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

TABLE: AMS.AMS_DM_PARTY_DETAILS

Object Details
Object Name: AMS_DM_PARTY_DETAILS
Object Type: TABLE
Owner: AMS
FND Design Data: TableAMS.AMS_DM_PARTY_DETAILS
Subobject Name:
Status: VALID


AMS_DM_GEN_STG table is populated by the OMO Mining Collection pack. The table is truncated after each run. When populated the table contains generic details for parties in the AMS_DM_DRV_STG table.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMS_DM_PARTY_DETAILS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnPARTY_ID
AMS_DM_PARTY_DETAILS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnPARTY_TYPE
Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER
Yes Party identifier.
CREATED_BY NUMBER

Standard WHO column.
CREATION_DATE DATE

Standard WHO column.
LAST_UPDATED_BY NUMBER

Standard WHO column.
LAST_UPDATE_DATE DATE

Standard WHO column.
LAST_UPDATE_LOGIN NUMBER

Standard WHO column.
OBJECT_VERSION_NUMBER NUMBER

This column is used for locking purposes.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
PARTY_TYPE VARCHAR2 (30)
Party type.
GENDER VARCHAR2 (30)
Gender.
ETHNICITY VARCHAR2 (60)
Ethnicity.
MARITAL_STATUS VARCHAR2 (30)
Marital status.
PERSONAL_INCOME NUMBER

Personal income.
HOH_FLAG VARCHAR2 (1)
Head of household indicator.
HOUSEHOLD_INCOME NUMBER

Household income.
HOUSEHOLD_SIZE NUMBER

Household size.
APARTMENT_FLAG VARCHAR2 (1)
Apartment indicator.
RENT_FLAG VARCHAR2 (1)
Rent indicator.
DEGREE_RECEIVED VARCHAR2 (1)
Degree received.
SCHOOL_TYPE VARCHAR2 (60)
School type.
INTEREST_ART_FLAG VARCHAR2 (1)
Interest in art indicator.
INTEREST_BOOKS_FLAG VARCHAR2 (1)
Interest in books indicator.
INTEREST_MOVIES_FLAG VARCHAR2 (1)
Interest in movies indicator.
INTEREST_MUSIC_FLAG VARCHAR2 (1)
Interest in music indicator.
INTEREST_THEATER_FLAG VARCHAR2 (1)
Interest in theater indicator.
INTEREST_TRAVEL_FLAG VARCHAR2 (1)
Interest in travel indicator.
INTEREST_DRINK_FLAG VARCHAR2 (1)
Interest in drinking indicator.
INTEREST_SMOKE_FLAG VARCHAR2 (1)
Interest in smoking indicator.
INTEREST_OTHER_FLAG VARCHAR2 (1)
Other interests indicator.
LEVEL_OF_INTEREST VARCHAR2 (30)
Level of interest.
INTEREST_TYPE_CODE VARCHAR2 (30)
Interest type code.
HOBBIES VARCHAR2 (240)
Hobbies.
EXPERIENCE_LEVEL VARCHAR2 (60)
Experience level.
WORK_CLASS_NAME VARCHAR2 (240)
Work class name.
EMPLOYED_FLAG VARCHAR2 (1)
Employed indicator.
YEARS_EMPLOYED NUMBER

Number of years employed.
OCCUPATION VARCHAR2 (60)
Occupation.
MILITARY_BRANCH VARCHAR2 (80)
Military branch served.
RESIDENCE_TYPE VARCHAR2 (30)
Residence type.
RESIDENT_LENGTH NUMBER

Number of years stayed at current residence.
SECOND_HOME_TYPE VARCHAR2 (30)
Second home type.
PRESENCE_OF_CHILDREN NUMBER

Presence of children indicator.
COUNTRY VARCHAR2 (60)
Country.
STATE VARCHAR2 (60)
State.
PROVINCE VARCHAR2 (60)
Province.
COUNTY VARCHAR2 (60)
County.
ZIP_CODE VARCHAR2 (60)
Zip code.
AVG_NUM_LIFE_CYCLE_SEGS NUMBER

Average number of life cycle segments.
CONTACT_TYPE VARCHAR2 (30)
Contact type.
CATEGORY_CODE VARCHAR2 (30)
Category code.
REFERENCE_USE_FLAG VARCHAR2 (1)
Use as a reference indicator.
SUBCATEGORY_CODE VARCHAR2 (30)
Subcategory code.
RETURN_TYPE VARCHAR2 (30)
Return type.
RETURN_REASON_CODE VARCHAR2 (30)
Reason for the return.
REFUND_PRICE NUMBER

Refund price.
REFUND_TYPE VARCHAR2 (30)
Refund type.
RETURNED_REASON VARCHAR2 (120)
Reason for the return.
GROSS_ANNUAL_INCOME NUMBER

Gross annual income.
DEBT_TO_INCOME_RATIO NUMBER

Deb to income ratio.
NUM_CREDIT_LINES NUMBER

Number of credit lines.
NUM_TRADE_LINES NUMBER

Number of trade lines.
NET_WORTH NUMBER

Net worth.
TOTAL_ASSETS NUMBER

Total assets.
TOT_DEBT_OUTSTANDING NUMBER

Total debt outstanding.
BANKRUPTCY_FLAG VARCHAR2 (1)
Bankruptcy indicator.
HIGH_RISK_FRAUD_FLAG VARCHAR2 (1)
High risk of fraud indicator.
GROSS_ANNUAL_SALES NUMBER

Gross annual sales.
GROWTH_RATE_SALES_YEAR NUMBER

Growth rate of sales for the past year.
GROWTH_RATE_NET_PROF_YEAR NUMBER

Growth rate of net profit for the past year.
CURRENT_ASSETS NUMBER

Current assets.
CURRENT_LIABILITIES NUMBER

Current liabilities.
TOTAL_DEBTS NUMBER

Total debts.
NET_PROFIT NUMBER

Net profit.
TANGIBLE_NET_PROFIT NUMBER

Tangible net profit.
CAPITAL_AMOUNT NUMBER

Capital amount.
CAPITAL_TYPE_INDICATOR VARCHAR2 (30)
Capital type indicator.
ACCOUNTS_RECEIVABLE NUMBER

Accounts receivable.
RETAINED_EARNINGS NUMBER

Retained earnings.
PAYDEX_SCORE_YEAR NUMBER

Paydex score for the past year.
PAYDEX_SCORE_3_MONTH_AGO NUMBER

Paydex score 3 months ago.
INDUSTRY_PAYDEX_MEDIAN NUMBER

Industry paydex score median.
AVG_HIGH_CREDIT NUMBER

Average high credit.
HIGH_CREDIT NUMBER

High credit.
TOT_PAYMENT_EXP NUMBER

Total payments.
NUM_NEGATIVE_PAYMENT NUMBER

Number of negative payments.
AVG_PAYMENT_SIZE NUMBER

Average payment size.
NUM_SLOW_PAYMENTS NUMBER

Number of slow payments.
FAILURE_SCORE NUMBER

Failure score.
FAILURE_SCORE_OVER_CODE VARCHAR2 (30)
Not used.
FAILURE_SCORE_INDUSTRY_PCT NUMBER

Not used.
FAILURE_SCORE_6_MONTHS NUMBER

Not used.
GLOBAL_FAILURE_SCORE VARCHAR2 (5)
Global failure score.
DNB_SCORE VARCHAR2 (5)
Dunn and Bradstreet score.
BUSINESS_FAILURE VARCHAR2 (120)
Business failure indicator.
OUT_OF_BUSINESS_FLAG VARCHAR2 (1)
Out of business indicator.
CUSTOMER_QUALITY_RANK NUMBER

Customer quality rank.
FORTUNE_500_RANK NUMBER

Fortune 500 rank.
NUM_OF_EMPLOYEES NUMBER

Number of employees.
LEGAL_STATUS VARCHAR2 (30)
Legal status.
ENTITY_TYPE VARCHAR2 (30)
Entity type.
YEAR_ESTABLISHED NUMBER

Year established.
LINE_OF_BUSINESS VARCHAR2 (30)
Line of business.
SIC_CODE1 VARCHAR2 (30)
Industry SIC code.
SIC_CODE2 VARCHAR2 (30)
Industry SIC code.
MARKET_SEGMENT_NAME VARCHAR2 (120)
Market segment name.
MARKET_SEGMENT_ID NUMBER

Market segment identifier.
SITE_NAME VARCHAR2 (120)
Site name.
SITE_DUNS_NUMBER NUMBER

Site DUNS number.
NUM_EMPLOYEES_AT_SITE NUMBER

Number of employees at site.
MINORITY_BUSINESS_FLAG VARCHAR2 (1)
Minority business indicator.
SMALL_BUSINESS_FLAG VARCHAR2 (1)
Small business indicator.
WOMEN_OWNED_BUS_FLAG VARCHAR2 (1)
Women owned business indicator.
GOV_ORG_FLAG VARCHAR2 (1)
Government organization indicator.
HQ_SUBSIDIARY_FLAG VARCHAR2 (1)
HQ subsidiary indicator.
FOREIGN_OWNED_FLAG VARCHAR2 (1)
Foreign owned indicator.
IMPORT_EXPORT_BUS_FLAG VARCHAR2 (1)
Import-Export business indicator.
CREDIT_CHECK_FLAG VARCHAR2 (1)
Credit check indicator.
TOLERANCE NUMBER

Tolerance.
DISCOUNT_TERMS_FLAG VARCHAR2 (1)
Discount terms indicator.
DUNNING_LETTERS_FLAG VARCHAR2 (1)
Dunning letters indicator.
INTEREST_CHARGES_FLAG VARCHAR2 (1)
Interest charges indicator.
SEND_STATEMENTS_FLAG VARCHAR2 (1)
Send statement indicator.
CREDIT_HOLD_FLAG VARCHAR2 (1)
Credit hold indicator.
CREDIT_RATING VARCHAR2 (60)
Credit rating.
RISK_CODE VARCHAR2 (60)
Risk code.
INTEREST_PERIOD_DAYS NUMBER

Number of days in interest period.
PAYMENT_GRACE_DAYS NUMBER

Number of payment grace days.
BUSINESS_SCOPE VARCHAR2 (240)
The physical class of business in which a business participates. For example, local, national, or international.
EMAIL_ADDRESS VARCHAR2 (240)
E-mail address.
ADDRESS1 VARCHAR2 (240)
First line of address.
ADDRESS2 VARCHAR2 (240)
Second line of address.
COMPETITOR_FLAG VARCHAR2 (240)
Indicates if a party is a competitor.
THIRD_PARTY_FLAG VARCHAR2 (240)
Tracks if a party has a direct relationship with the organization using Oracle Receivables or through a third party vendor.
PERSON_FIRST_NAME VARCHAR2 (240)
First name of the person.
PERSON_MIDDLE_NAME VARCHAR2 (240)
Middle name of the person.
PERSON_LAST_NAME VARCHAR2 (240)
Last or surname of the person.
PERSON_NAME_SUFFIX VARCHAR2 (240)
Indicates the place in a family structure. For example, in Tom Jones III, the "III" is the suffix.
PERSON_TITLE VARCHAR2 (240)
A professional or family title.
PERSON_ACADEMIC_TITLE VARCHAR2 (240)
Academic title that is part of a person's name.
PERSON_PRE_NAME_ADJUNCT VARCHAR2 (240)
Salutary introduction.
CONTROL_YR NUMBER

Year when current ownership gained control.
CONG_DIST_CODE VARCHAR2 (240)
U.S. Congressional District.
LABOR_SURPLUS_FLAG VARCHAR2 (240)
Indicates if this company operates in an area with a labor surplu.
DEBARMENT_FLAG VARCHAR2 (240)
Indicates if this party is prohibited from entering into contracts or transactions with a government agency in the United States.
DISADV_8A_FLAG VARCHAR2 (240)
Indicates if this company is considered disadvantaged by the US governement under Title 8A.
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.
MONTHS_SINCE_LAST_DEBARMENT NUMBER

Months since the most recent filing to prohibit the party from entering into contracts or transactions with a government agency in the United States.
GSA_INDICATOR_FLAG VARCHAR2 (240)
Indicates if this is a US federal agency supported by the General Services Administration (GSA).
ANALYSIS_FY VARCHAR2 (240)
Fiscal year used as the source for financial information.
FISCAL_YEAREND_MONTH VARCHAR2 (240)
Month in which 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.
ORGANIZATION_TYPE VARCHAR2 (240)
User-defined organization types such as region, division, and department.
CORPORATION_CLASS VARCHAR2 (240)
Taxation classification for corporation entities. For example, Chapter S in the US.
REGISTRATION_TYPE VARCHAR2 (240)
Lookup for type of registration, such as nonprofit.
INCORP_YEAR NUMBER

Year that the business was incorporated.
PUBLIC_PRIVATE_OWNERSHIP_FLAG VARCHAR2 (240)
Indicates if the organization is privately owned.
INTERNAL_FLAG VARCHAR2 (240)
Indicates if this is an internal organization.
TOTAL_PAYMENTS NUMBER

Total number of payment experiences.
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.
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.
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.
PARTY_NAME VARCHAR2 (360)
Name of this party.
CITY VARCHAR2 (120)
The city of the party's registered location.
Query Text

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


SELECT PARTY_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      PARTY_TYPE
,      GENDER
,      ETHNICITY
,      MARITAL_STATUS
,      PERSONAL_INCOME
,      HOH_FLAG
,      HOUSEHOLD_INCOME
,      HOUSEHOLD_SIZE
,      APARTMENT_FLAG
,      RENT_FLAG
,      DEGREE_RECEIVED
,      SCHOOL_TYPE
,      INTEREST_ART_FLAG
,      INTEREST_BOOKS_FLAG
,      INTEREST_MOVIES_FLAG
,      INTEREST_MUSIC_FLAG
,      INTEREST_THEATER_FLAG
,      INTEREST_TRAVEL_FLAG
,      INTEREST_DRINK_FLAG
,      INTEREST_SMOKE_FLAG
,      INTEREST_OTHER_FLAG
,      LEVEL_OF_INTEREST
,      INTEREST_TYPE_CODE
,      HOBBIES
,      EXPERIENCE_LEVEL
,      WORK_CLASS_NAME
,      EMPLOYED_FLAG
,      YEARS_EMPLOYED
,      OCCUPATION
,      MILITARY_BRANCH
,      RESIDENCE_TYPE
,      RESIDENT_LENGTH
,      SECOND_HOME_TYPE
,      PRESENCE_OF_CHILDREN
,      COUNTRY
,      STATE
,      PROVINCE
,      COUNTY
,      ZIP_CODE
,      AVG_NUM_LIFE_CYCLE_SEGS
,      CONTACT_TYPE
,      CATEGORY_CODE
,      REFERENCE_USE_FLAG
,      SUBCATEGORY_CODE
,      RETURN_TYPE
,      RETURN_REASON_CODE
,      REFUND_PRICE
,      REFUND_TYPE
,      RETURNED_REASON
,      GROSS_ANNUAL_INCOME
,      DEBT_TO_INCOME_RATIO
,      NUM_CREDIT_LINES
,      NUM_TRADE_LINES
,      NET_WORTH
,      TOTAL_ASSETS
,      TOT_DEBT_OUTSTANDING
,      BANKRUPTCY_FLAG
,      HIGH_RISK_FRAUD_FLAG
,      GROSS_ANNUAL_SALES
,      GROWTH_RATE_SALES_YEAR
,      GROWTH_RATE_NET_PROF_YEAR
,      CURRENT_ASSETS
,      CURRENT_LIABILITIES
,      TOTAL_DEBTS
,      NET_PROFIT
,      TANGIBLE_NET_PROFIT
,      CAPITAL_AMOUNT
,      CAPITAL_TYPE_INDICATOR
,      ACCOUNTS_RECEIVABLE
,      RETAINED_EARNINGS
,      PAYDEX_SCORE_YEAR
,      PAYDEX_SCORE_3_MONTH_AGO
,      INDUSTRY_PAYDEX_MEDIAN
,      AVG_HIGH_CREDIT
,      HIGH_CREDIT
,      TOT_PAYMENT_EXP
,      NUM_NEGATIVE_PAYMENT
,      AVG_PAYMENT_SIZE
,      NUM_SLOW_PAYMENTS
,      FAILURE_SCORE
,      FAILURE_SCORE_OVER_CODE
,      FAILURE_SCORE_INDUSTRY_PCT
,      FAILURE_SCORE_6_MONTHS
,      GLOBAL_FAILURE_SCORE
,      DNB_SCORE
,      BUSINESS_FAILURE
,      OUT_OF_BUSINESS_FLAG
,      CUSTOMER_QUALITY_RANK
,      FORTUNE_500_RANK
,      NUM_OF_EMPLOYEES
,      LEGAL_STATUS
,      ENTITY_TYPE
,      YEAR_ESTABLISHED
,      LINE_OF_BUSINESS
,      SIC_CODE1
,      SIC_CODE2
,      MARKET_SEGMENT_NAME
,      MARKET_SEGMENT_ID
,      SITE_NAME
,      SITE_DUNS_NUMBER
,      NUM_EMPLOYEES_AT_SITE
,      MINORITY_BUSINESS_FLAG
,      SMALL_BUSINESS_FLAG
,      WOMEN_OWNED_BUS_FLAG
,      GOV_ORG_FLAG
,      HQ_SUBSIDIARY_FLAG
,      FOREIGN_OWNED_FLAG
,      IMPORT_EXPORT_BUS_FLAG
,      CREDIT_CHECK_FLAG
,      TOLERANCE
,      DISCOUNT_TERMS_FLAG
,      DUNNING_LETTERS_FLAG
,      INTEREST_CHARGES_FLAG
,      SEND_STATEMENTS_FLAG
,      CREDIT_HOLD_FLAG
,      CREDIT_RATING
,      RISK_CODE
,      INTEREST_PERIOD_DAYS
,      PAYMENT_GRACE_DAYS
,      BUSINESS_SCOPE
,      EMAIL_ADDRESS
,      ADDRESS1
,      ADDRESS2
,      COMPETITOR_FLAG
,      THIRD_PARTY_FLAG
,      PERSON_FIRST_NAME
,      PERSON_MIDDLE_NAME
,      PERSON_LAST_NAME
,      PERSON_NAME_SUFFIX
,      PERSON_TITLE
,      PERSON_ACADEMIC_TITLE
,      PERSON_PRE_NAME_ADJUNCT
,      CONTROL_YR
,      CONG_DIST_CODE
,      LABOR_SURPLUS_FLAG
,      DEBARMENT_FLAG
,      DISADV_8A_FLAG
,      DEBARMENTS_COUNT
,      MONTHS_SINCE_LAST_DEBARMENT
,      GSA_INDICATOR_FLAG
,      ANALYSIS_FY
,      FISCAL_YEAREND_MONTH
,      CURR_FY_POTENTIAL_REVENUE
,      NEXT_FY_POTENTIAL_REVENUE
,      ORGANIZATION_TYPE
,      CORPORATION_CLASS
,      REGISTRATION_TYPE
,      INCORP_YEAR
,      PUBLIC_PRIVATE_OWNERSHIP_FLAG
,      INTERNAL_FLAG
,      TOTAL_PAYMENTS
,      CREDIT_SCORE_CLASS
,      CREDIT_SCORE_NATL_PERCENTILE
,      CREDIT_SCORE_INCD_DEFAULT
,      CREDIT_SCORE_AGE
,      FAILURE_SCORE_CLASS
,      FAILURE_SCORE_INCD_DEFAULT
,      FAILURE_SCORE_AGE
,      MAXIMUM_CREDIT_RECOMMENDATION
,      MAXIMUM_CREDIT_CURRENCY_CODE
,      PARTY_NAME
,      CITY
FROM AMS.AMS_DM_PARTY_DETAILS;

Dependencies

[top of page]

AMS.AMS_DM_PARTY_DETAILS does not reference any database object

AMS.AMS_DM_PARTY_DETAILS is referenced by following:

SchemaAMS
ViewAMS_DM_PARTY_DETAILS#