[Home] [Help]
369: ct.doc_sequence_value DOC_SEQ_VAL ,
370: tty.name CAT_CODE ,
371: te.entity_id ENTITY_ID
372: FROM ra_customer_trx_all ct,
373: ar_receivable_applications_all app,
374: xla_upgrade_dates gps,
375: ar_system_parameters_all sys,
376: ra_cust_trx_types_all tty,
377: ra_cust_trx_line_gl_dist_all ctlgd,
777: hdr.accounting_date accounting_date,
778: hdr.ledger_id ledger_id,
779: 2 ln_order
780: from ra_customer_trx_all ct,
781: ar_receivable_applications_all app,
782: xla_upgrade_dates gps,
783: xla_transaction_entities_upg ent,
784: xla_events ev,
785: xla_ae_headers hdr,
1984: rmth.name CAT_CODE ,
1985: te.entity_id ENTITY_ID
1986: FROM ar_cash_receipts_all cr,
1987: --ar_system_parameters_all sys,
1988: ar_receivable_applications_all app,
1989: xla_upgrade_dates gps,
1990: ar_cash_receipt_history_all crh,
1991: ar_cash_receipt_history_all crh1,
1992: ar_receipt_methods rmth,
2392: hdr.ledger_id ledger_id,
2393: 2 ln_order
2394: from ar_cash_receipts_all cr,
2395: ar_system_parameters_all sys,
2396: ar_receivable_applications_all app,
2397: xla_upgrade_dates gps,
2398: xla_transaction_entities_upg ent,
2399: ar_cash_receipt_history_all crh,
2400: ar_cash_receipt_history_all crh1,
3261: where rowid between l_start_rowid and l_end_rowid
3262: and gir.reference_10 = 'AR_CASH_RECEIPT_HISTORY'
3263: and gir.gl_sl_link_id is null;
3264:
3265: -- Update gl_sl_link_id for AR_RECEIVABLE_APPLICATIONS_ALL UNAPP data
3266:
3267: update /*+ rowid(gir) */ gl_import_references gir
3268: set gir.gl_sl_link_id = (select min(xal.gl_sl_link_id)
3269: from xla_ae_lines xal,
3271: xla_transaction_entities_upg xte,
3272: ar_cash_receipts_all cr,
3273: ar_system_parameters_all asp,
3274: xla_distribution_links xdl,
3275: ar_receivable_applications_all unapp,
3276: xla_upgrade_dates gps,
3277: ar_distributions_all ard,
3278: gl_je_lines gjl
3279: where xte.source_id_int_1 = cr.cash_receipt_id
3310: ),
3311: gir.gl_sl_link_table = 'XLAJEL',
3312: gir.last_update_date = sysdate
3313: where rowid between l_start_rowid and l_end_rowid
3314: and gir.reference_10 = 'AR_RECEIVABLE_APPLICATIONS'
3315: and gir.gl_sl_link_id is null;
3316:
3317: -- Update gl_sl_link_id for AR_CASH_BASIS_DISTS_ALL data
3318:
3410: THEN 'RA_CUST_TRX_LINE_GL_DIST_ALL'
3411: WHEN GIMP.REFERENCE_10 IN
3412: ('AR_TRANSACTION_HISTORY','AR_ADJUSTMENTS',
3413: 'AR_MISC_CASH_DISTRIBUTIONS',
3414: 'AR_RECEIVABLE_APPLICATIONS', 'AR_CASH_RECEIPT_HISTORY')
3415: THEN 'AR_DISTRIBUTIONS_ALL'
3416: ELSE NULL
3417: END )
3418: AND LN.APPLICATION_ID = 222
3422: )
3423: WHERE ROWID BETWEEN l_start_rowid and l_end_rowid
3424: AND GIMP.REFERENCE_10 IN
3425: ('AR_TRANSACTION_HISTORY','AR_ADJUSTMENTS','AR_MISC_CASH_DISTRIBUTIONS',
3426: 'AR_RECEIVABLE_APPLICATIONS','AR_CASH_RECEIPT_HISTORY','RA_CUST_TRX_LINE_GL_DIST')
3427: AND GIMP.GL_SL_LINK_ID IS NULL;
3428:
3429:
3430: l_rows_processed := l_rows_processed + SQL%ROWCOUNT;
3729: hdr.ledger_id AS ledger_id,
3730: 1 ln_order,
3731: nvl((select max(ae_line_num) from xla_ae_lines ael
3732: where ael.ae_header_id=hdr.ae_header_id and application_id=222),1000) max_line_num
3733: from ar_receivable_applications_all app,
3734: xla_upgrade_dates gps,
3735: xla_transaction_entities_upg ent,
3736: ra_customer_trx_all ctcm,
3737: ar_cash_receipt_history_all crh1,
4297: rmth.name CAT_CODE ,
4298: te.entity_id ENTITY_ID
4299: FROM ar_cash_receipts_all cr,
4300: -- ar_system_parameters_all sys,
4301: ar_receivable_applications_all app,
4302: -- xla_upgrade_dates gps,
4303: ar_cash_receipt_history_all crh,
4304: ar_cash_receipt_history_all crh1,
4305: ar_receipt_methods rmth,
4719: 2 ln_order,
4720: nvl((select max(ae_line_num) from xla_ae_lines ael where ael.ae_header_id=hdr.ae_header_id and application_id=222),1000) max_line_num
4721: from ar_cash_receipts_all cr,
4722: ar_system_parameters_all sys,
4723: ar_receivable_applications_all app,
4724: -- xla_upgrade_dates gps,
4725: xla_transaction_entities_upg ent,
4726: ar_cash_receipt_history_all crh,
4727: ar_cash_receipt_history_all crh1,
5075: hdr.accounting_date accounting_date,
5076: hdr.ledger_id AS ledger_id,
5077: 1 ln_order,
5078: nvl((select max(ae_line_num) from xla_ae_lines ael where ael.ae_header_id=hdr.ae_header_id and application_id=222),1000) max_line_num
5079: from ar_receivable_applications_all app,
5080: ar_system_parameters_all sys,
5081: xla_upgrade_dates gps,
5082: xla_transaction_entities_upg ent,
5083: ra_customer_trx_all ctcm,
5164: PROCEDURE UPGRADE_CASH_RA_DATA(
5165: p_cash_receipt_id IN NUMBER) IS
5166: BEGIN
5167:
5168: UPDATE ar_receivable_applications ra
5169: SET ra.cash_receipt_history_id =
5170: ( SELECT MAX(crh.cash_receipt_history_id)
5171: FROM ar_cash_receipt_history crh
5172: WHERE crh.cash_receipt_id = ra.cash_receipt_id