VIEW: ICX.ICX_PANEL_SUMMARY#

Source

View Text - Preformatted

select ORG_ID ORG_ID, CUSTOMER_ID CUSTOMER_ID, DATA_AS_OF_DATE DATA_AS_OF_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SAME_SUPPLY_CHAIN_FLAG SAME_SUPPLY_CHAIN_FLAG, CURRENCY_CODE CURRENCY_CODE, LAST_ORDER_HEADER_ID LAST_ORDER_HEADER_ID, ORDERS_AMOUNT_LAST_WEEK ORDERS_AMOUNT_LAST_WEEK, ORDERS_LAST_WEEK ORDERS_LAST_WEEK, ORDERS_AMOUNT_LAST_MONTH ORDERS_AMOUNT_LAST_MONTH, ORDERS_LAST_MONTH ORDERS_LAST_MONTH, ORDERS_AMOUNT_LAST_3_MONTHS ORDERS_AMOUNT_LAST_3_MONTHS, ORDERS_LAST_3_MONTHS ORDERS_LAST_3_MONTHS, ORDERS_AMOUNT_LAST_6_MONTHS ORDERS_AMOUNT_LAST_6_MONTHS, ORDERS_LAST_6_MONTHS ORDERS_LAST_6_MONTHS, ORDERS_AMOUNT_LAST_12_MONTHS ORDERS_AMOUNT_LAST_12_MONTHS, ORDERS_LAST_12_MONTHS ORDERS_LAST_12_MONTHS, CANCELLED_ORDERS_3_MONTHS CANCELLED_ORDERS_3_MONTHS, CANCELLED_AMOUNT_3_MONTHS CANCELLED_AMOUNT_3_MONTHS, CANCELLED_ORDERS_6_MONTHS CANCELLED_ORDERS_6_MONTHS, CANCELLED_AMOUNT_6_MONTHS CANCELLED_AMOUNT_6_MONTHS, RMA_3_MONTHS RMA_3_MONTHS, RMA_AMOUNT_3_MONTHS RMA_AMOUNT_3_MONTHS, RMA_6_MONTHS RMA_6_MONTHS, RMA_AMOUNT_6_MONTHS RMA_AMOUNT_6_MONTHS, LAST_ORDER_DATE LAST_ORDER_DATE, LAST_ORDER_NUMBER LAST_ORDER_NUMBER, SHIPMENTS_OPEN SHIPMENTS_OPEN, SHIPMENTS_LATE SHIPMENTS_LATE, CREDIT_RATING CREDIT_RATING, RISK_CODE RISK_CODE, LATE_PAYMENTS_3_MONTHS LATE_PAYMENTS_3_MONTHS, LATE_PAYMENTS_6_MONTHS LATE_PAYMENTS_6_MONTHS, AMOUNT_DUE AMOUNT_DUE, SERVICE_CALLS_3_MONTHS SERVICE_CALLS_3_MONTHS, DATE_OF_LAST_SERVICE_CALL DATE_OF_LAST_SERVICE_CALL, SITE_ID_LAST_SERVICE_CALL SITE_ID_LAST_SERVICE_CALL, SERVICE_AMOUNT_6_MONTHS SERVICE_AMOUNT_6_MONTHS, SERVICE_ORDERS_6_MONTHS SERVICE_ORDERS_6_MONTHS, SERVICE_AMOUNT_12_MONTHS SERVICE_AMOUNT_12_MONTHS, SERVICE_ORDERS_12_MONTHS SERVICE_ORDERS_12_MONTHS, LAST_SERVICE_CALL_CONTACT LAST_SERVICE_CALL_CONTACT, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12 from "ICX"."ICX_PANEL_SUMMARY"

View Text - HTML Formatted

SELECT ORG_ID ORG_ID
, CUSTOMER_ID CUSTOMER_ID
, DATA_AS_OF_DATE DATA_AS_OF_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SAME_SUPPLY_CHAIN_FLAG SAME_SUPPLY_CHAIN_FLAG
, CURRENCY_CODE CURRENCY_CODE
, LAST_ORDER_HEADER_ID LAST_ORDER_HEADER_ID
, ORDERS_AMOUNT_LAST_WEEK ORDERS_AMOUNT_LAST_WEEK
, ORDERS_LAST_WEEK ORDERS_LAST_WEEK
, ORDERS_AMOUNT_LAST_MONTH ORDERS_AMOUNT_LAST_MONTH
, ORDERS_LAST_MONTH ORDERS_LAST_MONTH
, ORDERS_AMOUNT_LAST_3_MONTHS ORDERS_AMOUNT_LAST_3_MONTHS
, ORDERS_LAST_3_MONTHS ORDERS_LAST_3_MONTHS
, ORDERS_AMOUNT_LAST_6_MONTHS ORDERS_AMOUNT_LAST_6_MONTHS
, ORDERS_LAST_6_MONTHS ORDERS_LAST_6_MONTHS
, ORDERS_AMOUNT_LAST_12_MONTHS ORDERS_AMOUNT_LAST_12_MONTHS
, ORDERS_LAST_12_MONTHS ORDERS_LAST_12_MONTHS
, CANCELLED_ORDERS_3_MONTHS CANCELLED_ORDERS_3_MONTHS
, CANCELLED_AMOUNT_3_MONTHS CANCELLED_AMOUNT_3_MONTHS
, CANCELLED_ORDERS_6_MONTHS CANCELLED_ORDERS_6_MONTHS
, CANCELLED_AMOUNT_6_MONTHS CANCELLED_AMOUNT_6_MONTHS
, RMA_3_MONTHS RMA_3_MONTHS
, RMA_AMOUNT_3_MONTHS RMA_AMOUNT_3_MONTHS
, RMA_6_MONTHS RMA_6_MONTHS
, RMA_AMOUNT_6_MONTHS RMA_AMOUNT_6_MONTHS
, LAST_ORDER_DATE LAST_ORDER_DATE
, LAST_ORDER_NUMBER LAST_ORDER_NUMBER
, SHIPMENTS_OPEN SHIPMENTS_OPEN
, SHIPMENTS_LATE SHIPMENTS_LATE
, CREDIT_RATING CREDIT_RATING
, RISK_CODE RISK_CODE
, LATE_PAYMENTS_3_MONTHS LATE_PAYMENTS_3_MONTHS
, LATE_PAYMENTS_6_MONTHS LATE_PAYMENTS_6_MONTHS
, AMOUNT_DUE AMOUNT_DUE
, SERVICE_CALLS_3_MONTHS SERVICE_CALLS_3_MONTHS
, DATE_OF_LAST_SERVICE_CALL DATE_OF_LAST_SERVICE_CALL
, SITE_ID_LAST_SERVICE_CALL SITE_ID_LAST_SERVICE_CALL
, SERVICE_AMOUNT_6_MONTHS SERVICE_AMOUNT_6_MONTHS
, SERVICE_ORDERS_6_MONTHS SERVICE_ORDERS_6_MONTHS
, SERVICE_AMOUNT_12_MONTHS SERVICE_AMOUNT_12_MONTHS
, SERVICE_ORDERS_12_MONTHS SERVICE_ORDERS_12_MONTHS
, LAST_SERVICE_CALL_CONTACT LAST_SERVICE_CALL_CONTACT
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
FROM "ICX"."ICX_PANEL_SUMMARY"