Plan hash value: 1983894226 -------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | -------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | | | | 127K(100)| | | 1 | SORT ORDER BY | | 47823 | 163M| 186M| 127K (1)| 00:00:05 | |* 2 | VIEW | | 47823 | 163M| | 91604 (1)| 00:00:04 | | 3 | WINDOW SORT | | 47823 | 12M| 13M| 91604 (1)| 00:00:04 | |* 4 | FILTER | | | | | | | |* 5 | HASH JOIN RIGHT OUTER | | 47823 | 12M| | 88791 (1)| 00:00:04 | |* 6 | TABLE ACCESS FULL | FO_APPLICATIONROLE | 9 | 234 | | 3 (0)| 00:00:01 | |* 7 | HASH JOIN RIGHT OUTER | | 47823 | 11M| | 88788 (1)| 00:00:04 | |* 8 | TABLE ACCESS FULL | FO_USERROLEMAP | 78365 | 994K| | 248 (2)| 00:00:01 | |* 9 | HASH JOIN RIGHT OUTER | | 47421 | 10M| | 88540 (1)| 00:00:04 | |* 10 | TABLE ACCESS FULL | FO_SYSTEMUSER | 74036 | 939K| | 317 (2)| 00:00:01 | | 11 | NESTED LOOPS OUTER | | 28446 | 6139K| | 88223 (1)| 00:00:04 | |* 12 | HASH JOIN RIGHT OUTER | | 28432 | 5497K| | 31343 (1)| 00:00:02 | |* 13 | TABLE ACCESS FULL | EF_ENTITYADDRESSMAP | 73885 | 1082K| | 283 (2)| 00:00:01 | |* 14 | HASH JOIN RIGHT OUTER | | 24239 | 4331K| | 31059 (1)| 00:00:02 | |* 15 | TABLE ACCESS FULL | FO_APPLICATIONUSER | 468 | 11232 | | 419 (1)| 00:00:01 | |* 16 | HASH JOIN RIGHT OUTER | | 24239 | 3763K| | 30640 (1)| 00:00:02 | |* 17 | TABLE ACCESS FULL | EF_EFILEUSER | 45681 | 1070K| | 177 (2)| 00:00:01 | |* 18 | HASH JOIN | | 24239 | 3195K| | 30462 (1)| 00:00:02 | |* 19 | FILTER | | | | | | | |* 20 | HASH JOIN RIGHT OUTER | | 24238 | 1112K| | 109 (1)| 00:00:01 | |* 21 | TABLE ACCESS FULL | EF_ECFSYSTEMCOURTMAP | 39 | 468 | | 3 (0)| 00:00:01 | |* 22 | TABLE ACCESS FULL | EF_LEGALORGANIZATION | 24238 | 828K| | 106 (1)| 00:00:01 | |* 23 | TABLE ACCESS FULL | FO_ENTITY | 261K| 21M| | 30352 (1)| 00:00:02 | |* 24 | TABLE ACCESS BY INDEX ROWID| FO_ENTITYADDRESS | 1 | 23 | | 2 (0)| 00:00:01 | |* 25 | INDEX UNIQUE SCAN | FO_PK_ENTITYADDRESS | 1 | | | 1 (0)| 00:00:01 | -------------------------------------------------------------------------------------------------------------------- Query Block Name / Object Alias (identified by operation id): ------------------------------------------------------------- 1 - SEL$12 2 - SEL$897A7E7E / PS@SEL$12 3 - SEL$897A7E7E 6 - SEL$897A7E7E / AR@SEL$8 8 - SEL$897A7E7E / URM@SEL$7 10 - SEL$897A7E7E / SU@SEL$5 13 - SEL$897A7E7E / EAM@SEL$3 15 - SEL$897A7E7E / AU@SEL$6 17 - SEL$897A7E7E / EU@SEL$1 21 - SEL$897A7E7E / CM@SEL$9 22 - SEL$897A7E7E / LO@SEL$1 23 - SEL$897A7E7E / E@SEL$2 24 - SEL$897A7E7E / AD@SEL$4 25 - SEL$897A7E7E / AD@SEL$4 Outline Data ------------- /*+ BEGIN_OUTLINE_DATA IGNORE_OPTIM_EMBEDDED_HINTS OPTIMIZER_FEATURES_ENABLE('12.1.0.2') DB_VERSION('12.1.0.2') OPT_PARAM('query_rewrite_enabled' 'false') FIRST_ROWS(1) OUTLINE_LEAF(@"SEL$897A7E7E") MERGE(@"SEL$C3E5619C") OUTLINE_LEAF(@"SEL$12") OUTLINE(@"SEL$11") OUTLINE(@"SEL$C3E5619C") MERGE(@"SEL$0D6D1508") OUTLINE(@"SEL$59D20EB4") ANSI_REARCH(@"SEL$10") OUTLINE(@"SEL$0D6D1508") MERGE(@"SEL$436CFC2C") OUTLINE(@"SEL$10") OUTLINE(@"SEL$29E7344E") ANSI_REARCH(@"SEL$493132A6") OUTLINE(@"SEL$436CFC2C") MERGE(@"SEL$212F8361") OUTLINE(@"SEL$493132A6") ANSI_REARCH(@"SEL$9") OUTLINE(@"SEL$7B577B65") ANSI_REARCH(@"SEL$EA807912") OUTLINE(@"SEL$212F8361") MERGE(@"SEL$6005BC06") OUTLINE(@"SEL$9") OUTLINE(@"SEL$EA807912") ANSI_REARCH(@"SEL$8") OUTLINE(@"SEL$6102772B") ANSI_REARCH(@"SEL$7677A73B") OUTLINE(@"SEL$6005BC06") MERGE(@"SEL$A686031D") OUTLINE(@"SEL$8") OUTLINE(@"SEL$7677A73B") ANSI_REARCH(@"SEL$7") OUTLINE(@"SEL$032E7E1A") ANSI_REARCH(@"SEL$AC8D8578") OUTLINE(@"SEL$A686031D") MERGE(@"SEL$2B0EA4D0") OUTLINE(@"SEL$7") OUTLINE(@"SEL$AC8D8578") ANSI_REARCH(@"SEL$6") OUTLINE(@"SEL$68F3DD2C") ANSI_REARCH(@"SEL$3FC9472D") OUTLINE(@"SEL$2B0EA4D0") MERGE(@"SEL$636336C3") OUTLINE(@"SEL$6") OUTLINE(@"SEL$3FC9472D") ANSI_REARCH(@"SEL$5") OUTLINE(@"SEL$A235E16A") ANSI_REARCH(@"SEL$E6E74641") OUTLINE(@"SEL$636336C3") MERGE(@"SEL$2BFA4EE4") OUTLINE(@"SEL$5") OUTLINE(@"SEL$E6E74641") ANSI_REARCH(@"SEL$4") OUTLINE(@"SEL$006708EA") ANSI_REARCH(@"SEL$3") OUTLINE(@"SEL$2BFA4EE4") MERGE(@"SEL$8812AA4E") OUTLINE(@"SEL$4") OUTLINE(@"SEL$3") OUTLINE(@"SEL$948754D7") ANSI_REARCH(@"SEL$2") OUTLINE(@"SEL$8812AA4E") ANSI_REARCH(@"SEL$1") OUTLINE(@"SEL$2") OUTLINE(@"SEL$1") NO_ACCESS(@"SEL$12" "PS"@"SEL$12") FULL(@"SEL$897A7E7E" "LO"@"SEL$1") FULL(@"SEL$897A7E7E" "CM"@"SEL$9") FULL(@"SEL$897A7E7E" "E"@"SEL$2") FULL(@"SEL$897A7E7E" "EU"@"SEL$1") FULL(@"SEL$897A7E7E" "AU"@"SEL$6") FULL(@"SEL$897A7E7E" "EAM"@"SEL$3") INDEX_RS_ASC(@"SEL$897A7E7E" "AD"@"SEL$4" ("FO_ENTITYADDRESS"."ENTITYADDRESSID")) FULL(@"SEL$897A7E7E" "SU"@"SEL$5") FULL(@"SEL$897A7E7E" "URM"@"SEL$7") FULL(@"SEL$897A7E7E" "AR"@"SEL$8") LEADING(@"SEL$897A7E7E" "LO"@"SEL$1" "CM"@"SEL$9" "E"@"SEL$2" "EU"@"SEL$1" "AU"@"SEL$6" "EAM"@"SEL$3" "AD"@"SEL$4" "SU"@"SEL$5" "URM"@"SEL$7" "AR"@"SEL$8") USE_HASH(@"SEL$897A7E7E" "CM"@"SEL$9") USE_HASH(@"SEL$897A7E7E" "E"@"SEL$2") USE_HASH(@"SEL$897A7E7E" "EU"@"SEL$1") USE_HASH(@"SEL$897A7E7E" "AU"@"SEL$6") USE_HASH(@"SEL$897A7E7E" "EAM"@"SEL$3") USE_NL(@"SEL$897A7E7E" "AD"@"SEL$4") USE_HASH(@"SEL$897A7E7E" "SU"@"SEL$5") USE_HASH(@"SEL$897A7E7E" "URM"@"SEL$7") USE_HASH(@"SEL$897A7E7E" "AR"@"SEL$8") SWAP_JOIN_INPUTS(@"SEL$897A7E7E" "CM"@"SEL$9") SWAP_JOIN_INPUTS(@"SEL$897A7E7E" "EU"@"SEL$1") SWAP_JOIN_INPUTS(@"SEL$897A7E7E" "AU"@"SEL$6") SWAP_JOIN_INPUTS(@"SEL$897A7E7E" "EAM"@"SEL$3") SWAP_JOIN_INPUTS(@"SEL$897A7E7E" "SU"@"SEL$5") SWAP_JOIN_INPUTS(@"SEL$897A7E7E" "URM"@"SEL$7") SWAP_JOIN_INPUTS(@"SEL$897A7E7E" "AR"@"SEL$8") END_OUTLINE_DATA */ Peeked Binds (identified by position): -------------------------------------- 13 - :SYS_B_12 (VARCHAR2(30), CSID=873): 'Y' 14 - :SYS_B_13 (VARCHAR2(30), CSID=873): 'Y' 15 - :SYS_B_14 (VARCHAR2(30), CSID=873): 'Y' 16 - :SYS_B_15 (VARCHAR2(30), CSID=873): 'Y' 17 - :SYS_B_16 (VARCHAR2(30), CSID=873): 'Y' 19 - :SYS_B_18 (VARCHAR2(30), CSID=873): 'Y' 20 - :SYS_B_19 (VARCHAR2(30), CSID=873): 'Y' 21 - :SYS_B_20 (VARCHAR2(30), CSID=873): 'Y' 24 - :SYS_B_23 (VARCHAR2(30), CSID=873): '%test%' 26 - :SYS_B_25 (VARCHAR2(30), CSID=873): 'Y' 27 - :SYS_B_26 (NUMBER): 90083 Predicate Information (identified by operation id): --------------------------------------------------- 2 - filter(("ROWNUMBER">=:SYS_B_29 AND "ROWNUMBER"<=:SYS_B_30)) 4 - filter((:SYS_B_30>=:SYS_B_29 AND :SYS_B_21=:SYS_B_22)) 5 - access("AR"."APPLICATIONROLEID"="URM"."APPLICATIONROLEID") 6 - filter(NLSSORT(INTERNAL_FUNCTION("ACTIVEFLAG"),'nls_sort=''BINARY_CI''')=NLSSORT(:SYS_B_19,'nls_sort= ''BINARY_CI''')) 7 - access("URM"."SYSTEMUSERID"="SU"."SYSTEMUSERID") 8 - filter(NLSSORT(INTERNAL_FUNCTION("ACTIVEFLAG"),'nls_sort=''BINARY_CI''')=NLSSORT(:SYS_B_18,'nls_sort= ''BINARY_CI''')) 9 - access("SU"."APPLICATIONUSERID"="EU"."APPLICATIONUSERID") 10 - filter(NLSSORT(INTERNAL_FUNCTION("ACTIVEFLAG"),'nls_sort=''BINARY_CI''')=NLSSORT(:SYS_B_16,'nls_sort= ''BINARY_CI''')) 12 - access("EAM"."ENTITYID"="LO"."ENTITYID") 13 - filter(NLSSORT(INTERNAL_FUNCTION("ACTIVEFLAG"),'nls_sort=''BINARY_CI''')=NLSSORT(:SYS_B_14,'nls_sort= ''BINARY_CI''')) 14 - access("AU"."APPLICATIONUSERID"="EU"."APPLICATIONUSERID") 15 - filter(NLSSORT(INTERNAL_FUNCTION("AU"."ACTIVEFLAG"),'nls_sort=''BINARY_CI''')=NLSSORT(:SYS_B_17,'nls_ sort=''BINARY_CI''')) 16 - access("EU"."ENTITYID"="LO"."ENTITYID") 17 - filter(NLSSORT(INTERNAL_FUNCTION("ACTIVEFLAG"),'nls_sort=''BINARY_CI''')=NLSSORT(:SYS_B_12,'nls_sort= ''BINARY_CI''')) 18 - access("E"."ENTITYID"="LO"."ENTITYID") 19 - filter(("CM"."COURTID"=:SYS_B_24 OR "LO"."ECFSYSTEMID" IS NULL)) 20 - access("CM"."ECFSYSTEMID"="LO"."ECFSYSTEMID") 21 - filter(NLSSORT(INTERNAL_FUNCTION("ACTIVEFLAG"),'nls_sort=''BINARY_CI''')=NLSSORT(:SYS_B_20,'nls_sort= ''BINARY_CI''')) 22 - filter(("LO"."LEGALORGANIZATIONTYPECODE"=:SYS_B_26 AND NLSSORT(INTERNAL_FUNCTION("ACTIVEFLAG"),'nls_sort=''BINARY_CI''')=NLSSORT(:SYS_B_25,'nls_sort=''BINARY_CI''' ))) 23 - filter(("E"."LASTNAME" LIKE :SYS_B_23 AND NLSSORT(INTERNAL_FUNCTION("ACTIVEFLAG"),'nls_sort=''BINARY_ CI''')=NLSSORT(:SYS_B_13,'nls_sort=''BINARY_CI'''))) 24 - filter(NLSSORT(INTERNAL_FUNCTION("ACTIVEFLAG"),'nls_sort=''BINARY_CI''')=NLSSORT(:SYS_B_15,'nls_sort= ''BINARY_CI''')) 25 - access("AD"."ENTITYADDRESSID"="EAM"."ENTITYADDRESSID") Column Projection Information (identified by operation id): ----------------------------------------------------------- 1 - (#keys=1) "PS"."ROWNUMBER"[NUMBER,22], "PS"."EFILEUSERID"[NUMBER,22], "PS"."REPRESENTERID"[NUMBER,22], "PS"."ACTIVEFLAG"[CHARACTER,1], "PS"."FIRSTNAME"[VARCHAR2,1000], "PS"."MIDDLENAME"[VARCHAR2,1000], "PS"."LASTNAME"[VARCHAR2,1000], "PS"."PREFIX"[VARCHAR2,80], "PS"."SUFFIX"[VARCHAR2,80], "PS"."IDENTIFICATIONNUMBER"[VARCHAR2,100], "PS"."ENTITYID"[NUMBER,22], "PS"."ENTITYADDRESSID"[NUMBER,22], "PS"."LINE1"[VARCHAR2,400], "PS"."APPLICATIONROLEID"[NUMBER,22], "PS"."APPLICATIONROLENAME"[VARCHAR2,1000], "PS"."SORTNAME"[VARCHAR2,1000], "PS"."DISPLAYNAME"[VARCHAR2,1000], "PS"."USERNAME"[VARCHAR2,250], "PS"."REPRESENTERTYPECODE"[NUMBER,22], "PS"."EFILEREGISTEREDFLAG"[CHARACTER,1], "PS"."TOTALROWS"[NUMBER,22] 2 - "PS"."EFILEUSERID"[NUMBER,22], "PS"."REPRESENTERID"[NUMBER,22], "PS"."ACTIVEFLAG"[CHARACTER,1], "PS"."FIRSTNAME"[VARCHAR2,1000], "PS"."MIDDLENAME"[VARCHAR2,1000], "PS"."LASTNAME"[VARCHAR2,1000], "PS"."PREFIX"[VARCHAR2,80], "PS"."SUFFIX"[VARCHAR2,80], "PS"."IDENTIFICATIONNUMBER"[VARCHAR2,100], "PS"."ENTITYID"[NUMBER,22], "PS"."ENTITYADDRESSID"[NUMBER,22], "PS"."LINE1"[VARCHAR2,400], "PS"."APPLICATIONROLEID"[NUMBER,22], "PS"."APPLICATIONROLENAME"[VARCHAR2,1000], "PS"."SORTNAME"[VARCHAR2,1000], "PS"."DISPLAYNAME"[VARCHAR2,1000], "PS"."USERNAME"[VARCHAR2,250], "PS"."REPRESENTERTYPECODE"[NUMBER,22], "PS"."EFILEREGISTEREDFLAG"[CHARACTER,1], "ROWNUMBER"[NUMBER,22], "PS"."TOTALROWS"[NUMBER,22] 3 - (#keys=1) NLSSORT("E"."SORTNAME",'nls_sort=''BINARY_CI''')[2000], "AR"."APPLICATIONROLEID"[NUMBER,22], "URM"."APPLICATIONROLEID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "AR"."APPLICATIONROLENAME"[VARCHAR2,1000], "URM"."SYSTEMUSERID"[NUMBER,22], "SU"."SYSTEMUSERID"[NUMBER,22], "AD"."ENTITYADDRESSID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "SU"."APPLICATIONUSERID"[NUMBER,22], "EU"."APPLICATIONUSERID"[NUMBER,22], "AD"."LINE1"[VARCHAR2,400], "ACTIVEFLAG"[CHARACTER,1], "EAM"."ENTITYID"[NUMBER,22], "LO"."ENTITYID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "EAM"."ENTITYADDRESSID"[NUMBER,22], "AU"."APPLICATIONUSERID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "AU"."DISPLAYNAME"[VARCHAR2,250], "AU"."ACTIVEFLAG"[CHARACTER,1], "EU"."ENTITYID"[NUMBER,22], "E"."SUFFIX"[VARCHAR2,80], "EU"."EFILEUSERID"[NUMBER,22], "E"."DISPLAYNAME"[VARCHAR2,1000], "ACTIVEFLAG"[CHARACTER,1], "EU"."EFILEUSERSTATUSCODE"[NUMBER,22], "E"."SORTNAME"[VARCHAR2,1000], "E"."ENTITYID"[NUMBER,22], "CM"."ECFSYSTEMID"[NUMBER,22], "LO"."ECFSYSTEMID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "CM"."COURTID"[NUMBER,22], "LO"."LEGALORGANIZATIONID"[NUMBER,22], "LO"."LEGALORGANIZATIONTYPECODE"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "ACTIVEFLAG"[CHARACTER,1], "E"."LASTNAME"[VARCHAR2,1000], "E"."FIRSTNAME"[VARCHAR2,1000], "E"."MIDDLENAME"[VARCHAR2,1000], "E"."PREFIX"[VARCHAR2,80], "AD".ROWID[ROWID,10], COUNT(*) OVER ()[22], ROW_NUMBER() OVER ( ORDER BY "E"."SORTNAME")[22] 4 - "AR"."APPLICATIONROLEID"[NUMBER,22], "URM"."APPLICATIONROLEID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "AR"."APPLICATIONROLENAME"[VARCHAR2,1000], "URM"."SYSTEMUSERID"[NUMBER,22], "SU"."SYSTEMUSERID"[NUMBER,22], "AD"."ENTITYADDRESSID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "SU"."APPLICATIONUSERID"[NUMBER,22], "EU"."APPLICATIONUSERID"[NUMBER,22], "AD"."LINE1"[VARCHAR2,400], "ACTIVEFLAG"[CHARACTER,1], "EAM"."ENTITYID"[NUMBER,22], "LO"."ENTITYID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "EAM"."ENTITYADDRESSID"[NUMBER,22], "AU"."APPLICATIONUSERID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "AU"."DISPLAYNAME"[VARCHAR2,250], "AU"."ACTIVEFLAG"[CHARACTER,1], "EU"."ENTITYID"[NUMBER,22], "E"."SUFFIX"[VARCHAR2,80], "EU"."EFILEUSERID"[NUMBER,22], "E"."DISPLAYNAME"[VARCHAR2,1000], "ACTIVEFLAG"[CHARACTER,1], "EU"."EFILEUSERSTATUSCODE"[NUMBER,22], "E"."SORTNAME"[VARCHAR2,1000], "E"."ENTITYID"[NUMBER,22], "CM"."ECFSYSTEMID"[NUMBER,22], "LO"."ECFSYSTEMID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "CM"."COURTID"[NUMBER,22], "LO"."LEGALORGANIZATIONID"[NUMBER,22], "LO"."LEGALORGANIZATIONTYPECODE"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "ACTIVEFLAG"[CHARACTER,1], "E"."LASTNAME"[VARCHAR2,1000], "E"."FIRSTNAME"[VARCHAR2,1000], "E"."MIDDLENAME"[VARCHAR2,1000], "E"."PREFIX"[VARCHAR2,80], "AD".ROWID[ROWID,10] 5 - (#keys=1) "AR"."APPLICATIONROLEID"[NUMBER,22], "URM"."APPLICATIONROLEID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "AR"."APPLICATIONROLENAME"[VARCHAR2,1000], "URM"."SYSTEMUSERID"[NUMBER,22], "SU"."SYSTEMUSERID"[NUMBER,22], "AD"."ENTITYADDRESSID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "SU"."APPLICATIONUSERID"[NUMBER,22], "EU"."APPLICATIONUSERID"[NUMBER,22], "AD"."LINE1"[VARCHAR2,400], "ACTIVEFLAG"[CHARACTER,1], "EAM"."ENTITYID"[NUMBER,22], "LO"."ENTITYID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "EAM"."ENTITYADDRESSID"[NUMBER,22], "AU"."APPLICATIONUSERID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "AU"."DISPLAYNAME"[VARCHAR2,250], "AU"."ACTIVEFLAG"[CHARACTER,1], "EU"."ENTITYID"[NUMBER,22], "E"."SUFFIX"[VARCHAR2,80], "EU"."EFILEUSERID"[NUMBER,22], "E"."DISPLAYNAME"[VARCHAR2,1000], "ACTIVEFLAG"[CHARACTER,1], "EU"."EFILEUSERSTATUSCODE"[NUMBER,22], "E"."SORTNAME"[VARCHAR2,1000], "E"."ENTITYID"[NUMBER,22], "CM"."ECFSYSTEMID"[NUMBER,22], "LO"."ECFSYSTEMID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "CM"."COURTID"[NUMBER,22], "LO"."LEGALORGANIZATIONID"[NUMBER,22], "LO"."LEGALORGANIZATIONTYPECODE"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "ACTIVEFLAG"[CHARACTER,1], "E"."LASTNAME"[VARCHAR2,1000], "E"."FIRSTNAME"[VARCHAR2,1000], "E"."MIDDLENAME"[VARCHAR2,1000], "E"."PREFIX"[VARCHAR2,80], "AD".ROWID[ROWID,10] 6 - "AR"."APPLICATIONROLEID"[NUMBER,22], "AR"."APPLICATIONROLENAME"[VARCHAR2,1000], "ACTIVEFLAG"[CHARACTER,1] 7 - (#keys=1) "URM"."SYSTEMUSERID"[NUMBER,22], "SU"."SYSTEMUSERID"[NUMBER,22], "URM"."APPLICATIONROLEID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "SU"."APPLICATIONUSERID"[NUMBER,22], "EU"."APPLICATIONUSERID"[NUMBER,22], "AD"."LINE1"[VARCHAR2,400], "ACTIVEFLAG"[CHARACTER,1], "EAM"."ENTITYID"[NUMBER,22], "LO"."ENTITYID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "EAM"."ENTITYADDRESSID"[NUMBER,22], "AU"."APPLICATIONUSERID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "AU"."DISPLAYNAME"[VARCHAR2,250], "AU"."ACTIVEFLAG"[CHARACTER,1], "EU"."ENTITYID"[NUMBER,22], "E"."SUFFIX"[VARCHAR2,80], "EU"."EFILEUSERID"[NUMBER,22], "E"."DISPLAYNAME"[VARCHAR2,1000], "ACTIVEFLAG"[CHARACTER,1], "EU"."EFILEUSERSTATUSCODE"[NUMBER,22], "E"."SORTNAME"[VARCHAR2,1000], "E"."ENTITYID"[NUMBER,22], "CM"."ECFSYSTEMID"[NUMBER,22], "LO"."ECFSYSTEMID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "CM"."COURTID"[NUMBER,22], "LO"."LEGALORGANIZATIONID"[NUMBER,22], "LO"."LEGALORGANIZATIONTYPECODE"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "ACTIVEFLAG"[CHARACTER,1], "E"."LASTNAME"[VARCHAR2,1000], "E"."FIRSTNAME"[VARCHAR2,1000], "E"."MIDDLENAME"[VARCHAR2,1000], "E"."PREFIX"[VARCHAR2,80], "AD".ROWID[ROWID,10], "AD"."ENTITYADDRESSID"[NUMBER,22] 8 - "URM"."APPLICATIONROLEID"[NUMBER,22], "URM"."SYSTEMUSERID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1] 9 - (#keys=1) "SU"."APPLICATIONUSERID"[NUMBER,22], "EU"."APPLICATIONUSERID"[NUMBER,22], "SU"."SYSTEMUSERID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "EAM"."ENTITYID"[NUMBER,22], "LO"."ENTITYID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "EAM"."ENTITYADDRESSID"[NUMBER,22], "AU"."APPLICATIONUSERID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "AU"."DISPLAYNAME"[VARCHAR2,250], "AU"."ACTIVEFLAG"[CHARACTER,1], "EU"."ENTITYID"[NUMBER,22], "E"."SUFFIX"[VARCHAR2,80], "EU"."EFILEUSERID"[NUMBER,22], "E"."DISPLAYNAME"[VARCHAR2,1000], "ACTIVEFLAG"[CHARACTER,1], "EU"."EFILEUSERSTATUSCODE"[NUMBER,22], "E"."SORTNAME"[VARCHAR2,1000], "E"."ENTITYID"[NUMBER,22], "CM"."ECFSYSTEMID"[NUMBER,22], "LO"."ECFSYSTEMID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "CM"."COURTID"[NUMBER,22], "LO"."LEGALORGANIZATIONID"[NUMBER,22], "LO"."LEGALORGANIZATIONTYPECODE"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "ACTIVEFLAG"[CHARACTER,1], "E"."LASTNAME"[VARCHAR2,1000], "E"."FIRSTNAME"[VARCHAR2,1000], "E"."MIDDLENAME"[VARCHAR2,1000], "E"."PREFIX"[VARCHAR2,80], "AD".ROWID[ROWID,10], "AD"."ENTITYADDRESSID"[NUMBER,22], "AD"."LINE1"[VARCHAR2,400] 10 - "SU"."SYSTEMUSERID"[NUMBER,22], "SU"."APPLICATIONUSERID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1] 11 - "EAM"."ENTITYID"[NUMBER,22], "LO"."ENTITYID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "EAM"."ENTITYADDRESSID"[NUMBER,22], "AU"."APPLICATIONUSERID"[NUMBER,22], "EU"."APPLICATIONUSERID"[NUMBER,22], "AU"."DISPLAYNAME"[VARCHAR2,250], "AU"."ACTIVEFLAG"[CHARACTER,1], "EU"."ENTITYID"[NUMBER,22], "E"."SUFFIX"[VARCHAR2,80], "EU"."EFILEUSERID"[NUMBER,22], "E"."DISPLAYNAME"[VARCHAR2,1000], "ACTIVEFLAG"[CHARACTER,1], "EU"."EFILEUSERSTATUSCODE"[NUMBER,22], "E"."SORTNAME"[VARCHAR2,1000], "E"."ENTITYID"[NUMBER,22], "CM"."ECFSYSTEMID"[NUMBER,22], "LO"."ECFSYSTEMID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "CM"."COURTID"[NUMBER,22], "LO"."LEGALORGANIZATIONID"[NUMBER,22], "LO"."LEGALORGANIZATIONTYPECODE"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "ACTIVEFLAG"[CHARACTER,1], "E"."LASTNAME"[VARCHAR2,1000], "E"."FIRSTNAME"[VARCHAR2,1000], "E"."MIDDLENAME"[VARCHAR2,1000], "E"."PREFIX"[VARCHAR2,80], "AD".ROWID[ROWID,10], "AD"."ENTITYADDRESSID"[NUMBER,22], "AD"."LINE1"[VARCHAR2,400], "ACTIVEFLAG"[CHARACTER,1] 12 - (#keys=1) "EAM"."ENTITYID"[NUMBER,22], "LO"."ENTITYID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "EAM"."ENTITYADDRESSID"[NUMBER,22], "AU"."APPLICATIONUSERID"[NUMBER,22], "EU"."APPLICATIONUSERID"[NUMBER,22], "AU"."DISPLAYNAME"[VARCHAR2,250], "AU"."ACTIVEFLAG"[CHARACTER,1], "EU"."ENTITYID"[NUMBER,22], "E"."SUFFIX"[VARCHAR2,80], "EU"."EFILEUSERID"[NUMBER,22], "E"."DISPLAYNAME"[VARCHAR2,1000], "ACTIVEFLAG"[CHARACTER,1], "EU"."EFILEUSERSTATUSCODE"[NUMBER,22], "E"."SORTNAME"[VARCHAR2,1000], "E"."ENTITYID"[NUMBER,22], "CM"."ECFSYSTEMID"[NUMBER,22], "LO"."ECFSYSTEMID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "CM"."COURTID"[NUMBER,22], "LO"."LEGALORGANIZATIONID"[NUMBER,22], "LO"."LEGALORGANIZATIONTYPECODE"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "ACTIVEFLAG"[CHARACTER,1], "E"."LASTNAME"[VARCHAR2,1000], "E"."FIRSTNAME"[VARCHAR2,1000], "E"."MIDDLENAME"[VARCHAR2,1000], "E"."PREFIX"[VARCHAR2,80] 13 - "EAM"."ENTITYID"[NUMBER,22], "EAM"."ENTITYADDRESSID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1] 14 - (#keys=1) "AU"."APPLICATIONUSERID"[NUMBER,22], "EU"."APPLICATIONUSERID"[NUMBER,22], "AU"."DISPLAYNAME"[VARCHAR2,250], "AU"."ACTIVEFLAG"[CHARACTER,1], "EU"."ENTITYID"[NUMBER,22], "LO"."ENTITYID"[NUMBER,22], "EU"."EFILEUSERID"[NUMBER,22], "E"."DISPLAYNAME"[VARCHAR2,1000], "ACTIVEFLAG"[CHARACTER,1], "EU"."EFILEUSERSTATUSCODE"[NUMBER,22], "E"."SORTNAME"[VARCHAR2,1000], "E"."ENTITYID"[NUMBER,22], "CM"."ECFSYSTEMID"[NUMBER,22], "LO"."ECFSYSTEMID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "CM"."COURTID"[NUMBER,22], "LO"."LEGALORGANIZATIONID"[NUMBER,22], "LO"."LEGALORGANIZATIONTYPECODE"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "ACTIVEFLAG"[CHARACTER,1], "E"."LASTNAME"[VARCHAR2,1000], "E"."FIRSTNAME"[VARCHAR2,1000], "E"."MIDDLENAME"[VARCHAR2,1000], "E"."PREFIX"[VARCHAR2,80], "E"."SUFFIX"[VARCHAR2,80] 15 - "AU"."APPLICATIONUSERID"[NUMBER,22], "AU"."ACTIVEFLAG"[CHARACTER,1], "AU"."DISPLAYNAME"[VARCHAR2,250] 16 - (#keys=1) "EU"."ENTITYID"[NUMBER,22], "LO"."ENTITYID"[NUMBER,22], "EU"."EFILEUSERID"[NUMBER,22], "EU"."APPLICATIONUSERID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "EU"."EFILEUSERSTATUSCODE"[NUMBER,22], "E"."SORTNAME"[VARCHAR2,1000], "E"."ENTITYID"[NUMBER,22], "CM"."ECFSYSTEMID"[NUMBER,22], "LO"."ECFSYSTEMID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "CM"."COURTID"[NUMBER,22], "LO"."LEGALORGANIZATIONID"[NUMBER,22], "LO"."LEGALORGANIZATIONTYPECODE"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "ACTIVEFLAG"[CHARACTER,1], "E"."LASTNAME"[VARCHAR2,1000], "E"."FIRSTNAME"[VARCHAR2,1000], "E"."MIDDLENAME"[VARCHAR2,1000], "E"."PREFIX"[VARCHAR2,80], "E"."SUFFIX"[VARCHAR2,80], "E"."DISPLAYNAME"[VARCHAR2,1000] 17 - "EU"."EFILEUSERID"[NUMBER,22], "EU"."APPLICATIONUSERID"[NUMBER,22], "EU"."ENTITYID"[NUMBER,22], "EU"."EFILEUSERSTATUSCODE"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1] 18 - (#keys=1) "LO"."ENTITYID"[NUMBER,22], "E"."ENTITYID"[NUMBER,22], "CM"."ECFSYSTEMID"[NUMBER,22], "LO"."ECFSYSTEMID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "CM"."COURTID"[NUMBER,22], "LO"."LEGALORGANIZATIONID"[NUMBER,22], "LO"."LEGALORGANIZATIONTYPECODE"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "ACTIVEFLAG"[CHARACTER,1], "E"."LASTNAME"[VARCHAR2,1000], "E"."FIRSTNAME"[VARCHAR2,1000], "E"."MIDDLENAME"[VARCHAR2,1000], "E"."PREFIX"[VARCHAR2,80], "E"."SUFFIX"[VARCHAR2,80], "E"."DISPLAYNAME"[VARCHAR2,1000], "E"."SORTNAME"[VARCHAR2,1000] 19 - "CM"."ECFSYSTEMID"[NUMBER,22], "LO"."ECFSYSTEMID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "CM"."COURTID"[NUMBER,22], "LO"."LEGALORGANIZATIONID"[NUMBER,22], "LO"."ENTITYID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "LO"."LEGALORGANIZATIONTYPECODE"[NUMBER,22] 20 - (#keys=1) "CM"."ECFSYSTEMID"[NUMBER,22], "LO"."ECFSYSTEMID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "CM"."COURTID"[NUMBER,22], "LO"."LEGALORGANIZATIONID"[NUMBER,22], "LO"."ENTITYID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1], "LO"."LEGALORGANIZATIONTYPECODE"[NUMBER,22] 21 - "CM"."ECFSYSTEMID"[NUMBER,22], "CM"."COURTID"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1] 22 - "LO"."LEGALORGANIZATIONID"[NUMBER,22], "LO"."ENTITYID"[NUMBER,22], "LO"."ECFSYSTEMID"[NUMBER,22], "LO"."LEGALORGANIZATIONTYPECODE"[NUMBER,22], "ACTIVEFLAG"[CHARACTER,1] 23 - "E"."ENTITYID"[NUMBER,22], "E"."LASTNAME"[VARCHAR2,1000], "E"."FIRSTNAME"[VARCHAR2,1000], "E"."MIDDLENAME"[VARCHAR2,1000], "E"."PREFIX"[VARCHAR2,80], "E"."SUFFIX"[VARCHAR2,80], "E"."DISPLAYNAME"[VARCHAR2,1000], "E"."SORTNAME"[VARCHAR2,1000], "ACTIVEFLAG"[CHARACTER,1] 24 - "AD".ROWID[ROWID,10], "AD"."ENTITYADDRESSID"[NUMBER,22], "AD"."LINE1"[VARCHAR2,400], "ACTIVEFLAG"[CHARACTER,1] 25 - "AD".ROWID[ROWID,10], "AD"."ENTITYADDRESSID"[NUMBER,22]