APPS.WMS_MDC_PVT dependencies on WMS_LPN_CONTENTS

Line 609: FROM wms_lpn_contents wlc

605: IF l_in_staging = 'Y' THEN
606: BEGIN
607: SELECT 'Y'
608: INTO l_loose_exists
609: FROM wms_lpn_contents wlc
610: WHERE wlc.parent_lpn_id = p_to_lpn_id
611: AND ROWNUM =1;
612: EXCEPTION
613: WHEN no_data_found THEN

Line 861: FROM wms_lpn_contents wlc

857: AND wlpn.organization_id = mil.organization_id
858: AND mil.inventory_location_type = 2 -- Staging
859: AND wdth.transfer_lpn_id = wdd.lpn_id
860: AND NOT exists (SELECT 1
861: FROM wms_lpn_contents wlc
862: WHERE wlc.parent_lpn_id = wlpn.outermost_lpn_id)
863: -- above is to check that the outermost lpn being suggested
864: -- does nto have Looase material
865: AND wda.delivery_id = l_from_delivery_id

Line 903: FROM wms_lpn_contents wlc

899: AND wlpn.organization_id = mil.organization_id
900: AND mil.inventory_location_type = 2
901: AND wdth.transfer_lpn_id = wdd.lpn_id
902: AND NOT exists (SELECT 1
903: FROM wms_lpn_contents wlc
904: WHERE wlc.parent_lpn_id = wlpn.outermost_lpn_id)
905: AND wda.delivery_id IN (SELECT l2.delivery_id
906: FROM wsh_delivery_legs l1, --_ob_grp_v l1,
907: wsh_delivery_legs l2 --_ob_grp_v l2

Line 950: FROM wms_lpn_contents wlc

946: AND wlpn.organization_id = mil.organization_id
947: AND mil.inventory_location_type = 2
948: AND wdth.transfer_lpn_id = wdd.lpn_id
949: AND NOT exists (SELECT 1
950: FROM wms_lpn_contents wlc
951: WHERE wlc.parent_lpn_id = wlpn.outermost_lpn_id)
952: AND wda.delivery_id IN (SELECT l2.delivery_id
953: FROM wsh_delivery_legs_ob_grp_v l1
954: , wsh_delivery_legs_ob_grp_v l2