APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_ITEM_COMP_DETAILS

Line 1649: FROM AHL_ITEM_COMP_DETAILS ICD

1645:
1646: CURSOR get_rec_from_id ( c_item_comp_detail_id NUMBER )
1647: IS
1648: SELECT DISTINCT ICD.item_comp_detail_id
1649: FROM AHL_ITEM_COMP_DETAILS ICD
1650: , AHL_ITEM_COMPOSITIONS CD
1651: WHERE ICD.item_comp_detail_id = c_item_comp_detail_id
1652: AND CD.APPROVAL_STATUS_CODE ='COMPLETE'
1653: AND CD.item_composition_id = ICD.item_composition_id

Line 3994: FROM AHL_ITEM_COMP_DETAILS ICD

3990: CURSOR get_item_comp ( c_item_comp_detail_id NUMBER )
3991: IS
3992: SELECT DISTINCT MTL.CONCATENATED_SEGMENTS
3993: , MTL.ORGANIZATION_CODE
3994: FROM AHL_ITEM_COMP_DETAILS ICD
3995: , AHL_ITEM_COMPOSITIONS CD
3996: , AHL_MTL_ITEMS_NON_OU_V MTL
3997: WHERE ICD.item_comp_detail_id = c_item_comp_detail_id
3998: AND CD.APPROVAL_STATUS_CODE ='COMPLETE'

Line 4030: from ahl_item_comp_details

4026: from ahl_position_alternates_v
4027: where relationship_id = c_position_path_id) pal,
4028: (select item_composition_id,
4029: item_comp_detail_id
4030: from ahl_item_comp_details
4031: where nvl(trunc(effective_end_date),trunc(sysdate + 1)) > trunc(sysdate)
4032: and item_comp_detail_id = c_item_comp_detail_id) icd,
4033: (select icb.item_composition_id,
4034: icb.inventory_item_id,

Line 4055: AHL_ITEM_COMP_DETAILS ICD

4051: from
4052: ahl_mtl_items_non_ou_v mtl,
4053: ahl_position_alternates_v pal,
4054: AHL_ITEM_COMP_V CD ,
4055: AHL_ITEM_COMP_DETAILS ICD
4056: where
4057: pal.relationship_id = nvl(c_position_path_id,'-1')
4058: and pal.inventory_item_id = mtl.INVENTORY_ITEM_ID
4059: and pal.inventory_org_id = mtl.INVENTORY_ORG_ID

Line 4081: AHL_ITEM_COMP_DETAILS ICD

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
4083: mch.mc_header_id = mcr.mc_header_id
4084: and mch.mc_id = mcp.mc_id
4085: and re.MC_ID = mch.MC_ID