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_DISTRIBUTION_LINKS

Line 978: xla_distribution_links lnk,

974: CURSOR trx_ccid (c_trx_id number, c_event_id number, c_ae_header_id number) IS
975: SELECT
976: ael.code_combination_id
977: FROM ra_cust_trx_line_gl_dist_all gl_dist,
978: xla_distribution_links lnk,
979: xla_ae_lines ael
980: WHERE gl_dist.customer_trx_id = c_trx_id
981: AND gl_dist.account_class = 'LINE'
982: AND lnk.application_id = 222

Line 995: xla_distribution_links lnk,

991: CURSOR trx_line_ccid (c_trx_id number, c_trx_line_id number, c_event_id number, c_ae_header_id NUMBER) IS
992: SELECT
993: ael.code_combination_id
994: FROM ra_cust_trx_line_gl_dist_all gl_dist,
995: xla_distribution_links lnk,
996: xla_ae_lines ael
997: WHERE gl_dist.customer_trx_id = c_trx_id
998: AND gl_dist.customer_trx_line_id = c_trx_line_id
999: AND gl_dist.account_class = 'LINE'

Line 1017: xla_distribution_links lnk,

1013: CURSOR trx_dist_ccid (c_trx_id NUMBER, c_trx_line_id NUMBER, c_event_id NUMBER, c_ae_header_id NUMBER) IS
1014: SELECT
1015: ael.code_combination_id
1016: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1017: xla_distribution_links lnk,
1018: xla_ae_lines ael
1019: WHERE gl_dist.customer_trx_id = c_trx_id
1020: AND gl_dist.customer_trx_line_id = c_trx_line_id
1021: AND gl_dist.account_class = 'LINE'

Line 1036: xla_distribution_links lnk,

1032: CURSOR tax_ccid (c_trx_id number, c_event_id number, c_ae_header_id number) IS
1033: SELECT
1034: ael.code_combination_id
1035: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1036: xla_distribution_links lnk,
1037: xla_ae_lines ael
1038: WHERE gl_dist.customer_trx_id = c_trx_id
1039: AND gl_dist.account_class = 'TAX'
1040: AND lnk.application_id = 222

Line 1053: xla_distribution_links lnk,

1049: CURSOR tax_line_ccid (c_trx_id number, c_tax_line_id NUMBER, c_event_id number, c_ae_header_id number) IS
1050: SELECT
1051: ael.code_combination_id
1052: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1053: xla_distribution_links lnk,
1054: xla_ae_lines ael
1055: WHERE gl_dist.customer_trx_id = c_trx_id
1056: AND gl_dist.customer_trx_line_id = c_tax_line_id
1057: AND gl_dist.account_class = 'TAX'

Line 1076: xla_distribution_links lnk,

1072: c_event_id number, c_ae_header_id number) IS
1073: SELECT
1074: ael.code_combination_id
1075: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1076: xla_distribution_links lnk,
1077: xla_ae_lines ael
1078: WHERE gl_dist.customer_trx_id = c_trx_id
1079: AND gl_dist.customer_trx_line_id = c_tax_line_id
1080: AND gl_dist.cust_trx_line_gl_dist_id = c_tax_line_dist_id

Line 1377: xla_distribution_links lnk,

1373:
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

Line 1396: xla_distribution_links lnk,

1392:
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'

Line 1418: xla_distribution_links lnk,

1414: CURSOR taxable_amount_line (c_trx_id NUMBER,c_trx_line_id NUMBER, c_ae_header_id NUMBER,
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

Line 1438: xla_distribution_links lnk,

1434:
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

Line 1462: xla_distribution_links lnk,

1458: CURSOR tax_amount_dist ( c_trx_id NUMBER,c_tax_line_id NUMBER, c_tax_dist_id NUMBER, c_ae_header_id NUMBER,
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

Line 1485: xla_distribution_links lnk,

1481: CURSOR taxable_amount_dist (c_trx_id NUMBER,c_trx_line_id NUMBER, c_ae_header_id NUMBER,
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

Line 1558: xla_distribution_links lnk,

1554: CURSOR trx_ccid (c_actg_source_id number, c_event_id number, c_ae_header_id number) IS
1555: SELECT
1556: ael.code_combination_id
1557: FROM ar_distributions_all dist,
1558: xla_distribution_links lnk,
1559: xla_ae_lines ael
1560: WHERE dist.line_id = p_actg_source_id
1561: AND lnk.application_id = 222
1562: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

Line 1574: xla_distribution_links lnk,

1570: CURSOR trx_dist_ccid (c_actg_source_id number, c_event_id number, c_ae_header_id number) IS
1571: SELECT ael.code_combination_id
1572: FROM ar_distributions_all dist,
1573: ar_distributions_all taxdist,
1574: xla_distribution_links lnk,
1575: xla_ae_lines ael
1576: WHERE taxdist.line_id = p_actg_source_id
1577: AND NVL(dist.source_table,'X') = NVL(taxdist.source_table_secondary,'X')
1578: AND dist.tax_link_id = taxdist.tax_link_id

Line 1593: xla_distribution_links lnk,

1589: CURSOR tax_ccid (c_actg_source_id number, c_event_id number, c_ae_header_id number) IS
1590: SELECT ael.code_combination_id
1591: FROM ar_distributions_all dist,
1592: ar_distributions_all taxdist,
1593: xla_distribution_links lnk,
1594: xla_ae_lines ael
1595: WHERE dist.line_id = p_actg_source_id
1596: AND NVL(dist.source_table,'X') = NVL(taxdist.source_table_secondary,'X')
1597: AND dist.tax_link_id = taxdist.tax_link_id

Line 1612: xla_distribution_links lnk,

1608: CURSOR tax_dist_ccid (c_actg_source_id number, c_event_id number, c_ae_header_id number) IS
1609: SELECT
1610: ael.code_combination_id
1611: FROM ar_distributions_all taxdist,
1612: xla_distribution_links lnk,
1613: xla_ae_lines ael
1614: WHERE taxdist.line_id = p_actg_source_id
1615: AND lnk.application_id = 222
1616: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

Line 1903: xla_distribution_links lnk,

1899: CURSOR taxable_amount_hdr (c_actg_source_id NUMBER, c_ae_header_id NUMBER,
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

Line 1921: xla_distribution_links lnk,

1917: c_event_id NUMBER,c_ledger_id NUMBER) IS
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

Line 1944: xla_distribution_links lnk,

1940: CURSOR taxable_amount_dist (c_actg_source_id NUMBER, c_ae_header_id NUMBER, c_event_id NUMBER,c_ledger_id NUMBER) IS
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

Line 1964: xla_distribution_links lnk,

1960: CURSOR tax_amount_dist (c_actg_source_id NUMBER, c_ae_header_id NUMBER,
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