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_COST_GROUP_PVT dependencies on MTL_SERIAL_NUMBERS

Line 1760: FROM cst_cost_groups ccg, mtl_serial_numbers msn

1756: GROUP BY ccg.cost_group_id, ccg.cost_group;
1757: ELSE
1758: SELECT ccg.cost_group_id, ccg.cost_group
1759: INTO x_cost_group_id, x_cost_group
1760: FROM cst_cost_groups ccg, mtl_serial_numbers msn
1761: WHERE ccg.cost_group_id = msn.cost_group_id
1762: AND (msn.lot_number = p_lot_number
1763: OR (p_lot_number IS NULL AND msn.lot_number IS NULL))
1764: AND (msn.revision = p_revision

Line 1798: FROM cst_cost_groups ccg, mtl_serial_numbers msn

1794: GROUP BY ccg.cost_group_id, ccg.cost_group;
1795: ELSE
1796: SELECT ccg.cost_group_id, ccg.cost_group
1797: INTO x_cost_group_id, x_cost_group
1798: FROM cst_cost_groups ccg, mtl_serial_numbers msn
1799: WHERE ccg.cost_group_id = msn.cost_group_id
1800: AND (msn.lot_number = p_lot_number
1801: OR (p_lot_number IS NULL AND msn.lot_number IS NULL))
1802: AND (msn.revision = p_revision