APPS.EDW_NAEDW_PUSH dependencies on EDW_UNIQUE_KEYS_MD_V

Line 53: edw_unique_keys_md_v pk,

49: edw_tables_md_v relation,
50: edw_pvt_columns_md_v item,
51: edw_foreign_keys_md_v fk,
52: edw_pvt_key_columns_md_v isu,
53: edw_unique_keys_md_v pk,
54: edw_tables_md_v parent
55: where
56: lvl.dim_id=p_dim_id
57: and relation.name=lvl.level_name||'_LTC'

Line 75: edw_unique_keys_md_v pk,

71: from
72: edw_levels_md_v lvl,
73: edw_tables_md_v relation,
74: edw_pvt_columns_md_v item,
75: edw_unique_keys_md_v pk,
76: edw_pvt_key_columns_md_v isu
77: where
78: lvl.dim_id=p_dim_id
79: and relation.name=lvl.level_name||'_LTC'

Line 1287: l_stmt:='select pk_item.column_name from edw_dimensions_md_v rel , edw_unique_keys_md_v pk, '||

1283: l_stmt varchar2(4000);
1284: TYPE CurTyp IS REF CURSOR;
1285: cv CurTyp;
1286: Begin
1287: l_stmt:='select pk_item.column_name from edw_dimensions_md_v rel , edw_unique_keys_md_v pk, '||
1288: 'edw_pvt_key_columns_md_v isu,edw_pvt_columns_md_v pk_item where rel.dim_name=:a '||
1289: 'and pk.entity_id=rel.dim_id and pk.primarykey=1 '||
1290: 'and isu.key_id=pk.key_id and pk_item.column_id=isu.column_id ';
1291: if g_debug then