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.

APPS.AHL_PRD_PRINT_PVT dependencies on AHL_RT_OPER_RESOURCES

Line 2501: FROM AHL_RT_OPER_RESOURCES AR

2497:
2498: CURSOR chk_route_res_csr (p_route_id IN NUMBER)
2499: IS
2500: SELECT 'Y'
2501: FROM AHL_RT_OPER_RESOURCES AR
2502: WHERE AR.association_type_code='ROUTE'
2503: AND AR.object_id=p_route_id
2504: AND ROWNUM < 2;
2505:

Line 2809: FROM AHL_RT_OPER_RESOURCES RE, ahl_resource_mappings ar, bom_resources br

2805: RE.ATTRIBUTE12 "Attribute12" ,
2806: RE.ATTRIBUTE13 "Attribute13" ,
2807: RE.ATTRIBUTE14 "Attribute14" ,
2808: RE.ATTRIBUTE15 "Attribute15"
2809: FROM AHL_RT_OPER_RESOURCES RE, ahl_resource_mappings ar, bom_resources br
2810: WHERE br.organization_id = ar.BOM_ORG_ID
2811: AND br.resource_id = ar.BOM_RESOURCE_ID
2812: AND br.resource_id = :1
2813: AND ar.aso_resource_id = re.aso_resource_id

Line 8188: FROM AHL_RT_OPER_RESOURCES AR

8184:
8185: CURSOR chk_route_res_csr (p_route_id IN NUMBER)
8186: IS
8187: SELECT 'Y'
8188: FROM AHL_RT_OPER_RESOURCES AR
8189: WHERE AR.association_type_code='ROUTE'
8190: AND AR.object_id=p_route_id
8191: AND ROWNUM < 2;
8192:

Line 8278: FROM AHL_RT_OPER_RESOURCES RE, ahl_resource_mappings ar, bom_resources br

8274: RE.ATTRIBUTE12 "Attribute12" ,
8275: RE.ATTRIBUTE13 "Attribute13" ,
8276: RE.ATTRIBUTE14 "Attribute14" ,
8277: RE.ATTRIBUTE15 "Attribute15"
8278: FROM AHL_RT_OPER_RESOURCES RE, ahl_resource_mappings ar, bom_resources br
8279: WHERE br.organization_id = ar.BOM_ORG_ID
8280: AND br.resource_id = ar.BOM_RESOURCE_ID
8281: AND br.resource_id = :1
8282: AND ar.aso_resource_id = re.aso_resource_id