XTR Admin - Limit Exceptions Log

Description
Categories: BI Publisher
Application: Treasury
Source: Admin - Limit Exceptions Log (XML)
Short Name: XTRLIEXP_XML
DB package: XTR_XTRLIEXP_XMLP_PKG
Select 	a.AMOUNT_DATE			Qry_Amount_Date		, 
	a.AUTHORISED_BY			Qry_Authorised_By		, 
	a.COMPANY_CODE			Qry_Company_Code	, 
	a.DEALER_CODE			Qry_Dealer_Code		, 
	a.DEAL_NUMBER			Qry_Deal_Number		, 
	a.EXCEEDED_BY_AMOUNT/:AMT_UNIT2 Qry_Exceeded_Amount	, 	
	a.EXCEEDED_ON_DATE		Qry_Exceeded_On_Date	, 
	a.EXCEPTION_TYPE			Qry_Exception_Type	, 
	a.HCE_AMOUNT/:AMT_UNIT2 Qry_Hce_Amount		, 
	a.LIMITING_AMOUNT/:AMT_UNIT2	 Qry_Limiting_Amount, 
	a.LIMIT_CHECK_TYPE		Qry_Limit_Check_Type	, 
	a.LIMIT_CODE			Qry_Limit_Code		, 
	a.LIMIT_PARTY			Qry_Limit_Party		, 
	a.LOG_ID				Qry_Log_Id		,	 
	a.TRANSACTION_NUMBER		Qry_Transaction_Number, 
	XTR_XTRLIEXP_XMLP_PKG.cf_descriptionformula(a.LIMIT_CHECK_TYPE, a.EXCEPTION_TYPE) cf_description
From 	xtr_limit_excess_log_v	a	,
	xtr_parties_v 		b	
Where 	a.company_code 		= 	nvl(:p_Company,a.company_code)
And    	a.limit_code 		= 	nvl(:p_Limit_Code,a.limit_code)
And    	a.exceeded_on_date 	>= 	Trunc(nvl(:p_From_date,trunc(sysdate)))
And    	b.party_code 		= 	a.company_Code
order by 	a.exceeded_on_date,
Qry_Company_Code,Qry_Exceeded_Amount,Qry_Limit_Code,Qry_Log_Id,Qry_Deal_Number,Qry_Transaction_Number,
Qry_Limit_Party,Qry_Amount_Date,Qry_Hce_Amount,Qry_Limiting_Amount,Qry_Authorised_By,Qry_Dealer_Code,Qry_Limit_Check_Type,Qry_Exception_Type
Parameter Name SQL text Validation
Company
 
LOV Oracle
Limit Code
 
LOV Oracle
From Date
 
Date
Factor
 
LOV Oracle