VIEW: APPS.AHL_APPROVERS_TYPE_V

Source

View Text - Preformatted

SELECT DISTINCT JRRV.role_id, JRRV.role_name, 'ROLE' FROM jtf_rs_role_relations_vl JRRV WHERE JRRV.role_type_code in ('AHLAPPR', 'AHLGAPPR') UNION SELECT AJREV.resource_id, AJREV.user_name, 'USER' FROM jtf_rs_resource_extns AJREV WHERE AJREV.category IN ('EMPLOYEE','PARTNER', 'PARTY') and AJREV.resource_id > 0

View Text - HTML Formatted

SELECT DISTINCT JRRV.ROLE_ID
, JRRV.ROLE_NAME
, 'ROLE'
FROM JTF_RS_ROLE_RELATIONS_VL JRRV
WHERE JRRV.ROLE_TYPE_CODE IN ('AHLAPPR'
, 'AHLGAPPR') UNION SELECT AJREV.RESOURCE_ID
, AJREV.USER_NAME
, 'USER'
FROM JTF_RS_RESOURCE_EXTNS AJREV
WHERE AJREV.CATEGORY IN ('EMPLOYEE'
, 'PARTNER'
, 'PARTY')
AND AJREV.RESOURCE_ID > 0