DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.JTF_HZ_ORGANIZATION_PROFILES_V

Object Details
Object Name: JTF_HZ_ORGANIZATION_PROFILES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_HZ_ORGANIZATION_PROFILES_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


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.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Id
ORGANIZATION_PROFILE_ID NUMBER (15) Yes Unique identifier for organization profiles.
PARTY_ID NUMBER (15) Yes Unique party indentifier. Foreign key to the HZ_PARTIES table
ORGANIZATION_NAME VARCHAR2 (360) Yes Name of a party of the Organization party type
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield segment
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Reserved for globalization functionality
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Reserved for globalization functionality
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Reserved for globalization functionality
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Reserved for globalization functionality
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Reserved for globalization functionality
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Reserved for globalization functionality
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Reserved for globalization functionality
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Reserved for globalization functionality
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Reserved for globalization functionality
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Reserved for globalization functionality
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Reserved for globalization functionality
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Reserved for globalization functionality
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Reserved for globalization functionality
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Reserved for globalization functionality
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Reserved for globalization functionality
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Reserved for globalization functionality
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Reserved for globalization functionality
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Reserved for globalization functionality
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Reserved for globalization functionality
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Reserved for globalization functionality
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Reserved for globalization functionality
DUNS_NUMBER NUMBER

DUNS number, a unique, nine-digit identification number that is assigned to business entities by Dun & Bradstreet
ENQUIRY_DUNS VARCHAR2 (15)
Identifier used to query the Dun & Bradstreet data. If a location is a branch, then in some countries the headquarters DUNS number is used to do the query. Otherwise it is the same as the DUNS number.
CEO_NAME VARCHAR2 (240)
Name of the chief executive officer
CEO_TITLE VARCHAR2 (240)
Formal title of the chief executive officer
PRINCIPAL_NAME VARCHAR2 (240)
Name of the highest ranking person in the company
PRINCIPAL_TITLE VARCHAR2 (240)
Title of the highest ranking person in the company
LEGAL_STATUS VARCHAR2 (30)
Legal structure. For example, partnership, corporation, and so on.
CONTROL_YR NUMBER

Year when current ownership gained control
EMPLOYEES_TOTAL NUMBER

Total number of employees
HQ_BRANCH_IND VARCHAR2 (30)
Status of this site. Identifies if the location is the HQ, a branch, or a single location.
BRANCH_FLAG VARCHAR2 (1)
Indicates if this is a branch location. Y for branch locations, N for all other locations.
OOB_IND VARCHAR2 (30)
Indicates if this organization is out of business. Y for businesses that are out of business, N for active businesses.
LINE_OF_BUSINESS VARCHAR2 (240)
Type of business activities performed at this site
CONG_DIST_CODE VARCHAR2 (2)
U.S. Congressional District
SIC_CODE VARCHAR2 (30)
Standard Industry Classification (SIC) code
IMPORT_IND VARCHAR2 (30)
Indicates if this company is an importer. Y for an importer, N for an organization that does not import.
EXPORT_IND VARCHAR2 (30)
Indicates if this company is an exporter. Y for an exporter, N for an organization that does not export.
LABOR_SURPLUS_IND VARCHAR2 (30)
Indicates if this company operates in an area with a labor surplus. Y for a surplus, N for no surplus exists.
DEBARMENT_IND VARCHAR2 (30)
No longer used
MINORITY_OWNED_IND VARCHAR2 (30)
Indicates if this company is primarily owned by ethnic or racial minorities. Y for a minority-owned frim, N for a firm that is not owned by minorities
MINORITY_OWNED_TYPE VARCHAR2 (30)
The type of minority-owned frim
WOMAN_OWNED_IND VARCHAR2 (30)
Indicates if this company is primarily owned by women. Y for a women-owned frim, N for a firm that is not primarily owned by women.
DISADV_8A_IND VARCHAR2 (30)
Indicates if this company is considered disadvantaged by the US governement under Title 8A. Y for a Title 8A disadvantaged firm, N for all other firms.
SMALL_BUS_IND VARCHAR2 (30)
Indicates if this company is considered to be a small business. Y for small businesses, N for all other firms.
RENT_OWN_IND VARCHAR2 (30)
Indicates if this company owns or rents its place of business. Lookup of values for rent, own, lease, and so on.
DEBARMENTS_COUNT NUMBER

No longer used
DEBARMENTS_DATE DATE

No longer used
FAILURE_SCORE VARCHAR2 (30)
No longer used
FAILURE_SCORE_NATL_PERCENTILE VARCHAR2 (3)
No longer used
FAILURE_SCORE_OVERRIDE_CODE VARCHAR2 (30)
No longer used
FAILURE_SCORE_COMMENTARY VARCHAR2 (30)
No longer used
GLOBAL_FAILURE_SCORE VARCHAR2 (5)
No longer used
DB_RATING VARCHAR2 (5)
Dun & Bradstreet credit rating
CREDIT_SCORE VARCHAR2 (30)
No longer used
CREDIT_SCORE_COMMENTARY VARCHAR2 (30)
No longer used
PAYDEX_SCORE VARCHAR2 (3)
No longer used
PAYDEX_THREE_MONTHS_AGO VARCHAR2 (3)
No longer used
PAYDEX_NORM VARCHAR2 (3)
No longer used
BEST_TIME_CONTACT_BEGIN DATE

Beginning of the best period of time to contact the organization
BEST_TIME_CONTACT_END DATE

End of the best period of time to contact the organization.
ORGANIZATION_NAME_PHONETIC VARCHAR2 (320)
Japanese Kana, or phonetic representation of organization name
TAX_NAME VARCHAR2 (60)
No longer used
TAX_REFERENCE VARCHAR2 (50)
Taxpayer registration number, also known as the VAT number.
GSA_INDICATOR_FLAG VARCHAR2 (1)
Indicates if this is a US federal agency supported by the General Services Administration (GSA). Y for organizations served by the GSA, N for organizations that are not served by the GSA.
JGZZ_FISCAL_CODE VARCHAR2 (20)
Taxpayer identification number, often unique identifier of person or organization. Can be SSN or income taxpayer ID in US, fiscal code or NIF in Europe
ANALYSIS_FY VARCHAR2 (5)
Fiscal year used as the source for financial informationFiscal year used as the source for financial information
FISCAL_YEAREND_MONTH VARCHAR2 (30)
Month that the fiscal year ends for organization
CURR_FY_POTENTIAL_REVENUE NUMBER

Organization's potential revenue for this fiscal year
NEXT_FY_POTENTIAL_REVENUE NUMBER

Organization's potential revenue for next fiscal year
YEAR_ESTABLISHED NUMBER (4)
Year that the organization began doing business
MISSION_STATEMENT VARCHAR2 (2000)
Corporate charter of organization
ORGANIZATION_TYPE VARCHAR2 (30)
User-defined organization types such as region, division, and department
BUSINESS_SCOPE VARCHAR2 (20)
The physical class of business in which a business participates. For example, local, national, or international.
CORPORATION_CLASS VARCHAR2 (60)
Taxation classification for corporation entities. For example, Chapter S in the US.
KNOWN_AS VARCHAR2 (240)
An alias or other name by which an organization is known.
LOCAL_BUS_IDEN_TYPE VARCHAR2 (30)
Lookup that represents most common business identifier in a country. For example, Chamber of Commerce Number in Italy, Government Registration Number in Taiwan.
LOCAL_BUS_IDENTIFIER VARCHAR2 (60)
Primary identifier assigned to businesses by government agency, Chamber of Commerce, or other authority. Generally used outside US.
PREF_FUNCTIONAL_CURRENCY VARCHAR2 (30)
Organization's default currency code.
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
WH_UPDATE_DATE DATE

No longer used
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      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 APPS.JTF_HZ_ORGANIZATION_PROFILES_V;

Dependencies

[top of page]

APPS.JTF_HZ_ORGANIZATION_PROFILES_V references the following:

SchemaAPPS
SynonymHZ_ORGANIZATION_PROFILES

APPS.JTF_HZ_ORGANIZATION_PROFILES_V is not referenced by any database object