ECC Lease Contracts, Lease Unapplied Cash Invoices

➜ Back to Library
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: okl-unapp-cash_inv
Query Procedure: OKL_AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure:
Run ECC Lease Contracts, Lease Unapplied Cash Invoices and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
SELECT * from (SELECT rcpt_v.*
  FROM OKL_ECC_OPEN_ITEMS_INV_V rcpt_v , okl_ecc_trx_process_t process_t
 WHERE rcpt_v.payment_schedule_id = process_t.payment_schedule_id
   AND process_t.incremental_flag = 'N'
   AND language in ('US')  )
   PIVOT(
          max(STREAM_PURPOSE_MEANING) as STREAM_PURPOSE_MEANING,
          max(ASSET_NUMBER) as ASSET_NUMBER
          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
Download
Related Blitz Reports
ECC Lease Contracts, Lease Unapplied Cash ECC Lease Contracts, Lease Vendor Cash Flow ECC Lease Contracts, Lease Outstanding Receivables ECC Receivables, Billing Process, SQL1 ECC Receivables, Payment History, SQL1 ECC Lease Contracts, Lease Invoice Applications ECC Receivables, Billing Process, SQL2 ECC Receivables, Outstanding Receivables (9) ECC Receivables, Outstanding Receivables (7)
Blitz Report™

Blitz Report™ provides multiple benefits:

Blitz Report™