[Home] [Help]
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
1636: re.mc_id = mch.mc_id AND
1637: mch.mc_header_id =mcr.mc_header_id AND
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
1653: and mch.mc_id = mcp.mc_id
1654: and re.MC_ID = mch.MC_ID
3142:
3143: CURSOR get_efct_status(c_efct_id number) IS
3144: --AMSRINIV. Bug 4913429. Replacing below commented query with a new query for better performance
3145: SELECT ROUTE_ID
3146: FROM AHL_ROUTE_EFFECTIVITIES
3147: WHERE ROUTE_EFFECTIVITY_ID = c_efct_id;
3148: /*SELECT ROUTE_ID
3149: FROM AHL_ROUTE_EFFECTIVITIES_V
3150: WHERE ROUTE_EFFECTIVITY_ID = c_efct_id;*/
3145: SELECT ROUTE_ID
3146: FROM AHL_ROUTE_EFFECTIVITIES
3147: WHERE ROUTE_EFFECTIVITY_ID = c_efct_id;
3148: /*SELECT ROUTE_ID
3149: FROM AHL_ROUTE_EFFECTIVITIES_V
3150: WHERE ROUTE_EFFECTIVITY_ID = c_efct_id;*/
3151:
3152: CURSOR get_route_status(c_route_id number) IS
3153: --AMSRINIV. Bug 4913429. Replacing below commented query with a new query for better performance
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
3653: WHERE
3654: mch.mc_header_id = mcr.mc_header_id
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,
3781: AHL_ITEM_COMP_V CD ,
3782: AHL_ITEM_COMP_DETAILS ICD
3783: WHERE