View: WF_HZ_GROUP_ROLES

Product:	FND - Application Object Library
Description:	Bulk Sync Directory Service Role View for Orig System HZ_GROUP
Implementation/DBA Data:	APPS.WF_HZ_GROUP_ROLES

View Text

SELECT 'HZ_GROUP:'||TO_CHAR(P.PARTY_ID)
, P.PARTY_NAME
, P.MISSION_STATEMENT
, NVL(CP.EMAIL_FORMAT
, 'MAILTEXT')
, L.NLS_LANGUAGE
, L.NLS_TERRITORY
, P.EMAIL_ADDRESS
, NULL
, 'HZ_GROUP'
, P.PARTY_ID
, TO_DATE(NULL)
, DECODE(P.STATUS
, 'I'
, 'INACTIVE'
, 'ACTIVE')
, TO_DATE(NULL)
, NULL
, 'N'
, 8
FROM HZ_PARTIES P
, HZ_PERSON_LANGUAGE PL
, HZ_CONTACT_POINTS CP
, FND_LANGUAGES L
WHERE P.PARTY_TYPE = 'GROUP'
AND P.STATUS IN ('A'
, 'I')
AND CP.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND P.PARTY_ID = CP.OWNER_TABLE_ID(+)
AND CP.CONTACT_POINT_TYPE(+) = 'EMAIL'
AND CP.PRIMARY_FLAG(+) = 'Y'
AND CP.STATUS(+) = 'A'
AND P.PARTY_ID = PL.PARTY_ID(+)
AND PL.PRIMARY_LANGUAGE_INDICATOR(+) = 'Y'
AND PL.STATUS(+) = 'A'
AND PL.LANGUAGE_NAME = L.LANGUAGE_CODE(+)

Columns