DBA Data[Home] [Help]

APPS.OKL_PROP_TAX_ADJ_PVT dependencies on OKL_TRX_AR_INVOICES_V

Line 121: okl_trx_ar_invoices_v tai,

117: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
118: UNION
119: SELECT NVL(SUM(til.amount),0) amount
120: FROM okc_k_headers_b khr,
121: okl_trx_ar_invoices_v tai,
122: okl_txl_ar_inv_lns_v til,
123: okl_strm_type_v sty
124: WHERE khr.id = p_khr_id
125: AND tai.khr_id = khr.id