View: PO_LINES_RELEASE_ITEMS_V

Product:	PO - Purchasing
Description:	10SC ONLY
Implementation/DBA Data:	APPS.PO_LINES_RELEASE_ITEMS_V

View Text

SELECT POL.LINE_NUM
, MIS.CONCATENATED_SEGMENTS
, POL.ITEM_REVISION
, POL.ITEM_DESCRIPTION
, POL.PO_HEADER_ID
, POL.PO_LINE_ID
, POL.ITEM_ID
, POL.COMMITTED_AMOUNT
, POL.QUANTITY_COMMITTED
, POL.LIST_PRICE_PER_UNIT
, POL.UNIT_MEAS_LOOKUP_CODE
, POL.MARKET_PRICE
, POL.UNIT_PRICE
, POL.NOT_TO_EXCEED_PRICE
, POL.ALLOW_PRICE_OVERRIDE_FLAG
, POL.NEGOTIATED_BY_PREPARER_FLAG
, POL.CAPITAL_EXPENSE_FLAG
, POL.NOTE_TO_VENDOR
, POL.VENDOR_PRODUCT_NUM
, POL.FROM_HEADER_ID
, POL.FROM_LINE_ID
, POL.LINE_TYPE_ID
, POL.PRICE_BREAK_LOOKUP_CODE
, POL.TAXABLE_FLAG
, MCA.CONCATENATED_SEGMENTS
, POL.OKE_CONTRACT_HEADER_ID
, POL.EXPIRATION_DATE
, POL.CLOSED_CODE
, POL.LINE_NUM|| MIS.CONCATENATED_SEGMENTS|| POL.ITEM_DESCRIPTION
, POL.ORG_ID
FROM MTL_SYSTEM_ITEMS_KFV MIS
, MTL_CATEGORIES_KFV MCA
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, PO_LINES POL
WHERE NVL(POL.CANCEL_FLAG
, 'N') = 'N'
AND POL.ITEM_ID = MIS.INVENTORY_ITEM_ID
AND MIS.ORGANIZATION_ID = FSP.INVENTORY_ORGANIZATION_ID
AND TRUNC(NVL(EXPIRATION_DATE
, SYSDATE+1)) >= TRUNC(SYSDATE)
AND NVL(POL.CLOSED_CODE
, 'OPEN') <> 'FINALLY CLOSED'
AND POL.CATEGORY_ID = MCA.CATEGORY_ID
AND POL.ITEM_ID IS NOT NULL
AND FSP.ORG_ID = POL.ORG_ID UNION ALL SELECT POL.LINE_NUM
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, POL.ITEM_DESCRIPTION
, POL.PO_HEADER_ID
, POL.PO_LINE_ID
, TO_NUMBER(NULL)
, POL.COMMITTED_AMOUNT
, POL.QUANTITY_COMMITTED
, POL.LIST_PRICE_PER_UNIT
, POL.UNIT_MEAS_LOOKUP_CODE
, POL.MARKET_PRICE
, POL.UNIT_PRICE
, POL.NOT_TO_EXCEED_PRICE
, POL.ALLOW_PRICE_OVERRIDE_FLAG
, POL.NEGOTIATED_BY_PREPARER_FLAG
, POL.CAPITAL_EXPENSE_FLAG
, POL.NOTE_TO_VENDOR
, POL.VENDOR_PRODUCT_NUM
, POL.FROM_HEADER_ID
, POL.FROM_LINE_ID
, POL.LINE_TYPE_ID
, POL.PRICE_BREAK_LOOKUP_CODE
, POL.TAXABLE_FLAG
, MCA.CONCATENATED_SEGMENTS
, POL.OKE_CONTRACT_HEADER_ID
, POL.EXPIRATION_DATE
, POL.CLOSED_CODE
, POL.LINE_NUM|| POL.ITEM_DESCRIPTION
, POL.ORG_ID
FROM MTL_CATEGORIES_KFV MCA
, PO_LINES POL
WHERE NVL(POL.CANCEL_FLAG
, 'N') = 'N'
AND TRUNC(NVL(EXPIRATION_DATE
, SYSDATE+1)) >= TRUNC(SYSDATE)
AND NVL(POL.CLOSED_CODE
, 'OPEN') <> 'FINALLY CLOSED'
AND POL.CATEGORY_ID = MCA.CATEGORY_ID
AND POL.ITEM_ID IS NULL

Columns