VIEW: APPS.PQH_ROLE_ROLES

Source

View Text - Preformatted

SELECT 'PQH_ROLE:'||to_char(rls.role_id) name , RLS.ROLE_NAME display_name , RLS.ROLE_NAME description , wf_pref.get_pref('-WF_DEFAULT-','MAILTYPE') notification_preference , FNDL.NLS_LANGUAGE LANGUAGE , FNDL.NLS_TERRITORY TERRITORY , to_char(null) email_address , to_char(null) fax , 'PQH_ROLE' ORIG_SYSTEM , RLS.role_id ORIG_SYSTEM_ID , to_date(null) START_DATE , 'ACTIVE' STATUS , to_date(null) EXPIRATION_DATE , to_number(NULL) SECURITY_GROUP_ID , 'N' USER_FLAG , to_number('12') PARTITION_ID from pqh_roles rls,FND_LANGUAGES FNDL where FNDL.installed_flag = 'B' and nvl(rls.enable_flag,'Y') ='Y'

View Text - HTML Formatted

SELECT 'PQH_ROLE:'||TO_CHAR(RLS.ROLE_ID) NAME
, RLS.ROLE_NAME DISPLAY_NAME
, RLS.ROLE_NAME DESCRIPTION
, WF_PREF.GET_PREF('-WF_DEFAULT-'
, 'MAILTYPE') NOTIFICATION_PREFERENCE
, FNDL.NLS_LANGUAGE LANGUAGE
, FNDL.NLS_TERRITORY TERRITORY
, TO_CHAR(NULL) EMAIL_ADDRESS
, TO_CHAR(NULL) FAX
, 'PQH_ROLE' ORIG_SYSTEM
, RLS.ROLE_ID ORIG_SYSTEM_ID
, TO_DATE(NULL) START_DATE
, 'ACTIVE' STATUS
, TO_DATE(NULL) EXPIRATION_DATE
, TO_NUMBER(NULL) SECURITY_GROUP_ID
, 'N' USER_FLAG
, TO_NUMBER('12') PARTITION_ID
FROM PQH_ROLES RLS
, FND_LANGUAGES FNDL
WHERE FNDL.INSTALLED_FLAG = 'B'
AND NVL(RLS.ENABLE_FLAG
, 'Y') ='Y'