APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_ROUTE_EFFECTIVITIES

Line 1727: ahl_route_effectivities re

1723: CURSOR validate_eff_mc_id(c_position_path_id NUMBER)
1724: is
1725: SELECT 'X'
1726: FROM ahl_mc_path_position_nodes mcp ,
1727: ahl_route_effectivities re
1728: WHERE mcp.mc_id =re.mc_id
1729: AND mcp.path_position_id=NVL(c_position_path_id,-1) and mcp.sequence=0;
1730:
1731:

Line 1741: ahl_route_effectivities re

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
1744: re.mc_id = mch.mc_id AND
1745: mch.mc_header_id =mcr.mc_header_id AND

Line 1758: , AHL_ROUTE_EFFECTIVITIES_V re

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
1761: and mch.mc_id = mcp.mc_id
1762: and re.MC_ID = mch.MC_ID

Line 3278: FROM AHL_ROUTE_EFFECTIVITIES

3274:
3275: CURSOR get_efct_status(c_efct_id number) IS
3276: --AMSRINIV. Bug 4913429. Replacing below commented query with a new query for better performance
3277: SELECT ROUTE_ID
3278: FROM AHL_ROUTE_EFFECTIVITIES
3279: WHERE ROUTE_EFFECTIVITY_ID = c_efct_id;
3280: /*SELECT ROUTE_ID
3281: FROM AHL_ROUTE_EFFECTIVITIES_V
3282: WHERE ROUTE_EFFECTIVITY_ID = c_efct_id;*/

Line 3281: FROM AHL_ROUTE_EFFECTIVITIES_V

3277: SELECT ROUTE_ID
3278: FROM AHL_ROUTE_EFFECTIVITIES
3279: WHERE ROUTE_EFFECTIVITY_ID = c_efct_id;
3280: /*SELECT ROUTE_ID
3281: FROM AHL_ROUTE_EFFECTIVITIES_V
3282: WHERE ROUTE_EFFECTIVITY_ID = c_efct_id;*/
3283:
3284: CURSOR get_route_status(c_route_id number) IS
3285: --AMSRINIV. Bug 4913429. Replacing below commented query with a new query for better performance

Line 3949: , AHL_ROUTE_EFFECTIVITIES_V re

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
3952: WHERE
3953: mch.mc_header_id = mcr.mc_header_id

Line 4078: AHL_ROUTE_EFFECTIVITIES re ,

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,
4080: AHL_ITEM_COMP_V CD ,
4081: AHL_ITEM_COMP_DETAILS ICD
4082: WHERE