View: EDW_PVT_MAP_PROPERTIES_MD_V

Product:	BIS - Applications BIS
Description:	EDW_PVT_MAP_PROPERTIES_MD_V
Implementation/DBA Data:	APPS.EDW_PVT_MAP_PROPERTIES_MD_V

View Text

SELECT MAP.ELEMENTID MAPPING_ID
, MAP.SOURCEDATAENTITY PRIMARY_SOURCE
, MAP.TARGETDATAENTITY PRIMARY_TARGET
, LINE.TEXT TEXT
, LINE.SQLTYPE TEXT_TYPE
FROM CMPRELATIONMAPPING_V MAP
, CMPWBLINE_V LINE
WHERE LINE.LINEOWNER(+)=MAP.ELEMENTID

Columns