VIEW: APPS.PO_REL_LINE_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'