[Home] [Help]
View: EDW_PVT_MAP_COLUMNS_MD_V
View Text
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
Columns
Name |
MAPPING_ID |
TARGET_USAGE_ID |
TARGET_COLUMN_USAGE_ID |
TARGET_COLUMN_ID |
SOURCE_USAGE_ID |
SOURCE_COLUMN_USAGE_ID |
SOURCE_COLUMN_ID |
FUNC_USAGE_ID |