DBA Data[Home] [Help]

APPS.ZX_AP_POPULATE_PKG dependencies on XLA_AE_HEADERS

Line 485: xla_ae_headers xla_head,

481: -- zx_dtl.tax_type_code
482: FROM zx_rep_trx_detail_t zx_dtl,
483: xla_transaction_entities xla_ent,
484: xla_events xla_event,
485: xla_ae_headers xla_head,
486: xla_ae_lines xla_line,
487: xla_acct_class_assgns acs,
488: xla_assignment_defns_b asd,
489: xla_distribution_links xla_dist

Line 2167: xla_ae_headers aeh,

2163: c_ledger_id NUMBER) IS
2164: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
2165: FROM zx_rec_nrec_dist zx_dist,
2166: xla_distribution_links lnk,
2167: xla_ae_headers aeh,
2168: xla_ae_lines ael
2169: WHERE zx_dist.trx_id = c_trx_id
2170: AND zx_dist.APPLICATION_ID = c_application_id
2171: AND zx_dist.entity_code = c_entity_code

Line 2199: xla_ae_headers aeh,

2195: c_ledger_id NUMBER) IS
2196: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
2197: FROM zx_rec_nrec_dist zx_dist,
2198: xla_distribution_links lnk,
2199: xla_ae_headers aeh,
2200: xla_ae_lines ael
2201: WHERE zx_dist.trx_id = c_trx_id
2202: AND zx_dist.APPLICATION_ID = c_application_id
2203: AND zx_dist.entity_code = c_entity_code

Line 2233: xla_ae_headers aeh,

2229: c_ledger_id NUMBER) IS
2230: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
2231: FROM zx_rec_nrec_dist zx_dist,
2232: xla_distribution_links lnk,
2233: xla_ae_headers aeh,
2234: xla_ae_lines ael
2235: WHERE zx_dist.trx_id = c_trx_id
2236: AND zx_dist.APPLICATION_ID = c_application_id
2237: AND zx_dist.entity_code = c_entity_code

Line 2266: xla_ae_headers aeh,

2262: c_ledger_id NUMBER) IS
2263: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
2264: FROM zx_rec_nrec_dist zx_dist,
2265: xla_distribution_links lnk,
2266: xla_ae_headers aeh,
2267: xla_ae_lines ael
2268: WHERE zx_dist.trx_id = c_trx_id
2269: AND zx_dist.APPLICATION_ID = c_application_id
2270: AND zx_dist.entity_code = c_entity_code

Line 2378: xla_ae_headers aeh,

2374: -- SUM( abs(nvl(lnk.UNROUNDED_ACCOUNTED_DR,0) - (nvl(lnk.UNROUNDED_ACCOUNTED_CR,0))) *
2375: -- (decode(sign(zx_dist.TRX_LINE_DIST_AMT),0,1,sign(zx_dist.TRX_LINE_DIST_AMT))))
2376: FROM zx_rec_nrec_dist zx_dist,
2377: xla_distribution_links lnk,
2378: xla_ae_headers aeh,
2379: xla_ae_lines ael
2380: WHERE zx_dist.trx_id = c_trx_id
2381: AND zx_dist.APPLICATION_ID = c_application_id
2382: AND zx_dist.entity_code = c_entity_code

Line 2455: xla_ae_headers aeh,

2451: SELECT SUM(nvl(lnk.UNROUNDED_ENTERED_DR,0) - nvl(lnk.UNROUNDED_ENTERED_CR,0)),
2452: SUM(nvl(lnk.UNROUNDED_ACCOUNTED_DR,0) - nvl(lnk.UNROUNDED_ACCOUNTED_CR,0))
2453: FROM ap_invoice_distributions_all ap_dist,
2454: xla_distribution_links lnk,
2455: xla_ae_headers aeh,
2456: xla_ae_lines ael
2457: WHERE ap_dist.invoice_id = c_trx_id
2458: AND ap_dist.invoice_line_number = c_trx_line_id
2459: AND ap_dist.invoice_distribution_id = c_trx_line_dist_id