APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_ITEM_COMP_DETAILS

Line 1566: FROM AHL_ITEM_COMP_DETAILS ICD

1562:
1563: CURSOR get_rec_from_id ( c_item_comp_detail_id NUMBER )
1564: IS
1565: SELECT DISTINCT ICD.item_comp_detail_id
1566: FROM AHL_ITEM_COMP_DETAILS ICD
1567: , AHL_ITEM_COMPOSITIONS CD
1568: WHERE ICD.item_comp_detail_id = c_item_comp_detail_id
1569: AND CD.APPROVAL_STATUS_CODE ='COMPLETE'
1570: AND CD.item_composition_id = ICD.item_composition_id

Line 3695: FROM AHL_ITEM_COMP_DETAILS ICD

3691: CURSOR get_item_comp ( c_item_comp_detail_id NUMBER )
3692: IS
3693: SELECT DISTINCT MTL.CONCATENATED_SEGMENTS
3694: , MTL.ORGANIZATION_CODE
3695: FROM AHL_ITEM_COMP_DETAILS ICD
3696: , AHL_ITEM_COMPOSITIONS CD
3697: , AHL_MTL_ITEMS_NON_OU_V MTL
3698: WHERE ICD.item_comp_detail_id = c_item_comp_detail_id
3699: AND CD.APPROVAL_STATUS_CODE ='COMPLETE'

Line 3731: from ahl_item_comp_details

3727: from ahl_position_alternates_v
3728: where relationship_id = c_position_path_id) pal,
3729: (select item_composition_id,
3730: item_comp_detail_id
3731: from ahl_item_comp_details
3732: where nvl(trunc(effective_end_date),trunc(sysdate + 1)) > trunc(sysdate)
3733: and item_comp_detail_id = c_item_comp_detail_id) icd,
3734: (select icb.item_composition_id,
3735: icb.inventory_item_id,

Line 3756: AHL_ITEM_COMP_DETAILS ICD

3752: from
3753: ahl_mtl_items_non_ou_v mtl,
3754: ahl_position_alternates_v pal,
3755: AHL_ITEM_COMP_V CD ,
3756: AHL_ITEM_COMP_DETAILS ICD
3757: where
3758: pal.relationship_id = nvl(c_position_path_id,'-1')
3759: and pal.inventory_item_id = mtl.INVENTORY_ITEM_ID
3760: and pal.inventory_org_id = mtl.INVENTORY_ORG_ID

Line 3782: AHL_ITEM_COMP_DETAILS ICD

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
3784: mch.mc_header_id = mcr.mc_header_id
3785: and mch.mc_id = mcp.mc_id
3786: and re.MC_ID = mch.MC_ID