APPS.INV_TXN_VALIDATIONS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 1791: from wms_license_plate_numbers

1787: x_return VARCHAR2(1) := 'Y';
1788:
1789: CURSOR c_lpn_content IS
1790: select lpn_id
1791: from wms_license_plate_numbers
1792: where outermost_lpn_id = p_lpn_id
1793: and organization_id = p_org_id;
1794:
1795: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 1847: from wms_license_plate_numbers

1843: x_return VARCHAR2(1) := 'Y';
1844:
1845: CURSOR c_lpn_content IS
1846: select lpn_id
1847: from wms_license_plate_numbers
1848: where outermost_lpn_id = p_lpn_id
1849: and organization_id = p_org_id;
1850:
1851: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 1902: from wms_license_plate_numbers

1898: x_return VARCHAR2(1) := 'Y';
1899:
1900: CURSOR c_lpn_content IS
1901: select lpn_id
1902: from wms_license_plate_numbers
1903: where outermost_lpn_id = p_lpn_id
1904: and organization_id = p_org_id;
1905:
1906: CURSOR c_lpn_serial(p_lpnid NUMBER) IS

Line 2111: From wsh_delivery_details wdd, wms_license_plate_numbers wlpn

2107:
2108: if( l_action_id = INV_GLOBALS.G_Action_Subxfr ) then
2109: select count(wdd.delivery_detail_id)
2110: into l_count
2111: From wsh_delivery_details wdd, wms_license_plate_numbers wlpn
2112: WHere wdd.lpn_id = wlpn.lpn_id
2113: and wlpn.lpn_context = wms_Container_pub.LPN_Context_Picked
2114: and wlpn.lpn_id = p_lpn_id
2115: and wdd.released_status = 'X'; -- For LPN reuse ER : 6845650

Line 2359: wms_license_plate_numbers wlpn

2355: --SUM(wlc.quantity) sumqty, lpn reservation change
2356: wlc.revision,
2357: wlpn.lpn_context, wlc.lot_number
2358: FROM wms_lpn_contents wlc,
2359: wms_license_plate_numbers wlpn
2360: WHERE wlpn.outermost_lpn_id = p_lpn_id
2361: AND wlpn.organization_id = p_organization_id
2362: AND wlc.parent_lpn_id = wlpn.lpn_id
2363: GROUP BY wlc.parent_lpn_id, wlc.inventory_item_id, wlc.revision, wlpn.lpn_context,wlc.lot_number ;

Line 2383: -- wms_license_plate_numbers wlpn

2379: -- OPTIMIZED BELOW FOR PERFORMANCE MXGUPTA JUNE 4 2001
2380: -- SELECT DISTINCT wlpn.subinventory_code, wlpn.locator_id
2381: -- INTO l_subinventory_code, l_locator_id
2382: -- FROM wms_lpn_contents wlc,
2383: -- wms_license_plate_numbers wlpn
2384: -- WHERE wlpn.organization_id = p_organization_id
2385: -- AND wlpn.outermost_lpn_id = p_lpn_id
2386: -- AND wlc.parent_lpn_id = wlpn.lpn_id;
2387:

Line 2390: FROM wms_license_plate_numbers

2386: -- AND wlc.parent_lpn_id = wlpn.lpn_id;
2387:
2388: SELECT DISTINCT subinventory_code, locator_id
2389: INTO l_subinventory_code, l_locator_id
2390: FROM wms_license_plate_numbers
2391: WHERE organization_id = p_organization_id
2392: AND lpn_id = p_lpn_id;
2393:
2394: OPEN l_item_cursor;

Line 2591: wms_license_plate_numbers wlpn

2587: -- SUM(wlc.quantity) sumqty,
2588: wlc.revision,
2589: wlpn.lpn_context, wlc.lot_number
2590: FROM wms_lpn_contents wlc,
2591: wms_license_plate_numbers wlpn
2592: WHERE wlpn.outermost_lpn_id = p_lpn_id
2593: AND wlpn.organization_id = p_organization_id
2594: AND wlc.parent_lpn_id = wlpn.lpn_id
2595: GROUP BY wlc.parent_lpn_id, wlc.inventory_item_id, wlc.revision, wlpn.lpn_context,wlc.lot_number ;

Line 2619: -- wms_license_plate_numbers wlpn

2615: -- OPTIMIZED BELOW FOR PERFORMANCE MXGUPTA JUNE 4 2001
2616: -- SELECT DISTINCT wlpn.subinventory_code, wlpn.locator_id
2617: -- INTO l_subinventory_code, l_locator_id
2618: -- FROM wms_lpn_contents wlc,
2619: -- wms_license_plate_numbers wlpn
2620: -- WHERE wlpn.organization_id = p_organization_id
2621: -- AND wlpn.outermost_lpn_id = p_lpn_id
2622: -- AND wlc.parent_lpn_id = wlpn.lpn_id;
2623:

Line 2628: FROM wms_license_plate_numbers

2624: --mdebug ('l Tree mode' || l_tree_mode);
2625:
2626: SELECT DISTINCT subinventory_code, locator_id
2627: INTO l_subinventory_code, l_locator_id
2628: FROM wms_license_plate_numbers
2629: WHERE organization_id = p_organization_id
2630: AND lpn_id = p_lpn_id;
2631:
2632: OPEN l_item_cursor;

Line 4546: from wms_license_plate_numbers

4542: x_return VARCHAR2(1) := 'Y';
4543:
4544: CURSOR c_lpn_content IS
4545: select lpn_id
4546: from wms_license_plate_numbers
4547: where outermost_lpn_id = p_lpn_id
4548: and organization_id = p_org_id;
4549:
4550: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);