APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_MC_PATH_POSITION_NODES

Line 1632: ahl_mc_path_position_nodes mcp,

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
1636: re.mc_id = mch.mc_id AND

Line 1641: mcp.SEQUENCE = ( SELECT MAX(SEQUENCE) FROM ahl_mc_path_position_nodes WHERE path_position_id = NVL(c_position_path_id,-1) ) AND

1637: mch.mc_header_id =mcr.mc_header_id AND
1638: mch.mc_id = mcp.mc_id AND
1639: mch.version_number = NVL(mcp.version_number, mch.version_number) AND
1640: mcr.position_key = mcp.position_key AND
1641: mcp.SEQUENCE = ( SELECT MAX(SEQUENCE) FROM ahl_mc_path_position_nodes WHERE path_position_id = NVL(c_position_path_id,-1) ) AND
1642: mcp.path_position_id = NVL(c_position_path_id,-1);
1643:
1644: /*SELECT DISTINCT
1645: mcp.path_position_id

Line 1649: , ahl_mc_path_position_nodes mcp

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
1653: and mch.mc_id = mcp.mc_id

Line 1657: and mcp.sequence = (select max(sequence) from ahl_mc_path_position_nodes where path_position_id = nvl(c_position_path_id,-1))

1653: and mch.mc_id = mcp.mc_id
1654: and re.MC_ID = mch.MC_ID
1655: and mch.version_number = nvl(mcp.version_number, mch.version_number)
1656: and mcr.position_key = mcp.position_key
1657: and mcp.sequence = (select max(sequence) from ahl_mc_path_position_nodes where path_position_id = nvl(c_position_path_id,-1))
1658: and mcp.path_position_id = nvl(c_position_path_id,-1);*/
1659:
1660:
1661: BEGIN

Line 3649: , ahl_mc_path_position_nodes mcp

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
3653: WHERE

Line 3659: and mcp.sequence = (select max(sequence) from ahl_mc_path_position_nodes where path_position_id = nvl(c_position_path_id,-1))

3655: and mch.mc_id = mcp.mc_id
3656: and re.MC_ID = mch.MC_ID
3657: and mch.version_number = nvl(mcp.version_number, mch.version_number)
3658: and mcr.position_key = mcp.position_key
3659: and mcp.sequence = (select max(sequence) from ahl_mc_path_position_nodes where path_position_id = nvl(c_position_path_id,-1))
3660: and mcp.path_position_id = nvl(c_position_path_id,-1)
3661: and fnd.LOOKUP_TYPE = 'AHL_POSITION_REFERENCE'
3662: and fnd.LOOKUP_CODE = mcr.POSITION_REF_CODE
3663: ;

Line 3777: ahl_mc_path_position_nodes mcp,

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,
3781: AHL_ITEM_COMP_V CD ,

Line 3789: and mcp.sequence = (select max(sequence) from ahl_mc_path_position_nodes where path_position_id = nvl(p_position_path_id,'-1'))

3785: and mch.mc_id = mcp.mc_id
3786: and re.MC_ID = mch.MC_ID
3787: and mch.version_number = nvl(mcp.version_number, mch.version_number)
3788: and mcr.position_key = mcp.position_key
3789: and mcp.sequence = (select max(sequence) from ahl_mc_path_position_nodes where path_position_id = nvl(p_position_path_id,'-1'))
3790: and mcp.path_position_id = nvl(p_position_path_id,'-1')
3791: and mcr.item_group_id = igass.item_group_id
3792: and igass.INVENTORY_ITEM_ID = CD.inventory_item_id
3793: and igass.INVENTORY_ORG_ID = CD.inventory_master_org_id