[Home] [Help]
3493: (fnd_file.log,'PO Receipt found: transaction ID = '||to_char(transaction_row.transaction_id));
3494: END IF;
3495:
3496: -- The pointers in the inventory transaction link to the receipt as follows:
3497: -- DOC_ID is the SHIPMENT_HEADER_ID in rcv_shipment_headers
3498: -- LINE_ID is the TRANSACTION_ID in rcv_transactions
3499:
3500: -- From the row in rcv_transactions the po_unit_price (expressed in price_um so
3501: -- we need to convert it to item_um) is the source of the cost. There is also the
3594: target_orgn_id,source_orgn_id, source_le_id, target_le_id, l_shipped_date
3595: FROM
3596: rcv_transactions t,
3597: mtl_material_transactions mmt,
3598: rcv_shipment_headers r,
3599: rcv_shipment_lines rsl,
3600: po_headers_all poh,
3601: hr_organization_information hoi1,
3602: hr_organization_information hoi2
3634: target_orgn_id,source_orgn_id, source_le_id, target_le_id, l_shipped_date
3635: FROM
3636: rcv_transactions t,
3637: mtl_material_transactions mmt,
3638: rcv_shipment_headers r,
3639: rcv_shipment_lines rsl,
3640: po_headers_all poh,
3641: hr_organization_information hoi1,
3642: hr_organization_information hoi2