[Home] [Help]
View: HZ_GROUP_WF_ROLES_V
View Text
SELECT 'HZ_GROUP:'||TO_CHAR(P.PARTY_ID) NAME
, P.PARTY_NAME DISPLAY_NAME
, SUBSTRB(P.MISSION_STATEMENT
, 1
, 1000) DESCRIPTION
, NVL2(P.EMAIL_ADDRESS
, NVL(SUBSTRB(CP.EMAIL_FORMAT
, 1
, 8)
, 'MAILTEXT')
, 'QUERY') NOTIFICATION_PREFERENCE
, L.NLS_LANGUAGE LANGUAGE
, L.NLS_TERRITORY TERRITORY
, SUBSTRB(P.EMAIL_ADDRESS
, 1
, 320) EMAIL_ADDRESS
, NULL FAX
, 'HZ_GROUP' ORIG_SYSTEM
, P.PARTY_ID ORIG_SYSTEM_ID
, NULL START_DATE
, DECODE(P.STATUS
, 'I'
, 'INACTIVE'
, 'ACTIVE') STATUS
, NULL EXPIRATION_DATE
, NULL SECURITY_GROUP_ID
, 'N' USER_FLAG
, 8 PARTITION_ID
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 CP.OWNER_TABLE_ID(+) = P.PARTY_ID
AND CP.CONTACT_POINT_TYPE(+) = 'EMAIL'
AND CP.EMAIL_ADDRESS(+) = P.EMAIL_ADDRESS
AND CP.PRIMARY_FLAG(+) = 'Y'
AND CP.STATUS(+) = 'A'
AND PL.PARTY_ID(+) = P.PARTY_ID
AND PL.PRIMARY_LANGUAGE_INDICATOR(+) = 'Y'
AND PL.STATUS(+) = 'A'
AND L.LANGUAGE_CODE(+) = PL.LANGUAGE_NAME
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 |