VIEW: APPS.CSF_M_PARTIES_V

Source

View Text - Preformatted

SELECT acc.access_id, acc.user_id, party.party_id, party.party_number, party.party_name, party.party_type, party.country, party.address1, party.address2, party.address3, party.address4, party.city, party.postal_code, party.state, party.attribute_category, party.attribute1, party.attribute2, party.attribute3, party.attribute4, party.attribute5, party.attribute6, party.attribute7, party.attribute8, party.attribute9, party.attribute10, party.attribute11, party.attribute12, party.attribute13, party.attribute14, party.attribute15, party.attribute16, party.attribute17, party.attribute18, party.attribute19, party.attribute20, party.attribute21, party.attribute22, party.attribute23, party.attribute24, party.PERSON_TITLE , party.PERSON_FIRST_NAME , party.PERSON_MIDDLE_NAME , party.PERSON_LAST_NAME , party.PERSON_FIRST_NAME_PHONETIC , party.PERSON_LAST_NAME_PHONETIC , party.PERSON_NAME_SUFFIX , party.KNOWN_AS, party.EMAIL_ADDRESS FROM CSM_PARTIES_ACC acc, HZ_PARTIES party WHERE acc.party_id = party.party_id and acc.user_id = asg_base.get_user_id

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, ACC.USER_ID
, PARTY.PARTY_ID
, PARTY.PARTY_NUMBER
, PARTY.PARTY_NAME
, PARTY.PARTY_TYPE
, PARTY.COUNTRY
, PARTY.ADDRESS1
, PARTY.ADDRESS2
, PARTY.ADDRESS3
, PARTY.ADDRESS4
, PARTY.CITY
, PARTY.POSTAL_CODE
, PARTY.STATE
, PARTY.ATTRIBUTE_CATEGORY
, PARTY.ATTRIBUTE1
, PARTY.ATTRIBUTE2
, PARTY.ATTRIBUTE3
, PARTY.ATTRIBUTE4
, PARTY.ATTRIBUTE5
, PARTY.ATTRIBUTE6
, PARTY.ATTRIBUTE7
, PARTY.ATTRIBUTE8
, PARTY.ATTRIBUTE9
, PARTY.ATTRIBUTE10
, PARTY.ATTRIBUTE11
, PARTY.ATTRIBUTE12
, PARTY.ATTRIBUTE13
, PARTY.ATTRIBUTE14
, PARTY.ATTRIBUTE15
, PARTY.ATTRIBUTE16
, PARTY.ATTRIBUTE17
, PARTY.ATTRIBUTE18
, PARTY.ATTRIBUTE19
, PARTY.ATTRIBUTE20
, PARTY.ATTRIBUTE21
, PARTY.ATTRIBUTE22
, PARTY.ATTRIBUTE23
, PARTY.ATTRIBUTE24
, PARTY.PERSON_TITLE
, PARTY.PERSON_FIRST_NAME
, PARTY.PERSON_MIDDLE_NAME
, PARTY.PERSON_LAST_NAME
, PARTY.PERSON_FIRST_NAME_PHONETIC
, PARTY.PERSON_LAST_NAME_PHONETIC
, PARTY.PERSON_NAME_SUFFIX
, PARTY.KNOWN_AS
, PARTY.EMAIL_ADDRESS
FROM CSM_PARTIES_ACC ACC
, HZ_PARTIES PARTY
WHERE ACC.PARTY_ID = PARTY.PARTY_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID