
var override_queryfields = [
		{
			name : 'wfl_mdf_status_flag',
			queryexpression : "${@wfl_mdf_status_flag}=&apos;Y&apos; and nvl(tlc.LOAN_CON_WFL_STATUS,&apos;WFL_NEW&apos;) not in(&apos;WFL_APPROVING&apos;,&apos;WFL_APPROVED&apos;) "
		},
		{
			field : 'business_type',
			queryoperator : '='
		},
		{
			field : 'currency',
			queryoperator : '='
		},
		{
			field : 'inside_or_outside',
			queryoperator : '='
		},
		{
			field : 'within_the_group',
			queryoperator : '='
		},
		{
			field : 'loan_contract_id',
			queryoperator : '='
		},
		{
			field : 'loan_contract_number',
			queryoperator : 'like'
		},
		{
			field : 'loan_contract_name',
			queryoperator : 'like'
		},
		{
			name : 'loan_con_type_detail',
			queryexpression : 'T1.loan_con_type_detail=${@loan_con_type_detail}'
		},
		{
			name : 'loan_con_bp',
			queryexpression : "T1.loan_con_bp=${@loan_con_bp}"
		},
		{
			field : 'loan_con_bp_n',
			queryoperator : "like"
		},
		{
			field : 'bank_branch_bp_id_n',
			queryoperator : "like"
		},
		{
			name : 'loan_date_from',
			queryexpression : "T1.loan_date_from>=trunc(to_date(${@loan_date_from},'yyyy-mm-dd'))"
		},
		{
			name : 'loan_date_to',
			queryexpression : "trunc(T1.loan_date_to)<=to_date(${@loan_date_to},'yyyy-mm-dd')"
		},
		{
			name : 'status_check_flag',
			queryexpression : "${@status_check_flag}='Y'  AND t1.data_class = 'NORMAL'  AND ((t1.loan_contract_status = 'NEW' AND nvl(t1.loan_con_wfl_status, 'WFL_NEW') IN ('WFL_NEW',  'WFL_REJECTED')) OR (not exists( select 1 FROM tre_loan_con_repayment_plan rp, prj_quotation q WHERE rp.quotation_id = q.quotation_id AND nvl(q.main_contract_flag, 'N') = 'N' AND rp.write_off_flag <> 'Y')  AND t1.loan_contract_status = 'REVIEWED'))" 
		}
		 ];

override();
