VIEW: APPS.PQH_POS_ROLES

Source

View Text - Preformatted

SELECT 'POS' || ':' || pos.position_id name, pos.name display_name, pos.name description, wf_pref.Get_pref('-WF_DEFAULT-','MAILTYPE') notification_preference, fndl.nls_language language, fndl.nls_territory territory, NULL email_address, NULL fax, 'POS' orig_system, pos.position_id orig_system_id, posmax.effective_start_date start_date, 'ACTIVE' status, posmax.effective_end_date expiration_date, NULL security_group_id, 'N' user_flag, 4 partition_id FROM fnd_languages fndl, hr_all_positions_f pos, (select position_id,min(effective_start_date) effective_start_date,max(effective_end_date) effective_end_date from hr_all_positions_f group by position_id) posmax WHERE fndl.installed_flag = 'B' AND trunc(sysdate) BETWEEN pos.effective_start_date AND pos.effective_end_date AND availability_status_id IN (1,4) AND posmax.position_id=pos.position_id

View Text - HTML Formatted

SELECT 'POS' || ':' || POS.POSITION_ID NAME
, POS.NAME DISPLAY_NAME
, POS.NAME DESCRIPTION
, WF_PREF.GET_PREF('-WF_DEFAULT-'
, 'MAILTYPE') NOTIFICATION_PREFERENCE
, FNDL.NLS_LANGUAGE LANGUAGE
, FNDL.NLS_TERRITORY TERRITORY
, NULL EMAIL_ADDRESS
, NULL FAX
, 'POS' ORIG_SYSTEM
, POS.POSITION_ID ORIG_SYSTEM_ID
, POSMAX.EFFECTIVE_START_DATE START_DATE
, 'ACTIVE' STATUS
, POSMAX.EFFECTIVE_END_DATE EXPIRATION_DATE
, NULL SECURITY_GROUP_ID
, 'N' USER_FLAG
, 4 PARTITION_ID
FROM FND_LANGUAGES FNDL
, HR_ALL_POSITIONS_F POS
, (SELECT POSITION_ID
, MIN(EFFECTIVE_START_DATE) EFFECTIVE_START_DATE
, MAX(EFFECTIVE_END_DATE) EFFECTIVE_END_DATE
FROM HR_ALL_POSITIONS_F GROUP BY POSITION_ID) POSMAX
WHERE FNDL.INSTALLED_FLAG = 'B'
AND TRUNC(SYSDATE) BETWEEN POS.EFFECTIVE_START_DATE
AND POS.EFFECTIVE_END_DATE
AND AVAILABILITY_STATUS_ID IN (1
, 4)
AND POSMAX.POSITION_ID=POS.POSITION_ID