OKL Billable Streams Reconciliation

➜ Back to Library
Description
Categories: BI Publisher
Application: Lease and Finance Management
Source: Billable Streams Reconciliation Report
Short Name: OKLSTMREN
DB package: OKL_STREAMS_RECON_PVT
			SELECT VALUE1_TEXT DIFF_DTLS_QUERY_TYPE,
				VALUE2_TEXT DIFF_DTLS_CURRENCY_CODE,         
				VALUE3_TEXT DIFF_DTLS_CONTRACT_NUMBER,       
				VALUE4_TEXT DIFF_DTLS_TOTAL_BILL_STRMS,
				VALUE5_TEXT DIFF_DTLS_BILLED_STREAMS,        
				VALUE6_TEXT DIFF_DTLS_CANCELLED_STREAMS,     
				VALUE7_TEXT DIFF_DTLS_UNBILLED_STREAMS,      
				VALUE8_TEXT DIFF_DTLS_DIFF_AMOUNT,
				VALUE1_NUM DIFF_DTLS_TOT_BILL_STRMS_NUM,
				VALUE2_NUM DIFF_DTLS_BILLED_STREAMS_NUM,        
				VALUE3_NUM DIFF_DTLS_CAN_STREAMS_NUM,     
				VALUE4_NUM DIFF_DTLS_UNBILLED_STRMS_NUM,      
				VALUE5_NUM DIFF_DTLS_DIFF_AMOUNT_NUM            
			FROM OKL_G_REPORTS_GT
			WHERE VALUE1_TEXT = 'DIFF_DTLS'
Parameter NameSQL textValidation
Contract Number
 
LOV Oracle
End Date
 
Date
Download
Related Blitz Reports
OKL Generate Reconciliation OKL Lease Subsidy Pool Association OKL Lease Subsidy Pool At-Limit OKL Lease Subsidy Pool Reconciliation AP Open Items Revaluation(GST) AP Open Balances Revaluation (GST) AP Open Balances Revaluation COPY OF: AP Open Balances Revaluation AP Open Items Revaluation
Blitz Report™