VIEW: APPS.WF_POS_ROLES

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)