View: JTF_HZ_PARTIES_V

Product:	JTF - CRM Foundation
Description:	JTF_HZ_PARTIES_V retrieves information about parties such as organizations, people, and groups, including the identifying address information for the party.
Implementation/DBA Data:	APPS.JTF_HZ_PARTIES_V

View Text

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"
, "SIC_CODE"
, "HQ_BRANCH_IND"
, "CUSTOMER_KEY"
, "TAX_REFERENCE"
, "JGZZ_FISCAL_CODE"
, "DUNS_NUMBER"
, "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"
, "GROUP_TYPE"
, "COUNTRY"
, "ADDRESS1"
, "ADDRESS2"
, "ADDRESS3"
, "ADDRESS4"
, "CITY"
, "POSTAL_CODE"
, "STATE"
, "PROVINCE"
, "STATUS"
, "COUNTY"
, "SIC_CODE_TYPE"
FROM HZ_PARTIES WITH READ ONLY

Columns