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_PACKING_WORKBENCH_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 763: ' FROM mtl_txn_request_lines mol, mtl_txn_request_headers moh, wms_license_plate_numbers lpn ';

759: 'mol.inventory_item_id inventory_item_id, :item item, mol.lpn_id lpn_id, mol.revision revision, mol.uom_code uom, mol.quantity-nvl(mol.quantity_delivered,0) quantity, mol.lot_number, '||
760: 'mol.secondary_quantity -NVL(mol.secondary_quantity_delivered,0) secondary_quantity, mol.secondary_uom_code, mol.grade_code'; --INCONV kkillams
761:
762: l_from_str VARCHAR2(2000) :=
763: ' FROM mtl_txn_request_lines mol, mtl_txn_request_headers moh, wms_license_plate_numbers lpn ';
764:
765: -- Bug 3802897
766: -- Make sure the available quantity is greater than 0
767: l_where_str VARCHAR2(2000) :=

Line 3125: FROM wms_packing_material_gtemp wpmg, mtl_txn_request_lines mol

3121: , mol.secondary_uom_code --INVCONV kkillams
3122: , wpmg.grade_code --INVCONV kkillams
3123: , mol.lot_number
3124: , mol.inspection_status
3125: FROM wms_packing_material_gtemp wpmg, mtl_txn_request_lines mol
3126: WHERE wpmg.move_order_line_id = mol.line_id
3127: AND wpmg.organization_id = p_organization_id
3128: AND nvl(wpmg.subinventory,'#$%') = nvl(p_subinventory_code, nvl(wpmg.subinventory,'#$%'))
3129: AND nvl(wpmg.locator_id, -9999) = nvl(p_locator_id, nvl(wpmg.locator_id, -9999))

Line 3161: FROM wms_packing_material_gtemp wpmg, mtl_txn_request_lines mol

3157: , mol.secondary_uom_code --INVCONV kkillams
3158: , wpmg.grade_code --INVCONV kkillams
3159: , mol.lot_number
3160: , mol.inspection_status
3161: FROM wms_packing_material_gtemp wpmg, mtl_txn_request_lines mol
3162: WHERE wpmg.move_order_line_id = mol.line_id
3163: AND wpmg.organization_id = p_organization_id
3164: AND nvl(wpmg.subinventory,'#$%') = nvl(p_subinventory_code, nvl(wpmg.subinventory,'#$%'))
3165: AND nvl(wpmg.locator_id, -9999) = nvl(p_locator_id, nvl(wpmg.locator_id, -9999))

Line 3203: FROM wms_packing_material_gtemp wpmg, mtl_txn_request_lines mol

3199: , mol.secondary_uom_code --INVCONV kkillams
3200: , wpmg.grade_code --INVCONV kkillams
3201: , mol.lot_number
3202: , mol.inspection_status
3203: FROM wms_packing_material_gtemp wpmg, mtl_txn_request_lines mol
3204: WHERE wpmg.move_order_line_id = mol.line_id
3205: AND wpmg.organization_id = p_organization_id
3206: AND nvl(wpmg.subinventory,'#$%') = nvl(p_subinventory_code, nvl(wpmg.subinventory,'#$%'))
3207: AND nvl(wpmg.locator_id, -9999) = nvl(p_locator_id, nvl(wpmg.locator_id, -9999))

Line 4064: UPDATE mtl_txn_request_lines

4060:
4061: END IF;
4062: -- Mark WMS_PROCESS_FLAG for the move order line
4063: BEGIN
4064: UPDATE mtl_txn_request_lines
4065: SET WMS_PROCESS_FLAG = 2
4066: WHERE line_id = l_mol_list(i).move_order_line_id;
4067: EXCEPTION
4068: WHEN others THEN