VIEW: APPS.JTF_HZ_PARTIES_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","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

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"
, "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