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 549: FROM xla_events_gt eve,

545: 'UNEDISC','UNED_LINE',
546: 'REC' ,'APP_LINE' , NULL),
547: NVL(dist.AMOUNT_CR,0)-NVL(dist.AMOUNT_DR,0),
548: NVL(dist.ACCTD_AMOUNT_CR,0)-NVL(dist.ACCTD_AMOUNT_DR,0)
549: FROM xla_events_gt eve,
550: ar_receivable_applications_all app,
551: ar_distributions_all dist,
552: gl_ledgers sob
553: WHERE eve.application_id = 222

Line 798: FROM xla_events_gt gt,

794: ,gt.event_class_code
795: ,gt.entity_code
796: ,'N' --MFAR_ADDITIONAL_ENTRY
797: ,nvl(dist.ref_mf_dist_flag,'N') --REF_MF_DIST_FLAG
798: FROM xla_events_gt gt,
799: ar_receivable_applications_all app,
800: ar_distributions_all dist,
801: gl_sets_of_books sob,
802: oe_system_parameters_all osp,

Line 1102: FROM xla_events_gt gt,

1098: gt.event_type_code
1099: ,gt.event_class_code
1100: ,gt.entity_code
1101: ,'N' --MFAR_ADDITIONAL_ENTRY
1102: FROM xla_events_gt gt,
1103: ar_receivable_applications_all app,
1104: ar_distributions_all dist,
1105: gl_sets_of_books sob,
1106: oe_system_parameters_all osp,

Line 1297: FROM xla_events_gt gt,

1293: ,gt.event_class_code
1294: ,gt.entity_code
1295: ,app.upgrade_method
1296: ,'N' --MFAR_ADDITIONAL_ENTRY
1297: FROM xla_events_gt gt,
1298: ar_receivable_applications_all app,
1299: ar_cash_basis_dists_all dist,
1300: gl_sets_of_books sob,
1301: oe_system_parameters_all osp,

Line 1526: FROM xla_events_gt gt,

1522: ,'N' --MFAR_ADDITIONAL_ENTRY
1523: , dist.source_type
1524: , dist.REF_PREV_CUST_TRX_LINE_ID -- 9860123
1525: , the_segment_value(sob.chart_of_accounts_id, 'GL_BALANCING', dist.ref_dist_ccid)
1526: FROM xla_events_gt gt,
1527: ar_receivable_applications_all app,
1528: ar_distributions_all dist,
1529: gl_sets_of_books sob,
1530: oe_system_parameters_all osp,

Line 1739: FROM xla_events_gt gt,

1735: ,gt.entity_code
1736: ,tlf.tax_line_id --tax_line_id
1737: ,app.upgrade_method
1738: ,'N' --MFAR_ADDITIONAL_ENTRY
1739: FROM xla_events_gt gt,
1740: ar_receivable_applications_all app,
1741: ar_cash_basis_dists_all dist,
1742: gl_sets_of_books sob,
1743: oe_system_parameters_all osp,

Line 1950: xla_events_gt gt,

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

Line 2158: xla_events_gt gt,

2154: ,gt.entity_code
2155: ,'N' --MFAR_ADDITIONAL_ENTRY
2156: FROM ar_adjustments_all adj,
2157: gl_sets_of_books sob,
2158: xla_events_gt gt,
2159: ra_customer_trx_all trxf,
2160: ra_cust_trx_line_gl_dist_all ctlgd
2161: WHERE gt.event_type_code = 'ADJ_CREATE'
2162: AND gt.application_id = p_application_id

Line 2243: xla_events_gt gt,

2239: ,gt.entity_code
2240: ,'N' --MFAR_ADDITIONAL_ENTRY
2241: FROM ar_adjustments_all adj,
2242: gl_sets_of_books sob,
2243: xla_events_gt gt,
2244: ra_customer_trx_all trxf,
2245: ar_transaction_history_all trh,
2246: ar_distributions_all ard
2247: WHERE gt.event_type_code = 'ADJ_CREATE'

Line 2447: FROM xla_events_gt gt,

2443: --}
2444: ,DECODE(gt.event_type_code,'RECP_REVERSE','Y',
2445: 'MISC_RECP_REVERSE','Y','N') --reversal_code
2446: ,'N' --MFAR_ADDITIONAL_ENTRY
2447: FROM xla_events_gt gt,
2448: gl_sets_of_books sob,
2449: ar_cash_receipts_all cr
2450: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
2451: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,--Header level view reversal stay

Line 2632: FROM xla_events_gt gt,

2628: ,gt.event_class_code
2629: ,gt.entity_code
2630: ,'N' --MFAR_ADDITIONAL_ENTRY
2631: --}
2632: FROM xla_events_gt gt,
2633: ra_customer_trx_all trx,
2634: gl_sets_of_books sob
2635: WHERE gt.event_type_code IN ('BILL_CREATE' ,'BILL_UPDATE' ,'BILL_REVERSE')
2636: AND gt.application_id = p_application_id

Line 2849: FROM xla_events_gt gt,

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

Line 3065: FROM xla_events_gt gt,

3061: ,tlt.tax_line_id --tax_line_id
3062: ,'N' --MFAR_ADDITIONAL_ENTRY
3063: ,decode(trxt.upgrade_method,'R12_11ICASH','N','')
3064: --}
3065: FROM xla_events_gt gt,
3066: ar_distributions_all dist,
3067: ar_adjustments_all adj,
3068: gl_sets_of_books sob,
3069: ra_customer_trx_all trxt,

Line 3359: FROM xla_events_gt gt,

3355: , NULL
3356: , to_number(NULL)
3357: , NULL
3358: ,decode(trxt.upgrade_method,'R12_11ICASH','N','')
3359: FROM xla_events_gt gt,
3360: ar_receivable_applications_all app,
3361: ar_distributions_all dist,
3362: gl_sets_of_books sob,
3363: oe_system_parameters_all osp,

Line 3495: FROM xla_events_gt gt,

3491: , dist.source_type
3492: ,decode(dist.REF_PREV_CUST_TRX_LINE_ID, NULL, to_number(NULL),dist.ref_customer_trx_line_id) -- 9860123
3493: ,the_segment_value(sob.chart_of_accounts_id, 'GL_BALANCING', dist.ref_dist_ccid)
3494: ,decode(trxt.upgrade_method,'R12_11ICASH','N','')
3495: FROM xla_events_gt gt,
3496: ar_receivable_applications_all app,
3497: ar_distributions_all dist,
3498: gl_sets_of_books sob,
3499: oe_system_parameters_all osp,

Line 3627: FROM xla_events_gt gt,

3623: , dist.source_type
3624: , to_number(NULL)
3625: , NULL
3626: , NULL
3627: FROM xla_events_gt gt,
3628: ar_receivable_applications_all app,
3629: ar_distributions_all dist,
3630: gl_sets_of_books sob,
3631: ra_customer_trx_all trx

Line 3800: FROM xla_events_gt gt,

3796: ,gt.entity_code
3797: ,tlt.tax_line_id --tax_line_id
3798: ,app.upgrade_method
3799: ,'N' --MFAR_ADDITIONAL_ENTRY
3800: FROM xla_events_gt gt,
3801: ar_receivable_applications_all app,
3802: AR_CASH_BASIS_DISTS_ALL acb,
3803: gl_sets_of_books sob,
3804: oe_system_parameters_all osp,

Line 3904: FROM xla_events_gt gt,

3900: ,gt.entity_code
3901: ,tlt.tax_line_id -- tax_line_id
3902: ,app.upgrade_method
3903: ,'N' --MFAR_ADDITIONAL_ENTRY
3904: FROM xla_events_gt gt,
3905: ar_receivable_applications_all app,
3906: AR_CASH_BASIS_DISTS_ALL acb,
3907: gl_sets_of_books sob,
3908: oe_system_parameters_all osp,

Line 4123: FROM xla_events_gt gt,

4119: ,gt.event_class_code
4120: ,gt.entity_code
4121: --}
4122: ,'N' --MFAR_ADDITIONAL_ENTRY
4123: FROM xla_events_gt gt,
4124: ar_receivable_applications_all app,
4125: ar_distributions_all dist, --ar_distributions_all dist,
4126: gl_sets_of_books sob
4127: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,

Line 4331: FROM xla_events_gt gt,

4327: ,gt.event_class_code
4328: ,gt.entity_code
4329: ,'N' --MFAR_ADDITIONAL_ENTRY
4330: --}
4331: FROM xla_events_gt gt,
4332: ar_cash_receipts_all cr,
4333: ar_cash_receipt_history_all crh,
4334: ar_distributions_all dist,
4335: gl_sets_of_books sob,

Line 4530: FROM xla_events_gt gt,

4526: --}
4527: --Bug7255483 Added value for new column in the view
4528: ,DECODE(NVL(app.receivables_trx_id,0), -16,
4529: NVL(dist.from_acctd_amount_cr,0) - NVL(dist.from_acctd_amount_dr,0),to_number(NULL))
4530: FROM xla_events_gt gt,
4531: ar_cash_receipts_all cr,
4532: ar_cash_receipt_history_all crh,
4533: ar_receivable_applications_all app,
4534: ar_distributions_all dist,

Line 5471: FROM xla_events_gt

5467: ,(SELECT entity_id,
5468: source_id_int_1,
5469: event_id,
5470: ledger_id
5471: FROM xla_events_gt
5472: WHERE application_id = 222
5473: AND event_type_code IN ('CM_CREATE','CM_UPDATE')
5474: GROUP BY entity_id,
5475: source_id_int_1,

Line 5543: FROM xla_events_gt

5539: ,ra_customer_trx_lines_all ctl
5540: ,(SELECT entity_id,
5541: source_id_int_1,
5542: event_id
5543: FROM xla_events_gt
5544: WHERE application_id = 222
5545: AND event_type_code IN ('CM_CREATE','CM_UPDATE')
5546: GROUP BY entity_id,
5547: source_id_int_1,

Line 5925: FROM xla_events_gt

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
5927: AND event_type_code IN ('RECP_CREATE','RECP_UPDATE','RECP_RATE_ADJUST')
5928: GROUP BY entity_id,
5929: source_id_int_1) xla

Line 6039: FROM xla_events_gt gt,

6035: 'REMITTANCE','REMITTED',
6036: 'CONFIRMATION','CONFIRMED',
6037: 'BANK_CHARGES','CLEARED'
6038: ,'CASH'), 'ACTUAL','REVERSAL') DIST_LINE_STATUS
6039: FROM xla_events_gt gt,
6040: ar_cash_receipt_history_all crh,
6041: ar_cash_receipts_all cr,
6042: ar_distributions_all ard,
6043: gl_ledgers lg

Line 6105: FROM xla_events_gt gt,

6101: , 'REV_DIST', (paircrh.amount+ nvl(paircrh.factor_discount_amount,0))) recp_amount
6102: ,decode(state.status, 'ORG_DIST',(crh.acctd_amount+ nvl(crh.acctd_factor_discount_amount,0))
6103: , 'REV_DIST',(paircrh.acctd_amount+ nvl(paircrh.acctd_factor_discount_amount,0))) recp_acctd_amount
6104: , decode(state.status, 'ORG_DIST','ACTUAL','REVERSAL') DIST_LINE_STATUS
6105: FROM xla_events_gt gt,
6106: ar_cash_receipt_history_all crh,
6107: ar_cash_receipts_all cr,
6108: ar_distributions_all ard,
6109: ar_cash_receipt_history_all paircrh,

Line 6170: FROM xla_events_gt gt,

6166: , 'REV_DIST', (paircrh.amount+ nvl(paircrh.factor_discount_amount,0))) recp_amount
6167: ,decode(state.status, 'ORG_DIST',(crh.acctd_amount+ nvl(crh.acctd_factor_discount_amount,0))
6168: , 'REV_DIST',(paircrh.acctd_amount+ nvl(paircrh.acctd_factor_discount_amount,0))) recp_acctd_amount
6169: , decode(state.status, 'ORG_DIST','ACTUAL','REVERSAL') DIST_LINE_STATUS
6170: FROM xla_events_gt gt,
6171: ar_cash_receipt_history_all crh,
6172: ar_cash_receipts_all cr,
6173: ar_distributions_all ard,
6174: ar_cash_receipt_history_all paircrh,

Line 6315: xla_events_gt gt,

6311: ,decode(crh.dist_line_status, 'REVERSAL', -1*app_max_line.max_line_id, app_max_line.max_line_id)
6312: ,app.mfar_upg_trx
6313: FROM ar_crh_gt crh,
6314: ar_crh_app_gt app,
6315: xla_events_gt gt,
6316: (SELECT app1.receivable_application_id receivable_application_id,
6317: MAX(app1.line_id) max_line_id
6318: FROM ar_crh_app_gt app1
6319: GROUP BY app1.receivable_application_id) app_max_line

Line 6476: FROM xla_events_gt gt,

6472: ,decode(crhlatest.acctd_amount+ nvl(crhlatest.acctd_factor_discount_amount,0),0,0,
6473: ar_unposted_item_util.currRound((abs(crhlatest.acctd_amount)/abs(crhlatest.acctd_amount+ nvl(crhlatest.acctd_factor_discount_amount,0)))*ra.acctd_amount_applied_from,cr.currency_code)) ALLOC_ACCTD_AMOUNT
6474: ,ext.max_line_id MAX_LINE_ID
6475: ,decode(trx.upgrade_method,'R12_11ICASH','N','') mfar_upg_trx
6476: FROM xla_events_gt gt,
6477: ar_receivable_applications_all ra,
6478: ar_cash_receipt_history_all crh,
6479: ar_distributions_all ard,
6480: ra_customer_trx_all trx,

Line 6593: FROM xla_events_gt gt,

6589: ,decode(crh.acctd_amount+ nvl(crh.acctd_factor_discount_amount,0),0,0,
6590: ar_unposted_item_util.currRound((abs(crh.acctd_amount)/abs(crh.acctd_amount+ nvl(crh.acctd_factor_discount_amount,0)))*ra.acctd_amount_applied_from,cr.currency_code)) ALLOC_ACCTD_AMOUNT
6591: ,ext.max_line_id MAX_LINE_ID
6592: ,decode(trx.upgrade_method,'R12_11ICASH','N','') mfar_upg_trx
6593: FROM xla_events_gt gt,
6594: ar_receivable_applications_all ra,
6595: ar_cash_receipt_history_all crh,
6596: ar_distributions_all ard,
6597: ra_customer_trx_all trx,

Line 6706: FROM xla_events_gt gt,

6702: ,decode(crhlatest.acctd_amount+ nvl(crhlatest.acctd_factor_discount_amount,0),0,0,
6703: ar_unposted_item_util.currRound(ra.acctd_amount_applied_from-((abs(crhlatest.acctd_amount)/abs(crhlatest.acctd_amount+ nvl(crhlatest.acctd_factor_discount_amount,0)))*ra.acctd_amount_applied_from),cr.currency_code)) ALLOC_ACCTD_AMOUNT
6704: ,ext.max_line_id MAX_LINE_ID
6705: ,decode(trx.upgrade_method,'R12_11ICASH','N','') mfar_upg_trx
6706: FROM xla_events_gt gt,
6707: ar_receivable_applications_all ra,
6708: ar_cash_receipt_history_all crh,
6709: ar_distributions_all ard,
6710: ra_customer_trx_all trx,

Line 6826: FROM xla_events_gt gt,

6822: ,decode(crh.acctd_amount+ nvl(crh.acctd_factor_discount_amount,0),0,0,
6823: ar_unposted_item_util.currRound(ra.acctd_amount_applied_from-((abs(crh.acctd_amount)/abs(crh.acctd_amount+ nvl(crh.acctd_factor_discount_amount,0)))*ra.acctd_amount_applied_from),cr.currency_code)) ALLOC_ACCTD_AMOUNT
6824: ,ext.max_line_id MAX_LINE_ID
6825: ,decode(trx.upgrade_method,'R12_11ICASH','N','') mfar_upg_trx
6826: FROM xla_events_gt gt,
6827: ar_receivable_applications_all ra,
6828: ar_cash_receipt_history_all crh,
6829: ar_distributions_all ard,
6830: ra_customer_trx_all trx,

Line 7110: FROM xla_events_gt gt,

7106: ,'Y' --MFAR_ADDITIONAL_ENTRY
7107: , 'CURR_ROUND'
7108: , currard.code_combination_id
7109: , dist.ref_dist_ccid
7110: FROM xla_events_gt gt,
7111: ar_receivable_applications_all app,
7112: ar_distributions_all dist,
7113: gl_sets_of_books sob,
7114: oe_system_parameters_all osp,

Line 7262: FROM xla_events_gt

7258: ,ar_cash_receipt_history_all crh
7259: ,ar_distributions_all ard
7260: ,(SELECT entity_id,
7261: source_id_int_1
7262: FROM xla_events_gt
7263: WHERE application_id = 222
7264: AND event_type_code IN ('MISC_RECP_CREATE','MISC_RECP_UPDATE')
7265: GROUP BY entity_id,
7266: source_id_int_1) xla

Line 7414: xla_events_gt gt

7410: ,gt.event_class_code --EVENT_CLASS_CODE
7411: ,gt.entity_code --ENTITY_CODE
7412: FROM ar_crh_gt crh,
7413: ar_crh_app_gt mcd,
7414: xla_events_gt gt
7415: WHERE crh.entity_id = mcd.entity_id
7416: AND mcd.source_table = 'MCD'
7417: AND crh.event_id = gt.event_id;
7418: local_log(procedure_name => 'mfar_produit_mcd_by_crh',

Line 7621: FROM xla_events_gt gt,

7617: ,gt.entity_code
7618: --BUG#4645389
7619: ,tl.tax_line_id --tax_line_id
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,

Line 7828: FROM xla_events_gt gt,

7824: NVL(dist.from_acctd_amount_cr,0)
7825: -NVL(dist.from_acctd_amount_dr,0) -- AMOUNT
7826: ,DECODE(gt.event_type_code,'MISC_RECP_REVERSE' ,'Y','N') --reversal_code
7827: ,'N'
7828: FROM xla_events_gt gt,
7829: ar_misc_cash_distributions_all mcd,
7830: ar_distributions_all dist,
7831: gl_sets_of_books sob,
7832: ar_cash_receipts_all cr,

Line 7875: | on xla events passed by XLA_EVENTS_GT |

7871: | D for Draft |
7872: | F for final |
7873: | |
7874: | Purpose : Extract the AR accounting lines based |
7875: | on xla events passed by XLA_EVENTS_GT |
7876: | This routine is launched by XLA accounting |
7877: | program in extract phase |
7878: | |
7879: | Modification history |

Line 9224: FROM xla_events_gt

9220:
9221:
9222: CURSOR c2 IS
9223: SELECT *
9224: FROM xla_events_gt
9225: WHERE application_id = 222;
9226: l c2%ROWTYPE;
9227:
9228:

Line 9330: FROM xla_events_gt

9326: SECURITY_ID_CHAR_3 ,
9327: ON_HOLD_FLAG ,
9328: TRANSACTION_DATE ,
9329: BUDGETARY_CONTROL_FLAG
9330: FROM xla_events_gt
9331: WHERE application_id = 222;
9332: --
9333: INSERT INTO ar_xla_lines_extract_tmp
9334: ( EVENT_ID ,

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

9549: ,third_party_type
9550: ,source_type
9551: FROM ar_xla_lines_extract;
9552: */
9553: local_log('diag_data','+--------BEGIN READING XLA_EVENTS_GT--------------+');
9554: OPEN c2;
9555: LOOP
9556: FETCH c2 INTO l;
9557: EXIT WHEN c2%NOTFOUND;

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

9603: local_log('diag_data',''||l.REFERENCE_DATE_2||'');
9604: local_log('diag_data',''||l.REFERENCE_DATE_3||'');
9605: END LOOP;
9606: CLOSE c2;
9607: local_log('diag_data','+--------END READING XLA_EVENTS_GT----------------+');
9608:
9609:
9610: local_log('diag_data','+--------BEGIN READING AR_XLA_LINES_EXTRACT-------+');
9611: cpt := 0;