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_ACTG_POPULATE_PKG dependencies on XLA_AE_HEADERS

Line 1378: xla_ae_headers aeh,

1374: CURSOR taxable_amount_hdr (c_trx_id NUMBER, c_ae_header_id NUMBER, c_event_id NUMBER, c_ledger_id NUMBER) IS
1375: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1376: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1377: xla_distribution_links lnk,
1378: xla_ae_headers aeh,
1379: xla_ae_lines ael
1380: WHERE gl_dist.customer_trx_id = c_trx_id
1381: AND lnk.application_id = 222
1382: AND gl_dist.account_class = 'REV'

Line 1397: xla_ae_headers aeh,

1393: CURSOR tax_amount_hdr (c_trx_id NUMBER, c_ae_header_id NUMBER, c_event_id NUMBER,c_ledger_id NUMBER) IS
1394: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1395: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1396: xla_distribution_links lnk,
1397: xla_ae_headers aeh,
1398: xla_ae_lines ael
1399: WHERE gl_dist.customer_trx_id = c_trx_id
1400: AND gl_dist.account_class = 'TAX'
1401: AND lnk.application_id = 222

Line 1419: xla_ae_headers aeh,

1415: c_event_id NUMBER, c_ledger_id NUMBER) IS
1416: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1417: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1418: xla_distribution_links lnk,
1419: xla_ae_headers aeh,
1420: xla_ae_lines ael
1421: WHERE gl_dist.customer_trx_id = c_trx_id
1422: AND gl_dist.customer_trx_line_id = c_trx_line_id
1423: AND gl_dist.account_class = 'REV'

Line 1439: xla_ae_headers aeh,

1435: 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
1436: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1437: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1438: xla_distribution_links lnk,
1439: xla_ae_headers aeh,
1440: xla_ae_lines ael
1441: WHERE gl_dist.customer_trx_id = c_trx_id
1442: AND gl_dist.customer_trx_line_id = c_tax_line_id
1443: AND gl_dist.account_class = 'TAX'

Line 1463: xla_ae_headers aeh,

1459: c_event_id NUMBER, c_ledger_id NUMBER) IS
1460: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1461: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1462: xla_distribution_links lnk,
1463: xla_ae_headers aeh,
1464: xla_ae_lines ael
1465: WHERE gl_dist.customer_trx_id = c_trx_id
1466: AND gl_dist.customer_trx_line_id = c_tax_line_id
1467: AND gl_dist.cust_trx_line_gl_dist_id = c_tax_dist_id

Line 1486: xla_ae_headers aeh,

1482: c_event_id NUMBER, c_ledger_id NUMBER) IS
1483: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1484: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1485: xla_distribution_links lnk,
1486: xla_ae_headers aeh,
1487: xla_ae_lines ael
1488: WHERE gl_dist.customer_trx_id = c_trx_id
1489: AND gl_dist.customer_trx_line_id = c_trx_line_id
1490: AND gl_dist.account_class = 'LINE'

Line 1904: xla_ae_headers aeh,

1900: c_event_id NUMBER,c_ledger_id NUMBER) IS
1901: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1902: FROM ar_distributions_all dist,
1903: xla_distribution_links lnk,
1904: xla_ae_headers aeh,
1905: xla_ae_lines ael
1906: WHERE dist.line_id = c_actg_source_id
1907: AND lnk.application_id = 222
1908: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

Line 1922: xla_ae_headers aeh,

1918: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1919: FROM AR_DISTRIBUTIONS_ALL dist,
1920: AR_DISTRIBUTIONS_ALL taxdist,
1921: xla_distribution_links lnk,
1922: xla_ae_headers aeh,
1923: xla_ae_lines ael
1924: WHERE dist.line_id = c_actg_source_id
1925: AND taxdist.tax_link_id = dist.tax_link_id
1926: AND NVL(taxdist.source_type_secondary,'X') = NVL(dist.source_type,'X')

Line 1945: xla_ae_headers aeh,

1941: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1942: FROM AR_DISTRIBUTIONS_ALL dist,
1943: AR_DISTRIBUTIONS_ALL taxdist,
1944: xla_distribution_links lnk,
1945: xla_ae_headers aeh,
1946: xla_ae_lines ael
1947: WHERE taxdist.line_id = c_actg_source_id
1948: AND taxdist.tax_link_id = dist.tax_link_id
1949: AND NVL(taxdist.source_type_secondary,'X') = NVL(dist.source_type,'X')

Line 1965: xla_ae_headers aeh,

1961: c_event_id NUMBER,c_ledger_id NUMBER) IS
1962: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1963: FROM ar_distributions_all taxdist,
1964: xla_distribution_links lnk,
1965: xla_ae_headers aeh,
1966: xla_ae_lines ael
1967: WHERE taxdist.line_id = c_actg_source_id
1968: AND lnk.application_id = 222
1969: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'