773:
774: IF ln_trans_source_type_id = 1 THEN
775: SELECT PHA.segment1
776: INTO lc_po_or_so_number
777: FROM po_headers_all PHA
778: WHERE PHA.po_header_id = ln_trans_source_id;
779: ELSIF ln_trans_source_type_id IN (2, 8, 12) THEN
780: SELECT OOH.order_number -- Changed to refer to OE tables for Bug Number 8834843
781: INTO lc_po_or_so_number