eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_AR_POPULATE_PKG dependencies on XLA_AE_HEADERS

Line 557: xla_ae_headers xla_head,

553: ZX_DTL.tax_determine_date--Bug 5622686
554: FROM zx_rep_trx_detail_t zx_dtl,
555: xla_transaction_entities xla_ent,
556: xla_events xla_event,
557: xla_ae_headers xla_head,
558: xla_ae_lines xla_line,
559: xla_acct_class_assgns acs,
560: xla_assignment_defns_b asd,
561: xla_distribution_links xla_dist

Line 783: xla_ae_headers xla_head,

779: ZX_DTL.tax_determine_date
780: FROM zx_rep_trx_detail_t zx_dtl,
781: xla_transaction_entities xla_ent,
782: xla_events xla_event,
783: xla_ae_headers xla_head,
784: xla_ae_lines xla_line,
785: xla_acct_class_assgns acs,
786: xla_assignment_defns_b asd,
787: xla_distribution_links xla_dist

Line 2317: xla_ae_headers aeh,

2313: SELECT sum(nvl(lnk.UNROUNDED_ENTERED_DR,0)) - sum(nvl(lnk.UNROUNDED_ENTERED_CR,0)),
2314: sum(nvl(lnk.UNROUNDED_ACCOUNTED_DR,0)) - SUM(nvl(lnk.UNROUNDED_ACCOUNTED_CR,0))
2315: FROM ra_cust_trx_line_gl_dist_all gl_dist,
2316: xla_distribution_links lnk,
2317: xla_ae_headers aeh,
2318: xla_ae_lines ael
2319: WHERE gl_dist.customer_trx_id = c_trx_id
2320: AND lnk.application_id = 222
2321: AND gl_dist.account_class = 'REV'

Line 2340: xla_ae_headers aeh,

2336: SELECT sum(nvl(lnk.UNROUNDED_ENTERED_DR,0)) - sum(nvl(lnk.UNROUNDED_ENTERED_CR,0)),
2337: sum(nvl(lnk.UNROUNDED_ACCOUNTED_DR,0)) - SUM(nvl(lnk.UNROUNDED_ACCOUNTED_CR,0))
2338: FROM ra_cust_trx_line_gl_dist_all gl_dist,
2339: xla_distribution_links lnk,
2340: xla_ae_headers aeh,
2341: xla_ae_lines ael
2342: WHERE gl_dist.customer_trx_id = c_trx_id
2343: AND gl_dist.account_class = 'TAX'
2344: AND lnk.application_id = 222

Line 2365: xla_ae_headers aeh,

2361: c_event_id NUMBER, c_ledger_id NUMBER) IS
2362: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
2363: FROM ra_cust_trx_line_gl_dist_all gl_dist,
2364: xla_distribution_links lnk,
2365: xla_ae_headers aeh,
2366: xla_ae_lines ael
2367: WHERE gl_dist.customer_trx_id = c_trx_id
2368: AND gl_dist.customer_trx_line_id = c_trx_line_id
2369: AND gl_dist.account_class = 'REV'

Line 2388: xla_ae_headers aeh,

2384: CURSOR tax_amount_line (c_trx_id NUMBER,c_tax_line_id NUMBER, c_ae_header_id NUMBER, c_event_id NUMBER, c_ledger_id NUMBER) IS
2385: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
2386: FROM ra_cust_trx_line_gl_dist_all gl_dist,
2387: xla_distribution_links lnk,
2388: xla_ae_headers aeh,
2389: xla_ae_lines ael
2390: WHERE gl_dist.customer_trx_id = c_trx_id
2391: AND gl_dist.customer_trx_line_id = c_tax_line_id
2392: AND gl_dist.account_class = 'TAX'

Line 2419: xla_ae_headers aeh,

2415: sum(nvl(lnk.UNROUNDED_ACCOUNTED_CR,0)) - SUM(nvl(lnk.UNROUNDED_ACCOUNTED_DR,0))
2416: --sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
2417: FROM ra_cust_trx_line_gl_dist_all gl_dist,
2418: xla_distribution_links lnk,
2419: xla_ae_headers aeh,
2420: xla_ae_lines ael
2421: WHERE gl_dist.customer_trx_id = c_trx_id
2422: -- AND gl_dist.customer_trx_line_id = c_tax_line_id
2423: AND gl_dist.cust_trx_line_gl_dist_id = c_tax_dist_id

Line 2448: xla_ae_headers aeh,

2444: sum(nvl(lnk.UNROUNDED_ACCOUNTED_CR,0)) - SUM(nvl(lnk.UNROUNDED_ACCOUNTED_DR,0))
2445: --SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
2446: FROM ra_cust_trx_line_gl_dist_all gl_dist,
2447: xla_distribution_links lnk,
2448: xla_ae_headers aeh,
2449: xla_ae_lines ael
2450: WHERE gl_dist.customer_trx_id = c_trx_id
2451: AND gl_dist.customer_trx_line_id = c_trx_line_id
2452: -- AND gl_dist.account_class = 'REV'

Line 3125: xla_ae_headers aeh,

3121: c_event_id NUMBER,c_ledger_id NUMBER) IS
3122: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
3123: FROM ar_distributions_all dist,
3124: xla_distribution_links lnk,
3125: xla_ae_headers aeh,
3126: xla_ae_lines ael
3127: WHERE dist.line_id = c_actg_source_id
3128: AND lnk.application_id = 222
3129: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

Line 3147: xla_ae_headers aeh,

3143: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
3144: FROM AR_DISTRIBUTIONS_ALL dist,
3145: AR_DISTRIBUTIONS_ALL taxdist,
3146: xla_distribution_links lnk,
3147: xla_ae_headers aeh,
3148: xla_ae_lines ael
3149: WHERE dist.line_id = c_actg_source_id
3150: AND taxdist.tax_link_id = dist.tax_link_id
3151: AND NVL(taxdist.source_type_secondary,'X') = NVL(dist.source_type,'X')

Line 3173: xla_ae_headers aeh,

3169: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
3170: FROM AR_DISTRIBUTIONS_ALL dist,
3171: AR_DISTRIBUTIONS_ALL taxdist,
3172: xla_distribution_links lnk,
3173: xla_ae_headers aeh,
3174: xla_ae_lines ael
3175: WHERE taxdist.line_id = c_actg_source_id
3176: AND taxdist.tax_link_id = dist.tax_link_id
3177: AND NVL(taxdist.source_type_secondary,'X') = NVL(dist.source_type,'X')

Line 3196: xla_ae_headers aeh,

3192: c_event_id NUMBER,c_ledger_id NUMBER) IS
3193: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
3194: FROM ar_distributions_all taxdist,
3195: xla_distribution_links lnk,
3196: xla_ae_headers aeh,
3197: xla_ae_lines ael
3198: WHERE taxdist.line_id = c_actg_source_id
3199: AND lnk.application_id = 222
3200: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'