----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'
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'