eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_UPGRADE_CASH_ACCRUAL dependencies on RA_CUSTOMER_TRX

Line 447: FROM ra_customer_trx trx,

443: --{Taxable Amount
444: , NULL -- tax_link_id
445: , NULL -- tax_inc_flag
446: --}
447: FROM ra_customer_trx trx,
448: ra_customer_trx_lines ctl,
449: ra_cust_trx_line_gl_dist ctlgd
450: WHERE trx.customer_trx_id = p_trx_id
451: AND ctl.customer_trx_id = trx.customer_trx_id

Line 448: ra_customer_trx_lines ctl,

444: , NULL -- tax_link_id
445: , NULL -- tax_inc_flag
446: --}
447: FROM ra_customer_trx trx,
448: ra_customer_trx_lines ctl,
449: ra_cust_trx_line_gl_dist ctlgd
450: WHERE trx.customer_trx_id = p_trx_id
451: AND ctl.customer_trx_id = trx.customer_trx_id
452: AND ctl.customer_trx_line_id = ctlgd.customer_trx_line_id

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 646: ra_customer_trx_lines_all ctl,

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' ,
650: 'CM_CREATE' ,'CM_UPDATE' )

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 709: ra_customer_trx_lines_all ctl,

705: AND ars.accounting_method = 'CASH'
706: AND NOT EXISTS ( SELECT '1'
707: FROM psa_trx_types_all psa
708: WHERE inv.cust_trx_type_id = psa.psa_trx_type_id)) trx,
709: ra_customer_trx_lines_all ctl,
710: ra_cust_trx_line_gl_dist_all ctlgd
711: WHERE trx.customer_trx_id = ctl.customer_trx_id
712: AND ctl.customer_trx_line_id = ctlgd.customer_trx_line_id
713: AND ctl.line_type IN ('LINE','TAX','FREIGHT','CHARGES','CB')

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 945: ra_customer_trx_lines_all ctl,

941: AND evt.event_id = app.event_id
942: AND app.customer_trx_id = inv.customer_trx_id
943: AND inv.cust_trx_type_id = psa.psa_trx_type_id
944: AND app.upgrade_method IS NULL) trx,
945: ra_customer_trx_lines_all ctl,
946: ra_cust_trx_line_gl_dist_all ctlgd
947: WHERE trx.customer_trx_id = ctl.customer_trx_id
948: AND ctl.customer_trx_line_id = ctlgd.customer_trx_line_id
949: AND ctl.line_type IN ('LINE','TAX','FREIGHT','CHARGES','CB')

Line 1748: ra_customer_trx_lines_all ctl,

1744: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
1745: MAX(to_currency) invoice_currency_code
1746: FROM ra_ar_gt
1747: GROUP BY ref_customer_trx_id, to_currency) trx,
1748: ra_customer_trx_lines_all ctl,
1749: ra_cust_trx_line_gl_dist_all ctlgd
1750: WHERE adj.customer_trx_id = trx.ref_customer_trx_id
1751: AND adj.status = 'A'
1752: AND adj.postable = 'Y'

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;