[Home] [Help]
478: IF NVL(l_entity_type,'L') = 'L' THEN
479:
480: INSERT ALL
481: WHEN 1 = 1 THEN
482: INTO XLA_AE_LINES
483: (upg_batch_id,
484: ae_header_id,
485: ae_line_num,
486: application_id,
1228: IF NVL(l_entity_type,'L') = 'L' THEN
1229:
1230: INSERT ALL
1231: WHEN 1 = 1 THEN
1232: INTO XLA_AE_LINES
1233: (upg_batch_id,
1234: ae_header_id,
1235: ae_line_num,
1236: application_id,
2096: IF NVL(l_entity_type,'L') = 'L' THEN
2097:
2098: INSERT ALL
2099: WHEN 1 = 1 THEN
2100: INTO XLA_AE_LINES
2101: (upg_batch_id,
2102: ae_header_id,
2103: ae_line_num,
2104: application_id,
2855: IF NVL(l_entity_type,'L') = 'L' THEN
2856:
2857: INSERT ALL
2858: WHEN 1 = 1 THEN
2859: INTO XLA_AE_LINES
2860: (upg_batch_id,
2861: ae_header_id,
2862: ae_line_num,
2863: application_id,
3214: If (l_accounting_method = 'CASH') Then
3215:
3216: update /*+ rowid(gir) */ gl_import_references gir
3217: set gir.gl_sl_link_id = (select min(xal.gl_sl_link_id)
3218: from xla_ae_lines xal,
3219: xla_ae_headers xah,
3220: xla_transaction_entities_upg xte,
3221: ar_cash_receipts_all cr,
3222: ar_system_parameters_all asp,
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,
3270: xla_ae_headers xah,
3271: xla_transaction_entities_upg xte,
3272: ar_cash_receipts_all cr,
3273: ar_system_parameters_all asp,
3323: gl_sl_link_table) =
3324: (SELECT /*+
3325: NO_EXPAND leading(ghd,periods,gld,gps,lnk,ln)
3326: use_nl(ghd,gld,gps)
3327: USE_NL_WITH_INDEX(ln XLA_AE_LINES_U1)
3328: USE_NL_WITH_INDEX(lnk XLA_DISTRIBUTION_LINKS_N1)
3329: */
3330: LN.GL_SL_LINK_ID, 'XLAJEL'
3331: FROM GL_JE_HEADERS GHD,
3331: FROM GL_JE_HEADERS GHD,
3332: GL_JE_LINES GLD,
3333: XLA_UPGRADE_DATES GPS,
3334: XLA_DISTRIBUTION_LINKS LNK,
3335: XLA_AE_LINES LN
3336: WHERE EXISTS
3337: (select /*+ PUSH_SUBQ */ null
3338: from ar120gir_periods periods
3339: where periods.period_name = GHD.period_name
3377: gl_sl_link_table) =
3378: (SELECT /*+
3379: NO_EXPAND leading(ghd,periods,gld,gps,lnk,ln)
3380: use_nl(ghd,gld,gps)
3381: USE_NL_WITH_INDEX(ln XLA_AE_LINES_U1)
3382: USE_NL_WITH_INDEX(lnk XLA_DISTRIBUTION_LINKS_N1)
3383: */
3384: LN.GL_SL_LINK_ID, 'XLAJEL'
3385: FROM GL_JE_HEADERS GHD,
3385: FROM GL_JE_HEADERS GHD,
3386: GL_JE_LINES GLD,
3387: XLA_UPGRADE_DATES GPS,
3388: XLA_DISTRIBUTION_LINKS LNK,
3389: XLA_AE_LINES LN
3390: WHERE EXISTS
3391: (select /*+ PUSH_SUBQ */ null
3392: from ar120gir_periods periods
3393: where periods.period_name = GHD.period_name
3508: --as AR stores in detailed accounting for historical data.
3509: -------------------------------------------------------------------
3510: INSERT ALL
3511: WHEN 1 = 1 THEN
3512: INTO XLA_AE_LINES
3513: (upg_batch_id,
3514: ae_header_id,
3515: ae_line_num,
3516: application_id,
3727: null tax_line_id,
3728: hdr.accounting_date accounting_date,
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,
4413: map.period_name ;
4414:
4415: INSERT ALL
4416: WHEN 1 = 1 THEN
4417: INTO XLA_AE_LINES
4418: (upg_batch_id,
4419: ae_header_id,
4420: ae_line_num,
4421: application_id,
4612: 'N' gain_or_loss_flag,
4613: hdr.accounting_date accounting_date,
4614: hdr.ledger_id ledger_id,
4615: 1 ln_order,
4616: 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
4617: from ar_cash_receipts_all cr,
4618: ar_cash_receipt_history_all crh,
4619: -- xla_upgrade_dates gps,
4620: ar_cash_receipt_history_all crh1,
4716: 'N') gain_or_loss_flag,
4717: hdr.accounting_date accounting_date,
4718: hdr.ledger_id ledger_id,
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,
4803: 'N' gain_or_loss_flag,
4804: hdr.accounting_date accounting_date,
4805: hdr.ledger_id ledger_id,
4806: 1 ln_order,
4807: 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
4808: from ar_cash_receipts_all cr,
4809: ar_misc_cash_distributions_all mcd,
4810: -- xla_upgrade_dates gps,
4811: ar_cash_receipt_history_all crh,
4855: and ard.source_table = 'MCD');
4856:
4857: INSERT ALL
4858: WHEN 1 = 1 THEN
4859: INTO XLA_AE_LINES
4860: (upg_batch_id,
4861: ae_header_id,
4862: ae_line_num,
4863: application_id,
5074: null tax_line_id,
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,