[Home] [Help]
View: WF_POS_ROLES
Product: | FND - Application Object Library |
Description: | Bulk Sync Directory Service Role View for Orig System POS |
Implementation/DBA Data: |
APPS.WF_POS_ROLES
|
View Text
SELECT 'POS'||':'||POS.POSITION_ID
, POS.NAME
, POS.NAME
, 'QUERY'
, FNDL.NLS_LANGUAGE
, FNDT.NLS_TERRITORY
, NULL
, NULL
, 'POS'
, POS.POSITION_ID
, TO_DATE(NULL)
, 'ACTIVE'
, TO_DATE(NULL)
, NULL
, 'N'
, 4
FROM FND_TERRITORIES FNDT
, FND_LANGUAGES FNDL
, HR_LOCATIONS_ALL HRL
, PER_POSITIONS POS
WHERE POS.LOCATION_ID = HRL.LOCATION_ID(+)
AND HRL.COUNTRY = FNDT.TERRITORY_CODE(+)
AND FNDT.NLS_TERRITORY = FNDL.NLS_TERRITORY(+)
Columns
Name |
NAME |
DISPLAY_NAME |
DESCRIPTION |
NOTIFICATION_PREFERENCE |
LANGUAGE |
TERRITORY |
EMAIL_ADDRESS |
FAX |
ORIG_SYSTEM |
ORIG_SYSTEM_ID |
START_DATE |
STATUS |
EXPIRATION_DATE |
SECURITY_GROUP_ID |
USER_FLAG |
PARTITION_ID |