View: CST_XLA_WO_V

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.CST_XLA_WO_V

View Text

SELECT DECODE(CWO.INVENTORY_ITEM_ID
, NULL
, NULL
, (SELECT MSI.CONCATENATED_SEGMENTS
FROM MTL_SYSTEM_ITEMS_B_KFV MSI
WHERE INVENTORY_ITEM_ID = CWO.INVENTORY_ITEM_ID
AND ROWNUM <2)) ITEM_NAME
, POH.SEGMENT1 PO_NUMBER
, POV.VENDOR_NAME
, CWO.TRANSACTION_DATE
, CWO.DESTINATION_TYPE_CODE
, HAOU.NAME OPERATING_UNIT_NAME
, MTR.REASON_NAME
, CWO.COMMENTS
, CWO.OPERATING_UNIT_ID
, CWO.WRITE_OFF_ID
FROM CST_WRITE_OFFS CWO
, PO_VENDORS POV
, PO_HEADERS_ALL POH
, PO_DISTRIBUTIONS_ALL POD
, MTL_TRANSACTION_REASONS MTR
, HR_ALL_ORGANIZATION_UNITS HAOU
WHERE CWO.PO_DISTRIBUTION_ID = POD.PO_DISTRIBUTION_ID(+)
AND POD.PO_HEADER_ID = POH.PO_HEADER_ID(+)
AND CWO.VENDOR_ID = POV.VENDOR_ID(+)
AND MTR.REASON_ID (+)= CWO.REASON_ID
AND CWO.OPERATING_UNIT_ID = HAOU.ORGANIZATION_ID

Columns