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.FLM_KANBAN_PUB dependencies on MTL_ITEM_LOCATIONS

Line 141: function is_locator_id_valid(p_subinv_name in mtl_item_locations.subinventory_code%TYPE

137: return false;
138: end is_inv_item_id_valid;
139:
140: -- private function to validate locator_id
141: function is_locator_id_valid(p_subinv_name in mtl_item_locations.subinventory_code%TYPE
142: ,p_locator_id in mtl_item_locations.inventory_location_id%TYPE
143: ,p_org_id in mtl_item_locations.organization_id%TYPE)
144: return boolean
145: is

Line 142: ,p_locator_id in mtl_item_locations.inventory_location_id%TYPE

138: end is_inv_item_id_valid;
139:
140: -- private function to validate locator_id
141: function is_locator_id_valid(p_subinv_name in mtl_item_locations.subinventory_code%TYPE
142: ,p_locator_id in mtl_item_locations.inventory_location_id%TYPE
143: ,p_org_id in mtl_item_locations.organization_id%TYPE)
144: return boolean
145: is
146: l_exist number;

Line 143: ,p_org_id in mtl_item_locations.organization_id%TYPE)

139:
140: -- private function to validate locator_id
141: function is_locator_id_valid(p_subinv_name in mtl_item_locations.subinventory_code%TYPE
142: ,p_locator_id in mtl_item_locations.inventory_location_id%TYPE
143: ,p_org_id in mtl_item_locations.organization_id%TYPE)
144: return boolean
145: is
146: l_exist number;
147: begin

Line 150: FROM mtl_item_locations mil

146: l_exist number;
147: begin
148: SELECT 1
149: INTO l_exist
150: FROM mtl_item_locations mil
151: WHERE mil.subinventory_code = p_subinv_name
152: AND mil.inventory_location_id = p_locator_id
153: AND mil.organization_id = p_org_id;
154:

Line 4303: from mtl_item_locations_kfv

4299: if l_locator_id is not null Then
4300:
4301: Select concatenated_segments
4302: into x_loc_name
4303: from mtl_item_locations_kfv
4304: where inventory_location_id = l_locator_id
4305: and organization_id = l_organization_id;
4306:
4307: end if;

Line 4323: from mtl_item_locations_kfv

4319: if p_locator_id is not null Then
4320:
4321: Select concatenated_segments
4322: into x_loc_name
4323: from mtl_item_locations_kfv
4324: where inventory_location_id = p_locator_id
4325: and organization_id = p_organization_id;
4326:
4327: end if;