DBA Data[Home] [Help]

APPS.INV_TRANSACTION_LOVS dependencies on MTL_SECONDARY_LOCATORS

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