VIEW: APPS.PO_LINES_RELEASE_ITEMS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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