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_MGMT_PUB dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 1714: FROM mtl_transaction_lots_temp

1710: BEGIN
1711: --Lot quantity
1712: SELECT sum(transaction_quantity)
1713: INTO l_mtlt_transaction_qty
1714: FROM mtl_transaction_lots_temp
1715: WHERE transaction_temp_id = p_transaction_temp_id;
1716: IF g_debug = 1 THEN
1717: print_msg(l_procedure_name , 'l_mtlt_transaction_qty : '||l_mtlt_transaction_qty|| ' l_mmtt_transaction_quantity : '||l_mmtt_transaction_quantity);
1718: END IF;

Line 1741: FROM mtl_transaction_lots_temp

1737: INTO l_msnt_transaction_qty
1738: FROM mtl_serial_numbers_temp
1739: WHERE transaction_temp_id IN
1740: (SELECT serial_transaction_temp_id
1741: FROM mtl_transaction_lots_temp
1742: WHERE transaction_temp_id = p_transaction_temp_id
1743: );
1744: IF l_msnt_transaction_qty <> l_mmtt_transaction_quantity THEN
1745: x_return_status := 'E';

Line 1764: FROM mtl_transaction_lots_temp

1760: BEGIN
1761: --Lot quantity
1762: SELECT sum(transaction_quantity)
1763: INTO l_mtlt_transaction_qty
1764: FROM mtl_transaction_lots_temp
1765: WHERE transaction_temp_id = p_transaction_temp_id;
1766: IF l_mtlt_transaction_qty <> l_mmtt_transaction_quantity THEN
1767: x_return_status := 'E';
1768: IF g_debug = 1 THEN

Line 1954: This helper procedure performs the splitting for the lot records contained in mtl_transaction_lots_temp table

1950: END validate_task;
1951:
1952: -------------------------------------------------------------------------------------------------------------------
1953: /*PROCEDURE split_mtlt()
1954: This helper procedure performs the splitting for the lot records contained in mtl_transaction_lots_temp table
1955: */
1956: -------------------------------------------------------------------------------------------------------------------
1957: PROCEDURE split_mtlt ( p_new_transaction_temp_id IN NUMBER ,
1958: p_transaction_qty_to_split IN NUMBER ,

Line 1969: INTO mtl_transaction_lots_temp

1965:
1966: BEGIN
1967: x_return_status := 'E';
1968: INSERT
1969: INTO mtl_transaction_lots_temp
1970: (
1971: TRANSACTION_TEMP_ID ,
1972: LAST_UPDATE_DATE ,
1973: LAST_UPDATED_BY ,

Line 2197: FROM mtl_transaction_lots_temp

2193: ATTRIBUTE12 ,
2194: ATTRIBUTE13 ,
2195: ATTRIBUTE14 ,
2196: ATTRIBUTE15
2197: FROM mtl_transaction_lots_temp
2198: WHERE rowid = p_row_id;
2199: x_return_status := 'S';
2200: EXCEPTION
2201: WHEN OTHERS THEN

Line 2285: FROM mtl_transaction_lots_temp mtlt

2281: CURSOR C_MTLT
2282: IS
2283: SELECT rowid,
2284: mtlt.*
2285: FROM mtl_transaction_lots_temp mtlt
2286: WHERE transaction_temp_id = p_orig_transaction_temp_id
2287: ORDER BY lot_number;
2288:
2289: l_transaction_remaining_qty NUMBER;

Line 2327: UPDATE mtl_transaction_lots_temp

2323: -- Update mtl_lot_number
2324: l_transaction_remaining_qty := l_transaction_remaining_qty - mtlt.transaction_quantity;
2325: l_primary_remaining_qty := l_primary_remaining_qty - mtlt.primary_quantity;
2326: l_secondary_remaining_qty := l_secondary_remaining_qty - mtlt.secondary_quantity; -- Added for Bug 16099247
2327: UPDATE mtl_transaction_lots_temp
2328: SET transaction_temp_id = p_new_transaction_temp_id ,
2329: last_updated_by = FND_GLOBAL.USER_ID
2330: WHERE rowid = mtlt.rowid;
2331: IF l_transaction_remaining_qty = 0 THEN

Line 2352: UPDATE mtl_transaction_lots_temp

2348: IF mtlt.serial_transaction_temp_id IS NOT NULL THEN
2349: SELECT mtl_material_transactions_s.NEXTVAL
2350: INTO l_new_serial_txn_temp_id
2351: FROM dual;
2352: UPDATE mtl_transaction_lots_temp
2353: SET serial_transaction_temp_id = l_new_serial_txn_temp_id ,
2354: last_updated_by = FND_GLOBAL.USER_ID
2355: WHERE transaction_temp_id = p_new_transaction_temp_id
2356: AND lot_number = mtlt.lot_number;

Line 2371: UPDATE mtl_transaction_lots_temp

2367: l_txn_remaining_qty_mtlt := mtlt.transaction_quantity - l_transaction_remaining_qty;
2368: l_prim_remaining_qty_mtlt := mtlt.primary_quantity - l_primary_remaining_qty;
2369: l_sec_remaining_qty_mtlt := mtlt.secondary_quantity - l_secondary_remaining_qty; -- Added for Bug 16099247
2370: -- Update the remaining qty in the mtlt after insert.
2371: UPDATE mtl_transaction_lots_temp
2372: SET transaction_quantity = l_txn_remaining_qty_mtlt ,
2373: primary_quantity = l_prim_remaining_qty_mtlt ,
2374: secondary_quantity = l_sec_remaining_qty_mtlt , -- Added for Bug 16099247
2375: last_updated_by = FND_GLOBAL.USER_ID

Line 3336: FROM mtl_transaction_lots_temp

3332: INTO l_msn_count
3333: FROM mtl_serial_numbers
3334: WHERE group_mark_id IN
3335: (SELECT serial_transaction_temp_id
3336: FROM mtl_transaction_lots_temp
3337: WHERE transaction_temp_id = p_transaction_temp_id
3338: );
3339: IF l_msn_count > 0 THEN
3340: UPDATE mtl_serial_numbers

Line 3346: FROM mtl_transaction_lots_temp

3342: line_mark_id = NULL,
3343: lot_line_mark_id = NULL
3344: WHERE group_mark_id IN
3345: (SELECT serial_transaction_temp_id
3346: FROM mtl_transaction_lots_temp
3347: WHERE transaction_temp_id = p_transaction_temp_id
3348: );
3349: l_unmarked_count := SQL%ROWCOUNT;
3350: IF SQL%ROWCOUNT = 0 THEN

Line 3363: FROM mtl_transaction_lots_temp

3359: INTO l_msnt_count
3360: FROM mtl_serial_numbers_temp
3361: WHERE transaction_temp_id IN
3362: (SELECT serial_transaction_temp_id
3363: FROM mtl_transaction_lots_temp
3364: WHERE transaction_temp_id = p_transaction_temp_id
3365: );
3366: IF l_msnt_count > 0 THEN
3367: DELETE mtl_serial_numbers_temp

Line 3370: FROM mtl_transaction_lots_temp

3366: IF l_msnt_count > 0 THEN
3367: DELETE mtl_serial_numbers_temp
3368: WHERE transaction_temp_id IN
3369: (SELECT serial_transaction_temp_id
3370: FROM mtl_transaction_lots_temp
3371: WHERE transaction_temp_id = p_transaction_temp_id
3372: );
3373: IF SQL%ROWCOUNT = 0 THEN
3374: IF l_debug = 1 THEN

Line 3424: DELETE mtl_transaction_lots_temp

3420: END IF;
3421: END IF;
3422: -- Deleting all the Lots associated with the Transaction
3423: IF l_lot_control_code = 2 THEN
3424: DELETE mtl_transaction_lots_temp
3425: WHERE transaction_temp_id = p_transaction_temp_id;
3426: IF SQL%ROWCOUNT = 0 THEN
3427: IF l_debug = 1 THEN
3428: debug_print ( 'Error deleting MTLT ');

Line 6725: FROM mtl_transaction_lots_temp

6721:
6722: CURSOR mtlt_changed (p_ttemp_id IN NUMBER)
6723: IS
6724: SELECT *
6725: FROM mtl_transaction_lots_temp
6726: WHERE transaction_temp_id = p_ttemp_id
6727: ORDER BY lot_number;
6728:
6729: --Bug 6766048

Line 6743: l_mtlt_row MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;

6739: from mtl_system_items
6740: where inventory_item_id = p_item_id
6741: and organization_id = p_organization_id;
6742:
6743: l_mtlt_row MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;
6744: -- l_split_uom_quantities qty_changed_tbl_type;
6745: l_procedure_name VARCHAR2(30) := 'SPLIT_TASK';
6746: l_task_tbl_qty_count NUMBER := p_split_quantities.COUNT;
6747: g_debug NUMBER := nvl(fnd_profile.VALUE('INV_DEBUG_TRACE'),0);