[Home] [Help]
575: FROM zx_rep_trx_detail_t zx_dtl,
576: xla_transaction_entities xla_ent,
577: xla_events xla_event,
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
823: FROM zx_rep_trx_detail_t zx_dtl,
824: xla_transaction_entities xla_ent,
825: xla_events xla_event,
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
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
1964: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
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'
1983: AND lnk.application_id = 222
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'
2007: AND lnk.application_id = 222
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'
2027: AND lnk.application_id = 222
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'
2046: AND lnk.application_id = 222
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
2066: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
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'
2085: AND lnk.application_id = 222
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
2112: AND gl_dist.account_class = 'TAX'
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
2616: AND gl_dist.account_class = 'REV'
2617: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
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'
2639: AND lnk.application_id = 222
2640: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
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
2664: AND gl_dist.account_class = 'REV'
2665: AND lnk.application_id = 222
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
2687: AND gl_dist.account_class = 'TAX'
2688: AND lnk.application_id = 222
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
2718: AND gl_dist.cust_trx_line_gl_dist_id = c_tax_dist_id
2719: AND gl_dist.account_class = 'TAX'
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
2754: -- AND gl_dist_line.account_class = 'REV'
2755: AND lnk.application_id = 222
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'
2877: AND lnk.source_distribution_id_num_1 = dist.line_id
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
2894: AND dist.source_id = taxdist.source_id
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
2914: AND lnk.application_id = 222
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
2931: AND lnk.application_id = 222
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
2948: AND lnk.application_id = 222
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
2966: AND dist.source_id = taxdist.source_id
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'
2986: AND lnk.source_distribution_id_num_1 = taxdist.line_id
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
3473: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
3474: AND lnk.source_distribution_id_num_1 = dist.line_id
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
3495: AND NVL(taxdist.source_type_secondary,'X') = NVL(dist.source_type,'X')
3496: AND taxdist.source_id = dist.source_id
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
3522: AND lnk.application_id = 222
3523: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
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
3543: AND lnk.application_id = 222
3544: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
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
3564: AND lnk.application_id = 222
3565: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
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
3587: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
3588: AND lnk.source_distribution_id_num_1 = taxdist.line_id