[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | HZ_ORGANIZATION_PROFILES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  AR.HZ_ORGANIZATION_PROFILES_V
|
| Subobject Name: | |
| Status: | VALID |
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.
| 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 |
| 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) | Not currently used | |
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Not currently used | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Not currently used | |
| 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. Used in Europe to identify customers. Also known as the fiscal code or NIF. | |
| 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. | |
| KNOWN_AS | VARCHAR2 | (240) | An alias or other name by which an organization is known. | |
| LOCAL_BUS_IDEN_TYPE | VARCHAR2 | (30) | Lookup for the primary domestic business identification number. For example, Taxpayer ID. | |
| LOCAL_BUS_IDENTIFIER | VARCHAR2 | (60) | Primary business ID number assigned to the business by a government agency, Chamber of Commerce, or industry association | |
| 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. | |
| 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 | |
| PRIMARY_CONTACT_ID | NUMBER | (15) | No longer used | |
| 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). | ||
| 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 | |
| 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 | |
| INTERNAL_FLAG | VARCHAR2 | (1) | Indicates if this is an internal organization. Y for internal, N for external. | |
| HIGH_CREDIT | NUMBER | No longer used. | ||
| AVG_HIGH_CREDIT | NUMBER | No longer used | ||
| TOTAL_PAYMENTS | NUMBER | Total number of payment experiences | ||
| 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 | |
| PARTY_NUMBER | VARCHAR2 | (30) | Yes | Unique identification number for this party |
| PARTY_NAME | VARCHAR2 | (360) | Yes | Name of this party |
| 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 | |
| SALUTATION | VARCHAR2 | (60) | Phrase used to address a party in any correspondence. | |
| 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. |
| DUNS_NUMBER_C | VARCHAR2 | (30) | DUNS_NUMBER in VARCHAR format. Column value not restricted to nine digit DUNS Number. |
Cut, paste (and edit) the following text to query this object:
SELECT 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
, REGISTRATION_TYPE
, TOTAL_EMPLOYEES_TEXT
, TOTAL_EMPLOYEES_IND
, TOTAL_EMP_EST_IND
, TOTAL_EMP_MIN_IND
, PARENT_SUB_IND
, INCORP_YEAR
, PRIMARY_CONTACT_ID
, 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
, 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
, EMP_AT_PRIMARY_ADR
, EMP_AT_PRIMARY_ADR_TEXT
, EMP_AT_PRIMARY_ADR_EST_IND
, EMP_AT_PRIMARY_ADR_MIN_IND
, INTERNAL_FLAG
, HIGH_CREDIT
, AVG_HIGH_CREDIT
, TOTAL_PAYMENTS
, KNOWN_AS2
, KNOWN_AS3
, KNOWN_AS4
, KNOWN_AS5
, PARTY_NUMBER
, PARTY_NAME
, 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
, SALUTATION
, BANK_OR_BRANCH_NUMBER
, BANK_CODE
, BRANCH_CODE
, PARTY_OBJECT_VERSION_NUMBER
, ACTUAL_CONTENT_SOURCE
, DUNS_NUMBER_C
FROM APPS.HZ_ORGANIZATION_PROFILES_V;
APPS
HZ_ORGANIZATION_PROFILES
HZ_PARTIES
APPS.HZ_ORGANIZATION_PROFILES_V is not referenced by any database object
|
|
|
|