VIEW: APPS.HZ_GROUP_WF_ROLES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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