APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on XLA_DISTRIBUTION_LINKS

Line 209: xla_distribution_links lnk,

205: SUM(nvl(lnk.UNROUNDED_ACCOUNTED_DR,0)- nvl(lnk.UNROUNDED_ACCOUNTED_CR,0)
206: ) taxable_act_amt
207: FROM zx_rep_trx_detail_t dtl,
208: ap_prepay_app_dists pre_dist,
209: xla_distribution_links lnk,
210: xla_ae_headers aeh,
211: xla_ae_lines ael
212: WHERE dtl.detail_tax_line_id = temp.detail_tax_line_id
213: AND pre_dist.prepay_app_distribution_id = dtl.taxable_item_source_id

Line 455: xla_distribution_links lnk

451: ap_invoice_distributions_all ap_dist,
452: po_distributions_all pod,
453: xla_ae_headers aeh,
454: xla_ae_lines ael,
455: xla_distribution_links lnk
456: WHERE dtl.ref_doc_application_id = 201
457: and dtl.request_id = p_request_id
458: and act_ext.detail_tax_line_id = dtl.detail_tax_line_id
459: and dtl.detail_tax_line_id = ext.detail_tax_line_id

Line 565: xla_distribution_links lnk,

561: decode(sign(nvl(dtl1.taxable_amt_funcl_curr,0)),0,1,sign(nvl(dtl1.taxable_amt_funcl_curr,0)))
562: FROM zx_rep_trx_detail_t dtl2,
563: zx_rep_actg_ext_t act_ext,
564: AP_INVOICE_DISTRIBUTIONS_ALL AP_DIST,
565: xla_distribution_links lnk,
566: xla_ae_headers aeh,
567: xla_ae_lines ael
568: WHERE ap_dist.invoice_id=dtl2.trx_id
569: and ap_dist.invoice_line_number=dtl2.trx_line_id

Line 596: xla_distribution_links lnk,

592: decode(sign(nvl(dtl1.taxable_amt,0)),0,1,sign(nvl(dtl1.taxable_amt,0)))
593: FROM zx_rep_trx_detail_t dtl2,
594: zx_rep_actg_ext_t act_ext,
595: AP_INVOICE_DISTRIBUTIONS_ALL AP_DIST,
596: xla_distribution_links lnk,
597: xla_ae_headers aeh,
598: xla_ae_lines ael
599: WHERE ap_dist.invoice_id=dtl2.trx_id
600: and ap_dist.invoice_line_number=dtl2.trx_line_id