Product: | AMS - Marketing |
---|---|
Description: | Obseleted view. |
Implementation/DBA Data: | APPS.AMS_DM_SOURCE_MODEL_BUS_V |
SELECT S.SOURCE_ID
, S.PARTY_ID
, S.ARC_USED_FOR_OBJECT
, S.USED_FOR_OBJECT_ID
, 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.NET_PROFIT
, P.TANGIBLE_NET_PROFIT
, P.CAPITAL_AMOUNT
, P.CAPITAL_TYPE_INDICATOR
, P.ACCOUNTS_RECEIVABLE
, P.RETAINED_EARNINGS
, P.PAYDEX_SCORE_YEAR
, P.PAYDEX_SCORE_3_MONTH_AGO
, P.INDUSTRY_PAYDEX_MEDIAN
, P.GLOBAL_FAILURE_SCORE
, P.DNB_SCORE
, P.OUT_OF_BUSINESS_FLAG
, P.CUSTOMER_QUALITY_RANK
, P.FORTUNE_500_RANK
, P.NUM_OF_EMPLOYEES
, P.LEGAL_STATUS
, P.YEAR_ESTABLISHED
, P.SIC_CODE1
, P.MINORITY_BUSINESS_FLAG
, P.SMALL_BUSINESS_FLAG
, P.WOMEN_OWNED_BUS_FLAG
, P.GOV_ORG_FLAG
, P.HQ_SUBSIDIARY_FLAG
, P.FOREIGN_OWNED_FLAG
, P.IMPORT_EXPORT_BUS_FLAG
, 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.DAYS_SINCE_LAST_EVENT
, 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 -- WE MAY WANT TO DENORMALIZE TARGET_GROUP_TYPE TO FILER CONSUMERS
AND BUSINESSES
, AMS_DM_MODELS_ALL_B M
WHERE S.PARTY_ID = P.PARTY_ID
AND PT.PARTY_ID = P.PARTY_ID
AND S.ARC_USED_FOR_OBJECT = 'MODL'