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.EGO_PUB_FWK_PK dependencies on HZ_ORIG_SYSTEMS_VL

Line 1434: from hz_orig_systems_vl ssm

1430:
1431: if (l_system_code is not null) then
1432: begin
1433: select ORIG_SYSTEM into l_system_code
1434: from hz_orig_systems_vl ssm
1435: where ssm.Status = 'A' AND ssm.orig_system_type = 'SPOKE'
1436: AND ORIG_SYSTEM = l_system_code;
1437: exception
1438: when no_data_found then

Line 1447: from hz_orig_systems_vl ssm

1443: end;
1444: elsif (l_system_code is null and l_system_name is not null) then
1445: begin
1446: select ORIG_SYSTEM into l_system_code
1447: from hz_orig_systems_vl ssm
1448: where ssm.Status = 'A' AND ssm.orig_system_type = 'SPOKE'
1449: AND ORIG_SYSTEM_NAME = l_system_name;
1450: exception
1451: when no_data_found then