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 1714: FROM ahl_mc_relationships mcr,

1710:
1711: CURSOR validate_position_keys( c_position_path_id NUMBER)
1712: is
1713: select 'X'
1714: FROM ahl_mc_relationships mcr,
1715: ahl_mc_headers_b mch,
1716: ahl_mc_path_position_nodes mcp
1717: WHERE mcp.mc_id = mch.mc_id
1718: AND mcp.SEQUENCE = ( SELECT MAX(SEQUENCE) FROM ahl_mc_path_position_nodes WHERE path_position_id = NVL(c_position_path_id,-1) )

Line 1738: ahl_mc_relationships mcr,

1734: --AMSRINIV. Bug 4913429. Replacing below commented query with a new query for better performance
1735: SELECT DISTINCT
1736: mcp.path_position_id
1737: FROM
1738: ahl_mc_relationships mcr,
1739: ahl_mc_headers_b mch,
1740: ahl_mc_path_position_nodes mcp,
1741: ahl_route_effectivities re
1742: WHERE

Line 1755: ahl_mc_relationships mcr

1751:
1752: SELECT DISTINCT
1753: mcp.path_position_id
1754: FROM
1755: ahl_mc_relationships mcr
1756: , ahl_mc_headers_b mch
1757: , ahl_mc_path_position_nodes mcp
1758: , AHL_ROUTE_EFFECTIVITIES_V re
1759: WHERE

Line 3946: ahl_mc_relationships mcr

3942: IS
3943: SELECT DISTINCT
3944: fnd.MEANING
3945: FROM
3946: ahl_mc_relationships mcr
3947: , ahl_mc_headers_b mch
3948: , ahl_mc_path_position_nodes mcp
3949: , AHL_ROUTE_EFFECTIVITIES_V re
3950: , fnd_lookup_values_vl fnd

Line 4074: ahl_mc_relationships mcr,

4070: SELECT DISTINCT
4071: CD.concatenated_segments ,
4072: CD.organization_code
4073: FROM
4074: ahl_mc_relationships mcr,
4075: ahl_mc_headers_b mch,
4076: ahl_mc_path_position_nodes mcp,
4077: ahl_item_associations_v igass ,
4078: AHL_ROUTE_EFFECTIVITIES re ,

Line 4351: p_x_mc_position_key IN OUT NOCOPY AHL_MC_RELATIONSHIPS.position_key%TYPE

4347: x_return_status OUT NOCOPY VARCHAR2,
4348: x_msg_data OUT NOCOPY VARCHAR2,
4349: p_mc_id IN AHL_MC_HEADERS_VL.mc_id%TYPE,
4350: p_mc_position IN FND_LOOKUP_VALUES_VL.meaning%TYPE,
4351: p_x_mc_position_key IN OUT NOCOPY AHL_MC_RELATIONSHIPS.position_key%TYPE
4352: )
4353: IS
4354: l_mc_position_key AHL_MC_RELATIONSHIPS.position_key%TYPE;
4355:

Line 4354: l_mc_position_key AHL_MC_RELATIONSHIPS.position_key%TYPE;

4350: p_mc_position IN FND_LOOKUP_VALUES_VL.meaning%TYPE,
4351: p_x_mc_position_key IN OUT NOCOPY AHL_MC_RELATIONSHIPS.position_key%TYPE
4352: )
4353: IS
4354: l_mc_position_key AHL_MC_RELATIONSHIPS.position_key%TYPE;
4355:
4356: CURSOR get_rec_from_value ( c_mc_id AHL_MC_HEADERS_VL.mc_id%TYPE, c_mc_position FND_LOOKUP_VALUES_VL.meaning%TYPE)
4357: IS
4358: SELECT DISTINCT amr.position_key

Line 4360: AHL_MC_RELATIONSHIPS amr,

4356: CURSOR get_rec_from_value ( c_mc_id AHL_MC_HEADERS_VL.mc_id%TYPE, c_mc_position FND_LOOKUP_VALUES_VL.meaning%TYPE)
4357: IS
4358: SELECT DISTINCT amr.position_key
4359: FROM
4360: AHL_MC_RELATIONSHIPS amr,
4361: FND_LOOKUP_VALUES_VL flv,
4362: AHL_MC_HEADERS_VL amh
4363: WHERE
4364: amr.mc_header_id = amh.mc_header_id AND

Line 4375: from AHL_MC_PATH_POSITION_NODES ampp, AHL_MC_RULE_STATEMENTS amrs, ahl_mc_headers_b amh2,ahl_mc_rules_b mcrule,ahl_mc_relationships rel

4371: flv.lookup_code = amr.position_ref_code AND
4372: flv.meaning = c_mc_position and
4373: nvl(amr.parent_relationship_id, -1) not in (
4374: select rel.relationship_id
4375: from AHL_MC_PATH_POSITION_NODES ampp, AHL_MC_RULE_STATEMENTS amrs, ahl_mc_headers_b amh2,ahl_mc_rules_b mcrule,ahl_mc_relationships rel
4376: where ampp.mc_id = c_mc_id and
4377: ampp.path_position_node_id = amrs.subject_id and
4378: amrs.subject_type = 'POSITION' and
4379: amrs.operator = 'MUST_HAVE' and

Line 4389: CURSOR get_rec_from_id ( c_mc_id AHL_MC_HEADERS_VL.mc_id%TYPE, c_mc_position_key AHL_MC_RELATIONSHIPS.position_key%TYPE )

4385: nvl(mcrule.active_end_date,SYSDATE +1) > SYSDATE and
4386: amh2.config_status_code = 'COMPLETE' and
4387: nvl(rel.active_end_date, SYSDATE + 1) > SYSDATE);
4388:
4389: CURSOR get_rec_from_id ( c_mc_id AHL_MC_HEADERS_VL.mc_id%TYPE, c_mc_position_key AHL_MC_RELATIONSHIPS.position_key%TYPE )
4390: IS
4391: SELECT DISTINCT amr.position_key
4392: FROM
4393: AHL_MC_RELATIONSHIPS amr,

Line 4393: AHL_MC_RELATIONSHIPS amr,

4389: CURSOR get_rec_from_id ( c_mc_id AHL_MC_HEADERS_VL.mc_id%TYPE, c_mc_position_key AHL_MC_RELATIONSHIPS.position_key%TYPE )
4390: IS
4391: SELECT DISTINCT amr.position_key
4392: FROM
4393: AHL_MC_RELATIONSHIPS amr,
4394: AHL_MC_HEADERS_VL amh
4395: WHERE
4396: amr.mc_header_id = amh.mc_header_id and
4397: amh.mc_id = NVL(c_mc_id,-1) and

Line 4403: from AHL_MC_PATH_POSITION_NODES ampp, AHL_MC_RULE_STATEMENTS amrs, ahl_mc_headers_b amh2,ahl_mc_rules_b mcrule,ahl_mc_relationships rel

4399: nvl(amr.active_end_date, SYSDATE + 1) > SYSDATE AND
4400: amr.position_key = c_mc_position_key and
4401: nvl(amr.parent_relationship_id, -1) not in (
4402: select rel.relationship_id
4403: from AHL_MC_PATH_POSITION_NODES ampp, AHL_MC_RULE_STATEMENTS amrs, ahl_mc_headers_b amh2,ahl_mc_rules_b mcrule,ahl_mc_relationships rel
4404: where ampp.mc_id = c_mc_id and
4405: ampp.path_position_node_id = amrs.subject_id and
4406: amrs.subject_type = 'POSITION' and
4407: amrs.operator = 'MUST_HAVE' and