APPS.INV_REPLENISH_COUNT_LOVS dependencies on MTL_SECONDARY_LOCATORS

Line 176: FROM mtl_secondary_locators msl

172: )
173: )
174: OR( msi.planning_level = 1
175: AND EXISTS(SELECT 1
176: FROM mtl_secondary_locators msl
177: WHERE msl.organization_id = msi.organization_id
178: AND msl.subinventory_code = msi.secondary_inventory_name
179: )
180: )

Line 243: FROM mtl_secondary_locators msl

239: -- AND milk.inventory_location_id = NVL(milk.physical_location_id, milk.inventory_location_id) -- Commented for Bug 6798138
240: AND NVL(milk.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
241: AND milk.concatenated_segments LIKE(p_locator||'%')
242: AND EXISTS( SELECT 1
243: FROM mtl_secondary_locators msl
244: , mtl_replenish_lines mrl
245: WHERE msl.secondary_locator = milk.inventory_location_id
246: AND msl.organization_id = milk.organization_id
247: AND mrl.replenishment_header_id = p_replenish_header_id

Line 319: FROM mtl_secondary_locators msl

315: AND milk.inventory_location_id = NVL(milk.physical_location_id, milk.inventory_location_id)
316: AND NVL(milk.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
317: AND milk.alias = p_alias
318: AND EXISTS( SELECT 1
319: FROM mtl_secondary_locators msl
320: , mtl_replenish_lines mrl
321: WHERE msl.secondary_locator = milk.inventory_location_id
322: AND msl.organization_id = milk.organization_id
323: AND mrl.replenishment_header_id = p_replenish_header_id

Line 447: FROM mtl_secondary_locators msl

443: )
444: )
445: OR (p_locator_id IS NOT NULL
446: AND EXISTS(SELECT 1
447: FROM mtl_secondary_locators msl
448: , mtl_replenish_lines mrl
449: WHERE msl.secondary_locator = p_locator_id
450: AND msl.inventory_item_id = msik.inventory_item_id
451: AND msl.organization_id = msik.organization_id