APPS.INV_LOC_WMS_UTILS dependencies on WMS_LPN_CONTENTS
Line 2319: FROM wms_lpn_contents wlc
2315: IS
2316: BEGIN
2317: SELECT nvl(sum(wlc.primary_quantity),0) /* Bug 5689378 */
2318: INTO x_quantity 2319: FROM wms_lpn_contents wlc 2320: , wms_license_plate_numbers wlpn
2321: WHERE wlc.parent_lpn_id = wlpn.lpn_id
2322: AND wlpn.outermost_lpn_id = p_lpn_id;
2323: END fetch_lpn_content_qty;