762:
763: SELECT rsh.receipt_num
764: INTO l_receipt_num
765: FROM rcv_shipment_headers rsh
766: , rcv_transactions rt
767: WHERE rt.transaction_id = InvRec.RCV_Transaction_Id
768: AND rsh.shipment_header_id = rt.shipment_header_id;
769:
770: end if;
1130:
1131: SELECT rsh.receipt_num
1132: INTO l_receipt_num
1133: FROM rcv_shipment_headers rsh
1134: , rcv_transactions rt
1135: WHERE rt.transaction_id = InvRec.RCV_Transaction_Id
1136: AND rsh.shipment_header_id = rt.shipment_header_id;
1137:
1138: end if;
1505:
1506: SELECT rsh.receipt_num
1507: INTO l_receipt_num
1508: FROM rcv_shipment_headers rsh
1509: , rcv_transactions rt
1510: WHERE rt.transaction_id = InvRec.RCV_Transaction_Id
1511: AND rsh.shipment_header_id = rt.shipment_header_id;
1512:
1513: end if;
1870:
1871: SELECT rsh.receipt_num
1872: INTO l_receipt_num
1873: FROM rcv_shipment_headers rsh
1874: , rcv_transactions rt
1875: WHERE rt.transaction_id = InvRec.RCV_Transaction_Id
1876: AND rsh.shipment_header_id = rt.shipment_header_id;
1877:
1878: end if;