WITH suppliers AS
            (
                SELECT t1.datasupplier_id, t1.oproj_id, t2.tecdoc_datasupplier_id tecdoc_id
                    FROM datasupplier t1,
                             mv_map_einsp_datasupplier t2
                 WHERE t1.deldate >= SYSDATE
                     AND t2.tm_datasupplier_id = t1.datasupplier_id
            ),
            processes AS
            (
                SELECT t1.datasupplier_id,
                             RAWTONHEX(t1.data_package_guid) data_package_guid,
                             t1.import_id,
                             t2.seq_id,
                             t2.end_timestamp,
                             t2.cuser,
                             t2.remark,
                             t2.process_id,
                             t3.activity_id,
                             t4.oproj_id,
                             t1.first_process_id,
                             t4.tecdoc_id
                    FROM supplier_data.import_header_v2 t1,
                             supplier_data.import_detail_v2 t2,
                             supplier_data.import_detail_activity t3,
                             suppliers t4
                 WHERE t2.data_package_guid = t1.data_package_guid
                     AND t3.data_package_guid = t2.data_package_guid
                     AND t3.seq_id            = t2.seq_id
                     AND t4.datasupplier_id   = t1.datasupplier_id
                     AND t1.closing_activity_id IS NULL
                     AND t3.end_timestamp       IS NOT NULL
                     AND t2.end_timestamp       IS NOT NULL
                     AND t2.process_id        = 15
                     AND t3.activity_id       = 3
                     AND NOT EXISTS (SELECT t11.data_package_guid
                                                         FROM supplier_data.import_detail_activity t11
                                                        WHERE t11.data_package_guid  = t1.data_package_guid
                                                            AND t11.activity_id             IN (4,
                                                                                                                        9
                                                                                                                     )
                                                    )
                     AND NOT EXISTS (SELECT *
                                                         FROM supplier_data.import_detail_v2 t21
                                                        WHERE t21.data_package_guid = t1.data_package_guid
                                                            AND t21.process_id = 9
                                                    )
            UNION
                 SELECT t1.datasupplier_id,
                             RAWTONHEX(t1.data_package_guid) data_package_guid,
                             t1.import_id,
                             t2.seq_id,
                             t2.end_timestamp,
                             t2.cuser,
                             t2.remark,
                             t2.process_id,
                             t3.activity_id,
                             t4.oproj_id,
                             t1.first_process_id,
                             t4.tecdoc_id
                    FROM supplier_data.import_header_v2 t1,
                             supplier_data.import_detail_v2 t2,
                             supplier_data.import_detail_activity t3,
                             suppliers t4
                 WHERE t2.data_package_guid = t1.data_package_guid
                     AND t3.data_package_guid = t2.data_package_guid
                     AND t3.seq_id            = t2.seq_id
                     AND t4.datasupplier_id   = t1.datasupplier_id
                     AND t1.closing_activity_id IS NULL
                     AND t3.end_timestamp       IS NOT NULL
                     AND t2.end_timestamp       IS NOT NULL
                     AND t2.process_id        = 14
                     AND t3.activity_id       = 3
                     AND NOT EXISTS (SELECT t11.data_package_guid
                                                         FROM supplier_data.import_detail_activity t11
                                                        WHERE t11.data_package_guid  = t1.data_package_guid
                                                            AND t11.activity_id             IN (4,
                                                                                                                        9
                                                                                                                     )
                                                    )
                     AND NOT EXISTS (SELECT *
                                                         FROM supplier_data.import_detail_v2 t21
                                                        WHERE t21.data_package_guid = t1.data_package_guid
                                                            AND t21.process_id = 9
                                                    )
            UNION
                SELECT t1.datasupplier_id,
                             RAWTONHEX(t1.data_package_guid) data_package_guid,
                             t1.import_id,
                             t2.seq_id,
                             t2.end_timestamp,
                             t2.cuser,
                             t2.remark,
                             t2.process_id,
                             t3.activity_id,
                             t4.oproj_id,
                             t1.first_process_id,
                             t4.tecdoc_id
                    FROM supplier_data.import_header_v2 t1,
                             supplier_data.import_detail_v2 t2,
                             supplier_data.import_detail_activity t3,
                             suppliers t4
                 WHERE t2.data_package_guid = t1.data_package_guid
                     AND t3.data_package_guid = t2.data_package_guid
                     AND t3.seq_id            = t2.seq_id
                     AND t4.datasupplier_id   = t1.datasupplier_id
                     AND t1.closing_activity_id IS NULL
                     AND t3.end_timestamp       IS NOT NULL
                     AND t2.end_timestamp       IS NOT NULL
                     AND t2.process_id        = 7
                     AND t3.activity_id       IN (7,
                                                                                8
                                                                             )
                     AND NOT EXISTS (SELECT t11.data_package_guid
                                                         FROM supplier_data.import_detail_activity t11
                                                        WHERE t11.data_package_guid  = t1.data_package_guid
                                                            AND t11.activity_id             IN (4,
                                                                                                                        9
                                                                                                                     )
                                                    )
                     AND NOT EXISTS (SELECT *
                                                         FROM supplier_data.import_detail_v2 t21
                                                        WHERE t21.data_package_guid = t1.data_package_guid
                                                            AND t21.process_id = 9
                                                    )
            ),
            events AS
            (
                SELECT
                    t1.event_id,
                    t1.update_period_id,
                    t2.event_date,
                    t2.cdate
                FROM
                    data_center.update_event t1,
                    data_center.event_destination t2
                WHERE t2.destination_id = 1
                AND t1.event_id = t2.event_id
            ),
            ordered_events AS
            (
                SELECT
                            t2.data_package_guid,
                            t3.event_id,
                            NVL(t3.event_date, t4.cdate) AS event_date,
                            t3.update_period_id,
                            t2.end_timestamp,
                            t2.cuser,
                            t2.datasupplier_id,
                            t2.tecdoc_id,
                            t2.import_id,
                            t2.oproj_id,
                            t2.remark,
                            t2.seq_id,
                            t2.first_process_id,
                            t2.process_id,
                            t2.activity_id
                    FROM processes t2,
                    events t3,
                    cdp_data.datasupplier_event t4
                    WHERE t2.data_package_guid = t4.data_package_guid
                    AND t3.event_id (+)= t4.event_id
                    ORDER BY NVL(t3.event_date, t4.cdate), t2.import_id, t2.end_timestamp, t2.seq_id
            )
            SELECT *
            FROM (
                SELECT * FROM ordered_events t1 WHERE t1.update_period_id = 1 AS
            )
            ORDER BY (CASE t1.update_period_id WHEN 1 THEN 0 ELSE 1 END)