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

VIEW: APPS.AMS_DM_ORGANIZATIONS_V

Object Details
Object Name: AMS_DM_ORGANIZATIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_DM_ORGANIZATIONS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER
Yes Party identifier.
PARTY_NAME VARCHAR2 (360)
Name of this party.
EMAIL_ADDRESS VARCHAR2 (240)
E-mail address.
ADDRESS1 VARCHAR2 (240)
First line of address.
ADDRESS2 VARCHAR2 (240)
Second line of address.
CITY VARCHAR2 (120)
The city of the party's registered location.
STATE VARCHAR2 (60)
State.
PROVINCE VARCHAR2 (60)
Province.
ZIP_CODE VARCHAR2 (60)
Zip code.
COUNTRY VARCHAR2 (60)
Country.
RENT_FLAG VARCHAR2 (1)
Rent indicator.
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.
REFERENCE_USE_FLAG VARCHAR2 (1)
Use as a reference indicator.
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.
LINE_OF_BUSINESS VARCHAR2 (30)
Line of business.
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.
BUSINESS_SCOPE VARCHAR2 (240)
The physical class of business in which a business participates. For example, local, national, or international.
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.
HIGH_CREDIT NUMBER

High credit.
AVG_HIGH_CREDIT NUMBER

Average high credit.
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.
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.
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.
GLOBAL_FAILURE_SCORE VARCHAR2 (5)
Global failure score.
DNB_SCORE VARCHAR2 (5)
Dunn and Bradstreet score.
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.
YEAR_ESTABLISHED NUMBER

Year established.
SIC_CODE1 VARCHAR2 (30)
Industry SIC code.
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.
DAYS_SINCE_LAST_EVENT NUMBER

Number of days since last attended an event.
NUM_TIMES_TARGETED NUMBER

Number of times targeted.
LAST_TARGETED_CHANNEL_CODE NUMBER

Last targeted channel.
TIMES_TARGETED_MONTH NUMBER

Number of times targeted in the last month.
TIMES_TARGETED_3_MONTHS NUMBER

Number of times targeted in the last 3 months.
TIMES_TARGETED_6_MONTHS NUMBER

Number of times targeted in the last 6 months.
TIMES_TARGETED_12_MONTHS NUMBER

Number of times targeted in the last 12 months.
DAYS_SINCE_LAST_TARGETED NUMBER

Number of days since the last time targeted.
AVG_DISC_OFFERED NUMBER

Average discount offered.
NUM_TYPES_DISC_OFFERED NUMBER

Number of types of discounts offered.
NUM_TIMES_TARGETED_EMAIL NUMBER

Number of times targeted by email.
NUM_TIMES_TARGETED_DIRECT NUMBER

Number of times targeted by direct mail.
NUM_TIMES_TARGETED_TELEMKT NUMBER

Number of times targeted by telemarketing.
NUM_TGT_BY_OFFR_TYP1 NUMBER

Number of times targeted by offer 1.
NUM_TGT_BY_OFFR_TYP2 NUMBER

Number of times targeted by offer 2.
NUM_TGT_BY_OFFR_TYP3 NUMBER

Number of times targeted by offer 3.
NUM_TGT_BY_OFFR_TYP4 NUMBER

Number of times targeted by offer 4.
DAYS_SINCE_FIRST_CONTACT NUMBER

Number of days since the first contact.
AVG_TALK_TIME NUMBER

Average talk time.
AVG_ORDER_AMOUNT NUMBER

Average order amount.
AVG_UNITS_PER_ORDER NUMBER

Averge units per order.
TOT_ORDER_AMOUNT_YEAR NUMBER

Total order amount in the past year.
TOT_ORDER_AMOUNT_9_MONTHS NUMBER

Total order amount in the past 9 months.
TOT_ORDER_AMOUNT_6_MONTHS NUMBER

Total order amount in the past 6 months.
TOT_ORDER_AMOUNT_3_MONTHS NUMBER

Total order amount in the past 3 months.
TOT_NUM_ORDERS_YEAR NUMBER

Total number of orders in the past year.
TOT_NUM_ORDER_9_MONTHS NUMBER

Total number of orders in the past 9 months.
TOT_NUM_ORDER_6_MONTHS NUMBER

Total number of orders in the past 6 months.
TOT_NUM_ORDER_3_MONTHS NUMBER

Total number of orders in the past 3 months.
DAYS_SINCE_ACCT_ESTABLISHED NUMBER

Number of days since account established.
DAYS_SINCE_ACCT_TERM NUMBER

Number of days since account terms.
DAYS_SINCE_ACCT_ACTIVATION NUMBER

Number of days since account activation.
DAYS_SINCE_ACCT_SUSPENDED NUMBER

Number of days since the account was suspended.
NUM_OF_SR_YEAR NUMBER

Number of service requests in the past year.
NUM_OF_SR_6_MONTHS NUMBER

Number of service requests in the past 6 months.
NUM_OF_SR_3_MONTHS NUMBER

Number of service requests in the past 3 months.
NUM_OF_SR_1_MONTH NUMBER

Number of service requests in the past month.
AVG_RESOLVE_DAYS_YEAR NUMBER

Average number of days to resolve in the past year.
AVG_RESOLVE_DAYS_6_MONTHS NUMBER

Average number of days to resolve in the past 6 months.
AVG_RESOLVE_DAYS_3_MONTHS NUMBER

Average number of days to resolve in the past 3 months.
AVG_RESOLVE_DAYS_1_MONTH NUMBER

Average number of days to resolve in the past month.
ORDER_LINES_DELIVERED NUMBER

Number of order lines delivered.
ORDER_LINES_ONTIME NUMBER

Number of order lines delivered on time.
ORDER_QTY_CUMUL NUMBER

Cumulative order quantity.
ORDER_RECENCY NUMBER

Order recency.
PAYMENTS NUMBER

Payments.
RETURNS NUMBER

Returns.
RETURN_BY_VALUE NUMBER

Return by value.
RETURN_BY_VALUE_PCT NUMBER

Return by percentage value.
ONTIME_PAYMENTS NUMBER

On time payments.
ONTIME_SHIP_PCT NUMBER

Ontime ship percentage.
CLOSED_SRS NUMBER

Closed service requests.
COGS NUMBER

Cost of goods.
CONTRACTS_CUML NUMBER

Cumulative contracts.
CONTRACT_AMT NUMBER

Contract amount.
CONTRACT_DURATION NUMBER

Contract duration.
INACTIVE_CONTRACTS NUMBER

Inactive contracts.
OPEN_CONTRACTS NUMBER

Open contracts.
NEW_CONTRACTS NUMBER

New contracts.
RENEWED_CONTRACTS NUMBER

Renewed contracts.
ESCALATED_SRS NUMBER

Escalated service requests.
FIRST_CALL_CL_RATE NUMBER

First call close rate.
NUM_OF_COMPLAINTS NUMBER

Number of complaints.
NUM_OF_INTERACTIONS NUMBER

Number of interactions.
NUM_OF_TRANSFERS NUMBER

Number of transfers.
OPEN_SRS NUMBER

Open service requests.
PCT_CALL_REWORK NUMBER

Percentage of calls reworked.
PRODUCTS NUMBER

Products.
REFERALS NUMBER

Referrals.
REOPENED_SRS NUMBER

Re-opened service requests.
SALES NUMBER

Sales.
TOTAL_SR_RESPONSE_TIME NUMBER

Total service request response time.
PCT_FIRST_CLOSED_SRS NUMBER

Percentage of first closed service requests.
AVG_COMPLAINTS NUMBER

Average complaints.
AVG_HOLD_TIME NUMBER

Average hold time.
AVG_LEN_OF_EMP NUMBER

Average length of employment.
AVG_TRANSFERS_PER_SR NUMBER

Average transfers per service request.
AVG_WORKLOAD NUMBER

Average workload.
TOT_CALLS NUMBER

Total calls.
CALL_LENGTH NUMBER

Call length.
PROFITABILITY NUMBER

Profitability.
SEEDED_TARGET VARCHAR2 (0)
Dummy column used for programmatic identification of seeded data mining data sources and target fields. Not intended for use by customers.
Query Text

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


SELECT PARTY_ID
,      PARTY_NAME
,      EMAIL_ADDRESS
,      ADDRESS1
,      ADDRESS2
,      CITY
,      STATE
,      PROVINCE
,      ZIP_CODE
,      COUNTRY
,      RENT_FLAG
,      COMPETITOR_FLAG
,      THIRD_PARTY_FLAG
,      REFERENCE_USE_FLAG
,      PERSON_FIRST_NAME
,      PERSON_MIDDLE_NAME
,      PERSON_LAST_NAME
,      PERSON_NAME_SUFFIX
,      PERSON_TITLE
,      PERSON_ACADEMIC_TITLE
,      PERSON_PRE_NAME_ADJUNCT
,      CONTROL_YR
,      LINE_OF_BUSINESS
,      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
,      BUSINESS_SCOPE
,      CORPORATION_CLASS
,      REGISTRATION_TYPE
,      INCORP_YEAR
,      PUBLIC_PRIVATE_OWNERSHIP_FLAG
,      INTERNAL_FLAG
,      HIGH_CREDIT
,      AVG_HIGH_CREDIT
,      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
,      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
,      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
,      GLOBAL_FAILURE_SCORE
,      DNB_SCORE
,      OUT_OF_BUSINESS_FLAG
,      CUSTOMER_QUALITY_RANK
,      FORTUNE_500_RANK
,      NUM_OF_EMPLOYEES
,      LEGAL_STATUS
,      YEAR_ESTABLISHED
,      SIC_CODE1
,      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
,      DAYS_SINCE_LAST_EVENT
,      NUM_TIMES_TARGETED
,      LAST_TARGETED_CHANNEL_CODE
,      TIMES_TARGETED_MONTH
,      TIMES_TARGETED_3_MONTHS
,      TIMES_TARGETED_6_MONTHS
,      TIMES_TARGETED_12_MONTHS
,      DAYS_SINCE_LAST_TARGETED
,      AVG_DISC_OFFERED
,      NUM_TYPES_DISC_OFFERED
,      NUM_TIMES_TARGETED_EMAIL
,      NUM_TIMES_TARGETED_DIRECT
,      NUM_TIMES_TARGETED_TELEMKT
,      NUM_TGT_BY_OFFR_TYP1
,      NUM_TGT_BY_OFFR_TYP2
,      NUM_TGT_BY_OFFR_TYP3
,      NUM_TGT_BY_OFFR_TYP4
,      DAYS_SINCE_FIRST_CONTACT
,      AVG_TALK_TIME
,      AVG_ORDER_AMOUNT
,      AVG_UNITS_PER_ORDER
,      TOT_ORDER_AMOUNT_YEAR
,      TOT_ORDER_AMOUNT_9_MONTHS
,      TOT_ORDER_AMOUNT_6_MONTHS
,      TOT_ORDER_AMOUNT_3_MONTHS
,      TOT_NUM_ORDERS_YEAR
,      TOT_NUM_ORDER_9_MONTHS
,      TOT_NUM_ORDER_6_MONTHS
,      TOT_NUM_ORDER_3_MONTHS
,      DAYS_SINCE_ACCT_ESTABLISHED
,      DAYS_SINCE_ACCT_TERM
,      DAYS_SINCE_ACCT_ACTIVATION
,      DAYS_SINCE_ACCT_SUSPENDED
,      NUM_OF_SR_YEAR
,      NUM_OF_SR_6_MONTHS
,      NUM_OF_SR_3_MONTHS
,      NUM_OF_SR_1_MONTH
,      AVG_RESOLVE_DAYS_YEAR
,      AVG_RESOLVE_DAYS_6_MONTHS
,      AVG_RESOLVE_DAYS_3_MONTHS
,      AVG_RESOLVE_DAYS_1_MONTH
,      ORDER_LINES_DELIVERED
,      ORDER_LINES_ONTIME
,      ORDER_QTY_CUMUL
,      ORDER_RECENCY
,      PAYMENTS
,      RETURNS
,      RETURN_BY_VALUE
,      RETURN_BY_VALUE_PCT
,      ONTIME_PAYMENTS
,      ONTIME_SHIP_PCT
,      CLOSED_SRS
,      COGS
,      CONTRACTS_CUML
,      CONTRACT_AMT
,      CONTRACT_DURATION
,      INACTIVE_CONTRACTS
,      OPEN_CONTRACTS
,      NEW_CONTRACTS
,      RENEWED_CONTRACTS
,      ESCALATED_SRS
,      FIRST_CALL_CL_RATE
,      NUM_OF_COMPLAINTS
,      NUM_OF_INTERACTIONS
,      NUM_OF_TRANSFERS
,      OPEN_SRS
,      PCT_CALL_REWORK
,      PRODUCTS
,      REFERALS
,      REOPENED_SRS
,      SALES
,      TOTAL_SR_RESPONSE_TIME
,      PCT_FIRST_CLOSED_SRS
,      AVG_COMPLAINTS
,      AVG_HOLD_TIME
,      AVG_LEN_OF_EMP
,      AVG_TRANSFERS_PER_SR
,      AVG_WORKLOAD
,      TOT_CALLS
,      CALL_LENGTH
,      PROFITABILITY
,      SEEDED_TARGET
FROM APPS.AMS_DM_ORGANIZATIONS_V;

Dependencies

[top of page]

APPS.AMS_DM_ORGANIZATIONS_V references the following:

SchemaAPPS
SynonymAMS_DM_PARTY_DETAILS
SynonymAMS_DM_PARTY_DETAILS_TIME

APPS.AMS_DM_ORGANIZATIONS_V is not referenced by any database object