DBA Data[Home] [Help]

APPS.WMA_SPECIAL_LOVS dependencies on MTL_ITEM_LOCATIONS_KFV

Line 153: from mtl_item_locations_kfv

149: -- not restricted to predefined locators
150: OPEN locators FOR
151: select inventory_location_id,
152: concatenated_segments
153: from mtl_item_locations_kfv
154: where organization_id = orgID
155: and subinventory_code = subinv
156: and concatenated_segments like locName || '%'
157: and inv_material_status_grp.is_status_applicable(

Line 177: mtl_item_locations_kfv milk

173: OPEN locators FOR
174: select msl.secondary_locator,
175: milk.concatenated_segments
176: from mtl_secondary_locators msl,
177: mtl_item_locations_kfv milk
178: where msl.organization_id = milk.organization_id
179: and msl.secondary_locator = milk.inventory_location_id
180: and msl.subinventory_code = milk.subinventory_code
181: and msl.inventory_item_id = itemID