eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_REPLENISH_COUNT_PVT dependencies on MTL_ITEM_SUB_INVENTORIES

Line 369: FROM mtl_system_items_vl msiv, mtl_item_sub_inventories mis, mtl_replenish_lines mrl, mfg_lookups ml

365: , ml.meaning count_type
366: , mrl.replenishment_line_id replenishment_line_id
367: , msiv.description item_description
368: , msiv.primary_uom_code primary_uom_code
369: FROM mtl_system_items_vl msiv, mtl_item_sub_inventories mis, mtl_replenish_lines mrl, mfg_lookups ml
370: WHERE mis.inventory_item_id = msiv.inventory_item_id
371: AND mis.organization_id = msiv.organization_id
372: AND mis.organization_id = p_organization_id
373: AND mis.secondary_inventory = p_subinventory_code

Line 596: FROM mtl_item_sub_inventories mis, mtl_system_items msi

592: OR count_type_code = 4
593: OR(
594: NOT EXISTS(
595: SELECT mis.inventory_planning_code
596: FROM mtl_item_sub_inventories mis, mtl_system_items msi
597: WHERE mis.inventory_item_id = mrl.inventory_item_id
598: AND mis.secondary_inventory = p_subinventory_code
599: AND mis.organization_id = mrl.organization_id
600: AND msi.inventory_item_id = mis.inventory_item_id

Line 609: FROM mtl_item_sub_inventories mis, mtl_system_items msi

605: )
606: OR(
607: EXISTS(
608: SELECT mis.inventory_planning_code
609: FROM mtl_item_sub_inventories mis, mtl_system_items msi
610: WHERE mis.inventory_item_id = mrl.inventory_item_id
611: AND mis.secondary_inventory = p_subinventory_code
612: AND mis.organization_id = mrl.organization_id
613: AND msi.inventory_item_id = mis.inventory_item_id