DBA Data[Home] [Help]

APPS.EDW_DEL_STG dependencies on EDW_DIMENSIONS_MD_V

Line 24: edw_dimensions_md_v dim

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
28: select

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'