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.ARP_XLA_EXTRACT_MAIN_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 961: ar_payment_schedules_all psch

957: oe_system_parameters_all osp,
958: ra_customer_trx_all trxf,
959: ra_customer_trx_lines_all tlf,
960: ra_cust_trx_line_gl_dist_all gldf,
961: ar_payment_schedules_all psch
962: WHERE gt.event_type_code IN ('CM_CREATE','CM_UPDATE' ) --BUG#3419926
963: AND gt.application_id = p_application_id
964: AND gt.event_id = app.event_id
965: AND dist.source_table = 'RA'

Line 1170: ar_payment_schedules_all psch

1166: oe_system_parameters_all osp,
1167: ra_customer_trx_all trxf,
1168: ra_customer_trx_lines_all tlf,
1169: ra_cust_trx_line_gl_dist_all gldf,
1170: ar_payment_schedules_all psch
1171: WHERE gt.event_type_code IN ('CM_CREATE','CM_UPDATE' )
1172: AND gt.application_id = 222
1173: AND gt.event_id = app.event_id
1174: AND dist.receivable_application_id = app.receivable_application_id

Line 1374: ar_payment_schedules_all psch,

1370: ,'N' --MFAR_ADDITIONAL_ENTRY
1371: FROM ra_customer_trx_all trx,
1372: gl_sets_of_books sob,
1373: xla_events_gt gt,
1374: ar_payment_schedules_all psch,
1375: ra_cust_trx_line_gl_dist_all ctlgd
1376: WHERE gt.event_type_code IN ('INV_CREATE' , 'INV_UPDATE' ,
1377: 'CM_CREATE' , 'CM_UPDATE' ,
1378: 'DM_CREATE' , 'DM_UPDATE' ,

Line 2688: ar_payment_schedules_all psch,

2684: oe_system_parameters_all osp,
2685: ra_customer_trx_all trxt,
2686: ra_customer_trx_lines_all tlt,
2687: ra_cust_trx_line_gl_dist_all gldt,
2688: ar_payment_schedules_all psch,
2689: ar_cash_receipts_all cr
2690: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
2691: 'RECP_RATE_ADJUST' ) -- Uptake XLA reversal, 'RECP_REVERSE')
2692: -- Exclude 'RECP_REVERSE' for no extract at line level is reuired for Reversal

Line 2818: ar_payment_schedules_all psch

2814: oe_system_parameters_all osp,
2815: ra_customer_trx_all trxt,
2816: ra_customer_trx_lines_all tlt,
2817: ra_cust_trx_line_gl_dist_all gldt,
2818: ar_payment_schedules_all psch
2819: WHERE gt.event_type_code IN ( 'CM_CREATE','CM_UPDATE' )
2820: AND gt.application_id = p_application_id
2821: AND gt.event_id = app.event_id
2822: AND (app.upgrade_method IN ('R12_NLB','R12', 'R12_11IMFAR', 'R12_11ICASH','11I_R12_POST')

Line 3117: ar_payment_schedules_all psch,

3113: oe_system_parameters_all osp,
3114: ra_customer_trx_all trxt,
3115: ra_customer_trx_lines_all tlt,
3116: ra_cust_trx_line_gl_dist_all gldt,
3117: ar_payment_schedules_all psch,
3118: ar_system_parameters_all ars
3119: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE',
3120: 'RECP_RATE_ADJUST' ) --Uptake XLA Reversal, 'RECP_REVERSE')
3121: AND gt.application_id = p_application_id

Line 3221: ar_payment_schedules_all psch,

3217: oe_system_parameters_all osp,
3218: ra_customer_trx_all trxt,
3219: ra_customer_trx_lines_all tlt,
3220: ra_cust_trx_line_gl_dist_all gldt,
3221: ar_payment_schedules_all psch,
3222: ar_system_parameters_all ars
3223: WHERE gt.event_type_code IN ( 'CM_CREATE' ,'CM_UPDATE' )
3224: AND gt.application_id = p_application_id
3225: AND gt.event_id = app.event_id

Line 4977: ar_payment_schedules_all psch

4973: ra_cust_trx_line_gl_dist_all gld,
4974: oe_system_parameters_all osp,
4975: ar_distributions_all dist,
4976: gl_sets_of_books sob,
4977: ar_payment_schedules_all psch
4978: WHERE gt.event_type_code IN ('BILL_CREATE' ,
4979: 'BILL_UPDATE' ,
4980: 'BILL_REVERSE' )
4981: AND gt.application_id = p_application_id