DBA Data[Home] [Help]

APPS.INV_REPLENISH_COUNT_LOVS dependencies on MTL_ITEM_SUB_INVENTORIES

Line 169: FROM mtl_item_sub_inventories mis

165: AND TRUNC(NVL(disable_date, SYSDATE + 1)) > TRUNC(SYSDATE)
166: AND NVL(subinventory_type, 1) = 1
167: AND(( msi.planning_level = 2
168: AND EXISTS(SELECT 1
169: FROM mtl_item_sub_inventories mis
170: WHERE mis.organization_id = msi.organization_id
171: AND mis.secondary_inventory = msi.secondary_inventory_name
172: )
173: )

Line 440: FROM mtl_item_sub_inventories mis

436: AND msik.stock_enabled_flag = 'Y'
437: AND msik.concatenated_segments LIKE p_item||l_append
438: AND ((p_locator_id IS NULL
439: AND EXISTS(SELECT 1
440: FROM mtl_item_sub_inventories mis
441: , mtl_replenish_lines mrl
442: WHERE mis.organization_id = msik.organization_id
443: AND mis.secondary_inventory = p_subinventory
444: AND mis.inventory_item_id = msik.inventory_item_id

Line 532: FROM mtl_item_sub_inventories mis

528: AND msik.inventory_item_flag = 'Y'
529: AND msik.stock_enabled_flag = 'Y'
530: AND ((p_locator_id IS NULL
531: AND EXISTS(SELECT 1
532: FROM mtl_item_sub_inventories mis
533: , mtl_replenish_lines mrl
534: WHERE mis.organization_id = msik.organization_id
535: AND mis.secondary_inventory = p_subinventory
536: AND mis.inventory_item_id = msik.inventory_item_id