VIEW: APPS.HZ_ORG_PROFILES_CPUI_V

Source

View Text - Preformatted

SELECT ORG.ORGANIZATION_PROFILE_ID, ORG.PARTY_ID, PTY.PARTY_NUMBER, ORG.ORGANIZATION_NAME, PTY.PARTY_NAME, ORG.ORGANIZATION_NAME_PHONETIC, PTY.SALUTATION, ORG.KNOWN_AS, ORG.KNOWN_AS2, ORG.KNOWN_AS3, ORG.KNOWN_AS4, ORG.KNOWN_AS5, ORG.DUNS_NUMBER_C, ORG.ENQUIRY_DUNS, ORG.CEO_TITLE, ORG.CEO_NAME, ORG.PRINCIPAL_TITLE, ORG.PRINCIPAL_NAME, ORG.LEGAL_STATUS, ORG.CONTROL_YR, ORG.EMPLOYEES_TOTAL, ORG.HQ_BRANCH_IND, ORG.BRANCH_FLAG, ORG.OOB_IND, ORG.LINE_OF_BUSINESS, ORG.CONG_DIST_CODE, ORG.SIC_CODE, ORG.IMPORT_IND, ORG.EXPORT_IND, ORG.LABOR_SURPLUS_IND, ORG.MINORITY_OWNED_IND, ORG.MINORITY_OWNED_TYPE, ORG.WOMAN_OWNED_IND, ORG.DISADV_8A_IND, ORG.SMALL_BUS_IND, ORG.RENT_OWN_IND, ORG.TAX_REFERENCE, ORG.GSA_INDICATOR_FLAG, ORG.JGZZ_FISCAL_CODE, ORG.ANALYSIS_FY, ORG.FISCAL_YEAREND_MONTH, ORG.CURR_FY_POTENTIAL_REVENUE, ORG.NEXT_FY_POTENTIAL_REVENUE, ORG.YEAR_ESTABLISHED, ORG.MISSION_STATEMENT, ORG.ORGANIZATION_TYPE, ORG.BUSINESS_SCOPE, ORG.CORPORATION_CLASS, ORG.LOCAL_BUS_IDEN_TYPE, ORG.LOCAL_BUS_IDENTIFIER, ORG.PREF_FUNCTIONAL_CURRENCY, ORG.REGISTRATION_TYPE, ORG.TOTAL_EMPLOYEES_TEXT, ORG.TOTAL_EMPLOYEES_IND, ORG.TOTAL_EMP_EST_IND, ORG.TOTAL_EMP_MIN_IND, ORG.EMP_AT_PRIMARY_ADR, ORG.EMP_AT_PRIMARY_ADR_TEXT, ORG.EMP_AT_PRIMARY_ADR_EST_IND, ORG.EMP_AT_PRIMARY_ADR_MIN_IND, ORG.PARENT_SUB_IND, ORG.INCORP_YEAR, ORG.LAST_UPDATE_DATE, ORG.LAST_UPDATED_BY, ORG.CREATION_DATE, ORG.CREATED_BY, ORG.LAST_UPDATE_LOGIN, ORG.REQUEST_ID, ORG.PROGRAM_APPLICATION_ID, ORG.PROGRAM_ID, ORG.PROGRAM_UPDATE_DATE, ORG.CONTENT_SOURCE_TYPE, ORG.CONTENT_SOURCE_NUMBER, ORG.EFFECTIVE_START_DATE, ORG.EFFECTIVE_END_DATE, ORG.SIC_CODE_TYPE, ORG.PUBLIC_PRIVATE_OWNERSHIP_FLAG, ORG.LOCAL_ACTIVITY_CODE_TYPE, ORG.LOCAL_ACTIVITY_CODE, ORG.INTERNAL_FLAG, ORG.TOTAL_PAYMENTS, PTY.PARTY_TYPE, PTY.ORIG_SYSTEM_REFERENCE, PTY.VALIDATED_FLAG, PTY.CUSTOMER_KEY, PTY.COUNTRY, PTY.ADDRESS1, PTY.ADDRESS2, PTY.ADDRESS3, PTY.ADDRESS4, PTY.CITY, PTY.POSTAL_CODE, PTY.PROVINCE, PTY.STATUS, PTY.COUNTY, PTY.STATE, PTY.URL, PTY.EMAIL_ADDRESS, PTY.LAST_ORDERED_DATE, PTY.TOTAL_ORDERED_AMOUNT, PTY.TOTAL_NUM_OF_ORDERS, PTY.DO_NOT_MAIL_FLAG, PTY.LANGUAGE_NAME, PTY.CATEGORY_CODE, PTY.REFERENCE_USE_FLAG, PTY.THIRD_PARTY_FLAG, PTY.COMPETITOR_FLAG, ORG.BANK_OR_BRANCH_NUMBER, ORG.BANK_CODE, ORG.BRANCH_CODE, PTY.OBJECT_VERSION_NUMBER PARTY_OBJECT_VERSION_NUMBER, ORG.ACTUAL_CONTENT_SOURCE, PTY.ATTRIBUTE_CATEGORY, PTY.ATTRIBUTE1, PTY.ATTRIBUTE2, PTY.ATTRIBUTE3, PTY.ATTRIBUTE4, PTY.ATTRIBUTE5, PTY.ATTRIBUTE6, PTY.ATTRIBUTE7, PTY.ATTRIBUTE8, PTY.ATTRIBUTE9, PTY.ATTRIBUTE10, PTY.ATTRIBUTE11, PTY.ATTRIBUTE12, PTY.ATTRIBUTE13, PTY.ATTRIBUTE14, PTY.ATTRIBUTE15, PTY.ATTRIBUTE16, PTY.ATTRIBUTE17, PTY.ATTRIBUTE18, PTY.ATTRIBUTE19, PTY.ATTRIBUTE20, PTY.ATTRIBUTE21, PTY.ATTRIBUTE22, PTY.ATTRIBUTE23, PTY.ATTRIBUTE24, PTY.CREATED_BY_MODULE FROM HZ_PARTIES PTY, HZ_ORGANIZATION_PROFILES ORG WHERE ORG.PARTY_ID = PTY.PARTY_ID AND ORG.EFFECTIVE_END_DATE IS NULL

View Text - HTML Formatted

SELECT ORG.ORGANIZATION_PROFILE_ID
, ORG.PARTY_ID
, PTY.PARTY_NUMBER
, ORG.ORGANIZATION_NAME
, PTY.PARTY_NAME
, ORG.ORGANIZATION_NAME_PHONETIC
, PTY.SALUTATION
, ORG.KNOWN_AS
, ORG.KNOWN_AS2
, ORG.KNOWN_AS3
, ORG.KNOWN_AS4
, ORG.KNOWN_AS5
, ORG.DUNS_NUMBER_C
, ORG.ENQUIRY_DUNS
, ORG.CEO_TITLE
, ORG.CEO_NAME
, ORG.PRINCIPAL_TITLE
, ORG.PRINCIPAL_NAME
, ORG.LEGAL_STATUS
, ORG.CONTROL_YR
, ORG.EMPLOYEES_TOTAL
, ORG.HQ_BRANCH_IND
, ORG.BRANCH_FLAG
, ORG.OOB_IND
, ORG.LINE_OF_BUSINESS
, ORG.CONG_DIST_CODE
, ORG.SIC_CODE
, ORG.IMPORT_IND
, ORG.EXPORT_IND
, ORG.LABOR_SURPLUS_IND
, ORG.MINORITY_OWNED_IND
, ORG.MINORITY_OWNED_TYPE
, ORG.WOMAN_OWNED_IND
, ORG.DISADV_8A_IND
, ORG.SMALL_BUS_IND
, ORG.RENT_OWN_IND
, ORG.TAX_REFERENCE
, ORG.GSA_INDICATOR_FLAG
, ORG.JGZZ_FISCAL_CODE
, ORG.ANALYSIS_FY
, ORG.FISCAL_YEAREND_MONTH
, ORG.CURR_FY_POTENTIAL_REVENUE
, ORG.NEXT_FY_POTENTIAL_REVENUE
, ORG.YEAR_ESTABLISHED
, ORG.MISSION_STATEMENT
, ORG.ORGANIZATION_TYPE
, ORG.BUSINESS_SCOPE
, ORG.CORPORATION_CLASS
, ORG.LOCAL_BUS_IDEN_TYPE
, ORG.LOCAL_BUS_IDENTIFIER
, ORG.PREF_FUNCTIONAL_CURRENCY
, ORG.REGISTRATION_TYPE
, ORG.TOTAL_EMPLOYEES_TEXT
, ORG.TOTAL_EMPLOYEES_IND
, ORG.TOTAL_EMP_EST_IND
, ORG.TOTAL_EMP_MIN_IND
, ORG.EMP_AT_PRIMARY_ADR
, ORG.EMP_AT_PRIMARY_ADR_TEXT
, ORG.EMP_AT_PRIMARY_ADR_EST_IND
, ORG.EMP_AT_PRIMARY_ADR_MIN_IND
, ORG.PARENT_SUB_IND
, ORG.INCORP_YEAR
, ORG.LAST_UPDATE_DATE
, ORG.LAST_UPDATED_BY
, ORG.CREATION_DATE
, ORG.CREATED_BY
, ORG.LAST_UPDATE_LOGIN
, ORG.REQUEST_ID
, ORG.PROGRAM_APPLICATION_ID
, ORG.PROGRAM_ID
, ORG.PROGRAM_UPDATE_DATE
, ORG.CONTENT_SOURCE_TYPE
, ORG.CONTENT_SOURCE_NUMBER
, ORG.EFFECTIVE_START_DATE
, ORG.EFFECTIVE_END_DATE
, ORG.SIC_CODE_TYPE
, ORG.PUBLIC_PRIVATE_OWNERSHIP_FLAG
, ORG.LOCAL_ACTIVITY_CODE_TYPE
, ORG.LOCAL_ACTIVITY_CODE
, ORG.INTERNAL_FLAG
, ORG.TOTAL_PAYMENTS
, PTY.PARTY_TYPE
, PTY.ORIG_SYSTEM_REFERENCE
, PTY.VALIDATED_FLAG
, PTY.CUSTOMER_KEY
, PTY.COUNTRY
, PTY.ADDRESS1
, PTY.ADDRESS2
, PTY.ADDRESS3
, PTY.ADDRESS4
, PTY.CITY
, PTY.POSTAL_CODE
, PTY.PROVINCE
, PTY.STATUS
, PTY.COUNTY
, PTY.STATE
, PTY.URL
, PTY.EMAIL_ADDRESS
, PTY.LAST_ORDERED_DATE
, PTY.TOTAL_ORDERED_AMOUNT
, PTY.TOTAL_NUM_OF_ORDERS
, PTY.DO_NOT_MAIL_FLAG
, PTY.LANGUAGE_NAME
, PTY.CATEGORY_CODE
, PTY.REFERENCE_USE_FLAG
, PTY.THIRD_PARTY_FLAG
, PTY.COMPETITOR_FLAG
, ORG.BANK_OR_BRANCH_NUMBER
, ORG.BANK_CODE
, ORG.BRANCH_CODE
, PTY.OBJECT_VERSION_NUMBER PARTY_OBJECT_VERSION_NUMBER
, ORG.ACTUAL_CONTENT_SOURCE
, PTY.ATTRIBUTE_CATEGORY
, PTY.ATTRIBUTE1
, PTY.ATTRIBUTE2
, PTY.ATTRIBUTE3
, PTY.ATTRIBUTE4
, PTY.ATTRIBUTE5
, PTY.ATTRIBUTE6
, PTY.ATTRIBUTE7
, PTY.ATTRIBUTE8
, PTY.ATTRIBUTE9
, PTY.ATTRIBUTE10
, PTY.ATTRIBUTE11
, PTY.ATTRIBUTE12
, PTY.ATTRIBUTE13
, PTY.ATTRIBUTE14
, PTY.ATTRIBUTE15
, PTY.ATTRIBUTE16
, PTY.ATTRIBUTE17
, PTY.ATTRIBUTE18
, PTY.ATTRIBUTE19
, PTY.ATTRIBUTE20
, PTY.ATTRIBUTE21
, PTY.ATTRIBUTE22
, PTY.ATTRIBUTE23
, PTY.ATTRIBUTE24
, PTY.CREATED_BY_MODULE
FROM HZ_PARTIES PTY
, HZ_ORGANIZATION_PROFILES ORG
WHERE ORG.PARTY_ID = PTY.PARTY_ID
AND ORG.EFFECTIVE_END_DATE IS NULL