APPS.INV_LOC_WMS_PUB dependencies on DUAL

Line 815: FROM DUAL

811: BEGIN
812: -- Bug 5856723 Slight performance improvement for checking validity of locator
813: /* SELECT 'FAILED'
814: INTO l_validity_check
815: FROM DUAL
816: WHERE EXISTS( */
817:
818: SELECT subinventory_code
819: INTO l_subinventory_code

Line 2298: FROM DUAL

2294: Non null organisation_code passed */
2295: IF p_organization_id IS NOT NULL THEN
2296: SELECT 1
2297: INTO l_chk_org
2298: FROM DUAL
2299: WHERE EXISTS(SELECT 1
2300: FROM mtl_parameters
2301: WHERE organization_id = p_organization_id);
2302:

Line 2328: FROM DUAL

2324: */
2325: IF p_inventory_location_id IS NOT NULL THEN
2326: SELECT 1
2327: INTO l_chk_loc
2328: FROM DUAL
2329: WHERE EXISTS(SELECT 1
2330: FROM mtl_item_locations
2331: WHERE inventory_location_id = p_inventory_location_id
2332: AND organization_id = l_organization_id);

Line 2373: FROM DUAL

2369: */
2370: BEGIN
2371: SELECT 1
2372: INTO l_physical_locator_id
2373: FROM DUAL
2374: WHERE EXISTS(SELECT 1
2375: FROM mtl_item_locations
2376: WHERE physical_location_id = l_inventory_location_id
2377: AND organization_id = l_organization_id

Line 2425: FROM DUAL

2421: If the locator_id exists then error out*/
2422: BEGIN
2423: SELECT 1
2424: INTO l_chk_flag
2425: FROM DUAL
2426: WHERE EXISTS(SELECT 1
2427: FROM mtl_onhand_quantities_detail
2428: WHERE locator_id = l_inventory_location_id
2429: AND organization_id = l_organization_id);

Line 2447: FROM DUAL

2443: */
2444: BEGIN
2445: SELECT 1
2446: INTO l_chk_flag
2447: FROM DUAL
2448: WHERE EXISTS(SELECT 1
2449: FROM mtl_reservations
2450: WHERE locator_id = l_inventory_location_id
2451: AND organization_id = l_organization_id);

Line 2468: FROM DUAL

2464: If the LOCATOR_ID exists then error out*/
2465: BEGIN
2466: SELECT 1
2467: INTO l_chk_flag
2468: FROM DUAL
2469: WHERE EXISTS(SELECT 1
2470: FROM wms_license_plate_numbers
2471: WHERE locator_id = l_inventory_location_id
2472: AND organization_id = l_organization_id);

Line 2489: FROM DUAL

2485: If the SECONDARY_LOCATOR exists then error out*/
2486: BEGIN
2487: SELECT 1
2488: INTO l_chk_flag
2489: FROM DUAL
2490: WHERE EXISTS(SELECT 1
2491: FROM mtl_secondary_locators
2492: WHERE secondary_locator = l_inventory_location_id
2493: AND organization_id = l_organization_id);

Line 2510: FROM DUAL

2506: If the locator_id exists then error out*/
2507: BEGIN
2508: SELECT 1
2509: INTO l_chk_flag
2510: FROM DUAL
2511: WHERE EXISTS(SELECT 1
2512: FROM mtl_transactions_interface
2513: WHERE locator_id = l_inventory_location_id
2514: AND organization_id = l_organization_id);

Line 2534: FROM DUAL

2530: as a part of the Bug Fix:2004798*/
2531: BEGIN
2532: SELECT 1
2533: INTO l_chk_flag
2534: FROM DUAL
2535: WHERE EXISTS(
2536: SELECT 1
2537: FROM mtl_material_transactions_temp
2538: WHERE (locator_id = l_inventory_location_id

Line 2558: FROM DUAL

2554: if the locator exists then error out*/
2555: BEGIN
2556: SELECT 1
2557: INTO l_chk_flag
2558: FROM DUAL
2559: WHERE EXISTS(SELECT 1
2560: FROM rcv_transactions_interface
2561: WHERE locator_id = l_inventory_location_id
2562: AND to_organization_id = l_organization_id);