APPS.EDW_NAEDW_PUSH dependencies on EDW_LEVELS_MD_V

Line 22: from edw_levels_md_v

18: where dim_long_name=p_dim;
19:
20: cursor c00(p_dim_id number) is
21: select level_name||'_LTC'
22: from edw_levels_md_v
23: where dim_id=p_dim_id;
24:
25: cursor c1(p_dim_id number) is
26: select distinct

Line 30: edw_levels_md_v lvl_child,

26: select distinct
27: lvl_child.level_name||'_LTC',
28: lvl_parent.level_name||'_LTC'
29: from
30: edw_levels_md_v lvl_child,
31: edw_levels_md_v lvl_parent,
32: edw_pvt_level_relation_md_v lvl_rel,
33: edw_hierarchies_md_v hier
34: where

Line 31: edw_levels_md_v lvl_parent,

27: lvl_child.level_name||'_LTC',
28: lvl_parent.level_name||'_LTC'
29: from
30: edw_levels_md_v lvl_child,
31: edw_levels_md_v lvl_parent,
32: edw_pvt_level_relation_md_v lvl_rel,
33: edw_hierarchies_md_v hier
34: where
35: hier.dim_id=p_dim_id

Line 48: edw_levels_md_v lvl,

44: item.data_type,
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,

Line 72: edw_levels_md_v lvl,

68: item.data_type,
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

Line 96: relation.name in (select level_name||'_LTC' from edw_levels_md_v where dim_id=p_dim_id)

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');
99:
100: cursor c3_II(p_dim_id number,p_owner varchar2) is

Line 111: and all_tab.table_name in (select level_name||'_LTC' from edw_levels_md_v where dim_id=p_dim_id)

107: all_tab_columns all_tab,
108: all_tables tab
109: where
110: all_tab.nullable in ('N')
111: and all_tab.table_name in (select level_name||'_LTC' from edw_levels_md_v where dim_id=p_dim_id)
112: and tab.table_name=all_tab.table_name
113: and tab.owner=p_owner
114: and all_tab.owner= p_owner
115: