CREATE OR REPLACE FORCE VIEW "CASH_COUNTER_SUMMARY_REPORT" ("P_DATE", "CASH", "NETS_OR_CDA", "CASHCARD", "CHEQUE", "CREDIT_CARD", "VOUCHER", "IB", "COMPANY_CODE", "CLINIC_CODE", "PAYMENT_MODE", "TOTAL") AS
SELECT To_date('2010-8-8', 'yyyy-mm-dd') as p_Date,'CASH1' as CASH, 'NETS1' as NETS_or_CDA, 'CASHCARD1' as CASHCARD
, 'CHEQUE1' as CHEQUE
, 'CREDIT1' as CREDIT_CARD
, 'VOUCHER1' as VOUCHER
, 'IB1' as IB
, 'A' as company_code
, '5' as clinic_code
, 'CHECK' as payment_mode
,10 as Total
FROM eposdba.ADDRESS_MS
SELECT To_date('2010-8-8', 'yyyy-mm-dd') as p_Date,'CASH1' as CASH, 'NETS1' as NETS_or_CDA, 'CASHCARD1' as CASHCARD
, 'CHEQUE1' as CHEQUE
, 'CREDIT1' as CREDIT_CARD
, 'VOUCHER1' as VOUCHER
, 'IB1' as IB
, 'A' as company_code
, '5' as clinic_code
, 'CHECK' as payment_mode
,10 as Total
FROM eposdba.ADDRESS_MS