[Home] [Help]
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: )
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
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
452: )
453: )
454: OR (p_locator_id IS NOT NULL
455: AND EXISTS(SELECT 1
456: FROM mtl_secondary_locators msl
457: , mtl_replenish_lines mrl
458: WHERE msl.secondary_locator = p_locator_id
459: AND msl.inventory_item_id = msik.inventory_item_id
460: AND msl.organization_id = msik.organization_id
544: )
545: )
546: OR (p_locator_id IS NOT NULL
547: AND EXISTS(SELECT 1
548: FROM mtl_secondary_locators msl
549: , mtl_replenish_lines mrl
550: WHERE msl.secondary_locator = p_locator_id
551: AND msl.inventory_item_id = msik.inventory_item_id
552: AND msl.organization_id = msik.organization_id