Identify table details of Custom Object In – Application Composer – Oracle Fusion
•Using : adf_extensible_table Table Approach *
| SNO | Table Detail | Column | Description |
| 1 | ADF_EXTENSIBLE_TABLE_USAGE | ENTITYDEF_FULLNAME | Custom Object Name |
| 2 | ADF_EXTENSIBLE_TABLE | TABLE_ID | Join with TABLE_ID of Table Mentioned in SNO 1 |
| 3 | ADF_EXTENSION_COLUMN_USAGE | TABLE_USAGE_ID | Join with TABLE_USAGE_ID of Table Mentioned in SNO 2 |
| 4 | ADF_EXTENSION_COLUMN | COLUMN_ID | Join with COLUMN_ID of Table Mentioned in SNO 3 |
select
aetu.ENTITYDEF_FULLNAME,
aet.TABLE_NAME,
aet.CONTEXT_COLUMN_NAME,
aetu.CONTEXT_COLUMN_VALUE,
aetu.TABLE_ID,
'SELECT * FROM ' || aet.TABLE_NAME || ' WHERE ' || aet.CONTEXT_COLUMN_NAME || '=''' || aetu.CONTEXT_COLUMN_VALUE || '''' "CustomQuery"
from
adf_extensible_table_usage aetu,
adf_extensible_table aet
WHERE
1 = 1
and aetu.ENTITYDEF_FULLNAME LIKE '%' || :P_CUSTOM_OBJECT_NAME || '%'
and aetu.table_id = aet.table_id
select
adf_table.table_id,
adf_table_usg.usage_id,
adf_table_usg.ENTITYDEF_FULLNAME ,
adf_col.COLUMN_ID,
adf_col.COLUMN_NAME,
adf_col.LOGICAL_DATATYPE,
adf_col.SANDBOX_NAME ,
adf_col_usage.ATTRIBUTE_NAME
FROM
adf_extensible_table adf_table,
adf_extensible_table_usage adf_table_usg,
ADF_EXTENSION_COLUMN adf_col ,
ADF_EXTENSION_COLUMN_USAGE adf_col_usage
where 1=1
and adf_table_usg.ENTITYDEF_FULLNAME like '%XXEmpDetail_c%'
and adf_table_usg.table_id = adf_table.table_id
and adf_table_usg.usage_id = adf_col_usage.TABLE_USAGE_ID
and adf_table.table_id = adf_col.table_id
and adf_col.column_id = adf_col_usage.column_id
Comments |0|
Category: Uncategorized