APPS.EDW_DEL_STG dependencies on EDW_RELATIONMAPPING_MD_V

Line 23: from edw_relationmapping_md_v dim_map,

19:
20: cursor alldimm is
21: select
22: dim.dim_long_name dim_name
23: from edw_relationmapping_md_v dim_map,
24: edw_dimensions_md_v dim
25: where dim_map.targetdataentity=dim.dim_id;
26:
27: /* cursor dimm(p_dim_name varchar2) is

Line 50: edw_relationmapping_md_v map,edw_dimensions_md_v dim,

46:
47: cursor dimm(p_dim_name varchar2) is
48: select lstg.relation_name table_name
49: from edw_relations_md_v ltc,edw_relations_md_v lstg,
50: edw_relationmapping_md_v map,edw_dimensions_md_v dim,
51: edw_levels_md_v lvl
52: where dim.dim_long_name=p_dim_name
53: and lvl.dim_id=dim.dim_id
54: and ltc.relation_name=lvl.level_name||'_LTC'

Line 66: from edw_relationmapping_md_v map,edw_facts_md_v cube

62: where cube.elementid = map.targetdataentity; */
63:
64: /**cursor allfactt is
65: select cube.fact_longname fact_name
66: from edw_relationmapping_md_v map,edw_facts_md_v cube
67: where cube.fact_id = map.targetdataentity;**/
68:
69: ----fix bug 2109920.Exclude derived facts from the fact list---
70: cursor allfactt is

Line 72: from edw_relationmapping_md_v map1,edw_facts_md_v cube1

68:
69: ----fix bug 2109920.Exclude derived facts from the fact list---
70: cursor allfactt is
71: select cube1.fact_longname fact_name
72: from edw_relationmapping_md_v map1,edw_facts_md_v cube1
73: where cube1.fact_id = map1.targetdataentity
74: and cube1.fact_longname not in
75: (select distinct cube.fact_longname
76: from

Line 79: edw_relationmapping_md_v map where

75: (select distinct cube.fact_longname
76: from
77: edw_facts_md_v cube,
78: edw_facts_md_v cube_src,
79: edw_relationmapping_md_v map where
80: map.targetdataentity=cube.fact_id
81: and map.sourcedataentity=cube_src.fact_id);
82:
83:

Line 88: edw_relationmapping_md_v map,

84:
85: cursor factt(p_fact_name varchar2) is
86: select relation.relation_name table_name
87: from edw_relations_md_v relation,
88: edw_relationmapping_md_v map,
89: edw_relations_md_v lvl_relation
90: where lvl_relation.relation_long_name=p_fact_name
91: and map.targetdataentity=lvl_relation.relation_id
92: and relation.relation_id=map.sourcedataentity;