APPS.WMS_LPN_LOVS dependencies on WMS_CONTAINER_PUB

Line 2535: l_lpn WMS_container_pub.LPN;

2531: (p_lpn IN VARCHAR2 ,
2532: p_organization_id IN NUMBER ,
2533: x_result OUT NOCOPY NUMBER)
2534: IS
2535: l_lpn WMS_container_pub.LPN;
2536: l_result NUMBER;
2537:
2538: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2539: BEGIN

Line 2542: l_result := wms_container_pub.Validate_LPN(l_lpn);

2538: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2539: BEGIN
2540: l_lpn.lpn_id := NULL;
2541: l_lpn.license_plate_number := p_lpn;
2542: l_result := wms_container_pub.Validate_LPN(l_lpn);
2543: IF (l_result = INV_Validate.F) THEN
2544: -- LPN was not found
2545: x_result := 2;
2546: ELSE

Line 2739: and lpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV

2735: and lpnc.parent_lpn_id = lpn.lpn_id
2736: and nvl(lpn.SUBINVENTORY_CODE,'@@@') = nvl(p_subinventory_code,'@@@')
2737: and nvl(lpn.LOCATOR_ID, 0) = nvl(p_locator_id, 0)
2738: and lpn.license_plate_number like (p_lpn)
2739: and lpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
2740: and not exists (select null
2741: from wms_lpn_contents
2742: where parent_lpn_id = lpnc.parent_lpn_id
2743: and inventory_item_id <> lpnc.inventory_item_id)

Line 4462: AND wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV

4458: wsh_delivery_details wdd ,
4459: wms_lpn_contents wlc
4460: WHERE wlpn.organization_id = p_organization_id
4461: AND wlpn.lpn_id = wlc.parent_lpn_id
4462: AND wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
4463: AND wlc.source_name IS NOT null
4464: AND wlpn.license_plate_number LIKE (p_lpn_id)
4465: AND wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_organization_id) ='Y'
4466: AND inv_material_status_grp.is_status_applicable (

Line 4520: AND wlpn.lpn_context = WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED

4516:
4517: FROM wms_license_plate_numbers wlpn
4518: WHERE wlpn.organization_id = p_organization_id
4519: AND wlpn.license_plate_number LIKE (p_lpn_id)
4520: AND wlpn.lpn_context = WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED
4521: ORDER BY license_plate_number;
4522:
4523: END Get_Return_Split_To_LPNs;
4524:

Line 4558: AND (wlpn.lpn_context = WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED

4554: NVL(wlpn.content_volume, 0)
4555: FROM wms_license_plate_numbers wlpn
4556: WHERE wlpn.organization_id = p_organization_id
4557: AND wlpn.lpn_id <> p_lpn_id
4558: AND (wlpn.lpn_context = WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED
4559: OR (wlpn.lpn_context = p_lpn_context
4560: AND ( (NOT EXISTS (SELECT 'LPN_HAS_MATERIAL'
4561: FROM wms_lpn_contents
4562: WHERE parent_lpn_id IN (SELECT wlpn1.lpn_id