View: HZ_ORG_PROFILES_CPUI_V

Product:	AR - Receivables
Description:	Organization Profiles
Implementation/DBA Data:	APPS.HZ_ORG_PROFILES_CPUI_V

View Text

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

Columns