Sunday, 16 December 2018

Query for the Open Purchase Orders (PO's) line location level details in Oracle Fusion

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

No comments:

Post a Comment