APPS.INV_LOC_WMS_UTILS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 2320: , wms_license_plate_numbers wlpn

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;
2324:

Line 2638: ,wms_license_plate_numbers wlpn

2634: ,mil2.max_cubic_area
2635: FROM mtl_onhand_quantities_detail moq
2636: ,mtl_item_locations mil
2637: ,mtl_item_locations mil2
2638: ,wms_license_plate_numbers wlpn
2639: WHERE moq.locator_id = mil.inventory_location_id
2640: AND mil.organization_id = moq.organization_id
2641: AND mil.subinventory_code = moq.subinventory_code
2642: AND (l_locator_id IS NULL OR nvl(mil.physical_location_id,mil.inventory_location_id) = l_locator_id)

Line 6747: FROM wms_license_plate_numbers

6743: l_content_volume,
6744: l_locator_id,
6745: l_subinventory_code,
6746: l_container_item_id
6747: FROM wms_license_plate_numbers
6748: WHERE lpn_id = p_lpn_id;
6749: exception
6750: when no_data_found then
6751: null;

Line 8311: FROM wms_license_plate_numbers WLPN,

8307: ,WLPN.CONTENT_VOLUME_UOM_CODE
8308: ,MIL.VOLUME_UOM_CODE
8309: ,null
8310: ,null),0))),0) content_volume
8311: FROM wms_license_plate_numbers WLPN,
8312: MTL_ITEM_LOCATIONS MIL
8313: WHERE MIL.INVENTORY_LOCATION_ID = WLPN.LOCATOR_ID
8314: AND WLPN.organization_id =p_organization_id
8315: AND WLPN.lpn_context =1

Line 8343: FROM wms_license_plate_numbers WLPN,

8339: ,WLPN.CONTENT_VOLUME_UOM_CODE
8340: ,MIL.VOLUME_UOM_CODE
8341: ,null
8342: ,null),0))),0) content_volume
8343: FROM wms_license_plate_numbers WLPN,
8344: MTL_ITEM_LOCATIONS MIL
8345: WHERE WLPN.LOCATOR_ID = MIL.INVENTORY_LOCATION_ID
8346: AND WLPN.organization_id =p_organization_id
8347: AND WLPN.lpn_context =1