|
|
| |
 |
 |
 |
 |
 |
 |
 |
 |
|
 |
 |
 |
 |
 |
|
|
|
|
|
|
SELECT CCAT AS CATEGORY,CHDR AS HEADER,TO_NUMBER(CSRNO) AS SQNC_NO,CLOC AS LOCATION,TO_CHAR(CCHLNO) AS CHLLN_NO,CDTDP AS DEPOSIT_DATE, CBNKCD1 AS BNK_ID,CBNKCD2 AS BRNCH_ID,CALLNAME AS ALLTTEE_NM,CADD1||CADD2||CADD3 AS ADDRSS, CAMT AS AMOUNT From TH_CHLLN_OLD_N where ( CCAT='' OR flt_ctgry_hdr='' )and (CHDR= OR lclty_hdr= ) and (LTRIM(CSRNO,0)=ltrim('',0) OR LTRIM(SQNC_NO,0)=LTRIM('',0))and (YR='' OR CYR='' ) UNION ALL SELECT FLT_CTGRY_HDR AS CATEGORY,LCLTY_HDR AS HEADER,SQNC_NO AS SQNC_NO,LCLTY_ID AS LOCATION, CHLLN_NO AS CHLLN_NO,DPST_DT AS DEPOSIT_DATE,BNK_ID AS BNK_ID,BRNCH_ID AS BRNCH_ID,ALLTTEE_NM AS ALLTTEE_NM,ADDRSS AS ADDRSS,CHLLN_AMNT AS AMOUNT From TH_CHLLN where ( FLT_CTGRY_HDR='' OR CCAT='' )and ( LCLTY_HDR= OR CHDR= ) and (SQNC_NO= OR CSRLNO = )and (TO_CHAR(YR,'YYYY')='' OR TO_CHAR(CYEAR,'YYYY')='' ) OraOLEDB error '80040e14'ORA-00936: missing expression /housing/3Npayment_results_next.asp, line 222 |
