VIEW: AMS.AMS_DM_BIC_STG#

Source

View Text - Preformatted

select PARTY_ID PARTY_ID, AVG_TALK_TIME AVG_TALK_TIME, AVG_ORDER_AMOUNT AVG_ORDER_AMOUNT, AVG_UNITS_PER_ORDER AVG_UNITS_PER_ORDER, TOT_ORDER_AMOUNT_YEAR TOT_ORDER_AMOUNT_YEAR, TOT_ORDER_AMOUNT_9_MONTHS TOT_ORDER_AMOUNT_9_MONTHS, TOT_ORDER_AMOUNT_6_MONTHS TOT_ORDER_AMOUNT_6_MONTHS, TOT_ORDER_AMOUNT_3_MONTHS TOT_ORDER_AMOUNT_3_MONTHS, TOT_NUM_ORDERS_YEAR TOT_NUM_ORDERS_YEAR, TOT_NUM_ORDER_9_MONTHS TOT_NUM_ORDER_9_MONTHS, TOT_NUM_ORDER_6_MONTHS TOT_NUM_ORDER_6_MONTHS, TOT_NUM_ORDER_3_MONTHS TOT_NUM_ORDER_3_MONTHS, NUM_OF_SR_YEAR NUM_OF_SR_YEAR, NUM_OF_SR_6_MONTHS NUM_OF_SR_6_MONTHS, NUM_OF_SR_3_MONTHS NUM_OF_SR_3_MONTHS, NUM_OF_SR_1_MONTH NUM_OF_SR_1_MONTH, AVG_RESOLVE_DAYS_YEAR AVG_RESOLVE_DAYS_YEAR, AVG_RESOLVE_DAYS_6_MONTHS AVG_RESOLVE_DAYS_6_MONTHS, AVG_RESOLVE_DAYS_3_MONTHS AVG_RESOLVE_DAYS_3_MONTHS, AVG_RESOLVE_DAYS_1_MONTH AVG_RESOLVE_DAYS_1_MONTH, ORDER_LINES_DELIVERED ORDER_LINES_DELIVERED, ORDER_LINES_ONTIME ORDER_LINES_ONTIME, ORDER_QTY_CUMUL ORDER_QTY_CUMUL, ORDER_RECENCY ORDER_RECENCY, PAYMENTS PAYMENTS, RETURNS RETURNS, RETURN_BY_VALUE RETURN_BY_VALUE, RETURN_BY_VALUE_PCT RETURN_BY_VALUE_PCT, ONTIME_PAYMENTS ONTIME_PAYMENTS, ONTIME_SHIP_PCT ONTIME_SHIP_PCT, CLOSED_SRS CLOSED_SRS, COGS COGS, CONTRACTS_CUML CONTRACTS_CUML, CONTRACT_AMT CONTRACT_AMT, CONTRACT_DURATION CONTRACT_DURATION, INACTIVE_CONTRACTS INACTIVE_CONTRACTS, OPEN_CONTRACTS OPEN_CONTRACTS, NEW_CONTRACTS NEW_CONTRACTS, RENEWED_CONTRACTS RENEWED_CONTRACTS, ESCALATED_SRS ESCALATED_SRS, FIRST_CALL_CL_RATE FIRST_CALL_CL_RATE, NUM_OF_COMPLAINTS NUM_OF_COMPLAINTS, NUM_OF_INTERACTIONS NUM_OF_INTERACTIONS, NUM_OF_TRANSFERS NUM_OF_TRANSFERS, OPEN_SRS OPEN_SRS, PCT_CALL_REWORK PCT_CALL_REWORK, PRODUCTS PRODUCTS, REFERALS REFERALS, REOPENED_SRS REOPENED_SRS, SALES SALES, TOTAL_SR_RESPONSE_TIME TOTAL_SR_RESPONSE_TIME, PCT_FIRST_CLOSED_SRS PCT_FIRST_CLOSED_SRS, AVG_COMPLAINTS AVG_COMPLAINTS, AVG_HOLD_TIME AVG_HOLD_TIME, AVG_LEN_OF_EMP AVG_LEN_OF_EMP, AVG_TRANSFERS_PER_SR AVG_TRANSFERS_PER_SR, AVG_WORKLOAD AVG_WORKLOAD, TOT_CALLS TOT_CALLS, CALL_LENGTH CALL_LENGTH, PROFITABILITY PROFITABILITY from "AMS"."AMS_DM_BIC_STG"

View Text - HTML Formatted

SELECT PARTY_ID PARTY_ID
, AVG_TALK_TIME AVG_TALK_TIME
, AVG_ORDER_AMOUNT AVG_ORDER_AMOUNT
, AVG_UNITS_PER_ORDER AVG_UNITS_PER_ORDER
, TOT_ORDER_AMOUNT_YEAR TOT_ORDER_AMOUNT_YEAR
, TOT_ORDER_AMOUNT_9_MONTHS TOT_ORDER_AMOUNT_9_MONTHS
, TOT_ORDER_AMOUNT_6_MONTHS TOT_ORDER_AMOUNT_6_MONTHS
, TOT_ORDER_AMOUNT_3_MONTHS TOT_ORDER_AMOUNT_3_MONTHS
, TOT_NUM_ORDERS_YEAR TOT_NUM_ORDERS_YEAR
, TOT_NUM_ORDER_9_MONTHS TOT_NUM_ORDER_9_MONTHS
, TOT_NUM_ORDER_6_MONTHS TOT_NUM_ORDER_6_MONTHS
, TOT_NUM_ORDER_3_MONTHS TOT_NUM_ORDER_3_MONTHS
, NUM_OF_SR_YEAR NUM_OF_SR_YEAR
, NUM_OF_SR_6_MONTHS NUM_OF_SR_6_MONTHS
, NUM_OF_SR_3_MONTHS NUM_OF_SR_3_MONTHS
, NUM_OF_SR_1_MONTH NUM_OF_SR_1_MONTH
, AVG_RESOLVE_DAYS_YEAR AVG_RESOLVE_DAYS_YEAR
, AVG_RESOLVE_DAYS_6_MONTHS AVG_RESOLVE_DAYS_6_MONTHS
, AVG_RESOLVE_DAYS_3_MONTHS AVG_RESOLVE_DAYS_3_MONTHS
, AVG_RESOLVE_DAYS_1_MONTH AVG_RESOLVE_DAYS_1_MONTH
, ORDER_LINES_DELIVERED ORDER_LINES_DELIVERED
, ORDER_LINES_ONTIME ORDER_LINES_ONTIME
, ORDER_QTY_CUMUL ORDER_QTY_CUMUL
, ORDER_RECENCY ORDER_RECENCY
, PAYMENTS PAYMENTS
, RETURNS RETURNS
, RETURN_BY_VALUE RETURN_BY_VALUE
, RETURN_BY_VALUE_PCT RETURN_BY_VALUE_PCT
, ONTIME_PAYMENTS ONTIME_PAYMENTS
, ONTIME_SHIP_PCT ONTIME_SHIP_PCT
, CLOSED_SRS CLOSED_SRS
, COGS COGS
, CONTRACTS_CUML CONTRACTS_CUML
, CONTRACT_AMT CONTRACT_AMT
, CONTRACT_DURATION CONTRACT_DURATION
, INACTIVE_CONTRACTS INACTIVE_CONTRACTS
, OPEN_CONTRACTS OPEN_CONTRACTS
, NEW_CONTRACTS NEW_CONTRACTS
, RENEWED_CONTRACTS RENEWED_CONTRACTS
, ESCALATED_SRS ESCALATED_SRS
, FIRST_CALL_CL_RATE FIRST_CALL_CL_RATE
, NUM_OF_COMPLAINTS NUM_OF_COMPLAINTS
, NUM_OF_INTERACTIONS NUM_OF_INTERACTIONS
, NUM_OF_TRANSFERS NUM_OF_TRANSFERS
, OPEN_SRS OPEN_SRS
, PCT_CALL_REWORK PCT_CALL_REWORK
, PRODUCTS PRODUCTS
, REFERALS REFERALS
, REOPENED_SRS REOPENED_SRS
, SALES SALES
, TOTAL_SR_RESPONSE_TIME TOTAL_SR_RESPONSE_TIME
, PCT_FIRST_CLOSED_SRS PCT_FIRST_CLOSED_SRS
, AVG_COMPLAINTS AVG_COMPLAINTS
, AVG_HOLD_TIME AVG_HOLD_TIME
, AVG_LEN_OF_EMP AVG_LEN_OF_EMP
, AVG_TRANSFERS_PER_SR AVG_TRANSFERS_PER_SR
, AVG_WORKLOAD AVG_WORKLOAD
, TOT_CALLS TOT_CALLS
, CALL_LENGTH CALL_LENGTH
, PROFITABILITY PROFITABILITY
FROM "AMS"."AMS_DM_BIC_STG"