[Home] [Help]
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
963: AND gt.application_id = p_application_id
964: AND gt.event_id = app.event_id
988: AND NVL(psch.terms_sequence_number,1) = 1
989: AND dist.source_type = 'REC' /* Bug 6119725 Start Changes */
990: AND ((dist.ref_cust_trx_line_gl_dist_id IS NOT NULL
991: AND dist.ref_cust_trx_line_gl_dist_id NOT IN (SELECT cust_trx_line_gl_dist_id
992: FROM ra_cust_trx_line_gl_dist_all ctlgd
993: WHERE ctlgd.customer_trx_id = app.applied_customer_trx_id)) -- Restrict To rows of Invoice
994: OR ((dist.ref_cust_trx_line_gl_dist_id IS NULL
995: AND sign((app.amount_applied+nvl(app.earned_discount_taken,0)+nvl(app.unearned_discount_taken,0)))*-1 = sign(nvl(dist.amount_dr,0) * -1+nvl(dist.amount_cr,0))
996: AND (((sign((app.amount_applied+nvl(app.earned_discount_taken,0)+nvl(app.unearned_discount_taken,0)))*-1) <> 0)
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' )
1172: AND gt.application_id = 222
1173: AND gt.event_id = app.event_id
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' ,
1377: 'CM_CREATE' , 'CM_UPDATE' ,
1378: 'DM_CREATE' , 'DM_UPDATE' ,
1379: 'DEP_CREATE' , 'DEP_UPDATE' ,
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
1586: AND adj.set_of_books_id = sob.set_of_books_id
2177: ,li.tax_line_id --tax_line_id
2178: ,'N' --MFAR_ADDITIONAL_ENTRY
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
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'
2403: AND gt.application_id = p_application_id
2404: AND adj.event_id = gt.event_id
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
2690: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
2691: 'RECP_RATE_ADJUST' ) -- Uptake XLA reversal, 'RECP_REVERSE')
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' )
2820: AND gt.application_id = p_application_id
2821: AND gt.event_id = app.event_id
2839: -- AND dist.activity_bucket IS NOT NULL
2840: /* Bug 6119725 Begin Changes */
2841: AND (( dist.ref_cust_trx_line_gl_dist_id IS NOT NULL
2842: AND dist.ref_cust_trx_line_gl_dist_id IN (SELECT cust_trx_line_gl_dist_id
2843: FROM ra_cust_trx_line_gl_dist_all ctlgd
2844: WHERE ctlgd.customer_trx_id = app.applied_customer_trx_id)) -- Select only TO rows which belong to Invoice
2845: OR ((dist.ref_cust_trx_line_gl_dist_id IS NULL
2846: AND sign((app.amount_applied+nvl(app.earned_discount_taken,0)+nvl(app.unearned_discount_taken,0))) = sign(nvl(dist.amount_dr,0) * -1+nvl(dist.amount_cr,0))
2847: AND (((sign((app.amount_applied+nvl(app.earned_discount_taken,0)+nvl(app.unearned_discount_taken,0)))*-1) <> 0)
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
3119: WHERE gt.event_type_code IN ( 'RECP_CREATE' ,'RECP_UPDATE',
3120: 'RECP_RATE_ADJUST' ) --Uptake XLA Reversal, 'RECP_REVERSE')
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
3223: WHERE gt.event_type_code IN ( 'CM_CREATE' ,'CM_UPDATE' )
3224: AND gt.application_id = p_application_id
3235: AND ars.org_id = app.org_id
3236: AND ars.ACCOUNTING_METHOD = 'CASH'
3237: AND acb.ref_cust_trx_line_gl_dist_id NOT IN
3238: (SELECT cust_trx_line_gl_dist_id
3239: FROM ra_cust_trx_line_gl_dist_all
3240: WHERE customer_trx_id = gt.source_id_int_1); --Excluding the receivable distribution of the CM
3241:
3242:
3243:
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
4047: FROM xla_events_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,
4475: ar_cash_receipt_history_all crhlatest
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,
4976: gl_sets_of_books sob,
4977: ar_payment_schedules_all psch
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
5348: -- AR_MC_MISC_CASH_DISTS A
5349: -- RA_CUST_TRX_LINE_GL_DIST_ALL B Those 2 B entities will post tpgether
5350: -- RA_MC_TRX_LINE_GL_DIST B (Transactions)
5351: -- AR_ADJUSTMENTS_ALL C Those 2 C entities will post together
5352: -- AR_MC_ADJUSTMENTS C (Adjustments)
5353: -- AR_RECEIVABLE_APPLICATIONS_ALL D Those 2 D entities will post together
5451:
5452: --
5453: -- CTLGD
5454: -- GL Posting entiting are
5455: -- RA_CUST_TRX_LINE_GL_DIST_ALL,
5456: --
5457: UPDATE /*+ INDEX(ra_cust_trx_line_gl_dist_all ra_cust_trx_line_gl_dist_n6) */
5458: ra_cust_trx_line_gl_dist_all
5459: SET posting_control_id = l_pst_id,
5453: -- CTLGD
5454: -- GL Posting entiting are
5455: -- RA_CUST_TRX_LINE_GL_DIST_ALL,
5456: --
5457: UPDATE /*+ INDEX(ra_cust_trx_line_gl_dist_all ra_cust_trx_line_gl_dist_n6) */
5458: ra_cust_trx_line_gl_dist_all
5459: SET posting_control_id = l_pst_id,
5460: gl_posted_date = l_date
5461: WHERE posting_control_id = -3
5454: -- GL Posting entiting are
5455: -- RA_CUST_TRX_LINE_GL_DIST_ALL,
5456: --
5457: UPDATE /*+ INDEX(ra_cust_trx_line_gl_dist_all ra_cust_trx_line_gl_dist_n6) */
5458: ra_cust_trx_line_gl_dist_all
5459: SET posting_control_id = l_pst_id,
5460: gl_posted_date = l_date
5461: WHERE posting_control_id = -3
5462: AND (customer_trx_id, event_id) IN
5635: -- CTLGD
5636: SELECT 'lock'
5637: BULK COLLECT INTO l_lock
5638: FROM xla_entity_events_v eve,
5639: ra_cust_trx_line_gl_dist_all ctlgd
5640: WHERE eve.request_id = p_report_request_id
5641: AND eve.application_id = p_application_id
5642: AND eve.entity_code = 'TRANSACTIONS'
5643: AND eve.event_id = ctlgd.event_id