OKL Passthrough Transaction Activity
Description
Categories: BI Publisher
Application: Lease and Finance Management
Source: Passthrough Transaction Activity Report
Short Name: OKLPASSTHRPT
DB package: OKL_PASSTHROUGH_RECON_RPT_PVT
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 |