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

VIEW: APPS.AMS_DM_PERSONS_V

Object Details
Object Name: AMS_DM_PERSONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_DM_PERSONS_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.
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.
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.
COUNTY VARCHAR2 (60)
County.
ZIP_CODE VARCHAR2 (60)
Zip code.
COUNTRY VARCHAR2 (60)
Country.
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.
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.
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.
PRESENCE_OF_CHILDREN NUMBER

Presence of children indicator.
REFERENCE_USE_FLAG VARCHAR2 (1)
Indicates if customer has agreed to be a reference.
CREDIT_CHECK_FLAG VARCHAR2 (1)
Indicates whether a credit check is to be carried out.
TOLERANCE NUMBER

Percentage over credit limit that this customer can exceed before action is taken.
DISCOUNT_TERMS_FLAG VARCHAR2 (1)
Indicates if discount terms exist. Y for discount terms are allowed, N for no discount terms are allowed.
DUNNING_LETTERS_FLAG VARCHAR2 (1)
Indicates if dunning letters are sent to this customer when invoices, debit memos or chargebacks become past due. Y for dunning letters are sent, N for no dunning letters.
INTEREST_CHARGES_FLAG VARCHAR2 (1)
Indicates if this customer is charged interest.
SEND_STATEMENTS_FLAG VARCHAR2 (1)
Indicates if statements are sent to this customer.
CREDIT_HOLD_FLAG VARCHAR2 (1)
Indicates if a credit hold exists on this account.
CREDIT_RATING VARCHAR2 (60)
Credit rating.
RISK_CODE VARCHAR2 (60)
Risk code.
AGE NUMBER

Age, in days, of a person.
DAYS_SINCE_LAST_EVENT NUMBER

Number of days since last attended an event.
DAYS_SINCE_LAST_SCHOOL NUMBER

Number of days since last attended school.
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
,      PERSON_FIRST_NAME
,      PERSON_MIDDLE_NAME
,      PERSON_LAST_NAME
,      PERSON_NAME_SUFFIX
,      PERSON_TITLE
,      PERSON_ACADEMIC_TITLE
,      PERSON_PRE_NAME_ADJUNCT
,      EMAIL_ADDRESS
,      ADDRESS1
,      ADDRESS2
,      CITY
,      STATE
,      PROVINCE
,      COUNTY
,      ZIP_CODE
,      COUNTRY
,      COMPETITOR_FLAG
,      THIRD_PARTY_FLAG
,      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
,      EMPLOYED_FLAG
,      YEARS_EMPLOYED
,      OCCUPATION
,      MILITARY_BRANCH
,      RESIDENCE_TYPE
,      RESIDENT_LENGTH
,      PRESENCE_OF_CHILDREN
,      REFERENCE_USE_FLAG
,      CREDIT_CHECK_FLAG
,      TOLERANCE
,      DISCOUNT_TERMS_FLAG
,      DUNNING_LETTERS_FLAG
,      INTEREST_CHARGES_FLAG
,      SEND_STATEMENTS_FLAG
,      CREDIT_HOLD_FLAG
,      CREDIT_RATING
,      RISK_CODE
,      AGE
,      DAYS_SINCE_LAST_EVENT
,      DAYS_SINCE_LAST_SCHOOL
,      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_PERSONS_V;

Dependencies

[top of page]

APPS.AMS_DM_PERSONS_V references the following:

SchemaAPPS
SynonymAMS_DM_PARTY_DETAILS
SynonymAMS_DM_PARTY_DETAILS_TIME

APPS.AMS_DM_PERSONS_V is not referenced by any database object