APPS.AHL_PRD_UTIL_PKG dependencies on AHL_RESOURCES

Line 1733: from AHL_RT_OPER_RESOURCES AROR, AHL_RESOURCES AHLR

1729: ORDER BY AOR.rt_oper_resource_id nulls last;
1730: */
1731:
1732: SELECT (select AHLR.name
1733: from AHL_RT_OPER_RESOURCES AROR, AHL_RESOURCES AHLR
1734: where AROR.aso_resource_id = AHLR.resource_id
1735: and AROR.rt_oper_resource_id = AOR.rt_oper_resource_id
1736: ) resource_name,
1737: WIPO.organization_id,

Line 1761: AHL_RESOURCES AHLR

1757: IS
1758: SELECT AHLR.name
1759:
1760: FROM AHL_RESOURCE_MAPPINGS MAP,
1761: AHL_RESOURCES AHLR
1762:
1763: WHERE MAP.aso_resource_id = AHLR.resource_id
1764: AND MAP.bom_resource_id = c_bom_resource_id
1765: AND MAP.bom_org_id = c_organization_id