Product: | PO - Purchasing |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.PO_REL_LINE_V |
SELECT L.LINE_NUM
, L.PO_HEADER_ID
, F.ITEM_NUMBER
, L.ITEM_REVISION
, L.ITEM_DESCRIPTION
, L.PO_LINE_ID
, L.ITEM_ID
, L.COMMITTED_AMOUNT
, L.QUANTITY_COMMITTED
, L.LIST_PRICE_PER_UNIT
, L.UNIT_MEAS_LOOKUP_CODE
, L.MARKET_PRICE
, L.UNIT_PRICE
, L.NOT_TO_EXCEED_PRICE
, L.ALLOW_PRICE_OVERRIDE_FLAG
, L.NEGOTIATED_BY_PREPARER_FLAG
, L.CAPITAL_EXPENSE_FLAG
, L.NOTE_TO_VENDOR
, L.VENDOR_PRODUCT_NUM
, L.FROM_HEADER_ID
, L.FROM_LINE_ID
, L.LINE_TYPE_ID
, L.PRICE_BREAK_LOOKUP_CODE
, L.TAXABLE_FLAG
, F.ORGANIZATION_ID
FROM PO_LINES L
, MTL_ITEM_FLEXFIELDS F
WHERE NVL(L.CANCEL_FLAG
, 'N') = 'N'
AND NVL(L.CLOSED_CODE
, 'OPEN') != 'FINALLY CLOSED'
AND L.ITEM_ID IS NOT NULL
AND F.INVENTORY_ITEM_ID = L.ITEM_ID UNION SELECT L.LINE_NUM
, L.PO_HEADER_ID
, ''
, L.ITEM_REVISION
, L.ITEM_DESCRIPTION
, L.PO_LINE_ID
, L.ITEM_ID
, L.COMMITTED_AMOUNT
, L.QUANTITY_COMMITTED
, L.LIST_PRICE_PER_UNIT
, L.UNIT_MEAS_LOOKUP_CODE
, L.MARKET_PRICE
, L.UNIT_PRICE
, L.NOT_TO_EXCEED_PRICE
, L.ALLOW_PRICE_OVERRIDE_FLAG
, L.NEGOTIATED_BY_PREPARER_FLAG
, L.CAPITAL_EXPENSE_FLAG
, L.NOTE_TO_VENDOR
, L.VENDOR_PRODUCT_NUM
, L.FROM_HEADER_ID
, L.FROM_LINE_ID
, L.LINE_TYPE_ID
, L.PRICE_BREAK_LOOKUP_CODE
, L.TAXABLE_FLAG
, -1
FROM PO_LINES L
WHERE NVL(L.CANCEL_FLAG
, 'N') = 'N'
AND NVL(L.CLOSED_CODE
, 'OPEN') != 'FINALLY CLOSED'