View: HZ_ORGANIZATION_PROFILES_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.HZ_ORGANIZATION_PROFILES_V

View Text

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.GLOBAL_ATTRIBUTE_CATEGORY
, A.GLOBAL_ATTRIBUTE1
, A.GLOBAL_ATTRIBUTE2
, A.GLOBAL_ATTRIBUTE3
, A.GLOBAL_ATTRIBUTE4
, A.GLOBAL_ATTRIBUTE5
, A.GLOBAL_ATTRIBUTE6
, A.GLOBAL_ATTRIBUTE7
, A.GLOBAL_ATTRIBUTE8
, A.GLOBAL_ATTRIBUTE9
, A.GLOBAL_ATTRIBUTE10
, A.GLOBAL_ATTRIBUTE11
, A.GLOBAL_ATTRIBUTE12
, A.GLOBAL_ATTRIBUTE13
, A.GLOBAL_ATTRIBUTE14
, A.GLOBAL_ATTRIBUTE15
, A.GLOBAL_ATTRIBUTE16
, A.GLOBAL_ATTRIBUTE17
, A.GLOBAL_ATTRIBUTE18
, A.GLOBAL_ATTRIBUTE19
, A.GLOBAL_ATTRIBUTE20
, A.DUNS_NUMBER
, 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.SIC_CODE
, A.IMPORT_IND
, A.EXPORT_IND
, A.LABOR_SURPLUS_IND
, A.DEBARMENT_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.DEBARMENTS_COUNT
, A.DEBARMENTS_DATE
, A.FAILURE_SCORE
, A.FAILURE_SCORE_NATL_PERCENTILE
, A.FAILURE_SCORE_OVERRIDE_CODE
, A.FAILURE_SCORE_COMMENTARY
, A.GLOBAL_FAILURE_SCORE
, A.DB_RATING
, A.CREDIT_SCORE
, A.CREDIT_SCORE_COMMENTARY
, A.PAYDEX_SCORE
, A.PAYDEX_THREE_MONTHS_AGO
, A.PAYDEX_NORM
, A.BEST_TIME_CONTACT_BEGIN
, A.BEST_TIME_CONTACT_END
, A.ORGANIZATION_NAME_PHONETIC
, A.TAX_NAME
, A.TAX_REFERENCE
, 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.KNOWN_AS
, 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.PRIMARY_CONTACT_ID
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.WH_UPDATE_DATE
, A.REQUEST_ID
, A.PROGRAM_APPLICATION_ID
, A.PROGRAM_ID
, A.PROGRAM_UPDATE_DATE
, A.CONTENT_SOURCE_TYPE
, A.CONTENT_SOURCE_NUMBER
, A.EFFECTIVE_START_DATE
, A.EFFECTIVE_END_DATE
, A.SIC_CODE_TYPE
, 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.HIGH_CREDIT
, A.AVG_HIGH_CREDIT
, A.TOTAL_PAYMENTS
, A.KNOWN_AS2
, A.KNOWN_AS3
, A.KNOWN_AS4
, A.KNOWN_AS5
, B.PARTY_NUMBER
, B.PARTY_NAME
, B.PARTY_TYPE
, B.ORIG_SYSTEM_REFERENCE
, B.VALIDATED_FLAG
, B.CUSTOMER_KEY
, 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.LAST_ORDERED_DATE
, B.TOTAL_ORDERED_AMOUNT
, B.TOTAL_NUM_OF_ORDERS
, B.DO_NOT_MAIL_FLAG
, B.LANGUAGE_NAME
, B.CATEGORY_CODE
, B.REFERENCE_USE_FLAG
, B.THIRD_PARTY_FLAG
, B.COMPETITOR_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
FROM HZ_PARTIES B
, HZ_ORGANIZATION_PROFILES A
WHERE (A.PARTY_ID = B.PARTY_ID)
AND A.EFFECTIVE_END_DATE IS NULL

Columns