VIEW: APPS.AMS_DM_PARTY_ATTRIBUTES_V

Source

View Text - Preformatted

SELECT d.PARTY_ID, GROSS_ANNUAL_INCOME, DEBT_TO_INCOME_RATIO, NET_WORTH, TOTAL_ASSETS, TOT_DEBT_OUTSTANDING, GROSS_ANNUAL_SALES, CURRENT_ASSETS, CURRENT_LIABILITIES, NET_PROFIT, ACCOUNTS_RECEIVABLE, RETAINED_EARNINGS, THIRD_PARTY_FLAG, DAYS_SINCE_LAST_EVENT, NUM_TIMES_TARGETED, LAST_TARGETED_CHANNEL_CODE, TIMES_TARGETED_MONTH, TIMES_TARGETED_3_MONTHS, TIMES_TARGETED_6_MONTHS, TIMES_TARGETED_9_MONTHS, TIMES_TARGETED_12_MONTHS, DAYS_SINCE_LAST_TARGETED, AVG_DISC_OFFERED, NUM_TYPES_DISC_OFFERED, DAYS_SINCE_FIRST_CONTACT, NUM_TIMES_TARGETED_EMAIL, NUM_TIMES_TARGETED_TELEMKT, NUM_TIMES_TARGETED_DIRECT, NUM_TGT_BY_OFFR_TYP1, NUM_TGT_BY_OFFR_TYP2, NUM_TGT_BY_OFFR_TYP3, NUM_TGT_BY_OFFR_TYP4, 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, 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, NULL SEEDED_TARGET from ams_dm_party_details d, ams_dm_party_details_time dt WHERE d.party_id = dt.party_id

View Text - HTML Formatted

SELECT D.PARTY_ID
, GROSS_ANNUAL_INCOME
, DEBT_TO_INCOME_RATIO
, NET_WORTH
, TOTAL_ASSETS
, TOT_DEBT_OUTSTANDING
, GROSS_ANNUAL_SALES
, CURRENT_ASSETS
, CURRENT_LIABILITIES
, NET_PROFIT
, ACCOUNTS_RECEIVABLE
, RETAINED_EARNINGS
, THIRD_PARTY_FLAG
, DAYS_SINCE_LAST_EVENT
, NUM_TIMES_TARGETED
, LAST_TARGETED_CHANNEL_CODE
, TIMES_TARGETED_MONTH
, TIMES_TARGETED_3_MONTHS
, TIMES_TARGETED_6_MONTHS
, TIMES_TARGETED_9_MONTHS
, TIMES_TARGETED_12_MONTHS
, DAYS_SINCE_LAST_TARGETED
, AVG_DISC_OFFERED
, NUM_TYPES_DISC_OFFERED
, DAYS_SINCE_FIRST_CONTACT
, NUM_TIMES_TARGETED_EMAIL
, NUM_TIMES_TARGETED_TELEMKT
, NUM_TIMES_TARGETED_DIRECT
, NUM_TGT_BY_OFFR_TYP1
, NUM_TGT_BY_OFFR_TYP2
, NUM_TGT_BY_OFFR_TYP3
, NUM_TGT_BY_OFFR_TYP4
, 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
, 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
, NULL SEEDED_TARGET
FROM AMS_DM_PARTY_DETAILS D
, AMS_DM_PARTY_DETAILS_TIME DT
WHERE D.PARTY_ID = DT.PARTY_ID