ECC Lease Contracts, Lease Invoice Applications
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: okl-ar-trx-appl
Query Procedure: OKL_AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure:
Dataset Key: okl-ar-trx-appl
Query Procedure: OKL_AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure:
Run
ECC Lease Contracts, Lease Invoice Applications and other Oracle EBS reports with Blitz Report™ on our demo environment
select x.* from ( SELECT * from (SELECT /*+cardinality(trx_t 100) */ trx_appl.*,trx_t.org_id org_id FROM okl_ar_inv_appl_v trx_appl, okl_ecc_trx_process_t trx_t WHERE trx_appl.payment_schedule_id = trx_t.payment_schedule_id AND trx_t.incremental_flag = 'N' AND language in ('US') ) PIVOT (max(CURRENCY) as CURRENCY for LANGUAGE in ('US' "US")) ) x where 2=2 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Operating Unit |
|
LOV |
Blitz Report™