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_RM_ROUTE_UTIL dependencies on AHL_MC_RELATIONSHIPS

Line 1630: ahl_mc_relationships mcr,

1626: --AMSRINIV. Bug 4913429. Replacing below commented query with a new query for better performance
1627: SELECT DISTINCT
1628: mcp.path_position_id
1629: FROM
1630: ahl_mc_relationships mcr,
1631: ahl_mc_headers_b mch,
1632: ahl_mc_path_position_nodes mcp,
1633: ahl_route_effectivities re
1634: WHERE

Line 1647: ahl_mc_relationships mcr

1643:
1644: /*SELECT DISTINCT
1645: mcp.path_position_id
1646: FROM
1647: ahl_mc_relationships mcr
1648: , ahl_mc_headers_b mch
1649: , ahl_mc_path_position_nodes mcp
1650: , AHL_ROUTE_EFFECTIVITIES_V re
1651: WHERE

Line 3647: ahl_mc_relationships mcr

3643: IS
3644: SELECT DISTINCT
3645: fnd.MEANING
3646: FROM
3647: ahl_mc_relationships mcr
3648: , ahl_mc_headers_b mch
3649: , ahl_mc_path_position_nodes mcp
3650: , AHL_ROUTE_EFFECTIVITIES_V re
3651: , fnd_lookup_values_vl fnd

Line 3775: ahl_mc_relationships mcr,

3771: SELECT DISTINCT
3772: CD.concatenated_segments ,
3773: CD.organization_code
3774: FROM
3775: ahl_mc_relationships mcr,
3776: ahl_mc_headers_b mch,
3777: ahl_mc_path_position_nodes mcp,
3778: ahl_item_associations_v igass ,
3779: AHL_ROUTE_EFFECTIVITIES re ,