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.WMS_CONTAINER_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 3213: FROM mtl_material_transactions_temp mmtt, wms_user_task_type_attributes wutta

3209: END IF;
3210:
3211: --Bug 8693053
3212: SELECT count (*) into honor_case_pick_count
3213: FROM mtl_material_transactions_temp mmtt, wms_user_task_type_attributes wutta
3214: WHERE mmtt.standard_operation_id = wutta.user_task_type_id
3215: AND mmtt.organization_id = wutta.organization_id
3216: AND mmtt.transfer_lpn_id = l_old.lpn_id
3217: AND honor_case_pick_flag = 'Y';

Line 7201: l_input_param_rec mtl_material_transactions_temp%ROWTYPE;

7197: l_lot_control_code NUMBER;
7198:
7199: l_label_status VARCHAR2(300);
7200: l_input_param_tbl inv_label.input_parameter_rec_type;
7201: l_input_param_rec mtl_material_transactions_temp%ROWTYPE;
7202: l_counter NUMBER := 1; -- Counter variable initialized to 1
7203: l_qty NUMBER := 0;
7204: error_msg VARCHAR2(2000);
7205:

Line 7229: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt1, mtl_serial_numbers_temp msnt2

7225: NVL(msnt1.fm_serial_number, msnt2.fm_serial_number),
7226: NVL(msnt1.to_serial_number, msnt2.to_serial_number)
7227: , mmtt.secondary_transaction_quantity --INVCONV kkillams
7228: , mmtt.secondary_uom_code --INVCONV kkillams
7229: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt1, mtl_serial_numbers_temp msnt2
7230: WHERE mmtt.organization_id = p_organization_id
7231: AND mmtt.transaction_header_id = l_trx_header_id
7232: AND mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
7233: AND msnt1.transaction_temp_id(+) = mtlt.serial_transaction_temp_id

Line 7674: --If an invenotory prepack, insert trx in mtl_material_transactions_temp table

7670: mdebug('packing lpn='|| l_lpn_to_pack || ' with qty=' || l_primary_quantity || ' ' ||l_primary_uom);
7671: mdebug('with lot='|| l_lot_number || ' serials=' || l_serial_number_from || '-' || l_serial_number_to);
7672: END IF;
7673:
7674: --If an invenotory prepack, insert trx in mtl_material_transactions_temp table
7675: IF (p_source = 1) THEN
7676: -- if inventory prepack, trx header id required
7677: SELECT mtl_material_transactions_s.NEXTVAL
7678: INTO l_trx_header_id

Line 7950: DELETE FROM mtl_material_transactions_temp

7946: WHERE process_id = l_process_id;
7947:
7948: -- Delete lpn entries from temp table
7949: IF (p_container_item_id IS NULL) THEN
7950: DELETE FROM mtl_material_transactions_temp
7951: WHERE transaction_header_id = l_trx_header_id;
7952: END IF;
7953:
7954: -- End of API body

Line 8619: FROM mtl_material_transactions_temp

8615: -- lpn has been allocatied
8616: BEGIN
8617: SELECT WMS_CONTAINER_PVT.F
8618: INTO l_lpn_is_valid
8619: FROM mtl_material_transactions_temp
8620: WHERE organization_id = p_organization_id
8621: AND ( ALLOCATED_LPN_ID = lpn_rec.lpn_id OR
8622: lpn_id = lpn_rec.lpn_id OR
8623: content_lpn_id = lpn_rec.lpn_id OR

Line 8796: -- MTL_MATERIAL_TRANSACTIONS_TEMP using standard MMTT insert API

8792: FROM DUAL;
8793:
8794: FOR Nested_LPN_rec IN Nested_LPN_cur LOOP
8795: -- Insert an 'UNPACK' transaction of child LPN from parent LPN into
8796: -- MTL_MATERIAL_TRANSACTIONS_TEMP using standard MMTT insert API
8797: l_return_status := INV_TRX_UTIL_PUB.INSERT_LINE_TRX (
8798: p_trx_hdr_id => l_trx_hdr_id
8799: , p_item_id => -1
8800: , p_org_id => p_organization_id

Line 9008: -- MTL_MATERIAL_TRANSACTIONS_TEMP cannot use API because

9004: ELSE
9005: l_converted_qty := l_crnt_item_rec.quantity;
9006: END IF;
9007:
9008: -- MTL_MATERIAL_TRANSACTIONS_TEMP cannot use API because
9009: -- need to use sepecific transaction temp id
9010: INSERT INTO mtl_material_transactions_temp (
9011: transaction_header_id
9012: , transaction_temp_id

Line 9010: INSERT INTO mtl_material_transactions_temp (

9006: END IF;
9007:
9008: -- MTL_MATERIAL_TRANSACTIONS_TEMP cannot use API because
9009: -- need to use sepecific transaction temp id
9010: INSERT INTO mtl_material_transactions_temp (
9011: transaction_header_id
9012: , transaction_temp_id
9013: , process_flag
9014: , posting_flag --Added for the bug 15900513

Line 9201: -- MTL_MATERIAL_TRANSACTIONS_TEMP using standard MMTT insert API

9197:
9198: --Every nested lpn will need to be deconsolidated from the outermost lpn,
9199: FOR lpn_rec IN nested_lpn_cursor LOOP
9200: -- Insert an 'UNPACK' transaction of child LPN from parent LPN into
9201: -- MTL_MATERIAL_TRANSACTIONS_TEMP using standard MMTT insert API
9202: l_return_status := INV_TRX_UTIL_PUB.INSERT_LINE_TRX (
9203: p_trx_hdr_id => l_trx_hdr_id
9204: , p_item_id => -1
9205: , p_org_id => p_organization_id

Line 9495: FROM mtl_material_transactions_temp mmtt,

9491:
9492: IF l_lpn_context = 8 THEN
9493: SELECT msikfv.concatenated_segments
9494: INTO l_concatenated_segments
9495: FROM mtl_material_transactions_temp mmtt,
9496: mtl_system_items_b_kfv msikfv
9497: WHERE transfer_lpn_id IN
9498: (SELECT lpn_id
9499: FROM wms_license_plate_numbers