VIEW: APPS.PQH_ROLES_V

Source

View Text - Preformatted

SELECT a.ROLE_ID , a.business_group_id , a.ROLE_NAME , HR_GENERAL.decode_lookup('PQH_ROLE_TYPE' ,a.role_type_cd) role_type , a.ROLE_TYPE_CD , a.ENABLE_FLAG , a.LAST_UPDATE_DATE , a.LAST_UPDATED_BY , a.LAST_UPDATE_LOGIN , a.CREATED_BY , a.CREATION_DATE , a.OBJECT_VERSION_NUMBER from pqh_roles a

View Text - HTML Formatted

SELECT A.ROLE_ID
, A.BUSINESS_GROUP_ID
, A.ROLE_NAME
, HR_GENERAL.DECODE_LOOKUP('PQH_ROLE_TYPE'
, A.ROLE_TYPE_CD) ROLE_TYPE
, A.ROLE_TYPE_CD
, A.ENABLE_FLAG
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
, A.CREATED_BY
, A.CREATION_DATE
, A.OBJECT_VERSION_NUMBER
FROM PQH_ROLES A