APPS.EDW_TRUNC_STG dependencies on EDW_RELATIONS_MD_V

Line 50: from edw_relations_md_v ltc,edw_relations_md_v lstg,

46: and src_relation.elementid=lvl_map.sourcedataentity; */
47:
48: cursor dimm(p_dim_name varchar2) is
49: select lstg.relation_name table_name
50: from edw_relations_md_v ltc,edw_relations_md_v lstg,
51: edw_relationmapping_md_v map,edw_dimensions_md_v dim,
52: edw_levels_md_v lvl
53: where dim.dim_long_name=p_dim_name
54: and lvl.dim_id=dim.dim_id

Line 99: from edw_relations_md_v relation,

95: and map.targetdataentity=lvl_relation.elementid
96: and relation.elementid=map.sourcedataentity; */
97: cursor factt(p_fact_name varchar2) is
98: select relation.relation_name table_name
99: from edw_relations_md_v relation,
100: edw_relationmapping_md_v map,
101: edw_relations_md_v lvl_relation
102: where lvl_relation.relation_long_name=p_fact_name
103: and map.targetdataentity=lvl_relation.relation_id

Line 101: edw_relations_md_v lvl_relation

97: cursor factt(p_fact_name varchar2) is
98: select relation.relation_name table_name
99: from edw_relations_md_v relation,
100: edw_relationmapping_md_v map,
101: edw_relations_md_v lvl_relation
102: where lvl_relation.relation_long_name=p_fact_name
103: and map.targetdataentity=lvl_relation.relation_id
104: and relation.relation_id=map.sourcedataentity;
105: