[Home] [Help]
702: '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, '||
703: 'mol.secondary_quantity -NVL(mol.secondary_quantity_delivered,0) secondary_quantity, mol.secondary_uom_code, mol.grade_code'; --INCONV kkillams
704:
705: l_from_str VARCHAR2(2000) :=
706: ' FROM mtl_txn_request_lines mol, mtl_txn_request_headers moh, wms_license_plate_numbers lpn ';
707:
708: -- Bug 3802897
709: -- Make sure the available quantity is greater than 0
710: l_where_str VARCHAR2(2000) :=
3048: , mol.secondary_uom_code --INVCONV kkillams
3049: , wpmg.grade_code --INVCONV kkillams
3050: , mol.lot_number
3051: , mol.inspection_status
3052: FROM wms_packing_material_gtemp wpmg, mtl_txn_request_lines mol
3053: WHERE wpmg.move_order_line_id = mol.line_id
3054: AND wpmg.organization_id = p_organization_id
3055: AND nvl(wpmg.subinventory,'#$%') = nvl(p_subinventory_code, nvl(wpmg.subinventory,'#$%'))
3056: AND nvl(wpmg.locator_id, -9999) = nvl(p_locator_id, nvl(wpmg.locator_id, -9999))
3894:
3895: END IF;
3896: -- Mark WMS_PROCESS_FLAG for the move order line
3897: BEGIN
3898: UPDATE mtl_txn_request_lines
3899: SET WMS_PROCESS_FLAG = 2
3900: WHERE line_id = l_mol_list(i).move_order_line_id;
3901: EXCEPTION
3902: WHEN others THEN