APPS.ARP_XLA_EXTRACT_MAIN_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 959: ra_customer_trx_lines_all tlf,

955: ar_distributions_all dist,
956: gl_sets_of_books sob,
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

Line 1168: ra_customer_trx_lines_all tlf,

1164: ar_cash_basis_dists_all dist,
1165: gl_sets_of_books sob,
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

Line 2182: ra_customer_trx_lines_all li,

2178: ,'N' --MFAR_ADDITIONAL_ENTRY
2179: --}
2180: FROM xla_events_gt gt,
2181: ra_cust_trx_line_gl_dist_all gld,
2182: ra_customer_trx_lines_all li,
2183: ra_customer_trx_all hd,
2184: gl_sets_of_books sob,
2185: oe_system_parameters_all osp
2186: WHERE gt.event_type_code IN ('INV_CREATE' , 'INV_UPDATE' ,

Line 2399: ra_customer_trx_lines_all tlt,

2395: ar_distributions_all dist,
2396: ar_adjustments_all adj,
2397: gl_sets_of_books sob,
2398: ra_customer_trx_all trxt,
2399: ra_customer_trx_lines_all tlt,
2400: ra_cust_trx_line_gl_dist_all gldt,
2401: oe_system_parameters_all osp
2402: WHERE gt.event_type_code = 'ADJ_CREATE'
2403: AND gt.application_id = p_application_id

Line 2686: ra_customer_trx_lines_all tlt,

2682: ar_distributions_all dist,
2683: gl_sets_of_books sob,
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' ,

Line 2816: ra_customer_trx_lines_all tlt,

2812: ar_distributions_all dist,
2813: gl_sets_of_books sob,
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

Line 3115: ra_customer_trx_lines_all tlt,

3111: AR_CASH_BASIS_DISTS_ALL acb,
3112: gl_sets_of_books sob,
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',

Line 3219: ra_customer_trx_lines_all tlt,

3215: AR_CASH_BASIS_DISTS_ALL acb,
3216: gl_sets_of_books sob,
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' )

Line 4044: ,ra_customer_trx_lines_all ctl

4040: ,ar_receivable_applications_all ra
4041: ,ar_distributions_all ard
4042: ,ra_customer_trx_all ct
4043: ,ra_cust_trx_line_gl_dist_all ctlgd
4044: ,ra_customer_trx_lines_all ctl
4045: ,(SELECT entity_id,
4046: source_id_int_1
4047: FROM xla_events_gt
4048: WHERE application_id = 222

Line 4472: ra_customer_trx_lines_all ctl,

4468: ar_cash_receipt_history_all crh,
4469: ar_distributions_all ard,
4470: ra_customer_trx_all trx,
4471: ra_cust_trx_line_gl_dist_all ctlgd,
4472: ra_customer_trx_lines_all ctl,
4473: ar_cash_receipts_all cr,
4474: gl_ledgers lg,
4475: ar_cash_receipt_history_all crhlatest
4476: WHERE gt.application_id = 222

Line 4972: ra_customer_trx_lines_all tl,

4968: ,'N'
4969: FROM xla_events_gt gt,
4970: ar_transaction_history_all th,
4971: ra_customer_trx_all trx,
4972: ra_customer_trx_lines_all tl,
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,