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 10757: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol

10753: l_move_order_type NUMBER;
10754:
10755: CURSOR task_list IS
10756: SELECT mmtt.transaction_temp_id
10757: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol
10758: WHERE mmtt.move_order_line_id = mol.line_id
10759: AND mol.header_id = p_move_order_header_id;
10760:
10761:

Line 10765: FROM wms_cartonization_temp mmtt

10761:
10762: ---- Patchset J, bulk picking -------------
10763: CURSOR task_list_bulk IS
10764: SELECT mmtt.transaction_temp_id
10765: FROM wms_cartonization_temp mmtt
10766: WHERE
10767: mmtt.parent_line_id is null -- non bulked tasks
10768: OR mmtt.parent_line_id = mmtt.transaction_temp_id; -- parent line only
10769: ---- End of Patchset J, bulk picking -------------

Line 11179: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol

11175: , mmtt.item_lot_control_code
11176: , mmtt.item_serial_control_code
11177: , mmtt.serial_allocated_flag
11178: -- Bug 4584538
11179: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol
11180: WHERE mmtt.move_order_line_id = mol.line_id
11181: AND mol.header_id = p_move_order_header_id
11182: AND mmtt.wms_task_type NOT IN(5, 6)
11183: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation

Line 11274: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol

11270: , mmtt.item_lot_control_code
11271: , mmtt.item_serial_control_code
11272: , mmtt.serial_allocated_flag
11273: -- Bug 4584538
11274: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol
11275: WHERE mmtt.move_order_line_id = mol.line_id
11276: AND mol.header_id = p_move_order_header_id
11277: AND mmtt.wms_task_type NOT IN(5, 6)
11278: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation

Line 11469: INSERT INTO wms_cartonization_temp

11465: print_debug(' --> Serial Control Code => ' || l_serial_control_code, 4);
11466: print_debug(' --> Serial Allocated Flag => ' || l_serial_allocated_flag, 4);
11467: END IF;
11468:
11469: INSERT INTO wms_cartonization_temp
11470: (
11471: transaction_header_id
11472: , transaction_temp_id
11473: , posting_flag

Line 11564: UPDATE wms_cartonization_temp

11560: IF (l_debug = 1) THEN
11561: print_debug('Updating the Parent Line ID of the Tasks Consolidated', 4);
11562: END IF;
11563:
11564: UPDATE wms_cartonization_temp
11565: SET parent_line_id = l_new_txn_temp_id
11566: WHERE transaction_temp_id <> l_new_txn_temp_id
11567: AND inventory_item_id = l_inventory_item_id
11568: AND NVL(revision, '#$%') = NVL(l_revision, NVL(revision, '#$%'))

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

11703: , mmtt.item_primary_uom_code
11704: , mmtt.item_lot_control_code
11705: , mmtt.item_serial_control_code
11706: , mmtt.serial_allocated_flag
11707: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda
11708: WHERE mmtt.move_order_line_id = mol.line_id
11709: -- AND mol.header_id = p_move_order_header_id -- no need since wct only have the records in concerns
11710: AND mol.line_id = wdd.move_ordeR_line_id
11711: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 11782: FROM wms_cartonization_temp mmtt

11778: , mmtt.item_primary_uom_code
11779: , mmtt.item_lot_control_code
11780: , mmtt.item_serial_control_code
11781: , mmtt.serial_allocated_flag
11782: FROM wms_cartonization_temp mmtt
11783: WHERE
11784: mmtt.wms_task_type NOT IN(5, 6)
11785: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation
11786: AND mmtt.cartonization_id is null -- only bulk non_cartoned lines

Line 11858: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol,

11854: , mmtt.item_primary_uom_code
11855: , mmtt.item_lot_control_code
11856: , mmtt.item_serial_control_code
11857: , mmtt.serial_allocated_flag
11858: FROM wms_cartonization_temp mmtt, mtl_txn_request_lines mol,
11859: wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda
11860: WHERE mmtt.move_order_line_id = mol.line_id
11861: AND ( mmtt.serial_allocated_flag = 'N' -- do not bulk serial allocated lines
11862: or mmtt.serial_allocated_flag is null)

Line 11918: FROM wms_cartonization_temp mmtt

11914: , mmtt.item_primary_uom_code
11915: , mmtt.item_lot_control_code
11916: , mmtt.item_serial_control_code
11917: , mmtt.serial_allocated_flag
11918: FROM wms_cartonization_temp mmtt
11919: WHERE mmtt.serial_allocated_flag = 'N' -- do not bulk serial allocated lines
11920: or mmtt.serial_allocated_flag is null
11921: GROUP BY mmtt.inventory_item_id
11922: , mmtt.revision

Line 12202: INSERT INTO wms_cartonization_temp

12198: print_debug(' --> Operation Plan Id => ' || l_operation_plan_id, 4);
12199: print_debug(' --> Task Status => ' || l_wms_task_status, 4);
12200: END IF;
12201:
12202: INSERT INTO wms_cartonization_temp
12203: (
12204: transaction_header_id
12205: , transaction_temp_id
12206: , posting_flag

Line 12282: UPDATE wms_cartonization_temp wct

12278: print_debug('Updating the Parent Line ID of the Tasks Consolidated', 4);
12279: END IF;
12280:
12281: IF l_delivery_flag = 'Y' THEN
12282: UPDATE wms_cartonization_temp wct
12283: SET parent_line_id = l_new_txn_temp_id
12284: WHERE transaction_temp_id <> l_new_txn_temp_id
12285: AND inventory_item_id = l_inventory_item_id
12286: AND NVL(revision, '#$%') = NVL(l_revision, NVL(revision, '#$%'))

Line 12303: UPDATE wms_cartonization_temp

12299: AND mol.line_id = wdd.move_ordeR_line_id
12300: AND wdd.delivery_detail_id = wda.delivery_detail_id
12301: AND NVL(wda.delivery_id,mol.carton_grouping_id) = l_carton_grouping_id);
12302: ELSE
12303: UPDATE wms_cartonization_temp
12304: SET parent_line_id = l_new_txn_temp_id
12305: WHERE transaction_temp_id <> l_new_txn_temp_id
12306: AND inventory_item_id = l_inventory_item_id
12307: AND NVL(revision, '#$%') = NVL(l_revision, NVL(revision, '#$%'))

Line 12488: l_task_rec_old_wct wms_cartonization_temp%ROWTYPE;

12484: l_item_v_uom VARCHAR2(3); -- item unit volume UOM
12485: l_item_w_uom VARCHAR2(3); -- item unit weight UOM
12486: l_eq_it_v_uom_ratio NUMBER := 1; -- conversion rate between equipment volume capacity and item unit volume UOM
12487: l_eq_it_w_uom_ratio NUMBER := 1; -- conversion rate between equipment weight capacity and item weight UOM
12488: l_task_rec_old_wct wms_cartonization_temp%ROWTYPE;
12489: l_task_rec_new_wct wms_cartonization_temp%ROWTYPE;
12490: l_task_rec_old_mmtt mtl_material_transactions_temp%ROWTYPE;
12491: l_task_rec_new_mmtt mtl_material_transactions_temp%ROWTYPE;
12492: l_child_rec_new mtl_material_transactions_temp%ROWTYPE;

Line 12489: l_task_rec_new_wct wms_cartonization_temp%ROWTYPE;

12485: l_item_w_uom VARCHAR2(3); -- item unit weight UOM
12486: l_eq_it_v_uom_ratio NUMBER := 1; -- conversion rate between equipment volume capacity and item unit volume UOM
12487: l_eq_it_w_uom_ratio NUMBER := 1; -- conversion rate between equipment weight capacity and item weight UOM
12488: l_task_rec_old_wct wms_cartonization_temp%ROWTYPE;
12489: l_task_rec_new_wct wms_cartonization_temp%ROWTYPE;
12490: l_task_rec_old_mmtt mtl_material_transactions_temp%ROWTYPE;
12491: l_task_rec_new_mmtt mtl_material_transactions_temp%ROWTYPE;
12492: l_child_rec_new mtl_material_transactions_temp%ROWTYPE;
12493: l_lot_split_rec inv_rcv_common_apis.trans_rec_tb_tp;

Line 12526: , wms_cartonization_temp mmtt

12522: , -- item volume UOM code
12523: item.weight_uom_code item_w_uom -- item weight UOM code
12524: FROM mtl_system_items equip
12525: , mtl_system_items item
12526: , wms_cartonization_temp mmtt
12527: , bom_resource_equipments res_equip
12528: , bom_resources res
12529: , bom_std_op_resources tt_x_res
12530: WHERE mmtt.transaction_temp_id = p_task_id -- the task in question

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

12576:
12577: -- A new cursor will be defined to find all the child tasks ordered by delivery
12578: Cursor c_child_tasks(p_parent_line_id NUMBER) is
12579: Select mmtt.transaction_temp_id,mmtt.transaction_quantity
12580: From wms_cartonization_temp mmtt,mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,
12581: wsh_delivery_assignments_v wda
12582: WHERE mmtt.parent_line_id = p_parent_line_id
12583: And mol.line_id = mmtt.move_order_line_id
12584: and mol.line_id = wdd.move_order_line_id

Line 12616: FROM wms_cartonization_temp

12612: -- Also query the transaction quantity
12613: -- changed for patchset J bulk picking -----------
12614: SELECT *
12615: INTO l_task_rec_old_wct
12616: FROM wms_cartonization_temp
12617: WHERE transaction_temp_id = p_task_id;
12618:
12619: -- get the mmtt rec too, will be used later on, the reason why both wct and mmtt are here is for branching
12620: SELECT *

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

12658: , l_init_qty
12659: , l_item_prim_uom_code
12660: , l_lot_control_code
12661: , l_serial_number_control_code
12662: FROM wms_cartonization_temp mmtt, mtl_item_locations mil, mtl_secondary_inventories msi, mtl_system_items item
12663: WHERE mmtt.transaction_temp_id = p_task_id
12664: AND mmtt.locator_id = mil.inventory_location_id(+)
12665: AND mmtt.organization_id = mil.organization_id(+)
12666: AND mmtt.subinventory_code = msi.secondary_inventory_name

Line 13149: UPDATE wms_cartonization_temp

13145: print_debug('split_task 130 - remove original task: ', 4);
13146: END IF;
13147:
13148: IF ((l_init_qty <= l_split_factor)) THEN
13149: UPDATE wms_cartonization_temp
13150: SET transaction_quantity = l_init_qty
13151: , primary_quantity = l_init_qty * l_txn_pri_uom_ratio
13152: WHERE transaction_temp_id = p_task_id;
13153: -- for patchset J bulk picking -----------

Line 13182: DELETE wms_cartonization_temp

13178:
13179: /*
13180:
13181: IF l_init_qty <= 0 THEN
13182: DELETE wms_cartonization_temp
13183: WHERE transaction_temp_id = p_task_id;
13184: END IF;
13185: */
13186: IF (l_debug = 1) THEN

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

13714: , l_mmtt_rec.move_order_header_id
13715: );
13716: END insert_mmtt;
13717:
13718: PROCEDURE insert_wct(l_wct_rec wms_cartonization_temp%ROWTYPE) IS
13719: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
13720: BEGIN
13721: INSERT INTO wms_cartonization_temp
13722: (

Line 13721: INSERT INTO wms_cartonization_temp

13717:
13718: PROCEDURE insert_wct(l_wct_rec wms_cartonization_temp%ROWTYPE) IS
13719: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
13720: BEGIN
13721: INSERT INTO wms_cartonization_temp
13722: (
13723: transaction_header_id
13724: , transaction_temp_id
13725: , source_code