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.XLE_UTILITIES_GRP dependencies on HR_LOCATIONS_ALL

Line 65: HR_LOCATIONS_ALL hrl,

61: hrl.postal_code,
62: hrl.country
63: FROM XLE_ENTITY_PROFILES lep,
64: XLE_REGISTRATIONS reg,
65: HR_LOCATIONS_ALL hrl,
66: XLE_JURISDICTIONS_VL jur
67: WHERE
68: lep.legal_entity_id = reg.source_id
69: AND reg.source_table = 'XLE_ENTITY_PROFILES'

Line 114: HR_LOCATIONS_ALL hrl,

110: hrl.postal_code,
111: hrl.country
112: FROM XLE_ETB_PROFILES etb,
113: XLE_REGISTRATIONS reg,
114: HR_LOCATIONS_ALL hrl,
115: XLE_JURISDICTIONS_VL jur
116: WHERE
117: etb.establishment_id = reg.source_id
118: AND reg.source_table = 'XLE_ETB_PROFILES'

Line 1128: HR_LOCATIONS_ALL hrl,

1124:
1125: SELECT DISTINCT hrl.country
1126: INTO l_country_code
1127: FROM XLE_ENTITY_PROFILES lep,
1128: HR_LOCATIONS_ALL hrl,
1129: XLE_REGISTRATIONS reg
1130: WHERE lep.legal_entity_id = l_legal_entity_id
1131: AND reg.source_id = lep.legal_entity_id
1132: AND reg.source_table = 'XLE_ENTITY_PROFILES'

Line 1263: HR_LOCATIONS_ALL hrl

1259: SELECT hrl.country
1260: INTO x_country_code
1261: FROM XLE_ENTITY_PROFILES xlep,
1262: XLE_REGISTRATIONS reg,
1263: HR_LOCATIONS_ALL hrl
1264: WHERE xlep.legal_entity_id = reg.source_id
1265: AND reg.source_table = 'XLE_ENTITY_PROFILES'
1266: AND reg.identifying_flag = 'Y'
1267: AND nvl(reg.effective_from,sysdate) <= sysdate