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

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

Howto
select distinct prha.creation_date,PRHA.segment1, poh.segment1
from po_requisition_headers_all PRHA
       ,po_requisition_lines_all PRLA
       ,po_line_locations_all PLLA
       ,po_headers_all poh
       ,po_lines_all pol
 
where prha.creation_date >= to_date('1/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 = PLLA.line_location_id
and poh.po_header_id = pol.po_header_id
and pol.po_line_id = plla.po_line_id;