VIEW: APPS.EDW_PVT_MAP_COLUMNS_MD_V

Source

View Text - Preformatted

SELECT src_ru.cmprelationmapping Mapping_id, tgt_ru.elementid Target_usage_id, tgt_iu.elementid Target_column_usage_id, tgt_it.elementid Target_column_id, src_ru.elementid Source_usage_id, src_iu.elementid source_column_usage_id,src_it.elementid Source_column_id, src_ap.cmpwbfunctionusage func_usage_id FROM CMPWBITEMUSAGE_V SRC_IU,CMPITEM_V SRC_IT,CMPWBITEMUSAGE_V TGT_IU,CMPITEM_V TGT_IT,CMPWBRELATIONUSAGE_V SRC_RU,CMPWBRELATIONUSAGE_V TGT_RU,CMPWBACTUALPARAMETER_V SRC_AP,CMPWBACTUALPARAMETER_V TGT_AP WHERE src_ru.source=1 and tgt_ru.cmprelationmapping=src_ru.cmprelationmapping and src_iu.cmpwbrelationusage=src_ru.elementid and src_it.elementid=src_iu.cmpitem and tgt_iu.cmpwbrelationusage=tgt_ru.elementid and tgt_it.elementid=tgt_iu.cmpitem and src_ap.cmpwbitemusage=src_iu.elementid and tgt_ap.cmpwbitemusage=tgt_iu.elementid and tgt_ru.dmltype is not null and src_ap.cmpwbfunctionusage=tgt_ap.cmpwbfunctionusage WITH READ ONLY

View Text - HTML Formatted

SELECT SRC_RU.CMPRELATIONMAPPING MAPPING_ID
, TGT_RU.ELEMENTID TARGET_USAGE_ID
, TGT_IU.ELEMENTID TARGET_COLUMN_USAGE_ID
, TGT_IT.ELEMENTID TARGET_COLUMN_ID
, SRC_RU.ELEMENTID SOURCE_USAGE_ID
, SRC_IU.ELEMENTID SOURCE_COLUMN_USAGE_ID
, SRC_IT.ELEMENTID SOURCE_COLUMN_ID
, SRC_AP.CMPWBFUNCTIONUSAGE FUNC_USAGE_ID
FROM CMPWBITEMUSAGE_V SRC_IU
, CMPITEM_V SRC_IT
, CMPWBITEMUSAGE_V TGT_IU
, CMPITEM_V TGT_IT
, CMPWBRELATIONUSAGE_V SRC_RU
, CMPWBRELATIONUSAGE_V TGT_RU
, CMPWBACTUALPARAMETER_V SRC_AP
, CMPWBACTUALPARAMETER_V TGT_AP
WHERE SRC_RU.SOURCE=1
AND TGT_RU.CMPRELATIONMAPPING=SRC_RU.CMPRELATIONMAPPING
AND SRC_IU.CMPWBRELATIONUSAGE=SRC_RU.ELEMENTID
AND SRC_IT.ELEMENTID=SRC_IU.CMPITEM
AND TGT_IU.CMPWBRELATIONUSAGE=TGT_RU.ELEMENTID
AND TGT_IT.ELEMENTID=TGT_IU.CMPITEM
AND SRC_AP.CMPWBITEMUSAGE=SRC_IU.ELEMENTID
AND TGT_AP.CMPWBITEMUSAGE=TGT_IU.ELEMENTID
AND TGT_RU.DMLTYPE IS NOT NULL
AND SRC_AP.CMPWBFUNCTIONUSAGE=TGT_AP.CMPWBFUNCTIONUSAGE WITH READ ONLY