VIEW: APPS.WF_HZ_GROUP_ROLES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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