[Home] [Help]
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
554: AND eve.entity_code IN ('RECEIPTS','TRANSACTIONS')
614: --Update receivable applications
615: local_log(procedure_name => 'upgrade_11i_r12_post',
616: p_msg_text => ' Set application upgrade_method 11I_R12_POST');
617:
618: UPDATE ar_receivable_applications_all
619: SET upgrade_method = '11I_R12_POST'
620: WHERE receivable_application_id IN
621: (SELECT gt_id
622: FROM ar_line_app_detail_gt
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,
803: ar_cash_receipts_all cr,
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,
1107: ar_cash_receipts_all cr,
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,
1302: ar_cash_receipts_all cr,
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,
1531: ra_customer_trx_all trxf,
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,
1744: ra_customer_trx_all trxf,
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,
3364: ra_customer_trx_all trxt,
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,
3500: ra_customer_trx_all trxt,
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
3632: WHERE gt.event_type_code IN ( 'CM_CREATE','CM_UPDATE' )
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,
3805: ra_customer_trx_all trxt,
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,
3909: ra_customer_trx_all trxt,
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' ,
4128: 'RECP_RATE_ADJUST' ) --Uptake XLA reversal,'RECP_REVERSE')
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,
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' )
5461: ,ra.set_of_books_id --ledger_id
5462: ,ard.currency_code --currency_code
5463: ,ra.org_id --org_id
5464: ,sob.currency_code --base currency code
5465: FROM ar_receivable_applications_all ra
5466: ,ar_distributions_all ard
5467: ,(SELECT entity_id,
5468: source_id_int_1,
5469: event_id,
5532: ,ct.sold_to_customer_id --sold_to_customer_id
5533: ,ct.sold_to_site_use_id --sold_to_site_use_id
5534: ,ct.ship_to_customer_id --ship_to_customer_id
5535: ,ct.ship_to_site_use_id --ship_to_site_use_id
5536: FROM ar_receivable_applications_all ra
5537: ,ar_distributions_all ard
5538: ,ra_customer_trx_all ct
5539: ,ra_customer_trx_lines_all ctl
5540: ,(SELECT entity_id,
5914: ,ra.acctd_amount_applied_from
5915: ,decode(ct.upgrade_method,'R12_11ICASH','N','') mfar_upg_trx
5916: FROM ar_cash_receipt_history_all crh
5917: ,ar_cash_receipts_all cr
5918: ,ar_receivable_applications_all ra
5919: ,ar_distributions_all ard
5920: ,ra_customer_trx_all ct
5921: ,ra_cust_trx_line_gl_dist_all ctlgd
5922: ,ra_customer_trx_lines_all ctl
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,
6481: ra_cust_trx_line_gl_dist_all ctlgd,
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,
6598: ra_cust_trx_line_gl_dist_all ctlgd,
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,
6711: ra_cust_trx_line_gl_dist_all ctlgd,
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,
6831: ra_cust_trx_line_gl_dist_all ctlgd,
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,
7115: ra_customer_trx_all trxt,
8006: -- RA_CUST_TRX_LINE_GL_DIST_ALL B Those 2 B entities will post tpgether
8007: -- RA_MC_TRX_LINE_GL_DIST B (Transactions)
8008: -- AR_ADJUSTMENTS_ALL C Those 2 C entities will post together
8009: -- AR_MC_ADJUSTMENTS C (Adjustments)
8010: -- AR_RECEIVABLE_APPLICATIONS_ALL D Those 2 D entities will post together
8011: -- AR_MC_RECEIVABLE_APPS D (Applications)
8012: -- AR_TRANSACTION_HISTORY_ALL E Those 2 E entities will post together
8013: -- AR_MC_TRANSACTION_HISTORY E (Bill Receivables)
8014: -- Question are there any side effect
8160:
8161: --
8162: -- APP
8163: -- GL Posting entiting are
8164: -- AR_RECEIVABLE_APPLICATIONS_ALL,
8165: --
8166: UPDATE ar_receivable_applications_all
8167: SET posting_control_id = l_pst_id,
8168: gl_posted_date = l_date,
8162: -- APP
8163: -- GL Posting entiting are
8164: -- AR_RECEIVABLE_APPLICATIONS_ALL,
8165: --
8166: UPDATE ar_receivable_applications_all
8167: SET posting_control_id = l_pst_id,
8168: gl_posted_date = l_date,
8169: last_updated_by = fnd_global.user_id,
8170: last_update_date = sysdate,
8337: -- APP
8338: SELECT 'lock'
8339: BULK COLLECT INTO l_lock
8340: FROM xla_entity_events_v eve,
8341: ar_receivable_applications_all app
8342: WHERE eve.request_id = p_report_request_id
8343: AND eve.application_id = p_application_id
8344: AND eve.entity_code IN ('RECEIPTS','TRANSACTIONS')
8345: AND eve.event_id = app.event_id