View: HZ_PARTY_WF_ROLES_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.HZ_PARTY_WF_ROLES_V

View Text

SELECT 'HZ_PARTY:'||TO_CHAR(INLINE.PER_ID) NAME
, NVL(INLINE.SUBJ_NAME
, INLINE.PER_NAME) DISPLAY_NAME
, INLINE.PER_NAME DESCRIPTION
, NVL2(INLINE.EMAIL_ADDRESS
, NVL(SUBSTRB(CP.EMAIL_FORMAT
, 1
, 8)
, 'MAILTEXT')
, 'QUERY') NOTIFICATION_PREFERENCE
, L1.NLS_LANGUAGE LANGUAGE
, L1.NLS_TERRITORY TERRITORY
, SUBSTRB(INLINE.EMAIL_ADDRESS
, 1
, 320) EMAIL_ADDRESS
, NULL FAX
, 'HZ_PARTY' ORIG_SYSTEM
, INLINE.PER_ID ORIG_SYSTEM_ID
, INLINE.START_DATE START_DATE
, DECODE(INLINE.STATUS
, 'A'
, 'ACTIVE'
, 'INACTIVE') STATUS
, INLINE.EXPIRATION_DATE EXPIRATION_DATE
, NULL SECURITY_GROUP_ID
, 'Y' USER_FLAG
, 9 PARTITION_ID
FROM ( SELECT NVL2(PR.PARTY_ID
, SUBJ.PARTY_ID
, P.PARTY_ID) PARTY
, P.PARTY_TYPE PARTY_TYPE
, PR.PARTY_ID REL_PARTY_ID
, P.PARTY_ID PER_ID
, P.PARTY_NAME PER_NAME
, SUBJ.PARTY_NAME SUBJ_NAME
, P.EMAIL_ADDRESS
, P.STATUS
, PR.START_DATE START_DATE
, PR.END_DATE EXPIRATION_DATE
FROM HZ_PARTIES P
, HZ_RELATIONSHIPS PR
, HZ_PARTIES SUBJ
WHERE P.PARTY_TYPE IN ('PERSON'
, 'PARTY_RELATIONSHIP')
AND PR.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
AND PR.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
AND ((PR.SUBJECT_TYPE IS NOT NULL
AND (PR.SUBJECT_TYPE = 'PERSON' )
AND (PR.OBJECT_TYPE = 'ORGANIZATION')) OR (PR.SUBJECT_TYPE IS NOT NULL
AND (PR.SUBJECT_TYPE = 'PERSON')
AND (PR.OBJECT_TYPE = 'PERSON')
AND ( PR.DIRECTIONAL_FLAG = 'F')) OR (PR.SUBJECT_TYPE IS NULL))
AND P.STATUS IN ('A'
, 'I')
AND PR.PARTY_ID(+) = P.PARTY_ID
AND PR.STATUS(+) <> 'M'
AND PR.STATUS(+) <> 'D'
AND PR.SUBJECT_ID = SUBJ.PARTY_ID(+) ) INLINE
, HZ_PERSON_LANGUAGE PL
, FND_LANGUAGES L1
, HZ_CONTACT_POINTS CP
WHERE CP.OWNER_TABLE_ID(+) = INLINE.PER_ID
AND CP.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND CP.CONTACT_POINT_TYPE(+) = 'EMAIL'
AND CP.EMAIL_ADDRESS(+) = INLINE.EMAIL_ADDRESS
AND CP.PRIMARY_FLAG(+) = 'Y'
AND CP.STATUS(+) = 'A'
AND PL.PARTY_ID(+) = INLINE.PARTY
AND PL.PRIMARY_LANGUAGE_INDICATOR(+) = 'Y'
AND PL.STATUS(+) = 'A'
AND L1.LANGUAGE_CODE(+) = PL.LANGUAGE_NAME

Columns