[Home] [Help]
574: zx_dtl.def_rec_settlement_option_code
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
822: ZX_DTL.DEF_REC_SETTLEMENT_OPTION_CODE
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
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
2616: AND gl_dist.account_class = 'REV'
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'
2639: AND lnk.application_id = 222
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
2664: AND gl_dist.account_class = 'REV'
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
2687: AND gl_dist.account_class = 'TAX'
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
2718: AND gl_dist.cust_trx_line_gl_dist_id = c_tax_dist_id
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
2754: -- AND gl_dist_line.account_class = 'REV'
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
3473: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
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
3495: AND NVL(taxdist.source_type_secondary,'X') = NVL(dist.source_type,'X')
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
3522: AND lnk.application_id = 222
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
3543: AND lnk.application_id = 222
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
3564: AND lnk.application_id = 222
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
3587: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'