APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_MC_HEADERS_B

Line 1631: ahl_mc_headers_b mch,

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

Line 1648: , ahl_mc_headers_b mch

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

Line 1748: FROM AHL_MC_HEADERS_B

1744: CURSOR get_rec_from_value ( c_mc_name AHL_MC_HEADERS_V.NAME%TYPE )
1745: IS
1746: --AMSRINIV. Bug 4913429. Replacing below commented query with a new query for better performance
1747: SELECT DISTINCT mc_id
1748: FROM AHL_MC_HEADERS_B
1749: WHERE upper(name) = upper(c_mc_name)
1750: AND CONFIG_STATUS_CODE='COMPLETE';
1751:
1752: /*SELECT DISTINCT mc_id

Line 1761: FROM AHL_MC_HEADERS_B

1757: CURSOR get_rec_from_value1 ( c_mc_name AHL_MC_HEADERS_V.NAME%TYPE , c_mc_revision_number AHL_MC_HEADERS_V.REVISION%TYPE)
1758: IS
1759: --AMSRINIV. Bug 4913429. Replacing below commented query with a new query for better performance
1760: SELECT DISTINCT mc_header_id, mc_id
1761: FROM AHL_MC_HEADERS_B
1762: WHERE upper(name) = upper(c_mc_name)
1763: AND upper(revision)=upper(c_mc_revision_number)
1764: AND CONFIG_STATUS_CODE='COMPLETE';
1765: /*

Line 3648: , ahl_mc_headers_b mch

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

Line 3776: ahl_mc_headers_b mch,

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