APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_MC_HEADERS_B

Line 1715: ahl_mc_headers_b mch,

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) )
1719: AND mch.mc_header_id = mcr.mc_header_id

Line 1739: ahl_mc_headers_b mch,

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
1743: re.mc_id IS NOT NULL AND

Line 1756: , ahl_mc_headers_b mch

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
1760: mch.mc_header_id = mcr.mc_header_id

Line 1880: FROM AHL_MC_HEADERS_B

1876: CURSOR get_rec_from_value ( c_mc_name AHL_MC_HEADERS_V.NAME%TYPE )
1877: IS
1878: --AMSRINIV. Bug 4913429. Replacing below commented query with a new query for better performance
1879: SELECT DISTINCT mc_id
1880: FROM AHL_MC_HEADERS_B
1881: WHERE upper(name) = upper(c_mc_name)
1882: AND CONFIG_STATUS_CODE='COMPLETE';
1883:
1884: /*SELECT DISTINCT mc_id

Line 1893: FROM AHL_MC_HEADERS_B

1889: CURSOR get_rec_from_value1 ( c_mc_name AHL_MC_HEADERS_V.NAME%TYPE , c_mc_revision_number AHL_MC_HEADERS_V.REVISION%TYPE)
1890: IS
1891: --AMSRINIV. Bug 4913429. Replacing below commented query with a new query for better performance
1892: SELECT DISTINCT mc_header_id, mc_id
1893: FROM AHL_MC_HEADERS_B
1894: WHERE upper(name) = upper(c_mc_name)
1895: AND upper(revision)=upper(c_mc_revision_number)
1896: AND CONFIG_STATUS_CODE='COMPLETE';
1897: /*

Line 3947: , ahl_mc_headers_b mch

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
3951: , AHL_RT_OPER_MATERIALS AOB

Line 4075: ahl_mc_headers_b mch,

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 ,
4079: -- ahl_mtl_items_non_ou_v mtl,

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 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