APPS.WMS_MDC_PVT dependencies on WMS_LPN_CONTENTS

Line 646: FROM wms_lpn_contents wlc

642: IF l_in_staging = 'Y' THEN
643: BEGIN
644: SELECT 'Y'
645: INTO l_loose_exists
646: FROM wms_lpn_contents wlc
647: WHERE wlc.parent_lpn_id = p_to_lpn_id
648: AND ROWNUM =1;
649: EXCEPTION
650: WHEN no_data_found THEN

Line 898: FROM wms_lpn_contents wlc

894: AND wlpn.organization_id = mil.organization_id
895: AND mil.inventory_location_type = 2 -- Staging
896: AND wdth.transfer_lpn_id = wdd.lpn_id
897: AND NOT exists (SELECT 1
898: FROM wms_lpn_contents wlc
899: WHERE wlc.parent_lpn_id = wlpn.outermost_lpn_id)
900: -- above is to check that the outermost lpn being suggested
901: -- does nto have Looase material
902: AND wda.delivery_id = l_from_delivery_id

Line 940: FROM wms_lpn_contents wlc

936: AND wlpn.organization_id = mil.organization_id
937: AND mil.inventory_location_type = 2
938: AND wdth.transfer_lpn_id = wdd.lpn_id
939: AND NOT exists (SELECT 1
940: FROM wms_lpn_contents wlc
941: WHERE wlc.parent_lpn_id = wlpn.outermost_lpn_id)
942: AND wda.delivery_id IN (SELECT l2.delivery_id
943: FROM wsh_delivery_legs l1, --_ob_grp_v l1,
944: wsh_delivery_legs l2 --_ob_grp_v l2

Line 987: FROM wms_lpn_contents wlc

983: AND wlpn.organization_id = mil.organization_id
984: AND mil.inventory_location_type = 2
985: AND wdth.transfer_lpn_id = wdd.lpn_id
986: AND NOT exists (SELECT 1
987: FROM wms_lpn_contents wlc
988: WHERE wlc.parent_lpn_id = wlpn.outermost_lpn_id)
989: AND wda.delivery_id IN (SELECT l2.delivery_id
990: FROM wsh_delivery_legs_ob_grp_v l1
991: , wsh_delivery_legs_ob_grp_v l2