eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDW_MAPPING_COLLECT dependencies on EDW_PVT_COLUMNS_MD_V

Line 4937: edw_pvt_columns_md_v fact_item

4933: cursor c2(p_fact_id number, p_is_name varchar2) is
4934: select fact_item.column_name from
4935: edw_attribute_sets_md_v sis,
4936: edw_attribute_set_columns_md_v isu,
4937: edw_pvt_columns_md_v fact_item
4938: where sis.entity_id=p_fact_id
4939: and sis.attribute_group_name=p_is_name
4940: and isu.attribute_group_id=sis.attribute_group_id
4941: and fact_item.column_id=isu.column_id

Line 5007: edw_pvt_columns_md_v fact_item

5003: cursor c2(p_fact_id number, p_is_name varchar2) is
5004: select fact_item.column_name from
5005: edw_attribute_sets_md_v sis,
5006: edw_attribute_set_columns_md_v isu,
5007: edw_pvt_columns_md_v fact_item
5008: where sis.entity_id=p_fact_id
5009: and sis.attribute_group_name=p_is_name
5010: and isu.attribute_group_id=sis.attribute_group_id
5011: and fact_item.column_id=isu.column_id

Line 14355: edw_pvt_columns_md_v pk_col,

14351: fk_col.column_name
14352: from
14353: edw_level_relations_md_v lvl_rel,
14354: edw_pvt_key_columns_md_v pk_key,
14355: edw_pvt_columns_md_v pk_col,
14356: edw_pvt_key_columns_md_v fk_key,
14357: edw_pvt_columns_md_v fk_col
14358: where
14359: lvl_rel.PARENT_LVLTBL_ID=p_parent_id

Line 14357: edw_pvt_columns_md_v fk_col

14353: edw_level_relations_md_v lvl_rel,
14354: edw_pvt_key_columns_md_v pk_key,
14355: edw_pvt_columns_md_v pk_col,
14356: edw_pvt_key_columns_md_v fk_key,
14357: edw_pvt_columns_md_v fk_col
14358: where
14359: lvl_rel.PARENT_LVLTBL_ID=p_parent_id
14360: and lvl_rel.CHILD_LVLTBL_ID=p_child_id
14361: and pk_key.key_id=lvl_rel.uk_id

Line 14397: 'edw_pvt_columns_md_v pk_col, '||

14393: 'fk_col.column_name '||
14394: 'from '||
14395: 'edw_level_relations_md_v lvl_rel, '||
14396: 'edw_pvt_key_columns_md_v pk_key, '||
14397: 'edw_pvt_columns_md_v pk_col, '||
14398: 'edw_pvt_key_columns_md_v fk_key, '||
14399: 'edw_pvt_columns_md_v fk_col '||
14400: 'where '||
14401: 'lvl_rel.PARENT_LVLTBL_ID=p_parent_id '||

Line 14399: 'edw_pvt_columns_md_v fk_col '||

14395: 'edw_level_relations_md_v lvl_rel, '||
14396: 'edw_pvt_key_columns_md_v pk_key, '||
14397: 'edw_pvt_columns_md_v pk_col, '||
14398: 'edw_pvt_key_columns_md_v fk_key, '||
14399: 'edw_pvt_columns_md_v fk_col '||
14400: 'where '||
14401: 'lvl_rel.PARENT_LVLTBL_ID=p_parent_id '||
14402: 'and lvl_rel.CHILD_LVLTBL_ID=p_child_id '||
14403: 'and pk_key.key_id=lvl_rel.uk_id '||