[Home] [Help]
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
563: AND zx_dtl.extract_source_ledger = 'AR'
564: AND zx_dtl.posted_date IS NOT NULL
565: AND zx_dtl.trx_id = xla_ent.source_id_int_1 -- Accounting Joins
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
789: AND zx_dtl.extract_source_ledger = 'AR'
790: AND zx_dtl.posted_date IS NOT NULL
791: AND zx_dtl.trx_id = xla_ent.source_id_int_1
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'
1769: AND lnk.application_id = 222
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
1787: AND gl_dist.account_class = 'REV'
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
1810: AND gl_dist.account_class = 'REV'
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'
1830: AND lnk.application_id = 222
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
1848: AND gl_dist.account_class = 'TAX'
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
1874: AND gl_dist.cust_trx_line_gl_dist_id = c_tax_line_dist_id
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
2320: AND lnk.application_id = 222
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
2343: AND gl_dist.account_class = 'TAX'
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
2368: AND gl_dist.customer_trx_line_id = c_trx_line_id
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
2391: AND gl_dist.customer_trx_line_id = c_tax_line_id
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
2422: -- AND gl_dist.customer_trx_line_id = c_tax_line_id
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
2451: AND gl_dist.customer_trx_line_id = c_trx_line_id
2564: CURSOR trx_ccid (c_actg_source_id number, c_event_id number, c_ae_header_id number) IS
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'
2581: CURSOR trx_dist_ccid (c_actg_source_id number, c_event_id number, c_ae_header_id number) IS
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
2601: CURSOR tax_ccid (c_actg_source_id number, c_event_id number, c_ae_header_id number) IS
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
2621: CURSOR tax_dist_ccid (c_actg_source_id number, c_event_id number, c_ae_header_id number) IS
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'
3120: CURSOR taxable_amount_hdr (c_actg_source_id NUMBER, c_ae_header_id NUMBER,
3121: c_event_id NUMBER,c_ledger_id NUMBER) IS
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
3142: c_event_id NUMBER,c_ledger_id NUMBER) IS
3143: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
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
3168: CURSOR taxable_amount_dist (c_actg_source_id NUMBER, c_ae_header_id NUMBER, c_event_id NUMBER,c_ledger_id NUMBER) IS
3169: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
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
3191: CURSOR tax_amount_dist (c_actg_source_id NUMBER, c_ae_header_id NUMBER,
3192: c_event_id NUMBER,c_ledger_id NUMBER) IS
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