APPS.ARP_XLA_EXTRACT_MAIN_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 1534: ar_payment_schedules_all psch

1530: oe_system_parameters_all osp,
1531: ra_customer_trx_all trxf,
1532: ra_customer_trx_lines_all tlf,
1533: ra_cust_trx_line_gl_dist_all gldf,
1534: ar_payment_schedules_all psch
1535: WHERE gt.event_type_code IN ('CM_CREATE','CM_UPDATE' ) --BUG#3419926
1536: AND gt.application_id = p_application_id
1537: AND gt.event_id = app.event_id
1538: AND dist.source_table = 'RA'

Line 1747: ar_payment_schedules_all psch

1743: oe_system_parameters_all osp,
1744: ra_customer_trx_all trxf,
1745: ra_customer_trx_lines_all tlf,
1746: ra_cust_trx_line_gl_dist_all gldf,
1747: ar_payment_schedules_all psch
1748: WHERE gt.event_type_code IN ('CM_CREATE','CM_UPDATE' )
1749: AND gt.application_id = 222
1750: AND gt.event_id = app.event_id
1751: AND dist.receivable_application_id = app.receivable_application_id

Line 1951: ar_payment_schedules_all psch,

1947: ,'N' --MFAR_ADDITIONAL_ENTRY
1948: FROM ra_customer_trx_all trx,
1949: gl_sets_of_books sob,
1950: xla_events_gt gt,
1951: ar_payment_schedules_all psch,
1952: ra_cust_trx_line_gl_dist_all ctlgd
1953: WHERE gt.event_type_code IN ('INV_CREATE' , 'INV_UPDATE' ,
1954: 'CM_CREATE' , 'CM_UPDATE' ,
1955: 'DM_CREATE' , 'DM_UPDATE' ,

Line 3367: ar_payment_schedules_all psch,

3363: oe_system_parameters_all osp,
3364: ra_customer_trx_all trxt,
3365: ra_customer_trx_lines_all tlt,
3366: ra_cust_trx_line_gl_dist_all gldt,
3367: ar_payment_schedules_all psch,
3368: ar_cash_receipts_all cr
3369: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
3370: 'RECP_RATE_ADJUST' ) -- Uptake XLA reversal, 'RECP_REVERSE')
3371: -- Exclude 'RECP_REVERSE' for no extract at line level is reuired for Reversal

Line 3503: ar_payment_schedules_all psch

3499: oe_system_parameters_all osp,
3500: ra_customer_trx_all trxt,
3501: ra_customer_trx_lines_all tlt,
3502: ra_cust_trx_line_gl_dist_all gldt,
3503: ar_payment_schedules_all psch
3504: WHERE gt.event_type_code IN ( 'CM_CREATE','CM_UPDATE' )
3505: AND gt.application_id = p_application_id
3506: AND gt.event_id = app.event_id
3507: AND (app.upgrade_method IN ('R12_NLB','R12', 'R12_11IMFAR', 'R12_11ICASH','11I_R12_POST','R12_MERGE')

Line 3808: ar_payment_schedules_all psch,

3804: oe_system_parameters_all osp,
3805: ra_customer_trx_all trxt,
3806: ra_customer_trx_lines_all tlt,
3807: ra_cust_trx_line_gl_dist_all gldt,
3808: ar_payment_schedules_all psch,
3809: ar_system_parameters_all ars
3810: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE',
3811: 'RECP_RATE_ADJUST' ) --Uptake XLA Reversal, 'RECP_REVERSE')
3812: AND gt.application_id = p_application_id

Line 3912: ar_payment_schedules_all psch,

3908: oe_system_parameters_all osp,
3909: ra_customer_trx_all trxt,
3910: ra_customer_trx_lines_all tlt,
3911: ra_cust_trx_line_gl_dist_all gldt,
3912: ar_payment_schedules_all psch,
3913: ar_system_parameters_all ars
3914: WHERE gt.event_type_code IN ( 'CM_CREATE' ,'CM_UPDATE' )
3915: AND gt.application_id = p_application_id
3916: AND gt.event_id = app.event_id

Line 7118: ar_payment_schedules_all psch,

7114: oe_system_parameters_all osp,
7115: ra_customer_trx_all trxt,
7116: ra_customer_trx_lines_all tlt,
7117: ra_cust_trx_line_gl_dist_all gldt,
7118: ar_payment_schedules_all psch,
7119: ar_cash_receipts_all cr,
7120: ar_distributions_all currard
7121: WHERE gt.event_type_code IN ('RECP_CREATE' ,'RECP_UPDATE', 'RECP_RATE_ADJUST' )
7122: AND gt.application_id = 222

Line 7629: ar_payment_schedules_all psch

7625: ra_cust_trx_line_gl_dist_all gld,
7626: oe_system_parameters_all osp,
7627: ar_distributions_all dist,
7628: gl_sets_of_books sob,
7629: ar_payment_schedules_all psch
7630: WHERE gt.event_type_code IN ('BILL_CREATE' ,
7631: 'BILL_UPDATE' ,
7632: 'BILL_REVERSE' )
7633: AND gt.application_id = p_application_id