[Home] [Help]
3009: CURSOR c_serial_numbers (c_delivery_detail_id NUMBER) IS
3010: SELECT fm_serial_number,
3011: to_serial_number,
3012: rownum, --haperf
3013: mtl_material_transactions_s.nextval seq_num,
3014: attribute_category,
3015: attribute1,
3016: attribute2,
3017: attribute3,
3249: ship_to_location_id,
3250: requisition_line_id,
3251: requisition_distribution_id,
3252: trx_uom,
3253: mtl_material_transactions_s.nextval trx_interface_id,
3254: shipment_number,
3255: expected_arrival_date,
3256: encumbrance_account,
3257: encumbrance_amount,
3382:
3383:
3384:
3385: CURSOR get_interface_id IS
3386: SELECT mtl_material_transactions_s.nextval
3387: FROM sys.dual;
3388:
3389:
3390: -- FP bug 4166635: cursor to look up trip's freight carrier
5194:
5195: END IF;
5196: -- bug 5736840
5197:
5198: SELECT mtl_material_transactions_s.nextval
5199: INTO l_transaction_header_id
5200: FROM sys.dual;
5201: --
5202: IF l_debug_on THEN
6351:
6352: -- COMMENT : This procedure updates the delivery details as interfaced to INV
6353: -- if they have been already processed by inventory system
6354: -- and the record has been entered into the table
6355: -- mtl_material_transactions.
6356: --
6357: --========================================================================
6358:
6359: procedure update_interfaced_details ( p_batch_id number , x_return_status out NOCOPY varchar2 ) is
6389: last_updated_by = fnd_global.user_id
6390:
6391: where (exists (
6392: SELECT mmt.picking_line_id
6393: FROM mtl_material_transactions mmt
6394: WHERE mmt.picking_line_id = dd.delivery_detail_id
6395: and transaction_source_type_id in ( 2,8,13,16 )
6396: and trx_source_line_id = dd.source_line_id
6397: )