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 812: FROM cst_cost_groups ccg, mtl_physical_inventory_tags mpit

808: OPEN x_cost_group_lov FOR
809: SELECT UNIQUE ccg.cost_group
810: , ccg.cost_group_id
811: , ccg.description
812: FROM cst_cost_groups ccg, mtl_physical_inventory_tags mpit
813: WHERE ccg.organization_id = p_organization_id
814: AND ccg.cost_group LIKE (p_cost_group)
815: AND ccg.cost_group_id = mpit.cost_group_id
816: AND mpit.physical_inventory_id = p_physical_inventory_id

Line 1517: FROM mtl_lot_numbers mln, mtl_physical_inventory_tags mpit,

1513: SELECT UNIQUE mln.lot_number
1514: , mln.description
1515: , mln.expiration_date
1516: , mmst.status_code
1517: FROM mtl_lot_numbers mln, mtl_physical_inventory_tags mpit,
1518: mtl_material_statuses_tl mmst
1519: WHERE mln.organization_id = p_organization_id
1520: AND mln.inventory_item_id = p_inventory_item_id
1521: AND mln.lot_number LIKE (p_lot_number)