[Home] [Help]
739: , milkfv.inventory_location_id locator_id
740: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id, milkfv.organization_id) locator
741: , sum(nvl(l_secondary_transaction_qty,wlc.secondary_quantity)) secondary_quantity -- invconv fabdi
742: , wlc.secondary_uom_code secondary_uom -- invconv fabdi
743: FROM wms_lpn_contents wlc
744: , wms_license_plate_numbers plpn
745: , cst_cost_groups ccg
746: , mtl_item_locations milkfv
747: -- Bug 4137707, Do not need to include this where clause,
812: AND milkfv.subinventory_code(+) = nvl(l_subinventory_code, plpn.subinventory_code)
813: AND milkfv.inventory_location_id(+) = nvl(l_locator_id, plpn.locator_id)
814: AND ccg.cost_group_id (+) = nvl(p_cost_group_id, mmtt.cost_group_id)
815: AND mmtt.transaction_temp_id = p_transaction_id
816: AND NOT EXISTS (SELECT 1 from wms_lpn_contents wlc where wlc.parent_lpn_id=p_lpn_id)
817: GROUP BY
818: nvl(p_organization_id, plpn.organization_id)
819: , nvl(p_inventory_item_id, mmtt.inventory_item_id)
820: , nvl(p_revision, mmtt.revision)
2176: END ;
2177: END IF;
2178: ELSE -- for manual
2179: select count(1) into l_count
2180: from wms_lpn_contents
2181: where parent_lpn_id = l_lpn_id;
2182: if l_count = 0 then
2183: l_query_moqd := -1;--wlc is not there so not checkin for status for manual driven
2184: END IF;