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_SYSTEM_ITEMS_VL

Line 319: 'MTL_SYSTEM_ITEMS_VL'.*/

315: END IF;
316:
317: IF p_planning_level = 1 THEN -- PAR level Count
318: /*Bug#5612236. In the below query, replaced 'MTL_SYSTEM_ITEMS_KFV' with
319: 'MTL_SYSTEM_ITEMS_VL'.*/
320: OPEN x_replenish_count_lines
321: FOR
322: SELECT msiv.inventory_item_id item_id
323: , msiv.concatenated_segments item

Line 331: FROM mtl_item_locations mil, mtl_system_items_vl msiv, mtl_secondary_locators msl, mtl_replenish_lines mrl, mfg_lookups ml

327: , ml.meaning count_type
328: , mrl.replenishment_line_id replenishment_line_id
329: , msiv.description item_description
330: , msiv.primary_uom_code primary_uom_code
331: FROM mtl_item_locations mil, mtl_system_items_vl msiv, mtl_secondary_locators msl, mtl_replenish_lines mrl, mfg_lookups ml
332: WHERE msl.inventory_item_id = msiv.inventory_item_id
333: AND msl.organization_id = msiv.organization_id
334: AND msl.secondary_locator = mil.inventory_location_id
335: AND msl.organization_id = mil.organization_id

Line 357: 'MTL_SYSTEM_ITEMS_VL'.*/

353: AND mrl.error_flag IS NULL
354: ORDER BY DECODE(p_use_loc_pick_seq, 'YES', mil.picking_order, replenishment_line_id), item;
355: ELSE -- Subinventory Level Count
356: /*Bug#5612236. In the below query, replaced 'MTL_SYSTEM_ITEMS_KFV' with
357: 'MTL_SYSTEM_ITEMS_VL'.*/
358: OPEN x_replenish_count_lines
359: FOR
360: SELECT mis.inventory_item_id item_id
361: , msiv.concatenated_segments item

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