PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Plan hash value: 1218131968 ---------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | ---------------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 2649 | 356K| 1585K (1)| 00:02:04 | | | | 1 | SORT GROUP BY | | 2649 | 356K| 1585K (1)| 00:02:04 | | | | 2 | VIEW | VW_ORE_6C24D5F9 | 2649 | 356K| 1585K (1)| 00:02:04 | | | | 3 | UNION-ALL | | | | | | | | |* 4 | FILTER | | | | | | | | | 5 | NESTED LOOPS | | 203 | 24766 | 137K (1)| 00:00:11 | | | PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6 | NESTED LOOPS | | 232 | 24766 | 137K (1)| 00:00:11 | | | |* 7 | TABLE ACCESS BY GLOBAL INDEX ROWID BATCHED| MOVEMENT | 58 | 4582 | 137K (1)| 00:00:11 | ROWID | ROWID | |* 8 | INDEX RANGE SCAN | IDX_MOV_STATE | 145K| | 640 (1)| 00:00:01 | | | | 9 | PARTITION REFERENCE ITERATOR | | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |* 10 | INDEX RANGE SCAN | IDX_MOVEMENT_MSG_ID | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |* 11 | TABLE ACCESS BY LOCAL INDEX ROWID | MOVEMENT_MESSAGE | 4 | 172 | 5 (0)| 00:00:01 | 1 | 1 | |* 12 | FILTER | | | | | | | | | 13 | NESTED LOOPS | | 1 | 122 | 10 (0)| 00:00:01 | | | | 14 | NESTED LOOPS | | 4 | 122 | 10 (0)| 00:00:01 | | | |* 15 | TABLE ACCESS BY GLOBAL INDEX ROWID BATCHED| MOVEMENT | 1 | 79 | 5 (0)| 00:00:01 | ROWID | ROWID | |* 16 | INDEX RANGE SCAN | IDX_MOV_STATE | 1 | | 4 (0)| 00:00:01 | | | PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 17 | PARTITION REFERENCE ITERATOR | | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |* 18 | INDEX RANGE SCAN | IDX_MOVEMENT_MSG_ID | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |* 19 | TABLE ACCESS BY LOCAL INDEX ROWID | MOVEMENT_MESSAGE | 4 | 172 | 5 (0)| 00:00:01 | 1 | 1 | |* 20 | FILTER | | | | | | | | | 21 | NESTED LOOPS | | 1 | 122 | 11 (0)| 00:00:01 | | | | 22 | NESTED LOOPS | | 4 | 122 | 11 (0)| 00:00:01 | | | |* 23 | TABLE ACCESS BY GLOBAL INDEX ROWID BATCHED| MOVEMENT | 1 | 79 | 6 (0)| 00:00:01 | ROWID | ROWID | |* 24 | INDEX RANGE SCAN | IDX_MOV_STATE | 2 | | 4 (0)| 00:00:01 | | | | 25 | PARTITION REFERENCE ITERATOR | | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |* 26 | INDEX RANGE SCAN | IDX_MOVEMENT_MSG_ID | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |* 27 | TABLE ACCESS BY LOCAL INDEX ROWID | MOVEMENT_MESSAGE | 4 | 172 | 5 (0)| 00:00:01 | 1 | 1 | PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |* 28 | FILTER | | | | | | | | | 29 | NESTED LOOPS | | 15 | 1830 | 10236 (1)| 00:00:01 | | | | 30 | NESTED LOOPS | | 16 | 1830 | 10236 (1)| 00:00:01 | | | |* 31 | TABLE ACCESS BY GLOBAL INDEX ROWID BATCHED| MOVEMENT | 4 | 316 | 10216 (1)| 00:00:01 | ROWID | ROWID | |* 32 | INDEX RANGE SCAN | IDX_MOV_STATE | 10767 | | 51 (0)| 00:00:01 | | | | 33 | PARTITION REFERENCE ITERATOR | | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |* 34 | INDEX RANGE SCAN | IDX_MOVEMENT_MSG_ID | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |* 35 | TABLE ACCESS BY LOCAL INDEX ROWID | MOVEMENT_MESSAGE | 4 | 172 | 5 (0)| 00:00:01 | 1 | 1 | |* 36 | FILTER | | | | | | | | | 37 | NESTED LOOPS | | 801 | 97722 | 543K (1)| 00:00:43 | | | | 38 | NESTED LOOPS | | 908 | 97722 | 543K (1)| 00:00:43 | | | PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |* 39 | TABLE ACCESS BY GLOBAL INDEX ROWID BATCHED| MOVEMENT | 227 | 17933 | 542K (1)| 00:00:43 | ROWID | ROWID | |* 40 | INDEX RANGE SCAN | IDX_MOV_STATE | 571K| | 2512 (1)| 00:00:01 | | | | 41 | PARTITION REFERENCE ITERATOR | | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |* 42 | INDEX RANGE SCAN | IDX_MOVEMENT_MSG_ID | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |* 43 | TABLE ACCESS BY LOCAL INDEX ROWID | MOVEMENT_MESSAGE | 4 | 172 | 5 (0)| 00:00:01 | 1 | 1 | |* 44 | FILTER | | | | | | | | | 45 | NESTED LOOPS | | 25 | 3050 | 16821 (1)| 00:00:02 | | | | 46 | NESTED LOOPS | | 28 | 3050 | 16821 (1)| 00:00:02 | | | |* 47 | TABLE ACCESS BY GLOBAL INDEX ROWID BATCHED| MOVEMENT | 7 | 553 | 16786 (1)| 00:00:02 | ROWID | ROWID | |* 48 | INDEX RANGE SCAN | IDX_MOV_STATE | 17693 | | 81 (0)| 00:00:01 | | | | 49 | PARTITION REFERENCE ITERATOR | | 4 | | 2 (0)| 00:00:01 | KEY | KEY | PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |* 50 | INDEX RANGE SCAN | IDX_MOVEMENT_MSG_ID | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |* 51 | TABLE ACCESS BY LOCAL INDEX ROWID | MOVEMENT_MESSAGE | 4 | 172 | 5 (0)| 00:00:01 | 1 | 1 | |* 52 | FILTER | | | | | | | | | 53 | NESTED LOOPS | | 11 | 1342 | 7358 (1)| 00:00:01 | | | | 54 | NESTED LOOPS | | 12 | 1342 | 7358 (1)| 00:00:01 | | | |* 55 | TABLE ACCESS BY GLOBAL INDEX ROWID BATCHED| MOVEMENT | 3 | 237 | 7343 (1)| 00:00:01 | ROWID | ROWID | |* 56 | INDEX RANGE SCAN | IDX_MOV_STATE | 7738 | | 37 (0)| 00:00:01 | | | | 57 | PARTITION REFERENCE ITERATOR | | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |* 58 | INDEX RANGE SCAN | IDX_MOVEMENT_MSG_ID | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |* 59 | TABLE ACCESS BY LOCAL INDEX ROWID | MOVEMENT_MESSAGE | 4 | 172 | 5 (0)| 00:00:01 | 1 | 1 | |* 60 | FILTER | | | | | | | | PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 61 | NESTED LOOPS | | 1 | 122 | 68 (0)| 00:00:01 | | | | 62 | NESTED LOOPS | | 4 | 122 | 68 (0)| 00:00:01 | | | |* 63 | TABLE ACCESS BY GLOBAL INDEX ROWID BATCHED| MOVEMENT | 1 | 79 | 63 (0)| 00:00:01 | ROWID | ROWID | |* 64 | INDEX RANGE SCAN | IDX_MOV_STATE | 61 | | 4 (0)| 00:00:01 | | | | 65 | PARTITION REFERENCE ITERATOR | | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |* 66 | INDEX RANGE SCAN | IDX_MOVEMENT_MSG_ID | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |* 67 | TABLE ACCESS BY LOCAL INDEX ROWID | MOVEMENT_MESSAGE | 4 | 172 | 5 (0)| 00:00:01 | 1 | 1 | |* 68 | FILTER | | | | | | | | | 69 | NESTED LOOPS | | 69 | 8418 | 47090 (1)| 00:00:04 | | | | 70 | NESTED LOOPS | | 80 | 8418 | 47090 (1)| 00:00:04 | | | |* 71 | TABLE ACCESS BY GLOBAL INDEX ROWID BATCHED| MOVEMENT | 20 | 1580 | 46990 (1)| 00:00:04 | ROWID | ROWID | PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |* 72 | INDEX RANGE SCAN | IDX_MOV_STATE | 49539 | | 221 (1)| 00:00:01 | | | | 73 | PARTITION REFERENCE ITERATOR | | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |* 74 | INDEX RANGE SCAN | IDX_MOVEMENT_MSG_ID | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |* 75 | TABLE ACCESS BY LOCAL INDEX ROWID | MOVEMENT_MESSAGE | 4 | 172 | 5 (0)| 00:00:01 | 1 | 1 | |* 76 | FILTER | | | | | | | | | 77 | NESTED LOOPS | | 1 | 122 | 636 (0)| 00:00:01 | | | | 78 | NESTED LOOPS | | 4 | 122 | 636 (0)| 00:00:01 | | | |* 79 | TABLE ACCESS BY GLOBAL INDEX ROWID BATCHED| MOVEMENT | 1 | 79 | 631 (0)| 00:00:01 | ROWID | ROWID | |* 80 | INDEX RANGE SCAN | IDX_MOV_STATE | 661 | | 6 (0)| 00:00:01 | | | | 81 | PARTITION REFERENCE ITERATOR | | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |* 82 | INDEX RANGE SCAN | IDX_MOVEMENT_MSG_ID | 4 | | 2 (0)| 00:00:01 | KEY | KEY | PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |* 83 | TABLE ACCESS BY LOCAL INDEX ROWID | MOVEMENT_MESSAGE | 4 | 172 | 5 (0)| 00:00:01 | 1 | 1 | |* 84 | FILTER | | | | | | | | | 85 | NESTED LOOPS | | 255 | 31110 | 137K (1)| 00:00:11 | | | | 86 | NESTED LOOPS | | 288 | 31110 | 137K (1)| 00:00:11 | | | |* 87 | TABLE ACCESS BY GLOBAL INDEX ROWID BATCHED| MOVEMENT | 72 | 5688 | 137K (1)| 00:00:11 | ROWID | ROWID | |* 88 | INDEX RANGE SCAN | IDX_MOV_STATE | 145K| | 640 (1)| 00:00:01 | | | | 89 | PARTITION REFERENCE ITERATOR | | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |* 90 | INDEX RANGE SCAN | IDX_MOVEMENT_MSG_ID | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |* 91 | TABLE ACCESS BY LOCAL INDEX ROWID | MOVEMENT_MESSAGE | 4 | 172 | 5 (0)| 00:00:01 | 1 | 1 | |* 92 | FILTER | | | | | | | | | 93 | NESTED LOOPS | | 45 | 5490 | 24503 (1)| 00:00:02 | | | PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 94 | NESTED LOOPS | | 52 | 5490 | 24503 (1)| 00:00:02 | | | |* 95 | TABLE ACCESS BY GLOBAL INDEX ROWID BATCHED| MOVEMENT | 13 | 1027 | 24438 (1)| 00:00:02 | ROWID | ROWID | |* 96 | INDEX RANGE SCAN | IDX_MOV_STATE | 25762 | | 116 (0)| 00:00:01 | | | | 97 | PARTITION REFERENCE ITERATOR | | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |* 98 | INDEX RANGE SCAN | IDX_MOVEMENT_MSG_ID | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |* 99 | TABLE ACCESS BY LOCAL INDEX ROWID | MOVEMENT_MESSAGE | 4 | 172 | 5 (0)| 00:00:01 | 1 | 1 | |*100 | FILTER | | | | | | | | | 101 | NESTED LOOPS | | 1 | 122 | 11 (0)| 00:00:01 | | | | 102 | NESTED LOOPS | | 4 | 122 | 11 (0)| 00:00:01 | | | |*103 | TABLE ACCESS BY GLOBAL INDEX ROWID BATCHED| MOVEMENT | 1 | 79 | 6 (0)| 00:00:01 | ROWID | ROWID | |*104 | INDEX RANGE SCAN | IDX_MOV_STATE | 1 | | 4 (0)| 00:00:01 | | | PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 105 | PARTITION REFERENCE ITERATOR | | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |*106 | INDEX RANGE SCAN | IDX_MOVEMENT_MSG_ID | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |*107 | TABLE ACCESS BY LOCAL INDEX ROWID | MOVEMENT_MESSAGE | 4 | 172 | 5 (0)| 00:00:01 | 1 | 1 | |*108 | FILTER | | | | | | | | | 109 | NESTED LOOPS | | 215 | 26230 | 116K (1)| 00:00:10 | | | | 110 | NESTED LOOPS | | 244 | 26230 | 116K (1)| 00:00:10 | | | |*111 | TABLE ACCESS BY GLOBAL INDEX ROWID BATCHED| MOVEMENT | 61 | 4819 | 115K (1)| 00:00:10 | ROWID | ROWID | |*112 | INDEX RANGE SCAN | IDX_MOV_STATE | 122K| | 539 (1)| 00:00:01 | | | | 113 | PARTITION REFERENCE ITERATOR | | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |*114 | INDEX RANGE SCAN | IDX_MOVEMENT_MSG_ID | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |*115 | TABLE ACCESS BY LOCAL INDEX ROWID | MOVEMENT_MESSAGE | 4 | 172 | 5 (0)| 00:00:01 | 1 | 1 | PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |*116 | FILTER | | | | | | | | | 117 | NESTED LOOPS | | 1005 | 119K| 543K (1)| 00:00:43 | | | | 118 | NESTED LOOPS | | 1140 | 119K| 543K (1)| 00:00:43 | | | |*119 | TABLE ACCESS BY GLOBAL INDEX ROWID BATCHED| MOVEMENT | 285 | 22515 | 542K (1)| 00:00:43 | ROWID | ROWID | |*120 | INDEX RANGE SCAN | IDX_MOV_STATE | 571K| | 2512 (1)| 00:00:01 | | | | 121 | PARTITION REFERENCE ITERATOR | | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |*122 | INDEX RANGE SCAN | IDX_MOVEMENT_MSG_ID | 4 | | 2 (0)| 00:00:01 | KEY | KEY | |*123 | TABLE ACCESS BY LOCAL INDEX ROWID | MOVEMENT_MESSAGE | 4 | 172 | 5 (0)| 00:00:01 | 1 | 1 | ---------------------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------- 4 - filter(SYSDATE@!-2>=SYSDATE@!-180) 7 - filter("STATE_MODIFICATION_DATE" IS NOT NULL AND "DOMAIN"='NCTS' AND EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3) 8 - access("STATE"='Initial' AND "MIN_DATE">=SYSDATE@!-180 AND "MIN_DATE"<=SYSDATE@!-2) 10 - access("ID"="B"."MOVEMENT_ID") 11 - filter("B"."IS_IECA"=0) 12 - filter(SYSDATE@!-2>=SYSDATE@!-180) 15 - filter("STATE_MODIFICATION_DATE" IS NOT NULL AND "DOMAIN"='NCTS' AND EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3 AND (LNNVL("STATE_MODIFICATION_DATE" IS PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- NOT NULL) OR LNNVL("STATE"='Initial') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3))) 16 - access("STATE"='Incidentregistered' AND "MIN_DATE">=SYSDATE@!-180 AND "MIN_DATE"<=SYSDATE@!-2) 18 - access("ID"="B"."MOVEMENT_ID") 19 - filter("B"."IS_IECA"=0) 20 - filter(SYSDATE@!-2>=SYSDATE@!-180) 23 - filter("STATE_MODIFICATION_DATE" IS NOT NULL AND "DOMAIN"='NCTS' AND EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3 AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Initial') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Incidentregistered') OR LNNVL(EXTRACT(DAY FROM PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3))) 24 - access("STATE"='Movementleftsecurityarea' AND "MIN_DATE">=SYSDATE@!-180 AND "MIN_DATE"<=SYSDATE@!-2) 26 - access("ID"="B"."MOVEMENT_ID") 27 - filter("B"."IS_IECA"=0) 28 - filter(SYSDATE@!-2>=SYSDATE@!-180) 31 - filter("STATE_MODIFICATION_DATE" IS NOT NULL AND "DOMAIN"='NCTS' AND EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3 AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Initial') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Incidentregistered') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- NOT NULL) OR LNNVL("STATE"='Movementleftsecurityarea') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3))) 32 - access("STATE"='Notificationcrossingfrontier' AND "MIN_DATE">=SYSDATE@!-180 AND "MIN_DATE"<=SYSDATE@!-2) 34 - access("ID"="B"."MOVEMENT_ID") 35 - filter("B"."IS_IECA"=0) 36 - filter(SYSDATE@!-2>=SYSDATE@!-180) 39 - filter("STATE_MODIFICATION_DATE" IS NOT NULL AND "DOMAIN"='NCTS' AND EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3 AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Initial') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Incidentregistered') OR LNNVL(EXTRACT(DAY FROM PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Movementleftsecurityarea') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Notificationcrossingfrontier') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3))) 40 - access("STATE"='Unknown' AND "MIN_DATE">=SYSDATE@!-180 AND "MIN_DATE"<=SYSDATE@!-2) 42 - access("ID"="B"."MOVEMENT_ID") 43 - filter("B"."IS_IECA"=0) 44 - filter(SYSDATE@!-2>=SYSDATE@!-180) 47 - filter("STATE_MODIFICATION_DATE" IS NOT NULL AND "DOMAIN"='NCTS' AND EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3 AND (LNNVL("STATE_MODIFICATION_DATE" IS PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- NOT NULL) OR LNNVL("STATE"='Initial') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Incidentregistered') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Movementleftsecurityarea') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Notificationcrossingfrontier') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Unknown') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3))) 48 - access("STATE"='Underenquiryprocedure' AND "MIN_DATE">=SYSDATE@!-180 AND "MIN_DATE"<=SYSDATE@!-2) PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 50 - access("ID"="B"."MOVEMENT_ID") 51 - filter("B"."IS_IECA"=0) 52 - filter(SYSDATE@!-2>=SYSDATE@!-180) 55 - filter("STATE_MODIFICATION_DATE" IS NOT NULL AND "DOMAIN"='NCTS' AND EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3 AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Initial') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Incidentregistered') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Movementleftsecurityarea') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- NOT NULL) OR LNNVL("STATE"='Notificationcrossingfrontier') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Unknown') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Underenquiryprocedure') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3))) 56 - access("STATE"='Released' AND "MIN_DATE">=SYSDATE@!-180 AND "MIN_DATE"<=SYSDATE@!-2) 58 - access("ID"="B"."MOVEMENT_ID") 59 - filter("B"."IS_IECA"=0) 60 - filter(SYSDATE@!-2>=SYSDATE@!-180) 63 - filter("STATE_MODIFICATION_DATE" IS NOT NULL AND "DOMAIN"='NCTS' AND EXTRACT(DAY FROM PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3 AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Initial') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Incidentregistered') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Movementleftsecurityarea') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Notificationcrossingfrontier') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Unknown') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- NOT NULL) OR LNNVL("STATE"='Underenquiryprocedure') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Released') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3))) 64 - access("STATE"='Recoveryrecommended' AND "MIN_DATE">=SYSDATE@!-180 AND "MIN_DATE"<=SYSDATE@!-2) 66 - access("ID"="B"."MOVEMENT_ID") 67 - filter("B"."IS_IECA"=0) 68 - filter(SYSDATE@!-2>=SYSDATE@!-180) 71 - filter("STATE_MODIFICATION_DATE" IS NOT NULL AND "DOMAIN"='NCTS' AND EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3 AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Initial') OR LNNVL(EXTRACT(DAY FROM PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Incidentregistered') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Movementleftsecurityarea') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Notificationcrossingfrontier') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Unknown') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Underenquiryprocedure') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- NOT NULL) OR LNNVL("STATE"='Released') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Recoveryrecommended') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3))) 72 - access("STATE"='Arrived' AND "MIN_DATE">=SYSDATE@!-180 AND "MIN_DATE"<=SYSDATE@!-2) 74 - access("ID"="B"."MOVEMENT_ID") 75 - filter("B"."IS_IECA"=0) 76 - filter(SYSDATE@!-2>=SYSDATE@!-180) 79 - filter("STATE_MODIFICATION_DATE" IS NOT NULL AND "DOMAIN"='NCTS' AND EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3 AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Initial') OR LNNVL(EXTRACT(DAY FROM PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Incidentregistered') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Movementleftsecurityarea') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Notificationcrossingfrontier') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Unknown') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Underenquiryprocedure') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- NOT NULL) OR LNNVL("STATE"='Released') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Recoveryrecommended') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Arrived') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3))) 80 - access("STATE"='Underrecoveryprocedure' AND "MIN_DATE">=SYSDATE@!-180 AND "MIN_DATE"<=SYSDATE@!-2) 82 - access("ID"="B"."MOVEMENT_ID") 83 - filter("B"."IS_IECA"=0) 84 - filter(SYSDATE@!-2>=SYSDATE@!-180) 87 - filter("STATE_MODIFICATION_DATE" IS NOT NULL AND "DOMAIN"='ECS' AND EXTRACT(DAY FROM PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3 AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Initial') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Incidentregistered') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Movementleftsecurityarea') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Notificationcrossingfrontier') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Unknown') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Underenquiryprocedure') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Released') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Recoveryrecommended') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Arrived') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Underrecoveryprocedure') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3))) 88 - access("STATE"='Initial' AND "MIN_DATE">=SYSDATE@!-180 AND "MIN_DATE"<=SYSDATE@!-2) PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 90 - access("ID"="B"."MOVEMENT_ID") 91 - filter("B"."IS_IECA"=0) 92 - filter(SYSDATE@!-2>=SYSDATE@!-180) 95 - filter("STATE_MODIFICATION_DATE" IS NOT NULL AND "DOMAIN"='ECS' AND EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3 AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Initial') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Incidentregistered') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Movementleftsecurityarea') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Notificationcrossingfrontier') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Unknown') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Underenquiryprocedure') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Released') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Recoveryrecommended') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Arrived') OR LNNVL(EXTRACT(DAY FROM PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Underrecoveryprocedure') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Initial') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3))) 96 - access("STATE"='UnderExitConfirmationRequest' AND "MIN_DATE">=SYSDATE@!-180 AND "MIN_DATE"<=SYSDATE@!-2) 98 - access("ID"="B"."MOVEMENT_ID") 99 - filter("B"."IS_IECA"=0) 100 - filter(SYSDATE@!-2>=SYSDATE@!-180) 103 - filter("STATE_MODIFICATION_DATE" IS NOT NULL AND "DOMAIN"='ECS' AND EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3 AND (LNNVL("DOMAIN"='NCTS') OR PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Initial') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Incidentregistered') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Movementleftsecurityarea') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Notificationcrossingfrontier') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Unknown') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Underenquiryprocedure') OR LNNVL(EXTRACT(DAY FROM PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Released') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Recoveryrecommended') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Arrived') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Underrecoveryprocedure') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Initial') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- NOT NULL) OR LNNVL("STATE"='UnderExitConfirmationRequest') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3))) 104 - access("STATE"='AwaitingforPCOControlDecision' AND "MIN_DATE">=SYSDATE@!-180 AND "MIN_DATE"<=SYSDATE@!-2) 106 - access("ID"="B"."MOVEMENT_ID") 107 - filter("B"."IS_IECA"=0) 108 - filter(SYSDATE@!-2>=SYSDATE@!-180) 111 - filter("STATE_MODIFICATION_DATE" IS NOT NULL AND "DOMAIN"='ECS' AND EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3 AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Initial') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Incidentregistered') OR LNNVL(EXTRACT(DAY FROM PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Movementleftsecurityarea') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Notificationcrossingfrontier') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Unknown') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Underenquiryprocedure') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Released') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Recoveryrecommended') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Arrived') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Underrecoveryprocedure') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Initial') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='UnderExitConfirmationRequest') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='AwaitingforPCOControlDecision') OR LNNVL(EXTRACT(DAY FROM PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3))) 112 - access("STATE"='ReleasedforExport' AND "MIN_DATE">=SYSDATE@!-180 AND "MIN_DATE"<=SYSDATE@!-2) 114 - access("ID"="B"."MOVEMENT_ID") 115 - filter("B"."IS_IECA"=0) 116 - filter(SYSDATE@!-2>=SYSDATE@!-180) 119 - filter("STATE_MODIFICATION_DATE" IS NOT NULL AND "DOMAIN"='ECS' AND EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3 AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Initial') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Incidentregistered') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Movementleftsecurityarea') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Notificationcrossingfrontier') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Unknown') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Underenquiryprocedure') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Released') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Recoveryrecommended') OR LNNVL(EXTRACT(DAY FROM PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Arrived') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("DOMAIN"='NCTS') OR LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Underrecoveryprocedure') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='Initial') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='UnderExitConfirmationRequest') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS NOT NULL) OR LNNVL("STATE"='AwaitingforPCOControlDecision') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3)) AND (LNNVL("STATE_MODIFICATION_DATE" IS PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- NOT NULL) OR LNNVL("STATE"='ReleasedforExport') OR LNNVL(EXTRACT(DAY FROM (SYSTIMESTAMP(6)-INTERNAL_FUNCTION("STATE_MODIFICATION_DATE"))DAY(9) TO SECOND(6))>=3))) 120 - access("STATE"='Unknown' AND "MIN_DATE">=SYSDATE@!-180 AND "MIN_DATE"<=SYSDATE@!-2) 122 - access("ID"="B"."MOVEMENT_ID") 123 - filter("B"."IS_IECA"=0)