eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INVTTMTX dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 135: FROM mtl_material_transactions_temp m

131: EXCEPTION WHEN NO_DATA_FOUND then
132: BEGIN
133: SELECT shipment_number
134: INTO found_row
135: FROM mtl_material_transactions_temp m
136: WHERE m.shipment_number = vall
137: AND m.transaction_type_id = INV_GLOBALS.G_SOURCETYPE_INVENTORY
138: AND m.transaction_action_id= INV_GLOBALS.G_ACTION_INTRANSITSHIPMENT
139: AND ROWNUM = 1 ;

Line 362: delete mtl_material_transactions_temp

358: WHEN OTHERS then
359: NULL;
360: END ;
361:
362: delete mtl_material_transactions_temp
363: where transaction_header_id = trx_header_id;
364: commit;
365:
366:

Line 382: --l_transaction_Action_id mtl_material_transactions_temp.transaction_action_id%TYPE;

378:
379: /* Jalaj Srivastava Bug 5527373
380: varibales no longer needed are commented */
381:
382: --l_transaction_Action_id mtl_material_transactions_temp.transaction_action_id%TYPE;
383: --l_transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE;
384: --l_origination_type mtl_lot_numbers.origination_type%TYPE;
385: --l_lot_rec_type mtl_lot_numbers%ROWTYPE;
386: --l_organization_id mtl_lot_numbers.organization_id%TYPE;

Line 383: --l_transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE;

379: /* Jalaj Srivastava Bug 5527373
380: varibales no longer needed are commented */
381:
382: --l_transaction_Action_id mtl_material_transactions_temp.transaction_action_id%TYPE;
383: --l_transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE;
384: --l_origination_type mtl_lot_numbers.origination_type%TYPE;
385: --l_lot_rec_type mtl_lot_numbers%ROWTYPE;
386: --l_organization_id mtl_lot_numbers.organization_id%TYPE;
387: --l_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE;

Line 408: mtl_material_transactions_temp mmtt

404: DELETE FROM mtl_transaction_lots_temp
405: WHERE group_header_id = hdr_id AND
406: transaction_temp_id NOT IN
407: (SELECT mmtt.transaction_temp_id FROM
408: mtl_material_transactions_temp mmtt
409: WHERE mmtt.transaction_header_id = hdr_id AND mmtt.transaction_temp_id
410: IS NOT NULL AND mmtt.transaction_header_id IS NOT NULL);
411:
412:

Line 417: mtl_material_transactions_temp mmtt

413: DELETE FROM mtl_serial_numbers_temp
414: WHERE group_header_id = hdr_id AND
415: transaction_temp_id NOT IN
416: (SELECT mmtt.transaction_temp_id FROM
417: mtl_material_transactions_temp mmtt
418: WHERE mmtt.transaction_header_id = hdr_id AND mmtt.transaction_temp_id
419: IS NOT NULL) AND transaction_temp_id NOT IN
420: ( SELECT mtlt.serial_transaction_temp_id
421: FROM mtl_transaction_lots_temp mtlt

Line 457: from mtl_material_transactions_temp mmtt

453: mmtt.transaction_date, mmtt.lot_expiration_date
454: into l_transaction_Action_id, l_transaction_source_type_id,
455: l_organization_id, l_inventory_item_id,
456: l_transaction_date, l_expiration_date
457: from mtl_material_transactions_temp mmtt
458: where mmtt.transaction_header_id = hdr_id
459: AND mmtt.lot_number IS NOT NULL
460: AND mmtt.transaction_header_id IS NOT NULL
461: AND rownum = 1;

Line 510: FROM mtl_material_transactions_temp mmtt,

506: mmtt.program_id, mmtt.program_update_date,
507: mmtt.transaction_quantity, mmtt.primary_quantity, mmtt.lot_number,
508: mmtt.lot_expiration_date, mmtt.transaction_header_id,
509: mmtt.transaction_temp_id, msi.default_lot_status_id
510: FROM mtl_material_transactions_temp mmtt,
511: mtl_system_items msi
512: WHERE mmtt.transaction_header_id = hdr_id AND mmtt.lot_number IS
513: NOT NULL AND mmtt.transaction_header_id IS NOT NULL
514: AND msi.inventory_item_id = mmtt.inventory_item_id

Line 714: FROM mtl_material_transactions_temp mmtt,

710: decode(msi.shelf_life_code,2,NVL(mln.origination_date, mmtt.transaction_date) + shelf_life_days,null)) + msi.expiration_action_interval)) /* Jalaj Srivastava Bug 5527373*/
711: , NVL(mln.hold_date, NVL(mln.origination_date, mmtt.transaction_date) + hold_days) /* Jalaj Srivastava Bug 5527373*/
712: , mmtt.reason_id
713: /* INVCONV Anand Thiyagarajan 22-Oct-2004 End */
714: FROM mtl_material_transactions_temp mmtt,
715: mtl_system_items msi,
716: mtl_lot_numbers mln
717: WHERE mmtt.transaction_header_id = hdr_id AND mmtt.lot_number IS
718: NOT NULL AND mmtt.transaction_header_id IS NOT NULL

Line 732: FROM mtl_material_transactions_temp mmtt

728: transaction_quantity = -1 * transaction_quantity ,
729: secondary_quantity = -1 * secondary_quantity /* INVCONV Anand Thiyagarajan 22-Oct-2004*/
730: WHERE transaction_temp_id in
731: (select mmtt.transaction_temp_id
732: FROM mtl_material_transactions_temp mmtt
733: WHERE mmtt.transaction_header_id = hdr_id AND mmtt.lot_number IS
734: NOT NULL AND mmtt.transaction_header_id IS NOT NULL)
735: AND ( primary_quantity < 0 OR transaction_quantity < 0 OR secondary_quantity < 0); /* INVCONV Anand Thiyagarajan 22-Oct-2004 */
736:

Line 747: UPDATE mtl_material_transactions_temp

743: BEGIN
744: if ( ((hdr_id IS NULL) OR (hdr_id < 0 )) AND (completed > 0) ) then
745: completed := 3;
746: elsif ( completed > 0 ) then
747: UPDATE mtl_material_transactions_temp
748: SET lot_number = NULL, lot_expiration_date = NULL
749: WHERE transaction_header_id = hdr_id AND process_flag = 'Y';
750: completed := 3;
751: end if;

Line 770: FROM mtl_material_transactions_temp

766: WHERE current_status = 6
767: AND group_mark_id = -1
768: AND (MSN.inventory_item_id, MSN.current_organization_id) in
769: (select inventory_item_id,ORGANIZATION_ID
770: FROM mtl_material_transactions_temp
771: WHERE transaction_header_id = hdr_id);
772: --2101601
773: completed := 4 ;
774: end if;