193: l_vendor_id,
194: l_vendor_site_id,
195: l_ship_to_location_id
196: From rcv_transactions RCV,
197: rcv_shipment_lines RSL
198: Where RCV.transaction_id = l_othr_chrg_tab(1).rcv_txn_id
199: And RCV.shipment_line_id = RSL.shipment_line_id
200: And rownum < 2;
201:
995: G_product_category, --product_category
996: G_user_defined_fisc_class, --user_defined_fisc_class
997: X_COST_FACTOR_ID --cost_factor_id
998: FROM po_ap_receipt_match_v rcv,
999: rcv_shipment_lines rsl
1000: WHERE rcv.rcv_transaction_id = x_rcv_transaction_id
1001: AND rsl.shipment_line_id = rcv.rcv_shipment_line_id;
1002:
1003: EXCEPTION WHEN OTHERS THEN