Product: | AMS - Marketing |
---|---|
Description: | Obseleted view. |
Implementation/DBA Data: | APPS.AMS_DM_SOURCE_SCORE_CON_V |
SELECT S.SOURCE_ID
, S.PARTY_ID
, S.ARC_USED_FOR_OBJECT
, S.USED_FOR_OBJECT_ID
, P.GENDER
, P.ETHNICITY
, P.MARITAL_STATUS
, P.PERSONAL_INCOME
, P.HOH_FLAG
, P.HOUSEHOLD_INCOME
, P.HOUSEHOLD_SIZE
, P.APARTMENT_FLAG
, P.RENT_FLAG
, P.DEGREE_RECEIVED
, P.SCHOOL_TYPE
, P.INTEREST_ART_FLAG
, P.INTEREST_BOOKS_FLAG
, P.INTEREST_MOVIES_FLAG
, P.INTEREST_MUSIC_FLAG
, P.INTEREST_THEATER_FLAG
, P.INTEREST_TRAVEL_FLAG
, P.INTEREST_DRINK_FLAG
, P.INTEREST_SMOKE_FLAG
, P.EMPLOYED_FLAG
, P.YEARS_EMPLOYED
, P.OCCUPATION
, P.MILITARY_BRANCH
, P.RESIDENCE_TYPE
, P.RESIDENT_LENGTH
, P.PRESENCE_OF_CHILDREN
, P.COUNTRY
, P.STATE
, P.PROVINCE
, P.COUNTY
, P.ZIP_CODE
, P.REFERENCE_USE_FLAG
, P.GROSS_ANNUAL_INCOME
, P.DEBT_TO_INCOME_RATIO
, P.NUM_CREDIT_LINES
, P.NUM_TRADE_LINES
, P.NET_WORTH
, P.TOTAL_ASSETS
, P.TOT_DEBT_OUTSTANDING
, P.BANKRUPTCY_FLAG
, P.HIGH_RISK_FRAUD_FLAG
, P.GROSS_ANNUAL_SALES
, P.GROWTH_RATE_SALES_YEAR
, P.CURRENT_ASSETS
, P.CURRENT_LIABILITIES
, P.TOTAL_DEBTS
, P.CREDIT_CHECK_FLAG
, P.TOLERANCE
, P.DISCOUNT_TERMS_FLAG
, P.DUNNING_LETTERS_FLAG
, P.INTEREST_CHARGES_FLAG
, P.SEND_STATEMENTS_FLAG
, P.CREDIT_HOLD_FLAG
, P.CREDIT_RATING
, P.RISK_CODE
, PT.AGE
, PT.DAYS_SINCE_LAST_EVENT
, PT.DAYS_SINCE_LAST_SCHOOL
, PT.NUM_TIMES_TARGETED
, PT.LAST_TARGETED_CHANNEL_CODE
, PT.TIMES_TARGETED_MONTH
, PT.TIMES_TARGETED_3_MONTHS
, PT.TIMES_TARGETED_6_MONTHS
, PT.TIMES_TARGETED_12_MONTHS
, PT.DAYS_SINCE_LAST_TARGETED
, PT.AVG_DISC_OFFERED
, PT.NUM_TYPES_DISC_OFFERED
, PT.NUM_TIMES_TARGETED_EMAIL
, PT.NUM_TIMES_TARGETED_DIRECT
, PT.NUM_TIMES_TARGETED_TELEMKT
, PT.NUM_TGT_BY_OFFR_TYP1
, PT.NUM_TGT_BY_OFFR_TYP2
, PT.NUM_TGT_BY_OFFR_TYP3
, PT.NUM_TGT_BY_OFFR_TYP4
, PT.DAYS_SINCE_FIRST_CONTACT
, PT.AVG_TALK_TIME
, PT.AVG_ORDER_AMOUNT
, PT.AVG_UNITS_PER_ORDER
, PT.TOT_ORDER_AMOUNT_YEAR
, PT.TOT_ORDER_AMOUNT_9_MONTHS
, PT.TOT_ORDER_AMOUNT_6_MONTHS
, PT.TOT_ORDER_AMOUNT_3_MONTHS
, PT.TOT_NUM_ORDERS_YEAR
, PT.TOT_NUM_ORDER_9_MONTHS
, PT.TOT_NUM_ORDER_6_MONTHS
, PT.TOT_NUM_ORDER_3_MONTHS
, PT.DAYS_SINCE_ACCT_ESTABLISHED
, PT.DAYS_SINCE_ACCT_TERM
, PT.DAYS_SINCE_ACCT_ACTIVATION
, PT.DAYS_SINCE_ACCT_SUSPENDED
, PT.NUM_OF_SR_YEAR
, PT.NUM_OF_SR_6_MONTHS
, PT.NUM_OF_SR_3_MONTHS
, PT.NUM_OF_SR_1_MONTH
, PT.AVG_RESOLVE_DAYS_YEAR
, PT.AVG_RESOLVE_DAYS_6_MONTHS
, PT.AVG_RESOLVE_DAYS_3_MONTHS
, PT.AVG_RESOLVE_DAYS_1_MONTH
, PT.ORDER_LINES_DELIVERED
, PT.ORDER_LINES_ONTIME
, PT.ORDER_QTY_CUMUL
, PT.ORDER_RECENCY
, PT.PAYMENTS
, PT.RETURNS
, PT.RETURN_BY_VALUE
, PT.RETURN_BY_VALUE_PCT
, PT.ONTIME_PAYMENTS
, PT.ONTIME_SHIP_PCT
, PT.CLOSED_SRS
, PT.COGS
, PT.CONTRACTS_CUML
, PT.CONTRACT_AMT
, PT.CONTRACT_DURATION
, PT.INACTIVE_CONTRACTS
, PT.OPEN_CONTRACTS
, PT.NEW_CONTRACTS
, PT.RENEWED_CONTRACTS
, PT.ESCALATED_SRS
, PT.FIRST_CALL_CL_RATE
, PT.NUM_OF_COMPLAINTS
, PT.NUM_OF_INTERACTIONS
, PT.NUM_OF_TRANSFERS
, PT.OPEN_SRS
, PT.PCT_CALL_REWORK
, PT.PRODUCTS
, PT.REFERALS
, PT.REOPENED_SRS
, PT.SALES
, PT.TOTAL_SR_RESPONSE_TIME
, PT.PCT_FIRST_CLOSED_SRS
, PT.AVG_COMPLAINTS
, PT.AVG_HOLD_TIME
, PT.AVG_LEN_OF_EMP
, PT.AVG_TRANSFERS_PER_SR
, PT.AVG_WORKLOAD
, PT.TOT_CALLS
, PT.CALL_LENGTH
, PT.PROFITABILITY
, S.TARGET_VALUE
FROM AMS_DM_SOURCE S
, AMS_DM_PARTY_DETAILS P
, AMS_DM_PARTY_DETAILS_TIME PT
WHERE S.PARTY_ID = P.PARTY_ID
AND PT.PARTY_ID = P.PARTY_ID
AND ARC_USED_FOR_OBJECT = 'SCOR'