APPS.EDW_DEL_STG dependencies on EDW_RELATIONS_MD_V

Line 49: from edw_relations_md_v ltc,edw_relations_md_v lstg,

45: and src_relation.elementid=lvl_map.sourcedataentity; */
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

Line 87: from edw_relations_md_v relation,

83:
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

Line 89: edw_relations_md_v lvl_relation

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;
93: