ECC Lease Contracts, Lease Unapplied Cash Invoices

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Contract Number, Contract Line Id, Amount Due Original, Amount Paid, Balance, Tax Amount, Invoice Number, Stream Type, Currency Code ...
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:
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 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