DBA Data[Home] [Help]

APPS.BEN_DM_GEN_SELF_REF dependencies on BEN_DM_TABLES

Line 166: ben_dm_Tables bdt

162: select bcm.column_name ,
163: bcm.entity_result_column_name
164: from ben_dm_column_mappings bcm ,
165: ben_dm_hierarchies bdh ,
166: ben_dm_Tables bdt
167: where bcm.table_id = bdh.table_id
168: and bdh.hierarchy_type = 'H'
169: and (bcm.column_name = bdh.column_name or bcm.column_name = bdt.surrogate_pk_column_name)
170: and bdh.table_id = bdt.table_id

Line 290: ben_dm_Tables bdt

286: bdh.column_name,
287: bdt.table_name,
288: bdt.surrogate_pk_column_name
289: from ben_dm_hierarchies bdh ,
290: ben_dm_Tables bdt
291: where bdh.hierarchy_type = 'H'
292: and bdh.table_id = bdt.table_id
293: order by bdh.table_id,bdh.column_name
294: ;