[Home] [Help]
452: , NULL -- tax_inc_flag
453: --}
454: , DECODE(ctl.line_type,'LINE',taxx.vat_tax_id,ctl.vat_tax_id) vat_tax_id
455: , DECODE(ctl.line_type,'LINE',taxx.location_segment_id,ctl.location_segment_id)
456: FROM ra_customer_trx trx,
457: ra_customer_trx_lines ctl,
458: ra_cust_trx_line_gl_dist ctlgd,
459: ( select ctl_tax.*
460: from ra_customer_trx_lines ctl_tax
453: --}
454: , DECODE(ctl.line_type,'LINE',taxx.vat_tax_id,ctl.vat_tax_id) vat_tax_id
455: , DECODE(ctl.line_type,'LINE',taxx.location_segment_id,ctl.location_segment_id)
456: FROM ra_customer_trx trx,
457: ra_customer_trx_lines ctl,
458: ra_cust_trx_line_gl_dist ctlgd,
459: ( select ctl_tax.*
460: from ra_customer_trx_lines ctl_tax
461: where customer_trx_id = p_trx_id
456: FROM ra_customer_trx trx,
457: ra_customer_trx_lines ctl,
458: ra_cust_trx_line_gl_dist ctlgd,
459: ( select ctl_tax.*
460: from ra_customer_trx_lines ctl_tax
461: where customer_trx_id = p_trx_id
462: and nvl(ctl_tax.line_number,1) = 1
463: and line_type = 'TAX'
464: ) taxx
661: , DECODE(ctl.line_type,'LINE',taxx.location_segment_id,ctl.location_segment_id)
662: FROM xla_events_gt evt,
663: ar_receivable_applications_all app,
664: ar_system_parameters_all ars,
665: ra_customer_trx_all trx,
666: ra_customer_trx_lines_all ctl,
667: ra_cust_trx_line_gl_dist_all ctlgd,
668: ( select ctl_tax.*
669: from ra_customer_trx_lines ctl_tax
662: FROM xla_events_gt evt,
663: ar_receivable_applications_all app,
664: ar_system_parameters_all ars,
665: ra_customer_trx_all trx,
666: ra_customer_trx_lines_all ctl,
667: ra_cust_trx_line_gl_dist_all ctlgd,
668: ( select ctl_tax.*
669: from ra_customer_trx_lines ctl_tax
670: where nvl(ctl_tax.line_number,1) = 1
665: ra_customer_trx_all trx,
666: ra_customer_trx_lines_all ctl,
667: ra_cust_trx_line_gl_dist_all ctlgd,
668: ( select ctl_tax.*
669: from ra_customer_trx_lines ctl_tax
670: where nvl(ctl_tax.line_number,1) = 1
671: and line_type = 'TAX'
672: ) taxx
673: WHERE evt.event_type_code IN ('RECP_CREATE' ,'RECP_UPDATE' ,
698: inv.invoice_currency_code,
699: inv.set_of_books_id
700: FROM xla_events_gt evt,
701: ar_receivable_applications_all app,
702: ra_customer_trx_all inv,
703: ar_system_parameters_all ars
704: WHERE evt.event_type_code
705: IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
706: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,
719: inv.invoice_currency_code,
720: inv.set_of_books_id
721: FROM xla_events_gt evt,
722: ar_receivable_applications_all app,
723: ra_customer_trx_all inv,
724: ar_system_parameters_all ars
725: WHERE evt.event_type_code
726: IN ( 'CM_CREATE' ,'CM_UPDATE' )
727: AND evt.event_id = app.event_id
731: AND ars.accounting_method = 'CASH'
732: AND NOT EXISTS ( SELECT '1'
733: FROM psa_trx_types_all psa
734: WHERE inv.cust_trx_type_id = psa.psa_trx_type_id)) trx,
735: ra_customer_trx_lines_all ctl,
736: ra_cust_trx_line_gl_dist_all ctlgd
737: WHERE trx.customer_trx_id = ctl.customer_trx_id
738: AND ctl.customer_trx_line_id = ctlgd.customer_trx_line_id
739: AND ctl.line_type IN ('LINE','TAX','FREIGHT','CHARGES','CB')
942: inv.invoice_currency_code,
943: inv.set_of_books_id
944: FROM xla_events_gt evt,
945: ar_receivable_applications_all app,
946: ra_customer_trx_all inv,
947: psa_trx_types_all psa
948: WHERE evt.event_type_code
949: IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
950: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,
959: inv.invoice_currency_code,
960: inv.set_of_books_id
961: FROM xla_events_gt evt,
962: ar_receivable_applications_all app,
963: ra_customer_trx_all inv,
964: psa_trx_types_all psa
965: WHERE evt.event_type_code
966: IN ( 'CM_CREATE' ,'CM_UPDATE' )
967: AND evt.event_id = app.event_id
967: AND evt.event_id = app.event_id
968: AND app.customer_trx_id = inv.customer_trx_id
969: AND inv.cust_trx_type_id = psa.psa_trx_type_id
970: AND app.upgrade_method IS NULL) trx,
971: ra_customer_trx_lines_all ctl,
972: ra_cust_trx_line_gl_dist_all ctlgd
973: WHERE trx.customer_trx_id = ctl.customer_trx_id
974: AND ctl.customer_trx_line_id = ctlgd.customer_trx_line_id
975: AND ctl.line_type IN ('LINE','TAX','FREIGHT','CHARGES','CB')
1333: , decode(adj.type, 'TAX', nvl(ard.location_segment_id, taxx.location_segment_id), taxx.location_segment_id)
1334: FROM ar_adjustments adj,
1335: ar_distributions ard,
1336: ( select customer_trx_id, vat_tax_id, location_segment_id
1337: from ra_customer_trx_lines
1338: where customer_trx_id = p_trx_id
1339: and line_type = 'LINE'
1340: and rownum = 1
1341: ) taxx,
1942: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
1943: MAX(to_currency) invoice_currency_code
1944: FROM ra_ar_gt
1945: GROUP BY ref_customer_trx_id, to_currency) trx,
1946: ra_customer_trx_lines_all ctl,
1947: ra_cust_trx_line_gl_dist_all ctlgd
1948: WHERE adj.customer_trx_id = trx.ref_customer_trx_id
1949: AND adj.status = 'A'
1950: AND adj.postable = 'Y'
2723: AND app.org_id = ars.org_id
2724: AND ars.accounting_method = 'CASH'
2725: AND NOT EXISTS (SELECT '1'
2726: FROM psa_trx_types_all psa,
2727: ra_customer_trx_all inv
2728: WHERE inv.customer_trx_id = app.applied_customer_trx_id
2729: AND inv.cust_trx_type_id = psa.psa_trx_type_id);
2730: /*
2731: -- Only to reconcile for CMAPP the applied to transaction
2744: AND app.org_id = ars.org_id
2745: AND ars.accounting_method = 'CASH'
2746: AND NOT EXISTS (SELECT '1'
2747: FROM psa_trx_types_all psa,
2748: ra_customer_trx_all inv
2749: WHERE inv.customer_trx_id = app.customer_trx_id
2750: AND inv.cust_trx_type_id = psa.psa_trx_type_id);
2751: */
2752: l_app_rec ar_receivable_applications%ROWTYPE;