[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AMS_ORG_DETAILS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  AMS.AMS_ORG_DETAILS_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PARTY_ID | NUMBER | (15) | Yes | Party identifier |
| 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. |
| STATUS | VARCHAR2 | (1) | Yes | The status of party |
| PARTY_SITE_ID | NUMBER | (15) | Party site identifier | |
| PARTY_SITE_NAME | VARCHAR2 | (240) | Name of the Party site | |
| REGION | VARCHAR2 | (30) | Region Code | |
| MAILSTOP | VARCHAR2 | (60) | MailStop | |
| LANGUAGE | VARCHAR2 | (4) | Language | |
| IDENTIFYING_ADDRESS_FLAG | VARCHAR2 | (1) | Indicates if this is an identifying Address | |
| ORIG_SYSTEM_REFERENCE | VARCHAR2 | (240) | Yes | identifier from foreign system. May not be unique. |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| PROGRAM_UPDATE_DATE | DATE | Last date this record was updated by a concurrent program | ||
| WH_UPDATE_DATE | DATE | Date when the record was entered or changed in a data warehouse | ||
| REQUEST_ID | NUMBER | (15) | Request identifier of last concurrent program to update this record | |
| PROGRAM_ID | NUMBER | (15) | Program identifier of last concurrent program to update this record | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Application identifier of last concurrent program to update this record | |
| SALUTATION | VARCHAR2 | (60) | Salutary introduction, such as Mr. or Herr | |
| KNOWN_AS | VARCHAR2 | (240) | An alias or other name by which a party is known | |
| 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 | |
| STATE | VARCHAR2 | (60) | State of the Identifying address | |
| POSTAL_CODE | VARCHAR2 | (60) | Postal code of the Identifying address | |
| PROVINCE | VARCHAR2 | (60) | Province of the Identifying address | |
| COUNTY | VARCHAR2 | (60) | County of the Identifying address | |
| COUNTRY | VARCHAR2 | (60) | Country of the Identifying address | |
| COUNTRY_NAME | CHAR | (0) | Country of the Identifying address | |
| TAX_NAME | VARCHAR2 | (60) | The name for the party that is recognized by the tax authority. | |
| TAX_REFERENCE | VARCHAR2 | (50) | Taxpayer identification number | |
| CUSTOMER_KEY | VARCHAR2 | (500) | Derived key used to facilitate fuzzy searches | |
| GROUP_TYPE | VARCHAR2 | (30) | group Type | |
| VALIDATED_FLAG | VARCHAR2 | (1) | Indicates if the party was validated. Y for a validated party, N for a party that is not validated. | |
| JGZZ_FISCAL_CODE | VARCHAR2 | (20) | Provides the fiscal code for an organization. This code is used in some European countries. | |
| DUNS_NUMBER | NUMBER | The DUNS number, a unique, nine-digit identification number assigned to business entities by Dun & Bradstreet | ||
| TOTAL_NUM_OF_ORDERS | NUMBER | Total number of orders through the last ordered date | ||
| TOTAL_ORDERED_AMOUNT | NUMBER | Total amount ordered through the last ordered date | ||
| LAST_ORDERED_DATE | DATE | Date of the most recent order | ||
| DO_NOT_MAIL_FLAG | VARCHAR2 | (1) | Do not Mail Flag | |
| 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 | |
| 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. | |
| LANGUAGE_NAME | VARCHAR2 | (4) | Standard name for a language | |
| URL | VARCHAR2 | (2000) | Uniform resource locator | |
| ORGANIZATION_PROFILE_ID | NUMBER | (15) | Yes | Organization Profile Identifier |
| ORGANIZATION_NAME | VARCHAR2 | (360) | Yes | Organization Name |
| CONTENT_SOURCE_TYPE | VARCHAR2 | (30) | Yes | Content Source Type |
| EFFECTIVE_START_DATE | DATE | Yes | Used for date tracking capabilities | |
| EFFECTIVE_END_DATE | DATE | Used for date tracking capabilities | ||
| CEO_NAME | VARCHAR2 | (240) | Name of the chief executive officer | |
| CEO_TITLE | VARCHAR2 | (240) | Formal title of the chief executive officer | |
| 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 | |
| SIC_CODE_TYPE | VARCHAR2 | (30) | Standard of 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. | |
| 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. | |
| FAILURE_SCORE | VARCHAR2 | (30) | For US, the value represents the Failure Risk Class (values 1 through 5). For Canada the value is the Stability Score that indicates the risk of business closure (values 1 through 10). For Australia, this field carries the percentile failure score. | |
| FAILURE_SCORE_NATL_PERCENTILE | VARCHAR2 | (3) | No longer used | |
| FAILURE_SCORE_OVERRIDE_CODE | VARCHAR2 | (30) | In Europe, this code indicates the reason for variance between the Dun & Bradstreet Rating and the Failure Score. In the US, the code indicates the reason why no score was calculated, or that the score is equal to 0. | |
| FAILURE_SCORE_COMMENTARY | VARCHAR2 | (30) | Lookup for explanation code for the FAILURE_SCORE column | |
| GLOBAL_FAILURE_SCORE | VARCHAR2 | (5) | Global score that indicates risk of business default | |
| DB_RATING | VARCHAR2 | (5) | Dun & Bradstreet credit rating | |
| CREDIT_SCORE | VARCHAR2 | (30) | Indicates the risk of delinquent payments | |
| PAYDEX_SCORE | VARCHAR2 | (3) | Paydex score for the last 12 months payment history | |
| PAYDEX_THREE_MONTHS_AGO | VARCHAR2 | (3) | Paydex score three months ago | |
| PAYDEX_NORM | VARCHAR2 | (3) | Median or average Paydex score for the industry. | |
| PRIMARY_CONTACT_ID | NUMBER | (15) | Primary contact Idnetifier | |
| 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. | ||
| 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 the organization was established | |
| ORGANIZATION_TYPE | VARCHAR2 | (30) | User-defined organization types such as region, division, and department | |
| CORPORATION_CLASS | VARCHAR2 | (60) | Taxation classification for corporation entities. For example, Chapter S in the US. | |
| 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 | |
| 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. | |
| 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 | Maximum credit ever extended to this organization | ||
| AVG_HIGH_CREDIT | NUMBER | Average of all high credit experiences | ||
| TOTAL_PAYMENTS | NUMBER | Total number of payment experiences | ||
| CONTENT_SOURCE_NUMBER | VARCHAR2 | (30) | Unique foreign key to data source, such as DUNS number | |
| BUSINESS_SCOPE | VARCHAR2 | (20) | The physical class of business in which a business participates. For example, local, national, or international. | |
| 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. | |
| 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. | |
| 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 | |
| DEBARMENT_IND | VARCHAR2 | (30) | Indicates if this party is prohibited from entering into contracts or transactions with a government agency in the United States. Y for a party that is debarred, N for a party that is not debarred. | |
| DEBARMENTS_COUNT | NUMBER | Count of filings by government agencies in the United States that prohibit the party from entering into contracts or transactions with those agencies. | ||
| DEBARMENTS_DATE | DATE | Date of the most recent filing to prohibit the party from entering into contracts or transactions with a government agency in the United States. | ||
| LOCAL_ACTIVITY_CODE_TYPE | VARCHAR2 | (30) | Date of the most recent filing to prohibit the party from entering into contracts or transactions with a government agency in the United States. | |
| LOCAL_ACTIVITY_CODE | VARCHAR2 | (30) | Local activity classification code | |
| CREDIT_SCORE_CLASS | NUMBER | Measures the risk of severe delinquency by a customer account. The value ranges from 1 for the greatest risk and 5 for the least risk. | ||
| CREDIT_SCORE_NATL_PERCENTILE | NUMBER | Indicates the relative credit rating of a business compared to all businesses whose credit ratings are included in the local country database | ||
| CREDIT_SCORE_INCD_DEFAULT | NUMBER | Indicates the probability, expressed as a percentage, of delinquency for a score range or class | ||
| CREDIT_SCORE_AGE | NUMBER | Indicates the age of the credit score, expressed in months | ||
| CREDIT_SCORE_DATE | DATE | Provides the date when the credit score was calculated | ||
| FAILURE_SCORE_CLASS | NUMBER | The failure score class value measures the risk of financial stress for a customer account. The value range is from 1 to 5. A value of 1 indicates a business that has the greatest risk, and a value of 5 indicates a business that has the least risk. | ||
| FAILURE_SCORE_INCD_DEFAULT | NUMBER | The failure score incident value states the probability, expressed as a percentage, of failure for a score range or class. | ||
| FAILURE_SCORE_AGE | NUMBER | The failure score age value states the age of the failure score, expressed in months | ||
| FAILURE_SCORE_DATE | DATE | The failure score date value states the date that the score was calculated | ||
| MAXIMUM_CREDIT_RECOMMENDATION | NUMBER | Maximum credit limit recommended for a specific currency | ||
| MAXIMUM_CREDIT_CURRENCY_CODE | VARCHAR2 | (240) | Currency used to state the MAXIMUM_CREDIT_RECOMMENDATION column | |
| DISPLAYED_DUNS_PARTY_ID | NUMBER | (15) | Dun & Bradstreet does not maintain data for the branch offices of companies that are located outside of North America. Data is only maintained for the company's headquarters. If the data pertains only to a company's headquarters, this column stores the headquarter's PARTY_ID. If the data pertains to a branch office, this column stores the branch's PARTY_ID. | |
| FAILURE_SCORE_NATNL_PERCENTILE | NUMBER | National percentile that reflects the relative ranking of a company among all the scorable companies in the local country database. | ||
| BUSINESS_REPORT | CLOB | (4000) | Dun & Bradstreet Business Information Report | |
| PROFILE_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure definition | |
| PROFILE_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PROFILE_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PROFILE_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PROFILE_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PROFILE_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PROFILE_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PROFILE_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PROFILE_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PROFILE_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PROFILE_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PROFILE_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PROFILE_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PROFILE_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PROFILE_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PROFILE_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PROFILE_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PROFILE_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PROFILE_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PROFILE_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PROFILE_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PARTY_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure definition | |
| PARTY_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PARTY_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PARTY_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PARTY_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PARTY_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PARTY_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PARTY_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PARTY_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PARTY_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PARTY_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PARTY_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PARTY_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PARTY_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PARTY_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PARTY_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PARTY_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PARTY_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PARTY_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PARTY_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PARTY_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PARTY_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PARTY_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PARTY_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| PARTY_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield definition | |
| CREATED_BY_NAME | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_LOGIN_NAME | NUMBER | (15) | Standard Who column | |
| LAST_UPDATED_BY_NAME | NUMBER | (15) | Yes | Standard Who column |
| CATEGORY_CODE | VARCHAR2 | (30) | Category Code | |
| PHONE_COUNTRY_CODE | VARCHAR2 | (10) | ||
| PHONE_AREA_CODE | VARCHAR2 | (10) | ||
| PHONE_NUMBER | VARCHAR2 | (40) | ||
| PHONE_EXTENSION | VARCHAR2 | (20) | ||
| COMPETITOR_FLAG | VARCHAR2 | (1) | ||
| THIRD_PARTY_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT PARTY_ID
, PARTY_NUMBER
, PARTY_NAME
, PARTY_TYPE
, STATUS
, PARTY_SITE_ID
, PARTY_SITE_NAME
, REGION
, MAILSTOP
, LANGUAGE
, IDENTIFYING_ADDRESS_FLAG
, ORIG_SYSTEM_REFERENCE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_UPDATE_DATE
, WH_UPDATE_DATE
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, SALUTATION
, KNOWN_AS
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, STATE
, POSTAL_CODE
, PROVINCE
, COUNTY
, COUNTRY
, COUNTRY_NAME
, TAX_NAME
, TAX_REFERENCE
, CUSTOMER_KEY
, GROUP_TYPE
, VALIDATED_FLAG
, JGZZ_FISCAL_CODE
, DUNS_NUMBER
, TOTAL_NUM_OF_ORDERS
, TOTAL_ORDERED_AMOUNT
, LAST_ORDERED_DATE
, DO_NOT_MAIL_FLAG
, REFERENCE_USE_FLAG
, GSA_INDICATOR_FLAG
, LANGUAGE_NAME
, URL
, ORGANIZATION_PROFILE_ID
, ORGANIZATION_NAME
, CONTENT_SOURCE_TYPE
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, CEO_NAME
, CEO_TITLE
, LEGAL_STATUS
, CONTROL_YR
, EMPLOYEES_TOTAL
, HQ_BRANCH_IND
, BRANCH_FLAG
, OOB_IND
, LINE_OF_BUSINESS
, CONG_DIST_CODE
, SIC_CODE
, SIC_CODE_TYPE
, IMPORT_IND
, EXPORT_IND
, MINORITY_OWNED_IND
, MINORITY_OWNED_TYPE
, WOMAN_OWNED_IND
, DISADV_8A_IND
, SMALL_BUS_IND
, RENT_OWN_IND
, FAILURE_SCORE
, FAILURE_SCORE_NATL_PERCENTILE
, FAILURE_SCORE_OVERRIDE_CODE
, FAILURE_SCORE_COMMENTARY
, GLOBAL_FAILURE_SCORE
, DB_RATING
, CREDIT_SCORE
, PAYDEX_SCORE
, PAYDEX_THREE_MONTHS_AGO
, PAYDEX_NORM
, PRIMARY_CONTACT_ID
, BEST_TIME_CONTACT_BEGIN
, BEST_TIME_CONTACT_END
, ANALYSIS_FY
, FISCAL_YEAREND_MONTH
, CURR_FY_POTENTIAL_REVENUE
, NEXT_FY_POTENTIAL_REVENUE
, YEAR_ESTABLISHED
, ORGANIZATION_TYPE
, 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
, PARENT_SUB_IND
, INCORP_YEAR
, PUBLIC_PRIVATE_OWNERSHIP_FLAG
, 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
, CONTENT_SOURCE_NUMBER
, BUSINESS_SCOPE
, ENQUIRY_DUNS
, LABOR_SURPLUS_IND
, PRINCIPAL_NAME
, PRINCIPAL_TITLE
, DEBARMENT_IND
, DEBARMENTS_COUNT
, DEBARMENTS_DATE
, LOCAL_ACTIVITY_CODE_TYPE
, LOCAL_ACTIVITY_CODE
, CREDIT_SCORE_CLASS
, CREDIT_SCORE_NATL_PERCENTILE
, CREDIT_SCORE_INCD_DEFAULT
, CREDIT_SCORE_AGE
, CREDIT_SCORE_DATE
, FAILURE_SCORE_CLASS
, FAILURE_SCORE_INCD_DEFAULT
, FAILURE_SCORE_AGE
, FAILURE_SCORE_DATE
, MAXIMUM_CREDIT_RECOMMENDATION
, MAXIMUM_CREDIT_CURRENCY_CODE
, DISPLAYED_DUNS_PARTY_ID
, FAILURE_SCORE_NATNL_PERCENTILE
, BUSINESS_REPORT
, PROFILE_ATTRIBUTE_CATEGORY
, PROFILE_ATTRIBUTE1
, PROFILE_ATTRIBUTE2
, PROFILE_ATTRIBUTE3
, PROFILE_ATTRIBUTE4
, PROFILE_ATTRIBUTE5
, PROFILE_ATTRIBUTE6
, PROFILE_ATTRIBUTE7
, PROFILE_ATTRIBUTE8
, PROFILE_ATTRIBUTE9
, PROFILE_ATTRIBUTE10
, PROFILE_ATTRIBUTE11
, PROFILE_ATTRIBUTE12
, PROFILE_ATTRIBUTE13
, PROFILE_ATTRIBUTE14
, PROFILE_ATTRIBUTE15
, PROFILE_ATTRIBUTE16
, PROFILE_ATTRIBUTE17
, PROFILE_ATTRIBUTE18
, PROFILE_ATTRIBUTE19
, PROFILE_ATTRIBUTE20
, PARTY_ATTRIBUTE_CATEGORY
, PARTY_ATTRIBUTE1
, PARTY_ATTRIBUTE2
, PARTY_ATTRIBUTE3
, PARTY_ATTRIBUTE4
, PARTY_ATTRIBUTE5
, PARTY_ATTRIBUTE6
, PARTY_ATTRIBUTE7
, PARTY_ATTRIBUTE8
, PARTY_ATTRIBUTE9
, PARTY_ATTRIBUTE10
, PARTY_ATTRIBUTE11
, PARTY_ATTRIBUTE12
, PARTY_ATTRIBUTE13
, PARTY_ATTRIBUTE14
, PARTY_ATTRIBUTE15
, PARTY_ATTRIBUTE16
, PARTY_ATTRIBUTE17
, PARTY_ATTRIBUTE18
, PARTY_ATTRIBUTE19
, PARTY_ATTRIBUTE20
, PARTY_ATTRIBUTE21
, PARTY_ATTRIBUTE22
, PARTY_ATTRIBUTE23
, PARTY_ATTRIBUTE24
, CREATED_BY_NAME
, LAST_UPDATE_LOGIN_NAME
, LAST_UPDATED_BY_NAME
, CATEGORY_CODE
, PHONE_COUNTRY_CODE
, PHONE_AREA_CODE
, PHONE_NUMBER
, PHONE_EXTENSION
, COMPETITOR_FLAG
, THIRD_PARTY_FLAG
FROM APPS.AMS_ORG_DETAILS_V;
APPS
HZ_CONTACT_POINTS
HZ_LOCATIONS
HZ_ORGANIZATION_PROFILES
HZ_PARTIES
HZ_PARTY_SITES
APPS.AMS_ORG_DETAILS_V is not referenced by any database object
|
|
|
|