APPS.INV_TRANSACTION_LOVS dependencies on MTL_ITEM_LOCATIONS_KFV

Line 154: FROM mtl_item_locations_kfv a,mtl_secondary_locators b

150: BEGIN
151: IF p_Restrict_Locators_Code = 1 THEN --Locators restricted to predefined list
152: OPEN x_Locators FOR
153: select a.inventory_location_id, a.concatenated_segments,a.description
154: FROM mtl_item_locations_kfv a,mtl_secondary_locators b
155: WHERE b.organization_id = p_Organization_Id and
156: b.inventory_item_id = p_Inventory_Item_Id and
157: b.subinventory_code = p_Subinventory_Code and
158: a.inventory_location_id = b.secondary_locator and

Line 163: FROM mtl_item_locations_kfv

159: a.concatenated_segments like (p_concatenated_segments);
160: ELSE --Locators not restricted
161: OPEN x_Locators FOR
162: select inventory_location_id,concatenated_segments,description
163: FROM mtl_item_locations_kfv
164: WHERE organization_id = p_Organization_Id and
165: subinventory_code = p_Subinventory_Code and
166: concatenated_segments like (p_concatenated_segments);
167: END IF;