DBA Data[Home] [Help]

APPS.INV_REPLENISH_COUNT_LOVS dependencies on MTL_SECONDARY_INVENTORIES

Line 96: , mtl_secondary_inventories msi

92: , mrh.default_line_items
93: , mrh.default_count_type_code
94: , ml.meaning default_count_type
95: FROM mtl_replenish_headers mrh
96: , mtl_secondary_inventories msi
97: , mfg_lookups ml
98: WHERE mrh.organization_id = p_organization_id
99: AND mrh.subinventory_code = NVL(p_subinventory, mrh.subinventory_code)
100: AND msi.secondary_inventory_name = mrh.subinventory_code

Line 162: FROM mtl_secondary_inventories msi

158: , msi.asset_inventory
159: , msi.quantity_tracked
160: , msi.planning_level
161: , msi.enable_locator_alias
162: FROM mtl_secondary_inventories msi
163: WHERE msi.organization_id = p_organization_id
164: AND secondary_inventory_name LIKE p_subinventory
165: AND TRUNC(NVL(disable_date, SYSDATE + 1)) > TRUNC(SYSDATE)
166: AND NVL(subinventory_type, 1) = 1