APPS.WIP_UTILITIES dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 128: from mtl_material_transactions_temp

124: -- only want to retrieve the assembly completion records
125: -- no label printing for return
126: cursor get_mmtt(x_txn_header_id number) is
127: select transaction_temp_id, rowid
128: from mtl_material_transactions_temp
129: where transaction_header_id = x_txn_header_id
130: and transaction_source_type_id = 5
131: and transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION;
132: cursor get_mti(x_txn_header_id number) is

Line 192: update mtl_material_transactions_temp

188: -- temp id not assigned to mmtt record (probably no lot/serial),
189: -- generate one
190: select mtl_material_transactions_s.nextval into l_temp_id
191: from sys.dual;
192: update mtl_material_transactions_temp
193: set transaction_temp_id = l_temp_id
194: where rowid = inv_rec.rowid;
195: else
196: l_temp_id := inv_rec.transaction_temp_id;

Line 355: mtl_material_transactions_temp mmtt

351: where transaction_temp_id in
352: ( select msnt.transaction_temp_id
353: from mtl_serial_numbers_temp msnt,
354: mtl_transaction_lots_temp mtlt,
355: mtl_material_transactions_temp mmtt
356: where mmtt.transaction_header_id = p_header_id
357: and mtlt.transaction_temp_id = mmtt.transaction_temp_id
358: and mtlt.serial_transaction_temp_id = msnt.transaction_temp_id
359: );

Line 366: mtl_material_transactions_temp mmtt

362: delete from mtl_serial_numbers_temp
363: where transaction_temp_id in
364: ( select msnt.transaction_temp_id
365: from mtl_serial_numbers_temp msnt,
366: mtl_material_transactions_temp mmtt
367: where mmtt.transaction_header_id = p_header_id
368: and mmtt.transaction_temp_id = msnt.transaction_temp_id
369: );
370:

Line 375: from mtl_material_transactions_temp mmtt,

371: -- Delete all lots
372: delete from mtl_transaction_lots_temp
373: where transaction_temp_id in
374: ( select mtlt.transaction_temp_id
375: from mtl_material_transactions_temp mmtt,
376: mtl_transaction_lots_temp mtlt
377: where mmtt.transaction_header_id = p_header_id
378: and mtlt.transaction_temp_id = mmtt.transaction_temp_id
379: );

Line 382: delete from mtl_material_transactions_temp

378: and mtlt.transaction_temp_id = mmtt.transaction_temp_id
379: );
380:
381: -- Finally, delete all records in mmtt for this transaction
382: delete from mtl_material_transactions_temp
383: where transaction_header_id = p_header_id;
384:
385: end delete_temp_records;
386:

Line 407: delete from mtl_material_transactions_temp

403: delete from mtl_transaction_lots_temp
404: where transaction_temp_id = p_temp_id;
405:
406: -- Finally, delete all records in mmtt for this transaction
407: delete from mtl_material_transactions_temp
408: where transaction_header_id = p_temp_id;
409: end delete_temp_records;
410:
411: procedure update_serial(p_serial_number in VARCHAR2,