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_LINES

Line 558: xla_ae_lines xla_line,

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
562: WHERE zx_dtl.request_id = c_request_id

Line 784: xla_ae_lines xla_line,

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
788: WHERE zx_dtl.request_id = c_request_id

Line 1766: xla_ae_lines ael

1762: SELECT
1763: ael.code_combination_id
1764: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1765: xla_distribution_links lnk,
1766: xla_ae_lines ael
1767: WHERE gl_dist.customer_trx_id = c_trx_id
1768: AND gl_dist.account_class = 'REV'
1769: AND lnk.application_id = 222
1770: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

Line 1784: xla_ae_lines ael

1780: SELECT
1781: ael.code_combination_id
1782: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1783: xla_distribution_links lnk,
1784: xla_ae_lines ael
1785: WHERE gl_dist.customer_trx_id = c_trx_id
1786: AND gl_dist.customer_trx_line_id = c_trx_line_id
1787: AND gl_dist.account_class = 'REV'
1788: AND lnk.application_id = 222

Line 1807: xla_ae_lines ael

1803: SELECT
1804: /*+ leading(gl_dist)*/ ael.code_combination_id
1805: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1806: xla_distribution_links lnk,
1807: xla_ae_lines ael
1808: WHERE gl_dist.customer_trx_id = c_trx_id
1809: AND gl_dist.customer_trx_line_id = c_trx_line_id
1810: AND gl_dist.account_class = 'REV'
1811: AND lnk.application_id = 222

Line 1827: xla_ae_lines ael

1823: SELECT
1824: ael.code_combination_id
1825: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1826: xla_distribution_links lnk,
1827: xla_ae_lines ael
1828: WHERE gl_dist.customer_trx_id = c_trx_id
1829: AND gl_dist.account_class = 'TAX'
1830: AND lnk.application_id = 222
1831: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

Line 1845: xla_ae_lines ael

1841: SELECT
1842: ael.code_combination_id
1843: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1844: xla_distribution_links lnk,
1845: xla_ae_lines ael
1846: WHERE gl_dist.customer_trx_id = c_trx_id
1847: AND gl_dist.customer_trx_line_id = c_tax_line_id
1848: AND gl_dist.account_class = 'TAX'
1849: AND lnk.application_id = 222

Line 1871: xla_ae_lines ael

1867: SELECT
1868: ael.code_combination_id
1869: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1870: xla_distribution_links lnk,
1871: xla_ae_lines ael
1872: WHERE gl_dist.customer_trx_id = c_trx_id
1873: -- AND gl_dist.customer_trx_line_id = c_tax_line_id
1874: AND gl_dist.cust_trx_line_gl_dist_id = c_tax_line_dist_id
1875: AND gl_dist.account_class = 'TAX'

Line 2318: xla_ae_lines ael

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'
2322: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

Line 2341: xla_ae_lines ael

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
2345: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

Line 2366: xla_ae_lines ael

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'
2370: AND lnk.application_id = 222

Line 2389: xla_ae_lines ael

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'
2393: AND lnk.application_id = 222

Line 2420: xla_ae_lines ael

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
2424: AND gl_dist.account_class = 'TAX'

Line 2449: xla_ae_lines ael

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'
2453: AND lnk.application_id = 222

Line 2569: xla_ae_lines ael

2565: SELECT
2566: ael.code_combination_id
2567: FROM ar_distributions_all dist,
2568: xla_distribution_links lnk,
2569: xla_ae_lines ael
2570: WHERE dist.line_id = p_actg_source_id
2571: AND lnk.application_id = 222
2572: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
2573: AND lnk.source_distribution_id_num_1 = dist.line_id

Line 2586: xla_ae_lines ael

2582: SELECT ael.code_combination_id
2583: FROM ar_distributions_all dist,
2584: ar_distributions_all taxdist,
2585: xla_distribution_links lnk,
2586: xla_ae_lines ael
2587: WHERE taxdist.line_id = p_actg_source_id
2588: AND NVL(dist.source_table,'X') = NVL(taxdist.source_table_secondary,'X')
2589: AND dist.tax_link_id = taxdist.tax_link_id
2590: AND dist.source_id = taxdist.source_id

Line 2606: xla_ae_lines ael

2602: SELECT ael.code_combination_id
2603: FROM ar_distributions_all dist,
2604: ar_distributions_all taxdist,
2605: xla_distribution_links lnk,
2606: xla_ae_lines ael
2607: WHERE dist.line_id = p_actg_source_id
2608: AND NVL(dist.source_table,'X') = NVL(taxdist.source_table_secondary,'X')
2609: AND dist.tax_link_id = taxdist.tax_link_id
2610: AND dist.source_id = taxdist.source_id

Line 2626: xla_ae_lines ael

2622: SELECT
2623: ael.code_combination_id
2624: FROM ar_distributions_all taxdist,
2625: xla_distribution_links lnk,
2626: xla_ae_lines ael
2627: WHERE taxdist.line_id = p_actg_source_id
2628: AND lnk.application_id = 222
2629: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
2630: AND lnk.source_distribution_id_num_1 = taxdist.line_id

Line 3126: xla_ae_lines ael

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'
3130: AND lnk.source_distribution_id_num_1 = dist.line_id

Line 3148: xla_ae_lines ael

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')
3152: AND taxdist.source_id = dist.source_id

Line 3174: xla_ae_lines ael

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')
3178: AND taxdist.source_id = dist.source_id

Line 3197: xla_ae_lines ael

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'
3201: AND lnk.source_distribution_id_num_1 = taxdist.line_id