[Home] [Help]
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,
545: ra_customer_trx_all trx
546: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
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
739: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
740: 'RECP_RATE_ADJUST') -- Uptake XLA trx reversal ,'RECP_REVERSE')
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' ,
1784: 'MISC_RECP_RATE_ADJUST','MISC_RECP_REVERSE' )--BUG#3419926
2685: ra_customer_trx_all trxt,
2686: ra_customer_trx_lines_all tlt,
2687: ra_cust_trx_line_gl_dist_all gldt,
2688: ar_payment_schedules_all psch,
2689: ar_cash_receipts_all cr
2690: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
2691: 'RECP_RATE_ADJUST' ) -- Uptake XLA reversal, 'RECP_REVERSE')
2692: -- Exclude 'RECP_REVERSE' for no extract at line level is reuired for Reversal
2693: AND gt.application_id = p_application_id
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,
3642: ar_cash_receipt_history_all pcrh
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,
3841: gl_sets_of_books sob
4035: ,ct.sold_to_site_use_id
4036: ,ct.ship_to_customer_id
4037: ,ct.ship_to_site_use_id
4038: FROM ar_cash_receipt_history_all crh
4039: ,ar_cash_receipts_all cr
4040: ,ar_receivable_applications_all ra
4041: ,ar_distributions_all ard
4042: ,ra_customer_trx_all ct
4043: ,ra_cust_trx_line_gl_dist_all ctlgd
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
4137: WHERE gt.application_id = 222
4138: AND gt.event_type_code IN ('RECP_CREATE','RECP_UPDATE','MISC_RECP_CREATE','MISC_RECP_UPDATE')
4469: ar_distributions_all ard,
4470: ra_customer_trx_all trx,
4471: ra_cust_trx_line_gl_dist_all ctlgd,
4472: ra_customer_trx_lines_all ctl,
4473: ar_cash_receipts_all cr,
4474: gl_ledgers lg,
4475: ar_cash_receipt_history_all crhlatest
4476: WHERE gt.application_id = 222
4477: AND gt.event_type_code IN ('RECP_CREATE','RECP_UPDATE')
4600: ,NULL
4601: ,NULL
4602: ,NULL
4603: ,NULL
4604: FROM ar_cash_receipts_all cr
4605: ,ar_misc_cash_distributions_all mcd
4606: ,ar_cash_receipt_history_all crh
4607: ,ar_distributions_all ard
4608: ,(SELECT entity_id,
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',
5184: 'MISC_RECP_UPDATE') --Uptake XLA Reversal 'MISC_RECP_REVERSE' )