[Home] [Help]
591: It would be ok to use RANK here instead of ROW_NUMBER since separate headers are created for CDLs and CCDLs
592:
593: The Cr and Dr amounts are altered assuming Switch Dr/CR to be 'Yes' on the JLT */
594:
595: INSERT ALL INTO XLA_AE_LINES
596: (upg_batch_id,
597: ae_header_id,
598: ae_line_num,
599: application_id,
802: where lines_gt.expenditure_item_id = cdl.expenditure_item_id
803: and lines_gt.cdl_line_num = cdl.line_num);
804:
805:
806: /* Stamp the gl_sl_link_id on xla_ae_lines to establish the link between GL and SLA
807:
808: This is done in a separate update (and not combined with the insert on xla_ae_lines
809: since there are known issues of data corruption in the link with gl_import_references
810: using the gl_batch_name and this corruption should not prevent the data upgrade to SLA.
804:
805:
806: /* Stamp the gl_sl_link_id on xla_ae_lines to establish the link between GL and SLA
807:
808: This is done in a separate update (and not combined with the insert on xla_ae_lines
809: since there are known issues of data corruption in the link with gl_import_references
810: using the gl_batch_name and this corruption should not prevent the data upgrade to SLA.
811:
812: Even if any data corrutpion is encountered, the upgrade is continued as the only loss
815:
816:
817: BEGIN
818:
819: UPDATE XLA_AE_LINES xal
820: SET gl_sl_link_id = (SELECT /*+ INDEX(tmp, PA_REV_AE_LINES_TMP_U1) */
821: gl_sl_link_id
822: FROM GL_IMPORT_REFERENCES imp,
823: PA_REV_AE_LINES_TMP tmp
1274: lines_gt.je_category,
1275: lines_gt.event_type_code;
1276:
1277:
1278: INSERT ALL INTO XLA_AE_LINES
1279: (upg_batch_id,
1280: ae_header_id,
1281: ae_line_num,
1282: application_id,
1486:
1487:
1488: BEGIN
1489:
1490: UPDATE XLA_AE_LINES xal
1491: SET gl_sl_link_id = (SELECT /*+ INDEX(tmp, PA_REV_AE_LINES_TMP_U1) */
1492: gl_sl_link_id
1493: FROM GL_IMPORT_REFERENCES imp,
1494: PA_REV_AE_LINES_TMP tmp