APPS.EDW_TRUNC_STG dependencies on EDW_DIMENSIONS_MD_V

Line 25: edw_dimensions_md_v dim

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

Line 51: edw_relationmapping_md_v map,edw_dimensions_md_v dim,

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
55: and ltc.relation_name=lvl.level_name||'_LTC'