[Home] [Help]
2520: CURSOR c_serial_numbers (c_delivery_detail_id NUMBER) IS
2521: SELECT fm_serial_number,
2522: to_serial_number,
2523: rownum, --haperf
2524: mtl_material_transactions_s.nextval seq_num,
2525: attribute_category,
2526: attribute1,
2527: attribute2,
2528: attribute3,
2640: ship_to_location_id,
2641: requisition_line_id,
2642: requisition_distribution_id,
2643: trx_uom,
2644: mtl_material_transactions_s.nextval trx_interface_id,
2645: shipment_number,
2646: expected_arrival_date,
2647: encumbrance_account,
2648: encumbrance_amount,
2772:
2773:
2774:
2775: CURSOR get_interface_id IS
2776: SELECT mtl_material_transactions_s.nextval
2777: FROM sys.dual;
2778:
2779:
2780: -- FP bug 4166635: cursor to look up trip's freight carrier
4216:
4217: END IF;
4218: -- bug 5736840
4219:
4220: SELECT mtl_material_transactions_s.nextval
4221: INTO l_transaction_header_id
4222: FROM sys.dual;
4223: --
4224: IF l_debug_on THEN
4832:
4833: -- COMMENT : This procedure updates the delivery details as interfaced to INV
4834: -- if they have been already processed by inventory system
4835: -- and the record has been entered into the table
4836: -- mtl_material_transactions.
4837: --
4838: --========================================================================
4839:
4840: procedure update_interfaced_details ( p_batch_id number , x_return_status out NOCOPY varchar2 ) is
4865: update wsh_delivery_details dd
4866: set inv_interfaced_flag = c_inv_int_full
4867: where (exists (
4868: SELECT mmt.picking_line_id
4869: FROM mtl_material_transactions mmt
4870: WHERE mmt.picking_line_id = dd.delivery_detail_id
4871: and transaction_source_type_id in ( 2,8,13,16 )
4872: and trx_source_line_id = dd.source_line_id
4873: )