APPS.AR_UPGRADE_CASH_ACCRUAL dependencies on RA_CUSTOMER_TRX_ALL

Line 665: ra_customer_trx_all trx,

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

Line 702: ra_customer_trx_all inv,

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' ,

Line 723: ra_customer_trx_all inv,

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

Line 946: ra_customer_trx_all inv,

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' ,

Line 963: ra_customer_trx_all inv,

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

Line 2727: ra_customer_trx_all inv

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

Line 2748: ra_customer_trx_all inv

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;