XTR Admin - Limit Exceptions Log

Description
Categories: BI Publisher
Columns: Qry Amount Date, Qry Authorised By, Qry Company Code, Qry Dealer Code, Qry Deal Number, Qry Exceeded Amount, Qry Exceeded On Date, Qry Exception Type, Qry Hce Amount, Qry Limiting Amount ...
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