DBA Data[Home] [Help]

APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on AP_MC_INVOICE_DISTS

Line 268: AP_MC_INVOICE_DISTS mc

264: UPDATE zx_rep_trx_detail_t dtl
265: SET (dtl.TAXABLE_AMT,dtl.TAXABLE_AMT_FUNCL_CURR)
266: = (SELECT sum(mc.amount), sum(nvl(mc.base_amount,mc.amount))
267: FROM AP_INVOICE_DISTRIBUTIONS_ALL dist,
268: AP_MC_INVOICE_DISTS mc
269: WHERE dtl.taxable_item_source_id = dist.invoice_distribution_id
270: AND dist.invoice_distribution_id = mc.invoice_distribution_id
271: AND mc.set_of_books_id = p_trl_global_variables_rec.reporting_ledger_id)
272: WHERE dtl.request_id = p_request_id