[Home] [Help]
581: It would be ok to use RANK here instead of ROW_NUMBER since separate headers are created for CDLs and CCDLs
582:
583: The Cr and Dr amounts are altered assuming Switch Dr/CR to be 'Yes' on the JLT */
584:
585: INSERT ALL INTO XLA_AE_LINES
586: (upg_batch_id,
587: ae_header_id,
588: ae_line_num,
589: application_id,
792: where lines_gt.expenditure_item_id = cdl.expenditure_item_id
793: and lines_gt.cdl_line_num = cdl.line_num);
794:
795:
796: /* Stamp the gl_sl_link_id on xla_ae_lines to establish the link between GL and SLA
797:
798: This is done in a separate update (and not combined with the insert on xla_ae_lines
799: since there are known issues of data corruption in the link with gl_import_references
800: using the gl_batch_name and this corruption should not prevent the data upgrade to SLA.
794:
795:
796: /* Stamp the gl_sl_link_id on xla_ae_lines to establish the link between GL and SLA
797:
798: This is done in a separate update (and not combined with the insert on xla_ae_lines
799: since there are known issues of data corruption in the link with gl_import_references
800: using the gl_batch_name and this corruption should not prevent the data upgrade to SLA.
801:
802: Even if any data corrutpion is encountered, the upgrade is continued as the only loss
805:
806:
807: BEGIN
808:
809: UPDATE XLA_AE_LINES xal
810: SET gl_sl_link_id = (SELECT /*+ INDEX(tmp, PA_REV_AE_LINES_TMP_U1) */
811: gl_sl_link_id
812: FROM GL_IMPORT_REFERENCES imp,
813: PA_REV_AE_LINES_TMP tmp
1263: lines_gt.je_category,
1264: lines_gt.event_type_code;
1265:
1266:
1267: INSERT ALL INTO XLA_AE_LINES
1268: (upg_batch_id,
1269: ae_header_id,
1270: ae_line_num,
1271: application_id,
1475:
1476:
1477: BEGIN
1478:
1479: UPDATE XLA_AE_LINES xal
1480: SET gl_sl_link_id = (SELECT /*+ INDEX(tmp, PA_REV_AE_LINES_TMP_U1) */
1481: gl_sl_link_id
1482: FROM GL_IMPORT_REFERENCES imp,
1483: PA_REV_AE_LINES_TMP tmp