OKL Passthrough Transaction Activity

Description
Categories: BI Publisher
Columns: Org Id, Khr Id, Contract Number, Contract Start Date, Contract End Date, Currency, Customer, Lty Code, Service Schedule, Kle Id ...
Application: Lease and Finance Management
Source: Passthrough Transaction Activity Report
Short Name: OKLPASSTHRPT
DB package: OKL_PASSTHROUGH_RECON_RPT_PVT
		SELECT  org_id
				   ,khr_id
				   ,contract_number
				   ,contract_start_date
				   ,contract_end_date
				   ,currency
				   ,customer
				  -- ,lty_code
				  ,(select distinct oklsv.name from okc_line_styles_v  oklsv, fnd_application fnd
					where oklsv.lty_code = ops.lty_code 
					  AND oklsv.application_id = fnd.application_id
					  AND fnd.application_short_name = 'OKL') lty_code
				   ,service_schedule
				   ,kle_id
				   ,line_start_date
				   ,line_end_date
				   ,line_name
				   ,line_amount
				   ,line_status_meaning
				   ,line_status_code
				   ,line_type
				   ,line_type_meaning
				   ,sel_id
				   ,customer_trx_id
				   ,ar_inv_num
				   ,ar_inv_date
				   ,ar_inv_line_num
				   ,ar_inv_line_amt
				   ,receipt_no
				   ,receipt_amount
				   ,passthru_term
				   ,payout_basis
				   ,vendor_id
				   ,vendor
				   ,vendor_site_id
				   ,vendor_site_code
				   ,ap_invoice_id
				   ,ap_inv_num
				   ,ap_inv_date
				   ,ap_inv_line_num
				   ,ap_inv_line_amt
				   ,ap_inv_line_amt_paid
				   ,ap_check_number
				   ,ap_check_date
			FROM    okl_passthrough_dtls_uv ops
			&WHERE_CLAUSE
Parameter Name SQL text Validation
Contract Number
 
LOV Oracle
Contract start Date
 
Date
Contract End Date
 
Date
Line Type
 
LOV Oracle
P_VENDOR
 
LOV Oracle
Vendor Site Code
 
LOV Oracle