VIEW: APPS.AS_PARTY_CONTACTS_V

Source

View Text - Preformatted

SELECT ROWID ,PARTY_ID , PARTY_NUMBER , PARTY_NAME , PARTY_TYPE , VALIDATED_FLAG , LAST_UPDATED_BY , CREATION_DATE , LAST_UPDATE_LOGIN , REQUEST_ID , PROGRAM_APPLICATION_ID , CREATED_BY , LAST_UPDATE_DATE , PROGRAM_ID , PROGRAM_UPDATE_DATE , WH_UPDATE_DATE , ATTRIBUTE_CATEGORY , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , ATTRIBUTE16 , ATTRIBUTE17 , ATTRIBUTE18 , ATTRIBUTE19 , ATTRIBUTE20 , ATTRIBUTE21 , ATTRIBUTE22 , ATTRIBUTE23 , ATTRIBUTE24 , GLOBAL_ATTRIBUTE_CATEGORY , GLOBAL_ATTRIBUTE1 , GLOBAL_ATTRIBUTE2 , GLOBAL_ATTRIBUTE4 , GLOBAL_ATTRIBUTE3 , GLOBAL_ATTRIBUTE5 , GLOBAL_ATTRIBUTE6 , GLOBAL_ATTRIBUTE7 , GLOBAL_ATTRIBUTE8 , GLOBAL_ATTRIBUTE9 , GLOBAL_ATTRIBUTE10 , GLOBAL_ATTRIBUTE11 , GLOBAL_ATTRIBUTE12 , GLOBAL_ATTRIBUTE13 , GLOBAL_ATTRIBUTE14 , GLOBAL_ATTRIBUTE15 , GLOBAL_ATTRIBUTE16 , GLOBAL_ATTRIBUTE17 , GLOBAL_ATTRIBUTE18 , GLOBAL_ATTRIBUTE19 , GLOBAL_ATTRIBUTE20 , ORIG_SYSTEM_REFERENCE , HQ_BRANCH_IND , CUSTOMER_KEY , TAX_NAME , PERSON_PRE_NAME_ADJUNCT , PERSON_FIRST_NAME , PERSON_MIDDLE_NAME , PERSON_LAST_NAME , PERSON_NAME_SUFFIX , PERSON_TITLE , PERSON_ACADEMIC_TITLE , PERSON_PREVIOUS_LAST_NAME , KNOWN_AS , PERSON_IDEN_TYPE , PERSON_IDENTIFIER , COUNTRY , ADDRESS1 , ADDRESS2 , ADDRESS3 , ADDRESS4 , CITY , POSTAL_CODE , STATE , PROVINCE , STATUS , COUNTY , URL , EMAIL_ADDRESS , DO_NOT_MAIL_FLAG , PERSON_FIRST_NAME_PHONETIC , PERSON_LAST_NAME_PHONETIC , LANGUAGE_NAME , CATEGORY_CODE , SALUTATION FROM HZ_PARTIES WHERE PARTY_TYPE = 'PERSON' AND STATUS IN ('A','I')

View Text - HTML Formatted

SELECT ROWID
, PARTY_ID
, PARTY_NUMBER
, PARTY_NAME
, PARTY_TYPE
, VALIDATED_FLAG
, LAST_UPDATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, CREATED_BY
, LAST_UPDATE_DATE
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, WH_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, ORIG_SYSTEM_REFERENCE
, HQ_BRANCH_IND
, CUSTOMER_KEY
, TAX_NAME
, PERSON_PRE_NAME_ADJUNCT
, PERSON_FIRST_NAME
, PERSON_MIDDLE_NAME
, PERSON_LAST_NAME
, PERSON_NAME_SUFFIX
, PERSON_TITLE
, PERSON_ACADEMIC_TITLE
, PERSON_PREVIOUS_LAST_NAME
, KNOWN_AS
, PERSON_IDEN_TYPE
, PERSON_IDENTIFIER
, COUNTRY
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, POSTAL_CODE
, STATE
, PROVINCE
, STATUS
, COUNTY
, URL
, EMAIL_ADDRESS
, DO_NOT_MAIL_FLAG
, PERSON_FIRST_NAME_PHONETIC
, PERSON_LAST_NAME_PHONETIC
, LANGUAGE_NAME
, CATEGORY_CODE
, SALUTATION
FROM HZ_PARTIES
WHERE PARTY_TYPE = 'PERSON'
AND STATUS IN ('A'
, 'I')