eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LOC_WMS_PUB dependencies on MTL_SECONDARY_LOCATORS

Line 2093: /* Check if this combination of Org, Item and Locator is present in MTL_SECONDARY_LOCATORS */

2089: /* The Locator segments are invalid for the given subinventory, organization combination */
2090: RAISE fnd_api.g_exc_error;
2091: END;
2092:
2093: /* Check if this combination of Org, Item and Locator is present in MTL_SECONDARY_LOCATORS */
2094: BEGIN
2095: SELECT 'Y'
2096: INTO l_locator_exists
2097: FROM mtl_secondary_locators

Line 2097: FROM mtl_secondary_locators

2093: /* Check if this combination of Org, Item and Locator is present in MTL_SECONDARY_LOCATORS */
2094: BEGIN
2095: SELECT 'Y'
2096: INTO l_locator_exists
2097: FROM mtl_secondary_locators
2098: WHERE secondary_locator = l_locator_id
2099: AND organization_id = l_organization_id
2100: AND inventory_item_id = l_inventory_item_id;
2101: EXCEPTION

Line 2155: /* If the l_locator_flag is N then insert a row into MTL_SECONDARY_LOCATORS */

2151: , 6
2152: );
2153: END;
2154:
2155: /* If the l_locator_flag is N then insert a row into MTL_SECONDARY_LOCATORS */
2156: IF l_locator_exists = 'N' THEN
2157: IF (inv_control.g_current_release_level >= inv_release.g_j_release_level) THEN
2158: INSERT INTO mtl_secondary_locators
2159: (

Line 2158: INSERT INTO mtl_secondary_locators

2154:
2155: /* If the l_locator_flag is N then insert a row into MTL_SECONDARY_LOCATORS */
2156: IF l_locator_exists = 'N' THEN
2157: IF (inv_control.g_current_release_level >= inv_release.g_j_release_level) THEN
2158: INSERT INTO mtl_secondary_locators
2159: (
2160: inventory_item_id
2161: , organization_id
2162: , secondary_locator

Line 2184: INSERT INTO mtl_secondary_locators

2180: , p_status_id
2181: , DECODE(l_planning_level, 1, p_par_level, NULL)
2182: );
2183: ELSE
2184: INSERT INTO mtl_secondary_locators
2185: (
2186: inventory_item_id
2187: , organization_id
2188: , secondary_locator

Line 2484: /*Check if the locator is present in MTL_SECONDARY_LOCATORS

2480: WHEN NO_DATA_FOUND THEN
2481: NULL;
2482: END;
2483:
2484: /*Check if the locator is present in MTL_SECONDARY_LOCATORS
2485: If the SECONDARY_LOCATOR exists then error out*/
2486: BEGIN
2487: SELECT 1
2488: INTO l_chk_flag

Line 2491: FROM mtl_secondary_locators

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);
2494:
2495: fnd_message.set_name('INV', 'INV_LOC_ITEMTIE');