VIEW: APPS.CST_XLA_REP_ITEM_REF_V

Source

View Text - Preformatted

SELECT WRI.WIP_ENTITY_ID,WRI.LINE_ID,WRI.WIP_SUPPLY_TYPE,WRI.ATTRIBUTE_CATEGORY,WRI.ATTRIBUTE1,WRI.ATTRIBUTE2,WRI.ATTRIBUTE3,WRI.ATTRIBUTE4,WRI.ATTRIBUTE5,WRI.ATTRIBUTE6,WRI.ATTRIBUTE7,WRI.ATTRIBUTE8,WRI.ATTRIBUTE9,WRI.ATTRIBUTE10,WRI.ATTRIBUTE11,WRI.ATTRIBUTE12,WRI.ATTRIBUTE13,WRI.ATTRIBUTE14,WRI.ATTRIBUTE15,WRI.CLASS_CODE,WAC.CLASS_TYPE,WAC.DESCRIPTION,WAC.COMPLETION_COST_SOURCE,WAC.COST_TYPE_ID,CCT.COST_TYPE,WAC.SYSTEM_OPTION_ID,WAC.ATTRIBUTE_CATEGORY,WAC.ATTRIBUTE1,WAC.ATTRIBUTE2,WAC.ATTRIBUTE3,WAC.ATTRIBUTE4,WAC.ATTRIBUTE5,WAC.ATTRIBUTE6,WAC.ATTRIBUTE7,WAC.ATTRIBUTE8,WAC.ATTRIBUTE9,WAC.ATTRIBUTE10,WAC.ATTRIBUTE11,WAC.ATTRIBUTE12,WAC.ATTRIBUTE13,WAC.ATTRIBUTE14,WAC.ATTRIBUTE15,WAC.BRIDGING_ACCOUNT FROM WIP_REPETITIVE_ITEMS WRI,WIP_ACCOUNTING_CLASSES WAC,CST_COST_TYPES CCT WHERE wri.class_code = wac.class_code AND wri.organization_id = wac.organization_id AND wac.cost_type_id = cct.cost_type_id (+)

View Text - HTML Formatted

SELECT WRI.WIP_ENTITY_ID
, WRI.LINE_ID
, WRI.WIP_SUPPLY_TYPE
, WRI.ATTRIBUTE_CATEGORY
, WRI.ATTRIBUTE1
, WRI.ATTRIBUTE2
, WRI.ATTRIBUTE3
, WRI.ATTRIBUTE4
, WRI.ATTRIBUTE5
, WRI.ATTRIBUTE6
, WRI.ATTRIBUTE7
, WRI.ATTRIBUTE8
, WRI.ATTRIBUTE9
, WRI.ATTRIBUTE10
, WRI.ATTRIBUTE11
, WRI.ATTRIBUTE12
, WRI.ATTRIBUTE13
, WRI.ATTRIBUTE14
, WRI.ATTRIBUTE15
, WRI.CLASS_CODE
, WAC.CLASS_TYPE
, WAC.DESCRIPTION
, WAC.COMPLETION_COST_SOURCE
, WAC.COST_TYPE_ID
, CCT.COST_TYPE
, WAC.SYSTEM_OPTION_ID
, WAC.ATTRIBUTE_CATEGORY
, WAC.ATTRIBUTE1
, WAC.ATTRIBUTE2
, WAC.ATTRIBUTE3
, WAC.ATTRIBUTE4
, WAC.ATTRIBUTE5
, WAC.ATTRIBUTE6
, WAC.ATTRIBUTE7
, WAC.ATTRIBUTE8
, WAC.ATTRIBUTE9
, WAC.ATTRIBUTE10
, WAC.ATTRIBUTE11
, WAC.ATTRIBUTE12
, WAC.ATTRIBUTE13
, WAC.ATTRIBUTE14
, WAC.ATTRIBUTE15
, WAC.BRIDGING_ACCOUNT
FROM WIP_REPETITIVE_ITEMS WRI
, WIP_ACCOUNTING_CLASSES WAC
, CST_COST_TYPES CCT
WHERE WRI.CLASS_CODE = WAC.CLASS_CODE
AND WRI.ORGANIZATION_ID = WAC.ORGANIZATION_ID
AND WAC.COST_TYPE_ID = CCT.COST_TYPE_ID (+)