APPS.AR_UPGRADE_CASH_ACCRUAL dependencies on RA_CUSTOMER_TRX_ALL

Line 645: ra_customer_trx_all trx,

641: , NULL -- tax_inc_flag
642: FROM xla_events_gt evt,
643: ar_receivable_applications_all app,
644: ar_system_parameters_all ars,
645: ra_customer_trx_all trx,
646: ra_customer_trx_lines_all ctl,
647: ra_cust_trx_line_gl_dist_all ctlgd
648: WHERE evt.event_type_code IN ('RECP_CREATE' ,'RECP_UPDATE' ,
649: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,

Line 676: ra_customer_trx_all inv,

672: inv.invoice_currency_code,
673: inv.set_of_books_id
674: FROM xla_events_gt evt,
675: ar_receivable_applications_all app,
676: ra_customer_trx_all inv,
677: ar_system_parameters_all ars
678: WHERE evt.event_type_code
679: IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
680: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,

Line 697: ra_customer_trx_all inv,

693: inv.invoice_currency_code,
694: inv.set_of_books_id
695: FROM xla_events_gt evt,
696: ar_receivable_applications_all app,
697: ra_customer_trx_all inv,
698: ar_system_parameters_all ars
699: WHERE evt.event_type_code
700: IN ( 'CM_CREATE' ,'CM_UPDATE' )
701: AND evt.event_id = app.event_id

Line 920: ra_customer_trx_all inv,

916: inv.invoice_currency_code,
917: inv.set_of_books_id
918: FROM xla_events_gt evt,
919: ar_receivable_applications_all app,
920: ra_customer_trx_all inv,
921: psa_trx_types_all psa
922: WHERE evt.event_type_code
923: IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
924: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,

Line 937: ra_customer_trx_all inv,

933: inv.invoice_currency_code,
934: inv.set_of_books_id
935: FROM xla_events_gt evt,
936: ar_receivable_applications_all app,
937: ra_customer_trx_all inv,
938: psa_trx_types_all psa
939: WHERE evt.event_type_code
940: IN ( 'CM_CREATE' ,'CM_UPDATE' )
941: AND evt.event_id = app.event_id

Line 2508: ra_customer_trx_all inv

2504: AND app.org_id = ars.org_id
2505: AND ars.accounting_method = 'CASH'
2506: AND NOT EXISTS (SELECT '1'
2507: FROM psa_trx_types_all psa,
2508: ra_customer_trx_all inv
2509: WHERE inv.customer_trx_id = app.applied_customer_trx_id
2510: AND inv.cust_trx_type_id = psa.psa_trx_type_id);
2511: /*
2512: -- Only to reconcile for CMAPP the applied to transaction

Line 2529: ra_customer_trx_all inv

2525: AND app.org_id = ars.org_id
2526: AND ars.accounting_method = 'CASH'
2527: AND NOT EXISTS (SELECT '1'
2528: FROM psa_trx_types_all psa,
2529: ra_customer_trx_all inv
2530: WHERE inv.customer_trx_id = app.customer_trx_id
2531: AND inv.cust_trx_type_id = psa.psa_trx_type_id);
2532: */
2533: l_app_rec ar_receivable_applications%ROWTYPE;