APPS.WIP_TRANSACTIONS_PKG dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 227: from mtl_material_transactions_temp mmtt,

223: oc_alloc_recs wip_move_alloc_cleanup.WIP_MOVE_TXN_ALLOCATIONS_REC;
224:
225: cursor overcpl_move_id is
226: select wmti.transaction_id
227: from mtl_material_transactions_temp mmtt,
228: wip_move_txn_interface wmti
229: where mmtt.TRANSACTION_HEADER_ID = mtl_header_id
230: and mmtt.overcompletion_transaction_id is not null
231: and wmti.overcompletion_transaction_id = mmtt.overcompletion_transaction_id;

Line 390: delete mtl_material_transactions_temp

386:
387: delete mtl_transaction_lots_temp
388: where group_header_id = mtl_header_id;
389:
390: delete mtl_material_transactions_temp
391: where transaction_header_id = mtl_header_id;
392:
393: end if;
394:

Line 404: from mtl_material_transactions_temp

400: ccount NUMBER;
401: BEGIN
402: select count(*)
403: into ccount
404: from mtl_material_transactions_temp
405: where transaction_header_id = mtl_hdr_id;
406:
407: RETURN ccount;
408:

Line 416: from mtl_material_transactions_temp

412: begin
413: delete mtl_transaction_lots_temp
414: where transaction_temp_id in
415: (select transaction_temp_id
416: from mtl_material_transactions_temp
417: where transaction_header_id=txn_hdr_id
418: and transaction_mode=1);
419: delete mtl_serial_numbers_temp where
420: transaction_temp_id in

Line 422: from mtl_material_transactions_temp

418: and transaction_mode=1);
419: delete mtl_serial_numbers_temp where
420: transaction_temp_id in
421: (select transaction_temp_id
422: from mtl_material_transactions_temp
423: where transaction_header_id=txn_hdr_id
424: and transaction_mode=1);
425: delete mtl_material_transactions_temp
426: where transaction_header_id=txn_hdr_id

Line 425: delete mtl_material_transactions_temp

421: (select transaction_temp_id
422: from mtl_material_transactions_temp
423: where transaction_header_id=txn_hdr_id
424: and transaction_mode=1);
425: delete mtl_material_transactions_temp
426: where transaction_header_id=txn_hdr_id
427: and transaction_mode=1;
428: commit;
429: end cln_up_MMTT ;