View: AMS_DM_PERSONS_V

Product:	AMS - Marketing
Description:	This view is no longer used for seeded data sources. (15-Jul-2004)View used by the seeded data mining data source for persons in the Trading Community Architecture.
Implementation/DBA Data:	APPS.AMS_DM_PERSONS_V

View Text

SELECT P.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
, NULL SEEDED_TARGET
FROM AMS_DM_PARTY_DETAILS P
, AMS_DM_PARTY_DETAILS_TIME PT
WHERE PT.PARTY_ID = P.PARTY_ID
AND P.PARTY_TYPE = 'PERSON'

Columns