Hibernate:
    select
        distinct timeprofil1_.TIME_PROFILE_ID as TIME_PROFILE_ID1_129_,
        timeprofil1_.NAME as NAME2_129_,
        timeprofil1_.TIME_PROFILE_CODE as TIME_PROFILE_CODE3_129_
    from
        club.MENU_PRICE menuprice0_,
        club.TIME_PROFILES timeprofil1_
    where
        menuprice0_.ALLOWED_TIME_PROFILE_ID=timeprofil1_.TIME_PROFILE_ID
Hibernate:
    SELECT
        mi.mi_id,
        mi.name1,
        mi.name2,
        mi.hierarchy_id,
        mp.price,
        mi.barcode,
        mi.mi_type,
        mi.code,
        mi.COMMISSION_GRP_ID as commGrpId,
        mi.color
    FROM
        menu_items mi,
        menu_price mp
    WHERE
        mi.active=1
        AND  mp.mi_id=mi.mi_id
        AND  mp.ordr=(
            SELECT
                MIN(ordr)
            FROM
                menu_price mpp
            WHERE
                mpp.mi_id = mi.mi_id
                AND        nvl(mpp.valid_from,trunc(sysdate))<=trunc(sysdate)
                AND        nvl(mpp.valid_till,trunc(sysdate))>=trunc(sysdate)
                AND (
                    mpp.allowed_rvcs IS NULL
                    OR           mpp.ALLOWED_RVCS IN (
                        SELECT
                            rvc_group_id
                        FROM
                            rvc_group_link rl
                        WHERE
                            rl.rvc_id=443
                    )
                )
                AND (
                    mpp.ALLOWED_TIME_PROFILE_ID is null
                )
            )
Hibernate:
    select
        this_.DOC_ID as DOC_ID1_42_0_,
        this_.BUSSINES_DATE as BUSSINES_DATE2_42_0_,
        this_.DEF_CARD_ID as DEF_CARD_ID3_42_0_,
        this_.DEF_CARD_TYPE_ID as DEF_CARD_TYPE_ID4_42_0_,
        this_.CHCK_ID as CHCK_ID5_42_0_,
        this_.CHECK_OPEN as CHECK_OPEN6_42_0_,
        this_.CHKNUM as CHKNUM7_42_0_,
        this_.COFIRMATION as COFIRMATION8_42_0_,
        this_.DOC_TYPE as DOC_TYPE9_42_0_,
        this_.GST as GST10_42_0_,
        this_.IMAGE as IMAGE11_42_0_,
        this_.INVOICE_ID as INVOICE_ID20_42_0_,
        this_.DEF_MAGSTRIPE as DEF_MAGSTRIPE12_42_0_,
        this_.OPERATOR as OPERATOR13_42_0_,
        this_.REGISTRATION_ID as REGISTRATION_ID21_42_0_,
        this_.RVC as RVC22_42_0_,
        this_.SP as SP14_42_0_,
        this_.TAX_EXEMPT as TAX_EXEMPT15_42_0_,
        this_.TM as TM16_42_0_,
        this_.TM_OPEN as TM_OPEN17_42_0_,
        this_.TTL as TTL18_42_0_,
        this_.VER as VER19_42_0_
    from
        club.DOCS this_
    where
        this_.RVC=?
        and this_.DEF_CARD_ID=?
        and this_.CHECK_OPEN=?
    order by
        this_.CHKNUM asc
Hibernate:
    select
        rvc0_.RVC_ID as RVC_ID1_97_0_,
        rvc0_.BUSSINES_DATE_START as BUSSINES_DATE_STAR2_97_0_,
        rvc0_.LAST_CHECK_NUM as LAST_CHECK_NUM3_97_0_,
        rvc0_.NAME as NAME4_97_0_,
        rvc0_.OPTIONS as OPTIONS5_97_0_,
        rvc0_.POS_RVC as POS_RVC6_97_0_,
        rvc0_.REG_RVC_GROUP_ID as REG_RVC_GROUP_ID11_97_0_,
        rvc0_.SALE_STORE_ID as SALE_STORE_ID12_97_0_,
        rvc0_.SITE_ID as SITE_ID13_97_0_,
        rvc0_.TIME_ZONE as TIME_ZONE14_97_0_,
        rvc0_.TREAT_STORE_ID as TREAT_STORE_ID15_97_0_,
        rvc0_.WEB_BOOK_ENABLE as WEB_BOOK_ENABLE7_97_0_,
        rvc0_.WEB_PAYM_DRIVER as WEB_PAYM_DRIVER8_97_0_,
        rvc0_.WEB_PAYM_KEY as WEB_PAYM_KEY9_97_0_,
        rvc0_.WEB_PAYM_URL as WEB_PAYM_URL10_97_0_,
        rvc0_.NAME || ' (' || rvc0_.RVC_ID || ')' as formula4_0_
    from
        club.RVC rvc0_
    where
        rvc0_.RVC_ID=?
15.08.16 17:05:33:495 - INFO - DocService - Doc Save 0
Hibernate:
    select
        club.DOCS_SEQUENCE.nextval
    from
        dual
15.08.16 17:05:33:495 - INFO - DocService - Doc Save Check doc.cofirmation=F ttl=0.0
15.08.16 17:05:33:495 - INFO - DocService - Doc Save Check updDoc=false and oldDocConfirmation=F
Hibernate:
    insert
    into
        club.DOCS
        (BUSSINES_DATE, DEF_CARD_ID, DEF_CARD_TYPE_ID, CHCK_ID, CHECK_OPEN, CHKNUM, COFIRMATION, DOC_TYPE, GST, IMAGE, INVOICE_ID, DEF_MAGSTRIPE, OPERATOR, REGISTRATION_ID, RVC, SP, TAX_EXEMPT, TM, TM_OPEN, TTL, VER, DOC_ID)
    values
        (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
    select
        employee0_.EMPL_ID as EMPL_ID1_48_,
        employee0_.ACTIVE as ACTIVE2_48_,
        employee0_.ALLOWED_RVC_GROUP_ID as ALLOWED_RVC_GROUP18_48_,
        employee0_.BOOKING_PRIORITY as BOOKING_PRIORITY3_48_,
        employee0_.CARD_ID as CARD_ID4_48_,
        employee0_.CURRENT_RVC_ID as CURRENT_RVC_ID19_48_,
        employee0_.EMAIL as EMAIL5_48_,
        employee0_.EXTERNAL as EXTERNAL6_48_,
        employee0_.GENDER as GENDER7_48_,
        employee0_.HIERARCHY_ID as HIERARCHY_ID20_48_,
        employee0_.INV_STORE_ID as INV_STORE_ID21_48_,
        employee0_.LOGON as LOGON8_48_,
        employee0_.MAGSTRIPE as MAGSTRIPE9_48_,
        employee0_.MANAGER_EMPL_ID as MANAGER_EMPL_ID22_48_,
        employee0_.NAME1 as NAME10_48_,
        employee0_.NAME2 as NAME11_48_,
        employee0_.PASSWORD as PASSWORD12_48_,
        employee0_.PASSWORD_CHANGE_TM as PASSWORD_CHANGE_T13_48_,
        employee0_.PHONE as PHONE14_48_,
        employee0_.PRIORITY as PRIORITY15_48_,
        employee0_.SALARY_CLASS_ID as SALARY_CLASS_ID23_48_,
        employee0_.TARGET_AMNT as TARGET_AMNT16_48_,
        employee0_.TARGET_CNT as TARGET_CNT17_48_,
        employee0_.ROLE_ID as ROLE_ID24_48_,
        employee0_.NAME2 || ' ' || employee0_.NAME1 as formula1_
    from
        club.EMPLOYEES employee0_
    where
        (
            employee0_.ACTIVE='T'
        )
        and(
            employee0_.ALLOWED_RVC_GROUP_ID in(
                select
                    rvcgroupli1_.RVC_GROUP_ID
                from
                    club.RVC_GROUP_LINK rvcgroupli1_
                where
                    (
                        rvcgroupli1_.RVC_ID=?
                    )
            )
        )
Hibernate:
    select
        menuprice0_.PRICE_ID as PRICE_ID1_80_,
        menuprice0_.ALLOWED_RVCS as ALLOWED_RVCS7_80_,
        menuprice0_.ALLOWED_TIME_PROFILE_ID as ALLOWED_TIME_PROFI8_80_,
        menuprice0_.MI_ID as MI_ID9_80_,
        menuprice0_.ORDR as ORDR2_80_,
        menuprice0_.PRICE as PRICE3_80_,
        menuprice0_.REDEEM_BONUS as REDEEM_BONUS4_80_,
        menuprice0_.VALID_FROM as VALID_FROM5_80_,
        menuprice0_.VALID_TILL as VALID_TILL6_80_
    from
        club.MENU_PRICE menuprice0_
    where
        (
            menuprice0_.MI_ID=?
        )
    order by
        menuprice0_.ORDR
Hibernate:
    select
        site0_.SITE_ID as SITE_ID1_107_0_,
        site0_.AUTOSTART as AUTOSTART2_107_0_,
        site0_.DB_SYNC as DB_SYNC3_107_0_,
        site0_.TP as TP4_107_0_,
        site0_.GI as GI5_107_0_,
        site0_.HTNG as HTNG6_107_0_,
        site0_.INQ_TM as INQ_TM7_107_0_,
        site0_.IP as IP8_107_0_,
        site0_.LOCATION as LOCATION9_107_0_,
        site0_.NAME as NAME10_107_0_,
        site0_.OPTIONS as OPTIONS11_107_0_,
        site0_.PMS_PROPERTY as PMS_PROPERTY12_107_0_,
        site0_.PORT as PORT13_107_0_,
        site0_.SITE_KEY as SITE_KEY14_107_0_,
        site0_.SVC_TAX_CLASS_ID as SVC_TAX_CLASS_ID16_107_0_,
        site0_.V8IFC as V15_107_0_
    from
        club.SITES site0_
    where
        site0_.SITE_ID=?
Hibernate:
    select
        menuitem0_.MI_ID as MI_ID1_77_,
        menuitem0_.ACTIVE as ACTIVE2_77_,
        menuitem0_.BARCODE as BARCODE3_77_,
        menuitem0_.BASE_INV_UNIT_ID as BASE_INV_UNIT_ID30_77_,
        menuitem0_.BOOK_STEP as BOOK_STEP4_77_,
        menuitem0_.CODE as CODE5_77_,
        menuitem0_.COLOR as COLOR6_77_,
        menuitem0_.COMMISSION_GRP_ID as COMMISSION_GRP_ID31_77_,
        menuitem0_.COMPLEXITY as COMPLEXITY7_77_,
        menuitem0_.COST as COST8_77_,
        menuitem0_.DESCRIPTION as DESCRIPTION9_77_,
        menuitem0_.DESCRIPTION_STRING_ID as DESCRIPTION_STRIN10_77_,
        menuitem0_.DISCOUNT_RULESET_ID as DISCOUNT_RULESET_32_77_,
        menuitem0_.EXTN_GROUP as EXTN_GROUP11_77_,
        menuitem0_.FGRP as FGRP33_77_,
        menuitem0_.FAVOURITES_ID as FAVOURITES_ID34_77_,
        menuitem0_.HIERARCHY_ID as HIERARCHY_ID35_77_,
        menuitem0_.INITIAL_STATUS as INITIAL_STATUS12_77_,
        menuitem0_.MAX_PARTICIPANT as MAX_PARTICIPANT13_77_,
        menuitem0_.MAX_PARTICIPANT_WEB as MAX_PARTICIPANT_W14_77_,
        menuitem0_.MI_TYPE as MI_TYPE15_77_,
        menuitem0_.NAME1 as NAME16_77_,
        menuitem0_.NAME2 as NAME17_77_,
        menuitem0_.NAME_STRING_ID as NAME_STRING_ID18_77_,
        menuitem0_.OPTIONS as OPTIONS19_77_,
        menuitem0_.PMS_CODE as PMS_CODE20_77_,
        menuitem0_.RETURN_CHARGE as RETURN_CHARGE21_77_,
        menuitem0_.RSRV_COUNT as RSRV_COUNT22_77_,
        menuitem0_.SI as SI36_77_,
        menuitem0_.SPA_CANCEL_CAT_ID as SPA_CANCEL_CAT_ID37_77_,
        menuitem0_.SUBSCR_ACTIVE_MI as SUBSCR_ACTIVE_MI23_77_,
        menuitem0_.SUBSCR_FROZEN_MI as SUBSCR_FROZEN_MI24_77_,
        menuitem0_.SUBSCR_PERIOD_COUNT as SUBSCR_PERIOD_COU25_77_,
        menuitem0_.SUBSCR_PERIOD_TYPE as SUBSCR_PERIOD_TYP26_77_,
        menuitem0_.TAX_CLASS as TAX_CLASS38_77_,
        menuitem0_.TREAT_CLEANOUT_TIME as TREAT_CLEANOUT_TI27_77_,
        menuitem0_.TREAT_DURATION as TREAT_DURATION28_77_,
        menuitem0_.TREAT_PREP_TIME as TREAT_PREP_TIME29_77_,
        menuitem0_.VOUCHER_CAMPAIGN_ID as VOUCHER_CAMPAIGN_39_77_,
        menuitem0_.WEBGRP as WEBGRP40_77_,
        UPPER(menuitem0_.CODE || ' ' || menuitem0_.NAME1) as formula2_,
        UPPER(menuitem0_.NAME1 || ' (' || menuitem0_.CODE || ')' ) as formula3_
    from
        club.MENU_ITEMS menuitem0_
    where
        (
            menuitem0_.CODE=?
        )
Hibernate:
    select
        menusi0_.SI_ID as SI_ID1_81_0_,
        menusi0_.DEP_CODE as DEP_CODE2_81_0_,
        menusi0_.NAME as NAME3_81_0_
    from
        club.MENU_SI menusi0_
    where
        menusi0_.SI_ID=?
Hibernate:
    select
        menufgrp0_.FGRP_ID as FGRP_ID1_76_0_,
        menufgrp0_.NAME as NAME2_76_0_
    from
        club.MENU_FGRP menufgrp0_
    where
        menufgrp0_.FGRP_ID=?
15.08.16 17:05:39:104 - INFO - AcquireLoyaltyHelper - ********************* AcquireLoyalty *********************
15.08.16 17:05:39:105 - INFO - AcquireLoyaltyHelper - Calc only: null
15.08.16 17:05:39:105 - INFO - AcquireLoyaltyHelper - Rev center: 1001:101, identification: CID:1260, voucher: null
15.08.16 17:05:39:105 - INFO - AcquireLoyaltyHelper - Void flag: false
Hibernate:
    select
        this_.CARD_ID as CARD_ID1_20_0_,
        this_.IS_ARCHIVED as IS_ARCHIVED2_20_0_,
        this_.BIRTH_DATE as BIRTH_DATE3_20_0_,
        this_.CARD_STATUS_ID as CARD_STATUS_ID78_20_0_,
        this_.CARD_TYPE_ID as CARD_TYPE_ID79_20_0_,
        this_.CELL_PHONE as CELL_PHONE4_20_0_,
        this_.CITY as CITY5_20_0_,
        this_.COMPANY as COMPANY6_20_0_,
        this_.COUNTRY as COUNTRY7_20_0_,
        this_.CREATED_DATE as CREATED_DATE8_20_0_,
        this_.CREATED_PERSON as CREATED_PERSON9_20_0_,
        this_.EMAIL as EMAIL10_20_0_,
        this_.FIRST_NAME as FIRST_NAME11_20_0_,
        this_.GENDER as GENDER12_20_0_,
        this_.GREETING as GREETING13_20_0_,
        this_.HEALTH_INFO as HEALTH_INFO14_20_0_,
        this_.JOB_TITLE as JOB_TITLE15_20_0_,
        this_.LANG as LANG16_20_0_,
        this_.LAST_NAME as LAST_NAME17_20_0_,
        this_.LAST_USED_RVC_ID as LAST_USED_RVC_ID18_20_0_,
        this_.MAGSTRIPE as MAGSTRIPE19_20_0_,
        this_.MAILING_OPT as MAILING_OPT20_20_0_,
        this_.MASTER_CARD_ID as MASTER_CARD_ID80_20_0_,
        this_.MAX_CHILDREN as MAX_CHILDREN21_20_0_,
        this_.MLST_SYNC_STATUS as MLST_SYNC_STATUS22_20_0_,
        this_.NOTES as NOTES23_20_0_,
        this_.PASSPORT as PASSPORT24_20_0_,
        this_.PASSWORD as PASSWORD25_20_0_,
        this_.PHONE as PHONE26_20_0_,
        this_.PROFILE_TYPE as PROFILE_TYPE27_20_0_,
        this_.RATE as RATE28_20_0_,
        this_.SECOND_NAME as SECOND_NAME29_20_0_,
        this_.SOURCE as SOURCE30_20_0_,
        this_.STREET_ADDRESS as STREET_ADDRESS31_20_0_,
        this_.TITLE as TITLE32_20_0_,
        this_.UDFD1 as UDFD33_20_0_,
        this_.UDFD10 as UDFD34_20_0_,
        this_.UDFD2 as UDFD35_20_0_,
        this_.UDFD3 as UDFD36_20_0_,
        this_.UDFD4 as UDFD37_20_0_,
        this_.UDFD5 as UDFD38_20_0_,
        this_.UDFD6 as UDFD39_20_0_,
        this_.UDFD7 as UDFD40_20_0_,
        this_.UDFD8 as UDFD41_20_0_,
        this_.UDFD9 as UDFD42_20_0_,
        this_.UDFN1 as UDFN43_20_0_,
        this_.UDFN10 as UDFN44_20_0_,
        this_.UDFN2 as UDFN45_20_0_,
        this_.UDFN3 as UDFN46_20_0_,
        this_.UDFN4 as UDFN47_20_0_,
        this_.UDFN5 as UDFN48_20_0_,
        this_.UDFN6 as UDFN49_20_0_,
        this_.UDFN7 as UDFN50_20_0_,
        this_.UDFN8 as UDFN51_20_0_,
        this_.UDFN9 as UDFN52_20_0_,
        this_.UDFS1 as UDFS53_20_0_,
        this_.UDFS10 as UDFS54_20_0_,
        this_.UDFS11 as UDFS55_20_0_,
        this_.UDFS12 as UDFS56_20_0_,
        this_.UDFS13 as UDFS57_20_0_,
        this_.UDFS14 as UDFS58_20_0_,
        this_.UDFS15 as UDFS59_20_0_,
        this_.UDFS16 as UDFS60_20_0_,
        this_.UDFS17 as UDFS61_20_0_,
        this_.UDFS18 as UDFS62_20_0_,
        this_.UDFS19 as UDFS63_20_0_,
        this_.UDFS2 as UDFS64_20_0_,
        this_.UDFS20 as UDFS65_20_0_,
        this_.UDFS3 as UDFS66_20_0_,
        this_.UDFS4 as UDFS67_20_0_,
        this_.UDFS5 as UDFS68_20_0_,
        this_.UDFS6 as UDFS69_20_0_,
        this_.UDFS7 as UDFS70_20_0_,
        this_.UDFS8 as UDFS71_20_0_,
        this_.UDFS9 as UDFS72_20_0_,
        this_.UPDATE_DATE as UPDATE_DATE73_20_0_,
        this_.UPDATE_PERSON as UPDATE_PERSON74_20_0_,
        this_.VALID_TILL as VALID_TILL75_20_0_,
        this_.VIP_STATUS as VIP_STATUS76_20_0_,
        this_.ZIP_CODE as ZIP_CODE77_20_0_
    from
        club.CARDS this_
    where
        this_.CARD_ID=?
Hibernate:
    select
        cardtype0_.CARD_TYPE_ID as CARD_TYPE_ID1_26_0_,
        cardtype0_.DEFAULT_ACCOUNT_DEF_ID as DEFAULT_ACCOUNT_D12_26_0_,
        cardtype0_.ACTIVE as ACTIVE2_26_0_,
        cardtype0_.DEFAULT_MASK as DEFAULT_MASK3_26_0_,
        cardtype0_.DEFAULT_VALIDITY_PERIOD as DEFAULT_VALIDITY_P4_26_0_,
        cardtype0_.FACILITY_ACCESS_RULESET as FACILITY_ACCESS_R13_26_0_,
        cardtype0_.MENU_LEVEL as MENU_LEVEL5_26_0_,
        cardtype0_.OPTIONS as OPTIONS6_26_0_,
        cardtype0_.PMS_LEVEL as PMS_LEVEL7_26_0_,
        cardtype0_.PMS_TYPE as PMS_TYPE8_26_0_,
        cardtype0_.RANGE_START as RANGE_START9_26_0_,
        cardtype0_.TRACK1FORMAT as TRACK10_26_0_,
        cardtype0_.TYPE_NAME as TYPE_NAME11_26_0_
    from
        club.CARD_TYPES cardtype0_
    where
        cardtype0_.CARD_TYPE_ID=?
Hibernate:
    select
        cardstatus0_.ID as ID1_25_0_,
        cardstatus0_.ACTIVED as ACTIVED2_25_0_,
        cardstatus0_.DESCRIPTION as DESCRIPTION3_25_0_
    from
        club.CARD_STATUS cardstatus0_
    where
        cardstatus0_.ID=?
15.08.16 17:05:39:117 - INFO - AcquireLoyaltyHelper - For: 1260 Герасименко Александр [Гость, Активна]
Hibernate:
    select
        site0_.SITE_ID as SITE_ID1_107_,
        site0_.AUTOSTART as AUTOSTART2_107_,
        site0_.DB_SYNC as DB_SYNC3_107_,
        site0_.TP as TP4_107_,
        site0_.GI as GI5_107_,
        site0_.HTNG as HTNG6_107_,
        site0_.INQ_TM as INQ_TM7_107_,
        site0_.IP as IP8_107_,
        site0_.LOCATION as LOCATION9_107_,
        site0_.NAME as NAME10_107_,
        site0_.OPTIONS as OPTIONS11_107_,
        site0_.PMS_PROPERTY as PMS_PROPERTY12_107_,
        site0_.PORT as PORT13_107_,
        site0_.SITE_KEY as SITE_KEY14_107_,
        site0_.SVC_TAX_CLASS_ID as SVC_TAX_CLASS_ID16_107_,
        site0_.V8IFC as V15_107_
    from
        club.SITES site0_
    where
        (
            upper(site0_.SITE_KEY)=?
        )
Hibernate:
    select
        rvc0_.RVC_ID as RVC_ID1_97_,
        rvc0_.BUSSINES_DATE_START as BUSSINES_DATE_STAR2_97_,
        rvc0_.LAST_CHECK_NUM as LAST_CHECK_NUM3_97_,
        rvc0_.NAME as NAME4_97_,
        rvc0_.OPTIONS as OPTIONS5_97_,
        rvc0_.POS_RVC as POS_RVC6_97_,
        rvc0_.REG_RVC_GROUP_ID as REG_RVC_GROUP_ID11_97_,
        rvc0_.SALE_STORE_ID as SALE_STORE_ID12_97_,
        rvc0_.SITE_ID as SITE_ID13_97_,
        rvc0_.TIME_ZONE as TIME_ZONE14_97_,
        rvc0_.TREAT_STORE_ID as TREAT_STORE_ID15_97_,
        rvc0_.WEB_BOOK_ENABLE as WEB_BOOK_ENABLE7_97_,
        rvc0_.WEB_PAYM_DRIVER as WEB_PAYM_DRIVER8_97_,
        rvc0_.WEB_PAYM_KEY as WEB_PAYM_KEY9_97_,
        rvc0_.WEB_PAYM_URL as WEB_PAYM_URL10_97_,
        rvc0_.NAME || ' (' || rvc0_.RVC_ID || ')' as formula4_
    from
        club.RVC rvc0_
    where
        (
            rvc0_.POS_RVC=?
        )
        and(
            rvc0_.SITE_ID=?
        )
Hibernate:
    select
        timezone0_.ID as ID1_131_0_,
        timezone0_.NAME as NAME2_131_0_
    from
        club.TIME_ZONE timezone0_
    where
        timezone0_.ID=?
15.08.16 17:05:39:125 - INFO - AcquireLoyaltyHelper - Current time: Mon Aug 15 17:05:39 GST 2016
15.08.16 17:05:39:128 - INFO - AcquireLoyaltyHelper - Bussines time: Mon Aug 15 00:00:00 GST 2016
15.08.16 17:05:39:128 - INFO - AcquireLoyaltyHelper - postingGUID: 4694
Hibernate:
    select
        doc0_.DOC_ID as DOC_ID1_42_0_,
        doc0_.BUSSINES_DATE as BUSSINES_DATE2_42_0_,
        doc0_.DEF_CARD_ID as DEF_CARD_ID3_42_0_,
        doc0_.DEF_CARD_TYPE_ID as DEF_CARD_TYPE_ID4_42_0_,
        doc0_.CHCK_ID as CHCK_ID5_42_0_,
        doc0_.CHECK_OPEN as CHECK_OPEN6_42_0_,
        doc0_.CHKNUM as CHKNUM7_42_0_,
        doc0_.COFIRMATION as COFIRMATION8_42_0_,
        doc0_.DOC_TYPE as DOC_TYPE9_42_0_,
        doc0_.GST as GST10_42_0_,
        doc0_.IMAGE as IMAGE11_42_0_,
        doc0_.INVOICE_ID as INVOICE_ID20_42_0_,
        doc0_.DEF_MAGSTRIPE as DEF_MAGSTRIPE12_42_0_,
        doc0_.OPERATOR as OPERATOR13_42_0_,
        doc0_.REGISTRATION_ID as REGISTRATION_ID21_42_0_,
        doc0_.RVC as RVC22_42_0_,
        doc0_.SP as SP14_42_0_,
        doc0_.TAX_EXEMPT as TAX_EXEMPT15_42_0_,
        doc0_.TM as TM16_42_0_,
        doc0_.TM_OPEN as TM_OPEN17_42_0_,
        doc0_.TTL as TTL18_42_0_,
        doc0_.VER as VER19_42_0_
    from
        club.DOCS doc0_
    where
        doc0_.DOC_ID=?
Hibernate:
    DELETE
    FROM
        DSC_HISTORY
    WHERE
        DOC_ID=?
Hibernate:
    select
        accounting0_.DOC_ID as DOC_ID7_0_,
        accounting0_.SEQ as SEQ1_0_,
        accounting0_.ACCOUNT_DEF_ID as ACCOUNT_DEF_ID8_0_,
        accounting0_.AMOUNT as AMOUNT2_0_,
        accounting0_.CARD_ID as CARD_ID9_0_,
        accounting0_.EXPIRY_DATE as EXPIRY_DATE3_0_,
        accounting0_.IMMED as IMMED4_0_,
        accounting0_.LOAN_FLAG as LOAN_FLAG5_0_,
        accounting0_.TAG as TAG6_0_
    from
        club.ACCOUNTING accounting0_
    where
        (
            accounting0_.DOC_ID=?
        )
Hibernate:
    DELETE
    FROM
        DOCS_PAYM dp
    WHERE
        dp.DOC_ID=?
Hibernate:
    DELETE
    FROM
        ITEM_ACCOUNTING
    WHERE
        DOC_ID=?
Hibernate:
    DELETE
    FROM
        SA_SCHEDULER
    WHERE
        SUBSCRIPTION_ACCOUNTING_ID IN (
            SELECT
                SUBSCRIPTION_ACCOUNTING_ID
            FROM
                SUBSCRIPTION_ACCOUNTING
            WHERE
                DOC_ID=?
        )
Hibernate:
    DELETE
    FROM
        SA_HISTORY
    WHERE
        SUBSCRIPTION_ACCOUNTING_ID IN (
            SELECT
                SUBSCRIPTION_ACCOUNTING_ID
            FROM
                SUBSCRIPTION_ACCOUNTING
            WHERE
                DOC_ID=?
        )
Hibernate:
    DELETE
    FROM
        SUBSCRIPTION_ACCOUNTING
    WHERE
        DOC_ID=?
Hibernate:
    select
        MAX(accounting0_.SEQ) as col_0_0_
    from
        club.ACCOUNTING accounting0_
    where
        (
            accounting0_.DOC_ID=?
        )
15.08.16 17:05:39:144 - INFO - AcquireLoyaltyHelper - 	MenuItemDecorator{100248|Аллергопанель 20 аллергенов|1|57.0|1|1, discount=0.0, totalDiscount=0.0, points=0.0}
15.08.16 17:05:39:145 - INFO - SubscriptionRedeemHelper - !!! SubscriptionRedeemHelper !!!
15.08.16 17:05:39:145 - INFO - SubscriptionRedeemHelper - !!! SubscriptionRedeemHelper items count:0
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        subscripti0_.SUBSCRIPTION_ACCOUNTING_ID as SUBSCRIPTION_ACCOU1_112_,
        subscripti0_.CANCELLATION_REASON as CANCELLATION_REASO2_112_,
        subscripti0_.CARD_ID as CARD_ID16_112_,
        subscripti0_.DOC_ID as DOC_ID17_112_,
        subscripti0_.DSC_RULESET_ID as DSC_RULESET_ID18_112_,
        subscripti0_.DSC_VALID_TILL as DSC_VALID_TILL3_112_,
        subscripti0_.EMPL_ID as EMPL_ID4_112_,
        subscripti0_.EXPIRATION_DATE as EXPIRATION_DATE5_112_,
        subscripti0_.EXTN_FLAG as EXTN_FLAG6_112_,
        subscripti0_.IS_MEMBERSHIP as IS_MEMBERSHIP7_112_,
        subscripti0_.ISSUE_DATE as ISSUE_DATE8_112_,
        subscripti0_.MMSHP_END_DATE as MMSHP_END_DATE9_112_,
        subscripti0_.MMSHP_START_DATE as MMSHP_START_DATE10_112_,
        subscripti0_.NOTE as NOTE11_112_,
        subscripti0_.PRICE as PRICE12_112_,
        subscripti0_.REF_NUM as REF_NUM13_112_,
        subscripti0_.STATUS as STATUS14_112_,
        subscripti0_.SUBSCRIPTION_MI_ID as SUBSCRIPTION_MI_I19_112_,
        subscripti0_.VALUE_TTL as VALUE_TTL15_112_
    from
        club.SUBSCRIPTION_ACCOUNTING subscripti0_
    where
        (
            subscripti0_.STATUS in(
                2 , 3
            )
        )
        AND(
            subscripti0_.CARD_ID=?
        )
        AND(
            subscripti0_.IS_MEMBERSHIP='1'
        )
Hibernate:
    select
        itembalanc0_.CARD_ID as CARD_ID6_69_,
        itembalanc0_.SUBSCRIPTION_ACCOUNTING_ID as SUBSCRIPTION_ACCOU7_69_,
        itembalanc0_.SUBSCRIPTION_ITEM_ID as SUBSCRIPTION_ITEM_8_69_,
        itembalanc0_.COST as COST1_69_,
        itembalanc0_.COUNT as COUNT2_69_,
        itembalanc0_.INIT_COUNT as INIT_COUNT3_69_,
        itembalanc0_.VALID_TILL as VALID_TILL4_69_,
        itembalanc0_.VALUE_TTL as VALUE_TTL5_69_
    from
        club.ITEM_BALANCE itembalanc0_,
        club.SUBSCRIPTION_ACCOUNTING subscripti1_
    where
        (
            itembalanc0_.CARD_ID=?
        )
        AND(
            (
                subscripti1_.STATUS IN(
                    2 , 3
                )
                and itembalanc0_.SUBSCRIPTION_ACCOUNTING_ID=subscripti1_.SUBSCRIPTION_ACCOUNTING_ID
            )
            or(
                (
                    subscripti1_.STATUS=1
                    and itembalanc0_.SUBSCRIPTION_ACCOUNTING_ID=subscripti1_.SUBSCRIPTION_ACCOUNTING_ID
                )
            )
        )
15.08.16 17:05:39:150 - INFO - ItemBalanceService - Load Enabled Subscriptions By Card. Found: 0rec.
Hibernate:
    select
        subscripti0_.SUBSCRIPTION_ACCOUNTING_ID as SUBSCRIPTION_ACCOU1_112_,
        subscripti0_.CANCELLATION_REASON as CANCELLATION_REASO2_112_,
        subscripti0_.CARD_ID as CARD_ID16_112_,
        subscripti0_.DOC_ID as DOC_ID17_112_,
        subscripti0_.DSC_RULESET_ID as DSC_RULESET_ID18_112_,
        subscripti0_.DSC_VALID_TILL as DSC_VALID_TILL3_112_,
        subscripti0_.EMPL_ID as EMPL_ID4_112_,
        subscripti0_.EXPIRATION_DATE as EXPIRATION_DATE5_112_,
        subscripti0_.EXTN_FLAG as EXTN_FLAG6_112_,
        subscripti0_.IS_MEMBERSHIP as IS_MEMBERSHIP7_112_,
        subscripti0_.ISSUE_DATE as ISSUE_DATE8_112_,
        subscripti0_.MMSHP_END_DATE as MMSHP_END_DATE9_112_,
        subscripti0_.MMSHP_START_DATE as MMSHP_START_DATE10_112_,
        subscripti0_.NOTE as NOTE11_112_,
        subscripti0_.PRICE as PRICE12_112_,
        subscripti0_.REF_NUM as REF_NUM13_112_,
        subscripti0_.STATUS as STATUS14_112_,
        subscripti0_.SUBSCRIPTION_MI_ID as SUBSCRIPTION_MI_I19_112_,
        subscripti0_.VALUE_TTL as VALUE_TTL15_112_
    from
        club.SUBSCRIPTION_ACCOUNTING subscripti0_
    where
        (
            subscripti0_.STATUS in(
                2 , 3
            )
        )
        AND(
            subscripti0_.CARD_ID=?
        )
        AND(
            subscripti0_.IS_MEMBERSHIP='1'
        )
Hibernate:
    select
        itembalanc0_.CARD_ID as CARD_ID6_69_,
        itembalanc0_.SUBSCRIPTION_ACCOUNTING_ID as SUBSCRIPTION_ACCOU7_69_,
        itembalanc0_.SUBSCRIPTION_ITEM_ID as SUBSCRIPTION_ITEM_8_69_,
        itembalanc0_.COST as COST1_69_,
        itembalanc0_.COUNT as COUNT2_69_,
        itembalanc0_.INIT_COUNT as INIT_COUNT3_69_,
        itembalanc0_.VALID_TILL as VALID_TILL4_69_,
        itembalanc0_.VALUE_TTL as VALUE_TTL5_69_
    from
        club.ITEM_BALANCE itembalanc0_,
        club.SUBSCRIPTION_ACCOUNTING subscripti2_
    where
        (
            itembalanc0_.CARD_ID in(
                select
                    card1_.MASTER_CARD_ID
                from
                    club.CARDS card1_
                where
                    (
                        card1_.CARD_ID=?
                    )
            )
        )
        AND(
            (
                subscripti2_.STATUS IN(
                    2 , 3
                )
                and itembalanc0_.SUBSCRIPTION_ACCOUNTING_ID=subscripti2_.SUBSCRIPTION_ACCOUNTING_ID
            )
            OR(
                (
                    subscripti2_.STATUS=1
                    and itembalanc0_.SUBSCRIPTION_ACCOUNTING_ID=subscripti2_.SUBSCRIPTION_ACCOUNTING_ID
                )
            )
        )
15.08.16 17:05:39:157 - INFO - ItemBalanceService - Load Enabled Subscriptions By Master Card. Found: 0rec.
15.08.16 17:05:39:158 - INFO - ItemBalanceService - loadEnabledByCard return: 0rec.
15.08.16 17:05:39:158 - INFO - DiscountRulesHelper - *** DiscountRulesHelper ***
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        subscripti0_.SUBSCRIPTION_ACCOUNTING_ID as SUBSCRIPTION_ACCOU1_112_,
        subscripti0_.CANCELLATION_REASON as CANCELLATION_REASO2_112_,
        subscripti0_.CARD_ID as CARD_ID16_112_,
        subscripti0_.DOC_ID as DOC_ID17_112_,
        subscripti0_.DSC_RULESET_ID as DSC_RULESET_ID18_112_,
        subscripti0_.DSC_VALID_TILL as DSC_VALID_TILL3_112_,
        subscripti0_.EMPL_ID as EMPL_ID4_112_,
        subscripti0_.EXPIRATION_DATE as EXPIRATION_DATE5_112_,
        subscripti0_.EXTN_FLAG as EXTN_FLAG6_112_,
        subscripti0_.IS_MEMBERSHIP as IS_MEMBERSHIP7_112_,
        subscripti0_.ISSUE_DATE as ISSUE_DATE8_112_,
        subscripti0_.MMSHP_END_DATE as MMSHP_END_DATE9_112_,
        subscripti0_.MMSHP_START_DATE as MMSHP_START_DATE10_112_,
        subscripti0_.NOTE as NOTE11_112_,
        subscripti0_.PRICE as PRICE12_112_,
        subscripti0_.REF_NUM as REF_NUM13_112_,
        subscripti0_.STATUS as STATUS14_112_,
        subscripti0_.SUBSCRIPTION_MI_ID as SUBSCRIPTION_MI_I19_112_,
        subscripti0_.VALUE_TTL as VALUE_TTL15_112_
    from
        club.SUBSCRIPTION_ACCOUNTING subscripti0_
    where
        (
            subscripti0_.CARD_ID=?
        )
        AND(
            subscripti0_.STATUS=?
        )
Hibernate:
    select
        links0_.CARD_TYPE_ID as CARD_TYPE_ID2_26_0_,
        links0_.ID as ID1_28_0_,
        links0_.ID as ID1_28_1_,
        links0_.CARD_TYPE_ID as CARD_TYPE_ID2_28_1_,
        links0_.RULESET_ID as RULESET_ID3_28_1_,
        ruleset1_.RULESET_ID as RULESET_ID1_94_2_,
        ruleset1_.BONUS_ACCOUNT_DEF_ID as BONUS_ACCOUNT_DEF12_94_2_,
        ruleset1_.BONUS_ACTIVATION_DELAY as BONUS_ACTIVATION_D2_94_2_,
        ruleset1_.LIMIT_AMOUNT as LIMIT_AMOUNT3_94_2_,
        ruleset1_.LIMIT_COUNT as LIMIT_COUNT4_94_2_,
        ruleset1_.LIMIT_PERIOD as LIMIT_PERIOD5_94_2_,
        ruleset1_.LIMIT_PERIOD_COUNT as LIMIT_PERIOD_COUNT6_94_2_,
        ruleset1_.NAME as NAME7_94_2_,
        ruleset1_.OPTIONS as OPTIONS8_94_2_,
        ruleset1_.RULESET_CODE as RULESET_CODE9_94_2_,
        ruleset1_.TYPE as TYPE10_94_2_,
        ruleset1_.WEIGHT as WEIGHT11_94_2_,
        accountdef2_.ACCOUNT_DEF_ID as ACCOUNT_DEF_ID1_2_3_,
        accountdef2_.ACCOUNT_CODE as ACCOUNT_CODE2_2_3_,
        accountdef2_.ACCOUNT_TYPE as ACCOUNT_TYPE3_2_3_,
        accountdef2_.AUTO_RENEW as AUTO_RENEW4_2_3_,
        accountdef2_.TASK_TYPE_ID as TASK_TYPE_ID10_2_3_,
        accountdef2_.CURRENCY_ID as CURRENCY_ID11_2_3_,
        accountdef2_.EXPIRATION as EXPIRATION5_2_3_,
        accountdef2_.NAME as NAME6_2_3_,
        accountdef2_.ORDR as ORDR7_2_3_,
        accountdef2_.POINTS_RATE as POINTS_RATE8_2_3_,
        accountdef2_.POINTS_ROUNDING as POINTS_ROUNDING9_2_3_,
        accountdef2_.RULESET_ID as RULESET_ID12_2_3_,
        accountdef2_.ACCOUNT_CODE || ' ' || accountdef2_.NAME as formula0_3_
    from
        club.CARD_TYPES_RULESET_LINK links0_
    inner join
        club.RULESETS ruleset1_
            on links0_.RULESET_ID=ruleset1_.RULESET_ID
    left outer join
        club.ACCOUNT_DEF accountdef2_
            on ruleset1_.BONUS_ACCOUNT_DEF_ID=accountdef2_.ACCOUNT_DEF_ID
    where
        links0_.CARD_TYPE_ID=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
15.08.16 17:05:39:170 - INFO - DiscountRulesHelper - *** total discount 0.0
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
15.08.16 17:05:39:172 - INFO - BonusRulesHelper - BONUS_CONSIDER_DSC=true
Hibernate:
    select
        rulesetdtl0_.RULESET_ID as RULESET_ID21_94_0_,
        rulesetdtl0_.RULE_ID as RULE_ID1_95_0_,
        rulesetdtl0_.RULE_ID as RULE_ID1_95_1_,
        rulesetdtl0_.ACTION as ACTION2_95_1_,
        rulesetdtl0_.ACTIVE as ACTIVE3_95_1_,
        rulesetdtl0_.CHKTOTAL as CHKTOTAL4_95_1_,
        rulesetdtl0_.COUNTER as COUNTER5_95_1_,
        rulesetdtl0_.FGRP as FGRP6_95_1_,
        rulesetdtl0_.GST as GST7_95_1_,
        rulesetdtl0_.IDX as IDX8_95_1_,
        rulesetdtl0_.LIMIT_AMOUNT as LIMIT_AMOUNT9_95_1_,
        rulesetdtl0_.LIMIT_COUNT as LIMIT_COUNT10_95_1_,
        rulesetdtl0_.LIMIT_PERIOD as LIMIT_PERIOD11_95_1_,
        rulesetdtl0_.LIMIT_PERIOD_COUNT as LIMIT_PERIOD_COUN12_95_1_,
        rulesetdtl0_.MIID as MIID13_95_1_,
        rulesetdtl0_.NAME as NAME14_95_1_,
        rulesetdtl0_.OPTIONS as OPTIONS15_95_1_,
        rulesetdtl0_.RES_AMOUNT as RES_AMOUNT16_95_1_,
        rulesetdtl0_.RES_BASE as RES_BASE17_95_1_,
        rulesetdtl0_.RES_PRCNT as RES_PRCNT18_95_1_,
        rulesetdtl0_.RULESET_ID as RULESET_ID21_95_1_,
        rulesetdtl0_.RVCLIST as RVCLIST22_95_1_,
        rulesetdtl0_.SERV_PERIOD as SERV_PERIOD19_95_1_,
        rulesetdtl0_.SI as SI20_95_1_,
        rulesetdtl0_.TIMEPROFILE_ID as TIMEPROFILE_ID23_95_1_,
        rvcgroup1_.RVC_GROUP_ID as RVC_GROUP_ID1_98_2_,
        rvcgroup1_.NAME as NAME2_98_2_,
        timeprofil2_.TIME_PROFILE_ID as TIME_PROFILE_ID1_129_3_,
        timeprofil2_.NAME as NAME2_129_3_,
        timeprofil2_.TIME_PROFILE_CODE as TIME_PROFILE_CODE3_129_3_
    from
        club.RULESETS_DTL rulesetdtl0_
    left outer join
        club.RVC_GROUP rvcgroup1_
            on rulesetdtl0_.RVCLIST=rvcgroup1_.RVC_GROUP_ID
    left outer join
        club.TIME_PROFILES timeprofil2_
            on rulesetdtl0_.TIMEPROFILE_ID=timeprofil2_.TIME_PROFILE_ID
    where
        rulesetdtl0_.RULESET_ID=?
Hibernate:
    select
        rulesetper0_.ID as ID1_96_,
        rulesetper0_.AMOUNT as AMOUNT2_96_,
        rulesetper0_.CARD_ID as CARD_ID4_96_,
        rulesetper0_.DOC_ID as DOC_ID5_96_,
        rulesetper0_.RULE_ID as RULE_ID3_96_,
        rulesetper0_.RULESET_ID as RULESET_ID6_96_
    from
        club.RULESET_PERIOD_ACC rulesetper0_,
        club.DOCS doc1_
    where
        (
            rulesetper0_.CARD_ID=?
        )
        AND(
            rulesetper0_.RULESET_ID=?
        )
        AND(
            doc1_.COFIRMATION='T'
            and rulesetper0_.DOC_ID=doc1_.DOC_ID
        )
Hibernate:
    select
        rulesetper0_.ID as ID1_96_,
        rulesetper0_.AMOUNT as AMOUNT2_96_,
        rulesetper0_.CARD_ID as CARD_ID4_96_,
        rulesetper0_.DOC_ID as DOC_ID5_96_,
        rulesetper0_.RULE_ID as RULE_ID3_96_,
        rulesetper0_.RULESET_ID as RULESET_ID6_96_
    from
        club.RULESET_PERIOD_ACC rulesetper0_,
        club.DOCS doc1_
    where
        (
            rulesetper0_.CARD_ID=?
        )
        AND(
            rulesetper0_.RULESET_ID=?
        )
        AND(
            doc1_.COFIRMATION='T'
            and rulesetper0_.DOC_ID=doc1_.DOC_ID
        )
15.08.16 17:05:39:177 - INFO - RuleBase - Ruleset added: Stat
Hibernate:
    select
        accounting_.DOC_ID,
        accounting_.SEQ,
        accounting_.ACCOUNT_DEF_ID as ACCOUNT_DEF_ID8_0_,
        accounting_.AMOUNT as AMOUNT2_0_,
        accounting_.CARD_ID as CARD_ID9_0_,
        accounting_.EXPIRY_DATE as EXPIRY_DATE3_0_,
        accounting_.IMMED as IMMED4_0_,
        accounting_.LOAN_FLAG as LOAN_FLAG5_0_,
        accounting_.TAG as TAG6_0_
    from
        club.ACCOUNTING accounting_
    where
        accounting_.DOC_ID=?
        and accounting_.SEQ=?
Hibernate:
    select
        menuitem0_.MI_ID as MI_ID1_77_,
        menuitem0_.ACTIVE as ACTIVE2_77_,
        menuitem0_.BARCODE as BARCODE3_77_,
        menuitem0_.BASE_INV_UNIT_ID as BASE_INV_UNIT_ID30_77_,
        menuitem0_.BOOK_STEP as BOOK_STEP4_77_,
        menuitem0_.CODE as CODE5_77_,
        menuitem0_.COLOR as COLOR6_77_,
        menuitem0_.COMMISSION_GRP_ID as COMMISSION_GRP_ID31_77_,
        menuitem0_.COMPLEXITY as COMPLEXITY7_77_,
        menuitem0_.COST as COST8_77_,
        menuitem0_.DESCRIPTION as DESCRIPTION9_77_,
        menuitem0_.DESCRIPTION_STRING_ID as DESCRIPTION_STRIN10_77_,
        menuitem0_.DISCOUNT_RULESET_ID as DISCOUNT_RULESET_32_77_,
        menuitem0_.EXTN_GROUP as EXTN_GROUP11_77_,
        menuitem0_.FGRP as FGRP33_77_,
        menuitem0_.FAVOURITES_ID as FAVOURITES_ID34_77_,
        menuitem0_.HIERARCHY_ID as HIERARCHY_ID35_77_,
        menuitem0_.INITIAL_STATUS as INITIAL_STATUS12_77_,
        menuitem0_.MAX_PARTICIPANT as MAX_PARTICIPANT13_77_,
        menuitem0_.MAX_PARTICIPANT_WEB as MAX_PARTICIPANT_W14_77_,
        menuitem0_.MI_TYPE as MI_TYPE15_77_,
        menuitem0_.NAME1 as NAME16_77_,
        menuitem0_.NAME2 as NAME17_77_,
        menuitem0_.NAME_STRING_ID as NAME_STRING_ID18_77_,
        menuitem0_.OPTIONS as OPTIONS19_77_,
        menuitem0_.PMS_CODE as PMS_CODE20_77_,
        menuitem0_.RETURN_CHARGE as RETURN_CHARGE21_77_,
        menuitem0_.RSRV_COUNT as RSRV_COUNT22_77_,
        menuitem0_.SI as SI36_77_,
        menuitem0_.SPA_CANCEL_CAT_ID as SPA_CANCEL_CAT_ID37_77_,
        menuitem0_.SUBSCR_ACTIVE_MI as SUBSCR_ACTIVE_MI23_77_,
        menuitem0_.SUBSCR_FROZEN_MI as SUBSCR_FROZEN_MI24_77_,
        menuitem0_.SUBSCR_PERIOD_COUNT as SUBSCR_PERIOD_COU25_77_,
        menuitem0_.SUBSCR_PERIOD_TYPE as SUBSCR_PERIOD_TYP26_77_,
        menuitem0_.TAX_CLASS as TAX_CLASS38_77_,
        menuitem0_.TREAT_CLEANOUT_TIME as TREAT_CLEANOUT_TI27_77_,
        menuitem0_.TREAT_DURATION as TREAT_DURATION28_77_,
        menuitem0_.TREAT_PREP_TIME as TREAT_PREP_TIME29_77_,
        menuitem0_.VOUCHER_CAMPAIGN_ID as VOUCHER_CAMPAIGN_39_77_,
        menuitem0_.WEBGRP as WEBGRP40_77_,
        UPPER(menuitem0_.CODE || ' ' || menuitem0_.NAME1) as formula2_,
        UPPER(menuitem0_.NAME1 || ' (' || menuitem0_.CODE || ')' ) as formula3_
    from
        club.MENU_ITEMS menuitem0_
    where
        (
            menuitem0_.CODE=?
        )
Hibernate:
    select
        bonustrigg0_.BONUS_TRIGGER_ID as BONUS_TRIGGER_ID1_8_,
        bonustrigg0_.AWARD_CHANGE_CARD_TYPE_ID as AWARD_CHANGE_CARD12_8_,
        bonustrigg0_.AWARD_COUPON_RULESET_ID as AWARD_COUPON_RULE13_8_,
        bonustrigg0_.AWARD_DEPOSIT as AWARD_DEPOSIT2_8_,
        bonustrigg0_.AWARD_DEPOSIT_MULTIPLY as AWARD_DEPOSIT_MULT3_8_,
        bonustrigg0_.AWARD_EXTEND_VALIDITY as AWARD_EXTEND_VALID4_8_,
        bonustrigg0_.AWARD_SUBSCRIPTION_MI_ID as AWARD_SUBSCRIPTIO14_8_,
        bonustrigg0_.TASK_TYPE_ID as TASK_TYPE_ID15_8_,
        bonustrigg0_.DEPOSIT_ACCOUNT_DEF_ID as DEPOSIT_ACCOUNT_D16_8_,
        bonustrigg0_.EMAIL_TEMPLATE_ID as EMAIL_TEMPLATE_ID17_8_,
        bonustrigg0_.NAME as NAME5_8_,
        bonustrigg0_.RESET_TYPE as RESET_TYPE6_8_,
        bonustrigg0_.RULESET_ID as RULESET_ID18_8_,
        bonustrigg0_.RUNONCE_FLAG as RUNONCE_FLAG7_8_,
        bonustrigg0_.TRIGGER_AMOUNT_MAX as TRIGGER_AMOUNT_MAX8_8_,
        bonustrigg0_.TRIGGER_AMOUNT_MIN as TRIGGER_AMOUNT_MIN9_8_,
        bonustrigg0_.TRIGGER_DATE as TRIGGER_DATE10_8_,
        bonustrigg0_.TRIGGER_DATE_DELTA as TRIGGER_DATE_DELT11_8_
    from
        club.BONUS_TRIGGERS bonustrigg0_
    where
        (
            bonustrigg0_.RULESET_ID=?
        )
15.08.16 17:05:39:185 - INFO - BonusTriggersHelper - bonusTriggers.size: 0
Hibernate:
    insert
    into
        club.ACCOUNTING
        (ACCOUNT_DEF_ID, AMOUNT, CARD_ID, EXPIRY_DATE, IMMED, LOAN_FLAG, TAG, DOC_ID, SEQ)
    values
        (?, ?, ?, ?, ?, ?, ?, ?, ?)
15.08.16 17:05:39:193 - INFO - CardInfo - Infolines URL:  http://localhost:8085//cardinfo/info.jsp?cardId=1260&templName=LOYALTY&docId=4694&email=0&extra=1260&body=
Hibernate:
    select
        this_.ID as ID1_29_2_,
        this_.CARD_ID as CARD_ID4_29_2_,
        this_.CARD_TYPE_ID as CARD_TYPE_ID5_29_2_,
        this_.MAGSTRIPE as MAGSTRIPE2_29_2_,
        this_.VALID_TILL as VALID_TILL3_29_2_,
        card2_.CARD_ID as CARD_ID1_20_0_,
        card2_.IS_ARCHIVED as IS_ARCHIVED2_20_0_,
        card2_.BIRTH_DATE as BIRTH_DATE3_20_0_,
        card2_.CARD_STATUS_ID as CARD_STATUS_ID78_20_0_,
        card2_.CARD_TYPE_ID as CARD_TYPE_ID79_20_0_,
        card2_.CELL_PHONE as CELL_PHONE4_20_0_,
        card2_.CITY as CITY5_20_0_,
        card2_.COMPANY as COMPANY6_20_0_,
        card2_.COUNTRY as COUNTRY7_20_0_,
        card2_.CREATED_DATE as CREATED_DATE8_20_0_,
        card2_.CREATED_PERSON as CREATED_PERSON9_20_0_,
        card2_.EMAIL as EMAIL10_20_0_,
        card2_.FIRST_NAME as FIRST_NAME11_20_0_,
        card2_.GENDER as GENDER12_20_0_,
        card2_.GREETING as GREETING13_20_0_,
        card2_.HEALTH_INFO as HEALTH_INFO14_20_0_,
        card2_.JOB_TITLE as JOB_TITLE15_20_0_,
        card2_.LANG as LANG16_20_0_,
        card2_.LAST_NAME as LAST_NAME17_20_0_,
        card2_.LAST_USED_RVC_ID as LAST_USED_RVC_ID18_20_0_,
        card2_.MAGSTRIPE as MAGSTRIPE19_20_0_,
        card2_.MAILING_OPT as MAILING_OPT20_20_0_,
        card2_.MASTER_CARD_ID as MASTER_CARD_ID80_20_0_,
        card2_.MAX_CHILDREN as MAX_CHILDREN21_20_0_,
        card2_.MLST_SYNC_STATUS as MLST_SYNC_STATUS22_20_0_,
        card2_.NOTES as NOTES23_20_0_,
        card2_.PASSPORT as PASSPORT24_20_0_,
        card2_.PASSWORD as PASSWORD25_20_0_,
        card2_.PHONE as PHONE26_20_0_,
        card2_.PROFILE_TYPE as PROFILE_TYPE27_20_0_,
        card2_.RATE as RATE28_20_0_,
        card2_.SECOND_NAME as SECOND_NAME29_20_0_,
        card2_.SOURCE as SOURCE30_20_0_,
        card2_.STREET_ADDRESS as STREET_ADDRESS31_20_0_,
        card2_.TITLE as TITLE32_20_0_,
        card2_.UDFD1 as UDFD33_20_0_,
        card2_.UDFD10 as UDFD34_20_0_,
        card2_.UDFD2 as UDFD35_20_0_,
        card2_.UDFD3 as UDFD36_20_0_,
        card2_.UDFD4 as UDFD37_20_0_,
        card2_.UDFD5 as UDFD38_20_0_,
        card2_.UDFD6 as UDFD39_20_0_,
        card2_.UDFD7 as UDFD40_20_0_,
        card2_.UDFD8 as UDFD41_20_0_,
        card2_.UDFD9 as UDFD42_20_0_,
        card2_.UDFN1 as UDFN43_20_0_,
        card2_.UDFN10 as UDFN44_20_0_,
        card2_.UDFN2 as UDFN45_20_0_,
        card2_.UDFN3 as UDFN46_20_0_,
        card2_.UDFN4 as UDFN47_20_0_,
        card2_.UDFN5 as UDFN48_20_0_,
        card2_.UDFN6 as UDFN49_20_0_,
        card2_.UDFN7 as UDFN50_20_0_,
        card2_.UDFN8 as UDFN51_20_0_,
        card2_.UDFN9 as UDFN52_20_0_,
        card2_.UDFS1 as UDFS53_20_0_,
        card2_.UDFS10 as UDFS54_20_0_,
        card2_.UDFS11 as UDFS55_20_0_,
        card2_.UDFS12 as UDFS56_20_0_,
        card2_.UDFS13 as UDFS57_20_0_,
        card2_.UDFS14 as UDFS58_20_0_,
        card2_.UDFS15 as UDFS59_20_0_,
        card2_.UDFS16 as UDFS60_20_0_,
        card2_.UDFS17 as UDFS61_20_0_,
        card2_.UDFS18 as UDFS62_20_0_,
        card2_.UDFS19 as UDFS63_20_0_,
        card2_.UDFS2 as UDFS64_20_0_,
        card2_.UDFS20 as UDFS65_20_0_,
        card2_.UDFS3 as UDFS66_20_0_,
        card2_.UDFS4 as UDFS67_20_0_,
        card2_.UDFS5 as UDFS68_20_0_,
        card2_.UDFS6 as UDFS69_20_0_,
        card2_.UDFS7 as UDFS70_20_0_,
        card2_.UDFS8 as UDFS71_20_0_,
        card2_.UDFS9 as UDFS72_20_0_,
        card2_.UPDATE_DATE as UPDATE_DATE73_20_0_,
        card2_.UPDATE_PERSON as UPDATE_PERSON74_20_0_,
        card2_.VALID_TILL as VALID_TILL75_20_0_,
        card2_.VIP_STATUS as VIP_STATUS76_20_0_,
        card2_.ZIP_CODE as ZIP_CODE77_20_0_,
        cardtype3_.CARD_TYPE_ID as CARD_TYPE_ID1_26_1_,
        cardtype3_.DEFAULT_ACCOUNT_DEF_ID as DEFAULT_ACCOUNT_D12_26_1_,
        cardtype3_.ACTIVE as ACTIVE2_26_1_,
        cardtype3_.DEFAULT_MASK as DEFAULT_MASK3_26_1_,
        cardtype3_.DEFAULT_VALIDITY_PERIOD as DEFAULT_VALIDITY_P4_26_1_,
        cardtype3_.FACILITY_ACCESS_RULESET as FACILITY_ACCESS_R13_26_1_,
        cardtype3_.MENU_LEVEL as MENU_LEVEL5_26_1_,
        cardtype3_.OPTIONS as OPTIONS6_26_1_,
        cardtype3_.PMS_LEVEL as PMS_LEVEL7_26_1_,
        cardtype3_.PMS_TYPE as PMS_TYPE8_26_1_,
        cardtype3_.RANGE_START as RANGE_START9_26_1_,
        cardtype3_.TRACK1FORMAT as TRACK10_26_1_,
        cardtype3_.TYPE_NAME as TYPE_NAME11_26_1_
    from
        club.CARD_XTRA this_
    inner join
        club.CARDS card2_
            on this_.CARD_ID=card2_.CARD_ID
    inner join
        club.CARD_TYPES cardtype3_
            on this_.CARD_TYPE_ID=cardtype3_.CARD_TYPE_ID
    where
        this_.MAGSTRIPE=?
Hibernate:
    select
        card0_.CARD_ID as CARD_ID1_20_0_,
        card0_.IS_ARCHIVED as IS_ARCHIVED2_20_0_,
        card0_.BIRTH_DATE as BIRTH_DATE3_20_0_,
        card0_.CARD_STATUS_ID as CARD_STATUS_ID78_20_0_,
        card0_.CARD_TYPE_ID as CARD_TYPE_ID79_20_0_,
        card0_.CELL_PHONE as CELL_PHONE4_20_0_,
        card0_.CITY as CITY5_20_0_,
        card0_.COMPANY as COMPANY6_20_0_,
        card0_.COUNTRY as COUNTRY7_20_0_,
        card0_.CREATED_DATE as CREATED_DATE8_20_0_,
        card0_.CREATED_PERSON as CREATED_PERSON9_20_0_,
        card0_.EMAIL as EMAIL10_20_0_,
        card0_.FIRST_NAME as FIRST_NAME11_20_0_,
        card0_.GENDER as GENDER12_20_0_,
        card0_.GREETING as GREETING13_20_0_,
        card0_.HEALTH_INFO as HEALTH_INFO14_20_0_,
        card0_.JOB_TITLE as JOB_TITLE15_20_0_,
        card0_.LANG as LANG16_20_0_,
        card0_.LAST_NAME as LAST_NAME17_20_0_,
        card0_.LAST_USED_RVC_ID as LAST_USED_RVC_ID18_20_0_,
        card0_.MAGSTRIPE as MAGSTRIPE19_20_0_,
        card0_.MAILING_OPT as MAILING_OPT20_20_0_,
        card0_.MASTER_CARD_ID as MASTER_CARD_ID80_20_0_,
        card0_.MAX_CHILDREN as MAX_CHILDREN21_20_0_,
        card0_.MLST_SYNC_STATUS as MLST_SYNC_STATUS22_20_0_,
        card0_.NOTES as NOTES23_20_0_,
        card0_.PASSPORT as PASSPORT24_20_0_,
        card0_.PASSWORD as PASSWORD25_20_0_,
        card0_.PHONE as PHONE26_20_0_,
        card0_.PROFILE_TYPE as PROFILE_TYPE27_20_0_,
        card0_.RATE as RATE28_20_0_,
        card0_.SECOND_NAME as SECOND_NAME29_20_0_,
        card0_.SOURCE as SOURCE30_20_0_,
        card0_.STREET_ADDRESS as STREET_ADDRESS31_20_0_,
        card0_.TITLE as TITLE32_20_0_,
        card0_.UDFD1 as UDFD33_20_0_,
        card0_.UDFD10 as UDFD34_20_0_,
        card0_.UDFD2 as UDFD35_20_0_,
        card0_.UDFD3 as UDFD36_20_0_,
        card0_.UDFD4 as UDFD37_20_0_,
        card0_.UDFD5 as UDFD38_20_0_,
        card0_.UDFD6 as UDFD39_20_0_,
        card0_.UDFD7 as UDFD40_20_0_,
        card0_.UDFD8 as UDFD41_20_0_,
        card0_.UDFD9 as UDFD42_20_0_,
        card0_.UDFN1 as UDFN43_20_0_,
        card0_.UDFN10 as UDFN44_20_0_,
        card0_.UDFN2 as UDFN45_20_0_,
        card0_.UDFN3 as UDFN46_20_0_,
        card0_.UDFN4 as UDFN47_20_0_,
        card0_.UDFN5 as UDFN48_20_0_,
        card0_.UDFN6 as UDFN49_20_0_,
        card0_.UDFN7 as UDFN50_20_0_,
        card0_.UDFN8 as UDFN51_20_0_,
        card0_.UDFN9 as UDFN52_20_0_,
        card0_.UDFS1 as UDFS53_20_0_,
        card0_.UDFS10 as UDFS54_20_0_,
        card0_.UDFS11 as UDFS55_20_0_,
        card0_.UDFS12 as UDFS56_20_0_,
        card0_.UDFS13 as UDFS57_20_0_,
        card0_.UDFS14 as UDFS58_20_0_,
        card0_.UDFS15 as UDFS59_20_0_,
        card0_.UDFS16 as UDFS60_20_0_,
        card0_.UDFS17 as UDFS61_20_0_,
        card0_.UDFS18 as UDFS62_20_0_,
        card0_.UDFS19 as UDFS63_20_0_,
        card0_.UDFS2 as UDFS64_20_0_,
        card0_.UDFS20 as UDFS65_20_0_,
        card0_.UDFS3 as UDFS66_20_0_,
        card0_.UDFS4 as UDFS67_20_0_,
        card0_.UDFS5 as UDFS68_20_0_,
        card0_.UDFS6 as UDFS69_20_0_,
        card0_.UDFS7 as UDFS70_20_0_,
        card0_.UDFS8 as UDFS71_20_0_,
        card0_.UDFS9 as UDFS72_20_0_,
        card0_.UPDATE_DATE as UPDATE_DATE73_20_0_,
        card0_.UPDATE_PERSON as UPDATE_PERSON74_20_0_,
        card0_.VALID_TILL as VALID_TILL75_20_0_,
        card0_.VIP_STATUS as VIP_STATUS76_20_0_,
        card0_.ZIP_CODE as ZIP_CODE77_20_0_
    from
        club.CARDS card0_
    where
        card0_.CARD_ID=?
Hibernate:
    select
        doc0_.DOC_ID as DOC_ID1_42_0_,
        doc0_.BUSSINES_DATE as BUSSINES_DATE2_42_0_,
        doc0_.DEF_CARD_ID as DEF_CARD_ID3_42_0_,
        doc0_.DEF_CARD_TYPE_ID as DEF_CARD_TYPE_ID4_42_0_,
        doc0_.CHCK_ID as CHCK_ID5_42_0_,
        doc0_.CHECK_OPEN as CHECK_OPEN6_42_0_,
        doc0_.CHKNUM as CHKNUM7_42_0_,
        doc0_.COFIRMATION as COFIRMATION8_42_0_,
        doc0_.DOC_TYPE as DOC_TYPE9_42_0_,
        doc0_.GST as GST10_42_0_,
        doc0_.IMAGE as IMAGE11_42_0_,
        doc0_.INVOICE_ID as INVOICE_ID20_42_0_,
        doc0_.DEF_MAGSTRIPE as DEF_MAGSTRIPE12_42_0_,
        doc0_.OPERATOR as OPERATOR13_42_0_,
        doc0_.REGISTRATION_ID as REGISTRATION_ID21_42_0_,
        doc0_.RVC as RVC22_42_0_,
        doc0_.SP as SP14_42_0_,
        doc0_.TAX_EXEMPT as TAX_EXEMPT15_42_0_,
        doc0_.TM as TM16_42_0_,
        doc0_.TM_OPEN as TM_OPEN17_42_0_,
        doc0_.TTL as TTL18_42_0_,
        doc0_.VER as VER19_42_0_
    from
        club.DOCS doc0_
    where
        doc0_.DOC_ID=?
Hibernate:
    select
        docdtl0_.DOC_ID as DOC_ID28_44_,
        docdtl0_.DTL_SEQ as DTL_SEQ1_44_,
        docdtl0_.MI_SEQ as MI_SEQ2_44_,
        docdtl0_.BOOKING_ID as BOOKING_ID3_44_,
        docdtl0_.CASHIER_SHIFT_ID as CASHIER_SHIFT_ID4_44_,
        docdtl0_.COUNT as COUNT5_44_,
        docdtl0_.DSC as DSC6_44_,
        docdtl0_.DSC_REASON as DSC_REASON7_44_,
        docdtl0_.FGRP as FGRP8_44_,
        docdtl0_.MANUAL_SVC as MANUAL_SVC9_44_,
        docdtl0_.MANUAL_DSC as MANUAL_DSC10_44_,
        docdtl0_.MI_ID as MI_ID11_44_,
        docdtl0_.NAME as NAME12_44_,
        docdtl0_.POSTING_EMPL_ID as POSTING_EMPL_ID13_44_,
        docdtl0_.PAY_TTL_DEPOSIT as PAY_TTL_DEPOSIT14_44_,
        docdtl0_.PAY_TTL_SUBSCR as PAY_TTL_SUBSCR15_44_,
        docdtl0_.POINTS as POINTS16_44_,
        docdtl0_.REFERENCE as REFERENCE17_44_,
        docdtl0_.COMISSION_EMPL_ID as COMISSION_EMPL_ID18_44_,
        docdtl0_.SI as SI19_44_,
        docdtl0_.TAX_ADD as TAX_ADD20_44_,
        docdtl0_.TAX_ADDON as TAX_ADDON21_44_,
        docdtl0_.TAX_VAT as TAX_VAT22_44_,
        docdtl0_.TICKETS as TICKETS23_44_,
        docdtl0_.TM as TM24_44_,
        docdtl0_.TTL as TTL25_44_,
        docdtl0_.VOID_FLAG as VOID_FLAG26_44_,
        docdtl0_.VOID_REASON as VOID_REASON27_44_
    from
        club.DOCS_DTL docdtl0_
    where
        (
            DOC_ID=?
        )
Hibernate:
    select
        a.expiry_date,
        sum(a.amount) as amount
    from
        accounting a,
        docs d
    where
        d.doc_id = a.doc_id
        and d.cofirmation='T'
        and a.expiry_date >= trunc(sysdate)
        and a.loan_flag='T'
        and a.card_id=?
    group by
        a.expiry_date
    having
        sum(a.amount) != 0
    order by
        a.expiry_date
Hibernate:
    SELECT
        v.*
    FROM
        VOUCHER v
    JOIN
        VOUCHER_CAMPAIGN vc
            ON vc.VOUCHER_CAMPAIGN_ID=v.VOUCHER_CAMPAIGN_ID
    WHERE
        v.LINK_CARD_ID=?
        AND (
            v.VALID_TILL IS NULL
            OR v.VALID_TILL >= SYSDATE
        )
        AND (
            v.USE_COUNT < vc.MAX_USE_COUNT
        )
        AND (
            v.SUBSCRIPTION_ACCOUNTING_ID IS NULL
            OR v.SUBSCRIPTION_ACCOUNTING_ID IN (
                SELECT
                    sa.SUBSCRIPTION_ACCOUNTING_ID
                FROM
                    SUBSCRIPTION_ACCOUNTING sa
                WHERE
                    sa.STATUS='2'
            )
        )
Hibernate:
    select
        card0_.CARD_ID as CARD_ID1_20_0_,
        card0_.IS_ARCHIVED as IS_ARCHIVED2_20_0_,
        card0_.BIRTH_DATE as BIRTH_DATE3_20_0_,
        card0_.CARD_STATUS_ID as CARD_STATUS_ID78_20_0_,
        card0_.CARD_TYPE_ID as CARD_TYPE_ID79_20_0_,
        card0_.CELL_PHONE as CELL_PHONE4_20_0_,
        card0_.CITY as CITY5_20_0_,
        card0_.COMPANY as COMPANY6_20_0_,
        card0_.COUNTRY as COUNTRY7_20_0_,
        card0_.CREATED_DATE as CREATED_DATE8_20_0_,
        card0_.CREATED_PERSON as CREATED_PERSON9_20_0_,
        card0_.EMAIL as EMAIL10_20_0_,
        card0_.FIRST_NAME as FIRST_NAME11_20_0_,
        card0_.GENDER as GENDER12_20_0_,
        card0_.GREETING as GREETING13_20_0_,
        card0_.HEALTH_INFO as HEALTH_INFO14_20_0_,
        card0_.JOB_TITLE as JOB_TITLE15_20_0_,
        card0_.LANG as LANG16_20_0_,
        card0_.LAST_NAME as LAST_NAME17_20_0_,
        card0_.LAST_USED_RVC_ID as LAST_USED_RVC_ID18_20_0_,
        card0_.MAGSTRIPE as MAGSTRIPE19_20_0_,
        card0_.MAILING_OPT as MAILING_OPT20_20_0_,
        card0_.MASTER_CARD_ID as MASTER_CARD_ID80_20_0_,
        card0_.MAX_CHILDREN as MAX_CHILDREN21_20_0_,
        card0_.MLST_SYNC_STATUS as MLST_SYNC_STATUS22_20_0_,
        card0_.NOTES as NOTES23_20_0_,
        card0_.PASSPORT as PASSPORT24_20_0_,
        card0_.PASSWORD as PASSWORD25_20_0_,
        card0_.PHONE as PHONE26_20_0_,
        card0_.PROFILE_TYPE as PROFILE_TYPE27_20_0_,
        card0_.RATE as RATE28_20_0_,
        card0_.SECOND_NAME as SECOND_NAME29_20_0_,
        card0_.SOURCE as SOURCE30_20_0_,
        card0_.STREET_ADDRESS as STREET_ADDRESS31_20_0_,
        card0_.TITLE as TITLE32_20_0_,
        card0_.UDFD1 as UDFD33_20_0_,
        card0_.UDFD10 as UDFD34_20_0_,
        card0_.UDFD2 as UDFD35_20_0_,
        card0_.UDFD3 as UDFD36_20_0_,
        card0_.UDFD4 as UDFD37_20_0_,
        card0_.UDFD5 as UDFD38_20_0_,
        card0_.UDFD6 as UDFD39_20_0_,
        card0_.UDFD7 as UDFD40_20_0_,
        card0_.UDFD8 as UDFD41_20_0_,
        card0_.UDFD9 as UDFD42_20_0_,
        card0_.UDFN1 as UDFN43_20_0_,
        card0_.UDFN10 as UDFN44_20_0_,
        card0_.UDFN2 as UDFN45_20_0_,
        card0_.UDFN3 as UDFN46_20_0_,
        card0_.UDFN4 as UDFN47_20_0_,
        card0_.UDFN5 as UDFN48_20_0_,
        card0_.UDFN6 as UDFN49_20_0_,
        card0_.UDFN7 as UDFN50_20_0_,
        card0_.UDFN8 as UDFN51_20_0_,
        card0_.UDFN9 as UDFN52_20_0_,
        card0_.UDFS1 as UDFS53_20_0_,
        card0_.UDFS10 as UDFS54_20_0_,
        card0_.UDFS11 as UDFS55_20_0_,
        card0_.UDFS12 as UDFS56_20_0_,
        card0_.UDFS13 as UDFS57_20_0_,
        card0_.UDFS14 as UDFS58_20_0_,
        card0_.UDFS15 as UDFS59_20_0_,
        card0_.UDFS16 as UDFS60_20_0_,
        card0_.UDFS17 as UDFS61_20_0_,
        card0_.UDFS18 as UDFS62_20_0_,
        card0_.UDFS19 as UDFS63_20_0_,
        card0_.UDFS2 as UDFS64_20_0_,
        card0_.UDFS20 as UDFS65_20_0_,
        card0_.UDFS3 as UDFS66_20_0_,
        card0_.UDFS4 as UDFS67_20_0_,
        card0_.UDFS5 as UDFS68_20_0_,
        card0_.UDFS6 as UDFS69_20_0_,
        card0_.UDFS7 as UDFS70_20_0_,
        card0_.UDFS8 as UDFS71_20_0_,
        card0_.UDFS9 as UDFS72_20_0_,
        card0_.UPDATE_DATE as UPDATE_DATE73_20_0_,
        card0_.UPDATE_PERSON as UPDATE_PERSON74_20_0_,
        card0_.VALID_TILL as VALID_TILL75_20_0_,
        card0_.VIP_STATUS as VIP_STATUS76_20_0_,
        card0_.ZIP_CODE as ZIP_CODE77_20_0_
    from
        club.CARDS card0_
    where
        card0_.CARD_ID=?
Hibernate:
    select
        vouchercam0_.VOUCHER_CAMPAIGN_ID as VOUCHER_CAMPAIGN_I1_137_0_,
        vouchercam0_.BONUS as BONUS2_137_0_,
        vouchercam0_.BONUS_TYPE as BONUS_TYPE3_137_0_,
        vouchercam0_.CODE_LEN as CODE_LEN4_137_0_,
        vouchercam0_.CODE_TYPE as CODE_TYPE5_137_0_,
        vouchercam0_.CREATED_PERSON as CREATED_PERSON6_137_0_,
        vouchercam0_.CREATED_TM as CREATED_TM7_137_0_,
        vouchercam0_.DEFAULT_VALIDITY as DEFAULT_VALIDITY8_137_0_,
        vouchercam0_.HIERARCHY_ID as HIERARCHY_ID19_137_0_,
        vouchercam0_.ITEMS as ITEMS9_137_0_,
        vouchercam0_.MAX_USE_COUNT as MAX_USE_COUNT10_137_0_,
        vouchercam0_.NAME as NAME11_137_0_,
        vouchercam0_.PREFIX as PREFIX12_137_0_,
        vouchercam0_.RANGE_FROM as RANGE_FROM13_137_0_,
        vouchercam0_.RANGE_TILL as RANGE_TILL14_137_0_,
        vouchercam0_.DSC_RULSET_ID as DSC_RULSET_ID20_137_0_,
        vouchercam0_.TYPE as TYPE15_137_0_,
        vouchercam0_.UPDATE_PERSON as UPDATE_PERSON16_137_0_,
        vouchercam0_.UPDATE_TM as UPDATE_TM17_137_0_,
        vouchercam0_.VALUE as VALUE18_137_0_
    from
        club.VOUCHER_CAMPAIGN vouchercam0_
    where
        vouchercam0_.VOUCHER_CAMPAIGN_ID=?
Hibernate:
    SELECT
        b.booking_id,
        b.status,
        b.name,
        b.time_start,
        b.time_end,
        r.name AS rvcname,
        (SELECT
            MIN(resource_name)
        FROM
            booking_resources
        WHERE
            resource_type='T'
            AND booking_id=b.booking_id) AS therapist
    FROM
        bookings b,
        booking_resources br,
        rvc r
    WHERE
        br.booking_id = b.booking_id
        AND r.rvc_id = b.rvc_id
        AND b.status != 'V'
        AND br.resource_type = 'P'
        AND br.resource_id = ?
        AND b.time_start >= ?
    order by
        b.time_start
Hibernate:
    select
        cardextra0_.ID as ID1_29_,
        cardextra0_.CARD_ID as CARD_ID4_29_,
        cardextra0_.CARD_TYPE_ID as CARD_TYPE_ID5_29_,
        cardextra0_.MAGSTRIPE as MAGSTRIPE2_29_,
        cardextra0_.VALID_TILL as VALID_TILL3_29_
    from
        club.CARD_XTRA cardextra0_
    where
        (
            cardextra0_.CARD_ID=?
        )
Hibernate:
    select
        template0_.TEMPLATE_ID as TEMPLATE_ID1_123_,
        template0_.DATA as DATA2_123_,
        template0_.NAME as NAME3_123_,
        template0_.SYSTEM as SYSTEM4_123_,
        template0_.TITLE as TITLE5_123_,
        template0_.TYPE as TYPE6_123_
    from
        club.TEMPLATES template0_
    where
        (
            template0_.NAME=?
        )
15.08.16 17:05:39:295 - INFO - DatabaseResourceViewResolver - Storing template c:\TOMCAT3\webapps\ROOT\WEB-INF\jsp\LOYALTY.jsp
Hibernate:
    select
        cardtype0_.CARD_TYPE_ID as CARD_TYPE_ID1_26_0_,
        cardtype0_.DEFAULT_ACCOUNT_DEF_ID as DEFAULT_ACCOUNT_D12_26_0_,
        cardtype0_.ACTIVE as ACTIVE2_26_0_,
        cardtype0_.DEFAULT_MASK as DEFAULT_MASK3_26_0_,
        cardtype0_.DEFAULT_VALIDITY_PERIOD as DEFAULT_VALIDITY_P4_26_0_,
        cardtype0_.FACILITY_ACCESS_RULESET as FACILITY_ACCESS_R13_26_0_,
        cardtype0_.MENU_LEVEL as MENU_LEVEL5_26_0_,
        cardtype0_.OPTIONS as OPTIONS6_26_0_,
        cardtype0_.PMS_LEVEL as PMS_LEVEL7_26_0_,
        cardtype0_.PMS_TYPE as PMS_TYPE8_26_0_,
        cardtype0_.RANGE_START as RANGE_START9_26_0_,
        cardtype0_.TRACK1FORMAT as TRACK10_26_0_,
        cardtype0_.TYPE_NAME as TYPE_NAME11_26_0_
    from
        club.CARD_TYPES cardtype0_
    where
        cardtype0_.CARD_TYPE_ID=?
15.08.16 17:05:39:513 - INFO - CardInfo - Infolines text: 1260 Герасименко Александр|Гость-|---------------------------|Guest signature
Hibernate:
    DELETE
    FROM
        DOCS_DTL
    WHERE
        DOC_ID=?
15.08.16 17:05:39:513 - INFO - ResourceInvoiceService - DELETE from docs_dtl result: 0
Hibernate:
    DELETE
    FROM
        DOCS_TAX
    WHERE
        DOC_ID=?
Hibernate:
    DELETE
    FROM
        DOCS_PAYM
    WHERE
        DOC_ID=?
15.08.16 17:05:39:513 - INFO - ResourceInvoiceService - DELETE from docs_paym result: 0
Hibernate:
    select
        tax0_.SITE_ID as SITE_ID5_115_,
        tax0_.TAX_ID as TAX_ID1_115_,
        tax0_.NAME as NAME2_115_,
        tax0_.RATE as RATE3_115_,
        tax0_.TYPE as TYPE4_115_
    from
        club.TAXES tax0_
    where
        (
            SITE_ID=?
        )
Hibernate:
    select
        site0_.SITE_ID as SITE_ID1_107_0_,
        site0_.AUTOSTART as AUTOSTART2_107_0_,
        site0_.DB_SYNC as DB_SYNC3_107_0_,
        site0_.TP as TP4_107_0_,
        site0_.GI as GI5_107_0_,
        site0_.HTNG as HTNG6_107_0_,
        site0_.INQ_TM as INQ_TM7_107_0_,
        site0_.IP as IP8_107_0_,
        site0_.LOCATION as LOCATION9_107_0_,
        site0_.NAME as NAME10_107_0_,
        site0_.OPTIONS as OPTIONS11_107_0_,
        site0_.PMS_PROPERTY as PMS_PROPERTY12_107_0_,
        site0_.PORT as PORT13_107_0_,
        site0_.SITE_KEY as SITE_KEY14_107_0_,
        site0_.SVC_TAX_CLASS_ID as SVC_TAX_CLASS_ID16_107_0_,
        site0_.V8IFC as V15_107_0_
    from
        club.SITES site0_
    where
        site0_.SITE_ID=?
Hibernate:
    select
        menuitem0_.MI_ID as MI_ID1_77_,
        menuitem0_.ACTIVE as ACTIVE2_77_,
        menuitem0_.BARCODE as BARCODE3_77_,
        menuitem0_.BASE_INV_UNIT_ID as BASE_INV_UNIT_ID30_77_,
        menuitem0_.BOOK_STEP as BOOK_STEP4_77_,
        menuitem0_.CODE as CODE5_77_,
        menuitem0_.COLOR as COLOR6_77_,
        menuitem0_.COMMISSION_GRP_ID as COMMISSION_GRP_ID31_77_,
        menuitem0_.COMPLEXITY as COMPLEXITY7_77_,
        menuitem0_.COST as COST8_77_,
        menuitem0_.DESCRIPTION as DESCRIPTION9_77_,
        menuitem0_.DESCRIPTION_STRING_ID as DESCRIPTION_STRIN10_77_,
        menuitem0_.DISCOUNT_RULESET_ID as DISCOUNT_RULESET_32_77_,
        menuitem0_.EXTN_GROUP as EXTN_GROUP11_77_,
        menuitem0_.FGRP as FGRP33_77_,
        menuitem0_.FAVOURITES_ID as FAVOURITES_ID34_77_,
        menuitem0_.HIERARCHY_ID as HIERARCHY_ID35_77_,
        menuitem0_.INITIAL_STATUS as INITIAL_STATUS12_77_,
        menuitem0_.MAX_PARTICIPANT as MAX_PARTICIPANT13_77_,
        menuitem0_.MAX_PARTICIPANT_WEB as MAX_PARTICIPANT_W14_77_,
        menuitem0_.MI_TYPE as MI_TYPE15_77_,
        menuitem0_.NAME1 as NAME16_77_,
        menuitem0_.NAME2 as NAME17_77_,
        menuitem0_.NAME_STRING_ID as NAME_STRING_ID18_77_,
        menuitem0_.OPTIONS as OPTIONS19_77_,
        menuitem0_.PMS_CODE as PMS_CODE20_77_,
        menuitem0_.RETURN_CHARGE as RETURN_CHARGE21_77_,
        menuitem0_.RSRV_COUNT as RSRV_COUNT22_77_,
        menuitem0_.SI as SI36_77_,
        menuitem0_.SPA_CANCEL_CAT_ID as SPA_CANCEL_CAT_ID37_77_,
        menuitem0_.SUBSCR_ACTIVE_MI as SUBSCR_ACTIVE_MI23_77_,
        menuitem0_.SUBSCR_FROZEN_MI as SUBSCR_FROZEN_MI24_77_,
        menuitem0_.SUBSCR_PERIOD_COUNT as SUBSCR_PERIOD_COU25_77_,
        menuitem0_.SUBSCR_PERIOD_TYPE as SUBSCR_PERIOD_TYP26_77_,
        menuitem0_.TAX_CLASS as TAX_CLASS38_77_,
        menuitem0_.TREAT_CLEANOUT_TIME as TREAT_CLEANOUT_TI27_77_,
        menuitem0_.TREAT_DURATION as TREAT_DURATION28_77_,
        menuitem0_.TREAT_PREP_TIME as TREAT_PREP_TIME29_77_,
        menuitem0_.VOUCHER_CAMPAIGN_ID as VOUCHER_CAMPAIGN_39_77_,
        menuitem0_.WEBGRP as WEBGRP40_77_,
        UPPER(menuitem0_.CODE || ' ' || menuitem0_.NAME1) as formula2_,
        UPPER(menuitem0_.NAME1 || ' (' || menuitem0_.CODE || ')' ) as formula3_
    from
        club.MENU_ITEMS menuitem0_
    where
        (
            menuitem0_.CODE=?
        )
Hibernate:
    select
        taxclass0_.TAX_CLASS_ID as TAX_CLASS_ID1_116_0_,
        taxclass0_.NAME as NAME2_116_0_,
        taxclass0_.TAX_RATES as TAX_RATES3_116_0_
    from
        club.TAX_CLASSES taxclass0_
    where
        taxclass0_.TAX_CLASS_ID=?
Hibernate:
    select
        menuitem0_.MI_ID as MI_ID1_77_,
        menuitem0_.ACTIVE as ACTIVE2_77_,
        menuitem0_.BARCODE as BARCODE3_77_,
        menuitem0_.BASE_INV_UNIT_ID as BASE_INV_UNIT_ID30_77_,
        menuitem0_.BOOK_STEP as BOOK_STEP4_77_,
        menuitem0_.CODE as CODE5_77_,
        menuitem0_.COLOR as COLOR6_77_,
        menuitem0_.COMMISSION_GRP_ID as COMMISSION_GRP_ID31_77_,
        menuitem0_.COMPLEXITY as COMPLEXITY7_77_,
        menuitem0_.COST as COST8_77_,
        menuitem0_.DESCRIPTION as DESCRIPTION9_77_,
        menuitem0_.DESCRIPTION_STRING_ID as DESCRIPTION_STRIN10_77_,
        menuitem0_.DISCOUNT_RULESET_ID as DISCOUNT_RULESET_32_77_,
        menuitem0_.EXTN_GROUP as EXTN_GROUP11_77_,
        menuitem0_.FGRP as FGRP33_77_,
        menuitem0_.FAVOURITES_ID as FAVOURITES_ID34_77_,
        menuitem0_.HIERARCHY_ID as HIERARCHY_ID35_77_,
        menuitem0_.INITIAL_STATUS as INITIAL_STATUS12_77_,
        menuitem0_.MAX_PARTICIPANT as MAX_PARTICIPANT13_77_,
        menuitem0_.MAX_PARTICIPANT_WEB as MAX_PARTICIPANT_W14_77_,
        menuitem0_.MI_TYPE as MI_TYPE15_77_,
        menuitem0_.NAME1 as NAME16_77_,
        menuitem0_.NAME2 as NAME17_77_,
        menuitem0_.NAME_STRING_ID as NAME_STRING_ID18_77_,
        menuitem0_.OPTIONS as OPTIONS19_77_,
        menuitem0_.PMS_CODE as PMS_CODE20_77_,
        menuitem0_.RETURN_CHARGE as RETURN_CHARGE21_77_,
        menuitem0_.RSRV_COUNT as RSRV_COUNT22_77_,
        menuitem0_.SI as SI36_77_,
        menuitem0_.SPA_CANCEL_CAT_ID as SPA_CANCEL_CAT_ID37_77_,
        menuitem0_.SUBSCR_ACTIVE_MI as SUBSCR_ACTIVE_MI23_77_,
        menuitem0_.SUBSCR_FROZEN_MI as SUBSCR_FROZEN_MI24_77_,
        menuitem0_.SUBSCR_PERIOD_COUNT as SUBSCR_PERIOD_COU25_77_,
        menuitem0_.SUBSCR_PERIOD_TYPE as SUBSCR_PERIOD_TYP26_77_,
        menuitem0_.TAX_CLASS as TAX_CLASS38_77_,
        menuitem0_.TREAT_CLEANOUT_TIME as TREAT_CLEANOUT_TI27_77_,
        menuitem0_.TREAT_DURATION as TREAT_DURATION28_77_,
        menuitem0_.TREAT_PREP_TIME as TREAT_PREP_TIME29_77_,
        menuitem0_.VOUCHER_CAMPAIGN_ID as VOUCHER_CAMPAIGN_39_77_,
        menuitem0_.WEBGRP as WEBGRP40_77_,
        UPPER(menuitem0_.CODE || ' ' || menuitem0_.NAME1) as formula2_,
        UPPER(menuitem0_.NAME1 || ' (' || menuitem0_.CODE || ')' ) as formula3_
    from
        club.MENU_ITEMS menuitem0_
    where
        (
            menuitem0_.CODE=?
        )
Hibernate:
    select
        menufgrp0_.FGRP_ID as FGRP_ID1_76_0_,
        menufgrp0_.NAME as NAME2_76_0_
    from
        club.MENU_FGRP menufgrp0_
    where
        menufgrp0_.FGRP_ID=?
Hibernate:
    select
        menusi0_.SI_ID as SI_ID1_81_0_,
        menusi0_.DEP_CODE as DEP_CODE2_81_0_,
        menusi0_.NAME as NAME3_81_0_
    from
        club.MENU_SI menusi0_
    where
        menusi0_.SI_ID=?
Hibernate:
    select
        docdtl_.DOC_ID,
        docdtl_.DTL_SEQ,
        docdtl_.MI_SEQ,
        docdtl_.BOOKING_ID as BOOKING_ID3_44_,
        docdtl_.CASHIER_SHIFT_ID as CASHIER_SHIFT_ID4_44_,
        docdtl_.COUNT as COUNT5_44_,
        docdtl_.DSC as DSC6_44_,
        docdtl_.DSC_REASON as DSC_REASON7_44_,
        docdtl_.FGRP as FGRP8_44_,
        docdtl_.MANUAL_SVC as MANUAL_SVC9_44_,
        docdtl_.MANUAL_DSC as MANUAL_DSC10_44_,
        docdtl_.MI_ID as MI_ID11_44_,
        docdtl_.NAME as NAME12_44_,
        docdtl_.POSTING_EMPL_ID as POSTING_EMPL_ID13_44_,
        docdtl_.PAY_TTL_DEPOSIT as PAY_TTL_DEPOSIT14_44_,
        docdtl_.PAY_TTL_SUBSCR as PAY_TTL_SUBSCR15_44_,
        docdtl_.POINTS as POINTS16_44_,
        docdtl_.REFERENCE as REFERENCE17_44_,
        docdtl_.COMISSION_EMPL_ID as COMISSION_EMPL_ID18_44_,
        docdtl_.SI as SI19_44_,
        docdtl_.TAX_ADD as TAX_ADD20_44_,
        docdtl_.TAX_ADDON as TAX_ADDON21_44_,
        docdtl_.TAX_VAT as TAX_VAT22_44_,
        docdtl_.TICKETS as TICKETS23_44_,
        docdtl_.TM as TM24_44_,
        docdtl_.TTL as TTL25_44_,
        docdtl_.VOID_FLAG as VOID_FLAG26_44_,
        docdtl_.VOID_REASON as VOID_REASON27_44_
    from
        club.DOCS_DTL docdtl_
    where
        docdtl_.DOC_ID=?
        and docdtl_.DTL_SEQ=?
        and docdtl_.MI_SEQ=?
Hibernate:
    select
        invdoc0_.INV_DOCS_ID as INV_DOCS_ID1_62_,
        invdoc0_.AMOUNT as AMOUNT2_62_,
        invdoc0_.BOOKING_ID as BOOKING_ID12_62_,
        invdoc0_.CONFIRMATION as CONFIRMATION3_62_,
        invdoc0_.DOC_ID as DOC_ID4_62_,
        invdoc0_.DST_STORE_ID as DST_STORE_ID13_62_,
        invdoc0_.EXT_DOC_NUM as EXT_DOC_NUM5_62_,
        invdoc0_.MOD_OPERATOR as MOD_OPERATOR6_62_,
        invdoc0_.MI_ID as MI_ID14_62_,
        invdoc0_.NOTES as NOTES7_62_,
        invdoc0_.OP_CODE as OP_CODE8_62_,
        invdoc0_.OPERATOR as OPERATOR9_62_,
        invdoc0_.SRC_STORE_ID as SRC_STORE_ID15_62_,
        invdoc0_.INV_SUPPLIER_ID as INV_SUPPLIER_ID16_62_,
        invdoc0_.DATE_TM as DATE_TM10_62_,
        invdoc0_.XTRA_COST as XTRA_COST11_62_
    from
        club.INV_DOCS invdoc0_
    where
        (
            invdoc0_.DOC_ID=?
        )
        and(
            invdoc0_.MI_ID is null
        )
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    insert
    into
        club.DOCS_TAX
        (AMOUNT, NAME, TAX_ID, RATE, TYPE, DOC_ID, SEQ)
    values
        (?, ?, ?, ?, ?, ?, ?)
Hibernate:
    insert
    into
        club.DOCS_DTL
        (BOOKING_ID, CASHIER_SHIFT_ID, COUNT, DSC, DSC_REASON, FGRP, MANUAL_SVC, MANUAL_DSC, MI_ID, NAME, POSTING_EMPL_ID, PAY_TTL_DEPOSIT, PAY_TTL_SUBSCR, POINTS, REFERENCE, COMISSION_EMPL_ID, SI, TAX_ADD, TAX_ADDON, TAX_VAT, TICKETS, TM, TTL, VOID_FLAG, VOID_REASON, DOC_ID, DTL_SEQ, MI_SEQ)
    values
        (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
    update
        club.DOCS
    set
        BUSSINES_DATE=?,
        DEF_CARD_ID=?,
        DEF_CARD_TYPE_ID=?,
        CHCK_ID=?,
        CHECK_OPEN=?,
        CHKNUM=?,
        COFIRMATION=?,
        DOC_TYPE=?,
        GST=?,
        IMAGE=?,
        INVOICE_ID=?,
        DEF_MAGSTRIPE=?,
        OPERATOR=?,
        REGISTRATION_ID=?,
        RVC=?,
        SP=?,
        TAX_EXEMPT=?,
        TM=?,
        TM_OPEN=?,
        TTL=?,
        VER=?
    where
        DOC_ID=?
Hibernate:
    select
        this_.CURRENCY_ID as CURRENCY_ID1_39_0_,
        this_.BASE as BASE2_39_0_,
        this_.DECIMAL_CHAR as DECIMAL_CHAR3_39_0_,
        this_.DGT_GROUP_CHAR as DGT_GROUP_CHAR4_39_0_,
        this_.ISO_CODE as ISO_CODE5_39_0_,
        this_.NAME as NAME6_39_0_,
        this_.PRINT_PREFIX as PRINT_PREFIX7_39_0_,
        this_.PRINT_SUFFIX as PRINT_SUFFIX8_39_0_,
        this_.RATE as RATE9_39_0_,
        this_.SCALE as SCALE10_39_0_
    from
        club.CURRENCY this_
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        accountdef0_.ACCOUNT_DEF_ID as ACCOUNT_DEF_ID1_2_,
        accountdef0_.ACCOUNT_CODE as ACCOUNT_CODE2_2_,
        accountdef0_.ACCOUNT_TYPE as ACCOUNT_TYPE3_2_,
        accountdef0_.AUTO_RENEW as AUTO_RENEW4_2_,
        accountdef0_.TASK_TYPE_ID as TASK_TYPE_ID10_2_,
        accountdef0_.CURRENCY_ID as CURRENCY_ID11_2_,
        accountdef0_.EXPIRATION as EXPIRATION5_2_,
        accountdef0_.NAME as NAME6_2_,
        accountdef0_.ORDR as ORDR7_2_,
        accountdef0_.POINTS_RATE as POINTS_RATE8_2_,
        accountdef0_.POINTS_ROUNDING as POINTS_ROUNDING9_2_,
        accountdef0_.RULESET_ID as RULESET_ID12_2_,
        accountdef0_.ACCOUNT_CODE || ' ' || accountdef0_.NAME as formula0_
    from
        club.ACCOUNT_DEF accountdef0_
    order by
        ORDR
Hibernate:
    select
        distinct timeprofil1_.TIME_PROFILE_ID as TIME_PROFILE_ID1_129_,
        timeprofil1_.NAME as NAME2_129_,
        timeprofil1_.TIME_PROFILE_CODE as TIME_PROFILE_CODE3_129_
    from
        club.MENU_PRICE menuprice0_,
        club.TIME_PROFILES timeprofil1_
    where
        menuprice0_.ALLOWED_TIME_PROFILE_ID=timeprofil1_.TIME_PROFILE_ID
Hibernate:
    SELECT
        mi.mi_id,
        mi.name1,
        mi.name2,
        mi.hierarchy_id,
        mp.price,
        mi.barcode,
        mi.mi_type,
        mi.code,
        mi.COMMISSION_GRP_ID as commGrpId,
        mi.color
    FROM
        menu_items mi,
        menu_price mp
    WHERE
        mi.active=1
        AND  mp.mi_id=mi.mi_id
        AND  mp.ordr=(
            SELECT
                MIN(ordr)
            FROM
                menu_price mpp
            WHERE
                mpp.mi_id = mi.mi_id
                AND        nvl(mpp.valid_from,trunc(sysdate))<=trunc(sysdate)
                AND        nvl(mpp.valid_till,trunc(sysdate))>=trunc(sysdate)
                AND (
                    mpp.allowed_rvcs IS NULL
                    OR           mpp.ALLOWED_RVCS IN (
                        SELECT
                            rvc_group_id
                        FROM
                            rvc_group_link rl
                        WHERE
                            rl.rvc_id=443
                    )
                )
                AND (
                    mpp.ALLOWED_TIME_PROFILE_ID is null
                )
            )
Hibernate:
    select
        this_.CURRENCY_ID as CURRENCY_ID1_39_0_,
        this_.BASE as BASE2_39_0_,
        this_.DECIMAL_CHAR as DECIMAL_CHAR3_39_0_,
        this_.DGT_GROUP_CHAR as DGT_GROUP_CHAR4_39_0_,
        this_.ISO_CODE as ISO_CODE5_39_0_,
        this_.NAME as NAME6_39_0_,
        this_.PRINT_PREFIX as PRINT_PREFIX7_39_0_,
        this_.PRINT_SUFFIX as PRINT_SUFFIX8_39_0_,
        this_.RATE as RATE9_39_0_,
        this_.SCALE as SCALE10_39_0_
    from
        club.CURRENCY this_
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        accountdef0_.ACCOUNT_DEF_ID as ACCOUNT_DEF_ID1_2_,
        accountdef0_.ACCOUNT_CODE as ACCOUNT_CODE2_2_,
        accountdef0_.ACCOUNT_TYPE as ACCOUNT_TYPE3_2_,
        accountdef0_.AUTO_RENEW as AUTO_RENEW4_2_,
        accountdef0_.TASK_TYPE_ID as TASK_TYPE_ID10_2_,
        accountdef0_.CURRENCY_ID as CURRENCY_ID11_2_,
        accountdef0_.EXPIRATION as EXPIRATION5_2_,
        accountdef0_.NAME as NAME6_2_,
        accountdef0_.ORDR as ORDR7_2_,
        accountdef0_.POINTS_RATE as POINTS_RATE8_2_,
        accountdef0_.POINTS_ROUNDING as POINTS_ROUNDING9_2_,
        accountdef0_.RULESET_ID as RULESET_ID12_2_,
        accountdef0_.ACCOUNT_CODE || ' ' || accountdef0_.NAME as formula0_
    from
        club.ACCOUNT_DEF accountdef0_
    order by
        ORDR
15.08.16 17:06:23:642 - INFO - PostPaymentHelper - ****** PostPaymentHelper ******
Hibernate:
    select
        this_.CARD_ID as CARD_ID1_20_0_,
        this_.IS_ARCHIVED as IS_ARCHIVED2_20_0_,
        this_.BIRTH_DATE as BIRTH_DATE3_20_0_,
        this_.CARD_STATUS_ID as CARD_STATUS_ID78_20_0_,
        this_.CARD_TYPE_ID as CARD_TYPE_ID79_20_0_,
        this_.CELL_PHONE as CELL_PHONE4_20_0_,
        this_.CITY as CITY5_20_0_,
        this_.COMPANY as COMPANY6_20_0_,
        this_.COUNTRY as COUNTRY7_20_0_,
        this_.CREATED_DATE as CREATED_DATE8_20_0_,
        this_.CREATED_PERSON as CREATED_PERSON9_20_0_,
        this_.EMAIL as EMAIL10_20_0_,
        this_.FIRST_NAME as FIRST_NAME11_20_0_,
        this_.GENDER as GENDER12_20_0_,
        this_.GREETING as GREETING13_20_0_,
        this_.HEALTH_INFO as HEALTH_INFO14_20_0_,
        this_.JOB_TITLE as JOB_TITLE15_20_0_,
        this_.LANG as LANG16_20_0_,
        this_.LAST_NAME as LAST_NAME17_20_0_,
        this_.LAST_USED_RVC_ID as LAST_USED_RVC_ID18_20_0_,
        this_.MAGSTRIPE as MAGSTRIPE19_20_0_,
        this_.MAILING_OPT as MAILING_OPT20_20_0_,
        this_.MASTER_CARD_ID as MASTER_CARD_ID80_20_0_,
        this_.MAX_CHILDREN as MAX_CHILDREN21_20_0_,
        this_.MLST_SYNC_STATUS as MLST_SYNC_STATUS22_20_0_,
        this_.NOTES as NOTES23_20_0_,
        this_.PASSPORT as PASSPORT24_20_0_,
        this_.PASSWORD as PASSWORD25_20_0_,
        this_.PHONE as PHONE26_20_0_,
        this_.PROFILE_TYPE as PROFILE_TYPE27_20_0_,
        this_.RATE as RATE28_20_0_,
        this_.SECOND_NAME as SECOND_NAME29_20_0_,
        this_.SOURCE as SOURCE30_20_0_,
        this_.STREET_ADDRESS as STREET_ADDRESS31_20_0_,
        this_.TITLE as TITLE32_20_0_,
        this_.UDFD1 as UDFD33_20_0_,
        this_.UDFD10 as UDFD34_20_0_,
        this_.UDFD2 as UDFD35_20_0_,
        this_.UDFD3 as UDFD36_20_0_,
        this_.UDFD4 as UDFD37_20_0_,
        this_.UDFD5 as UDFD38_20_0_,
        this_.UDFD6 as UDFD39_20_0_,
        this_.UDFD7 as UDFD40_20_0_,
        this_.UDFD8 as UDFD41_20_0_,
        this_.UDFD9 as UDFD42_20_0_,
        this_.UDFN1 as UDFN43_20_0_,
        this_.UDFN10 as UDFN44_20_0_,
        this_.UDFN2 as UDFN45_20_0_,
        this_.UDFN3 as UDFN46_20_0_,
        this_.UDFN4 as UDFN47_20_0_,
        this_.UDFN5 as UDFN48_20_0_,
        this_.UDFN6 as UDFN49_20_0_,
        this_.UDFN7 as UDFN50_20_0_,
        this_.UDFN8 as UDFN51_20_0_,
        this_.UDFN9 as UDFN52_20_0_,
        this_.UDFS1 as UDFS53_20_0_,
        this_.UDFS10 as UDFS54_20_0_,
        this_.UDFS11 as UDFS55_20_0_,
        this_.UDFS12 as UDFS56_20_0_,
        this_.UDFS13 as UDFS57_20_0_,
        this_.UDFS14 as UDFS58_20_0_,
        this_.UDFS15 as UDFS59_20_0_,
        this_.UDFS16 as UDFS60_20_0_,
        this_.UDFS17 as UDFS61_20_0_,
        this_.UDFS18 as UDFS62_20_0_,
        this_.UDFS19 as UDFS63_20_0_,
        this_.UDFS2 as UDFS64_20_0_,
        this_.UDFS20 as UDFS65_20_0_,
        this_.UDFS3 as UDFS66_20_0_,
        this_.UDFS4 as UDFS67_20_0_,
        this_.UDFS5 as UDFS68_20_0_,
        this_.UDFS6 as UDFS69_20_0_,
        this_.UDFS7 as UDFS70_20_0_,
        this_.UDFS8 as UDFS71_20_0_,
        this_.UDFS9 as UDFS72_20_0_,
        this_.UPDATE_DATE as UPDATE_DATE73_20_0_,
        this_.UPDATE_PERSON as UPDATE_PERSON74_20_0_,
        this_.VALID_TILL as VALID_TILL75_20_0_,
        this_.VIP_STATUS as VIP_STATUS76_20_0_,
        this_.ZIP_CODE as ZIP_CODE77_20_0_
    from
        club.CARDS this_
    where
        this_.CARD_ID=?
Hibernate:
    select
        cardtype0_.CARD_TYPE_ID as CARD_TYPE_ID1_26_0_,
        cardtype0_.DEFAULT_ACCOUNT_DEF_ID as DEFAULT_ACCOUNT_D12_26_0_,
        cardtype0_.ACTIVE as ACTIVE2_26_0_,
        cardtype0_.DEFAULT_MASK as DEFAULT_MASK3_26_0_,
        cardtype0_.DEFAULT_VALIDITY_PERIOD as DEFAULT_VALIDITY_P4_26_0_,
        cardtype0_.FACILITY_ACCESS_RULESET as FACILITY_ACCESS_R13_26_0_,
        cardtype0_.MENU_LEVEL as MENU_LEVEL5_26_0_,
        cardtype0_.OPTIONS as OPTIONS6_26_0_,
        cardtype0_.PMS_LEVEL as PMS_LEVEL7_26_0_,
        cardtype0_.PMS_TYPE as PMS_TYPE8_26_0_,
        cardtype0_.RANGE_START as RANGE_START9_26_0_,
        cardtype0_.TRACK1FORMAT as TRACK10_26_0_,
        cardtype0_.TYPE_NAME as TYPE_NAME11_26_0_
    from
        club.CARD_TYPES cardtype0_
    where
        cardtype0_.CARD_TYPE_ID=?
Hibernate:
    select
        cardstatus0_.ID as ID1_25_0_,
        cardstatus0_.ACTIVED as ACTIVED2_25_0_,
        cardstatus0_.DESCRIPTION as DESCRIPTION3_25_0_
    from
        club.CARD_STATUS cardstatus0_
    where
        cardstatus0_.ID=?
15.08.16 17:06:23:658 - INFO - PostPaymentHelper - Card: 1260 Герасименко Александр [Гость, Активна]
Hibernate:
    select
        site0_.SITE_ID as SITE_ID1_107_,
        site0_.AUTOSTART as AUTOSTART2_107_,
        site0_.DB_SYNC as DB_SYNC3_107_,
        site0_.TP as TP4_107_,
        site0_.GI as GI5_107_,
        site0_.HTNG as HTNG6_107_,
        site0_.INQ_TM as INQ_TM7_107_,
        site0_.IP as IP8_107_,
        site0_.LOCATION as LOCATION9_107_,
        site0_.NAME as NAME10_107_,
        site0_.OPTIONS as OPTIONS11_107_,
        site0_.PMS_PROPERTY as PMS_PROPERTY12_107_,
        site0_.PORT as PORT13_107_,
        site0_.SITE_KEY as SITE_KEY14_107_,
        site0_.SVC_TAX_CLASS_ID as SVC_TAX_CLASS_ID16_107_,
        site0_.V8IFC as V15_107_
    from
        club.SITES site0_
    where
        (
            upper(site0_.SITE_KEY)=?
        )
Hibernate:
    select
        rvc0_.RVC_ID as RVC_ID1_97_,
        rvc0_.BUSSINES_DATE_START as BUSSINES_DATE_STAR2_97_,
        rvc0_.LAST_CHECK_NUM as LAST_CHECK_NUM3_97_,
        rvc0_.NAME as NAME4_97_,
        rvc0_.OPTIONS as OPTIONS5_97_,
        rvc0_.POS_RVC as POS_RVC6_97_,
        rvc0_.REG_RVC_GROUP_ID as REG_RVC_GROUP_ID11_97_,
        rvc0_.SALE_STORE_ID as SALE_STORE_ID12_97_,
        rvc0_.SITE_ID as SITE_ID13_97_,
        rvc0_.TIME_ZONE as TIME_ZONE14_97_,
        rvc0_.TREAT_STORE_ID as TREAT_STORE_ID15_97_,
        rvc0_.WEB_BOOK_ENABLE as WEB_BOOK_ENABLE7_97_,
        rvc0_.WEB_PAYM_DRIVER as WEB_PAYM_DRIVER8_97_,
        rvc0_.WEB_PAYM_KEY as WEB_PAYM_KEY9_97_,
        rvc0_.WEB_PAYM_URL as WEB_PAYM_URL10_97_,
        rvc0_.NAME || ' (' || rvc0_.RVC_ID || ')' as formula4_
    from
        club.RVC rvc0_
    where
        (
            rvc0_.POS_RVC=?
        )
        and(
            rvc0_.SITE_ID=?
        )
Hibernate:
    select
        timezone0_.ID as ID1_131_0_,
        timezone0_.NAME as NAME2_131_0_
    from
        club.TIME_ZONE timezone0_
    where
        timezone0_.ID=?
15.08.16 17:06:23:658 - INFO - PostPaymentHelper - current time: Mon Aug 15 17:06:23 GST 2016
15.08.16 17:06:23:658 - INFO - PostPaymentHelper - business time: Mon Aug 15 00:00:00 GST 2016
Hibernate:
    select
        doc0_.DOC_ID as DOC_ID1_42_0_,
        doc0_.BUSSINES_DATE as BUSSINES_DATE2_42_0_,
        doc0_.DEF_CARD_ID as DEF_CARD_ID3_42_0_,
        doc0_.DEF_CARD_TYPE_ID as DEF_CARD_TYPE_ID4_42_0_,
        doc0_.CHCK_ID as CHCK_ID5_42_0_,
        doc0_.CHECK_OPEN as CHECK_OPEN6_42_0_,
        doc0_.CHKNUM as CHKNUM7_42_0_,
        doc0_.COFIRMATION as COFIRMATION8_42_0_,
        doc0_.DOC_TYPE as DOC_TYPE9_42_0_,
        doc0_.GST as GST10_42_0_,
        doc0_.IMAGE as IMAGE11_42_0_,
        doc0_.INVOICE_ID as INVOICE_ID20_42_0_,
        doc0_.DEF_MAGSTRIPE as DEF_MAGSTRIPE12_42_0_,
        doc0_.OPERATOR as OPERATOR13_42_0_,
        doc0_.REGISTRATION_ID as REGISTRATION_ID21_42_0_,
        doc0_.RVC as RVC22_42_0_,
        doc0_.SP as SP14_42_0_,
        doc0_.TAX_EXEMPT as TAX_EXEMPT15_42_0_,
        doc0_.TM as TM16_42_0_,
        doc0_.TM_OPEN as TM_OPEN17_42_0_,
        doc0_.TTL as TTL18_42_0_,
        doc0_.VER as VER19_42_0_
    from
        club.DOCS doc0_
    where
        doc0_.DOC_ID=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
15.08.16 17:06:23:658 - INFO - PostPaymentHelper - Doc: Docs [DOC_ID: 4694, chk#: 0261, amount: 57.0]
15.08.16 17:06:23:658 - INFO - PostPaymentHelper - PMS key number: null
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
15.08.16 17:06:23:658 - INFO - PostPaymentHelper - Partial payment allowed: false
Hibernate:
    select
        docdtl0_.DOC_ID as DOC_ID28_44_,
        docdtl0_.DTL_SEQ as DTL_SEQ1_44_,
        docdtl0_.MI_SEQ as MI_SEQ2_44_,
        docdtl0_.BOOKING_ID as BOOKING_ID3_44_,
        docdtl0_.CASHIER_SHIFT_ID as CASHIER_SHIFT_ID4_44_,
        docdtl0_.COUNT as COUNT5_44_,
        docdtl0_.DSC as DSC6_44_,
        docdtl0_.DSC_REASON as DSC_REASON7_44_,
        docdtl0_.FGRP as FGRP8_44_,
        docdtl0_.MANUAL_SVC as MANUAL_SVC9_44_,
        docdtl0_.MANUAL_DSC as MANUAL_DSC10_44_,
        docdtl0_.MI_ID as MI_ID11_44_,
        docdtl0_.NAME as NAME12_44_,
        docdtl0_.POSTING_EMPL_ID as POSTING_EMPL_ID13_44_,
        docdtl0_.PAY_TTL_DEPOSIT as PAY_TTL_DEPOSIT14_44_,
        docdtl0_.PAY_TTL_SUBSCR as PAY_TTL_SUBSCR15_44_,
        docdtl0_.POINTS as POINTS16_44_,
        docdtl0_.REFERENCE as REFERENCE17_44_,
        docdtl0_.COMISSION_EMPL_ID as COMISSION_EMPL_ID18_44_,
        docdtl0_.SI as SI19_44_,
        docdtl0_.TAX_ADD as TAX_ADD20_44_,
        docdtl0_.TAX_ADDON as TAX_ADDON21_44_,
        docdtl0_.TAX_VAT as TAX_VAT22_44_,
        docdtl0_.TICKETS as TICKETS23_44_,
        docdtl0_.TM as TM24_44_,
        docdtl0_.TTL as TTL25_44_,
        docdtl0_.VOID_FLAG as VOID_FLAG26_44_,
        docdtl0_.VOID_REASON as VOID_REASON27_44_
    from
        club.DOCS_DTL docdtl0_
    where
        (
            DOC_ID=?
        )
15.08.16 17:06:23:658 - INFO - PostPaymentHelper - calc sum: 57.0
15.08.16 17:06:23:673 - INFO - PostPaymentHelper$CalcHelper - pricePerItem: 57.00
15.08.16 17:06:23:674 - INFO - PostPaymentHelper - extPay: 0.0
Hibernate:
    select
        MAX(accounting0_.SEQ) as col_0_0_
    from
        club.ACCOUNTING accounting0_
    where
        (
            accounting0_.DOC_ID=?
        )
Hibernate:
    select
        accountdef0_.ACCOUNT_DEF_ID as ACCOUNT_DEF_ID1_2_0_,
        accountdef0_.ACCOUNT_CODE as ACCOUNT_CODE2_2_0_,
        accountdef0_.ACCOUNT_TYPE as ACCOUNT_TYPE3_2_0_,
        accountdef0_.AUTO_RENEW as AUTO_RENEW4_2_0_,
        accountdef0_.TASK_TYPE_ID as TASK_TYPE_ID10_2_0_,
        accountdef0_.CURRENCY_ID as CURRENCY_ID11_2_0_,
        accountdef0_.EXPIRATION as EXPIRATION5_2_0_,
        accountdef0_.NAME as NAME6_2_0_,
        accountdef0_.ORDR as ORDR7_2_0_,
        accountdef0_.POINTS_RATE as POINTS_RATE8_2_0_,
        accountdef0_.POINTS_ROUNDING as POINTS_ROUNDING9_2_0_,
        accountdef0_.RULESET_ID as RULESET_ID12_2_0_,
        accountdef0_.ACCOUNT_CODE || ' ' || accountdef0_.NAME as formula0_0_
    from
        club.ACCOUNT_DEF accountdef0_
    where
        accountdef0_.ACCOUNT_DEF_ID=?
Hibernate:
    select
        accounting0_.ID as ID1_1_,
        accounting0_.ACCOUNT_DEF_ID as ACCOUNT_DEF_ID7_1_,
        accounting0_.AMOUNT as AMOUNT2_1_,
        accounting0_.CARD_ID as CARD_ID3_1_,
        accounting0_.CRD_TTL as CRD_TTL4_1_,
        accounting0_.LAST_EXPIRY as LAST_EXPIRY5_1_,
        accounting0_.LOAN as LOAN6_1_
    from
        club.ACCOUNTING_BALANCE accounting0_,
        club.ACCOUNT_DEF accountdef1_
    where
        (
            accounting0_.CARD_ID=?
        )
        AND(
            accountdef1_.ACCOUNT_CODE=?
            and accounting0_.ACCOUNT_DEF_ID=accountdef1_.ACCOUNT_DEF_ID
        )
Hibernate:
    select
        SUM(accounting0_.AMOUNT) as col_0_0_
    from
        club.ACCOUNTING accounting0_,
        club.ACCOUNT_DEF accountdef1_
    where
        (
            accounting0_.CARD_ID=?
        )
        AND(
            accounting0_.DOC_ID=?
        )
        AND(
            accountdef1_.ACCOUNT_CODE=?
            and accounting0_.ACCOUNT_DEF_ID=accountdef1_.ACCOUNT_DEF_ID
        )
    group by
        accounting0_.CARD_ID ,
        accounting0_.DOC_ID ,
        accountdef1_.ACCOUNT_DEF_ID
15.08.16 17:06:23:680 - INFO - PostPaymentHelper - acquireSum before: 57.0
Hibernate:
    select
        cardtypesa0_.CARD_TYPES_ACCOUNTS_ID as CARD_TYPES_ACCOUNT1_27_,
        cardtypesa0_.ACCOUNT_DEF_ID as ACCOUNT_DEF_ID5_27_,
        cardtypesa0_.CARD_TYPE_ID as CARD_TYPE_ID6_27_,
        cardtypesa0_.CREDIT_LIMIT as CREDIT_LIMIT2_27_,
        cardtypesa0_.PAYMENT_LIMIT as PAYMENT_LIMIT3_27_,
        cardtypesa0_.PRIORITY as PRIORITY4_27_
    from
        club.CARD_TYPES_ACCOUNTS cardtypesa0_
    where
        (
            cardtypesa0_.CARD_TYPE_ID=?
        )
    order by
        cardtypesa0_.PRIORITY
Hibernate:
    select
        accountdef0_.ACCOUNT_DEF_ID as ACCOUNT_DEF_ID1_2_0_,
        accountdef0_.ACCOUNT_CODE as ACCOUNT_CODE2_2_0_,
        accountdef0_.ACCOUNT_TYPE as ACCOUNT_TYPE3_2_0_,
        accountdef0_.AUTO_RENEW as AUTO_RENEW4_2_0_,
        accountdef0_.TASK_TYPE_ID as TASK_TYPE_ID10_2_0_,
        accountdef0_.CURRENCY_ID as CURRENCY_ID11_2_0_,
        accountdef0_.EXPIRATION as EXPIRATION5_2_0_,
        accountdef0_.NAME as NAME6_2_0_,
        accountdef0_.ORDR as ORDR7_2_0_,
        accountdef0_.POINTS_RATE as POINTS_RATE8_2_0_,
        accountdef0_.POINTS_ROUNDING as POINTS_ROUNDING9_2_0_,
        accountdef0_.RULESET_ID as RULESET_ID12_2_0_,
        accountdef0_.ACCOUNT_CODE || ' ' || accountdef0_.NAME as formula0_0_
    from
        club.ACCOUNT_DEF accountdef0_
    where
        accountdef0_.ACCOUNT_DEF_ID=?
Hibernate:
    select
        this_.ID as ID1_1_1_,
        this_.ACCOUNT_DEF_ID as ACCOUNT_DEF_ID7_1_1_,
        this_.AMOUNT as AMOUNT2_1_1_,
        this_.CARD_ID as CARD_ID3_1_1_,
        this_.CRD_TTL as CRD_TTL4_1_1_,
        this_.LAST_EXPIRY as LAST_EXPIRY5_1_1_,
        this_.LOAN as LOAN6_1_1_,
        accountdef2_.ACCOUNT_DEF_ID as ACCOUNT_DEF_ID1_2_0_,
        accountdef2_.ACCOUNT_CODE as ACCOUNT_CODE2_2_0_,
        accountdef2_.ACCOUNT_TYPE as ACCOUNT_TYPE3_2_0_,
        accountdef2_.AUTO_RENEW as AUTO_RENEW4_2_0_,
        accountdef2_.TASK_TYPE_ID as TASK_TYPE_ID10_2_0_,
        accountdef2_.CURRENCY_ID as CURRENCY_ID11_2_0_,
        accountdef2_.EXPIRATION as EXPIRATION5_2_0_,
        accountdef2_.NAME as NAME6_2_0_,
        accountdef2_.ORDR as ORDR7_2_0_,
        accountdef2_.POINTS_RATE as POINTS_RATE8_2_0_,
        accountdef2_.POINTS_ROUNDING as POINTS_ROUNDING9_2_0_,
        accountdef2_.RULESET_ID as RULESET_ID12_2_0_,
        accountdef2_.ACCOUNT_CODE || ' ' || accountdef2_.NAME as formula0_0_
    from
        club.ACCOUNTING_BALANCE this_
    inner join
        club.ACCOUNT_DEF accountdef2_
            on this_.ACCOUNT_DEF_ID=accountdef2_.ACCOUNT_DEF_ID
    where
        this_.CARD_ID=?
        and this_.ACCOUNT_DEF_ID=?
15.08.16 17:06:23:685 - INFO - PostPaymentHelper - master accountingBalance: null
15.08.16 17:06:23:685 - INFO - PostPaymentHelper - AccountingBalances: [Balance [cardId: 1260, accountDef: null, amount: 2933.5, loan: 0.0]]
15.08.16 17:06:23:686 - INFO - PostPaymentHelper - Master card exist: false
Hibernate:
    select
        voucher0_.VOUCHER_ID as VOUCHER_ID1_135_,
        voucher0_.CODE as CODE2_135_,
        voucher0_.CREATED_PERSON as CREATED_PERSON3_135_,
        voucher0_.CREATED_TM as CREATED_TM4_135_,
        voucher0_.DSC as DSC5_135_,
        voucher0_.ITEMS as ITEMS6_135_,
        voucher0_.LINK_CARD_ID as LINK_CARD_ID16_135_,
        voucher0_.LINK_DATE as LINK_DATE7_135_,
        voucher0_.LINK_EMPL as LINK_EMPL8_135_,
        voucher0_.LOCK_PERSON as LOCK_PERSON9_135_,
        voucher0_.LOCK_REASON as LOCK_REASON10_135_,
        voucher0_.LOCK_TM as LOCK_TM11_135_,
        voucher0_.SUBSCRIPTION_ACCOUNTING_ID as SUBSCRIPTION_ACCO17_135_,
        voucher0_.USE_COUNT as USE_COUNT12_135_,
        voucher0_.VALID_FROM as VALID_FROM13_135_,
        voucher0_.VALID_TILL as VALID_TILL14_135_,
        voucher0_.VALUE_BALANCE as VALUE_BALANCE15_135_,
        voucher0_.VOUCHER_CAMPAIGN_ID as VOUCHER_CAMPAIGN_18_135_
    from
        club.VOUCHER voucher0_
    where
        (
            UPPER(voucher0_.CODE)LIKE ?
        )
Hibernate:
    select
        vouchercam0_.VOUCHER_CAMPAIGN_ID as VOUCHER_CAMPAIGN_I1_137_0_,
        vouchercam0_.BONUS as BONUS2_137_0_,
        vouchercam0_.BONUS_TYPE as BONUS_TYPE3_137_0_,
        vouchercam0_.CODE_LEN as CODE_LEN4_137_0_,
        vouchercam0_.CODE_TYPE as CODE_TYPE5_137_0_,
        vouchercam0_.CREATED_PERSON as CREATED_PERSON6_137_0_,
        vouchercam0_.CREATED_TM as CREATED_TM7_137_0_,
        vouchercam0_.DEFAULT_VALIDITY as DEFAULT_VALIDITY8_137_0_,
        vouchercam0_.HIERARCHY_ID as HIERARCHY_ID19_137_0_,
        vouchercam0_.ITEMS as ITEMS9_137_0_,
        vouchercam0_.MAX_USE_COUNT as MAX_USE_COUNT10_137_0_,
        vouchercam0_.NAME as NAME11_137_0_,
        vouchercam0_.PREFIX as PREFIX12_137_0_,
        vouchercam0_.RANGE_FROM as RANGE_FROM13_137_0_,
        vouchercam0_.RANGE_TILL as RANGE_TILL14_137_0_,
        vouchercam0_.DSC_RULSET_ID as DSC_RULSET_ID20_137_0_,
        vouchercam0_.TYPE as TYPE15_137_0_,
        vouchercam0_.UPDATE_PERSON as UPDATE_PERSON16_137_0_,
        vouchercam0_.UPDATE_TM as UPDATE_TM17_137_0_,
        vouchercam0_.VALUE as VALUE18_137_0_
    from
        club.VOUCHER_CAMPAIGN vouchercam0_
    where
        vouchercam0_.VOUCHER_CAMPAIGN_ID=?
Hibernate:
    select
        dictionary0_.HIERARCHY_ID as HIERARCHY_ID1_41_0_,
        dictionary0_.NAME as NAME2_41_0_,
        dictionary0_.PARENT_ID as PARENT_ID3_41_0_,
        dictionary1_.HIERARCHY_ID as HIERARCHY_ID1_41_1_,
        dictionary1_.NAME as NAME2_41_1_,
        dictionary1_.PARENT_ID as PARENT_ID3_41_1_
    from
        club.DICTIONARY_HIERARCHY dictionary0_
    left outer join
        club.DICTIONARY_HIERARCHY dictionary1_
            on dictionary0_.PARENT_ID=dictionary1_.HIERARCHY_ID
    where
        dictionary0_.HIERARCHY_ID=?
15.08.16 17:06:23:690 - INFO - PostPaymentHelper - Voucher: Voucher{voucherId=43, voucherCampaign=ru.hrs.lassd.club.vo.VoucherCampaign@6962237e, code='505450515553', useCount=1, valueBalance=3000.0, dsc=0.0, validFrom=2016-08-15, validTill=2016-08-16, lockTm=null, lockReason='null', lockPerson='null', createdTm=2016-08-15 15:38:44.19, createdPerson='mag'}
15.08.16 17:06:23:691 - INFO - PostPaymentHelper - accBalance: Balance [cardId: 0, accountDef: null, amount: 3000.0, loan: 0.0]
15.08.16 17:06:23:691 - INFO - PostPaymentHelper - No ruleset way
15.08.16 17:06:23:691 - INFO - PostPaymentHelper - menuItem: 100248 Аллергопанель 20 аллергенов qty:1 amnt:57.0
15.08.16 17:06:23:691 - INFO - PostPaymentHelper - cnt: 1
15.08.16 17:06:23:692 - INFO - PostPaymentHelper - accBalance before: 3000.0
15.08.16 17:06:23:692 - INFO - PostPaymentHelper - VALUE = 57.0
15.08.16 17:06:23:692 - INFO - PostPaymentHelper - acquireSum: 0.0
15.08.16 17:06:23:692 - INFO - PostPaymentHelper - accBalance after: 2943.0
15.08.16 17:06:23:692 - INFO - PostPaymentHelper - remains for item 0, 0.0
Hibernate:
    select
        club.VOUCHER_ACCOUNTING_SEQ.nextval
    from
        dual
15.08.16 17:06:23:697 - INFO - PostPaymentHelper - acquireSum after: 0.00
15.08.16 17:06:23:697 - INFO - PostPaymentHelper - payAmount: 57.00
15.08.16 17:06:23:698 - INFO - PostPaymentHelper - result: 57.00
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
15.08.16 17:06:23:699 - INFO - PostPaymentHelper - !!!!!!!!!!!!!!!! saveDocDtl
15.08.16 17:06:23:699 - INFO - PostPaymentHelper - size: 1
Hibernate:
    select
        docdtl0_.DOC_ID as DOC_ID28_44_,
        docdtl0_.DTL_SEQ as DTL_SEQ1_44_,
        docdtl0_.MI_SEQ as MI_SEQ2_44_,
        docdtl0_.BOOKING_ID as BOOKING_ID3_44_,
        docdtl0_.CASHIER_SHIFT_ID as CASHIER_SHIFT_ID4_44_,
        docdtl0_.COUNT as COUNT5_44_,
        docdtl0_.DSC as DSC6_44_,
        docdtl0_.DSC_REASON as DSC_REASON7_44_,
        docdtl0_.FGRP as FGRP8_44_,
        docdtl0_.MANUAL_SVC as MANUAL_SVC9_44_,
        docdtl0_.MANUAL_DSC as MANUAL_DSC10_44_,
        docdtl0_.MI_ID as MI_ID11_44_,
        docdtl0_.NAME as NAME12_44_,
        docdtl0_.POSTING_EMPL_ID as POSTING_EMPL_ID13_44_,
        docdtl0_.PAY_TTL_DEPOSIT as PAY_TTL_DEPOSIT14_44_,
        docdtl0_.PAY_TTL_SUBSCR as PAY_TTL_SUBSCR15_44_,
        docdtl0_.POINTS as POINTS16_44_,
        docdtl0_.REFERENCE as REFERENCE17_44_,
        docdtl0_.COMISSION_EMPL_ID as COMISSION_EMPL_ID18_44_,
        docdtl0_.SI as SI19_44_,
        docdtl0_.TAX_ADD as TAX_ADD20_44_,
        docdtl0_.TAX_ADDON as TAX_ADDON21_44_,
        docdtl0_.TAX_VAT as TAX_VAT22_44_,
        docdtl0_.TICKETS as TICKETS23_44_,
        docdtl0_.TM as TM24_44_,
        docdtl0_.TTL as TTL25_44_,
        docdtl0_.VOID_FLAG as VOID_FLAG26_44_,
        docdtl0_.VOID_REASON as VOID_REASON27_44_
    from
        club.DOCS_DTL docdtl0_
    where
        (
            DOC_ID=?
        )
15.08.16 17:06:23:701 - INFO - PostPaymentHelper - ****** PostPaymentHelper end ******
15.08.16 17:06:23:702 - INFO - PostPaymentHelper - ***********************************
Hibernate:
    insert
    into
        club.VOUCHER_ACCOUNTING
        (DOC_ID, DSC, VALUE, VOUCHER_ID, VOUCHER_ACCOUNTING_ID)
    values
        (?, ?, ?, ?, ?)
Hibernate:
    update
        club.VOUCHER
    set
        CODE=?,
        CREATED_PERSON=?,
        CREATED_TM=?,
        DSC=?,
        ITEMS=?,
        LINK_CARD_ID=?,
        LINK_DATE=?,
        LINK_EMPL=?,
        LOCK_PERSON=?,
        LOCK_REASON=?,
        LOCK_TM=?,
        SUBSCRIPTION_ACCOUNTING_ID=?,
        USE_COUNT=?,
        VALID_FROM=?,
        VALID_TILL=?,
        VALUE_BALANCE=?,
        VOUCHER_CAMPAIGN_ID=?
    where
        VOUCHER_ID=?
15.08.16 17:06:23:727 - INFO - CardInfo - Infolines URL:  http://localhost:8085//cardinfo/info.jsp?cardId=1260&templName=PAYMENT&docId=4694&email=0&extra=1260&body=
Hibernate:
    select
        this_.ID as ID1_29_2_,
        this_.CARD_ID as CARD_ID4_29_2_,
        this_.CARD_TYPE_ID as CARD_TYPE_ID5_29_2_,
        this_.MAGSTRIPE as MAGSTRIPE2_29_2_,
        this_.VALID_TILL as VALID_TILL3_29_2_,
        card2_.CARD_ID as CARD_ID1_20_0_,
        card2_.IS_ARCHIVED as IS_ARCHIVED2_20_0_,
        card2_.BIRTH_DATE as BIRTH_DATE3_20_0_,
        card2_.CARD_STATUS_ID as CARD_STATUS_ID78_20_0_,
        card2_.CARD_TYPE_ID as CARD_TYPE_ID79_20_0_,
        card2_.CELL_PHONE as CELL_PHONE4_20_0_,
        card2_.CITY as CITY5_20_0_,
        card2_.COMPANY as COMPANY6_20_0_,
        card2_.COUNTRY as COUNTRY7_20_0_,
        card2_.CREATED_DATE as CREATED_DATE8_20_0_,
        card2_.CREATED_PERSON as CREATED_PERSON9_20_0_,
        card2_.EMAIL as EMAIL10_20_0_,
        card2_.FIRST_NAME as FIRST_NAME11_20_0_,
        card2_.GENDER as GENDER12_20_0_,
        card2_.GREETING as GREETING13_20_0_,
        card2_.HEALTH_INFO as HEALTH_INFO14_20_0_,
        card2_.JOB_TITLE as JOB_TITLE15_20_0_,
        card2_.LANG as LANG16_20_0_,
        card2_.LAST_NAME as LAST_NAME17_20_0_,
        card2_.LAST_USED_RVC_ID as LAST_USED_RVC_ID18_20_0_,
        card2_.MAGSTRIPE as MAGSTRIPE19_20_0_,
        card2_.MAILING_OPT as MAILING_OPT20_20_0_,
        card2_.MASTER_CARD_ID as MASTER_CARD_ID80_20_0_,
        card2_.MAX_CHILDREN as MAX_CHILDREN21_20_0_,
        card2_.MLST_SYNC_STATUS as MLST_SYNC_STATUS22_20_0_,
        card2_.NOTES as NOTES23_20_0_,
        card2_.PASSPORT as PASSPORT24_20_0_,
        card2_.PASSWORD as PASSWORD25_20_0_,
        card2_.PHONE as PHONE26_20_0_,
        card2_.PROFILE_TYPE as PROFILE_TYPE27_20_0_,
        card2_.RATE as RATE28_20_0_,
        card2_.SECOND_NAME as SECOND_NAME29_20_0_,
        card2_.SOURCE as SOURCE30_20_0_,
        card2_.STREET_ADDRESS as STREET_ADDRESS31_20_0_,
        card2_.TITLE as TITLE32_20_0_,
        card2_.UDFD1 as UDFD33_20_0_,
        card2_.UDFD10 as UDFD34_20_0_,
        card2_.UDFD2 as UDFD35_20_0_,
        card2_.UDFD3 as UDFD36_20_0_,
        card2_.UDFD4 as UDFD37_20_0_,
        card2_.UDFD5 as UDFD38_20_0_,
        card2_.UDFD6 as UDFD39_20_0_,
        card2_.UDFD7 as UDFD40_20_0_,
        card2_.UDFD8 as UDFD41_20_0_,
        card2_.UDFD9 as UDFD42_20_0_,
        card2_.UDFN1 as UDFN43_20_0_,
        card2_.UDFN10 as UDFN44_20_0_,
        card2_.UDFN2 as UDFN45_20_0_,
        card2_.UDFN3 as UDFN46_20_0_,
        card2_.UDFN4 as UDFN47_20_0_,
        card2_.UDFN5 as UDFN48_20_0_,
        card2_.UDFN6 as UDFN49_20_0_,
        card2_.UDFN7 as UDFN50_20_0_,
        card2_.UDFN8 as UDFN51_20_0_,
        card2_.UDFN9 as UDFN52_20_0_,
        card2_.UDFS1 as UDFS53_20_0_,
        card2_.UDFS10 as UDFS54_20_0_,
        card2_.UDFS11 as UDFS55_20_0_,
        card2_.UDFS12 as UDFS56_20_0_,
        card2_.UDFS13 as UDFS57_20_0_,
        card2_.UDFS14 as UDFS58_20_0_,
        card2_.UDFS15 as UDFS59_20_0_,
        card2_.UDFS16 as UDFS60_20_0_,
        card2_.UDFS17 as UDFS61_20_0_,
        card2_.UDFS18 as UDFS62_20_0_,
        card2_.UDFS19 as UDFS63_20_0_,
        card2_.UDFS2 as UDFS64_20_0_,
        card2_.UDFS20 as UDFS65_20_0_,
        card2_.UDFS3 as UDFS66_20_0_,
        card2_.UDFS4 as UDFS67_20_0_,
        card2_.UDFS5 as UDFS68_20_0_,
        card2_.UDFS6 as UDFS69_20_0_,
        card2_.UDFS7 as UDFS70_20_0_,
        card2_.UDFS8 as UDFS71_20_0_,
        card2_.UDFS9 as UDFS72_20_0_,
        card2_.UPDATE_DATE as UPDATE_DATE73_20_0_,
        card2_.UPDATE_PERSON as UPDATE_PERSON74_20_0_,
        card2_.VALID_TILL as VALID_TILL75_20_0_,
        card2_.VIP_STATUS as VIP_STATUS76_20_0_,
        card2_.ZIP_CODE as ZIP_CODE77_20_0_,
        cardtype3_.CARD_TYPE_ID as CARD_TYPE_ID1_26_1_,
        cardtype3_.DEFAULT_ACCOUNT_DEF_ID as DEFAULT_ACCOUNT_D12_26_1_,
        cardtype3_.ACTIVE as ACTIVE2_26_1_,
        cardtype3_.DEFAULT_MASK as DEFAULT_MASK3_26_1_,
        cardtype3_.DEFAULT_VALIDITY_PERIOD as DEFAULT_VALIDITY_P4_26_1_,
        cardtype3_.FACILITY_ACCESS_RULESET as FACILITY_ACCESS_R13_26_1_,
        cardtype3_.MENU_LEVEL as MENU_LEVEL5_26_1_,
        cardtype3_.OPTIONS as OPTIONS6_26_1_,
        cardtype3_.PMS_LEVEL as PMS_LEVEL7_26_1_,
        cardtype3_.PMS_TYPE as PMS_TYPE8_26_1_,
        cardtype3_.RANGE_START as RANGE_START9_26_1_,
        cardtype3_.TRACK1FORMAT as TRACK10_26_1_,
        cardtype3_.TYPE_NAME as TYPE_NAME11_26_1_
    from
        club.CARD_XTRA this_
    inner join
        club.CARDS card2_
            on this_.CARD_ID=card2_.CARD_ID
    inner join
        club.CARD_TYPES cardtype3_
            on this_.CARD_TYPE_ID=cardtype3_.CARD_TYPE_ID
    where
        this_.MAGSTRIPE=?
Hibernate:
    select
        card0_.CARD_ID as CARD_ID1_20_0_,
        card0_.IS_ARCHIVED as IS_ARCHIVED2_20_0_,
        card0_.BIRTH_DATE as BIRTH_DATE3_20_0_,
        card0_.CARD_STATUS_ID as CARD_STATUS_ID78_20_0_,
        card0_.CARD_TYPE_ID as CARD_TYPE_ID79_20_0_,
        card0_.CELL_PHONE as CELL_PHONE4_20_0_,
        card0_.CITY as CITY5_20_0_,
        card0_.COMPANY as COMPANY6_20_0_,
        card0_.COUNTRY as COUNTRY7_20_0_,
        card0_.CREATED_DATE as CREATED_DATE8_20_0_,
        card0_.CREATED_PERSON as CREATED_PERSON9_20_0_,
        card0_.EMAIL as EMAIL10_20_0_,
        card0_.FIRST_NAME as FIRST_NAME11_20_0_,
        card0_.GENDER as GENDER12_20_0_,
        card0_.GREETING as GREETING13_20_0_,
        card0_.HEALTH_INFO as HEALTH_INFO14_20_0_,
        card0_.JOB_TITLE as JOB_TITLE15_20_0_,
        card0_.LANG as LANG16_20_0_,
        card0_.LAST_NAME as LAST_NAME17_20_0_,
        card0_.LAST_USED_RVC_ID as LAST_USED_RVC_ID18_20_0_,
        card0_.MAGSTRIPE as MAGSTRIPE19_20_0_,
        card0_.MAILING_OPT as MAILING_OPT20_20_0_,
        card0_.MASTER_CARD_ID as MASTER_CARD_ID80_20_0_,
        card0_.MAX_CHILDREN as MAX_CHILDREN21_20_0_,
        card0_.MLST_SYNC_STATUS as MLST_SYNC_STATUS22_20_0_,
        card0_.NOTES as NOTES23_20_0_,
        card0_.PASSPORT as PASSPORT24_20_0_,
        card0_.PASSWORD as PASSWORD25_20_0_,
        card0_.PHONE as PHONE26_20_0_,
        card0_.PROFILE_TYPE as PROFILE_TYPE27_20_0_,
        card0_.RATE as RATE28_20_0_,
        card0_.SECOND_NAME as SECOND_NAME29_20_0_,
        card0_.SOURCE as SOURCE30_20_0_,
        card0_.STREET_ADDRESS as STREET_ADDRESS31_20_0_,
        card0_.TITLE as TITLE32_20_0_,
        card0_.UDFD1 as UDFD33_20_0_,
        card0_.UDFD10 as UDFD34_20_0_,
        card0_.UDFD2 as UDFD35_20_0_,
        card0_.UDFD3 as UDFD36_20_0_,
        card0_.UDFD4 as UDFD37_20_0_,
        card0_.UDFD5 as UDFD38_20_0_,
        card0_.UDFD6 as UDFD39_20_0_,
        card0_.UDFD7 as UDFD40_20_0_,
        card0_.UDFD8 as UDFD41_20_0_,
        card0_.UDFD9 as UDFD42_20_0_,
        card0_.UDFN1 as UDFN43_20_0_,
        card0_.UDFN10 as UDFN44_20_0_,
        card0_.UDFN2 as UDFN45_20_0_,
        card0_.UDFN3 as UDFN46_20_0_,
        card0_.UDFN4 as UDFN47_20_0_,
        card0_.UDFN5 as UDFN48_20_0_,
        card0_.UDFN6 as UDFN49_20_0_,
        card0_.UDFN7 as UDFN50_20_0_,
        card0_.UDFN8 as UDFN51_20_0_,
        card0_.UDFN9 as UDFN52_20_0_,
        card0_.UDFS1 as UDFS53_20_0_,
        card0_.UDFS10 as UDFS54_20_0_,
        card0_.UDFS11 as UDFS55_20_0_,
        card0_.UDFS12 as UDFS56_20_0_,
        card0_.UDFS13 as UDFS57_20_0_,
        card0_.UDFS14 as UDFS58_20_0_,
        card0_.UDFS15 as UDFS59_20_0_,
        card0_.UDFS16 as UDFS60_20_0_,
        card0_.UDFS17 as UDFS61_20_0_,
        card0_.UDFS18 as UDFS62_20_0_,
        card0_.UDFS19 as UDFS63_20_0_,
        card0_.UDFS2 as UDFS64_20_0_,
        card0_.UDFS20 as UDFS65_20_0_,
        card0_.UDFS3 as UDFS66_20_0_,
        card0_.UDFS4 as UDFS67_20_0_,
        card0_.UDFS5 as UDFS68_20_0_,
        card0_.UDFS6 as UDFS69_20_0_,
        card0_.UDFS7 as UDFS70_20_0_,
        card0_.UDFS8 as UDFS71_20_0_,
        card0_.UDFS9 as UDFS72_20_0_,
        card0_.UPDATE_DATE as UPDATE_DATE73_20_0_,
        card0_.UPDATE_PERSON as UPDATE_PERSON74_20_0_,
        card0_.VALID_TILL as VALID_TILL75_20_0_,
        card0_.VIP_STATUS as VIP_STATUS76_20_0_,
        card0_.ZIP_CODE as ZIP_CODE77_20_0_
    from
        club.CARDS card0_
    where
        card0_.CARD_ID=?
Hibernate:
    select
        doc0_.DOC_ID as DOC_ID1_42_0_,
        doc0_.BUSSINES_DATE as BUSSINES_DATE2_42_0_,
        doc0_.DEF_CARD_ID as DEF_CARD_ID3_42_0_,
        doc0_.DEF_CARD_TYPE_ID as DEF_CARD_TYPE_ID4_42_0_,
        doc0_.CHCK_ID as CHCK_ID5_42_0_,
        doc0_.CHECK_OPEN as CHECK_OPEN6_42_0_,
        doc0_.CHKNUM as CHKNUM7_42_0_,
        doc0_.COFIRMATION as COFIRMATION8_42_0_,
        doc0_.DOC_TYPE as DOC_TYPE9_42_0_,
        doc0_.GST as GST10_42_0_,
        doc0_.IMAGE as IMAGE11_42_0_,
        doc0_.INVOICE_ID as INVOICE_ID20_42_0_,
        doc0_.DEF_MAGSTRIPE as DEF_MAGSTRIPE12_42_0_,
        doc0_.OPERATOR as OPERATOR13_42_0_,
        doc0_.REGISTRATION_ID as REGISTRATION_ID21_42_0_,
        doc0_.RVC as RVC22_42_0_,
        doc0_.SP as SP14_42_0_,
        doc0_.TAX_EXEMPT as TAX_EXEMPT15_42_0_,
        doc0_.TM as TM16_42_0_,
        doc0_.TM_OPEN as TM_OPEN17_42_0_,
        doc0_.TTL as TTL18_42_0_,
        doc0_.VER as VER19_42_0_
    from
        club.DOCS doc0_
    where
        doc0_.DOC_ID=?
Hibernate:
    select
        docdtl0_.DOC_ID as DOC_ID28_44_,
        docdtl0_.DTL_SEQ as DTL_SEQ1_44_,
        docdtl0_.MI_SEQ as MI_SEQ2_44_,
        docdtl0_.BOOKING_ID as BOOKING_ID3_44_,
        docdtl0_.CASHIER_SHIFT_ID as CASHIER_SHIFT_ID4_44_,
        docdtl0_.COUNT as COUNT5_44_,
        docdtl0_.DSC as DSC6_44_,
        docdtl0_.DSC_REASON as DSC_REASON7_44_,
        docdtl0_.FGRP as FGRP8_44_,
        docdtl0_.MANUAL_SVC as MANUAL_SVC9_44_,
        docdtl0_.MANUAL_DSC as MANUAL_DSC10_44_,
        docdtl0_.MI_ID as MI_ID11_44_,
        docdtl0_.NAME as NAME12_44_,
        docdtl0_.POSTING_EMPL_ID as POSTING_EMPL_ID13_44_,
        docdtl0_.PAY_TTL_DEPOSIT as PAY_TTL_DEPOSIT14_44_,
        docdtl0_.PAY_TTL_SUBSCR as PAY_TTL_SUBSCR15_44_,
        docdtl0_.POINTS as POINTS16_44_,
        docdtl0_.REFERENCE as REFERENCE17_44_,
        docdtl0_.COMISSION_EMPL_ID as COMISSION_EMPL_ID18_44_,
        docdtl0_.SI as SI19_44_,
        docdtl0_.TAX_ADD as TAX_ADD20_44_,
        docdtl0_.TAX_ADDON as TAX_ADDON21_44_,
        docdtl0_.TAX_VAT as TAX_VAT22_44_,
        docdtl0_.TICKETS as TICKETS23_44_,
        docdtl0_.TM as TM24_44_,
        docdtl0_.TTL as TTL25_44_,
        docdtl0_.VOID_FLAG as VOID_FLAG26_44_,
        docdtl0_.VOID_REASON as VOID_REASON27_44_
    from
        club.DOCS_DTL docdtl0_
    where
        (
            DOC_ID=?
        )
Hibernate:
    select
        doc0_.DOC_ID as DOC_ID1_42_0_,
        doc0_.BUSSINES_DATE as BUSSINES_DATE2_42_0_,
        doc0_.DEF_CARD_ID as DEF_CARD_ID3_42_0_,
        doc0_.DEF_CARD_TYPE_ID as DEF_CARD_TYPE_ID4_42_0_,
        doc0_.CHCK_ID as CHCK_ID5_42_0_,
        doc0_.CHECK_OPEN as CHECK_OPEN6_42_0_,
        doc0_.CHKNUM as CHKNUM7_42_0_,
        doc0_.COFIRMATION as COFIRMATION8_42_0_,
        doc0_.DOC_TYPE as DOC_TYPE9_42_0_,
        doc0_.GST as GST10_42_0_,
        doc0_.IMAGE as IMAGE11_42_0_,
        doc0_.INVOICE_ID as INVOICE_ID20_42_0_,
        doc0_.DEF_MAGSTRIPE as DEF_MAGSTRIPE12_42_0_,
        doc0_.OPERATOR as OPERATOR13_42_0_,
        doc0_.REGISTRATION_ID as REGISTRATION_ID21_42_0_,
        doc0_.RVC as RVC22_42_0_,
        doc0_.SP as SP14_42_0_,
        doc0_.TAX_EXEMPT as TAX_EXEMPT15_42_0_,
        doc0_.TM as TM16_42_0_,
        doc0_.TM_OPEN as TM_OPEN17_42_0_,
        doc0_.TTL as TTL18_42_0_,
        doc0_.VER as VER19_42_0_
    from
        club.DOCS doc0_
    where
        doc0_.DOC_ID=?
Hibernate:
    select
        a.expiry_date,
        sum(a.amount) as amount
    from
        accounting a,
        docs d
    where
        d.doc_id = a.doc_id
        and d.cofirmation='T'
        and a.expiry_date >= trunc(sysdate)
        and a.loan_flag='T'
        and a.card_id=?
    group by
        a.expiry_date
    having
        sum(a.amount) != 0
    order by
        a.expiry_date
Hibernate:
    SELECT
        v.*
    FROM
        VOUCHER v
    JOIN
        VOUCHER_CAMPAIGN vc
            ON vc.VOUCHER_CAMPAIGN_ID=v.VOUCHER_CAMPAIGN_ID
    WHERE
        v.LINK_CARD_ID=?
        AND (
            v.VALID_TILL IS NULL
            OR v.VALID_TILL >= SYSDATE
        )
        AND (
            v.USE_COUNT < vc.MAX_USE_COUNT
        )
        AND (
            v.SUBSCRIPTION_ACCOUNTING_ID IS NULL
            OR v.SUBSCRIPTION_ACCOUNTING_ID IN (
                SELECT
                    sa.SUBSCRIPTION_ACCOUNTING_ID
                FROM
                    SUBSCRIPTION_ACCOUNTING sa
                WHERE
                    sa.STATUS='2'
            )
        )
Hibernate:
    select
        card0_.CARD_ID as CARD_ID1_20_0_,
        card0_.IS_ARCHIVED as IS_ARCHIVED2_20_0_,
        card0_.BIRTH_DATE as BIRTH_DATE3_20_0_,
        card0_.CARD_STATUS_ID as CARD_STATUS_ID78_20_0_,
        card0_.CARD_TYPE_ID as CARD_TYPE_ID79_20_0_,
        card0_.CELL_PHONE as CELL_PHONE4_20_0_,
        card0_.CITY as CITY5_20_0_,
        card0_.COMPANY as COMPANY6_20_0_,
        card0_.COUNTRY as COUNTRY7_20_0_,
        card0_.CREATED_DATE as CREATED_DATE8_20_0_,
        card0_.CREATED_PERSON as CREATED_PERSON9_20_0_,
        card0_.EMAIL as EMAIL10_20_0_,
        card0_.FIRST_NAME as FIRST_NAME11_20_0_,
        card0_.GENDER as GENDER12_20_0_,
        card0_.GREETING as GREETING13_20_0_,
        card0_.HEALTH_INFO as HEALTH_INFO14_20_0_,
        card0_.JOB_TITLE as JOB_TITLE15_20_0_,
        card0_.LANG as LANG16_20_0_,
        card0_.LAST_NAME as LAST_NAME17_20_0_,
        card0_.LAST_USED_RVC_ID as LAST_USED_RVC_ID18_20_0_,
        card0_.MAGSTRIPE as MAGSTRIPE19_20_0_,
        card0_.MAILING_OPT as MAILING_OPT20_20_0_,
        card0_.MASTER_CARD_ID as MASTER_CARD_ID80_20_0_,
        card0_.MAX_CHILDREN as MAX_CHILDREN21_20_0_,
        card0_.MLST_SYNC_STATUS as MLST_SYNC_STATUS22_20_0_,
        card0_.NOTES as NOTES23_20_0_,
        card0_.PASSPORT as PASSPORT24_20_0_,
        card0_.PASSWORD as PASSWORD25_20_0_,
        card0_.PHONE as PHONE26_20_0_,
        card0_.PROFILE_TYPE as PROFILE_TYPE27_20_0_,
        card0_.RATE as RATE28_20_0_,
        card0_.SECOND_NAME as SECOND_NAME29_20_0_,
        card0_.SOURCE as SOURCE30_20_0_,
        card0_.STREET_ADDRESS as STREET_ADDRESS31_20_0_,
        card0_.TITLE as TITLE32_20_0_,
        card0_.UDFD1 as UDFD33_20_0_,
        card0_.UDFD10 as UDFD34_20_0_,
        card0_.UDFD2 as UDFD35_20_0_,
        card0_.UDFD3 as UDFD36_20_0_,
        card0_.UDFD4 as UDFD37_20_0_,
        card0_.UDFD5 as UDFD38_20_0_,
        card0_.UDFD6 as UDFD39_20_0_,
        card0_.UDFD7 as UDFD40_20_0_,
        card0_.UDFD8 as UDFD41_20_0_,
        card0_.UDFD9 as UDFD42_20_0_,
        card0_.UDFN1 as UDFN43_20_0_,
        card0_.UDFN10 as UDFN44_20_0_,
        card0_.UDFN2 as UDFN45_20_0_,
        card0_.UDFN3 as UDFN46_20_0_,
        card0_.UDFN4 as UDFN47_20_0_,
        card0_.UDFN5 as UDFN48_20_0_,
        card0_.UDFN6 as UDFN49_20_0_,
        card0_.UDFN7 as UDFN50_20_0_,
        card0_.UDFN8 as UDFN51_20_0_,
        card0_.UDFN9 as UDFN52_20_0_,
        card0_.UDFS1 as UDFS53_20_0_,
        card0_.UDFS10 as UDFS54_20_0_,
        card0_.UDFS11 as UDFS55_20_0_,
        card0_.UDFS12 as UDFS56_20_0_,
        card0_.UDFS13 as UDFS57_20_0_,
        card0_.UDFS14 as UDFS58_20_0_,
        card0_.UDFS15 as UDFS59_20_0_,
        card0_.UDFS16 as UDFS60_20_0_,
        card0_.UDFS17 as UDFS61_20_0_,
        card0_.UDFS18 as UDFS62_20_0_,
        card0_.UDFS19 as UDFS63_20_0_,
        card0_.UDFS2 as UDFS64_20_0_,
        card0_.UDFS20 as UDFS65_20_0_,
        card0_.UDFS3 as UDFS66_20_0_,
        card0_.UDFS4 as UDFS67_20_0_,
        card0_.UDFS5 as UDFS68_20_0_,
        card0_.UDFS6 as UDFS69_20_0_,
        card0_.UDFS7 as UDFS70_20_0_,
        card0_.UDFS8 as UDFS71_20_0_,
        card0_.UDFS9 as UDFS72_20_0_,
        card0_.UPDATE_DATE as UPDATE_DATE73_20_0_,
        card0_.UPDATE_PERSON as UPDATE_PERSON74_20_0_,
        card0_.VALID_TILL as VALID_TILL75_20_0_,
        card0_.VIP_STATUS as VIP_STATUS76_20_0_,
        card0_.ZIP_CODE as ZIP_CODE77_20_0_
    from
        club.CARDS card0_
    where
        card0_.CARD_ID=?
Hibernate:
    select
        vouchercam0_.VOUCHER_CAMPAIGN_ID as VOUCHER_CAMPAIGN_I1_137_0_,
        vouchercam0_.BONUS as BONUS2_137_0_,
        vouchercam0_.BONUS_TYPE as BONUS_TYPE3_137_0_,
        vouchercam0_.CODE_LEN as CODE_LEN4_137_0_,
        vouchercam0_.CODE_TYPE as CODE_TYPE5_137_0_,
        vouchercam0_.CREATED_PERSON as CREATED_PERSON6_137_0_,
        vouchercam0_.CREATED_TM as CREATED_TM7_137_0_,
        vouchercam0_.DEFAULT_VALIDITY as DEFAULT_VALIDITY8_137_0_,
        vouchercam0_.HIERARCHY_ID as HIERARCHY_ID19_137_0_,
        vouchercam0_.ITEMS as ITEMS9_137_0_,
        vouchercam0_.MAX_USE_COUNT as MAX_USE_COUNT10_137_0_,
        vouchercam0_.NAME as NAME11_137_0_,
        vouchercam0_.PREFIX as PREFIX12_137_0_,
        vouchercam0_.RANGE_FROM as RANGE_FROM13_137_0_,
        vouchercam0_.RANGE_TILL as RANGE_TILL14_137_0_,
        vouchercam0_.DSC_RULSET_ID as DSC_RULSET_ID20_137_0_,
        vouchercam0_.TYPE as TYPE15_137_0_,
        vouchercam0_.UPDATE_PERSON as UPDATE_PERSON16_137_0_,
        vouchercam0_.UPDATE_TM as UPDATE_TM17_137_0_,
        vouchercam0_.VALUE as VALUE18_137_0_
    from
        club.VOUCHER_CAMPAIGN vouchercam0_
    where
        vouchercam0_.VOUCHER_CAMPAIGN_ID=?
Hibernate:
    SELECT
        b.booking_id,
        b.status,
        b.name,
        b.time_start,
        b.time_end,
        r.name AS rvcname,
        (SELECT
            MIN(resource_name)
        FROM
            booking_resources
        WHERE
            resource_type='T'
            AND booking_id=b.booking_id) AS therapist
    FROM
        bookings b,
        booking_resources br,
        rvc r
    WHERE
        br.booking_id = b.booking_id
        AND r.rvc_id = b.rvc_id
        AND b.status != 'V'
        AND br.resource_type = 'P'
        AND br.resource_id = ?
        AND b.time_start >= ?
    order by
        b.time_start
Hibernate:
    select
        cardextra0_.ID as ID1_29_,
        cardextra0_.CARD_ID as CARD_ID4_29_,
        cardextra0_.CARD_TYPE_ID as CARD_TYPE_ID5_29_,
        cardextra0_.MAGSTRIPE as MAGSTRIPE2_29_,
        cardextra0_.VALID_TILL as VALID_TILL3_29_
    from
        club.CARD_XTRA cardextra0_
    where
        (
            cardextra0_.CARD_ID=?
        )
Hibernate:
    select
        template0_.TEMPLATE_ID as TEMPLATE_ID1_123_,
        template0_.DATA as DATA2_123_,
        template0_.NAME as NAME3_123_,
        template0_.SYSTEM as SYSTEM4_123_,
        template0_.TITLE as TITLE5_123_,
        template0_.TYPE as TYPE6_123_
    from
        club.TEMPLATES template0_
    where
        (
            template0_.NAME=?
        )
15.08.16 17:06:23:764 - INFO - DatabaseResourceViewResolver - Storing template c:\TOMCAT3\webapps\ROOT\WEB-INF\jsp\PAYMENT.jsp
Hibernate:
    select
        cardtype0_.CARD_TYPE_ID as CARD_TYPE_ID1_26_0_,
        cardtype0_.DEFAULT_ACCOUNT_DEF_ID as DEFAULT_ACCOUNT_D12_26_0_,
        cardtype0_.ACTIVE as ACTIVE2_26_0_,
        cardtype0_.DEFAULT_MASK as DEFAULT_MASK3_26_0_,
        cardtype0_.DEFAULT_VALIDITY_PERIOD as DEFAULT_VALIDITY_P4_26_0_,
        cardtype0_.FACILITY_ACCESS_RULESET as FACILITY_ACCESS_R13_26_0_,
        cardtype0_.MENU_LEVEL as MENU_LEVEL5_26_0_,
        cardtype0_.OPTIONS as OPTIONS6_26_0_,
        cardtype0_.PMS_LEVEL as PMS_LEVEL7_26_0_,
        cardtype0_.PMS_TYPE as PMS_TYPE8_26_0_,
        cardtype0_.RANGE_START as RANGE_START9_26_0_,
        cardtype0_.TRACK1FORMAT as TRACK10_26_0_,
        cardtype0_.TYPE_NAME as TYPE_NAME11_26_0_
    from
        club.CARD_TYPES cardtype0_
    where
        cardtype0_.CARD_TYPE_ID=?
Hibernate:
    select
        accountdef0_.ACCOUNT_DEF_ID as ACCOUNT_DEF_ID1_2_,
        accountdef0_.ACCOUNT_CODE as ACCOUNT_CODE2_2_,
        accountdef0_.ACCOUNT_TYPE as ACCOUNT_TYPE3_2_,
        accountdef0_.AUTO_RENEW as AUTO_RENEW4_2_,
        accountdef0_.TASK_TYPE_ID as TASK_TYPE_ID10_2_,
        accountdef0_.CURRENCY_ID as CURRENCY_ID11_2_,
        accountdef0_.EXPIRATION as EXPIRATION5_2_,
        accountdef0_.NAME as NAME6_2_,
        accountdef0_.ORDR as ORDR7_2_,
        accountdef0_.POINTS_RATE as POINTS_RATE8_2_,
        accountdef0_.POINTS_ROUNDING as POINTS_ROUNDING9_2_,
        accountdef0_.RULESET_ID as RULESET_ID12_2_,
        accountdef0_.ACCOUNT_CODE || ' ' || accountdef0_.NAME as formula0_
    from
        club.ACCOUNT_DEF accountdef0_
    order by
        ORDR
Hibernate:
    select
        cardtypesa0_.CARD_TYPES_ACCOUNTS_ID as CARD_TYPES_ACCOUNT1_27_,
        cardtypesa0_.ACCOUNT_DEF_ID as ACCOUNT_DEF_ID5_27_,
        cardtypesa0_.CARD_TYPE_ID as CARD_TYPE_ID6_27_,
        cardtypesa0_.CREDIT_LIMIT as CREDIT_LIMIT2_27_,
        cardtypesa0_.PAYMENT_LIMIT as PAYMENT_LIMIT3_27_,
        cardtypesa0_.PRIORITY as PRIORITY4_27_
    from
        club.CARD_TYPES_ACCOUNTS cardtypesa0_
    where
        (
            cardtypesa0_.CARD_TYPE_ID=?
        )
        AND(
            cardtypesa0_.ACCOUNT_DEF_ID=?
        )
Hibernate:
    select
        accountdef0_.ACCOUNT_DEF_ID as ACCOUNT_DEF_ID1_2_0_,
        accountdef0_.ACCOUNT_CODE as ACCOUNT_CODE2_2_0_,
        accountdef0_.ACCOUNT_TYPE as ACCOUNT_TYPE3_2_0_,
        accountdef0_.AUTO_RENEW as AUTO_RENEW4_2_0_,
        accountdef0_.TASK_TYPE_ID as TASK_TYPE_ID10_2_0_,
        accountdef0_.CURRENCY_ID as CURRENCY_ID11_2_0_,
        accountdef0_.EXPIRATION as EXPIRATION5_2_0_,
        accountdef0_.NAME as NAME6_2_0_,
        accountdef0_.ORDR as ORDR7_2_0_,
        accountdef0_.POINTS_RATE as POINTS_RATE8_2_0_,
        accountdef0_.POINTS_ROUNDING as POINTS_ROUNDING9_2_0_,
        accountdef0_.RULESET_ID as RULESET_ID12_2_0_,
        accountdef0_.ACCOUNT_CODE || ' ' || accountdef0_.NAME as formula0_0_
    from
        club.ACCOUNT_DEF accountdef0_
    where
        accountdef0_.ACCOUNT_DEF_ID=?
Hibernate:
    select
        cardtype0_.CARD_TYPE_ID as CARD_TYPE_ID1_26_0_,
        cardtype0_.DEFAULT_ACCOUNT_DEF_ID as DEFAULT_ACCOUNT_D12_26_0_,
        cardtype0_.ACTIVE as ACTIVE2_26_0_,
        cardtype0_.DEFAULT_MASK as DEFAULT_MASK3_26_0_,
        cardtype0_.DEFAULT_VALIDITY_PERIOD as DEFAULT_VALIDITY_P4_26_0_,
        cardtype0_.FACILITY_ACCESS_RULESET as FACILITY_ACCESS_R13_26_0_,
        cardtype0_.MENU_LEVEL as MENU_LEVEL5_26_0_,
        cardtype0_.OPTIONS as OPTIONS6_26_0_,
        cardtype0_.PMS_LEVEL as PMS_LEVEL7_26_0_,
        cardtype0_.PMS_TYPE as PMS_TYPE8_26_0_,
        cardtype0_.RANGE_START as RANGE_START9_26_0_,
        cardtype0_.TRACK1FORMAT as TRACK10_26_0_,
        cardtype0_.TYPE_NAME as TYPE_NAME11_26_0_
    from
        club.CARD_TYPES cardtype0_
    where
        cardtype0_.CARD_TYPE_ID=?
Hibernate:
    select
        accounting0_.ID as ID1_1_,
        accounting0_.ACCOUNT_DEF_ID as ACCOUNT_DEF_ID7_1_,
        accounting0_.AMOUNT as AMOUNT2_1_,
        accounting0_.CARD_ID as CARD_ID3_1_,
        accounting0_.CRD_TTL as CRD_TTL4_1_,
        accounting0_.LAST_EXPIRY as LAST_EXPIRY5_1_,
        accounting0_.LOAN as LOAN6_1_
    from
        club.ACCOUNTING_BALANCE accounting0_,
        club.ACCOUNT_DEF accountdef1_
    where
        (
            accounting0_.CARD_ID=?
        )
        AND(
            accountdef1_.ACCOUNT_CODE=?
            and accounting0_.ACCOUNT_DEF_ID=accountdef1_.ACCOUNT_DEF_ID
        )
Hibernate:
    select
        accountdef0_.ACCOUNT_DEF_ID as ACCOUNT_DEF_ID1_2_0_,
        accountdef0_.ACCOUNT_CODE as ACCOUNT_CODE2_2_0_,
        accountdef0_.ACCOUNT_TYPE as ACCOUNT_TYPE3_2_0_,
        accountdef0_.AUTO_RENEW as AUTO_RENEW4_2_0_,
        accountdef0_.TASK_TYPE_ID as TASK_TYPE_ID10_2_0_,
        accountdef0_.CURRENCY_ID as CURRENCY_ID11_2_0_,
        accountdef0_.EXPIRATION as EXPIRATION5_2_0_,
        accountdef0_.NAME as NAME6_2_0_,
        accountdef0_.ORDR as ORDR7_2_0_,
        accountdef0_.POINTS_RATE as POINTS_RATE8_2_0_,
        accountdef0_.POINTS_ROUNDING as POINTS_ROUNDING9_2_0_,
        accountdef0_.RULESET_ID as RULESET_ID12_2_0_,
        accountdef0_.ACCOUNT_CODE || ' ' || accountdef0_.NAME as formula0_0_
    from
        club.ACCOUNT_DEF accountdef0_
    where
        accountdef0_.ACCOUNT_DEF_ID=?
Hibernate:
    select
        SUM(accounting0_.AMOUNT) as col_0_0_
    from
        club.ACCOUNTING accounting0_,
        club.ACCOUNT_DEF accountdef1_
    where
        (
            accounting0_.CARD_ID=?
        )
        AND(
            accounting0_.DOC_ID=?
        )
        AND(
            accountdef1_.ACCOUNT_CODE=?
            and accounting0_.ACCOUNT_DEF_ID=accountdef1_.ACCOUNT_DEF_ID
        )
    group by
        accounting0_.CARD_ID ,
        accounting0_.DOC_ID ,
        accountdef1_.ACCOUNT_DEF_ID
Hibernate:
    select
        doc0_.DOC_ID as DOC_ID1_42_0_,
        doc0_.BUSSINES_DATE as BUSSINES_DATE2_42_0_,
        doc0_.DEF_CARD_ID as DEF_CARD_ID3_42_0_,
        doc0_.DEF_CARD_TYPE_ID as DEF_CARD_TYPE_ID4_42_0_,
        doc0_.CHCK_ID as CHCK_ID5_42_0_,
        doc0_.CHECK_OPEN as CHECK_OPEN6_42_0_,
        doc0_.CHKNUM as CHKNUM7_42_0_,
        doc0_.COFIRMATION as COFIRMATION8_42_0_,
        doc0_.DOC_TYPE as DOC_TYPE9_42_0_,
        doc0_.GST as GST10_42_0_,
        doc0_.IMAGE as IMAGE11_42_0_,
        doc0_.INVOICE_ID as INVOICE_ID20_42_0_,
        doc0_.DEF_MAGSTRIPE as DEF_MAGSTRIPE12_42_0_,
        doc0_.OPERATOR as OPERATOR13_42_0_,
        doc0_.REGISTRATION_ID as REGISTRATION_ID21_42_0_,
        doc0_.RVC as RVC22_42_0_,
        doc0_.SP as SP14_42_0_,
        doc0_.TAX_EXEMPT as TAX_EXEMPT15_42_0_,
        doc0_.TM as TM16_42_0_,
        doc0_.TM_OPEN as TM_OPEN17_42_0_,
        doc0_.TTL as TTL18_42_0_,
        doc0_.VER as VER19_42_0_
    from
        club.DOCS doc0_
    where
        doc0_.DOC_ID=?
Hibernate:
    select
        cardtypesa0_.CARD_TYPES_ACCOUNTS_ID as CARD_TYPES_ACCOUNT1_27_,
        cardtypesa0_.ACCOUNT_DEF_ID as ACCOUNT_DEF_ID5_27_,
        cardtypesa0_.CARD_TYPE_ID as CARD_TYPE_ID6_27_,
        cardtypesa0_.CREDIT_LIMIT as CREDIT_LIMIT2_27_,
        cardtypesa0_.PAYMENT_LIMIT as PAYMENT_LIMIT3_27_,
        cardtypesa0_.PRIORITY as PRIORITY4_27_
    from
        club.CARD_TYPES_ACCOUNTS cardtypesa0_
    where
        (
            cardtypesa0_.CARD_TYPE_ID=?
        )
        AND(
            cardtypesa0_.ACCOUNT_DEF_ID=?
        )
Hibernate:
    select
        accountdef0_.ACCOUNT_DEF_ID as ACCOUNT_DEF_ID1_2_0_,
        accountdef0_.ACCOUNT_CODE as ACCOUNT_CODE2_2_0_,
        accountdef0_.ACCOUNT_TYPE as ACCOUNT_TYPE3_2_0_,
        accountdef0_.AUTO_RENEW as AUTO_RENEW4_2_0_,
        accountdef0_.TASK_TYPE_ID as TASK_TYPE_ID10_2_0_,
        accountdef0_.CURRENCY_ID as CURRENCY_ID11_2_0_,
        accountdef0_.EXPIRATION as EXPIRATION5_2_0_,
        accountdef0_.NAME as NAME6_2_0_,
        accountdef0_.ORDR as ORDR7_2_0_,
        accountdef0_.POINTS_RATE as POINTS_RATE8_2_0_,
        accountdef0_.POINTS_ROUNDING as POINTS_ROUNDING9_2_0_,
        accountdef0_.RULESET_ID as RULESET_ID12_2_0_,
        accountdef0_.ACCOUNT_CODE || ' ' || accountdef0_.NAME as formula0_0_
    from
        club.ACCOUNT_DEF accountdef0_
    where
        accountdef0_.ACCOUNT_DEF_ID=?
Hibernate:
    select
        cardtype0_.CARD_TYPE_ID as CARD_TYPE_ID1_26_0_,
        cardtype0_.DEFAULT_ACCOUNT_DEF_ID as DEFAULT_ACCOUNT_D12_26_0_,
        cardtype0_.ACTIVE as ACTIVE2_26_0_,
        cardtype0_.DEFAULT_MASK as DEFAULT_MASK3_26_0_,
        cardtype0_.DEFAULT_VALIDITY_PERIOD as DEFAULT_VALIDITY_P4_26_0_,
        cardtype0_.FACILITY_ACCESS_RULESET as FACILITY_ACCESS_R13_26_0_,
        cardtype0_.MENU_LEVEL as MENU_LEVEL5_26_0_,
        cardtype0_.OPTIONS as OPTIONS6_26_0_,
        cardtype0_.PMS_LEVEL as PMS_LEVEL7_26_0_,
        cardtype0_.PMS_TYPE as PMS_TYPE8_26_0_,
        cardtype0_.RANGE_START as RANGE_START9_26_0_,
        cardtype0_.TRACK1FORMAT as TRACK10_26_0_,
        cardtype0_.TYPE_NAME as TYPE_NAME11_26_0_
    from
        club.CARD_TYPES cardtype0_
    where
        cardtype0_.CARD_TYPE_ID=?
Hibernate:
    select
        accounting0_.ID as ID1_1_,
        accounting0_.ACCOUNT_DEF_ID as ACCOUNT_DEF_ID7_1_,
        accounting0_.AMOUNT as AMOUNT2_1_,
        accounting0_.CARD_ID as CARD_ID3_1_,
        accounting0_.CRD_TTL as CRD_TTL4_1_,
        accounting0_.LAST_EXPIRY as LAST_EXPIRY5_1_,
        accounting0_.LOAN as LOAN6_1_
    from
        club.ACCOUNTING_BALANCE accounting0_,
        club.ACCOUNT_DEF accountdef1_
    where
        (
            accounting0_.CARD_ID=?
        )
        AND(
            accountdef1_.ACCOUNT_CODE=?
            and accounting0_.ACCOUNT_DEF_ID=accountdef1_.ACCOUNT_DEF_ID
        )
Hibernate:
    select
        accountdef0_.ACCOUNT_DEF_ID as ACCOUNT_DEF_ID1_2_0_,
        accountdef0_.ACCOUNT_CODE as ACCOUNT_CODE2_2_0_,
        accountdef0_.ACCOUNT_TYPE as ACCOUNT_TYPE3_2_0_,
        accountdef0_.AUTO_RENEW as AUTO_RENEW4_2_0_,
        accountdef0_.TASK_TYPE_ID as TASK_TYPE_ID10_2_0_,
        accountdef0_.CURRENCY_ID as CURRENCY_ID11_2_0_,
        accountdef0_.EXPIRATION as EXPIRATION5_2_0_,
        accountdef0_.NAME as NAME6_2_0_,
        accountdef0_.ORDR as ORDR7_2_0_,
        accountdef0_.POINTS_RATE as POINTS_RATE8_2_0_,
        accountdef0_.POINTS_ROUNDING as POINTS_ROUNDING9_2_0_,
        accountdef0_.RULESET_ID as RULESET_ID12_2_0_,
        accountdef0_.ACCOUNT_CODE || ' ' || accountdef0_.NAME as formula0_0_
    from
        club.ACCOUNT_DEF accountdef0_
    where
        accountdef0_.ACCOUNT_DEF_ID=?
Hibernate:
    select
        SUM(accounting0_.AMOUNT) as col_0_0_
    from
        club.ACCOUNTING accounting0_,
        club.ACCOUNT_DEF accountdef1_
    where
        (
            accounting0_.CARD_ID=?
        )
        AND(
            accounting0_.DOC_ID=?
        )
        AND(
            accountdef1_.ACCOUNT_CODE=?
            and accounting0_.ACCOUNT_DEF_ID=accountdef1_.ACCOUNT_DEF_ID
        )
    group by
        accounting0_.CARD_ID ,
        accounting0_.DOC_ID ,
        accountdef1_.ACCOUNT_DEF_ID
Hibernate:
    select
        doc0_.DOC_ID as DOC_ID1_42_0_,
        doc0_.BUSSINES_DATE as BUSSINES_DATE2_42_0_,
        doc0_.DEF_CARD_ID as DEF_CARD_ID3_42_0_,
        doc0_.DEF_CARD_TYPE_ID as DEF_CARD_TYPE_ID4_42_0_,
        doc0_.CHCK_ID as CHCK_ID5_42_0_,
        doc0_.CHECK_OPEN as CHECK_OPEN6_42_0_,
        doc0_.CHKNUM as CHKNUM7_42_0_,
        doc0_.COFIRMATION as COFIRMATION8_42_0_,
        doc0_.DOC_TYPE as DOC_TYPE9_42_0_,
        doc0_.GST as GST10_42_0_,
        doc0_.IMAGE as IMAGE11_42_0_,
        doc0_.INVOICE_ID as INVOICE_ID20_42_0_,
        doc0_.DEF_MAGSTRIPE as DEF_MAGSTRIPE12_42_0_,
        doc0_.OPERATOR as OPERATOR13_42_0_,
        doc0_.REGISTRATION_ID as REGISTRATION_ID21_42_0_,
        doc0_.RVC as RVC22_42_0_,
        doc0_.SP as SP14_42_0_,
        doc0_.TAX_EXEMPT as TAX_EXEMPT15_42_0_,
        doc0_.TM as TM16_42_0_,
        doc0_.TM_OPEN as TM_OPEN17_42_0_,
        doc0_.TTL as TTL18_42_0_,
        doc0_.VER as VER19_42_0_
    from
        club.DOCS doc0_
    where
        doc0_.DOC_ID=?
15.08.16 17:06:23:952 - INFO - CardInfo - Infolines text: 1260 Герасименко Александр|Гость-|Депозит 2933.50 (+0.00)
Hibernate:
    select
        this_.ID as ID1_124_0_,
        this_.ALLOWED_RVC_GROUP_ID as ALLOWED_RVC_GROUP15_124_0_,
        this_.AUTOBALANCE_PM as AUTOBALANCE_PM2_124_0_,
        this_.F_CLOSECHECK as F_CLOSECHECK3_124_0_,
        this_.F_CLOSESHIFT as F_CLOSESHIFT4_124_0_,
        this_.F_NOSALE as F_NOSALE5_124_0_,
        this_.F_SERVICE as F_SERVICE6_124_0_,
        this_.FISCAL as FISCAL7_124_0_,
        this_.HTNG_UNIT as HTNG_UNIT8_124_0_,
        this_.IFC as IFC9_124_0_,
        this_.NAME as NAME10_124_0_,
        this_.PMS_PAYM_SVC as PMS_PAYM_SVC11_124_0_,
        this_.PMS_STAT as PMS_STAT12_124_0_,
        this_.PRIVILEGED as PRIVILEGED13_124_0_,
        this_.TM_ID as TM_ID14_124_0_
    from
        club.TENDERMEDIA this_
Hibernate:
    select
        this_.SI_ID as SI_ID1_81_0_,
        this_.DEP_CODE as DEP_CODE2_81_0_,
        this_.NAME as NAME3_81_0_
    from
        club.MENU_SI this_
15.08.16 17:06:23:967 - INFO - FidelioXml - >> Fidelio XML: <fidelio Version="1.0.0"><request ID="46941" UserName="s" Password="s" Vendor="Suite8"><command><post><crm_posting><RoomNum>9200</RoomNum><PostingDate>15.08.2016</PostingDate><Quantity>1</Quantity><Price>57.00</Price><Comment></Comment><Description>МЕДИЦИНСКИЕ УСЛУГИ</Description><DepartmentCode>450</DepartmentCode></crm_posting><crm_posting><RoomNum>9200</RoomNum><PostingDate>15.08.2016</PostingDate><Quantity>1</Quantity><Price>-57.00</Price><Comment></Comment><Description>Autobalance</Description><DepartmentCode>906</DepartmentCode></crm_posting></post></command></request></fidelio>
15.08.16 17:06:27:734 - INFO - FidelioXml - << Fidelio XML: <?xml version="1.0" encoding="utf-8" ?><fidelio Version="1.0.0"><response ID="46941" Status="OK"></response></fidelio>
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        tax0_.SITE_ID as SITE_ID5_115_,
        tax0_.TAX_ID as TAX_ID1_115_,
        tax0_.NAME as NAME2_115_,
        tax0_.RATE as RATE3_115_,
        tax0_.TYPE as TYPE4_115_
    from
        club.TAXES tax0_
    where
        (
            SITE_ID=?
        )
Hibernate:
    select
        site0_.SITE_ID as SITE_ID1_107_0_,
        site0_.AUTOSTART as AUTOSTART2_107_0_,
        site0_.DB_SYNC as DB_SYNC3_107_0_,
        site0_.TP as TP4_107_0_,
        site0_.GI as GI5_107_0_,
        site0_.HTNG as HTNG6_107_0_,
        site0_.INQ_TM as INQ_TM7_107_0_,
        site0_.IP as IP8_107_0_,
        site0_.LOCATION as LOCATION9_107_0_,
        site0_.NAME as NAME10_107_0_,
        site0_.OPTIONS as OPTIONS11_107_0_,
        site0_.PMS_PROPERTY as PMS_PROPERTY12_107_0_,
        site0_.PORT as PORT13_107_0_,
        site0_.SITE_KEY as SITE_KEY14_107_0_,
        site0_.SVC_TAX_CLASS_ID as SVC_TAX_CLASS_ID16_107_0_,
        site0_.V8IFC as V15_107_0_
    from
        club.SITES site0_
    where
        site0_.SITE_ID=?
Hibernate:
    select
        tendermedi0_.ID as ID1_124_,
        tendermedi0_.ALLOWED_RVC_GROUP_ID as ALLOWED_RVC_GROUP15_124_,
        tendermedi0_.AUTOBALANCE_PM as AUTOBALANCE_PM2_124_,
        tendermedi0_.F_CLOSECHECK as F_CLOSECHECK3_124_,
        tendermedi0_.F_CLOSESHIFT as F_CLOSESHIFT4_124_,
        tendermedi0_.F_NOSALE as F_NOSALE5_124_,
        tendermedi0_.F_SERVICE as F_SERVICE6_124_,
        tendermedi0_.FISCAL as FISCAL7_124_,
        tendermedi0_.HTNG_UNIT as HTNG_UNIT8_124_,
        tendermedi0_.IFC as IFC9_124_,
        tendermedi0_.NAME as NAME10_124_,
        tendermedi0_.PMS_PAYM_SVC as PMS_PAYM_SVC11_124_,
        tendermedi0_.PMS_STAT as PMS_STAT12_124_,
        tendermedi0_.PRIVILEGED as PRIVILEGED13_124_,
        tendermedi0_.TM_ID as TM_ID14_124_
    from
        club.TENDERMEDIA tendermedi0_
    where
        (
            tendermedi0_.TM_ID=?
        )
Hibernate:
    DELETE
    FROM
        DOCS_DTL
    WHERE
        DOC_ID=?
15.08.16 17:06:27:904 - INFO - ResourceInvoiceService - DELETE from docs_dtl result: 1
Hibernate:
    DELETE
    FROM
        DOCS_TAX
    WHERE
        DOC_ID=?
Hibernate:
    DELETE
    FROM
        DOCS_PAYM
    WHERE
        DOC_ID=?
15.08.16 17:06:27:907 - INFO - ResourceInvoiceService - DELETE from docs_paym result: 0
Hibernate:
    select
        tax0_.SITE_ID as SITE_ID5_115_,
        tax0_.TAX_ID as TAX_ID1_115_,
        tax0_.NAME as NAME2_115_,
        tax0_.RATE as RATE3_115_,
        tax0_.TYPE as TYPE4_115_
    from
        club.TAXES tax0_
    where
        (
            SITE_ID=?
        )
Hibernate:
    select
        site0_.SITE_ID as SITE_ID1_107_0_,
        site0_.AUTOSTART as AUTOSTART2_107_0_,
        site0_.DB_SYNC as DB_SYNC3_107_0_,
        site0_.TP as TP4_107_0_,
        site0_.GI as GI5_107_0_,
        site0_.HTNG as HTNG6_107_0_,
        site0_.INQ_TM as INQ_TM7_107_0_,
        site0_.IP as IP8_107_0_,
        site0_.LOCATION as LOCATION9_107_0_,
        site0_.NAME as NAME10_107_0_,
        site0_.OPTIONS as OPTIONS11_107_0_,
        site0_.PMS_PROPERTY as PMS_PROPERTY12_107_0_,
        site0_.PORT as PORT13_107_0_,
        site0_.SITE_KEY as SITE_KEY14_107_0_,
        site0_.SVC_TAX_CLASS_ID as SVC_TAX_CLASS_ID16_107_0_,
        site0_.V8IFC as V15_107_0_
    from
        club.SITES site0_
    where
        site0_.SITE_ID=?
Hibernate:
    select
        menuitem0_.MI_ID as MI_ID1_77_,
        menuitem0_.ACTIVE as ACTIVE2_77_,
        menuitem0_.BARCODE as BARCODE3_77_,
        menuitem0_.BASE_INV_UNIT_ID as BASE_INV_UNIT_ID30_77_,
        menuitem0_.BOOK_STEP as BOOK_STEP4_77_,
        menuitem0_.CODE as CODE5_77_,
        menuitem0_.COLOR as COLOR6_77_,
        menuitem0_.COMMISSION_GRP_ID as COMMISSION_GRP_ID31_77_,
        menuitem0_.COMPLEXITY as COMPLEXITY7_77_,
        menuitem0_.COST as COST8_77_,
        menuitem0_.DESCRIPTION as DESCRIPTION9_77_,
        menuitem0_.DESCRIPTION_STRING_ID as DESCRIPTION_STRIN10_77_,
        menuitem0_.DISCOUNT_RULESET_ID as DISCOUNT_RULESET_32_77_,
        menuitem0_.EXTN_GROUP as EXTN_GROUP11_77_,
        menuitem0_.FGRP as FGRP33_77_,
        menuitem0_.FAVOURITES_ID as FAVOURITES_ID34_77_,
        menuitem0_.HIERARCHY_ID as HIERARCHY_ID35_77_,
        menuitem0_.INITIAL_STATUS as INITIAL_STATUS12_77_,
        menuitem0_.MAX_PARTICIPANT as MAX_PARTICIPANT13_77_,
        menuitem0_.MAX_PARTICIPANT_WEB as MAX_PARTICIPANT_W14_77_,
        menuitem0_.MI_TYPE as MI_TYPE15_77_,
        menuitem0_.NAME1 as NAME16_77_,
        menuitem0_.NAME2 as NAME17_77_,
        menuitem0_.NAME_STRING_ID as NAME_STRING_ID18_77_,
        menuitem0_.OPTIONS as OPTIONS19_77_,
        menuitem0_.PMS_CODE as PMS_CODE20_77_,
        menuitem0_.RETURN_CHARGE as RETURN_CHARGE21_77_,
        menuitem0_.RSRV_COUNT as RSRV_COUNT22_77_,
        menuitem0_.SI as SI36_77_,
        menuitem0_.SPA_CANCEL_CAT_ID as SPA_CANCEL_CAT_ID37_77_,
        menuitem0_.SUBSCR_ACTIVE_MI as SUBSCR_ACTIVE_MI23_77_,
        menuitem0_.SUBSCR_FROZEN_MI as SUBSCR_FROZEN_MI24_77_,
        menuitem0_.SUBSCR_PERIOD_COUNT as SUBSCR_PERIOD_COU25_77_,
        menuitem0_.SUBSCR_PERIOD_TYPE as SUBSCR_PERIOD_TYP26_77_,
        menuitem0_.TAX_CLASS as TAX_CLASS38_77_,
        menuitem0_.TREAT_CLEANOUT_TIME as TREAT_CLEANOUT_TI27_77_,
        menuitem0_.TREAT_DURATION as TREAT_DURATION28_77_,
        menuitem0_.TREAT_PREP_TIME as TREAT_PREP_TIME29_77_,
        menuitem0_.VOUCHER_CAMPAIGN_ID as VOUCHER_CAMPAIGN_39_77_,
        menuitem0_.WEBGRP as WEBGRP40_77_,
        UPPER(menuitem0_.CODE || ' ' || menuitem0_.NAME1) as formula2_,
        UPPER(menuitem0_.NAME1 || ' (' || menuitem0_.CODE || ')' ) as formula3_
    from
        club.MENU_ITEMS menuitem0_
    where
        (
            menuitem0_.CODE=?
        )
Hibernate:
    select
        taxclass0_.TAX_CLASS_ID as TAX_CLASS_ID1_116_0_,
        taxclass0_.NAME as NAME2_116_0_,
        taxclass0_.TAX_RATES as TAX_RATES3_116_0_
    from
        club.TAX_CLASSES taxclass0_
    where
        taxclass0_.TAX_CLASS_ID=?
Hibernate:
    select
        menuitem0_.MI_ID as MI_ID1_77_,
        menuitem0_.ACTIVE as ACTIVE2_77_,
        menuitem0_.BARCODE as BARCODE3_77_,
        menuitem0_.BASE_INV_UNIT_ID as BASE_INV_UNIT_ID30_77_,
        menuitem0_.BOOK_STEP as BOOK_STEP4_77_,
        menuitem0_.CODE as CODE5_77_,
        menuitem0_.COLOR as COLOR6_77_,
        menuitem0_.COMMISSION_GRP_ID as COMMISSION_GRP_ID31_77_,
        menuitem0_.COMPLEXITY as COMPLEXITY7_77_,
        menuitem0_.COST as COST8_77_,
        menuitem0_.DESCRIPTION as DESCRIPTION9_77_,
        menuitem0_.DESCRIPTION_STRING_ID as DESCRIPTION_STRIN10_77_,
        menuitem0_.DISCOUNT_RULESET_ID as DISCOUNT_RULESET_32_77_,
        menuitem0_.EXTN_GROUP as EXTN_GROUP11_77_,
        menuitem0_.FGRP as FGRP33_77_,
        menuitem0_.FAVOURITES_ID as FAVOURITES_ID34_77_,
        menuitem0_.HIERARCHY_ID as HIERARCHY_ID35_77_,
        menuitem0_.INITIAL_STATUS as INITIAL_STATUS12_77_,
        menuitem0_.MAX_PARTICIPANT as MAX_PARTICIPANT13_77_,
        menuitem0_.MAX_PARTICIPANT_WEB as MAX_PARTICIPANT_W14_77_,
        menuitem0_.MI_TYPE as MI_TYPE15_77_,
        menuitem0_.NAME1 as NAME16_77_,
        menuitem0_.NAME2 as NAME17_77_,
        menuitem0_.NAME_STRING_ID as NAME_STRING_ID18_77_,
        menuitem0_.OPTIONS as OPTIONS19_77_,
        menuitem0_.PMS_CODE as PMS_CODE20_77_,
        menuitem0_.RETURN_CHARGE as RETURN_CHARGE21_77_,
        menuitem0_.RSRV_COUNT as RSRV_COUNT22_77_,
        menuitem0_.SI as SI36_77_,
        menuitem0_.SPA_CANCEL_CAT_ID as SPA_CANCEL_CAT_ID37_77_,
        menuitem0_.SUBSCR_ACTIVE_MI as SUBSCR_ACTIVE_MI23_77_,
        menuitem0_.SUBSCR_FROZEN_MI as SUBSCR_FROZEN_MI24_77_,
        menuitem0_.SUBSCR_PERIOD_COUNT as SUBSCR_PERIOD_COU25_77_,
        menuitem0_.SUBSCR_PERIOD_TYPE as SUBSCR_PERIOD_TYP26_77_,
        menuitem0_.TAX_CLASS as TAX_CLASS38_77_,
        menuitem0_.TREAT_CLEANOUT_TIME as TREAT_CLEANOUT_TI27_77_,
        menuitem0_.TREAT_DURATION as TREAT_DURATION28_77_,
        menuitem0_.TREAT_PREP_TIME as TREAT_PREP_TIME29_77_,
        menuitem0_.VOUCHER_CAMPAIGN_ID as VOUCHER_CAMPAIGN_39_77_,
        menuitem0_.WEBGRP as WEBGRP40_77_,
        UPPER(menuitem0_.CODE || ' ' || menuitem0_.NAME1) as formula2_,
        UPPER(menuitem0_.NAME1 || ' (' || menuitem0_.CODE || ')' ) as formula3_
    from
        club.MENU_ITEMS menuitem0_
    where
        (
            menuitem0_.CODE=?
        )
Hibernate:
    select
        menufgrp0_.FGRP_ID as FGRP_ID1_76_0_,
        menufgrp0_.NAME as NAME2_76_0_
    from
        club.MENU_FGRP menufgrp0_
    where
        menufgrp0_.FGRP_ID=?
Hibernate:
    select
        menusi0_.SI_ID as SI_ID1_81_0_,
        menusi0_.DEP_CODE as DEP_CODE2_81_0_,
        menusi0_.NAME as NAME3_81_0_
    from
        club.MENU_SI menusi0_
    where
        menusi0_.SI_ID=?
Hibernate:
    select
        docdtl_.DOC_ID,
        docdtl_.DTL_SEQ,
        docdtl_.MI_SEQ,
        docdtl_.BOOKING_ID as BOOKING_ID3_44_,
        docdtl_.CASHIER_SHIFT_ID as CASHIER_SHIFT_ID4_44_,
        docdtl_.COUNT as COUNT5_44_,
        docdtl_.DSC as DSC6_44_,
        docdtl_.DSC_REASON as DSC_REASON7_44_,
        docdtl_.FGRP as FGRP8_44_,
        docdtl_.MANUAL_SVC as MANUAL_SVC9_44_,
        docdtl_.MANUAL_DSC as MANUAL_DSC10_44_,
        docdtl_.MI_ID as MI_ID11_44_,
        docdtl_.NAME as NAME12_44_,
        docdtl_.POSTING_EMPL_ID as POSTING_EMPL_ID13_44_,
        docdtl_.PAY_TTL_DEPOSIT as PAY_TTL_DEPOSIT14_44_,
        docdtl_.PAY_TTL_SUBSCR as PAY_TTL_SUBSCR15_44_,
        docdtl_.POINTS as POINTS16_44_,
        docdtl_.REFERENCE as REFERENCE17_44_,
        docdtl_.COMISSION_EMPL_ID as COMISSION_EMPL_ID18_44_,
        docdtl_.SI as SI19_44_,
        docdtl_.TAX_ADD as TAX_ADD20_44_,
        docdtl_.TAX_ADDON as TAX_ADDON21_44_,
        docdtl_.TAX_VAT as TAX_VAT22_44_,
        docdtl_.TICKETS as TICKETS23_44_,
        docdtl_.TM as TM24_44_,
        docdtl_.TTL as TTL25_44_,
        docdtl_.VOID_FLAG as VOID_FLAG26_44_,
        docdtl_.VOID_REASON as VOID_REASON27_44_
    from
        club.DOCS_DTL docdtl_
    where
        docdtl_.DOC_ID=?
        and docdtl_.DTL_SEQ=?
        and docdtl_.MI_SEQ=?
Hibernate:
    select
        docpaym_.DOC_ID,
        docpaym_.PAYM_SEQ,
        docpaym_.AMOUNT as AMOUNT2_45_,
        docpaym_.CASHIER_SHIFT_ID as CASHIER_SHIFT_ID3_45_,
        docpaym_.CURRENCY_ID as CURRENCY_ID12_45_,
        docpaym_.CURRENCY_AMOUNT as CURRENCY_AMOUNT4_45_,
        docpaym_.TM_NAME as TM_NAME5_45_,
        docpaym_.POSTING_TM as POSTING_TM6_45_,
        docpaym_.REFERENCE as REFERENCE7_45_,
        docpaym_.TM_ID as TM_ID8_45_,
        docpaym_.VOID_FLAG as VOID_FLAG9_45_,
        docpaym_.VOID_REFERENCE as VOID_REFERENCE10_45_
    from
        club.DOCS_PAYM docpaym_
    where
        docpaym_.DOC_ID=?
        and docpaym_.PAYM_SEQ=?
Hibernate:
    select
        invdoc0_.INV_DOCS_ID as INV_DOCS_ID1_62_,
        invdoc0_.AMOUNT as AMOUNT2_62_,
        invdoc0_.BOOKING_ID as BOOKING_ID12_62_,
        invdoc0_.CONFIRMATION as CONFIRMATION3_62_,
        invdoc0_.DOC_ID as DOC_ID4_62_,
        invdoc0_.DST_STORE_ID as DST_STORE_ID13_62_,
        invdoc0_.EXT_DOC_NUM as EXT_DOC_NUM5_62_,
        invdoc0_.MOD_OPERATOR as MOD_OPERATOR6_62_,
        invdoc0_.MI_ID as MI_ID14_62_,
        invdoc0_.NOTES as NOTES7_62_,
        invdoc0_.OP_CODE as OP_CODE8_62_,
        invdoc0_.OPERATOR as OPERATOR9_62_,
        invdoc0_.SRC_STORE_ID as SRC_STORE_ID15_62_,
        invdoc0_.INV_SUPPLIER_ID as INV_SUPPLIER_ID16_62_,
        invdoc0_.DATE_TM as DATE_TM10_62_,
        invdoc0_.XTRA_COST as XTRA_COST11_62_
    from
        club.INV_DOCS invdoc0_
    where
        (
            invdoc0_.DOC_ID=?
        )
        and(
            invdoc0_.MI_ID is null
        )
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    insert
    into
        club.DOCS_TAX
        (AMOUNT, NAME, TAX_ID, RATE, TYPE, DOC_ID, SEQ)
    values
        (?, ?, ?, ?, ?, ?, ?)
Hibernate:
    insert
    into
        club.DOCS_DTL
        (BOOKING_ID, CASHIER_SHIFT_ID, COUNT, DSC, DSC_REASON, FGRP, MANUAL_SVC, MANUAL_DSC, MI_ID, NAME, POSTING_EMPL_ID, PAY_TTL_DEPOSIT, PAY_TTL_SUBSCR, POINTS, REFERENCE, COMISSION_EMPL_ID, SI, TAX_ADD, TAX_ADDON, TAX_VAT, TICKETS, TM, TTL, VOID_FLAG, VOID_REASON, DOC_ID, DTL_SEQ, MI_SEQ)
    values
        (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
    insert
    into
        club.DOCS_PAYM
        (AMOUNT, CASHIER_SHIFT_ID, CURRENCY_ID, CURRENCY_AMOUNT, TM_NAME, POSTING_TM, REFERENCE, TM_ID, VOID_FLAG, VOID_REFERENCE, DOC_ID, PAYM_SEQ)
    values
        (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
    update
        club.DOCS
    set
        BUSSINES_DATE=?,
        DEF_CARD_ID=?,
        DEF_CARD_TYPE_ID=?,
        CHCK_ID=?,
        CHECK_OPEN=?,
        CHKNUM=?,
        COFIRMATION=?,
        DOC_TYPE=?,
        GST=?,
        IMAGE=?,
        INVOICE_ID=?,
        DEF_MAGSTRIPE=?,
        OPERATOR=?,
        REGISTRATION_ID=?,
        RVC=?,
        SP=?,
        TAX_EXEMPT=?,
        TM=?,
        TM_OPEN=?,
        TTL=?,
        VER=?
    where
        DOC_ID=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        employee0_.EMPL_ID as EMPL_ID1_48_0_,
        employee0_.ACTIVE as ACTIVE2_48_0_,
        employee0_.ALLOWED_RVC_GROUP_ID as ALLOWED_RVC_GROUP18_48_0_,
        employee0_.BOOKING_PRIORITY as BOOKING_PRIORITY3_48_0_,
        employee0_.CARD_ID as CARD_ID4_48_0_,
        employee0_.CURRENT_RVC_ID as CURRENT_RVC_ID19_48_0_,
        employee0_.EMAIL as EMAIL5_48_0_,
        employee0_.EXTERNAL as EXTERNAL6_48_0_,
        employee0_.GENDER as GENDER7_48_0_,
        employee0_.HIERARCHY_ID as HIERARCHY_ID20_48_0_,
        employee0_.INV_STORE_ID as INV_STORE_ID21_48_0_,
        employee0_.LOGON as LOGON8_48_0_,
        employee0_.MAGSTRIPE as MAGSTRIPE9_48_0_,
        employee0_.MANAGER_EMPL_ID as MANAGER_EMPL_ID22_48_0_,
        employee0_.NAME1 as NAME10_48_0_,
        employee0_.NAME2 as NAME11_48_0_,
        employee0_.PASSWORD as PASSWORD12_48_0_,
        employee0_.PASSWORD_CHANGE_TM as PASSWORD_CHANGE_T13_48_0_,
        employee0_.PHONE as PHONE14_48_0_,
        employee0_.PRIORITY as PRIORITY15_48_0_,
        employee0_.SALARY_CLASS_ID as SALARY_CLASS_ID23_48_0_,
        employee0_.TARGET_AMNT as TARGET_AMNT16_48_0_,
        employee0_.TARGET_CNT as TARGET_CNT17_48_0_,
        employee0_.ROLE_ID as ROLE_ID24_48_0_,
        employee0_.NAME2 || ' ' || employee0_.NAME1 as formula1_0_
    from
        club.EMPLOYEES employee0_
    where
        employee0_.EMPL_ID=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
Hibernate:
    select
        system0_.PARAM_NAME as PARAM_NAME1_114_0_,
        system0_.VALUE as VALUE2_114_0_
    from
        club.SYSTEM system0_
    where
        system0_.PARAM_NAME=?
15.08.16 17:06:29:125 - INFO - DocConfirmHelper - *** handleDocConfirmRequest ***
15.08.16 17:06:29:125 - INFO - DocConfirmHelper - PostingGUID: 4694
Hibernate:
    select
        doc0_.DOC_ID as DOC_ID1_42_0_,
        doc0_.BUSSINES_DATE as BUSSINES_DATE2_42_0_,
        doc0_.DEF_CARD_ID as DEF_CARD_ID3_42_0_,
        doc0_.DEF_CARD_TYPE_ID as DEF_CARD_TYPE_ID4_42_0_,
        doc0_.CHCK_ID as CHCK_ID5_42_0_,
        doc0_.CHECK_OPEN as CHECK_OPEN6_42_0_,
        doc0_.CHKNUM as CHKNUM7_42_0_,
        doc0_.COFIRMATION as COFIRMATION8_42_0_,
        doc0_.DOC_TYPE as DOC_TYPE9_42_0_,
        doc0_.GST as GST10_42_0_,
        doc0_.IMAGE as IMAGE11_42_0_,
        doc0_.INVOICE_ID as INVOICE_ID20_42_0_,
        doc0_.DEF_MAGSTRIPE as DEF_MAGSTRIPE12_42_0_,
        doc0_.OPERATOR as OPERATOR13_42_0_,
        doc0_.REGISTRATION_ID as REGISTRATION_ID21_42_0_,
        doc0_.RVC as RVC22_42_0_,
        doc0_.SP as SP14_42_0_,
        doc0_.TAX_EXEMPT as TAX_EXEMPT15_42_0_,
        doc0_.TM as TM16_42_0_,
        doc0_.TM_OPEN as TM_OPEN17_42_0_,
        doc0_.TTL as TTL18_42_0_,
        doc0_.VER as VER19_42_0_
    from
        club.DOCS doc0_
    where
        doc0_.DOC_ID=?
15.08.16 17:06:29:128 - INFO - DocConfirmHelper - confirmation: T
Hibernate:
    select
        rvc0_.RVC_ID as RVC_ID1_97_0_,
        rvc0_.BUSSINES_DATE_START as BUSSINES_DATE_STAR2_97_0_,
        rvc0_.LAST_CHECK_NUM as LAST_CHECK_NUM3_97_0_,
        rvc0_.NAME as NAME4_97_0_,
        rvc0_.OPTIONS as OPTIONS5_97_0_,
        rvc0_.POS_RVC as POS_RVC6_97_0_,
        rvc0_.REG_RVC_GROUP_ID as REG_RVC_GROUP_ID11_97_0_,
        rvc0_.SALE_STORE_ID as SALE_STORE_ID12_97_0_,
        rvc0_.SITE_ID as SITE_ID13_97_0_,
        rvc0_.TIME_ZONE as TIME_ZONE14_97_0_,
        rvc0_.TREAT_STORE_ID as TREAT_STORE_ID15_97_0_,
        rvc0_.WEB_BOOK_ENABLE as WEB_BOOK_ENABLE7_97_0_,
        rvc0_.WEB_PAYM_DRIVER as WEB_PAYM_DRIVER8_97_0_,
        rvc0_.WEB_PAYM_KEY as WEB_PAYM_KEY9_97_0_,
        rvc0_.WEB_PAYM_URL as WEB_PAYM_URL10_97_0_,
        rvc0_.NAME || ' (' || rvc0_.RVC_ID || ')' as formula4_0_,
        invstore1_.INV_STORE_ID as INV_STORE_ID1_64_1_,
        invstore1_.IS_CENTAL as IS_CENTAL2_64_1_,
        invstore1_.NAME as NAME3_64_1_,
        invstore1_.RETAIL_RVC_ID as RETAIL_RVC_ID4_64_1_,
        invstore2_.INV_STORE_ID as INV_STORE_ID1_64_2_,
        invstore2_.IS_CENTAL as IS_CENTAL2_64_2_,
        invstore2_.NAME as NAME3_64_2_,
        invstore2_.RETAIL_RVC_ID as RETAIL_RVC_ID4_64_2_
    from
        club.RVC rvc0_
    left outer join
        club.INV_STORE invstore1_
            on rvc0_.SALE_STORE_ID=invstore1_.INV_STORE_ID
    left outer join
        club.INV_STORE invstore2_
            on rvc0_.TREAT_STORE_ID=invstore2_.INV_STORE_ID
    where
        rvc0_.RVC_ID=?
Hibernate:
    select
        timezone0_.ID as ID1_131_0_,
        timezone0_.NAME as NAME2_131_0_
    from
        club.TIME_ZONE timezone0_
    where
        timezone0_.ID=?
15.08.16 17:06:29:131 - INFO - DocService - Doc Save 4694
Hibernate:
    select
        details0_.DOC_ID as DOC_ID28_42_0_,
        details0_.DOC_ID as DOC_ID28_44_0_,
        details0_.DTL_SEQ as DTL_SEQ1_44_0_,
        details0_.MI_SEQ as MI_SEQ2_44_0_,
        details0_.DOC_ID as DOC_ID28_44_1_,
        details0_.DTL_SEQ as DTL_SEQ1_44_1_,
        details0_.MI_SEQ as MI_SEQ2_44_1_,
        details0_.BOOKING_ID as BOOKING_ID3_44_1_,
        details0_.CASHIER_SHIFT_ID as CASHIER_SHIFT_ID4_44_1_,
        details0_.COUNT as COUNT5_44_1_,
        details0_.DSC as DSC6_44_1_,
        details0_.DSC_REASON as DSC_REASON7_44_1_,
        details0_.FGRP as FGRP8_44_1_,
        details0_.MANUAL_SVC as MANUAL_SVC9_44_1_,
        details0_.MANUAL_DSC as MANUAL_DSC10_44_1_,
        details0_.MI_ID as MI_ID11_44_1_,
        details0_.NAME as NAME12_44_1_,
        details0_.POSTING_EMPL_ID as POSTING_EMPL_ID13_44_1_,
        details0_.PAY_TTL_DEPOSIT as PAY_TTL_DEPOSIT14_44_1_,
        details0_.PAY_TTL_SUBSCR as PAY_TTL_SUBSCR15_44_1_,
        details0_.POINTS as POINTS16_44_1_,
        details0_.REFERENCE as REFERENCE17_44_1_,
        details0_.COMISSION_EMPL_ID as COMISSION_EMPL_ID18_44_1_,
        details0_.SI as SI19_44_1_,
        details0_.TAX_ADD as TAX_ADD20_44_1_,
        details0_.TAX_ADDON as TAX_ADDON21_44_1_,
        details0_.TAX_VAT as TAX_VAT22_44_1_,
        details0_.TICKETS as TICKETS23_44_1_,
        details0_.TM as TM24_44_1_,
        details0_.TTL as TTL25_44_1_,
        details0_.VOID_FLAG as VOID_FLAG26_44_1_,
        details0_.VOID_REASON as VOID_REASON27_44_1_
    from
        club.DOCS_DTL details0_
    where
        details0_.DOC_ID=?
15.08.16 17:06:29:133 - INFO - DocService - Doc Save Check doc.cofirmation=T ttl=57.0
15.08.16 17:06:29:134 - INFO - DocService - Doc Save Check updDoc =true and oldDocConfirmation=F
15.08.16 17:06:29:134 - INFO - DocService - Doc confirmed. Adjusting balances
Hibernate:
    select
        itemaccoun0_.DOC_ID as DOC_ID4_68_,
        itemaccoun0_.SEQ as SEQ1_68_,
        itemaccoun0_.CARD_ID as CARD_ID5_68_,
        itemaccoun0_.MI_COUNT as MI_COUNT2_68_,
        itemaccoun0_.SUBSCRIPTION_ACCOUNTING_ID as SUBSCRIPTION_ACCOU6_68_,
        itemaccoun0_.SUBSCRIPTION_ITEM_ID as SUBSCRIPTION_ITEM_7_68_,
        itemaccoun0_.VALUE_TTL as VALUE_TTL3_68_
    from
        club.ITEM_ACCOUNTING itemaccoun0_
    where
        (
            itemaccoun0_.DOC_ID=?
        )
Hibernate:
    select
        accounting0_.DOC_ID as DOC_ID7_0_,
        accounting0_.SEQ as SEQ1_0_,
        accounting0_.ACCOUNT_DEF_ID as ACCOUNT_DEF_ID8_0_,
        accounting0_.AMOUNT as AMOUNT2_0_,
        accounting0_.CARD_ID as CARD_ID9_0_,
        accounting0_.EXPIRY_DATE as EXPIRY_DATE3_0_,
        accounting0_.IMMED as IMMED4_0_,
        accounting0_.LOAN_FLAG as LOAN_FLAG5_0_,
        accounting0_.TAG as TAG6_0_
    from
        club.ACCOUNTING accounting0_
    where
        (
            accounting0_.DOC_ID=?
        )
Hibernate:
    select
        accountdef0_.ACCOUNT_DEF_ID as ACCOUNT_DEF_ID1_2_0_,
        accountdef0_.ACCOUNT_CODE as ACCOUNT_CODE2_2_0_,
        accountdef0_.ACCOUNT_TYPE as ACCOUNT_TYPE3_2_0_,
        accountdef0_.AUTO_RENEW as AUTO_RENEW4_2_0_,
        accountdef0_.TASK_TYPE_ID as TASK_TYPE_ID10_2_0_,
        accountdef0_.CURRENCY_ID as CURRENCY_ID11_2_0_,
        accountdef0_.EXPIRATION as EXPIRATION5_2_0_,
        accountdef0_.NAME as NAME6_2_0_,
        accountdef0_.ORDR as ORDR7_2_0_,
        accountdef0_.POINTS_RATE as POINTS_RATE8_2_0_,
        accountdef0_.POINTS_ROUNDING as POINTS_ROUNDING9_2_0_,
        accountdef0_.RULESET_ID as RULESET_ID12_2_0_,
        accountdef0_.ACCOUNT_CODE || ' ' || accountdef0_.NAME as formula0_0_
    from
        club.ACCOUNT_DEF accountdef0_
    where
        accountdef0_.ACCOUNT_DEF_ID=?
Hibernate:
    select
        card0_.CARD_ID as CARD_ID1_20_0_,
        card0_.IS_ARCHIVED as IS_ARCHIVED2_20_0_,
        card0_.BIRTH_DATE as BIRTH_DATE3_20_0_,
        card0_.CARD_STATUS_ID as CARD_STATUS_ID78_20_0_,
        card0_.CARD_TYPE_ID as CARD_TYPE_ID79_20_0_,
        card0_.CELL_PHONE as CELL_PHONE4_20_0_,
        card0_.CITY as CITY5_20_0_,
        card0_.COMPANY as COMPANY6_20_0_,
        card0_.COUNTRY as COUNTRY7_20_0_,
        card0_.CREATED_DATE as CREATED_DATE8_20_0_,
        card0_.CREATED_PERSON as CREATED_PERSON9_20_0_,
        card0_.EMAIL as EMAIL10_20_0_,
        card0_.FIRST_NAME as FIRST_NAME11_20_0_,
        card0_.GENDER as GENDER12_20_0_,
        card0_.GREETING as GREETING13_20_0_,
        card0_.HEALTH_INFO as HEALTH_INFO14_20_0_,
        card0_.JOB_TITLE as JOB_TITLE15_20_0_,
        card0_.LANG as LANG16_20_0_,
        card0_.LAST_NAME as LAST_NAME17_20_0_,
        card0_.LAST_USED_RVC_ID as LAST_USED_RVC_ID18_20_0_,
        card0_.MAGSTRIPE as MAGSTRIPE19_20_0_,
        card0_.MAILING_OPT as MAILING_OPT20_20_0_,
        card0_.MASTER_CARD_ID as MASTER_CARD_ID80_20_0_,
        card0_.MAX_CHILDREN as MAX_CHILDREN21_20_0_,
        card0_.MLST_SYNC_STATUS as MLST_SYNC_STATUS22_20_0_,
        card0_.NOTES as NOTES23_20_0_,
        card0_.PASSPORT as PASSPORT24_20_0_,
        card0_.PASSWORD as PASSWORD25_20_0_,
        card0_.PHONE as PHONE26_20_0_,
        card0_.PROFILE_TYPE as PROFILE_TYPE27_20_0_,
        card0_.RATE as RATE28_20_0_,
        card0_.SECOND_NAME as SECOND_NAME29_20_0_,
        card0_.SOURCE as SOURCE30_20_0_,
        card0_.STREET_ADDRESS as STREET_ADDRESS31_20_0_,
        card0_.TITLE as TITLE32_20_0_,
        card0_.UDFD1 as UDFD33_20_0_,
        card0_.UDFD10 as UDFD34_20_0_,
        card0_.UDFD2 as UDFD35_20_0_,
        card0_.UDFD3 as UDFD36_20_0_,
        card0_.UDFD4 as UDFD37_20_0_,
        card0_.UDFD5 as UDFD38_20_0_,
        card0_.UDFD6 as UDFD39_20_0_,
        card0_.UDFD7 as UDFD40_20_0_,
        card0_.UDFD8 as UDFD41_20_0_,
        card0_.UDFD9 as UDFD42_20_0_,
        card0_.UDFN1 as UDFN43_20_0_,
        card0_.UDFN10 as UDFN44_20_0_,
        card0_.UDFN2 as UDFN45_20_0_,
        card0_.UDFN3 as UDFN46_20_0_,
        card0_.UDFN4 as UDFN47_20_0_,
        card0_.UDFN5 as UDFN48_20_0_,
        card0_.UDFN6 as UDFN49_20_0_,
        card0_.UDFN7 as UDFN50_20_0_,
        card0_.UDFN8 as UDFN51_20_0_,
        card0_.UDFN9 as UDFN52_20_0_,
        card0_.UDFS1 as UDFS53_20_0_,
        card0_.UDFS10 as UDFS54_20_0_,
        card0_.UDFS11 as UDFS55_20_0_,
        card0_.UDFS12 as UDFS56_20_0_,
        card0_.UDFS13 as UDFS57_20_0_,
        card0_.UDFS14 as UDFS58_20_0_,
        card0_.UDFS15 as UDFS59_20_0_,
        card0_.UDFS16 as UDFS60_20_0_,
        card0_.UDFS17 as UDFS61_20_0_,
        card0_.UDFS18 as UDFS62_20_0_,
        card0_.UDFS19 as UDFS63_20_0_,
        card0_.UDFS2 as UDFS64_20_0_,
        card0_.UDFS20 as UDFS65_20_0_,
        card0_.UDFS3 as UDFS66_20_0_,
        card0_.UDFS4 as UDFS67_20_0_,
        card0_.UDFS5 as UDFS68_20_0_,
        card0_.UDFS6 as UDFS69_20_0_,
        card0_.UDFS7 as UDFS70_20_0_,
        card0_.UDFS8 as UDFS71_20_0_,
        card0_.UDFS9 as UDFS72_20_0_,
        card0_.UPDATE_DATE as UPDATE_DATE73_20_0_,
        card0_.UPDATE_PERSON as UPDATE_PERSON74_20_0_,
        card0_.VALID_TILL as VALID_TILL75_20_0_,
        card0_.VIP_STATUS as VIP_STATUS76_20_0_,
        card0_.ZIP_CODE as ZIP_CODE77_20_0_
    from
        club.CARDS card0_
    where
        card0_.CARD_ID=?
Hibernate:
    select
        this_.ID as ID1_1_1_,
        this_.ACCOUNT_DEF_ID as ACCOUNT_DEF_ID7_1_1_,
        this_.AMOUNT as AMOUNT2_1_1_,
        this_.CARD_ID as CARD_ID3_1_1_,
        this_.CRD_TTL as CRD_TTL4_1_1_,
        this_.LAST_EXPIRY as LAST_EXPIRY5_1_1_,
        this_.LOAN as LOAN6_1_1_,
        accountdef2_.ACCOUNT_DEF_ID as ACCOUNT_DEF_ID1_2_0_,
        accountdef2_.ACCOUNT_CODE as ACCOUNT_CODE2_2_0_,
        accountdef2_.ACCOUNT_TYPE as ACCOUNT_TYPE3_2_0_,
        accountdef2_.AUTO_RENEW as AUTO_RENEW4_2_0_,
        accountdef2_.TASK_TYPE_ID as TASK_TYPE_ID10_2_0_,
        accountdef2_.CURRENCY_ID as CURRENCY_ID11_2_0_,
        accountdef2_.EXPIRATION as EXPIRATION5_2_0_,
        accountdef2_.NAME as NAME6_2_0_,
        accountdef2_.ORDR as ORDR7_2_0_,
        accountdef2_.POINTS_RATE as POINTS_RATE8_2_0_,
        accountdef2_.POINTS_ROUNDING as POINTS_ROUNDING9_2_0_,
        accountdef2_.RULESET_ID as RULESET_ID12_2_0_,
        accountdef2_.ACCOUNT_CODE || ' ' || accountdef2_.NAME as formula0_0_
    from
        club.ACCOUNTING_BALANCE this_
    inner join
        club.ACCOUNT_DEF accountdef2_
            on this_.ACCOUNT_DEF_ID=accountdef2_.ACCOUNT_DEF_ID
    where
        this_.CARD_ID=?
        and this_.ACCOUNT_DEF_ID=?
Hibernate:
    select
        docdtl0_.DOC_ID as DOC_ID28_44_,
        docdtl0_.DTL_SEQ as DTL_SEQ1_44_,
        docdtl0_.MI_SEQ as MI_SEQ2_44_,
        docdtl0_.BOOKING_ID as BOOKING_ID3_44_,
        docdtl0_.CASHIER_SHIFT_ID as CASHIER_SHIFT_ID4_44_,
        docdtl0_.COUNT as COUNT5_44_,
        docdtl0_.DSC as DSC6_44_,
        docdtl0_.DSC_REASON as DSC_REASON7_44_,
        docdtl0_.FGRP as FGRP8_44_,
        docdtl0_.MANUAL_SVC as MANUAL_SVC9_44_,
        docdtl0_.MANUAL_DSC as MANUAL_DSC10_44_,
        docdtl0_.MI_ID as MI_ID11_44_,
        docdtl0_.NAME as NAME12_44_,
        docdtl0_.POSTING_EMPL_ID as POSTING_EMPL_ID13_44_,
        docdtl0_.PAY_TTL_DEPOSIT as PAY_TTL_DEPOSIT14_44_,
        docdtl0_.PAY_TTL_SUBSCR as PAY_TTL_SUBSCR15_44_,
        docdtl0_.POINTS as POINTS16_44_,
        docdtl0_.REFERENCE as REFERENCE17_44_,
        docdtl0_.COMISSION_EMPL_ID as COMISSION_EMPL_ID18_44_,
        docdtl0_.SI as SI19_44_,
        docdtl0_.TAX_ADD as TAX_ADD20_44_,
        docdtl0_.TAX_ADDON as TAX_ADDON21_44_,
        docdtl0_.TAX_VAT as TAX_VAT22_44_,
        docdtl0_.TICKETS as TICKETS23_44_,
        docdtl0_.TM as TM24_44_,
        docdtl0_.TTL as TTL25_44_,
        docdtl0_.VOID_FLAG as VOID_FLAG26_44_,
        docdtl0_.VOID_REASON as VOID_REASON27_44_
    from
        club.DOCS_DTL docdtl0_
    where
        (
            DOC_ID=?
        )
Hibernate:
    select
        subscripti0_.SUBSCRIPTION_ACCOUNTING_ID as SUBSCRIPTION_ACCOU1_112_,
        subscripti0_.CANCELLATION_REASON as CANCELLATION_REASO2_112_,
        subscripti0_.CARD_ID as CARD_ID16_112_,
        subscripti0_.DOC_ID as DOC_ID17_112_,
        subscripti0_.DSC_RULESET_ID as DSC_RULESET_ID18_112_,
        subscripti0_.DSC_VALID_TILL as DSC_VALID_TILL3_112_,
        subscripti0_.EMPL_ID as EMPL_ID4_112_,
        subscripti0_.EXPIRATION_DATE as EXPIRATION_DATE5_112_,
        subscripti0_.EXTN_FLAG as EXTN_FLAG6_112_,
        subscripti0_.IS_MEMBERSHIP as IS_MEMBERSHIP7_112_,
        subscripti0_.ISSUE_DATE as ISSUE_DATE8_112_,
        subscripti0_.MMSHP_END_DATE as MMSHP_END_DATE9_112_,
        subscripti0_.MMSHP_START_DATE as MMSHP_START_DATE10_112_,
        subscripti0_.NOTE as NOTE11_112_,
        subscripti0_.PRICE as PRICE12_112_,
        subscripti0_.REF_NUM as REF_NUM13_112_,
        subscripti0_.STATUS as STATUS14_112_,
        subscripti0_.SUBSCRIPTION_MI_ID as SUBSCRIPTION_MI_I19_112_,
        subscripti0_.VALUE_TTL as VALUE_TTL15_112_
    from
        club.SUBSCRIPTION_ACCOUNTING subscripti0_,
        club.MENU_ITEMS menuitem1_
    where
        (
            subscripti0_.DOC_ID=?
        )
        AND(
            menuitem1_.CODE=?
            and subscripti0_.SUBSCRIPTION_MI_ID=menuitem1_.MI_ID
        )
15.08.16 17:06:29:151 - INFO - DocConfirmHelper - *** handleDocConfirmRequest end ***
Hibernate:
    update
        club.DOCS
    set
        BUSSINES_DATE=?,
        DEF_CARD_ID=?,
        DEF_CARD_TYPE_ID=?,
        CHCK_ID=?,
        CHECK_OPEN=?,
        CHKNUM=?,
        COFIRMATION=?,
        DOC_TYPE=?,
        GST=?,
        IMAGE=?,
        INVOICE_ID=?,
        DEF_MAGSTRIPE=?,
        OPERATOR=?,
        REGISTRATION_ID=?,
        RVC=?,
        SP=?,
        TAX_EXEMPT=?,
        TM=?,
        TM_OPEN=?,
        TTL=?,
        VER=?
    where
        DOC_ID=?
Hibernate:
    update
        club.ACCOUNTING_BALANCE
    set
        ACCOUNT_DEF_ID=?,
        AMOUNT=?,
        CARD_ID=?,
        CRD_TTL=?,
        LAST_EXPIRY=?,
        LOAN=?
    where
        ID=?