APPS.EDW_NAEDW_PUSH dependencies on EDW_PVT_KEY_COLUMNS_MD_V

Line 52: edw_pvt_key_columns_md_v isu,

48: edw_levels_md_v lvl,
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

Line 76: edw_pvt_key_columns_md_v isu

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'
80: and item.parent_object_id=relation.elementid

Line 1288: 'edw_pvt_key_columns_md_v isu,edw_pvt_columns_md_v pk_item where rel.dim_name=:a '||

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
1292: write_to_log_file_n('Going to execute '||l_stmt);