[Home] [Help]
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' ,
547: 'RECP_RATE_ADJUST' ) --,'RECP_REVERSE') uptake XLA transaction reversal
548: AND gt.application_id = p_application_id
549: AND gt.event_id = app.event_id
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')
741: AND gt.application_id = 222
742: AND gt.event_id = app.event_id
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,
961: ar_payment_schedules_all psch
962: WHERE gt.event_type_code IN ('CM_CREATE','CM_UPDATE' ) --BUG#3419926
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,
1170: ar_payment_schedules_all psch
1171: WHERE gt.event_type_code IN ('CM_CREATE','CM_UPDATE' )
1367: ,gt.event_type_code
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
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
1585: AND adj.adjustment_id = gt.source_id_int_1
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
1968: AND gt.source_id_int_1 = trx.customer_trx_id
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,
2185: oe_system_parameters_all osp
2186: WHERE gt.event_type_code IN ('INV_CREATE' , 'INV_UPDATE' ,
2187: 'CM_CREATE' , 'CM_UPDATE' ,
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
2402: WHERE gt.event_type_code = 'ADJ_CREATE'
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,
2688: ar_payment_schedules_all psch,
2689: ar_cash_receipts_all cr
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,
2818: ar_payment_schedules_all psch
2819: WHERE gt.event_type_code IN ( 'CM_CREATE','CM_UPDATE' )
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
2944: AND dist.source_table = 'RA'
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,
3117: ar_payment_schedules_all psch,
3118: ar_system_parameters_all ars
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,
3221: ar_payment_schedules_all psch,
3222: ar_system_parameters_all ars
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
4044: ,ra_customer_trx_lines_all ctl
4045: ,(SELECT entity_id,
4046: source_id_int_1
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,
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,
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,
4974: oe_system_parameters_all osp,
4975: ar_distributions_all dist,
5339: -----------------
5340: -- The table in which the posting_control_id is present in AR are:
5341: -- AR_MC_CASH_BASIS_DISTS_ALL Obsolete unified Accrual and Cash basis accounting
5342: -- AR_CASH_BASIS_DISTS_ALL Obsolete unified Accrual and Cash basis accounting
5343: -- RA_CUSTOMER_TRX_ALL Do not post
5344: -- AR_RATE_ADJUSTMENTS_ALL Do not post
5345: -- AR_CASH_RECEIPT_HISTORY_ALL A Those 4 A entities will post together
5346: -- AR_MC_CASH_RECEIPT_HIST A (Misc) Cash Receipt
5347: -- AR_MISC_CASH_DISTRIBUTIONS_ALL A