SELECT DISTINCT
POHA.PO_HEADER_ID,
POHA.SEGMENT1,
POLA.LINE_NUM,
POLLA.NEED_BY_DATE,
POLLA.PROMISED_DATE
FROM
PO_LINE_LOCATIONS_ALL POLLA,
PO_LINES_ALL POLA,
PO_HEADERS_ALL POHA
WHERE
POHA.PO_HEADER_ID=POLA.PO_HEADER_ID
AND POLA.PO_LINE_ID=POLLA.PO_LINE_ID
--AND POHA.SEGMENT1 like 'XXXXX'
AND POHA.DOCUMENT_STATUS <>'CLOSED'
AND POHA.DOCUMENT_STATUS <>'CANCELED'
AND POHA.DOCUMENT_STATUS <>'CLOSED FOR RECEIVING'
AND POHA.DOCUMENT_STATUS <>'INCOMPLETE'
AND POHA.DOCUMENT_STATUS <>'CLOSED FOR INVOICING'
ORDER BY POHA.SEGMENT1
POHA.PO_HEADER_ID,
POHA.SEGMENT1,
POLA.LINE_NUM,
POLLA.NEED_BY_DATE,
POLLA.PROMISED_DATE
FROM
PO_LINE_LOCATIONS_ALL POLLA,
PO_LINES_ALL POLA,
PO_HEADERS_ALL POHA
WHERE
POHA.PO_HEADER_ID=POLA.PO_HEADER_ID
AND POLA.PO_LINE_ID=POLLA.PO_LINE_ID
--AND POHA.SEGMENT1 like 'XXXXX'
AND POHA.DOCUMENT_STATUS <>'CLOSED'
AND POHA.DOCUMENT_STATUS <>'CANCELED'
AND POHA.DOCUMENT_STATUS <>'CLOSED FOR RECEIVING'
AND POHA.DOCUMENT_STATUS <>'INCOMPLETE'
AND POHA.DOCUMENT_STATUS <>'CLOSED FOR INVOICING'
ORDER BY POHA.SEGMENT1
No comments:
Post a Comment