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_INV_LOVS dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 878: FROM cst_cost_groups ccg, mtl_cycle_count_entries mcce

874: OPEN x_cost_group_lov FOR
875: SELECT UNIQUE ccg.cost_group
876: , ccg.cost_group_id
877: , ccg.description
878: FROM cst_cost_groups ccg, mtl_cycle_count_entries mcce
879: WHERE ccg.organization_id = p_organization_id
880: AND ccg.cost_group LIKE (p_cost_group)
881: AND ccg.cost_group_id = mcce.cost_group_id
882: AND mcce.cycle_count_header_id = p_cycle_count_header_id

Line 1634: FROM mtl_lot_numbers mln, mtl_cycle_count_entries mcce,

1630: SELECT UNIQUE mln.lot_number
1631: , mln.description
1632: , mln.expiration_date
1633: , mmst.status_code
1634: FROM mtl_lot_numbers mln, mtl_cycle_count_entries mcce,
1635: mtl_material_statuses_tl mmst
1636: WHERE mln.organization_id = p_organization_id
1637: AND mln.inventory_item_id = p_inventory_item_id
1638: AND mln.status_id = mmst.status_id (+)