eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_ITEM_COMPOSITIONS

Line 1650: , AHL_ITEM_COMPOSITIONS CD

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
1654: AND nvl(trunc(CD.EFFECTIVE_END_DATE),trunc(sysdate+1)) > trunc(sysdate)

Line 3995: , AHL_ITEM_COMPOSITIONS CD

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'
3999: AND CD.item_composition_id = ICD.item_composition_id

Line 4038: from ahl_item_compositions icb

4034: icb.inventory_item_id,
4035: icb.inventory_master_org_id,
4036: decode(sign(trunc(nvl(icb.effective_end_date,sysdate + 1)) - trunc(sysdate)),1,icb.approval_status_code,'EXPIRED') approval_status_code,
4037: icb.effective_end_date effective_end_date
4038: from ahl_item_compositions icb
4039: where approval_status_code = 'COMPLETE'
4040: and nvl(trunc(effective_end_date),trunc(sysdate + 1)) > trunc(sysdate)) cd
4041: where pal.inventory_item_id = mtl.inventory_item_id
4042: and pal.inventory_org_id = mtl.inventory_org_id