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 |
