HZ_ORGANIZATION_PROFILES_V

Details

• Schema: FUSION

• Object owner: HZ

• Object type: VIEW

Columns

Name

ORGANIZATION_PROFILE_ID PARTY_ID ORGANIZATION_NAME ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ENQUIRY_DUNS CEO_NAME CEO_TITLE PRINCIPAL_NAME PRINCIPAL_TITLE LEGAL_STATUS CONTROL_YR EMPLOYEES_TOTAL HQ_BRANCH_IND BRANCH_FLAG OOB_IND LINE_OF_BUSINESS CONG_DIST_CODE IMPORT_IND EXPORT_IND LABOR_SURPLUS_IND MINORITY_OWNED_IND MINORITY_OWNED_TYPE WOMAN_OWNED_IND DISADV_8A_IND SMALL_BUS_IND RENT_OWN_IND DB_RATING GSA_INDICATOR_FLAG JGZZ_FISCAL_CODE ANALYSIS_FY FISCAL_YEAREND_MONTH CURR_FY_POTENTIAL_REVENUE NEXT_FY_POTENTIAL_REVENUE YEAR_ESTABLISHED MISSION_STATEMENT ORGANIZATION_TYPE BUSINESS_SCOPE CORPORATION_CLASS LOCAL_BUS_IDEN_TYPE LOCAL_BUS_IDENTIFIER PREF_FUNCTIONAL_CURRENCY REGISTRATION_TYPE TOTAL_EMPLOYEES_TEXT TOTAL_EMPLOYEES_IND TOTAL_EMP_EST_IND TOTAL_EMP_MIN_IND PARENT_SUB_IND INCORP_YEAR LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE CONTENT_SOURCE_NUMBER EFFECTIVE_START_DATE EFFECTIVE_END_DATE PUBLIC_PRIVATE_OWNERSHIP_FLAG LOCAL_ACTIVITY_CODE_TYPE LOCAL_ACTIVITY_CODE EMP_AT_PRIMARY_ADR EMP_AT_PRIMARY_ADR_TEXT EMP_AT_PRIMARY_ADR_EST_IND EMP_AT_PRIMARY_ADR_MIN_IND INTERNAL_FLAG TOTAL_PAYMENTS PARTY_NUMBER PARTY_NAME PARTY_TYPE ORIG_SYSTEM_REFERENCE VALIDATED_FLAG COUNTRY ADDRESS1 ADDRESS2 ADDRESS3 ADDRESS4 CITY POSTAL_CODE PROVINCE STATUS COUNTY STATE URL EMAIL_ADDRESS LANGUAGE_NAME CATEGORY_CODE THIRD_PARTY_FLAG SALUTATION BANK_OR_BRANCH_NUMBER BANK_CODE BRANCH_CODE OBJECT_VERSION_NUMBER ACTUAL_CONTENT_SOURCE DUNS_NUMBER_C PARENT_DUNS_NUM_C GLOBAL_ULTIMATE_DUNS_NUM_C DOMESTIC_ULTIMATE_DUNS_NUM_C

Query

SQL_Statement

SELECT A.ORGANIZATION_PROFILE_ID, A.PARTY_ID, A.ORGANIZATION_NAME, A.ATTRIBUTE_CATEGORY, A.ATTRIBUTE1, A.ATTRIBUTE2, A.ATTRIBUTE3, A.ATTRIBUTE4, A.ATTRIBUTE5, A.ATTRIBUTE6, A.ATTRIBUTE7, A.ATTRIBUTE8, A.ATTRIBUTE9, A.ATTRIBUTE10, A.ATTRIBUTE11, A.ATTRIBUTE12, A.ATTRIBUTE13, A.ATTRIBUTE14, A.ATTRIBUTE15, A.ATTRIBUTE16, A.ATTRIBUTE17, A.ATTRIBUTE18, A.ATTRIBUTE19, A.ATTRIBUTE20, A.ENQUIRY_DUNS, A.CEO_NAME, A.CEO_TITLE, A.PRINCIPAL_NAME, A.PRINCIPAL_TITLE, A.LEGAL_STATUS, A.CONTROL_YR, A.EMPLOYEES_TOTAL, A.HQ_BRANCH_IND, A.BRANCH_FLAG, A.OOB_IND, A.LINE_OF_BUSINESS, A.CONG_DIST_CODE, A.IMPORT_IND, A.EXPORT_IND, A.LABOR_SURPLUS_IND, A.MINORITY_OWNED_IND, A.MINORITY_OWNED_TYPE, A.WOMAN_OWNED_IND, A.DISADV_8A_IND, A.SMALL_BUS_IND, A.RENT_OWN_IND, A.DB_RATING, A.GSA_INDICATOR_FLAG, A.JGZZ_FISCAL_CODE, A.ANALYSIS_FY, A.FISCAL_YEAREND_MONTH, A.CURR_FY_POTENTIAL_REVENUE, A.NEXT_FY_POTENTIAL_REVENUE, A.YEAR_ESTABLISHED, A.MISSION_STATEMENT, A.ORGANIZATION_TYPE, A.BUSINESS_SCOPE, A.CORPORATION_CLASS, A.LOCAL_BUS_IDEN_TYPE, A.LOCAL_BUS_IDENTIFIER, A.PREF_FUNCTIONAL_CURRENCY, A.REGISTRATION_TYPE, A.TOTAL_EMPLOYEES_TEXT, A.TOTAL_EMPLOYEES_IND, A.TOTAL_EMP_EST_IND, A.TOTAL_EMP_MIN_IND, A.PARENT_SUB_IND, A.INCORP_YEAR, A.LAST_UPDATE_DATE, A.LAST_UPDATED_BY, A.CREATION_DATE, A.CREATED_BY, A.LAST_UPDATE_LOGIN, A.REQUEST_ID, A.JOB_DEFINITION_NAME, A.JOB_DEFINITION_PACKAGE, A.CONTENT_SOURCE_NUMBER, A.EFFECTIVE_START_DATE, A.EFFECTIVE_END_DATE, A.PUBLIC_PRIVATE_OWNERSHIP_FLAG, A.LOCAL_ACTIVITY_CODE_TYPE, A.LOCAL_ACTIVITY_CODE, A.EMP_AT_PRIMARY_ADR, A.EMP_AT_PRIMARY_ADR_TEXT, A.EMP_AT_PRIMARY_ADR_EST_IND, A.EMP_AT_PRIMARY_ADR_MIN_IND, A.INTERNAL_FLAG, A.TOTAL_PAYMENTS, B.PARTY_NUMBER, B.PARTY_NAME, B.PARTY_TYPE, B.ORIG_SYSTEM_REFERENCE, B.VALIDATED_FLAG, B.COUNTRY, B.ADDRESS1, B.ADDRESS2, B.ADDRESS3, B.ADDRESS4, B.CITY, B.POSTAL_CODE, B.PROVINCE, B.STATUS, B.COUNTY, B.STATE, B.URL, B.EMAIL_ADDRESS, B.LANGUAGE_NAME, B.CATEGORY_CODE, B.THIRD_PARTY_FLAG, B.SALUTATION, A.BANK_OR_BRANCH_NUMBER, A.BANK_CODE, A.BRANCH_CODE, B.OBJECT_VERSION_NUMBER, A.ACTUAL_CONTENT_SOURCE, B.DUNS_NUMBER_C, A.PARENT_DUNS_NUM_C, A.GLOBAL_ULTIMATE_DUNS_NUM_C, A.DOMESTIC_ULTIMATE_DUNS_NUM_C FROM HZ_PARTIES B, HZ_ORGANIZATION_PROFILES A WHERE A.PARTY_ID = B.PARTY_ID AND A.EFFECTIVE_END_DATE IS NULL AND SUBSTR(B.COUNTRY, 1, 2) = 'B.COUNTRY'