576: pha.segment1 po_number
577: FROM rcv_transactions rt,
578: po_distributions_all pda,
579: po_line_locations_all plla,
580: po_lines_all pla,
581: po_headers_all pha
582: WHERE rt.transaction_id = p_rcv_txn_id
583: AND rt.po_distribution_id = pda.po_distribution_id
584: AND rt.po_line_location_id = plla.line_location_id