eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.HZ_ORG_PROFILES_CPUI_V

Object Details

Object Name:	HZ_ORG_PROFILES_CPUI_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.HZ_ORG_PROFILES_CPUI_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
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
PARTY_NUMBER	VARCHAR2	(30)	Yes	Unique identification number for this party
ORGANIZATION_NAME	VARCHAR2	(360)	Yes	Name of a party of the Organization party type
PARTY_NAME	VARCHAR2	(360)	Yes	Name of this party
ORGANIZATION_NAME_PHONETIC	VARCHAR2	(320)		Japanese Kana, or phonetic representation of organization name
SALUTATION	VARCHAR2	(60)		Phrase used to address a party in any correspondence.
KNOWN_AS	VARCHAR2	(240)		An alias or other name by which an organization is known.
KNOWN_AS2	VARCHAR2	(240)		An alias or other name by which a party is known
KNOWN_AS3	VARCHAR2	(240)		An alias or other name by which a party is known
KNOWN_AS4	VARCHAR2	(240)		An alias or other name by which a party is known
KNOWN_AS5	VARCHAR2	(240)		An alias or other name by which a party is known
DUNS_NUMBER_C	VARCHAR2	(30)		DUNS_NUMBER in VARCHAR format. Column value not restricted to nine digit DUNS Number.
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_TITLE	VARCHAR2	(240)		Formal title of the chief executive officer
CEO_NAME	VARCHAR2	(240)		Name of the chief executive officer
PRINCIPAL_TITLE	VARCHAR2	(240)		Title of the highest ranking person in the company
PRINCIPAL_NAME	VARCHAR2	(240)		Name 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.
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.
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 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.
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.
REGISTRATION_TYPE	VARCHAR2	(30)		Lookup for type of registration, such as nonprofit.
TOTAL_EMPLOYEES_TEXT	VARCHAR2	(60)		Total number of personnel employeed if can not be mapped to numeric field.
TOTAL_EMPLOYEES_IND	VARCHAR2	(30)		Lookup that indicates whether subsidiaries are included in the calculation of total employees A for totals without subsidiaries, B for totals with subsidiaries.
TOTAL_EMP_EST_IND	VARCHAR2	(30)		Lookup that indicates whether the employee total is estimated. A for estimated, N for not estimated or actual.
TOTAL_EMP_MIN_IND	VARCHAR2	(30)		Lookup that indicates whether the number is a minimum, maximum, or average number of total employees. A for minimum, B for maximum, and C for average.
EMP_AT_PRIMARY_ADR	VARCHAR2	(10)		Number of employees at the referenced address
EMP_AT_PRIMARY_ADR_TEXT	VARCHAR2	(12)		Number of employees at the referenced address which cannot be mapped to a number
EMP_AT_PRIMARY_ADR_EST_IND	VARCHAR2	(30)		Qualifies calculation of employees at the primary address as estimated
EMP_AT_PRIMARY_ADR_MIN_IND	VARCHAR2	(30)		Qualifies calculation of employees at the primary address as minimum
PARENT_SUB_IND	VARCHAR2	(30)		Lookup that indicates if organization is a parent or subsidiary location
INCORP_YEAR	NUMBER	(4)		Year that the business was incorporated
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).
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).
CONTENT_SOURCE_TYPE	VARCHAR2	(30)	Yes	Source of data content.
CONTENT_SOURCE_NUMBER	VARCHAR2	(30)		Unique foreign key to data source, such as DUNS number
EFFECTIVE_START_DATE	DATE		Yes	Used for date tracking capabilities
EFFECTIVE_END_DATE	DATE			Used for date tracking capabilities
SIC_CODE_TYPE	VARCHAR2	(30)		Version of Standard Industry Classification (SIC) code
PUBLIC_PRIVATE_OWNERSHIP_FLAG	VARCHAR2	(1)		Indicates if the organization is privately owned. Y for a privately owned organization, N for a publicly owned organization.
LOCAL_ACTIVITY_CODE_TYPE	VARCHAR2	(30)		Local activity classification code type identifier
LOCAL_ACTIVITY_CODE	VARCHAR2	(30)		Local activity classification code
INTERNAL_FLAG	VARCHAR2	(1)		Indicates if this is an internal organization. Y for internal, N for external.
TOTAL_PAYMENTS	NUMBER			Total number of payment experiences
PARTY_TYPE	VARCHAR2	(30)	Yes	The party type can only be Person, Organization, Group or Relationship.
ORIG_SYSTEM_REFERENCE	VARCHAR2	(240)	Yes	Customer identifier from foreign system. May not be unique.
VALIDATED_FLAG	VARCHAR2	(1)		Indicates if the party was validated. Y for a validated party, N for a party that is not validated.
CUSTOMER_KEY	VARCHAR2	(500)		Derived key used to facilitate fuzzy searches
COUNTRY	VARCHAR2	(60)		The country listed in the TERRITORY_CODE column of the FND_TERRITORY table. for the Identifying address.
ADDRESS1	VARCHAR2	(240)		First line of the Identifying address
ADDRESS2	VARCHAR2	(240)		Second line of the Identifying address
ADDRESS3	VARCHAR2	(240)		Third line of the Identifying address
ADDRESS4	VARCHAR2	(240)		Fourth line of the Identifying address
CITY	VARCHAR2	(60)		City of the Identifying address
POSTAL_CODE	VARCHAR2	(60)		Postal Code of the Identifying address
PROVINCE	VARCHAR2	(60)		Province of the Identifying address
STATUS	VARCHAR2	(1)	Yes	Party status flag.
COUNTY	VARCHAR2	(60)		County of the Identifying address
STATE	VARCHAR2	(60)		State of the Identifying address
URL	VARCHAR2	(2000)		Uniform resource locator
EMAIL_ADDRESS	VARCHAR2	(2000)		E-mail address
LAST_ORDERED_DATE	DATE			Date of the most recent order
TOTAL_ORDERED_AMOUNT	NUMBER			Total amount ordered through the last ordered date
TOTAL_NUM_OF_ORDERS	NUMBER			Total number of orders through the last ordered date
DO_NOT_MAIL_FLAG	VARCHAR2	(1)		No longer used
LANGUAGE_NAME	VARCHAR2	(4)		Standard name for a language
CATEGORY_CODE	VARCHAR2	(30)		User-definable category. Lookup type is CUSTOMER_CATEGORY
REFERENCE_USE_FLAG	VARCHAR2	(1)		Indicates if customer has agreed to be a reference. Y for customer who is referencable, N or null for a nonreferencable customer
THIRD_PARTY_FLAG	VARCHAR2	(1)		Tracks if a party has a direct relationship with the organization using Oracle Receivables or through a third party vendor. Y for a third party relationship, N for a direct relationship. If Oracle Service is installed, the Third Party field in the Customers window is mandatory.
COMPETITOR_FLAG	VARCHAR2	(1)		Indicates if a party is a competitor. Y for a party that is a competitor, N or null for a party that is not a competitor
BANK_OR_BRANCH_NUMBER	VARCHAR2	(30)		Stores bank number for banks and branch number for bank branches, primarily ABA number for US bank branches.
BANK_CODE	VARCHAR2	(30)		Identifies bank in several countries, typically for regulatory purposes.
BRANCH_CODE	VARCHAR2	(30)		Identifies bank branch in several countries, typically for regulatory purposes.
PARTY_OBJECT_VERSION_NUMBER	NUMBER			This column is used for locking purposes
ACTUAL_CONTENT_SOURCE	VARCHAR2	(30)	Yes	Additional Content Source Type column for backward compatibility.
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
ATTRIBUTE21	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE22	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE23	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE24	VARCHAR2	(150)		Descriptive Flexfield segment
CREATED_BY_MODULE	VARCHAR2	(150)		TCA Who column

Query Text

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


SELECT ORGANIZATION_PROFILE_ID
,      PARTY_ID
,      PARTY_NUMBER
,      ORGANIZATION_NAME
,      PARTY_NAME
,      ORGANIZATION_NAME_PHONETIC
,      SALUTATION
,      KNOWN_AS
,      KNOWN_AS2
,      KNOWN_AS3
,      KNOWN_AS4
,      KNOWN_AS5
,      DUNS_NUMBER_C
,      ENQUIRY_DUNS
,      CEO_TITLE
,      CEO_NAME
,      PRINCIPAL_TITLE
,      PRINCIPAL_NAME
,      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
,      MINORITY_OWNED_IND
,      MINORITY_OWNED_TYPE
,      WOMAN_OWNED_IND
,      DISADV_8A_IND
,      SMALL_BUS_IND
,      RENT_OWN_IND
,      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
,      LOCAL_BUS_IDEN_TYPE
,      LOCAL_BUS_IDENTIFIER
,      PREF_FUNCTIONAL_CURRENCY
,      REGISTRATION_TYPE
,      TOTAL_EMPLOYEES_TEXT
,      TOTAL_EMPLOYEES_IND
,      TOTAL_EMP_EST_IND
,      TOTAL_EMP_MIN_IND
,      EMP_AT_PRIMARY_ADR
,      EMP_AT_PRIMARY_ADR_TEXT
,      EMP_AT_PRIMARY_ADR_EST_IND
,      EMP_AT_PRIMARY_ADR_MIN_IND
,      PARENT_SUB_IND
,      INCORP_YEAR
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CONTENT_SOURCE_TYPE
,      CONTENT_SOURCE_NUMBER
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      SIC_CODE_TYPE
,      PUBLIC_PRIVATE_OWNERSHIP_FLAG
,      LOCAL_ACTIVITY_CODE_TYPE
,      LOCAL_ACTIVITY_CODE
,      INTERNAL_FLAG
,      TOTAL_PAYMENTS
,      PARTY_TYPE
,      ORIG_SYSTEM_REFERENCE
,      VALIDATED_FLAG
,      CUSTOMER_KEY
,      COUNTRY
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      PROVINCE
,      STATUS
,      COUNTY
,      STATE
,      URL
,      EMAIL_ADDRESS
,      LAST_ORDERED_DATE
,      TOTAL_ORDERED_AMOUNT
,      TOTAL_NUM_OF_ORDERS
,      DO_NOT_MAIL_FLAG
,      LANGUAGE_NAME
,      CATEGORY_CODE
,      REFERENCE_USE_FLAG
,      THIRD_PARTY_FLAG
,      COMPETITOR_FLAG
,      BANK_OR_BRANCH_NUMBER
,      BANK_CODE
,      BRANCH_CODE
,      PARTY_OBJECT_VERSION_NUMBER
,      ACTUAL_CONTENT_SOURCE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      CREATED_BY_MODULE
FROM APPS.HZ_ORG_PROFILES_CPUI_V;

Dependencies

[top of page]

APPS.HZ_ORG_PROFILES_CPUI_V references the following:

APPS: HZ_ORGANIZATION_PROFILES; HZ_PARTIES

APPS.HZ_ORG_PROFILES_CPUI_V is not referenced by any database object