DBA Data[Home] [Help]

APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on XLA_AE_LINES

Line 211: xla_ae_lines ael

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
214: AND pre_dist.prepay_dist_lookup_code = 'PREPAY APPL'
215: AND lnk.application_id = 200

Line 454: xla_ae_lines ael,

450: zx_rep_actg_ext_t act_ext,
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

Line 567: xla_ae_lines ael

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
570: and ap_dist.related_id=dtl2.taxable_item_source_id
571: and ap_dist.invoice_distribution_id <> ap_dist.related_id

Line 598: xla_ae_lines ael

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
601: and ap_dist.related_id=dtl2.taxable_item_source_id
602: and ap_dist.invoice_distribution_id <> ap_dist.related_id