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 1764: FROM ra_cust_trx_line_gl_dist_all gl_dist,

1760: j IN binary_integer) IS
1761: CURSOR trx_ccid (c_trx_id number, c_event_id number, c_ae_header_id number) IS
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'

Line 1770: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

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'
1771: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
1772: AND lnk.ae_header_id = ael.ae_header_id
1773: AND lnk.ae_line_num = ael.ae_line_num
1774: AND lnk.event_id = c_event_id

Line 1782: FROM ra_cust_trx_line_gl_dist_all gl_dist,

1778:
1779: CURSOR trx_line_ccid (c_trx_id number, c_trx_line_id number, c_event_id number, c_ae_header_id NUMBER) IS
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

Line 1789: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

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
1789: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
1790: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
1791: AND lnk.ae_header_id = ael.ae_header_id
1792: AND lnk.ae_line_num = ael.ae_line_num
1793: AND lnk.event_id = c_event_id

Line 1805: FROM ra_cust_trx_line_gl_dist_all gl_dist,

1801:
1802: CURSOR trx_dist_ccid (c_trx_id NUMBER, c_trx_line_id NUMBER, c_event_id NUMBER, c_ae_header_id NUMBER) IS
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

Line 1812: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

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
1812: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
1813: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
1814: AND lnk.ae_header_id = ael.ae_header_id
1815: AND lnk.ae_line_num = ael.ae_line_num
1816: AND lnk.event_id = c_event_id

Line 1825: FROM ra_cust_trx_line_gl_dist_all gl_dist,

1821:
1822: CURSOR tax_ccid (c_trx_id number, c_event_id number, c_ae_header_id number) IS
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'

Line 1831: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

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'
1832: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
1833: AND lnk.ae_header_id = ael.ae_header_id
1834: AND lnk.ae_line_num = ael.ae_line_num
1835: AND lnk.event_id = c_event_id

Line 1843: FROM ra_cust_trx_line_gl_dist_all gl_dist,

1839:
1840: CURSOR tax_line_ccid (c_trx_id number, c_tax_line_id NUMBER, c_event_id number, c_ae_header_id number) IS
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

Line 1850: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

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
1850: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
1851: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
1852: AND lnk.ae_header_id = ael.ae_header_id
1853: AND lnk.ae_line_num = ael.ae_line_num
1854: AND lnk.event_id = c_event_id

Line 1869: FROM ra_cust_trx_line_gl_dist_all gl_dist,

1865: CURSOR tax_dist_ccid (c_trx_id NUMBER, c_tax_line_dist_id NUMBER,
1866: c_event_id number, c_ae_header_id number) IS
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

Line 1877: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

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'
1876: AND lnk.application_id = 222
1877: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
1878: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
1879: AND lnk.ae_header_id = ael.ae_header_id
1880: AND lnk.ae_line_num = ael.ae_line_num
1881: AND lnk.event_id = c_event_id

Line 2315: FROM ra_cust_trx_line_gl_dist_all gl_dist,

2311:
2312: CURSOR taxable_amount_hdr (c_trx_id NUMBER, c_ae_header_id NUMBER, c_event_id NUMBER, c_ledger_id NUMBER) IS
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

Line 2322: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

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'
2323: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
2324: AND lnk.ae_header_id = c_ae_header_id
2325: AND lnk.event_id = c_event_id
2326: AND lnk.ae_line_num = ael.ae_line_num

Line 2338: FROM ra_cust_trx_line_gl_dist_all gl_dist,

2334:
2335: CURSOR tax_amount_hdr (c_trx_id NUMBER, c_ae_header_id NUMBER, c_event_id NUMBER,c_ledger_id NUMBER) IS
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

Line 2345: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

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'
2346: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
2347: AND lnk.ae_header_id = c_ae_header_id
2348: AND lnk.event_id = c_event_id
2349: AND lnk.ae_line_num = ael.ae_line_num

Line 2363: FROM ra_cust_trx_line_gl_dist_all gl_dist,

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

Line 2371: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

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
2371: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
2372: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
2373: AND lnk.ae_header_id = c_ae_header_id
2374: AND lnk.event_id = c_event_id
2375: AND lnk.ae_line_num = ael.ae_line_num

Line 2386: FROM ra_cust_trx_line_gl_dist_all gl_dist,

2382:
2383:
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

Line 2394: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

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
2394: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
2395: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
2396: AND lnk.event_id = c_event_id
2397: AND lnk.ae_header_id = c_ae_header_id
2398: AND lnk.ae_line_num = ael.ae_line_num

Line 2417: FROM ra_cust_trx_line_gl_dist_all gl_dist,

2413: c_event_id NUMBER, c_ledger_id NUMBER) IS
2414: SELECT sum(nvl(lnk.UNROUNDED_ENTERED_CR,0)) - sum(nvl(lnk.UNROUNDED_ENTERED_DR,0)),
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

Line 2426: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

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'
2425: AND lnk.application_id = 222
2426: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
2427: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
2428: AND ael.accounting_class_code = 'TAX'
2429: AND lnk.ae_header_id = ael.ae_header_id
2430: AND lnk.ae_line_num = ael.ae_line_num

Line 2446: FROM ra_cust_trx_line_gl_dist_all gl_dist,

2442: c_event_id NUMBER, c_ledger_id NUMBER) IS
2443: SELECT sum(nvl(lnk.UNROUNDED_ENTERED_CR,0)) - sum(nvl(lnk.UNROUNDED_ENTERED_DR,0)),
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

Line 2454: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

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
2454: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
2455: AND ael.accounting_class_code = 'REVENUE'
2456: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
2457: AND lnk.ae_header_id = c_ae_header_id
2458: AND lnk.event_id = c_event_id