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