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.

[Home] [Help]

APPS.WMS_TASK_MGMT_PUB dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 1641: FROM mtl_transaction_lots_temp

1637: BEGIN
1638: --Lot quantity
1639: SELECT sum(transaction_quantity)
1640: INTO l_mtlt_transaction_qty
1641: FROM mtl_transaction_lots_temp
1642: WHERE transaction_temp_id = p_transaction_temp_id;
1643: IF g_debug = 1 THEN
1644: print_msg(l_procedure_name , 'l_mtlt_transaction_qty : '||l_mtlt_transaction_qty|| ' l_mmtt_transaction_quantity : '||l_mmtt_transaction_quantity);
1645: END IF;

Line 1668: FROM mtl_transaction_lots_temp

1664: INTO l_msnt_transaction_qty
1665: FROM mtl_serial_numbers_temp
1666: WHERE transaction_temp_id IN
1667: (SELECT serial_transaction_temp_id
1668: FROM mtl_transaction_lots_temp
1669: WHERE transaction_temp_id = p_transaction_temp_id
1670: );
1671: IF l_msnt_transaction_qty <> l_mmtt_transaction_quantity THEN
1672: x_return_status := 'E';

Line 1691: FROM mtl_transaction_lots_temp

1687: BEGIN
1688: --Lot quantity
1689: SELECT sum(transaction_quantity)
1690: INTO l_mtlt_transaction_qty
1691: FROM mtl_transaction_lots_temp
1692: WHERE transaction_temp_id = p_transaction_temp_id;
1693: IF l_mtlt_transaction_qty <> l_mmtt_transaction_quantity THEN
1694: x_return_status := 'E';
1695: IF g_debug = 1 THEN

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

1874: END validate_task;
1875:
1876: -------------------------------------------------------------------------------------------------------------------
1877: /*PROCEDURE split_mtlt()
1878: This helper procedure performs the splitting for the lot records contained in mtl_transaction_lots_temp table
1879: */
1880: -------------------------------------------------------------------------------------------------------------------
1881: PROCEDURE split_mtlt ( p_new_transaction_temp_id IN NUMBER ,
1882: p_transaction_qty_to_split IN NUMBER ,

Line 1892: INTO mtl_transaction_lots_temp

1888:
1889: BEGIN
1890: x_return_status := 'E';
1891: INSERT
1892: INTO mtl_transaction_lots_temp
1893: (
1894: TRANSACTION_TEMP_ID ,
1895: LAST_UPDATE_DATE ,
1896: LAST_UPDATED_BY ,

Line 2120: FROM mtl_transaction_lots_temp

2116: ATTRIBUTE12 ,
2117: ATTRIBUTE13 ,
2118: ATTRIBUTE14 ,
2119: ATTRIBUTE15
2120: FROM mtl_transaction_lots_temp
2121: WHERE rowid = p_row_id;
2122: x_return_status := 'S';
2123: EXCEPTION
2124: WHEN OTHERS THEN

Line 2207: FROM mtl_transaction_lots_temp mtlt

2203: CURSOR C_MTLT
2204: IS
2205: SELECT rowid,
2206: mtlt.*
2207: FROM mtl_transaction_lots_temp mtlt
2208: WHERE transaction_temp_id = p_orig_transaction_temp_id
2209: ORDER BY lot_number;
2210:
2211: l_transaction_remaining_qty NUMBER;

Line 2245: UPDATE mtl_transaction_lots_temp

2241: -- Calculate remaining quantity.
2242: -- Update mtl_lot_number
2243: l_transaction_remaining_qty := l_transaction_remaining_qty - mtlt.transaction_quantity;
2244: l_primary_remaining_qty := l_primary_remaining_qty - mtlt.primary_quantity;
2245: UPDATE mtl_transaction_lots_temp
2246: SET transaction_temp_id = p_new_transaction_temp_id ,
2247: last_updated_by = FND_GLOBAL.USER_ID
2248: WHERE rowid = mtlt.rowid;
2249: IF l_transaction_remaining_qty = 0 THEN

Line 2268: UPDATE mtl_transaction_lots_temp

2264: IF mtlt.serial_transaction_temp_id IS NOT NULL THEN
2265: SELECT mtl_material_transactions_s.NEXTVAL
2266: INTO l_new_serial_txn_temp_id
2267: FROM dual;
2268: UPDATE mtl_transaction_lots_temp
2269: SET serial_transaction_temp_id = l_new_serial_txn_temp_id ,
2270: last_updated_by = FND_GLOBAL.USER_ID
2271: WHERE transaction_temp_id = p_new_transaction_temp_id
2272: AND lot_number = mtlt.lot_number;

Line 2286: UPDATE mtl_transaction_lots_temp

2282: END IF;
2283: l_txn_remaining_qty_mtlt := mtlt.transaction_quantity - l_transaction_remaining_qty;
2284: l_prim_remaining_qty_mtlt := mtlt.primary_quantity - l_primary_remaining_qty;
2285: -- Update the remaining qty in the mtlt after insert.
2286: UPDATE mtl_transaction_lots_temp
2287: SET transaction_quantity = l_txn_remaining_qty_mtlt ,
2288: primary_quantity = l_prim_remaining_qty_mtlt ,
2289: last_updated_by = FND_GLOBAL.USER_ID
2290: WHERE rowid = mtlt.rowid;

Line 3247: FROM mtl_transaction_lots_temp

3243: INTO l_msn_count
3244: FROM mtl_serial_numbers
3245: WHERE group_mark_id IN
3246: (SELECT serial_transaction_temp_id
3247: FROM mtl_transaction_lots_temp
3248: WHERE transaction_temp_id = p_transaction_temp_id
3249: );
3250: IF l_msn_count > 0 THEN
3251: UPDATE mtl_serial_numbers

Line 3257: FROM mtl_transaction_lots_temp

3253: line_mark_id = NULL,
3254: lot_line_mark_id = NULL
3255: WHERE group_mark_id IN
3256: (SELECT serial_transaction_temp_id
3257: FROM mtl_transaction_lots_temp
3258: WHERE transaction_temp_id = p_transaction_temp_id
3259: );
3260: l_unmarked_count := SQL%ROWCOUNT;
3261: IF SQL%ROWCOUNT = 0 THEN

Line 3274: FROM mtl_transaction_lots_temp

3270: INTO l_msnt_count
3271: FROM mtl_serial_numbers_temp
3272: WHERE transaction_temp_id IN
3273: (SELECT serial_transaction_temp_id
3274: FROM mtl_transaction_lots_temp
3275: WHERE transaction_temp_id = p_transaction_temp_id
3276: );
3277: IF l_msnt_count > 0 THEN
3278: DELETE mtl_serial_numbers_temp

Line 3281: FROM mtl_transaction_lots_temp

3277: IF l_msnt_count > 0 THEN
3278: DELETE mtl_serial_numbers_temp
3279: WHERE transaction_temp_id IN
3280: (SELECT serial_transaction_temp_id
3281: FROM mtl_transaction_lots_temp
3282: WHERE transaction_temp_id = p_transaction_temp_id
3283: );
3284: IF SQL%ROWCOUNT = 0 THEN
3285: IF l_debug = 1 THEN

Line 3335: DELETE mtl_transaction_lots_temp

3331: END IF;
3332: END IF;
3333: -- Deleting all the Lots associated with the Transaction
3334: IF l_lot_control_code = 2 THEN
3335: DELETE mtl_transaction_lots_temp
3336: WHERE transaction_temp_id = p_transaction_temp_id;
3337: IF SQL%ROWCOUNT = 0 THEN
3338: IF l_debug = 1 THEN
3339: debug_print ( 'Error deleting MTLT ');

Line 6630: FROM mtl_transaction_lots_temp

6626:
6627: CURSOR mtlt_changed (p_ttemp_id IN NUMBER)
6628: IS
6629: SELECT *
6630: FROM mtl_transaction_lots_temp
6631: WHERE transaction_temp_id = p_ttemp_id
6632: ORDER BY lot_number;
6633:
6634: --Bug 6766048

Line 6648: l_mtlt_row MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;

6644: from mtl_system_items
6645: where inventory_item_id = p_item_id
6646: and organization_id = p_organization_id;
6647:
6648: l_mtlt_row MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;
6649: -- l_split_uom_quantities qty_changed_tbl_type;
6650: l_procedure_name VARCHAR2(30) := 'SPLIT_TASK';
6651: l_task_tbl_qty_count NUMBER := p_split_quantities.COUNT;
6652: g_debug NUMBER := nvl(fnd_profile.VALUE('INV_DEBUG_TRACE'),0);