[Home] [Help]
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,
542: ar_cash_receipts_all cr,
543: --BUG#5201086
544: ar_cash_receipt_history_all crh,
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,
736: ar_cash_receipts_all cr,
737: ar_cash_receipt_history_all crh,
738: ra_customer_trx_all trx
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,
958: ra_customer_trx_all trxf,
959: ra_customer_trx_lines_all tlf,
960: ra_cust_trx_line_gl_dist_all gldf,
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,
1167: ra_customer_trx_all trxf,
1168: ra_customer_trx_lines_all tlf,
1169: ra_cust_trx_line_gl_dist_all gldf,
1368: ,gt.event_class_code
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' ,
1575: ,gt.event_class_code
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'
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
1783: 'MISC_RECP_CREATE' ,'MISC_RECP_UPDATE' ,
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
1968: AND gt.source_id_int_1 = trx.customer_trx_id
1969: AND trx.set_of_books_id = sob.set_of_books_id;
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' ,
2187: 'CM_CREATE' , 'CM_UPDATE' ,
2188: 'DM_CREATE' , 'DM_UPDATE' ,
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,
2399: ra_customer_trx_lines_all tlt,
2400: ra_cust_trx_line_gl_dist_all gldt,
2401: oe_system_parameters_all osp
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,
2685: ra_customer_trx_all trxt,
2686: ra_customer_trx_lines_all tlt,
2687: ra_cust_trx_line_gl_dist_all gldt,
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,
2815: ra_customer_trx_all trxt,
2816: ra_customer_trx_lines_all tlt,
2817: ra_cust_trx_line_gl_dist_all gldt,
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
2941: WHERE gt.event_type_code IN ( 'CM_CREATE','CM_UPDATE' )
2942: AND gt.application_id = p_application_id
2943: AND gt.event_id = app.event_id
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,
3114: ra_customer_trx_all trxt,
3115: ra_customer_trx_lines_all tlt,
3116: ra_cust_trx_line_gl_dist_all gldt,
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,
3218: ra_customer_trx_all trxt,
3219: ra_customer_trx_lines_all tlt,
3220: ra_cust_trx_line_gl_dist_all gldt,
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' ,
3437: 'RECP_RATE_ADJUST' ) --Uptake XLA reversal,'RECP_REVERSE')
3438: -- Exclude 'RECP_REVERSE' for no extract at line level is reuired for Reversal
3439: AND gt.application_id = p_application_id
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,
3642: ar_cash_receipt_history_all pcrh
3643: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
3644: 'MISC_RECP_CREATE' ,'MISC_RECP_UPDATE' ,
3645: --Uptake XLA Reversal 'RECP_REVERSE' ,'MISC_RECP_REVERSE' ,
3837: ar_cash_receipts_all cr,
3838: ar_cash_receipt_history_all crh,
3839: ar_receivable_applications_all app,
3840: ar_distributions_all dist,
3841: gl_sets_of_books sob
3842: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
3843: 'RECP_RATE_ADJUST' ) --Uptake XLA Reversal,'RECP_REVERSE' )
3844: AND gt.application_id = p_application_id
3845: AND cr.cash_receipt_id = gt.source_id_int_1
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,
4977: ar_payment_schedules_all psch
4978: WHERE gt.event_type_code IN ('BILL_CREATE' ,
4979: 'BILL_UPDATE' ,
4980: 'BILL_REVERSE' )
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,
5181: --5201086
5182: ar_cash_receipt_history_all crh
5183: WHERE gt.event_type_code IN ( 'MISC_RECP_CREATE','MISC_RECP_RATE_ADJUST',