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 365: delete mtl_material_transactions_temp

361: WHEN OTHERS then
362: NULL;
363: END ;
364:
365: delete mtl_material_transactions_temp
366: where transaction_header_id = trx_header_id;
367: commit;
368:
369:

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

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

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

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

Line 411: mtl_material_transactions_temp mmtt

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

Line 420: mtl_material_transactions_temp mmtt

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

Line 460: from mtl_material_transactions_temp mmtt

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

Line 513: FROM mtl_material_transactions_temp mmtt,

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

Line 717: FROM mtl_material_transactions_temp mmtt,

713: 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*/
714: , NVL(mln.hold_date, NVL(mln.origination_date, mmtt.transaction_date) + hold_days) /* Jalaj Srivastava Bug 5527373*/
715: , mmtt.reason_id
716: /* INVCONV Anand Thiyagarajan 22-Oct-2004 End */
717: FROM mtl_material_transactions_temp mmtt,
718: mtl_system_items msi,
719: mtl_lot_numbers mln
720: WHERE mmtt.transaction_header_id = hdr_id AND mmtt.lot_number IS
721: NOT NULL AND mmtt.transaction_header_id IS NOT NULL

Line 735: FROM mtl_material_transactions_temp mmtt

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

Line 750: UPDATE mtl_material_transactions_temp

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

Line 773: FROM mtl_material_transactions_temp

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