APPS.EDW_NAEDW_PUSH dependencies on EDW_TABLES_MD_V

Line 49: edw_tables_md_v relation,

45: 'FK',
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,

Line 54: edw_tables_md_v parent

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

Line 73: edw_tables_md_v relation,

69: 'PK',
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

Line 93: edw_tables_md_v relation,

89: item.column_name,
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