View: JTF_PARTIES_ALL_V

Product:	JTF - CRM Foundation
Description:	Party information of the Caller, Customer and Relationship
Implementation/DBA Data:	APPS.JTF_PARTIES_ALL_V

View Text

SELECT PARTY_ID PARTY_ID
, PARTY_NUMBER PARTY_NUMBER
, PARTY_NAME PARTY_NAME
, PARTY_TYPE PARTY_TYPE
, VALIDATED_FLAG VALIDATED_FLAG
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, WH_UPDATE_DATE WH_UPDATE_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ATTRIBUTE21 ATTRIBUTE21
, ATTRIBUTE22 ATTRIBUTE22
, ATTRIBUTE23 ATTRIBUTE23
, ATTRIBUTE24 ATTRIBUTE24
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, SIC_CODE SIC_CODE
, HQ_BRANCH_IND HQ_BRANCH_IND
, CUSTOMER_KEY CUSTOMER_KEY
, TAX_REFERENCE TAX_REFERENCE
, JGZZ_FISCAL_CODE JGZZ_FISCAL_CODE
, DUNS_NUMBER DUNS_NUMBER
, TAX_NAME TAX_NAME
, PERSON_PRE_NAME_ADJUNCT PERSON_PRE_NAME_ADJUNCT
, PERSON_FIRST_NAME PERSON_FIRST_NAME
, PERSON_MIDDLE_NAME PERSON_MIDDLE_NAME
, PERSON_LAST_NAME PERSON_LAST_NAME
, PERSON_NAME_SUFFIX PERSON_NAME_SUFFIX
, PERSON_TITLE PERSON_TITLE
, PERSON_ACADEMIC_TITLE PERSON_ACADEMIC_TITLE
, PERSON_PREVIOUS_LAST_NAME PERSON_PREVIOUS_LAST_NAME
, KNOWN_AS KNOWN_AS
, PERSON_IDEN_TYPE PERSON_IDEN_TYPE
, PERSON_IDENTIFIER PERSON_IDENTIFIER
, GROUP_TYPE GROUP_TYPE
, COUNTRY COUNTRY
, ADDRESS1 ADDRESS1
, ADDRESS2 ADDRESS2
, ADDRESS3 ADDRESS3
, ADDRESS4 ADDRESS4
, CITY CITY
, POSTAL_CODE POSTAL_CODE
, STATE STATE
, PROVINCE PROVINCE
, STATUS STATUS
, COUNTY COUNTY
, SIC_CODE_TYPE SIC_CODE_TYPE
FROM HZ_PARTIES

Columns