APPS.ARP_XLA_EXTRACT_MAIN_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 1532: ra_customer_trx_lines_all tlf,

1528: ar_distributions_all dist,
1529: gl_sets_of_books sob,
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

Line 1745: ra_customer_trx_lines_all tlf,

1741: ar_cash_basis_dists_all dist,
1742: gl_sets_of_books sob,
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

Line 2851: ra_customer_trx_lines_all li,

2847: ,'N' --MFAR_ADDITIONAL_ENTRY
2848: --}
2849: FROM xla_events_gt gt,
2850: ra_cust_trx_line_gl_dist_all gld,
2851: ra_customer_trx_lines_all li,
2852: ra_customer_trx_all hd,
2853: gl_sets_of_books sob,
2854: oe_system_parameters_all osp
2855: WHERE gt.event_type_code IN ('INV_CREATE' , 'INV_UPDATE' ,

Line 3070: ra_customer_trx_lines_all tlt,

3066: ar_distributions_all dist,
3067: ar_adjustments_all adj,
3068: gl_sets_of_books sob,
3069: ra_customer_trx_all trxt,
3070: ra_customer_trx_lines_all tlt,
3071: ra_cust_trx_line_gl_dist_all gldt,
3072: oe_system_parameters_all osp
3073: WHERE gt.event_type_code = 'ADJ_CREATE'
3074: AND gt.application_id = p_application_id

Line 3365: ra_customer_trx_lines_all tlt,

3361: ar_distributions_all dist,
3362: gl_sets_of_books sob,
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' ,

Line 3501: ra_customer_trx_lines_all tlt,

3497: ar_distributions_all dist,
3498: gl_sets_of_books sob,
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

Line 3806: ra_customer_trx_lines_all tlt,

3802: AR_CASH_BASIS_DISTS_ALL acb,
3803: gl_sets_of_books sob,
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',

Line 3910: ra_customer_trx_lines_all tlt,

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

Line 5539: ,ra_customer_trx_lines_all ctl

5535: ,ct.ship_to_site_use_id --ship_to_site_use_id
5536: FROM ar_receivable_applications_all ra
5537: ,ar_distributions_all ard
5538: ,ra_customer_trx_all ct
5539: ,ra_customer_trx_lines_all ctl
5540: ,(SELECT entity_id,
5541: source_id_int_1,
5542: event_id
5543: FROM xla_events_gt

Line 5922: ,ra_customer_trx_lines_all ctl

5918: ,ar_receivable_applications_all ra
5919: ,ar_distributions_all ard
5920: ,ra_customer_trx_all ct
5921: ,ra_cust_trx_line_gl_dist_all ctlgd
5922: ,ra_customer_trx_lines_all ctl
5923: ,(SELECT entity_id,
5924: source_id_int_1
5925: FROM xla_events_gt
5926: WHERE application_id = 222

Line 6482: ra_customer_trx_lines_all ctl,

6478: ar_cash_receipt_history_all crh,
6479: ar_distributions_all ard,
6480: ra_customer_trx_all trx,
6481: ra_cust_trx_line_gl_dist_all ctlgd,
6482: ra_customer_trx_lines_all ctl,
6483: ar_cash_receipts_all cr,
6484: gl_ledgers lg,
6485: ar_cash_receipt_history_all crhlatest,
6486: (SELECT source_id,

Line 6599: ra_customer_trx_lines_all ctl,

6595: ar_cash_receipt_history_all crh,
6596: ar_distributions_all ard,
6597: ra_customer_trx_all trx,
6598: ra_cust_trx_line_gl_dist_all ctlgd,
6599: ra_customer_trx_lines_all ctl,
6600: ar_cash_receipts_all cr,
6601: gl_ledgers lg,
6602: (SELECT source_id,
6603: MAX(line_id) max_line_id

Line 6712: ra_customer_trx_lines_all ctl,

6708: ar_cash_receipt_history_all crh,
6709: ar_distributions_all ard,
6710: ra_customer_trx_all trx,
6711: ra_cust_trx_line_gl_dist_all ctlgd,
6712: ra_customer_trx_lines_all ctl,
6713: ar_cash_receipts_all cr,
6714: gl_ledgers lg,
6715: ar_cash_receipt_history_all crhlatest,
6716: (SELECT source_id,

Line 6832: ra_customer_trx_lines_all ctl,

6828: ar_cash_receipt_history_all crh,
6829: ar_distributions_all ard,
6830: ra_customer_trx_all trx,
6831: ra_cust_trx_line_gl_dist_all ctlgd,
6832: ra_customer_trx_lines_all ctl,
6833: ar_cash_receipts_all cr,
6834: gl_ledgers lg,
6835: ar_crh_gt crhgt,
6836: (SELECT source_id,

Line 7116: ra_customer_trx_lines_all tlt,

7112: ar_distributions_all dist,
7113: gl_sets_of_books sob,
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

Line 7624: ra_customer_trx_lines_all tl,

7620: ,'N'
7621: FROM xla_events_gt gt,
7622: ar_transaction_history_all th,
7623: ra_customer_trx_all trx,
7624: ra_customer_trx_lines_all tl,
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,