View: ICX_PO_LINES_ALL_CONTEXT_V

Product:	ICX - Oracle iProcurement
Description:	Purchase Order Index View
Implementation/DBA Data:	APPS.ICX_PO_LINES_ALL_CONTEXT_V

View Text

SELECT PL.PO_LINE_ID
, PL.ITEM_DESCRIPTION
FROM PO_LINES_ALL PL
, PO_HEADERS_ALL PH
WHERE PH.TYPE_LOOKUP_CODE IN ('BLANKET'
, 'QUOTATION')
AND PH.PO_HEADER_ID = PL.PO_HEADER_ID
AND NVL(PH.CANCEL_FLAG
, 'N') != 'Y'
AND NVL(PH.CLOSED_CODE
, 'OPEN') != 'FINALLY CLOSED'
AND (SYSDATE BETWEEN NVL(PH.START_DATE
, SYSDATE - 1)
AND NVL(PH.END_DATE
, SYSDATE + 1) OR TRUNC(SYSDATE) <= NVL(TRUNC(PH.START_DATE)
, TRUNC(SYSDATE)))

Columns