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_PHYSICAL_INVENTORY_TAGS

Line 834: FROM cst_cost_groups ccg, mtl_physical_inventory_tags mpit

830: OPEN x_cost_group_lov FOR
831: SELECT UNIQUE ccg.cost_group
832: , ccg.cost_group_id
833: , ccg.description
834: FROM cst_cost_groups ccg, mtl_physical_inventory_tags mpit
835: WHERE ccg.organization_id = p_organization_id
836: AND ccg.cost_group LIKE (p_cost_group)
837: AND ccg.cost_group_id = mpit.cost_group_id
838: AND mpit.physical_inventory_id = p_physical_inventory_id

Line 1541: FROM mtl_lot_numbers mln, mtl_physical_inventory_tags mpit,

1537: SELECT UNIQUE mln.lot_number
1538: , mln.description
1539: , mln.expiration_date
1540: , mmst.status_code
1541: FROM mtl_lot_numbers mln, mtl_physical_inventory_tags mpit,
1542: mtl_material_statuses_tl mmst
1543: WHERE mln.organization_id = p_organization_id
1544: AND mln.inventory_item_id = p_inventory_item_id
1545: AND mln.lot_number LIKE (p_lot_number)