VIEW: APPS.HZ_ORGANIZATION_PROFILES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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