https://xmlpublishertemplate.blogspot.com/2019/01/how-to-display-character-like-between.html
select distinct substr( ' & '||trx_type.name,2) TRX_TYPE_NAME
from
ar_customers cust
,Ra_Cust_Trx_Line_Gl_Dist_All trx_gl,
gl_code_combinations gcc,
ra_customer_trx_all trx_all,
ra_cust_trx_types_all trx_type, -- , -- 25 JUL 2011
gl_code_combinations gcc2
where
trx_all.org_id between nvl(:FR_ORG_ID,:P_ORG_ID) and nvl(:TO_ORG_ID,:P_ORG_ID)
and trx_all.org_id = :P_ORG_ID
and trx_all.trx_date between UPPER(nvl(:frdate,'01-JUL-94')) and UPPER(nvl(:todate,Sysdate))
and gcc.CODE_COMBINATION_ID=trx_gl.CODE_COMBINATION_ID
and trx_gl.CUSTOMER_TRX_ID=trx_all.CUSTOMER_TRX_ID
and cust.CUSTOMER_ID=trx_all.BILL_TO_CUSTOMER_ID
and gcc.SEGMENT2 = nvl(:location,gcc.SEGMENT2)
and cust.CUSTOMER_name like nvl(:cust_name,cust.CUSTOMER_name)
and trx_type.name LIKE NVL(:inv_Type,'%')
and trx_all.cust_trx_type_id = trx_type.cust_trx_type_id
and trunc(trx_gl.GL_DATE) <= nvl(:p_term_due_date_to,trx_all.term_due_date)
and trx_type.GL_ID_REC = gcc2.CODE_COMBINATION_ID
and gcc2.SEGMENT4 = :ACCOUNT_GRP;
In RTF Template add in Text form Field Options
<?substring(TRX_TYPE_NAME,4)?>
The Result will be like
ELT & TIU & LKK
No comments:
Post a Comment