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_TASK_LOAD dependencies on MTL_ALLOCATIONS_GTMP

Line 371: FROM mtl_allocations_gtmp

367: serial_number,
368: SUM(transaction_quantity) transaction_quantity,
369: SUM(primary_quantity) primary_quantity,
370: SUM(secondary_quantity) secondary_quantity
371: FROM mtl_allocations_gtmp
372: WHERE (lot_number IS NOT NULL OR serial_number IS NOT NULL)
373: GROUP BY transaction_temp_id, lot_number, serial_number, secondary_quantity
374: ORDER BY transaction_temp_id, lot_number, serial_number;
375:

Line 2694: FROM mtl_allocations_gtmp

2690: ,transaction_quantity
2691: ,primary_quantity
2692: ,suggested_quantity
2693: ,secondary_quantity
2694: FROM mtl_allocations_gtmp
2695: ORDER BY
2696: transaction_temp_id
2697: ,lot_number;
2698:

Line 3053: UPDATE mtl_allocations_gtmp

3049: THEN
3050: L_progress := '410';
3051: mydebug('l_progress: ' || l_progress );
3052: -- update all serial records with the serial_transaction_temp_id to be populated
3053: UPDATE mtl_allocations_gtmp
3054: SET child_transaction_temp_id = l_serial_transaction_temp_id
3055: WHERE lot_number = rec_confirmed_lots_serials.lot_number
3056: AND transaction_temp_id = rec_confirmed_lots_serials.transaction_temp_id ;
3057: IF SQL%NOTFOUND THEN

Line 3167: FROM mtl_allocations_gtmp

3163: ,lot_number
3164: ,serial_number
3165: ,transaction_quantity
3166: ,primary_quantity
3167: FROM mtl_allocations_gtmp
3168: WHERE NVL(lot_number,'@@') = nvl(p_serial_lot_number,'@@')
3169: ORDER BY
3170: transaction_temp_id
3171: --,nvl(lot_number,'@@')

Line 3266: FROM mtl_allocations_gtmp

3262: , last_updated_by = p_user_id
3263: WHERE transaction_temp_id = l_o_msnt_transaction_temp_id
3264: AND fm_serial_number IN
3265: (SELECT serial_number
3266: FROM mtl_allocations_gtmp
3267: WHERE NVL(lot_number,'@@') = nvl(p_serial_lot_number,'@@'));
3268:
3269: IF SQL%NOTFOUND THEN
3270: mydebug('msnt not updateed..');

Line 3284: FROM mtl_allocations_gtmp

3280: AND inventory_item_id = p_inventory_item_id
3281: --AND group_mark_id IS NULL
3282: AND serial_number IN
3283: (SELECT serial_number
3284: FROM mtl_allocations_gtmp
3285: WHERE NVL(lot_number,'@@') = nvl(p_serial_lot_number,'@@'));
3286:
3287: IF SQL%NOTFOUND THEN
3288: RAISE fnd_api.G_EXC_ERROR;

Line 3898: ELSE -- confirmed_serials are no null so get the serials from mtl-allocations_gtmp table

3894: mydebug('x_return_status : ' || x_return_status);
3895: RAISE fnd_api.G_EXC_ERROR;
3896: END IF;
3897:
3898: ELSE -- confirmed_serials are no null so get the serials from mtl-allocations_gtmp table
3899:
3900: INSERT INTO mtl_serial_numbers_temp
3901: (transaction_temp_id
3902: ,last_update_date

Line 4062: FROM mtl_allocations_gtmp

4058: AND NVL(lot_number,'@@') = nvl(p_serial_lot_number,'@@')
4059: --AND group_mark_id IS NULL
4060: AND msn.serial_number IN
4061: (SELECT serial_number
4062: FROM mtl_allocations_gtmp
4063: WHERE NVL(lot_number,'@@') = nvl(p_serial_lot_number,'@@'))
4064: );
4065: IF SQL%NOTFOUND THEN --- MSN record not found)
4066: RAISE fnd_api.G_EXC_ERROR;

Line 4175: FROM mtl_allocations_gtmp

4171: AND NVL(lot_number,'@@') = nvl(p_serial_lot_number,'@@')
4172: --AND group_mark_id IS NULL
4173: AND msn.serial_number IN
4174: (SELECT serial_number
4175: FROM mtl_allocations_gtmp
4176: WHERE NVL(lot_number,'@@') = nvl(p_serial_lot_number,'@@'));
4177:
4178: IF SQL%NOTFOUND THEN
4179: fnd_message.set_name('WMS', 'WMS_ERROR_MARKING_SERIAL'); --NEWMSG

Line 4508: DELETE mtl_allocations_gtmp ;

4504: -- update one of the MMTTs(min temp_id) from each group and delete rest from that group
4505: l_progress := 500;
4506: IF l_debug = 1 THEN mydebug('l_progress = ' || l_progress); END IF;
4507:
4508: DELETE mtl_allocations_gtmp ;
4509: IF SQL%NOTFOUND THEN
4510: null;
4511: END IF;
4512:

Line 4539: INTO mtl_allocations_gtmp

4535: -- MMTTs should be deleted that belong to the p_transaction-header_id but are not
4536: -- in this list
4537: l_progress := 600;
4538: INSERT
4539: INTO mtl_allocations_gtmp
4540: (transaction_temp_id)
4541: VALUES ( rec_mmtt1.group_temp_id);
4542: mydebug('Inserted temp_id into mtl_allocations_gtmp: ' || rec_mmtt1.group_temp_id);
4543:

Line 4542: mydebug('Inserted temp_id into mtl_allocations_gtmp: ' || rec_mmtt1.group_temp_id);

4538: INSERT
4539: INTO mtl_allocations_gtmp
4540: (transaction_temp_id)
4541: VALUES ( rec_mmtt1.group_temp_id);
4542: mydebug('Inserted temp_id into mtl_allocations_gtmp: ' || rec_mmtt1.group_temp_id);
4543:
4544: IF p_suggested_uom <> rec_mmtt1.item_primary_uom_code
4545: THEN
4546: l_suggested_mmtt_qty := inv_convert.inv_um_convert

Line 5088: FROM mtl_allocations_gtmp);

5084: ,last_update_date = SYSDATE
5085: ,last_updated_by = p_user_id
5086: WHERE transaction_temp_id IN
5087: (SELECT transaction_temp_id
5088: FROM mtl_allocations_gtmp);
5089: mydebug('nullify certain columns for all the dispatched tasks for this user');
5090: UPDATE wms_dispatched_tasks
5091: SET device_invoked = null
5092: -- Following two statement are commnet for bug 4560814

Line 5121: FROM mtl_allocations_gtmp));

5117: FROM mtl_material_transactions_temp
5118: WHERE transaction_header_id = p_transaction_header_id
5119: AND transaction_temp_id NOT IN
5120: (SELECT transaction_temp_id
5121: FROM mtl_allocations_gtmp));
5122: IF SQL%NOTFOUND THEN
5123: mydebug('no extra WDTs to delete :' );
5124: NULL;
5125: END IF;

Line 5141: FROM mtl_allocations_gtmp)

5137:
5138: DELETE wms_dispatched_tasks
5139: WHERE transaction_temp_id IN
5140: (SELECT transaction_temp_id
5141: FROM mtl_allocations_gtmp)
5142: AND status <> l_g_task_queued;
5143: IF SQL%NOTFOUND THEN
5144: mydebug('no non queued WDTs to delete :' );
5145: NULL;

Line 5155: FROM mtl_allocations_gtmp);

5151: DELETE mtl_material_transactions_temp
5152: WHERE transaction_header_id = p_transaction_header_id
5153: AND transaction_temp_id NOT IN
5154: (SELECT transaction_temp_id
5155: FROM mtl_allocations_gtmp);
5156: IF SQL%NOTFOUND THEN
5157: mydebug('no extra MMTTs to delete :' );
5158: NULL;
5159: END IF;

Line 5823: SELECT transaction_temp_id from mtl_allocations_gtmp

5819: L NUMBER :=0;
5820:
5821:
5822: CURSOR tempid_cur (v_transaction_temp_id NUMBER) IS
5823: SELECT transaction_temp_id from mtl_allocations_gtmp
5824: WHERE transaction_temp_id <> v_transaction_temp_id
5825: ORDER BY transaction_temp_id;
5826:
5827:

Line 5838: SELECT count(*) into new_mmtt_count from mtl_allocations_gtmp;

5834: l_progress := 110;
5835:
5836: l_prev_task_status := wms_picking_pkg.g_previous_task_status(p_transaction_temp_id);
5837:
5838: SELECT count(*) into new_mmtt_count from mtl_allocations_gtmp;
5839: mydebug('Total count in mtl_allocations_gtemp: ' || new_mmtt_count);
5840:
5841: l_first_index := wms_picking_pkg.g_start_over_tempid.first;
5842: l_existing_count := wms_picking_pkg.g_start_over_tempid.count-1;

Line 5994: DELETE mtl_allocations_gtmp ;

5990: BEGIN
5991: x_return_status := l_g_ret_sts_success;
5992: mydebug ('In :' || l_proc_name );
5993:
5994: DELETE mtl_allocations_gtmp ;
5995: IF SQL%NOTFOUND THEN
5996: null;
5997: END IF;
5998:

Line 6132: INTO mtl_allocations_gtmp

6128: END IF;
6129: mydebug ('l_serial_number:' || l_serial_number);
6130: mydebug ('s:' || s||':t:' || t );
6131: INSERT
6132: INTO mtl_allocations_gtmp
6133: (transaction_temp_id
6134: , lot_number
6135: , serial_number
6136: , transaction_quantity

Line 6152: INTO mtl_allocations_gtmp

6148: EXIT;
6149: END LOOP;
6150: ELSE
6151: INSERT
6152: INTO mtl_allocations_gtmp
6153: (transaction_temp_id
6154: , lot_number
6155: , serial_number
6156: , transaction_quantity

Line 9856: -- satisfy the pick in question, the temp table mtl_allocations_gtmp

9852:
9853:
9854: -- during the picking process. If the user does not specifies
9855: -- a from lpn, this procedure will figure out if the loose quantity will
9856: -- satisfy the pick in question, the temp table mtl_allocations_gtmp
9857: -- will store the available lot and serial numbers for this pick
9858:
9859: PROCEDURE loose_match(
9860: p_org_id IN NUMBER