ECC Lease Contracts, Lease Unapplied Cash Invoices
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:
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 |
|
LOV |
Blitz Report™