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 XLA_EVENTS_GT

Line 209: FROM xla_events_gt eve,

205: 'UNEDISC','UNED_LINE',
206: 'REC' ,'APP_LINE' , NULL),
207: NVL(dist.AMOUNT_CR,0)-NVL(dist.AMOUNT_DR,0),
208: NVL(dist.ACCTD_AMOUNT_CR,0)-NVL(dist.ACCTD_AMOUNT_DR,0)
209: FROM xla_events_gt eve,
210: ar_receivable_applications_all app,
211: ar_distributions_all dist,
212: gl_ledgers sob
213: WHERE eve.application_id = 222

Line 537: FROM xla_events_gt gt,

533: gt.event_type_code
534: ,gt.event_class_code
535: ,gt.entity_code
536: ,'N' --MFAR_ADDITIONAL_ENTRY
537: FROM xla_events_gt gt,
538: ar_receivable_applications_all app,
539: ar_distributions_all dist,
540: gl_sets_of_books sob,
541: oe_system_parameters_all osp,

Line 731: FROM xla_events_gt gt,

727: ,gt.event_class_code
728: ,gt.entity_code
729: ,app.upgrade_method
730: ,'N' --MFAR_ADDITIONAL_ENTRY
731: FROM xla_events_gt gt,
732: ar_receivable_applications_all app,
733: ar_cash_basis_dists_all dist,
734: gl_sets_of_books sob,
735: oe_system_parameters_all osp,

Line 953: FROM xla_events_gt gt,

949: gt.entity_code,
950: tlf.tax_line_id, --tax_line_id
951: app.upgrade_method
952: ,'N' --MFAR_ADDITIONAL_ENTRY
953: FROM xla_events_gt gt,
954: ar_receivable_applications_all app,
955: ar_distributions_all dist,
956: gl_sets_of_books sob,
957: oe_system_parameters_all osp,

Line 1162: FROM xla_events_gt gt,

1158: ,gt.entity_code
1159: ,tlf.tax_line_id --tax_line_id
1160: ,app.upgrade_method
1161: ,'N' --MFAR_ADDITIONAL_ENTRY
1162: FROM xla_events_gt gt,
1163: ar_receivable_applications_all app,
1164: ar_cash_basis_dists_all dist,
1165: gl_sets_of_books sob,
1166: oe_system_parameters_all osp,

Line 1373: xla_events_gt gt,

1369: ,gt.entity_code
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' ,

Line 1580: xla_events_gt gt,

1576: ,gt.entity_code
1577: ,'N' --MFAR_ADDITIONAL_ENTRY
1578: FROM ar_adjustments_all adj,
1579: gl_sets_of_books sob,
1580: xla_events_gt gt,
1581: ra_customer_trx_all trxf,
1582: ra_cust_trx_line_gl_dist_all ctlgd
1583: WHERE gt.event_type_code = 'ADJ_CREATE'
1584: AND gt.application_id = p_application_id

Line 1778: FROM xla_events_gt gt,

1774: --}
1775: ,DECODE(gt.event_type_code,'RECP_REVERSE','Y',
1776: 'MISC_RECP_REVERSE','Y','N') --reversal_code
1777: ,'N' --MFAR_ADDITIONAL_ENTRY
1778: FROM xla_events_gt gt,
1779: gl_sets_of_books sob,
1780: ar_cash_receipts_all cr
1781: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
1782: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,--Header level view reversal stay

Line 1963: FROM xla_events_gt gt,

1959: ,gt.event_class_code
1960: ,gt.entity_code
1961: ,'N' --MFAR_ADDITIONAL_ENTRY
1962: --}
1963: FROM xla_events_gt gt,
1964: ra_customer_trx_all trx,
1965: gl_sets_of_books sob
1966: WHERE gt.event_type_code IN ('BILL_CREATE' ,'BILL_UPDATE' ,'BILL_REVERSE')
1967: AND gt.application_id = p_application_id

Line 2180: FROM xla_events_gt gt,

2176: --BUG#4645389
2177: ,li.tax_line_id --tax_line_id
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,

Line 2394: FROM xla_events_gt gt,

2390: --BUG#4645389
2391: ,tlt.tax_line_id --tax_line_id
2392: ,'N' --MFAR_ADDITIONAL_ENTRY
2393: --}
2394: FROM xla_events_gt gt,
2395: ar_distributions_all dist,
2396: ar_adjustments_all adj,
2397: gl_sets_of_books sob,
2398: ra_customer_trx_all trxt,

Line 2680: FROM xla_events_gt gt,

2676: ,tlt.tax_line_id --tax_line_id
2677: --BUG5366837
2678: ,app.upgrade_method
2679: ,'N' --MFAR_ADDITIONAL_ENTRY
2680: FROM xla_events_gt gt,
2681: ar_receivable_applications_all app,
2682: ar_distributions_all dist,
2683: gl_sets_of_books sob,
2684: oe_system_parameters_all osp,

Line 2810: FROM xla_events_gt gt,

2806: ,tlt.tax_line_id --tax_line_id
2807: --BUG#5366837
2808: ,app.upgrade_method
2809: ,'N' --MFAR_ADDITIONAL_ENTRY
2810: FROM xla_events_gt gt,
2811: ar_receivable_applications_all app,
2812: ar_distributions_all dist,
2813: gl_sets_of_books sob,
2814: oe_system_parameters_all osp,

Line 2936: FROM xla_events_gt gt,

2932: ,NULL --tax_line_id
2933: --BUG#5366837
2934: ,app.upgrade_method
2935: ,'N' --MFAR_ADDITIONAL_ENTRY
2936: FROM xla_events_gt gt,
2937: ar_receivable_applications_all app,
2938: ar_distributions_all dist,
2939: gl_sets_of_books sob,
2940: ra_customer_trx_all trx

Line 3109: FROM xla_events_gt gt,

3105: ,gt.entity_code
3106: ,tlt.tax_line_id --tax_line_id
3107: ,app.upgrade_method
3108: ,'N' --MFAR_ADDITIONAL_ENTRY
3109: FROM xla_events_gt gt,
3110: ar_receivable_applications_all app,
3111: AR_CASH_BASIS_DISTS_ALL acb,
3112: gl_sets_of_books sob,
3113: oe_system_parameters_all osp,

Line 3213: FROM xla_events_gt gt,

3209: ,gt.entity_code
3210: ,tlt.tax_line_id -- tax_line_id
3211: ,app.upgrade_method
3212: ,'N' --MFAR_ADDITIONAL_ENTRY
3213: FROM xla_events_gt gt,
3214: ar_receivable_applications_all app,
3215: AR_CASH_BASIS_DISTS_ALL acb,
3216: gl_sets_of_books sob,
3217: oe_system_parameters_all osp,

Line 3432: FROM xla_events_gt gt,

3428: ,gt.event_class_code
3429: ,gt.entity_code
3430: --}
3431: ,'N' --MFAR_ADDITIONAL_ENTRY
3432: FROM xla_events_gt gt,
3433: ar_receivable_applications_all app,
3434: ar_distributions_all dist, --ar_distributions_all dist,
3435: gl_sets_of_books sob
3436: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,

Line 3637: FROM xla_events_gt gt,

3633: ,gt.event_class_code
3634: ,gt.entity_code
3635: ,'N' --MFAR_ADDITIONAL_ENTRY
3636: --}
3637: FROM xla_events_gt gt,
3638: ar_cash_receipts_all cr,
3639: ar_cash_receipt_history_all crh,
3640: ar_distributions_all dist,
3641: gl_sets_of_books sob,

Line 3836: FROM xla_events_gt gt,

3832: --}
3833: --Bug7255483 Added value for new column in the view
3834: ,DECODE(NVL(app.receivables_trx_id,0), -16,
3835: NVL(dist.from_acctd_amount_cr,0) - NVL(dist.from_acctd_amount_dr,0),to_number(NULL))
3836: FROM xla_events_gt gt,
3837: ar_cash_receipts_all cr,
3838: ar_cash_receipt_history_all crh,
3839: ar_receivable_applications_all app,
3840: ar_distributions_all dist,

Line 4047: FROM xla_events_gt

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
4049: AND event_type_code IN ('RECP_CREATE','RECP_UPDATE')
4050: GROUP BY entity_id,
4051: source_id_int_1) xla

Line 4132: FROM xla_events_gt gt,

4128: ,crh.org_id
4129: ,DECODE(ard.source_type,'CASH' ,'CLEARED',
4130: 'REMITTANCE' ,'REMITTED',
4131: 'CONFIRMATION','CONFIRMED','CASH')
4132: FROM xla_events_gt gt,
4133: ar_cash_receipt_history_all crh,
4134: ar_cash_receipts_all cr,
4135: ar_distributions_all ard,
4136: gl_ledgers lg

Line 4301: xla_events_gt gt

4297: ar_crh_app_gt app,
4298: (SELECT 'CLEARED' AS status FROM DUAL UNION
4299: SELECT 'REMITTED' AS status FROM DUAL UNION
4300: SELECT 'CONFIRMED' AS status FROM DUAL ) state,
4301: xla_events_gt gt
4302: WHERE crh.entity_id = app.entity_id
4303: AND app.source_table = 'RA'
4304: AND DECODE(state.status,'CLEARED' ,DECODE(crh.status,'CLEARED' ,'Y','N'),
4305: 'REMITTED' ,DECODE(crh.status,'REMITTED' ,'Y','N'),

Line 4466: FROM xla_events_gt gt,

4462: ,ard.third_party_id --third_party_id
4463: ,ard.third_party_sub_id --third_party_site_id
4464: ,DECODE(ard.third_party_id,NULL,NULL,'C') --third_party_type
4465: ,ard.source_type --source_type
4466: FROM xla_events_gt gt,
4467: ar_receivable_applications_all ra,
4468: ar_cash_receipt_history_all crh,
4469: ar_distributions_all ard,
4470: ra_customer_trx_all trx,

Line 4610: FROM xla_events_gt

4606: ,ar_cash_receipt_history_all crh
4607: ,ar_distributions_all ard
4608: ,(SELECT entity_id,
4609: source_id_int_1
4610: FROM xla_events_gt
4611: WHERE application_id = 222
4612: AND event_type_code IN ('MISC_RECP_CREATE','MISC_RECP_UPDATE')
4613: GROUP BY entity_id,
4614: source_id_int_1) xla

Line 4762: xla_events_gt gt

4758: ,gt.event_class_code --EVENT_CLASS_CODE
4759: ,gt.entity_code --ENTITY_CODE
4760: FROM ar_crh_gt crh,
4761: ar_crh_app_gt mcd,
4762: xla_events_gt gt
4763: WHERE crh.entity_id = mcd.entity_id
4764: AND mcd.source_table = 'MCD'
4765: AND crh.event_id = gt.event_id;
4766: local_log(procedure_name => 'mfar_produit_mcd_by_crh',

Line 4969: FROM xla_events_gt gt,

4965: ,gt.entity_code
4966: --BUG#4645389
4967: ,tl.tax_line_id --tax_line_id
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,

Line 5176: FROM xla_events_gt gt,

5172: NVL(dist.from_acctd_amount_cr,0)
5173: -NVL(dist.from_acctd_amount_dr,0) -- AMOUNT
5174: ,DECODE(gt.event_type_code,'MISC_RECP_REVERSE' ,'Y','N') --reversal_code
5175: ,'N'
5176: FROM xla_events_gt gt,
5177: ar_misc_cash_distributions_all mcd,
5178: ar_distributions_all dist,
5179: gl_sets_of_books sob,
5180: ar_cash_receipts_all cr,

Line 5223: | on xla events passed by XLA_EVENTS_GT |

5219: | D for Draft |
5220: | F for final |
5221: | |
5222: | Purpose : Extract the AR accounting lines based |
5223: | on xla events passed by XLA_EVENTS_GT |
5224: | This routine is launched by XLA accounting |
5225: | program in extract phase |
5226: | |
5227: | Modification history |

Line 6053: FROM xla_events_gt

6049:
6050:
6051: CURSOR c2 IS
6052: SELECT *
6053: FROM xla_events_gt
6054: WHERE application_id = 222;
6055: l c2%ROWTYPE;
6056:
6057:

Line 6159: FROM xla_events_gt

6155: SECURITY_ID_CHAR_3 ,
6156: ON_HOLD_FLAG ,
6157: TRANSACTION_DATE ,
6158: BUDGETARY_CONTROL_FLAG
6159: FROM xla_events_gt
6160: WHERE application_id = 222;
6161: --
6162: INSERT INTO ar_xla_lines_extract_tmp
6163: ( EVENT_ID ,

Line 6382: local_log('diag_data','+--------BEGIN READING XLA_EVENTS_GT--------------+');

6378: ,third_party_type
6379: ,source_type
6380: FROM ar_xla_lines_extract;
6381: */
6382: local_log('diag_data','+--------BEGIN READING XLA_EVENTS_GT--------------+');
6383: OPEN c2;
6384: LOOP
6385: FETCH c2 INTO l;
6386: EXIT WHEN c2%NOTFOUND;

Line 6436: local_log('diag_data','+--------END READING XLA_EVENTS_GT----------------+');

6432: local_log('diag_data',''||l.REFERENCE_DATE_2||'');
6433: local_log('diag_data',''||l.REFERENCE_DATE_3||'');
6434: END LOOP;
6435: CLOSE c2;
6436: local_log('diag_data','+--------END READING XLA_EVENTS_GT----------------+');
6437:
6438:
6439: local_log('diag_data','+--------BEGIN READING AR_XLA_LINES_EXTRACT-------+');
6440: cpt := 0;