ECC Lease Contracts, Lease Invoice Applications, SQL1

Description
Columns: Payment Schedule Id, Ecc Spec Id, Cash Receipt Id, Receipt Number, Customer Trx Id, Invoice Number, Line Type, Line Applied, Tax Applied, Line Balance ...
Imported from ECC
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"))