[Home] [Help]
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
Name |
ITEM_NAME |
PO_NUMBER |
VENDOR_NAME |
TRANSACTION_DATE |
DESTINATION_TYPE_CODE |
OPERATING_UNIT_NAME |
REASON_NAME |
COMMENTS |
OPERATING_UNIT_ID |
WRITE_OFF_ID |