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 431: FROM mtl_item_sub_inventories mis

427: AND msik.stock_enabled_flag = 'Y'
428: AND msik.concatenated_segments LIKE p_item
429: AND ((p_locator_id IS NULL
430: AND EXISTS(SELECT 1
431: FROM mtl_item_sub_inventories mis
432: , mtl_replenish_lines mrl
433: WHERE mis.organization_id = msik.organization_id
434: AND mis.secondary_inventory = p_subinventory
435: AND mis.inventory_item_id = msik.inventory_item_id