APPS.INV_TXN_VALIDATIONS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 1944: from wms_license_plate_numbers

1940: x_return VARCHAR2(1) := 'Y';
1941:
1942: CURSOR c_lpn_content IS
1943: select lpn_id
1944: from wms_license_plate_numbers
1945: where outermost_lpn_id = p_lpn_id
1946: and organization_id = p_org_id;
1947:
1948: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 2000: from wms_license_plate_numbers

1996: x_return VARCHAR2(1) := 'Y';
1997:
1998: CURSOR c_lpn_content IS
1999: select lpn_id
2000: from wms_license_plate_numbers
2001: where outermost_lpn_id = p_lpn_id
2002: and organization_id = p_org_id;
2003:
2004: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 2055: from wms_license_plate_numbers

2051: x_return VARCHAR2(1) := 'Y';
2052:
2053: CURSOR c_lpn_content IS
2054: select lpn_id
2055: from wms_license_plate_numbers
2056: where outermost_lpn_id = p_lpn_id
2057: and organization_id = p_org_id;
2058:
2059: CURSOR c_lpn_serial(p_lpnid NUMBER) IS

Line 2138: from wms_license_plate_numbers

2134: x_return VARCHAR2(1) := 'Y';
2135:
2136: CURSOR c_lpn_content IS
2137: select lpn_id
2138: from wms_license_plate_numbers
2139: where outermost_lpn_id = p_lpn_id
2140: and organization_id = p_org_id;
2141:
2142: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 2163: FROM wms_license_plate_numbers

2159:
2160: if l_cnt >=1 then
2161: SELECT license_plate_number
2162: INTO l_lpn_number
2163: FROM wms_license_plate_numbers
2164: WHERE lpn_id=p_lpn_id;
2165:
2166: IF (l_debug = 1) THEN
2167: mdebug ('LPN '||l_lpn_number||' has contents which are part of a loaded task.');

Line 2337: From wsh_delivery_details wdd, wms_license_plate_numbers wlpn

2333:
2334: if( l_action_id = INV_GLOBALS.G_Action_Subxfr ) then
2335: select count(wdd.delivery_detail_id)
2336: into l_count
2337: From wsh_delivery_details wdd, wms_license_plate_numbers wlpn
2338: WHere wdd.lpn_id = wlpn.lpn_id
2339: and wlpn.lpn_context = wms_Container_pub.LPN_Context_Picked
2340: and wlpn.lpn_id = p_lpn_id
2341: and wdd.released_status = 'X'; -- For LPN reuse ER : 6845650

Line 2613: wms_license_plate_numbers wlpn

2609: --SUM(wlc.quantity) sumqty, lpn reservation change
2610: wlc.revision,
2611: wlpn.lpn_context, wlc.lot_number
2612: FROM wms_lpn_contents wlc,
2613: wms_license_plate_numbers wlpn
2614: WHERE wlpn.outermost_lpn_id = p_lpn_id
2615: AND wlpn.organization_id = p_organization_id
2616: AND wlc.parent_lpn_id = wlpn.lpn_id
2617: GROUP BY wlc.parent_lpn_id, wlc.inventory_item_id, wlc.revision, wlpn.lpn_context,wlc.lot_number ;

Line 2637: -- wms_license_plate_numbers wlpn

2633: -- OPTIMIZED BELOW FOR PERFORMANCE MXGUPTA JUNE 4 2001
2634: -- SELECT DISTINCT wlpn.subinventory_code, wlpn.locator_id
2635: -- INTO l_subinventory_code, l_locator_id
2636: -- FROM wms_lpn_contents wlc,
2637: -- wms_license_plate_numbers wlpn
2638: -- WHERE wlpn.organization_id = p_organization_id
2639: -- AND wlpn.outermost_lpn_id = p_lpn_id
2640: -- AND wlc.parent_lpn_id = wlpn.lpn_id;
2641:

Line 2644: FROM wms_license_plate_numbers

2640: -- AND wlc.parent_lpn_id = wlpn.lpn_id;
2641:
2642: SELECT DISTINCT subinventory_code, locator_id
2643: INTO l_subinventory_code, l_locator_id
2644: FROM wms_license_plate_numbers
2645: WHERE organization_id = p_organization_id
2646: AND lpn_id = p_lpn_id;
2647:
2648: OPEN l_item_cursor;

Line 2846: wms_license_plate_numbers wlpn

2842: -- SUM(wlc.quantity) sumqty,
2843: wlc.revision,
2844: wlpn.lpn_context, wlc.lot_number
2845: FROM wms_lpn_contents wlc,
2846: wms_license_plate_numbers wlpn
2847: WHERE wlpn.outermost_lpn_id = p_lpn_id
2848: AND wlpn.organization_id = p_organization_id
2849: AND wlc.parent_lpn_id = wlpn.lpn_id
2850: GROUP BY wlc.parent_lpn_id, wlc.inventory_item_id, wlc.revision, wlpn.lpn_context,wlc.lot_number ;

Line 2874: -- wms_license_plate_numbers wlpn

2870: -- OPTIMIZED BELOW FOR PERFORMANCE MXGUPTA JUNE 4 2001
2871: -- SELECT DISTINCT wlpn.subinventory_code, wlpn.locator_id
2872: -- INTO l_subinventory_code, l_locator_id
2873: -- FROM wms_lpn_contents wlc,
2874: -- wms_license_plate_numbers wlpn
2875: -- WHERE wlpn.organization_id = p_organization_id
2876: -- AND wlpn.outermost_lpn_id = p_lpn_id
2877: -- AND wlc.parent_lpn_id = wlpn.lpn_id;
2878:

Line 2883: FROM wms_license_plate_numbers

2879: --mdebug ('l Tree mode' || l_tree_mode);
2880:
2881: SELECT DISTINCT subinventory_code, locator_id
2882: INTO l_subinventory_code, l_locator_id
2883: FROM wms_license_plate_numbers
2884: WHERE organization_id = p_organization_id
2885: AND lpn_id = p_lpn_id;
2886:
2887: -- Bug 13878269

Line 4825: from wms_license_plate_numbers

4821: x_return VARCHAR2(1) := 'Y';
4822:
4823: CURSOR c_lpn_content IS
4824: select lpn_id
4825: from wms_license_plate_numbers
4826: where outermost_lpn_id = p_lpn_id
4827: and organization_id = p_org_id;
4828:
4829: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);