采购接收分录查询

----PO receiving accounting --------------
select distinct pha.segment1,
                rsh.receipt_num,
                rct.transaction_id,
                rct.quantity,
                rrs.entered_dr,
                rrs.entered_cr
  from apps.po_headers_all               pha,
       apps.po_releases_all              pra,
       apps.po_lines_all                 pla,
       apps.po_line_Locations_all        plla,
       apps.po_distributions_all         pda,
       apps.rcv_receiving_sub_ledger     rrs,
       apps.rcv_transactions             rct,
       apps.rcv_shipment_headers         rsh,
       apps.rcv_shipment_lines           rsl,
       apps.org_organization_definitions ood
 where 1 = 1
   and pha.po_header_id = pla.po_header_id
   and pla.po_line_id = plla.po_line_id
   and plla.po_release_id = pra.po_release_id(+)
   and plla.line_location_id = pda.line_location_id
   and to_char(pda.po_distribution_id) = rrs.reference3
   and rrs.rcv_transaction_id = rct.transaction_id
   and rct.shipment_header_id = rsh.shipment_header_id
   and rct.shipment_line_id = rsl.shipment_line_id
   and rct.organization_id = rct.organization_id
   and ood.set_of_books_id = rrs.set_of_books_id
   and pha.segment1 = '&po_number'
   and rsh.receipt_number = '&receipt_number'