VIEW: APPS.ICX_PO_LINES_ALL_CONTEXT_V

Source

View Text - Preformatted

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)))

View Text - HTML Formatted

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)))