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 WMS_CARTONIZATION_TEMP

Line 11096: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol

11092: l_move_order_type NUMBER;
11093:
11094: CURSOR task_list IS
11095: SELECT mmtt.transaction_temp_id
11096: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol
11097: WHERE mmtt.move_order_line_id = mol.line_id
11098: AND mol.header_id = p_move_order_header_id;
11099:
11100:

Line 11104: FROM wms_cartonization_temp mmtt

11100:
11101: ---- Patchset J, bulk picking -------------
11102: CURSOR task_list_bulk IS
11103: SELECT mmtt.transaction_temp_id
11104: FROM wms_cartonization_temp mmtt
11105: WHERE
11106: mmtt.parent_line_id is null -- non bulked tasks
11107: OR mmtt.parent_line_id = mmtt.transaction_temp_id; -- parent line only
11108: ---- End of Patchset J, bulk picking -------------

Line 11594: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol

11590: , mmtt.item_lot_control_code
11591: , mmtt.item_serial_control_code
11592: , mmtt.serial_allocated_flag
11593: -- Bug 4584538
11594: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol
11595: WHERE mmtt.move_order_line_id = mol.line_id
11596: AND mol.header_id = p_move_order_header_id
11597: AND mmtt.wms_task_type NOT IN(5, 6)
11598: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation

Line 11694: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol

11690: , mmtt.item_lot_control_code
11691: , mmtt.item_serial_control_code
11692: , mmtt.serial_allocated_flag
11693: -- Bug 4584538
11694: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol
11695: WHERE mmtt.move_order_line_id = mol.line_id
11696: AND mol.header_id = p_move_order_header_id
11697: AND mmtt.wms_task_type NOT IN(5, 6)
11698: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation

Line 11896: INSERT INTO wms_cartonization_temp

11892: print_debug(' --> Serial Control Code => ' || l_serial_control_code, 4);
11893: print_debug(' --> Serial Allocated Flag => ' || l_serial_allocated_flag, 4);
11894: END IF;
11895:
11896: INSERT INTO wms_cartonization_temp
11897: (
11898: transaction_header_id
11899: , transaction_temp_id
11900: , posting_flag

Line 11995: UPDATE wms_cartonization_temp

11991: IF (l_debug = 1) THEN
11992: print_debug('Updating the Parent Line ID of the Tasks Consolidated', 4);
11993: END IF;
11994:
11995: UPDATE wms_cartonization_temp
11996: SET parent_line_id = l_new_txn_temp_id
11997: WHERE transaction_temp_id <> l_new_txn_temp_id
11998: AND inventory_item_id = l_inventory_item_id
11999: AND NVL(revision, '#$%') = NVL(l_revision, NVL(revision, '#$%'))

Line 12142: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda

12138: , mmtt.item_lot_control_code
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

Line 12226: FROM wms_cartonization_temp mmtt

12222: , mmtt.item_lot_control_code
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)

Line 12311: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol,

12307: , mmtt.item_lot_control_code
12308: , mmtt.item_serial_control_code
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)

Line 12379: FROM wms_cartonization_temp mmtt

12375: , mmtt.item_lot_control_code
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'

Line 12694: INSERT INTO wms_cartonization_temp

12690: print_debug(' --> Task Status => ' || l_wms_task_status, 4);
12691: print_debug(' --> Lot Allocated Flag => ' || l_lot_allocated_flag, 4); -- Added for 14699845 (Flexible lot allocation)
12692: END IF;
12693:
12694: INSERT INTO wms_cartonization_temp
12695: (
12696: transaction_header_id
12697: , transaction_temp_id
12698: , posting_flag

Line 12778: UPDATE wms_cartonization_temp wct

12774: print_debug('Updating the Parent Line ID of the Tasks Consolidated', 4);
12775: END IF;
12776:
12777: IF l_delivery_flag = 'Y' THEN
12778: UPDATE wms_cartonization_temp wct
12779: SET parent_line_id = l_new_txn_temp_id
12780: WHERE transaction_temp_id <> l_new_txn_temp_id
12781: AND inventory_item_id = l_inventory_item_id
12782: AND NVL(revision, '#$%') = NVL(l_revision, NVL(revision, '#$%'))

Line 12808: UPDATE wms_cartonization_temp wct

12804: WHERE mmtt.transaction_temp_id = wct.transaction_temp_id
12805: AND mmtt.allocated_lpn_id IS NOT NULL)
12806: AND wct.cartonization_id is NULL;--added for bug 9446937
12807: ELSE
12808: UPDATE wms_cartonization_temp wct
12809: SET parent_line_id = l_new_txn_temp_id
12810: WHERE transaction_temp_id <> l_new_txn_temp_id
12811: AND inventory_item_id = l_inventory_item_id
12812: AND NVL(revision, '#$%') = NVL(l_revision, NVL(revision, '#$%'))

Line 13013: l_task_rec_old_wct wms_cartonization_temp%ROWTYPE;

13009: l_item_v_uom VARCHAR2(3); -- item unit volume UOM
13010: l_item_w_uom VARCHAR2(3); -- item unit weight UOM
13011: l_eq_it_v_uom_ratio NUMBER := 1; -- conversion rate between equipment volume capacity and item unit volume UOM
13012: l_eq_it_w_uom_ratio NUMBER := 1; -- conversion rate between equipment weight capacity and item weight UOM
13013: l_task_rec_old_wct wms_cartonization_temp%ROWTYPE;
13014: l_task_rec_new_wct wms_cartonization_temp%ROWTYPE;
13015: l_task_rec_old_mmtt mtl_material_transactions_temp%ROWTYPE;
13016: l_task_rec_new_mmtt mtl_material_transactions_temp%ROWTYPE;
13017: l_child_rec_new mtl_material_transactions_temp%ROWTYPE;

Line 13014: l_task_rec_new_wct wms_cartonization_temp%ROWTYPE;

13010: l_item_w_uom VARCHAR2(3); -- item unit weight UOM
13011: l_eq_it_v_uom_ratio NUMBER := 1; -- conversion rate between equipment volume capacity and item unit volume UOM
13012: l_eq_it_w_uom_ratio NUMBER := 1; -- conversion rate between equipment weight capacity and item weight UOM
13013: l_task_rec_old_wct wms_cartonization_temp%ROWTYPE;
13014: l_task_rec_new_wct wms_cartonization_temp%ROWTYPE;
13015: l_task_rec_old_mmtt mtl_material_transactions_temp%ROWTYPE;
13016: l_task_rec_new_mmtt mtl_material_transactions_temp%ROWTYPE;
13017: l_child_rec_new mtl_material_transactions_temp%ROWTYPE;
13018: l_lot_split_rec inv_rcv_common_apis.trans_rec_tb_tp;

Line 13051: , wms_cartonization_temp mmtt

13047: , -- item volume UOM code
13048: item.weight_uom_code item_w_uom -- item weight UOM code
13049: FROM mtl_system_items equip
13050: , mtl_system_items item
13051: , wms_cartonization_temp mmtt
13052: , bom_resource_equipments res_equip
13053: , bom_resources res
13054: , bom_std_op_resources tt_x_res
13055: WHERE mmtt.transaction_temp_id = p_task_id -- the task in question

Line 13105: From wms_cartonization_temp mmtt,mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,

13101:
13102: -- A new cursor will be defined to find all the child tasks ordered by delivery
13103: Cursor c_child_tasks(p_parent_line_id NUMBER) is
13104: Select mmtt.transaction_temp_id,mmtt.transaction_quantity,mmtt.secondary_transaction_quantity,mmtt.primary_quantity
13105: From wms_cartonization_temp mmtt,mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,
13106: wsh_delivery_assignments_v wda
13107: WHERE mmtt.parent_line_id = p_parent_line_id
13108: And mol.line_id = mmtt.move_order_line_id
13109: and mol.line_id = wdd.move_order_line_id

Line 13141: FROM wms_cartonization_temp

13137: -- Also query the transaction quantity
13138: -- changed for patchset J bulk picking -----------
13139: SELECT *
13140: INTO l_task_rec_old_wct
13141: FROM wms_cartonization_temp
13142: WHERE transaction_temp_id = p_task_id;
13143:
13144: -- get the mmtt rec too, will be used later on, the reason why both wct and mmtt are here is for branching
13145: SELECT *

Line 13191: FROM wms_cartonization_temp mmtt, mtl_item_locations mil, mtl_secondary_inventories msi, mtl_system_items item

13187: , l_item_prim_uom_code
13188: , l_lot_control_code
13189: , l_serial_number_control_code
13190: , l_item_sec_uom_code
13191: FROM wms_cartonization_temp mmtt, mtl_item_locations mil, mtl_secondary_inventories msi, mtl_system_items item
13192: WHERE mmtt.transaction_temp_id = p_task_id
13193: AND mmtt.locator_id = mil.inventory_location_id(+)
13194: AND mmtt.organization_id = mil.organization_id(+)
13195: AND mmtt.subinventory_code = msi.secondary_inventory_name

Line 13800: UPDATE wms_cartonization_temp

13796: print_debug('split_task 130 - remove original task: ', 4);
13797: END IF;
13798:
13799: IF ((l_init_qty <= l_split_factor)) THEN
13800: UPDATE wms_cartonization_temp
13801: SET transaction_quantity = l_init_qty
13802: , primary_quantity = l_init_qty * l_txn_pri_uom_ratio
13803: , secondary_transaction_quantity = DECODE(l_txn_sec_uom_ratio, NULL, NULL,0,NULL,Round((l_init_qty/l_txn_sec_uom_ratio),5))
13804: WHERE transaction_temp_id = p_task_id;

Line 13836: DELETE wms_cartonization_temp

13832:
13833: /*
13834:
13835: IF l_init_qty <= 0 THEN
13836: DELETE wms_cartonization_temp
13837: WHERE transaction_temp_id = p_task_id;
13838: END IF;
13839: */
13840: IF (l_debug = 1) THEN

Line 14374: PROCEDURE insert_wct(l_wct_rec wms_cartonization_temp%ROWTYPE) IS

14370: , l_mmtt_rec.fulfillment_base
14371: );
14372: END insert_mmtt;
14373:
14374: PROCEDURE insert_wct(l_wct_rec wms_cartonization_temp%ROWTYPE) IS
14375: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
14376: BEGIN
14377: INSERT INTO wms_cartonization_temp
14378: (

Line 14377: INSERT INTO wms_cartonization_temp

14373:
14374: PROCEDURE insert_wct(l_wct_rec wms_cartonization_temp%ROWTYPE) IS
14375: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
14376: BEGIN
14377: INSERT INTO wms_cartonization_temp
14378: (
14379: transaction_header_id
14380: , transaction_temp_id
14381: , source_code