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 RA_CUST_TRX_LINE_GL_DIST_ALL

Line 1061: RA_CUST_TRX_LINE_GL_DIST_ALL DIST

1057: IF l_mau is NOT NULL THEN
1058: UPDATE zx_rep_trx_detail_t DET
1059: SET taxable_amt_funcl_curr = ROUND(((SELECT (zl.line_amt * DIST.PERCENT)/100
1060: FROM zx_lines zl,
1061: RA_CUST_TRX_LINE_GL_DIST_ALL DIST
1062: WHERE ZL.TAX_LINE_ID = DET.TAX_LINE_ID
1063: AND DIST.CUST_TRX_LINE_GL_DIST_ID = DET.ACTG_SOURCE_ID
1064: AND DIST.CUSTOMER_TRX_ID = ZL.TRX_ID) * currency_conversion_rate) / l_mau) * l_mau
1065: WHERE request_id = p_trl_global_variables_rec.request_id

Line 1958: FROM ra_cust_trx_line_gl_dist_all gl_dist,

1954: j IN binary_integer) IS
1955: CURSOR trx_ccid (c_trx_id number, c_event_id number, c_ae_header_id number) IS
1956: SELECT
1957: ael.code_combination_id
1958: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1959: xla_distribution_links lnk,
1960: xla_ae_lines ael
1961: WHERE gl_dist.customer_trx_id = c_trx_id
1962: AND gl_dist.account_class = 'REV'

Line 1964: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

1960: xla_ae_lines ael
1961: WHERE gl_dist.customer_trx_id = c_trx_id
1962: AND gl_dist.account_class = 'REV'
1963: AND lnk.application_id = 222
1964: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
1965: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
1966: AND lnk.ae_header_id = ael.ae_header_id
1967: AND lnk.ae_line_num = ael.ae_line_num
1968: AND lnk.event_id = c_event_id

Line 1977: FROM ra_cust_trx_line_gl_dist_all gl_dist,

1973:
1974: CURSOR trx_line_ccid (c_trx_id number, c_trx_line_id number, c_event_id number, c_ae_header_id NUMBER) IS
1975: SELECT
1976: ael.code_combination_id
1977: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1978: xla_distribution_links lnk,
1979: xla_ae_lines ael
1980: WHERE gl_dist.customer_trx_id = c_trx_id
1981: AND gl_dist.customer_trx_line_id = c_trx_line_id

Line 1984: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

1980: WHERE gl_dist.customer_trx_id = c_trx_id
1981: AND gl_dist.customer_trx_line_id = c_trx_line_id
1982: AND gl_dist.account_class = 'REV'
1983: AND lnk.application_id = 222
1984: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
1985: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
1986: AND lnk.ae_header_id = ael.ae_header_id
1987: AND lnk.ae_line_num = ael.ae_line_num
1988: AND lnk.event_id = c_event_id

Line 2001: FROM ra_cust_trx_line_gl_dist_all gl_dist,

1997:
1998: CURSOR trx_dist_ccid (c_trx_id NUMBER, c_trx_line_id NUMBER, c_event_id NUMBER, c_ae_header_id NUMBER) IS
1999: SELECT
2000: /*+ leading(gl_dist)*/ ael.code_combination_id
2001: FROM ra_cust_trx_line_gl_dist_all gl_dist,
2002: xla_distribution_links lnk,
2003: xla_ae_lines ael
2004: WHERE gl_dist.customer_trx_id = c_trx_id
2005: AND gl_dist.customer_trx_line_id = c_trx_line_id

Line 2008: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

2004: WHERE gl_dist.customer_trx_id = c_trx_id
2005: AND gl_dist.customer_trx_line_id = c_trx_line_id
2006: AND gl_dist.account_class = 'REV'
2007: AND lnk.application_id = 222
2008: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
2009: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
2010: AND lnk.ae_header_id = ael.ae_header_id
2011: AND lnk.ae_line_num = ael.ae_line_num
2012: AND lnk.event_id = c_event_id

Line 2021: FROM ra_cust_trx_line_gl_dist_all gl_dist,

2017:
2018: CURSOR trx_dist_ccid_tax_event (c_trx_id NUMBER, c_trx_line_id NUMBER, c_ledger_id NUMBER) IS
2019: SELECT
2020: /*+ leading(gl_dist)*/ ael.code_combination_id
2021: FROM ra_cust_trx_line_gl_dist_all gl_dist,
2022: xla_distribution_links lnk,
2023: xla_ae_lines ael
2024: WHERE gl_dist.customer_trx_id = c_trx_id
2025: AND gl_dist.customer_trx_line_id = c_trx_line_id

Line 2028: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

2024: WHERE gl_dist.customer_trx_id = c_trx_id
2025: AND gl_dist.customer_trx_line_id = c_trx_line_id
2026: AND gl_dist.account_class = 'REV'
2027: AND lnk.application_id = 222
2028: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
2029: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
2030: AND lnk.ae_header_id = ael.ae_header_id
2031: AND lnk.ae_line_num = ael.ae_line_num
2032: AND ael.application_id = lnk.application_id

Line 2040: FROM ra_cust_trx_line_gl_dist_all gl_dist,

2036:
2037: CURSOR trx_dist_unrev_ccid (c_trx_id NUMBER, c_trx_line_id NUMBER, c_event_id NUMBER, c_ae_header_id NUMBER) IS
2038: SELECT
2039: /*+ leading(gl_dist)*/ ael.code_combination_id
2040: FROM ra_cust_trx_line_gl_dist_all gl_dist,
2041: xla_distribution_links lnk,
2042: xla_ae_lines ael
2043: WHERE gl_dist.customer_trx_id = c_trx_id
2044: AND gl_dist.customer_trx_line_id = c_trx_line_id

Line 2047: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

2043: WHERE gl_dist.customer_trx_id = c_trx_id
2044: AND gl_dist.customer_trx_line_id = c_trx_line_id
2045: AND gl_dist.account_class = 'UNEARN'
2046: AND lnk.application_id = 222
2047: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
2048: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
2049: AND lnk.ae_header_id = ael.ae_header_id
2050: AND lnk.ae_line_num = ael.ae_line_num
2051: AND lnk.event_id = c_event_id

Line 2060: FROM ra_cust_trx_line_gl_dist_all gl_dist,

2056:
2057: CURSOR tax_ccid (c_trx_id number, c_event_id number, c_ae_header_id number) IS
2058: SELECT
2059: ael.code_combination_id
2060: FROM ra_cust_trx_line_gl_dist_all gl_dist,
2061: xla_distribution_links lnk,
2062: xla_ae_lines ael
2063: WHERE gl_dist.customer_trx_id = c_trx_id
2064: AND gl_dist.account_class = 'TAX'

Line 2066: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

2062: xla_ae_lines ael
2063: WHERE gl_dist.customer_trx_id = c_trx_id
2064: AND gl_dist.account_class = 'TAX'
2065: AND lnk.application_id = 222
2066: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
2067: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
2068: AND lnk.ae_header_id = ael.ae_header_id
2069: AND lnk.ae_line_num = ael.ae_line_num
2070: AND lnk.event_id = c_event_id

Line 2079: FROM ra_cust_trx_line_gl_dist_all gl_dist,

2075:
2076: CURSOR tax_line_ccid (c_trx_id number, c_tax_line_id NUMBER, c_event_id number, c_ae_header_id number) IS
2077: SELECT
2078: ael.code_combination_id
2079: FROM ra_cust_trx_line_gl_dist_all gl_dist,
2080: xla_distribution_links lnk,
2081: xla_ae_lines ael
2082: WHERE gl_dist.customer_trx_id = c_trx_id
2083: AND gl_dist.customer_trx_line_id = c_tax_line_id

Line 2086: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

2082: WHERE gl_dist.customer_trx_id = c_trx_id
2083: AND gl_dist.customer_trx_line_id = c_tax_line_id
2084: AND gl_dist.account_class = 'TAX'
2085: AND lnk.application_id = 222
2086: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
2087: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
2088: AND lnk.ae_header_id = ael.ae_header_id
2089: AND lnk.ae_line_num = ael.ae_line_num
2090: AND lnk.event_id = c_event_id

Line 2106: FROM ra_cust_trx_line_gl_dist_all gl_dist,

2102: CURSOR tax_dist_ccid (c_trx_id NUMBER, c_tax_line_dist_id NUMBER,
2103: c_event_id number, c_ae_header_id number) IS
2104: SELECT
2105: ael.code_combination_id
2106: FROM ra_cust_trx_line_gl_dist_all gl_dist,
2107: xla_distribution_links lnk,
2108: xla_ae_lines ael
2109: WHERE gl_dist.customer_trx_id = c_trx_id
2110: -- AND gl_dist.customer_trx_line_id = c_tax_line_id

Line 2114: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

2110: -- AND gl_dist.customer_trx_line_id = c_tax_line_id
2111: AND gl_dist.cust_trx_line_gl_dist_id = c_tax_line_dist_id
2112: AND gl_dist.account_class = 'TAX'
2113: AND lnk.application_id = 222
2114: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
2115: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
2116: AND lnk.ae_header_id = ael.ae_header_id
2117: AND lnk.ae_line_num = ael.ae_line_num
2118: AND lnk.event_id = c_event_id

Line 2610: FROM ra_cust_trx_line_gl_dist_all gl_dist,

2606:
2607: CURSOR taxable_amount_hdr (c_trx_id NUMBER, c_ae_header_id NUMBER, c_event_id NUMBER, c_ledger_id NUMBER) IS
2608: SELECT sum(nvl(lnk.UNROUNDED_ENTERED_DR,0)) - sum(nvl(lnk.UNROUNDED_ENTERED_CR,0)),
2609: sum(nvl(lnk.UNROUNDED_ACCOUNTED_DR,0)) - SUM(nvl(lnk.UNROUNDED_ACCOUNTED_CR,0))
2610: FROM ra_cust_trx_line_gl_dist_all gl_dist,
2611: xla_distribution_links lnk,
2612: xla_ae_headers aeh,
2613: xla_ae_lines ael
2614: WHERE gl_dist.customer_trx_id = c_trx_id

Line 2617: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

2613: xla_ae_lines ael
2614: WHERE gl_dist.customer_trx_id = c_trx_id
2615: AND lnk.application_id = 222
2616: AND gl_dist.account_class = 'REV'
2617: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
2618: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
2619: AND lnk.ae_header_id = c_ae_header_id
2620: AND lnk.event_id = c_event_id
2621: AND lnk.ae_line_num = ael.ae_line_num

Line 2633: FROM ra_cust_trx_line_gl_dist_all gl_dist,

2629:
2630: CURSOR tax_amount_hdr (c_trx_id NUMBER, c_ae_header_id NUMBER, c_event_id NUMBER,c_ledger_id NUMBER) IS
2631: SELECT sum(nvl(lnk.UNROUNDED_ENTERED_DR,0)) - sum(nvl(lnk.UNROUNDED_ENTERED_CR,0)),
2632: sum(nvl(lnk.UNROUNDED_ACCOUNTED_DR,0)) - SUM(nvl(lnk.UNROUNDED_ACCOUNTED_CR,0))
2633: FROM ra_cust_trx_line_gl_dist_all gl_dist,
2634: xla_distribution_links lnk,
2635: xla_ae_headers aeh,
2636: xla_ae_lines ael
2637: WHERE gl_dist.customer_trx_id = c_trx_id

Line 2640: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

2636: xla_ae_lines ael
2637: WHERE gl_dist.customer_trx_id = c_trx_id
2638: AND gl_dist.account_class = 'TAX'
2639: AND lnk.application_id = 222
2640: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
2641: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
2642: AND lnk.ae_header_id = c_ae_header_id
2643: AND lnk.event_id = c_event_id
2644: AND lnk.ae_line_num = ael.ae_line_num

Line 2658: FROM ra_cust_trx_line_gl_dist_all gl_dist,

2654:
2655: CURSOR taxable_amount_line (c_trx_id NUMBER,c_trx_line_id NUMBER, c_ae_header_id NUMBER,
2656: c_event_id NUMBER, c_ledger_id NUMBER) IS
2657: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
2658: FROM ra_cust_trx_line_gl_dist_all gl_dist,
2659: xla_distribution_links lnk,
2660: xla_ae_headers aeh,
2661: xla_ae_lines ael
2662: WHERE gl_dist.customer_trx_id = c_trx_id

Line 2666: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

2662: WHERE gl_dist.customer_trx_id = c_trx_id
2663: AND gl_dist.customer_trx_line_id = c_trx_line_id
2664: AND gl_dist.account_class = 'REV'
2665: AND lnk.application_id = 222
2666: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
2667: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
2668: AND lnk.ae_header_id = c_ae_header_id
2669: AND lnk.event_id = c_event_id
2670: AND lnk.ae_line_num = ael.ae_line_num

Line 2681: FROM ra_cust_trx_line_gl_dist_all gl_dist,

2677:
2678:
2679: 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
2680: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
2681: FROM ra_cust_trx_line_gl_dist_all gl_dist,
2682: xla_distribution_links lnk,
2683: xla_ae_headers aeh,
2684: xla_ae_lines ael
2685: WHERE gl_dist.customer_trx_id = c_trx_id

Line 2689: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

2685: WHERE gl_dist.customer_trx_id = c_trx_id
2686: AND gl_dist.customer_trx_line_id = c_tax_line_id
2687: AND gl_dist.account_class = 'TAX'
2688: AND lnk.application_id = 222
2689: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
2690: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
2691: AND lnk.event_id = c_event_id
2692: AND lnk.ae_header_id = c_ae_header_id
2693: AND lnk.ae_line_num = ael.ae_line_num

Line 2712: FROM ra_cust_trx_line_gl_dist_all gl_dist,

2708: c_event_id NUMBER, c_ledger_id NUMBER) IS
2709: SELECT sum(nvl(lnk.UNROUNDED_ENTERED_CR,0)) - sum(nvl(lnk.UNROUNDED_ENTERED_DR,0)),
2710: sum(nvl(lnk.UNROUNDED_ACCOUNTED_CR,0)) - SUM(nvl(lnk.UNROUNDED_ACCOUNTED_DR,0))
2711: --sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
2712: FROM ra_cust_trx_line_gl_dist_all gl_dist,
2713: xla_distribution_links lnk,
2714: xla_ae_headers aeh,
2715: xla_ae_lines ael
2716: WHERE gl_dist.customer_trx_id = c_trx_id

Line 2721: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

2717: -- AND gl_dist.customer_trx_line_id = c_tax_line_id
2718: AND gl_dist.cust_trx_line_gl_dist_id = c_tax_dist_id
2719: AND gl_dist.account_class = 'TAX'
2720: AND lnk.application_id = 222
2721: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
2722: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
2723: AND ael.accounting_class_code = 'TAX'
2724: AND lnk.ae_header_id = ael.ae_header_id
2725: AND lnk.ae_line_num = ael.ae_line_num

Line 2745: FROM RA_CUST_TRX_LINE_GL_DIST_ALL GL_DIST_TAX,

2741: c_ledger_id NUMBER,
2742: c_tax_dist_id NUMBER) IS
2743: SELECT SIGN(GL_DIST_TAX.PERCENT)* V.TAXABLE_AMT,
2744: SIGN(GL_DIST_TAX.PERCENT)* V.TAXABLE_FUNC_AMT
2745: FROM RA_CUST_TRX_LINE_GL_DIST_ALL GL_DIST_TAX,
2746: (SELECT SUM(NVL(LNK.UNROUNDED_ENTERED_CR,0) - NVL(LNK.UNROUNDED_ENTERED_DR,0)) TAXABLE_AMT,
2747: sum(nvl(lnk.UNROUNDED_ACCOUNTED_CR,0) - nvl(lnk.UNROUNDED_ACCOUNTED_DR,0)) TAXABLE_FUNC_AMT
2748: FROM ra_cust_trx_line_gl_dist_all gl_dist_line,
2749: xla_distribution_links lnk,

Line 2748: FROM ra_cust_trx_line_gl_dist_all gl_dist_line,

2744: SIGN(GL_DIST_TAX.PERCENT)* V.TAXABLE_FUNC_AMT
2745: FROM RA_CUST_TRX_LINE_GL_DIST_ALL GL_DIST_TAX,
2746: (SELECT SUM(NVL(LNK.UNROUNDED_ENTERED_CR,0) - NVL(LNK.UNROUNDED_ENTERED_DR,0)) TAXABLE_AMT,
2747: sum(nvl(lnk.UNROUNDED_ACCOUNTED_CR,0) - nvl(lnk.UNROUNDED_ACCOUNTED_DR,0)) TAXABLE_FUNC_AMT
2748: FROM ra_cust_trx_line_gl_dist_all gl_dist_line,
2749: xla_distribution_links lnk,
2750: xla_ae_headers aeh,
2751: xla_ae_lines ael
2752: WHERE gl_dist_line.customer_trx_id = c_trx_id

Line 2756: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

2752: WHERE gl_dist_line.customer_trx_id = c_trx_id
2753: AND gl_dist_line.customer_trx_line_id = c_trx_line_id
2754: -- AND gl_dist_line.account_class = 'REV'
2755: AND lnk.application_id = 222
2756: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
2757: AND ael.accounting_class_code in ('REVENUE','UNEARNED_REVENUE','SUSPENSE','UNBILL')
2758: AND lnk.source_distribution_id_num_1 = gl_dist_line.cust_trx_line_gl_dist_id
2759: AND lnk.ae_header_id = c_ae_header_id
2760: AND lnk.event_id = c_event_id