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

Line 12143: , MTL_TRANSACTION_LOTS_TEMP mtlt -- Added for 14699845 (Flexible lot allocation)

12139: , mmtt.item_serial_control_code
12140: , mmtt.serial_allocated_flag
12141: , Decode(Nvl(mmtt.lot_number, mtlt.LOT_NUMBER), NULL, 'N', 'Y') lot_allocated_flag -- Added for 14699845 (Flexible lot allocation)
12142: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda
12143: , MTL_TRANSACTION_LOTS_TEMP mtlt -- Added for 14699845 (Flexible lot allocation)
12144: WHERE mmtt.move_order_line_id = mol.line_id
12145: -- AND mol.header_id = p_move_order_header_id -- no need since wct only have the records in concerns
12146: AND mol.line_id = wdd.move_ordeR_line_id
12147: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 12227: , MTL_TRANSACTION_LOTS_TEMP mtlt -- Added for 14699845 (Flexible lot allocation)

12223: , mmtt.item_serial_control_code
12224: , mmtt.serial_allocated_flag
12225: , Decode(Nvl(mmtt.lot_number, mtlt.LOT_NUMBER), NULL, 'N', 'Y') lot_allocated_flag -- Added for 14699845 (Flexible lot allocation)
12226: FROM wms_cartonization_temp mmtt
12227: , MTL_TRANSACTION_LOTS_TEMP mtlt -- Added for 14699845 (Flexible lot allocation)
12228: WHERE
12229: mmtt.wms_task_type NOT IN(5, 6)
12230: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id (+) -- Added for 14699845 (Flexible lot allocation)
12231: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation

Line 12313: , MTL_TRANSACTION_LOTS_TEMP mtlt -- Added for 14699845 (Flexible lot allocation)

12309: , mmtt.serial_allocated_flag
12310: , Decode(Nvl(mmtt.lot_number, mtlt.LOT_NUMBER), NULL, 'N', 'Y') lot_allocated_flag -- Added for 14699845 (Flexible lot allocation)
12311: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol,
12312: wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda
12313: , MTL_TRANSACTION_LOTS_TEMP mtlt -- Added for 14699845 (Flexible lot allocation)
12314: WHERE mmtt.move_order_line_id = mol.line_id
12315: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id (+) -- Added for 14699845 (Flexible lot allocation)
12316: AND ( mmtt.serial_allocated_flag = 'N' -- do not bulk serial allocated lines
12317: or mmtt.serial_allocated_flag is null)

Line 12380: , MTL_TRANSACTION_LOTS_TEMP mtlt -- Added for 14699845 (Flexible lot allocation)

12376: , mmtt.item_serial_control_code
12377: , mmtt.serial_allocated_flag
12378: , Decode(Nvl(mmtt.lot_number, mtlt.LOT_NUMBER), NULL, 'N', 'Y') lot_allocated_flag -- Added for 14699845 (Flexible lot allocation)
12379: FROM wms_cartonization_temp mmtt
12380: , MTL_TRANSACTION_LOTS_TEMP mtlt -- Added for 14699845 (Flexible lot allocation)
12381: WHERE (mmtt.serial_allocated_flag = 'N' -- do not bulk serial allocated lines
12382: or mmtt.serial_allocated_flag is null )
12383: AND NVL(mmtt.fulfillment_base,'P') = 'P'
12384: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id (+) -- Added for 14699845 (Flexible lot allocation)

Line 12793: AND ((l_lot_allocated_flag = 'Y' AND EXISTS (SELECT 1 FROM MTL_TRANSACTION_LOTS_TEMP mtlt WHERE mtlt.transaction_temp_id=wct.transaction_temp_id))

12789: AND NVL(transaction_action_id, -1) = NVL(l_transaction_action_id, NVL(transaction_action_id, -1))
12790: AND NVL(transaction_source_type_id, -1) = NVL(l_transaction_source_type_id, NVL(transaction_source_type_id, -1))
12791: AND NVL(cost_group_id, -1) = NVL(l_cost_group_id, NVL(cost_group_id, -1))
12792: -- Added for 14699845 (Flexible lot allocation)
12793: AND ((l_lot_allocated_flag = 'Y' AND EXISTS (SELECT 1 FROM MTL_TRANSACTION_LOTS_TEMP mtlt WHERE mtlt.transaction_temp_id=wct.transaction_temp_id))
12794: OR (l_lot_allocated_flag = 'N' AND NOT EXISTS (SELECT 1 FROM MTL_TRANSACTION_LOTS_TEMP mtlt WHERE mtlt.transaction_temp_id=wct.transaction_temp_id)))
12795: AND EXISTS(SELECT 1
12796: FROM mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda
12797: WHERE mol.line_id = wct.move_order_line_id

Line 12794: OR (l_lot_allocated_flag = 'N' AND NOT EXISTS (SELECT 1 FROM MTL_TRANSACTION_LOTS_TEMP mtlt WHERE mtlt.transaction_temp_id=wct.transaction_temp_id)))

12790: AND NVL(transaction_source_type_id, -1) = NVL(l_transaction_source_type_id, NVL(transaction_source_type_id, -1))
12791: AND NVL(cost_group_id, -1) = NVL(l_cost_group_id, NVL(cost_group_id, -1))
12792: -- Added for 14699845 (Flexible lot allocation)
12793: AND ((l_lot_allocated_flag = 'Y' AND EXISTS (SELECT 1 FROM MTL_TRANSACTION_LOTS_TEMP mtlt WHERE mtlt.transaction_temp_id=wct.transaction_temp_id))
12794: OR (l_lot_allocated_flag = 'N' AND NOT EXISTS (SELECT 1 FROM MTL_TRANSACTION_LOTS_TEMP mtlt WHERE mtlt.transaction_temp_id=wct.transaction_temp_id)))
12795: AND EXISTS(SELECT 1
12796: FROM mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda
12797: WHERE mol.line_id = wct.move_order_line_id
12798: AND mol.line_id = wdd.move_ordeR_line_id

Line 12823: AND ((l_lot_allocated_flag = 'Y' AND EXISTS (SELECT 1 FROM MTL_TRANSACTION_LOTS_TEMP mtlt WHERE mtlt.transaction_temp_id=wct.transaction_temp_id))

12819: AND NVL(transaction_action_id, -1) = NVL(l_transaction_action_id, NVL(transaction_action_id, -1))
12820: AND NVL(transaction_source_type_id, -1) = NVL(l_transaction_source_type_id, NVL(transaction_source_type_id, -1))
12821: AND NVL(cost_group_id, -1) = NVL(l_cost_group_id, NVL(cost_group_id, -1))
12822: -- Added for 14699845 (Flexible lot allocation)
12823: AND ((l_lot_allocated_flag = 'Y' AND EXISTS (SELECT 1 FROM MTL_TRANSACTION_LOTS_TEMP mtlt WHERE mtlt.transaction_temp_id=wct.transaction_temp_id))
12824: OR (l_lot_allocated_flag = 'N' AND NOT EXISTS (SELECT 1 FROM MTL_TRANSACTION_LOTS_TEMP mtlt WHERE mtlt.transaction_temp_id=wct.transaction_temp_id)))
12825: AND transaction_temp_id NOT IN ( -- added for bug 9309619 Vpedarla
12826: SELECT transaction_temp_id
12827: FROM mtl_material_transactions_temp mmtt

Line 12824: OR (l_lot_allocated_flag = 'N' AND NOT EXISTS (SELECT 1 FROM MTL_TRANSACTION_LOTS_TEMP mtlt WHERE mtlt.transaction_temp_id=wct.transaction_temp_id)))

12820: AND NVL(transaction_source_type_id, -1) = NVL(l_transaction_source_type_id, NVL(transaction_source_type_id, -1))
12821: AND NVL(cost_group_id, -1) = NVL(l_cost_group_id, NVL(cost_group_id, -1))
12822: -- Added for 14699845 (Flexible lot allocation)
12823: AND ((l_lot_allocated_flag = 'Y' AND EXISTS (SELECT 1 FROM MTL_TRANSACTION_LOTS_TEMP mtlt WHERE mtlt.transaction_temp_id=wct.transaction_temp_id))
12824: OR (l_lot_allocated_flag = 'N' AND NOT EXISTS (SELECT 1 FROM MTL_TRANSACTION_LOTS_TEMP mtlt WHERE mtlt.transaction_temp_id=wct.transaction_temp_id)))
12825: AND transaction_temp_id NOT IN ( -- added for bug 9309619 Vpedarla
12826: SELECT transaction_temp_id
12827: FROM mtl_material_transactions_temp mmtt
12828: WHERE mmtt.transaction_temp_id = wct.transaction_temp_id -- Modified for 14699845 (Flexible lot allocation)

Line 12899: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;

12895: , x_msg_data OUT NOCOPY VARCHAR2) IS
12896:
12897: l_serial_number_control_code NUMBER;
12898: l_lot_control_code NUMBER;
12899: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
12900: l_msnt_rec mtl_serial_numbers_temp%ROWTYPE;
12901: l_new_txn_temp_id NUMBER;
12902:
12903:

Line 12930: INSERT INTO mtl_transaction_lots_temp

12926: END IF;
12927:
12928: IF (l_lot_control_code = 2) THEN
12929: -- insert the lot numbers for the parent line
12930: INSERT INTO mtl_transaction_lots_temp
12931: (transaction_temp_id
12932: , lot_number
12933: , transaction_quantity
12934: , primary_quantity

Line 12955: FROM mtl_transaction_lots_temp mtlt,mtl_material_transactions_temp mmtt

12951: ,g_user_id
12952: ,SYSDATE
12953: ,g_user_id
12954: ,null
12955: FROM mtl_transaction_lots_temp mtlt,mtl_material_transactions_temp mmtt
12956: WHERE
12957: mtlt.transaction_temp_id = mmtt.transaction_temp_id
12958: and mmtt.parent_line_id = p_parent_transaction_temp_id -- child task
12959: and mmtt.transaction_temp_id <> p_parent_transaction_temp_id -- not parent task

Line 14867: INSERT INTO mtl_transaction_lots_temp

14863: FETCH mmtt INTO l_mmtt_rec;
14864:
14865: CLOSE mmtt;
14866:
14867: INSERT INTO mtl_transaction_lots_temp
14868: (
14869: transaction_temp_id
14870: , last_update_date
14871: , last_updated_by