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.AHL_RA_ANALYSER_PVT dependencies on AHL_MC_PATH_POSITION_NODES

Line 202: from ahl_mc_path_position_nodes pos,

198: AND DTLS.MTBF_VALUE IS NOT NULL;
199:
200: CURSOR c_get_path_postions(c_relationship_id AHL_RA_DEFINITION_HDR.RELATIONSHIP_ID%TYPE) IS
201: Select pos.path_position_id
202: from ahl_mc_path_position_nodes pos,
203: ahl_mc_relationships rel,
204: ahl_mc_headers_b hdr
205: where rel.mc_header_id = hdr.mc_header_id
206: and rel.relationship_id = to_number(c_relationship_id)

Line 211: from ahl_mc_path_position_nodes

207: and hdr.mc_id = pos.mc_id
208: and hdr.version_number = nvl(pos.version_number, hdr.version_number)
209: and pos.position_key = rel.position_key
210: and pos.sequence in (select max(sequence)
211: from ahl_mc_path_position_nodes
212: where path_position_id = pos.path_position_id);
213:
214: CURSOR c_fetch_dummy_assocs(c_fct_designator AHL_RA_FCT_ASSOCIATIONS.FORECAST_DESIGNATOR%TYPE,
215: c_arrival_org_id AHL_RA_FCT_ASSOCIATIONS.ORGANIZATION_ID%TYPE) IS