APPS.EDW_NAEDW_PUSH dependencies on EDW_PVT_COLUMNS_MD_V

Line 50: edw_pvt_columns_md_v item,

46: parent.name
47: from
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

Line 74: edw_pvt_columns_md_v item,

70: null
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

Line 94: edw_pvt_columns_md_v item

90: item.length,
91: item.data_type
92: from
93: edw_tables_md_v relation,
94: edw_pvt_columns_md_v item
95: where
96: relation.name in (select level_name||'_LTC' from edw_levels_md_v where dim_id=p_dim_id)
97: and item.parent_object_id=relation.elementid
98: and item.column_name in ('NAME');

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);