VIEW: AR.HZ_IMP_PARTIES_INT#

Source

View Text - Preformatted

select BATCH_ID BATCH_ID, PARTY_ORIG_SYSTEM PARTY_ORIG_SYSTEM, PARTY_ORIG_SYSTEM_REFERENCE PARTY_ORIG_SYSTEM_REFERENCE, INSERT_UPDATE_FLAG INSERT_UPDATE_FLAG, PARTY_TYPE PARTY_TYPE, PARTY_ID PARTY_ID, PARTY_NUMBER PARTY_NUMBER, SALUTATION SALUTATION, 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, ORGANIZATION_NAME ORGANIZATION_NAME, ORGANIZATION_NAME_PHONETIC ORGANIZATION_NAME_PHONETIC, ORGANIZATION_TYPE ORGANIZATION_TYPE, ANALYSIS_FY ANALYSIS_FY, BRANCH_FLAG BRANCH_FLAG, BUSINESS_SCOPE BUSINESS_SCOPE, CEO_NAME CEO_NAME, CEO_TITLE CEO_TITLE, CONG_DIST_CODE CONG_DIST_CODE, CONTROL_YR CONTROL_YR, CORPORATION_CLASS CORPORATION_CLASS, CURR_FY_POTENTIAL_REVENUE CURR_FY_POTENTIAL_REVENUE, NEXT_FY_POTENTIAL_REVENUE NEXT_FY_POTENTIAL_REVENUE, PREF_FUNCTIONAL_CURRENCY PREF_FUNCTIONAL_CURRENCY, DISADV_8A_IND DISADV_8A_IND, DO_NOT_CONFUSE_WITH DO_NOT_CONFUSE_WITH, DUNS_NUMBER_C DUNS_NUMBER_C, EMP_AT_PRIMARY_ADR EMP_AT_PRIMARY_ADR, EMP_AT_PRIMARY_ADR_EST_IND EMP_AT_PRIMARY_ADR_EST_IND, EMP_AT_PRIMARY_ADR_MIN_IND EMP_AT_PRIMARY_ADR_MIN_IND, EMP_AT_PRIMARY_ADR_TEXT EMP_AT_PRIMARY_ADR_TEXT, EMPLOYEES_TOTAL EMPLOYEES_TOTAL, DISPLAYED_DUNS DISPLAYED_DUNS, EXPORT_IND EXPORT_IND, FISCAL_YEAREND_MONTH FISCAL_YEAREND_MONTH, GSA_INDICATOR_FLAG GSA_INDICATOR_FLAG, HQ_BRANCH_IND HQ_BRANCH_IND, IMPORT_IND IMPORT_IND, INCORP_YEAR INCORP_YEAR, JGZZ_FISCAL_CODE JGZZ_FISCAL_CODE, TAX_REFERENCE TAX_REFERENCE, KNOWN_AS KNOWN_AS, KNOWN_AS2 KNOWN_AS2, KNOWN_AS3 KNOWN_AS3, KNOWN_AS4 KNOWN_AS4, KNOWN_AS5 KNOWN_AS5, LABOR_SURPLUS_IND LABOR_SURPLUS_IND, LEGAL_STATUS LEGAL_STATUS, LINE_OF_BUSINESS LINE_OF_BUSINESS, LOCAL_BUS_IDENTIFIER LOCAL_BUS_IDENTIFIER, LOCAL_BUS_IDEN_TYPE LOCAL_BUS_IDEN_TYPE, MINORITY_OWNED_IND MINORITY_OWNED_IND, MINORITY_OWNED_TYPE MINORITY_OWNED_TYPE, MISSION_STATEMENT MISSION_STATEMENT, OOB_IND OOB_IND, PARENT_SUB_IND PARENT_SUB_IND, PRINCIPAL_NAME PRINCIPAL_NAME, PRINCIPAL_TITLE PRINCIPAL_TITLE, PUBLIC_PRIVATE_OWNERSHIP_FLAG PUBLIC_PRIVATE_OWNERSHIP_FLAG, REGISTRATION_TYPE REGISTRATION_TYPE, RENT_OWN_IND RENT_OWN_IND, SMALL_BUS_IND SMALL_BUS_IND, TOTAL_EMP_EST_IND TOTAL_EMP_EST_IND, TOTAL_EMP_MIN_IND TOTAL_EMP_MIN_IND, TOTAL_EMPLOYEES_IND TOTAL_EMPLOYEES_IND, TOTAL_EMPLOYEES_TEXT TOTAL_EMPLOYEES_TEXT, TOTAL_PAYMENTS TOTAL_PAYMENTS, WOMAN_OWNED_IND WOMAN_OWNED_IND, YEAR_ESTABLISHED YEAR_ESTABLISHED, PERSON_FIRST_NAME PERSON_FIRST_NAME, PERSON_LAST_NAME PERSON_LAST_NAME, PERSON_MIDDLE_NAME PERSON_MIDDLE_NAME, PERSON_INITIALS PERSON_INITIALS, PERSON_NAME_SUFFIX PERSON_NAME_SUFFIX, PERSON_PRE_NAME_ADJUNCT PERSON_PRE_NAME_ADJUNCT, PERSON_PREVIOUS_LAST_NAME PERSON_PREVIOUS_LAST_NAME, PERSON_TITLE PERSON_TITLE, PERSON_FIRST_NAME_PHONETIC PERSON_FIRST_NAME_PHONETIC, PERSON_LAST_NAME_PHONETIC PERSON_LAST_NAME_PHONETIC, PERSON_MIDDLE_NAME_PHONETIC PERSON_MIDDLE_NAME_PHONETIC, PERSON_NAME_PHONETIC PERSON_NAME_PHONETIC, PERSON_ACADEMIC_TITLE PERSON_ACADEMIC_TITLE, DATE_OF_BIRTH DATE_OF_BIRTH, PLACE_OF_BIRTH PLACE_OF_BIRTH, DATE_OF_DEATH DATE_OF_DEATH, DECEASED_FLAG DECEASED_FLAG, DECLARED_ETHNICITY DECLARED_ETHNICITY, GENDER GENDER, HEAD_OF_HOUSEHOLD_FLAG HEAD_OF_HOUSEHOLD_FLAG, HOUSEHOLD_INCOME HOUSEHOLD_INCOME, HOUSEHOLD_SIZE HOUSEHOLD_SIZE, MARITAL_STATUS MARITAL_STATUS, MARITAL_STATUS_EFFECTIVE_DATE MARITAL_STATUS_EFFECTIVE_DATE, PERSON_IDEN_TYPE PERSON_IDEN_TYPE, PERSON_IDENTIFIER PERSON_IDENTIFIER, PERSONAL_INCOME PERSONAL_INCOME, INTERFACE_STATUS INTERFACE_STATUS, DQM_ACTION_FLAG DQM_ACTION_FLAG, DUP_WITHIN_INT_FLAG DUP_WITHIN_INT_FLAG, ERROR_ID ERROR_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CREATED_BY_MODULE CREATED_BY_MODULE from "AR"."HZ_IMP_PARTIES_INT"

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, PARTY_ORIG_SYSTEM PARTY_ORIG_SYSTEM
, PARTY_ORIG_SYSTEM_REFERENCE PARTY_ORIG_SYSTEM_REFERENCE
, INSERT_UPDATE_FLAG INSERT_UPDATE_FLAG
, PARTY_TYPE PARTY_TYPE
, PARTY_ID PARTY_ID
, PARTY_NUMBER PARTY_NUMBER
, SALUTATION SALUTATION
, 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
, ORGANIZATION_NAME ORGANIZATION_NAME
, ORGANIZATION_NAME_PHONETIC ORGANIZATION_NAME_PHONETIC
, ORGANIZATION_TYPE ORGANIZATION_TYPE
, ANALYSIS_FY ANALYSIS_FY
, BRANCH_FLAG BRANCH_FLAG
, BUSINESS_SCOPE BUSINESS_SCOPE
, CEO_NAME CEO_NAME
, CEO_TITLE CEO_TITLE
, CONG_DIST_CODE CONG_DIST_CODE
, CONTROL_YR CONTROL_YR
, CORPORATION_CLASS CORPORATION_CLASS
, CURR_FY_POTENTIAL_REVENUE CURR_FY_POTENTIAL_REVENUE
, NEXT_FY_POTENTIAL_REVENUE NEXT_FY_POTENTIAL_REVENUE
, PREF_FUNCTIONAL_CURRENCY PREF_FUNCTIONAL_CURRENCY
, DISADV_8A_IND DISADV_8A_IND
, DO_NOT_CONFUSE_WITH DO_NOT_CONFUSE_WITH
, DUNS_NUMBER_C DUNS_NUMBER_C
, EMP_AT_PRIMARY_ADR EMP_AT_PRIMARY_ADR
, EMP_AT_PRIMARY_ADR_EST_IND EMP_AT_PRIMARY_ADR_EST_IND
, EMP_AT_PRIMARY_ADR_MIN_IND EMP_AT_PRIMARY_ADR_MIN_IND
, EMP_AT_PRIMARY_ADR_TEXT EMP_AT_PRIMARY_ADR_TEXT
, EMPLOYEES_TOTAL EMPLOYEES_TOTAL
, DISPLAYED_DUNS DISPLAYED_DUNS
, EXPORT_IND EXPORT_IND
, FISCAL_YEAREND_MONTH FISCAL_YEAREND_MONTH
, GSA_INDICATOR_FLAG GSA_INDICATOR_FLAG
, HQ_BRANCH_IND HQ_BRANCH_IND
, IMPORT_IND IMPORT_IND
, INCORP_YEAR INCORP_YEAR
, JGZZ_FISCAL_CODE JGZZ_FISCAL_CODE
, TAX_REFERENCE TAX_REFERENCE
, KNOWN_AS KNOWN_AS
, KNOWN_AS2 KNOWN_AS2
, KNOWN_AS3 KNOWN_AS3
, KNOWN_AS4 KNOWN_AS4
, KNOWN_AS5 KNOWN_AS5
, LABOR_SURPLUS_IND LABOR_SURPLUS_IND
, LEGAL_STATUS LEGAL_STATUS
, LINE_OF_BUSINESS LINE_OF_BUSINESS
, LOCAL_BUS_IDENTIFIER LOCAL_BUS_IDENTIFIER
, LOCAL_BUS_IDEN_TYPE LOCAL_BUS_IDEN_TYPE
, MINORITY_OWNED_IND MINORITY_OWNED_IND
, MINORITY_OWNED_TYPE MINORITY_OWNED_TYPE
, MISSION_STATEMENT MISSION_STATEMENT
, OOB_IND OOB_IND
, PARENT_SUB_IND PARENT_SUB_IND
, PRINCIPAL_NAME PRINCIPAL_NAME
, PRINCIPAL_TITLE PRINCIPAL_TITLE
, PUBLIC_PRIVATE_OWNERSHIP_FLAG PUBLIC_PRIVATE_OWNERSHIP_FLAG
, REGISTRATION_TYPE REGISTRATION_TYPE
, RENT_OWN_IND RENT_OWN_IND
, SMALL_BUS_IND SMALL_BUS_IND
, TOTAL_EMP_EST_IND TOTAL_EMP_EST_IND
, TOTAL_EMP_MIN_IND TOTAL_EMP_MIN_IND
, TOTAL_EMPLOYEES_IND TOTAL_EMPLOYEES_IND
, TOTAL_EMPLOYEES_TEXT TOTAL_EMPLOYEES_TEXT
, TOTAL_PAYMENTS TOTAL_PAYMENTS
, WOMAN_OWNED_IND WOMAN_OWNED_IND
, YEAR_ESTABLISHED YEAR_ESTABLISHED
, PERSON_FIRST_NAME PERSON_FIRST_NAME
, PERSON_LAST_NAME PERSON_LAST_NAME
, PERSON_MIDDLE_NAME PERSON_MIDDLE_NAME
, PERSON_INITIALS PERSON_INITIALS
, PERSON_NAME_SUFFIX PERSON_NAME_SUFFIX
, PERSON_PRE_NAME_ADJUNCT PERSON_PRE_NAME_ADJUNCT
, PERSON_PREVIOUS_LAST_NAME PERSON_PREVIOUS_LAST_NAME
, PERSON_TITLE PERSON_TITLE
, PERSON_FIRST_NAME_PHONETIC PERSON_FIRST_NAME_PHONETIC
, PERSON_LAST_NAME_PHONETIC PERSON_LAST_NAME_PHONETIC
, PERSON_MIDDLE_NAME_PHONETIC PERSON_MIDDLE_NAME_PHONETIC
, PERSON_NAME_PHONETIC PERSON_NAME_PHONETIC
, PERSON_ACADEMIC_TITLE PERSON_ACADEMIC_TITLE
, DATE_OF_BIRTH DATE_OF_BIRTH
, PLACE_OF_BIRTH PLACE_OF_BIRTH
, DATE_OF_DEATH DATE_OF_DEATH
, DECEASED_FLAG DECEASED_FLAG
, DECLARED_ETHNICITY DECLARED_ETHNICITY
, GENDER GENDER
, HEAD_OF_HOUSEHOLD_FLAG HEAD_OF_HOUSEHOLD_FLAG
, HOUSEHOLD_INCOME HOUSEHOLD_INCOME
, HOUSEHOLD_SIZE HOUSEHOLD_SIZE
, MARITAL_STATUS MARITAL_STATUS
, MARITAL_STATUS_EFFECTIVE_DATE MARITAL_STATUS_EFFECTIVE_DATE
, PERSON_IDEN_TYPE PERSON_IDEN_TYPE
, PERSON_IDENTIFIER PERSON_IDENTIFIER
, PERSONAL_INCOME PERSONAL_INCOME
, INTERFACE_STATUS INTERFACE_STATUS
, DQM_ACTION_FLAG DQM_ACTION_FLAG
, DUP_WITHIN_INT_FLAG DUP_WITHIN_INT_FLAG
, ERROR_ID ERROR_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CREATED_BY_MODULE CREATED_BY_MODULE
FROM "AR"."HZ_IMP_PARTIES_INT"