[Home] [Help]
578: xla_ae_headers xla_head,
579: xla_ae_lines xla_line,
580: xla_acct_class_assgns acs,
581: xla_assignment_defns_b asd,
582: xla_distribution_links xla_dist
583: WHERE zx_dtl.request_id = c_request_id
584: AND zx_dtl.extract_source_ledger = 'AR'
585: AND ( ( zx_dtl.account_class = 'TAX'
586: AND xla_ent.entity_code = 'TRANSACTIONS'
826: xla_ae_headers xla_head,
827: xla_ae_lines xla_line,
828: xla_acct_class_assgns acs,
829: xla_assignment_defns_b asd,
830: xla_distribution_links xla_dist
831: WHERE zx_dtl.request_id = c_request_id
832: AND zx_dtl.extract_source_ledger = 'AR'
833: AND zx_dtl.account_class = 'TAX'
834: AND zx_dtl.posted_date IS NOT NULL
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'
1963: AND lnk.application_id = 222
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
1982: AND gl_dist.account_class = 'REV'
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
2006: AND gl_dist.account_class = 'REV'
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
2026: AND gl_dist.account_class = 'REV'
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
2045: AND gl_dist.account_class = 'UNEARN'
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'
2065: AND lnk.application_id = 222
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
2084: AND gl_dist.account_class = 'TAX'
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
2111: AND gl_dist.cust_trx_line_gl_dist_id = c_tax_line_dist_id
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
2615: AND lnk.application_id = 222
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
2638: AND gl_dist.account_class = 'TAX'
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
2663: AND gl_dist.customer_trx_line_id = c_trx_line_id
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
2686: AND gl_dist.customer_trx_line_id = c_tax_line_id
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
2717: -- AND gl_dist.customer_trx_line_id = c_tax_line_id
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
2753: AND gl_dist_line.customer_trx_line_id = c_trx_line_id
2868: CURSOR trx_ccid (c_actg_source_id number, c_event_id number, c_ae_header_id number) IS
2869: SELECT
2870: ael.code_combination_id
2871: FROM ar_distributions_all dist,
2872: xla_distribution_links lnk,
2873: xla_ae_lines ael
2874: WHERE dist.line_id = c_actg_source_id
2875: AND lnk.application_id = 222
2876: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
2885: /* CURSOR trx_dist_ccid (c_actg_source_id number, c_event_id number, c_ae_header_id number) IS
2886: SELECT ael.code_combination_id
2887: FROM ar_distributions_all dist,
2888: ar_distributions_all taxdist,
2889: xla_distribution_links lnk,
2890: xla_ae_lines ael
2891: WHERE taxdist.line_id = p_actg_source_id
2892: AND NVL(dist.source_table,'X') = NVL(taxdist.source_table_secondary,'X')
2893: AND dist.tax_link_id = taxdist.tax_link_id
2905:
2906: CURSOR trx_dist_ccid_misc (c_trx_line_id number, c_event_id number, c_ae_header_id number) IS
2907: SELECT ael.code_combination_id
2908: FROM ar_distributions_all dist,
2909: xla_distribution_links lnk,
2910: xla_ae_lines ael
2911: WHERE dist.line_id = c_trx_line_id
2912: AND dist.source_table= 'MCD'
2913: AND lnk.source_distribution_id_num_1 = dist.line_id
2922:
2923: CURSOR trx_dist_ccid_app (c_trx_line_id number, c_event_id number, c_ae_header_id number) IS
2924: SELECT ael.code_combination_id
2925: FROM ar_distributions_all dist,
2926: xla_distribution_links lnk,
2927: xla_ae_lines ael
2928: WHERE dist.line_id = c_trx_line_id
2929: AND dist.source_table= 'RA'
2930: AND lnk.source_distribution_id_num_1 = dist.line_id
2939:
2940: CURSOR trx_dist_ccid_adj (c_trx_line_id number, c_event_id number, c_ae_header_id number) IS
2941: SELECT ael.code_combination_id
2942: FROM ar_distributions_all dist,
2943: xla_distribution_links lnk,
2944: xla_ae_lines ael
2945: WHERE dist.line_id = c_trx_line_id
2946: AND dist.source_table= 'ADJ'
2947: AND lnk.source_distribution_id_num_1 = dist.line_id
2957: CURSOR tax_ccid (c_actg_source_id number, c_event_id number, c_ae_header_id number) IS
2958: SELECT ael.code_combination_id
2959: FROM ar_distributions_all dist,
2960: ar_distributions_all taxdist,
2961: xla_distribution_links lnk,
2962: xla_ae_lines ael
2963: WHERE dist.line_id = c_actg_source_id
2964: AND NVL(dist.source_table,'X') = NVL(taxdist.source_table_secondary,'X')
2965: AND dist.tax_link_id = taxdist.tax_link_id
2977: CURSOR tax_dist_ccid (c_actg_source_id number, c_event_id number, c_ae_header_id number) IS
2978: SELECT
2979: ael.code_combination_id
2980: FROM ar_distributions_all taxdist,
2981: xla_distribution_links lnk,
2982: xla_ae_lines ael
2983: WHERE taxdist.line_id = c_actg_source_id
2984: AND lnk.application_id = 222
2985: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
3464: CURSOR taxable_amount_hdr (c_actg_source_id NUMBER, c_ae_header_id NUMBER,
3465: c_event_id NUMBER,c_ledger_id NUMBER) IS
3466: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
3467: FROM ar_distributions_all dist,
3468: xla_distribution_links lnk,
3469: xla_ae_headers aeh,
3470: xla_ae_lines ael
3471: WHERE dist.line_id = c_actg_source_id
3472: AND lnk.application_id = 222
3486: c_event_id NUMBER,c_ledger_id NUMBER) IS
3487: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
3488: FROM AR_DISTRIBUTIONS_ALL dist,
3489: AR_DISTRIBUTIONS_ALL taxdist,
3490: xla_distribution_links lnk,
3491: xla_ae_headers aeh,
3492: xla_ae_lines ael
3493: WHERE dist.line_id = c_actg_source_id
3494: AND taxdist.tax_link_id = dist.tax_link_id
3513: --SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
3514: SELECT sum(nvl(lnk.UNROUNDED_ENTERED_CR,0)) - sum(nvl(lnk.UNROUNDED_ENTERED_DR,0)),
3515: sum(nvl(lnk.UNROUNDED_ACCOUNTED_CR,0)) - SUM(nvl(lnk.UNROUNDED_ACCOUNTED_DR,0))
3516: FROM AR_DISTRIBUTIONS_ALL dist,
3517: xla_distribution_links lnk,
3518: xla_ae_headers aeh,
3519: xla_ae_lines ael
3520: WHERE dist.line_id = c_trx_line_id
3521: AND lnk.source_distribution_id_num_1 = dist.line_id
3534: CURSOR taxable_amount_dist_app(c_trx_line_id NUMBER, c_ae_header_id NUMBER, c_event_id NUMBER,c_ledger_id NUMBER) IS
3535: SELECT sum(nvl(lnk.UNROUNDED_ENTERED_CR,0)) - sum(nvl(lnk.UNROUNDED_ENTERED_DR,0)),
3536: sum(nvl(lnk.UNROUNDED_ACCOUNTED_CR,0)) - SUM(nvl(lnk.UNROUNDED_ACCOUNTED_DR,0))
3537: FROM AR_DISTRIBUTIONS_ALL dist,
3538: xla_distribution_links lnk,
3539: xla_ae_headers aeh,
3540: xla_ae_lines ael
3541: WHERE dist.line_id = c_trx_line_id
3542: AND lnk.source_distribution_id_num_1 = dist.line_id
3555: CURSOR taxable_amount_dist_adj(c_trx_line_id NUMBER, c_ae_header_id NUMBER, c_event_id NUMBER,c_ledger_id NUMBER) IS
3556: SELECT sum(nvl(lnk.UNROUNDED_ENTERED_CR,0)) - sum(nvl(lnk.UNROUNDED_ENTERED_DR,0)),
3557: sum(nvl(lnk.UNROUNDED_ACCOUNTED_CR,0)) - SUM(nvl(lnk.UNROUNDED_ACCOUNTED_DR,0))
3558: FROM AR_DISTRIBUTIONS_ALL dist,
3559: xla_distribution_links lnk,
3560: xla_ae_headers aeh,
3561: xla_ae_lines ael
3562: WHERE dist.line_id = c_trx_line_id
3563: AND lnk.source_distribution_id_num_1 = dist.line_id
3578: --SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
3579: SELECT sum(nvl(lnk.UNROUNDED_ENTERED_CR,0)) - sum(nvl(lnk.UNROUNDED_ENTERED_DR,0)),
3580: sum(nvl(lnk.UNROUNDED_ACCOUNTED_CR,0)) - SUM(nvl(lnk.UNROUNDED_ACCOUNTED_DR,0))
3581: FROM ar_distributions_all taxdist,
3582: xla_distribution_links lnk,
3583: xla_ae_headers aeh,
3584: xla_ae_lines ael
3585: WHERE taxdist.line_id = c_actg_source_id
3586: AND lnk.application_id = 222