[Home] [Help]
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,
803: ar_cash_receipts_all cr,
804: --BUG#5201086
805: ar_cash_receipt_history_all crh,
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,
1107: ar_cash_receipts_all cr,
1108: --BUG#5201086
1109: ar_cash_receipt_history_all crh,
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,
1302: ar_cash_receipts_all cr,
1303: ar_cash_receipt_history_all crh,
1304: ra_customer_trx_all trx
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,
1531: ra_customer_trx_all trxf,
1532: ra_customer_trx_lines_all tlf,
1533: ra_cust_trx_line_gl_dist_all gldf,
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,
1744: ra_customer_trx_all trxf,
1745: ra_customer_trx_lines_all tlf,
1746: ra_cust_trx_line_gl_dist_all gldf,
1945: ,gt.event_class_code
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' ,
2153: ,gt.event_class_code
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'
2238: ,gt.event_class_code
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
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
2452: 'MISC_RECP_CREATE' ,'MISC_RECP_UPDATE' ,
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
2637: AND gt.source_id_int_1 = trx.customer_trx_id
2638: AND trx.set_of_books_id = sob.set_of_books_id;
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' ,
2856: 'CM_CREATE' , 'CM_UPDATE' ,
2857: 'DM_CREATE' , 'DM_UPDATE' ,
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,
3070: ra_customer_trx_lines_all tlt,
3071: ra_cust_trx_line_gl_dist_all gldt,
3072: oe_system_parameters_all osp
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,
3364: ra_customer_trx_all trxt,
3365: ra_customer_trx_lines_all tlt,
3366: ra_cust_trx_line_gl_dist_all gldt,
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,
3500: ra_customer_trx_all trxt,
3501: ra_customer_trx_lines_all tlt,
3502: ra_cust_trx_line_gl_dist_all gldt,
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
3632: WHERE gt.event_type_code IN ( 'CM_CREATE','CM_UPDATE' )
3633: AND gt.application_id = p_application_id
3634: AND gt.event_id = app.event_id
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,
3805: ra_customer_trx_all trxt,
3806: ra_customer_trx_lines_all tlt,
3807: ra_cust_trx_line_gl_dist_all gldt,
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,
3909: ra_customer_trx_all trxt,
3910: ra_customer_trx_lines_all tlt,
3911: ra_cust_trx_line_gl_dist_all gldt,
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' ,
4128: 'RECP_RATE_ADJUST' ) --Uptake XLA reversal,'RECP_REVERSE')
4129: -- Exclude 'RECP_REVERSE' for no extract at line level is reuired for Reversal
4130: AND gt.application_id = p_application_id
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,
4336: ar_cash_receipt_history_all pcrh
4337: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
4338: 'MISC_RECP_CREATE' ,'MISC_RECP_UPDATE' ,
4339: --Uptake XLA Reversal 'RECP_REVERSE' ,'MISC_RECP_REVERSE' ,
4531: ar_cash_receipts_all cr,
4532: ar_cash_receipt_history_all crh,
4533: ar_receivable_applications_all app,
4534: ar_distributions_all dist,
4535: gl_sets_of_books sob
4536: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
4537: 'RECP_RATE_ADJUST' ) --Uptake XLA Reversal,'RECP_REVERSE' )
4538: AND gt.application_id = p_application_id
4539: AND cr.cash_receipt_id = gt.source_id_int_1
5474: GROUP BY entity_id,
5475: source_id_int_1,
5476: event_id,
5477: ledger_id) xla
5478: ,gl_sets_of_books sob
5479: ,ar_xla_lines_extract ext -- 10047351
5480: WHERE xla.source_id_int_1 = ra.customer_trx_id
5481: AND xla.event_id = ra.event_id
5482: AND ra.status = 'APP'
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,
7115: ra_customer_trx_all trxt,
7116: ra_customer_trx_lines_all tlt,
7117: ra_cust_trx_line_gl_dist_all gldt,
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,
7629: ar_payment_schedules_all psch
7630: WHERE gt.event_type_code IN ('BILL_CREATE' ,
7631: 'BILL_UPDATE' ,
7632: 'BILL_REVERSE' )
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,
7833: --5201086
7834: ar_cash_receipt_history_all crh
7835: WHERE gt.event_type_code IN ( 'MISC_RECP_CREATE','MISC_RECP_RATE_ADJUST',