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.INV_MISSING_QTY_ACTIONS_ENGINE dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 152: FROM mtl_transaction_lots_temp mtlt

148: , DECODE(NVL(mat.secondary_quantity,0) - NVL(SUM(mtlt.secondary_quantity),0)
149: ,0,NULL,
150: NVL(mat.secondary_quantity,0) - NVL(SUM(mtlt.secondary_quantity),0)
151: ) --INVCONV kkillams
152: FROM mtl_transaction_lots_temp mtlt
153: WHERE mtlt.transaction_temp_id = p_transaction_temp_id
154: AND mtlt.lot_number = mat.lot_number)
155:
156: WHERE mat.transaction_temp_id = p_transaction_temp_id;

Line 173: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn

169: ELSIF p_lot_control_code = 2 AND p_serial_control_code NOT IN(1, 6) THEN
170: DELETE mtl_allocations_gtmp
171: WHERE transaction_temp_id = p_transaction_temp_id
172: AND serial_number IN( SELECT msn.serial_number
173: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn
174: WHERE mtlt.transaction_temp_id = p_transaction_temp_id
175: AND msn.group_mark_id = mtlt.serial_transaction_temp_id);
176: l_deleted_count := SQL%ROWCOUNT;
177:

Line 188: FROM mtl_transaction_lots_temp mtlt

184: ,0,NULL,
185: NVL(mat.secondary_quantity,0) - NVL(SUM(mtlt.secondary_quantity),0)
186: ) --INVCONV kkillams
187:
188: FROM mtl_transaction_lots_temp mtlt
189: WHERE mtlt.transaction_temp_id = p_transaction_temp_id
190: AND mtlt.lot_number = mat.lot_number)
191: WHERE mat.transaction_temp_id = p_transaction_temp_id;
192: l_updated_count := SQL%ROWCOUNT;

Line 565: INSERT INTO mtl_transaction_lots_temp(

561: print_debug('The primary quantity is '|| curr_lot.primary_quantity,l_api_name, g_info);
562: print_debug('The remaining quantity is '|| l_rem_txn_qty,l_api_name, g_info);
563: END IF;
564:
565: INSERT INTO mtl_transaction_lots_temp(
566: transaction_temp_id
567: , lot_number, transaction_quantity, primary_quantity
568: , serial_transaction_temp_id, group_header_id
569: , last_update_date, last_updated_by, creation_date, created_by

Line 1254: FROM mtl_transaction_lots_temp mtlt

1250: INSERT INTO mtl_allocations_gtmp(transaction_temp_id, lot_number, transaction_quantity, primary_quantity
1251: ,secondary_quantity) --INVCONV kkillams
1252: SELECT p_transaction_temp_id, mtlt.lot_number, SUM(mtlt.transaction_quantity), SUM(mtlt.primary_quantity)
1253: ,DECODE(SUM(NVL(mtlt.secondary_quantity,0)),0,NULL,SUM(NVL(mtlt.secondary_quantity,0))) --INVCONV kkillams
1254: FROM mtl_transaction_lots_temp mtlt
1255: WHERE p_transaction_temp_id IS NOT NULL
1256: AND mtlt.transaction_temp_id = p_transaction_temp_id
1257: GROUP BY mtlt.lot_number
1258: UNION ALL

Line 1261: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

1257: GROUP BY mtlt.lot_number
1258: UNION ALL
1259: SELECT mmtt.transaction_temp_id, mtlt.lot_number, SUM(mtlt.transaction_quantity), SUM(mtlt.primary_quantity)
1260: ,DECODE(SUM(NVL(mtlt.secondary_quantity,0)),0,NULL,SUM(NVL(mtlt.secondary_quantity,0))) --INVCONV kkillams
1261: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1262: WHERE p_transaction_temp_id IS NULL AND p_mo_line_id IS NOT NULL
1263: AND mmtt.move_order_line_id = p_mo_line_id
1264: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
1265: GROUP BY mmtt.transaction_temp_id, mtlt.lot_number;

Line 1349: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn

1345: END IF;
1346:
1347: INSERT INTO mtl_allocations_gtmp(transaction_temp_id, lot_number, serial_number, transaction_quantity, primary_quantity)
1348: SELECT p_transaction_temp_id, mtlt.lot_number, msn.serial_number, 1, 1
1349: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn
1350: WHERE p_transaction_temp_id IS NOT NULL
1351: AND mtlt.transaction_temp_id = p_transaction_temp_id
1352: AND msn.group_mark_id = mtlt.serial_transaction_temp_id
1353: UNION ALL

Line 1355: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn

1351: AND mtlt.transaction_temp_id = p_transaction_temp_id
1352: AND msn.group_mark_id = mtlt.serial_transaction_temp_id
1353: UNION ALL
1354: SELECT mmtt.transaction_temp_id, mtlt.lot_number, msn.serial_number, 1, 1
1355: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn
1356: WHERE p_transaction_temp_id IS NULL and p_mo_line_id IS NOT NULL
1357: AND mmtt.move_order_line_id = p_mo_line_id
1358: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
1359: AND msn.group_mark_id = mtlt.serial_transaction_temp_id;