select
AR_CREDIT,
AR_DEBIT,
AR_NUMBER,
BILL_GENERATION_DATE,
BILL_NO,
CASHIER_ID,
SUBSTR(CHEQUE_NUMBER,1,3) RVC,
SUBSTR(CHEQUE_NUMBER,4,4) CHECK_NO,
NVL(CAST(COVERS as NUMBER),0) COVERS,
DEP_CREDIT,
DEP_DEBIT,
FOLIO_TYPE,
GUEST_COUNTRY_CODE,
GUEST_COUNTRY_NAME,
GUEST_CREDIT,
GUEST_DEBIT,
GUEST_NAME,
GUEST_NAME_ID,
MUN_VAT,
NET,
PAYEE_NAME,
PAYEE_NAME_ID,
PAYEE_NAME_TYPE,
PT,
RESORT,
RESV_NAME_ID,
ROOM,
--TAXELEMMINIC,
--TAXELEMVAT,
TRANS_CODE,
trim(TRX_CODE) TRX_CODE,
TRX_DATE,
rtrim(TRX_DESCR) as TRX_DESCR,
TRX_GROUP,
TRX_SUBGROUP,
TRX_NO,
VAT
from EUROTEL_REPORT_fin_trans
where trx_date between :from_date and :to_date
and
from EUROTEL_REPORT_RES_WBLKNM
WHERE business_date BETWEEN :datefrom AND :DATEto
--WHERE business_date BETWEEN to_date('01/05/2013','dd/mm/yyyy') AND to_date('31/12/2014','dd/mm/yyyy')
group by
RESORT,
R_TYPE,
ROOM,
--- RESV_NAME_ID,
-- GUEST_NAME_ID,
--- GUEST_FIRST_NAME,
---- CUSTOM_REFERENCE,
MEAL_PLAN,
ARRIVAL_DATE,
-- DEPARTURE_DATE,
business_date,
TO_CHAR(BUSINESS_DATE,'yyyy') ,
TO_CHAR(BUSINESS_DATE,'MM'),
----- TO_CHAR(BUSINESS_DATE,'WW') ,
--RT_FACTOR,
ROOM_TYPE,
ROOM_TYPE_RTC,
ROOM_CLASS,
MARKET_CODE,
SOURCE_CODE,
RATE_CODE,
----- GROUP_ID,
--- TRAVEL_AGENT_ID,
--- COMPANY_ID,
--- SOURCE_ID,
BOOKED_DATE,
--CONFIRMATION_NO,
PSUEDO_ROOM_YN,
CANCELLATION_DATE,
RESV_STATUS,
DEDUCT,
BLOCK_DEDUCT,
--- ALLOTMENT_HEADER_ID,
ALLOTMENT_NAME,
--COUNTRY,
--NATIONALITY,
COUNTRY_NAME,
NATIONALITY_NAME,
COMPANY,
TRAVEL_AGENT,
SOURCE,
ORA-00936: missing expression