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 2189: /* Check if this combination of Org, Item and Locator is present in MTL_SECONDARY_LOCATORS */

2185: /* The Locator segments are invalid for the given subinventory, organization combination */
2186: RAISE fnd_api.g_exc_error;
2187: END;
2188:
2189: /* Check if this combination of Org, Item and Locator is present in MTL_SECONDARY_LOCATORS */
2190: BEGIN
2191: SELECT 'Y'
2192: INTO l_locator_exists
2193: FROM mtl_secondary_locators

Line 2193: FROM mtl_secondary_locators

2189: /* Check if this combination of Org, Item and Locator is present in MTL_SECONDARY_LOCATORS */
2190: BEGIN
2191: SELECT 'Y'
2192: INTO l_locator_exists
2193: FROM mtl_secondary_locators
2194: WHERE secondary_locator = l_locator_id
2195: AND organization_id = l_organization_id
2196: AND inventory_item_id = l_inventory_item_id;
2197: EXCEPTION

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

2247: , 6
2248: );
2249: END;
2250:
2251: /* If the l_locator_flag is N then insert a row into MTL_SECONDARY_LOCATORS */
2252: IF l_locator_exists = 'N' THEN
2253: IF (inv_control.g_current_release_level >= inv_release.g_j_release_level) THEN
2254: INSERT INTO mtl_secondary_locators
2255: (

Line 2254: INSERT INTO mtl_secondary_locators

2250:
2251: /* If the l_locator_flag is N then insert a row into MTL_SECONDARY_LOCATORS */
2252: IF l_locator_exists = 'N' THEN
2253: IF (inv_control.g_current_release_level >= inv_release.g_j_release_level) THEN
2254: INSERT INTO mtl_secondary_locators
2255: (
2256: inventory_item_id
2257: , organization_id
2258: , secondary_locator

Line 2280: INSERT INTO mtl_secondary_locators

2276: , p_status_id
2277: , DECODE(l_planning_level, 1, p_par_level, NULL)
2278: );
2279: ELSE
2280: INSERT INTO mtl_secondary_locators
2281: (
2282: inventory_item_id
2283: , organization_id
2284: , secondary_locator

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

2576: WHEN NO_DATA_FOUND THEN
2577: NULL;
2578: END;
2579:
2580: /*Check if the locator is present in MTL_SECONDARY_LOCATORS
2581: If the SECONDARY_LOCATOR exists then error out*/
2582: BEGIN
2583: SELECT 1
2584: INTO l_chk_flag

Line 2587: FROM mtl_secondary_locators

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