[E-Bussiness Suite] Query PR tanpa PO by Date

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

Howto

select distinct prha.creation_date,PRHA.segment1
from po_requisition_headers_all PRHA
       ,po_requisition_lines_all PRLA
    
where prha.creation_date >= to_date('17/5/2013','dd/mm/yyyy')
and  prha.creation_date <= to_date('21/5/2013','dd/mm/yyyy')
and prha.requisition_header_id = PRLA.requisition_header_id
and PRLA.line_location_id is null;