[E-Bussiness Suite] Query PO tanpa Receipt Number by Date

Deskripsi
      Query untuk melisting PO yang tidak memiliki RECEIPT NUMBER dan difilter berdasarkan tanggal.

Howto
select distinct PRHA.segment1 as PO_NUMBER

from PO_HEADERS_ALL PRHA
       ,RCV_SHIPMENT_LINES RSL
 
where PRHA.CREATION_DATE >= TO_DATE('17/05/2013','DD/MM/YY')
AND PRHA.CREATION_DATE <= TO_DATE('22/05/2013','DD/MM/YY')
AND PRHA.po_header_id = RSL.po_header_id(+)
AND RSL.po_header_id is null

order by PRHA.segment1;



-- Update--
Jika ingin ditambahkan dengan vendor dan buyer maka querynya seperti ini :

select distinct PRHA.segment1 AS PO_NUMBER
        ,PV.VENDOR_NAME AS VENDOR
        ,HE.FULL_NAME AS BUYER

from PO_HEADERS_ALL PRHA
    ,RCV_SHIPMENT_LINES RSL
    ,PO_VENDORS PV
    ,HR_EMPLOYEES HE
 
where PRHA.CREATION_DATE >= TO_DATE('17/05/2013','DD/MM/YY')
AND PRHA.CREATION_DATE <= TO_DATE('22/05/2013','DD/MM/YY')
AND PRHA.po_header_id = RSL.po_header_id(+)
AND PRHA.VENDOR_ID = PV.VENDOR_ID
AND PRHA.AGENT_ID = HE.EMPLOYEE_ID
AND RSL.po_header_id is null

order by PRHA.segment1;