APPS.INV_LOC_WMS_UTILS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 2214: , wms_license_plate_numbers wlpn

2210: BEGIN
2211: SELECT nvl(sum(wlc.primary_quantity),0) /* Bug 5689378 */
2212: INTO x_quantity
2213: FROM wms_lpn_contents wlc
2214: , wms_license_plate_numbers wlpn
2215: WHERE wlc.parent_lpn_id = wlpn.lpn_id
2216: AND wlpn.outermost_lpn_id = p_lpn_id;
2217: END fetch_lpn_content_qty;
2218:

Line 2552: wms_license_plate_numbers wlpn

2548: wlpn.outermost_lpn_id lpn_id,
2549: TO_NUMBER(NULL) transaction_status
2550: FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ,
2551: mtl_item_locations mil,
2552: wms_license_plate_numbers wlpn
2553: WHERE moq.locator_id = mil.inventory_location_id
2554: AND mil.organization_id = moq.organization_id
2555: AND mil.subinventory_code = moq.subinventory_code
2556: AND nvl(mil.physical_location_id,mil.inventory_location_id) = l_locator_id

Line 6319: FROM wms_license_plate_numbers

6315: l_content_volume,
6316: l_locator_id,
6317: l_subinventory_code,
6318: l_container_item_id
6319: FROM wms_license_plate_numbers
6320: WHERE lpn_id = p_lpn_id;
6321: exception
6322: when no_data_found then
6323: null;

Line 7791: FROM wms_license_plate_numbers WLPN,

7787: ,WLPN.CONTENT_VOLUME_UOM_CODE
7788: ,MIL.VOLUME_UOM_CODE
7789: ,null
7790: ,null),0))),0) content_volume
7791: FROM wms_license_plate_numbers WLPN,
7792: MTL_ITEM_LOCATIONS MIL
7793: WHERE MIL.INVENTORY_LOCATION_ID = WLPN.LOCATOR_ID
7794: AND WLPN.organization_id =p_organization_id
7795: AND WLPN.lpn_context =1

Line 7823: FROM wms_license_plate_numbers WLPN,

7819: ,WLPN.CONTENT_VOLUME_UOM_CODE
7820: ,MIL.VOLUME_UOM_CODE
7821: ,null
7822: ,null),0))),0) content_volume
7823: FROM wms_license_plate_numbers WLPN,
7824: MTL_ITEM_LOCATIONS MIL
7825: WHERE WLPN.LOCATOR_ID = MIL.INVENTORY_LOCATION_ID
7826: AND WLPN.organization_id =p_organization_id
7827: AND WLPN.lpn_context =1