VIEW: APPS.CST_XLA_WO_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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