VIEW: APPS.CSL_HZ_PARTIES_V

Source

View Text - Preformatted

SELECT A.ACCESS_ID , B.PARTY_ID , B.PARTY_NUMBER , B.PARTY_NAME , B.PARTY_TYPE , B.STATUS , B.PERSON_TITLE , B.PERSON_FIRST_NAME , B.PERSON_MIDDLE_NAME , B.PERSON_LAST_NAME , B.ATTRIBUTE_CATEGORY , B.ATTRIBUTE1 , B.ATTRIBUTE2 , B.ATTRIBUTE3 , B.ATTRIBUTE4 , B.ATTRIBUTE5 , B.ATTRIBUTE6 , B.ATTRIBUTE7 , B.ATTRIBUTE8 , B.ATTRIBUTE9 , B.ATTRIBUTE10 , B.ATTRIBUTE11 , B.ATTRIBUTE12 , B.ATTRIBUTE13 , B.ATTRIBUTE14 , B.ATTRIBUTE15 , B.ATTRIBUTE16 , B.ATTRIBUTE17 , B.ATTRIBUTE18 , B.ATTRIBUTE19 , B.ATTRIBUTE20 , B.ATTRIBUTE21 , B.ATTRIBUTE22 , B.ATTRIBUTE23 , B.ATTRIBUTE24 , B.PERSON_FIRST_NAME_PHONETIC , B.PERSON_LAST_NAME_PHONETIC , B.PERSON_NAME_SUFFIX FROM CSL_HZ_PARTIES_ACC A , HZ_PARTIES B WHERE A.PARTY_ID = B.PARTY_ID AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID

View Text - HTML Formatted

SELECT A.ACCESS_ID
, B.PARTY_ID
, B.PARTY_NUMBER
, B.PARTY_NAME
, B.PARTY_TYPE
, B.STATUS
, B.PERSON_TITLE
, B.PERSON_FIRST_NAME
, B.PERSON_MIDDLE_NAME
, B.PERSON_LAST_NAME
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.ATTRIBUTE16
, B.ATTRIBUTE17
, B.ATTRIBUTE18
, B.ATTRIBUTE19
, B.ATTRIBUTE20
, B.ATTRIBUTE21
, B.ATTRIBUTE22
, B.ATTRIBUTE23
, B.ATTRIBUTE24
, B.PERSON_FIRST_NAME_PHONETIC
, B.PERSON_LAST_NAME_PHONETIC
, B.PERSON_NAME_SUFFIX
FROM CSL_HZ_PARTIES_ACC A
, HZ_PARTIES B
WHERE A.PARTY_ID = B.PARTY_ID
AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID