APPS.INV_LOC_WMS_PUB dependencies on DUAL

Line 873: FROM DUAL

869: BEGIN
870: -- Bug 5856723 Slight performance improvement for checking validity of locator
871: /* SELECT 'FAILED'
872: INTO l_validity_check
873: FROM DUAL
874: WHERE EXISTS( */
875:
876:
877:

Line 2394: FROM DUAL

2390: Non null organisation_code passed */
2391: IF p_organization_id IS NOT NULL THEN
2392: SELECT 1
2393: INTO l_chk_org
2394: FROM DUAL
2395: WHERE EXISTS(SELECT 1
2396: FROM mtl_parameters
2397: WHERE organization_id = p_organization_id);
2398:

Line 2424: FROM DUAL

2420: */
2421: IF p_inventory_location_id IS NOT NULL THEN
2422: SELECT 1
2423: INTO l_chk_loc
2424: FROM DUAL
2425: WHERE EXISTS(SELECT 1
2426: FROM mtl_item_locations
2427: WHERE inventory_location_id = p_inventory_location_id
2428: AND organization_id = l_organization_id);

Line 2469: FROM DUAL

2465: */
2466: BEGIN
2467: SELECT 1
2468: INTO l_physical_locator_id
2469: FROM DUAL
2470: WHERE EXISTS(SELECT 1
2471: FROM mtl_item_locations
2472: WHERE physical_location_id = l_inventory_location_id
2473: AND organization_id = l_organization_id

Line 2521: FROM DUAL

2517: If the locator_id exists then error out*/
2518: BEGIN
2519: SELECT 1
2520: INTO l_chk_flag
2521: FROM DUAL
2522: WHERE EXISTS(SELECT 1
2523: FROM mtl_onhand_quantities_detail
2524: WHERE locator_id = l_inventory_location_id
2525: AND organization_id = l_organization_id);

Line 2543: FROM DUAL

2539: */
2540: BEGIN
2541: SELECT 1
2542: INTO l_chk_flag
2543: FROM DUAL
2544: WHERE EXISTS(SELECT 1
2545: FROM mtl_reservations
2546: WHERE locator_id = l_inventory_location_id
2547: AND organization_id = l_organization_id);

Line 2564: FROM DUAL

2560: If the LOCATOR_ID exists then error out*/
2561: BEGIN
2562: SELECT 1
2563: INTO l_chk_flag
2564: FROM DUAL
2565: WHERE EXISTS(SELECT 1
2566: FROM wms_license_plate_numbers
2567: WHERE locator_id = l_inventory_location_id
2568: AND organization_id = l_organization_id);

Line 2585: FROM DUAL

2581: If the SECONDARY_LOCATOR exists then error out*/
2582: BEGIN
2583: SELECT 1
2584: INTO l_chk_flag
2585: FROM DUAL
2586: WHERE EXISTS(SELECT 1
2587: FROM mtl_secondary_locators
2588: WHERE secondary_locator = l_inventory_location_id
2589: AND organization_id = l_organization_id);

Line 2606: FROM DUAL

2602: If the locator_id exists then error out*/
2603: BEGIN
2604: SELECT 1
2605: INTO l_chk_flag
2606: FROM DUAL
2607: WHERE EXISTS(SELECT 1
2608: FROM mtl_transactions_interface
2609: WHERE locator_id = l_inventory_location_id
2610: AND organization_id = l_organization_id);

Line 2630: FROM DUAL

2626: as a part of the Bug Fix:2004798*/
2627: BEGIN
2628: SELECT 1
2629: INTO l_chk_flag
2630: FROM DUAL
2631: WHERE EXISTS(
2632: SELECT 1
2633: FROM mtl_material_transactions_temp
2634: WHERE (locator_id = l_inventory_location_id

Line 2654: FROM DUAL

2650: if the locator exists then error out*/
2651: BEGIN
2652: SELECT 1
2653: INTO l_chk_flag
2654: FROM DUAL
2655: WHERE EXISTS(SELECT 1
2656: FROM rcv_transactions_interface
2657: WHERE locator_id = l_inventory_location_id
2658: AND to_organization_id = l_organization_id);