ECC Lease Contracts, Lease Invoice Information

Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: okl-couter-ar
Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
Run ECC Lease Contracts, Lease Invoice Information and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
SELECT  *
FROM    (
        SELECT  DISTINCT
                oec.ecc_spec_id
               ,oec.invoice_num
               ,oec.customer_name
               ,oec.site_use_id
               ,oec.currency_code
               ,oec.due_date
               ,oec.amount
               ,oec.balance
               ,oec.ar_invoice_id
               ,oec.usage_period
               ,oec.invoice_date
               ,oec.bill_to_site_use_id
               ,oec.customer_acct_id
               ,oec.org_id
               ,oec.customer_number
               ,oec.contract_number
               ,oec.asset_number
               ,payout_basis.description payout_basis
               ,payment_basis.description payment_basis
               ,payout_basis.language
               ,oec.contract_id
               ,oec.invoice_line_number
               ,oec.line_type
               ,oec.line_amount
               ,oec.tax_amount
               ,oec.revenue_amount
               ,oec.amount_due_remaining
               ,oec.receivable_application_id
               ,oec.cash_receipt_id
               ,oec.customer_trx_id
               ,oec.customer_trx_line_id
               ,oec.invoice_number
               ,oec.stream_type
               ,oec.due_date_receipt
               ,oec.balance_amount
               ,oec.applied_amount
               ,oec.line_applied
               ,oec.tax_applied
               ,oec.line_balance
               ,oec.tax_balance
               ,oec.original_applied_amount
               ,oec.total_line_amount
               ,oec.gl_date
               ,oec.invoice_currency_code
               ,oec.receipt_number
               ,oec.tax_current_amount_due
               ,oec.original_line_applied
               ,oec.original_tax_applied
               ,oec.original_gl_date
               ,oec.vendor
               ,oec.vendor_site
               ,oec.ar_link
               ,oec.ap_inv_num
               ,oec.invoice_amount
               ,oec.line_number
               ,oec.ap_line_amount
               ,oec.ap_tax_amount
               ,oec.payment_date
               ,oec.payment_number
               ,oec.ap_inv_date
               ,oec.paid_amount
               ,oec.receipt_date
        FROM    okl_ecc_charges_data oec
               ,fnd_lookup_values payout_basis
               ,fnd_lookup_values payment_basis
        WHERE   payout_basis.lookup_code = nvl(oec.payout_basis,payout_basis.lookup_code)
        AND     nvl(payout_basis.lookup_type,'OKL_PAYOUT_BASIS') = 'OKL_PAYOUT_BASIS'
        AND     payment_basis.lookup_code = nvl(oec.payment_basis,payment_basis.lookup_code)
        AND     payment_basis.lookup_type(+) = 'OKL_PAYMENT_BASIS'
        AND     payment_basis.language = payout_basis.language
        AND     payment_basis.language in ('US')
AND     oec.spec_flag ='N')
 PIVOT
			        (MAX(payout_basis) AS payout_basis,
							 MAX(payment_basis) AS payment_basis
			         for language in('US' "US"))
) x
where
2=2
Parameter Name SQL text Validation
Operating Unit
x.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
LOV