VIEW: APPS.PQH_ROLE_UR

Source

View Text - Preformatted

SELECT usr.user_name user_name , 'PER' user_orig_system , pei.person_id user_orig_system_id , 'PQH_ROLE:'||decode(pei.information_type,'PQH_ROLE_USERS',pei.pei_information3,'0') ROLE_NAME , 'PQH_ROLE' ROLE_ORIG_SYSTEM , to_number(decode(pei.information_type,'PQH_ROLE_USERS',pei.pei_information3,'0')) ROLE_ORIG_SYSTEM_ID , to_date(NULL) START_DATE , to_date(NULL) EXPIRATION_DATE , to_number(null) SECURITY_GROUP_ID , to_number('12') PARTITION_ID from PER_PEOPLE_EXTRA_INFO PEI,FND_USER USR where information_type = 'PQH_ROLE_USERS' and usr.employee_id = pei.person_id and pei.pei_information5 = 'Y'

View Text - HTML Formatted

SELECT USR.USER_NAME USER_NAME
, 'PER' USER_ORIG_SYSTEM
, PEI.PERSON_ID USER_ORIG_SYSTEM_ID
, 'PQH_ROLE:'||DECODE(PEI.INFORMATION_TYPE
, 'PQH_ROLE_USERS'
, PEI.PEI_INFORMATION3
, '0') ROLE_NAME
, 'PQH_ROLE' ROLE_ORIG_SYSTEM
, TO_NUMBER(DECODE(PEI.INFORMATION_TYPE
, 'PQH_ROLE_USERS'
, PEI.PEI_INFORMATION3
, '0')) ROLE_ORIG_SYSTEM_ID
, TO_DATE(NULL) START_DATE
, TO_DATE(NULL) EXPIRATION_DATE
, TO_NUMBER(NULL) SECURITY_GROUP_ID
, TO_NUMBER('12') PARTITION_ID
FROM PER_PEOPLE_EXTRA_INFO PEI
, FND_USER USR
WHERE INFORMATION_TYPE = 'PQH_ROLE_USERS'
AND USR.EMPLOYEE_ID = PEI.PERSON_ID
AND PEI.PEI_INFORMATION5 = 'Y'