Product: | JTF - CRM Foundation |
---|---|
Description: | JTF_HZ_ORGANIZATION_PROFILES_V retrieves information about people as contacts for organizations. The table includes information about the person in the context of the organization such as their job title or rank. |
Implementation/DBA Data: | APPS.JTF_HZ_ORGANIZATION_PROFILES_V |
SELECT ROWID
, 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
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, DUNS_NUMBER
, 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
, SIC_CODE
, IMPORT_IND
, EXPORT_IND
, LABOR_SURPLUS_IND
, DEBARMENT_IND
, MINORITY_OWNED_IND
, MINORITY_OWNED_TYPE
, WOMAN_OWNED_IND
, DISADV_8A_IND
, SMALL_BUS_IND
, RENT_OWN_IND
, DEBARMENTS_COUNT
, DEBARMENTS_DATE
, FAILURE_SCORE
, FAILURE_SCORE_NATL_PERCENTILE
, FAILURE_SCORE_OVERRIDE_CODE
, FAILURE_SCORE_COMMENTARY
, GLOBAL_FAILURE_SCORE
, DB_RATING
, CREDIT_SCORE
, CREDIT_SCORE_COMMENTARY
, PAYDEX_SCORE
, PAYDEX_THREE_MONTHS_AGO
, PAYDEX_NORM
, BEST_TIME_CONTACT_BEGIN
, BEST_TIME_CONTACT_END
, ORGANIZATION_NAME_PHONETIC
, TAX_NAME
, TAX_REFERENCE
, 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
, KNOWN_AS
, LOCAL_BUS_IDEN_TYPE
, LOCAL_BUS_IDENTIFIER
, PREF_FUNCTIONAL_CURRENCY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, WH_UPDATE_DATE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM HZ_ORGANIZATION_PROFILES WITH READ ONLY