Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --------------------------------------------------------------------------------------------------------------------------------------------
- | Id | Operation | Name | ROWS | Bytes | Cost (%CPU)| Pstart| Pstop |
- --------------------------------------------------------------------------------------------------------------------------------------------
- | 0 | SELECT STATEMENT | | 1 | 8138 | 5208 (2)| | |
- | 1 | NESTED LOOPS | | 1 | 8138 | 5208 (2)| | |
- | 2 | NESTED LOOPS | | 1 | 8130 | 5207 (2)| | |
- | 3 | NESTED LOOPS | | 1 | 8105 | 5206 (2)| | |
- | 4 | NESTED LOOPS | | 1 | 8100 | 5206 (2)| | |
- | 5 | NESTED LOOPS | | 1 | 8084 | 5205 (2)| | |
- | 6 | NESTED LOOPS | | 1 | 8074 | 5203 (2)| | |
- | 7 | NESTED LOOPS | | 1 | 8045 | 5202 (2)| | |
- | 8 | NESTED LOOPS | | 1 | 8040 | 5201 (2)| | |
- | 9 | NESTED LOOPS | | 1 | 8035 | 5201 (2)| | |
- | 10 | NESTED LOOPS | | 1 | 8021 | 5200 (2)| | |
- | 11 | FAST DUAL | | 1 | | 2 (0)| | |
- | 12 | VIEW | | 1 | 8021 | 5198 (2)| | |
- |* 13 | FILTER | | | | | | |
- | 14 | SORT GROUP BY PIVOT | | 1 | 141 | 5198 (2)| | |
- |* 15 | HASH JOIN | | 6252 | 860K| 5197 (2)| | |
- |* 16 | HASH JOIN | | 4399 | 554K| 2283 (1)| | |
- |* 17 | TABLE ACCESS FULL | CS_KB_ELEMENT_TYPES_TL | 60 | 1500 | 4 (0)| | |
- | 18 | NESTED LOOPS | | 4399 | 446K| 2279 (1)| | |
- |* 19 | HASH JOIN | | 4399 | 425K| 2278 (1)| | |
- |* 20 | HASH JOIN | | 13198 | 1069K| 1245 (1)| | |
- | 21 | NESTED LOOPS | | | | | | |
- | 22 | NESTED LOOPS | | 1241 | 90593 | 988 (1)| | |
- | 23 | NESTED LOOPS | | 873 | 41904 | 114 (0)| | |
- | 24 | NESTED LOOPS | | 1 | 34 | 4 (0)| | |
- |* 25 | TABLE ACCESS BY INDEX ROWID | CS_KB_SET_TYPES_TL | 1 | 29 | 4 (0)| | |
- |* 26 | INDEX SKIP SCAN | CS_KB_SET_TYPES_TL_U1 | 6 | | 1 (0)| | |
- |* 27 | INDEX UNIQUE SCAN | CS_KB_SET_TYPES_B_U1 | 1 | 5 | 0 (0)| | |
- |* 28 | TABLE ACCESS BY INDEX ROWID | CS_KB_SETS_B | 1164 | 16296 | 110 (0)| | |
- |* 29 | INDEX RANGE SCAN | CS_KB_SETS_B_N1 | 5588 | | 17 (0)| | |
- |* 30 | INDEX UNIQUE SCAN | CS_KB_SETS_TL_U1 | 1 | | 0 (0)| | |
- | 31 | TABLE ACCESS BY INDEX ROWID | CS_KB_SETS_TL | 1 | 25 | 1 (0)| | |
- | 32 | INDEX FAST FULL SCAN | CS_KB_SET_ELES_U1 | 297K| 2902K| 254 (2)| | |
- |* 33 | TABLE ACCESS FULL | CS_KB_ELEMENTS_B | 88313 | 1379K| 1032 (1)| | |
- |* 34 | INDEX UNIQUE SCAN | CS_KB_ELEMENT_TYPES_B_U1 | 1 | 5 | 0 (0)| | |
- |* 35 | TABLE ACCESS FULL | CS_KB_ELEMENTS_TL | 264K| 3104K| 2911 (2)| | |
- |* 36 | TABLE ACCESS BY INDEX ROWID | CS_KB_SETS_B | 1 | 14 | 1 (0)| | |
- |* 37 | INDEX UNIQUE SCAN | CS_KB_SETS_B_U1 | 1 | | 0 (0)| | |
- |* 38 | INDEX UNIQUE SCAN | CS_KB_SET_TYPES_B_U1 | 1 | 5 | 0 (0)| | |
- | 39 | VIEW | | 1 | 5 | 1 (0)| | |
- | 40 | SORT UNIQUE | | | | | | |
- | 41 | UNION-ALL PARTITION | | | | | | |
- |* 42 | HASH JOIN ANTI | | 1 | 2051 | 755 (1)| | |
- | 43 | NESTED LOOPS | | 1 | 2038 | 375 (2)| | |
- | 44 | VIEW | | 7 | 14196 | 377 (2)| | |
- |* 45 | FILTER | | | | | | |
- |* 46 | CONNECT BY WITH FILTERING | | | | | | |
- | 47 | NESTED LOOPS | | 2 | 242 | 183 (2)| | |
- | 48 | NESTED LOOPS | | 2 | 226 | 183 (2)| | |
- |* 49 | HASH JOIN RIGHT SEMI | | 2 | 206 | 181 (2)| | |
- | 50 | VIEW | VW_NSO_1 | 1 | 77 | 8 (0)| | |
- | 51 | NESTED LOOPS | | 1 | 80 | 8 (0)| | |
- | 52 | NESTED LOOPS | | 1 | 71 | 7 (0)| | |
- | 53 | NESTED LOOPS | | 1 | 26 | 5 (0)| | |
- | 54 | NESTED LOOPS | | 1 | 16 | 4 (0)| | |
- | 55 | FAST DUAL | | 1 | | 2 (0)| | |
- | 56 | TABLE ACCESS BY INDEX ROWID | MTL_ITEM_REVISIONS_B | 1 | 16 | 2 (0)| | |
- |* 57 | INDEX UNIQUE SCAN | MTL_ITEM_REVISIONS_B_U2 | 1 | | 1 (0)| | |
- |* 58 | INDEX UNIQUE SCAN | MTL_SYSTEM_ITEMS_B_U1 | 1 | 10 | 1 (0)| | |
- | 59 | TABLE ACCESS BY GLOBAL INDEX ROWID| EGO_MTL_SY_ITEMS_EXT_B | 1 | 45 | 2 (0)| ROWID | ROWID |
- |* 60 | INDEX RANGE SCAN | EGO_MTL_SY_ITEMS_EXT_B_U2 | 1 | | 2 (0)| | |
- |* 61 | INDEX UNIQUE SCAN | EGO_MTL_SY_ITEMS_EXT_TL_U1 | 1 | 9 | 1 (0)| | |
- |* 62 | TABLE ACCESS FULL | CS_KB_SOLN_CATEGORIES_TL | 15508 | 393K| 172 (1)| | |
- | 63 | TABLE ACCESS BY INDEX ROWID | CS_KB_SOLN_CATEGORIES_B | 1 | 10 | 1 (0)| | |
- |* 64 | INDEX UNIQUE SCAN | CS_KB_SOLN_CATEGORIES_B_U1 | 1 | | 0 (0)| | |
- |* 65 | INDEX UNIQUE SCAN | CS_KB_SOLN_CATEGORIES_TL_U1 | 1 | 8 | 0 (0)| | |
- | 66 | NESTED LOOPS | | 5 | 285 | 192 (2)| | |
- | 67 | NESTED LOOPS | | 5 | 245 | 192 (2)| | |
- | 68 | NESTED LOOPS | | 5 | 115 | 187 (2)| | |
- | 69 | CONNECT BY PUMP | | | | | | |
- |* 70 | TABLE ACCESS BY INDEX ROWID | CS_KB_SOLN_CATEGORIES_B | 2 | 20 | 2 (0)| | |
- |* 71 | INDEX RANGE SCAN | CS_KB_SOLN_CATEGORIES_B_N1 | 2 | | 1 (0)| | |
- | 72 | TABLE ACCESS BY INDEX ROWID | CS_KB_SOLN_CATEGORIES_TL | 1 | 26 | 1 (0)| | |
- |* 73 | INDEX UNIQUE SCAN | CS_KB_SOLN_CATEGORIES_TL_U1 | 1 | | 0 (0)| | |
- |* 74 | INDEX UNIQUE SCAN | CS_KB_SOLN_CATEGORIES_TL_U1 | 1 | 8 | 0 (0)| | |
- |* 75 | INDEX UNIQUE SCAN | CS_KB_SET_CATEGORIES_U1 | 1 | 10 | 0 (0)| | |
- |* 76 | VIEW | VW_NSO_2 | 15 | 195 | 380 (1)| | |
- | 77 | NESTED LOOPS | | | | | | |
- | 78 | NESTED LOOPS | | 15 | 30375 | 380 (1)| | |
- | 79 | NESTED LOOPS | | 7 | 14105 | 360 (1)| | |
- | 80 | FAST DUAL | | 1 | | 2 (0)| | |
- |* 81 | VIEW | | 7 | 14105 | 358 (1)| | |
- |* 82 | CONNECT BY WITH FILTERING | | | | | | |
- | 83 | NESTED LOOPS | | 2 | 88 | 174 (1)| | |
- | 84 | NESTED LOOPS | | 2 | 72 | 174 (1)| | |
- |* 85 | TABLE ACCESS FULL | CS_KB_SOLN_CATEGORIES_TL | 2 | 52 | 172 (1)| | |
- | 86 | TABLE ACCESS BY INDEX ROWID | CS_KB_SOLN_CATEGORIES_B | 1 | 10 | 1 (0)| | |
- |* 87 | INDEX UNIQUE SCAN | CS_KB_SOLN_CATEGORIES_B_U1 | 1 | | 0 (0)| | |
- |* 88 | INDEX UNIQUE SCAN | CS_KB_SOLN_CATEGORIES_TL_U1 | 1 | 8 | 0 (0)| | |
- | 89 | NESTED LOOPS | | 5 | 285 | 183 (1)| | |
- | 90 | NESTED LOOPS | | 5 | 245 | 183 (1)| | |
- | 91 | NESTED LOOPS | | 5 | 115 | 178 (1)| | |
- | 92 | CONNECT BY PUMP | | | | | | |
- |* 93 | TABLE ACCESS BY INDEX ROWID | CS_KB_SOLN_CATEGORIES_B | 2 | 20 | 2 (0)| | |
- |* 94 | INDEX RANGE SCAN | CS_KB_SOLN_CATEGORIES_B_N1 | 2 | | 1 (0)| | |
- | 95 | TABLE ACCESS BY INDEX ROWID | CS_KB_SOLN_CATEGORIES_TL | 1 | 26 | 1 (0)| | |
- |* 96 | INDEX UNIQUE SCAN | CS_KB_SOLN_CATEGORIES_TL_U1 | 1 | | 0 (0)| | |
- |* 97 | INDEX UNIQUE SCAN | CS_KB_SOLN_CATEGORIES_TL_U1 | 1 | 8 | 0 (0)| | |
- |* 98 | INDEX RANGE SCAN | CS_KB_SET_CATEGORIES_N1 | 2 | | 1 (0)| | |
- | 99 | TABLE ACCESS BY INDEX ROWID | CS_KB_SET_CATEGORIES | 2 | 20 | 3 (0)| | |
- |*100 | HASH JOIN ANTI | | 1 | 2051 | 592 (2)| | |
- | 101 | NESTED LOOPS | | 1 | 2038 | 360 (1)| | |
- | 102 | NESTED LOOPS | | 7 | 14196 | 360 (1)| | |
- | 103 | FAST DUAL | | 1 | | 2 (0)| | |
- |*104 | VIEW | | 7 | 14196 | 358 (1)| | |
- |*105 | CONNECT BY WITH FILTERING | | | | | | |
- | 106 | NESTED LOOPS | | 2 | 88 | 174 (1)| | |
- | 107 | NESTED LOOPS | | 2 | 72 | 174 (1)| | |
- |*108 | TABLE ACCESS FULL | CS_KB_SOLN_CATEGORIES_TL | 2 | 52 | 172 (1)| | |
- | 109 | TABLE ACCESS BY INDEX ROWID | CS_KB_SOLN_CATEGORIES_B | 1 | 10 | 1 (0)| | |
- |*110 | INDEX UNIQUE SCAN | CS_KB_SOLN_CATEGORIES_B_U1 | 1 | | 0 (0)| | |
- |*111 | INDEX UNIQUE SCAN | CS_KB_SOLN_CATEGORIES_TL_U1 | 1 | 8 | 0 (0)| | |
- | 112 | NESTED LOOPS | | 5 | 285 | 183 (1)| | |
- | 113 | NESTED LOOPS | | 5 | 245 | 183 (1)| | |
- | 114 | NESTED LOOPS | | 5 | 115 | 178 (1)| | |
- | 115 | CONNECT BY PUMP | | | | | | |
- |*116 | TABLE ACCESS BY INDEX ROWID | CS_KB_SOLN_CATEGORIES_B | 2 | 20 | 2 (0)| | |
- |*117 | INDEX RANGE SCAN | CS_KB_SOLN_CATEGORIES_B_N1 | 2 | | 1 (0)| | |
- | 118 | TABLE ACCESS BY INDEX ROWID | CS_KB_SOLN_CATEGORIES_TL | 1 | 26 | 1 (0)| | |
- |*119 | INDEX UNIQUE SCAN | CS_KB_SOLN_CATEGORIES_TL_U1 | 1 | | 0 (0)| | |
- |*120 | INDEX UNIQUE SCAN | CS_KB_SOLN_CATEGORIES_TL_U1 | 1 | 8 | 0 (0)| | |
- |*121 | INDEX UNIQUE SCAN | CS_KB_SET_CATEGORIES_U1 | 1 | 10 | 0 (0)| | |
- |*122 | VIEW | VW_NSO_4 | 30887 | 392K| 232 (3)| | |
- |*123 | HASH JOIN | | 30887 | 59M| 232 (3)| | |
- | 124 | INDEX FAST FULL SCAN | CS_KB_SET_CATEGORIES_U1 | 30887 | 301K| 23 (0)| | |
- |*125 | VIEW | | 15507 | 29M| 209 (3)| | |
- |*126 | CONNECT BY NO FILTERING WITH START-WITH | | | | | | |
- | 127 | NESTED LOOPS | | 15507 | 666K| 208 (3)| | |
- |*128 | HASH JOIN | | 15507 | 545K| 205 (1)| | |
- |*129 | TABLE ACCESS FULL | CS_KB_SOLN_CATEGORIES_B | 15506 | 151K| 32 (0)| | |
- |*130 | TABLE ACCESS FULL | CS_KB_SOLN_CATEGORIES_TL | 15508 | 393K| 172 (1)| | |
- |*131 | INDEX UNIQUE SCAN | CS_KB_SOLN_CATEGORIES_TL_U1 | 1 | 8 | 0 (0)| | |
- | 132 | NESTED LOOPS | | 1 | 80 | 8 (0)| | |
- | 133 | NESTED LOOPS | | 1 | 71 | 7 (0)| | |
- | 134 | NESTED LOOPS | | 1 | 26 | 5 (0)| | |
- | 135 | NESTED LOOPS | | 1 | 16 | 4 (0)| | |
- | 136 | FAST DUAL | | 1 | | 2 (0)| | |
- | 137 | TABLE ACCESS BY INDEX ROWID | MTL_ITEM_REVISIONS_B | 1 | 16 | 2 (0)| | |
- |*138 | INDEX UNIQUE SCAN | MTL_ITEM_REVISIONS_B_U2 | 1 | | 1 (0)| | |
- |*139 | INDEX UNIQUE SCAN | MTL_SYSTEM_ITEMS_B_U1 | 1 | 10 | 1 (0)| | |
- |*140 | TABLE ACCESS BY GLOBAL INDEX ROWID | EGO_MTL_SY_ITEMS_EXT_B | 1 | 45 | 2 (0)| ROWID | ROWID |
- |*141 | INDEX RANGE SCAN | EGO_MTL_SY_ITEMS_EXT_B_U2 | 1 | | 2 (0)| | |
- |*142 | INDEX UNIQUE SCAN | EGO_MTL_SY_ITEMS_EXT_TL_U1 | 1 | 9 | 1 (0)| | |
- |*143 | TABLE ACCESS BY INDEX ROWID | CS_KB_SET_TYPES_TL | 1 | 29 | 1 (0)| | |
- |*144 | INDEX UNIQUE SCAN | CS_KB_SET_TYPES_TL_U1 | 1 | | 0 (0)| | |
- |*145 | INDEX RANGE SCAN | CS_KB_SET_ELES_U1 | 11 | 110 | 2 (0)| | |
- |*146 | TABLE ACCESS BY INDEX ROWID | CS_KB_ELEMENTS_B | 1 | 16 | 1 (0)| | |
- |*147 | INDEX UNIQUE SCAN | CS_KB_ELEMENTS_B_U1 | 1 | | 0 (0)| | |
- |*148 | INDEX UNIQUE SCAN | CS_KB_ELEMENT_TYPES_B_U1 | 1 | 5 | 0 (0)| | |
- |*149 | TABLE ACCESS BY INDEX ROWID | CS_KB_ELEMENT_TYPES_TL | 1 | 25 | 1 (0)| | |
- |*150 | INDEX UNIQUE SCAN | CS_KB_ELEMENT_TYPES_TL_U1 | 1 | | 0 (0)| | |
- |*151 | INDEX UNIQUE SCAN | CS_KB_ELEMENTS_TL_U1 | 1 | 8 | 1 (0)| | |
- --------------------------------------------------------------------------------------------------------------------------------------------
- Predicate Information (IDENTIFIED BY operation id):
- ---------------------------------------------------
- 13 - FILTER(CASE WHEN ('REP'='SHIP' AND MAX(CASE WHEN ("ETL"."NAME"='ShowAtDelivery') THEN "EBTL"."NAME" END )='Y') THEN 1 WHEN
- ('REP'='RCV' AND MAX(CASE WHEN ("ETL"."NAME"='ShowAtRegistration') THEN "EBTL"."NAME" END )='Y') THEN 1 WHEN ('REP'='REP' AND
- MAX(CASE WHEN ("ETL"."NAME"='ShowAtRepair') THEN "EBTL"."NAME" END )='Y') THEN 1 ELSE 0 END =1 AND (MAX(CASE WHEN
- ("ETL"."NAME"='StartProductionDate') THEN "EBTL"."NAME" END ) IS NULL AND MAX(CASE WHEN ("ETL"."NAME"='EndProductionDate') THEN
- "EBTL"."NAME" END ) IS NULL OR NULL IS NULL OR NVL(TO_DATE(MAX(CASE WHEN ("ETL"."NAME"='StartProductionDate') THEN "EBTL"."NAME"
- END )),TO_DATE('1900-01-01'))<=NULL AND NVL(TO_DATE(MAX(CASE WHEN ("ETL"."NAME"='EndProductionDate') THEN "EBTL"."NAME" END
- )),SYSDATE@!+1)>=NULL) AND (MAX(CASE WHEN ("ETL"."NAME"='LiIonInstruction') THEN "EBTL"."NAME" END )='N' OR MAX(CASE WHEN
- ("ETL"."NAME"='LiIonInstruction') THEN "EBTL"."NAME" END ) IS NULL OR MAX(CASE WHEN ("ETL"."NAME"='LiIonInstruction') THEN
- "EBTL"."NAME" END )='Y' AND NULL='Y' AND NULL='Y' AND 'REP'='SHIP') AND (MAX(CASE WHEN ("ETL"."NAME"='StartSerialNumber') THEN
- "EBTL"."NAME" END ) IS NULL AND MAX(CASE WHEN ("ETL"."NAME"='EndSerialNumber') THEN "EBTL"."NAME" END ) IS NULL OR (MAX(CASE WHEN
- ("ETL"."NAME"='StartSerialNumber') THEN "EBTL"."NAME" END ) IS NULL OR MAX(CASE WHEN ("ETL"."NAME"='StartSerialNumber') THEN
- "EBTL"."NAME" END )=CASE WHEN ( REGEXP_LIKE (MAX(CASE WHEN ("ETL"."NAME"='StartSerialNumber') THEN "EBTL"."NAME" END
- ),'^[0-9]*$') AND REGEXP_LIKE ('T261051WNQ','^[0-9]*$')) THEN TO_CHAR(LEAST(TO_NUMBER(MAX(CASE WHEN
- ("ETL"."NAME"='StartSerialNumber') THEN "EBTL"."NAME" END )),TO_NUMBER('T261051WNQ'))) ELSE LEAST(MAX(CASE WHEN
- ("ETL"."NAME"='StartSerialNumber') THEN "EBTL"."NAME" END ),'T261051WNQ') END ) AND (MAX(CASE WHEN
- ("ETL"."NAME"='EndSerialNumber') THEN "EBTL"."NAME" END ) IS NULL OR CASE WHEN ( REGEXP_LIKE (MAX(CASE WHEN
- ("ETL"."NAME"='EndSerialNumber') THEN "EBTL"."NAME" END ),'^[0-9]*$') AND REGEXP_LIKE ('T261051WNQ','^[0-9]*$')) THEN
- TO_CHAR(LEAST(TO_NUMBER(MAX(CASE WHEN ("ETL"."NAME"='EndSerialNumber') THEN "EBTL"."NAME" END )),TO_NUMBER('T261051WNQ'))) ELSE
- LEAST(MAX(CASE WHEN ("ETL"."NAME"='EndSerialNumber') THEN "EBTL"."NAME" END ),'T261051WNQ') END ='T261051WNQ')))
- 15 - access("EBTL"."ELEMENT_ID"="EB"."ELEMENT_ID")
- 16 - access("ETL"."ELEMENT_TYPE_ID"="ET"."ELEMENT_TYPE_ID")
- 17 - FILTER("ETL"."LANGUAGE"=USERENV('LANG'))
- 19 - access("EB"."ELEMENT_ID"="EL"."ELEMENT_ID")
- 20 - access("EL"."SET_ID"="S"."SET_ID")
- 25 - FILTER("STTL"."NAME"='Instruction')
- 26 - access("STTL"."LANGUAGE"=USERENV('LANG'))
- FILTER("STTL"."LANGUAGE"=USERENV('LANG'))
- 27 - access("STTL"."SET_TYPE_ID"="ST"."SET_TYPE_ID")
- 28 - FILTER("S"."STATUS"='PUB')
- 29 - access("ST"."SET_TYPE_ID"="S"."SET_TYPE_ID")
- 30 - access("S"."SET_ID"="CKST"."SET_ID" AND "CKST"."LANGUAGE"='US')
- 33 - FILTER("EB"."STATUS"='PUBLISHED')
- 34 - access("ET"."ELEMENT_TYPE_ID"="EB"."ELEMENT_TYPE_ID")
- 35 - FILTER("EBTL"."LANGUAGE"=USERENV('LANG'))
- 36 - FILTER("S"."STATUS"='PUB')
- 37 - access("SETPARAMS"."SET_ID"="S"."SET_ID")
- 38 - access("ST"."SET_TYPE_ID"="S"."SET_TYPE_ID")
- 42 - access("SETCATEGORIES"."SET_ID"="SET_ID")
- 45 - FILTER('REP'<>'REP' OR LEVEL<3)
- 46 - access("A"."PARENT_CATEGORY_ID"=PRIOR "A"."CATEGORY_ID")
- 49 - access("B"."NAME"="FSEITEMGROUP")
- 57 - access("MIR"."REVISION_ID"=12274952)
- 58 - access("MSI"."INVENTORY_ITEM_ID"=9169275 AND "MSI"."ORGANIZATION_ID"=3461)
- 60 - access("MSI"."INVENTORY_ITEM_ID"="B"."INVENTORY_ITEM_ID" AND "MSI"."ORGANIZATION_ID"="B"."ORGANIZATION_ID" AND
- "MIR"."REVISION_ID"="B"."REVISION_ID" AND "B"."ATTR_GROUP_ID"=7335)
- FILTER("MIR"."INVENTORY_ITEM_ID"="B"."INVENTORY_ITEM_ID" AND "MIR"."ORGANIZATION_ID"="B"."ORGANIZATION_ID")
- 61 - access("TL"."LANGUAGE"=USERENV('LANG') AND "B"."EXTENSION_ID"="TL"."EXTENSION_ID")
- 62 - FILTER("B"."LANGUAGE"='US')
- 64 - access("A"."CATEGORY_ID"="B"."CATEGORY_ID")
- FILTER("A"."CATEGORY_ID"<>1 AND "A"."CATEGORY_ID"<>(-1))
- 65 - access("A"."PARENT_CATEGORY_ID"="C"."CATEGORY_ID" AND "C"."LANGUAGE"="B"."LANGUAGE")
- 70 - FILTER("A"."CATEGORY_ID"<>1 AND "A"."CATEGORY_ID"<>(-1))
- 71 - access("connect$_by$_pump$_035"."Prior Fc.Category_Id "="A"."PARENT_CATEGORY_ID")
- 73 - access("A"."CATEGORY_ID"="B"."CATEGORY_ID" AND "B"."LANGUAGE"='US')
- 74 - access("A"."PARENT_CATEGORY_ID"="C"."CATEGORY_ID" AND "C"."LANGUAGE"="B"."LANGUAGE")
- 75 - access("SETCATEGORIES"."SET_ID"="S"."SET_ID" AND "SETCATEGORIES"."CATEGORY_ID"="CATEGORIES"."GROUPCATEGORYID")
- 76 - FILTER("SET_ID"="S"."SET_ID")
- 81 - FILTER("EXCLUDEDCATEGORIES"."PATH"<>'/Customers/56495' AND "EXCLUDEDCATEGORIES"."PATH"<>'/Customers/56495/' AND
- "EXCLUDEDCATEGORIES"."PATH"<>'/Customers/56495//97250' AND "EXCLUDEDCATEGORIES"."PATH"<>'/Customers/56495//97250/')
- 82 - access("A"."PARENT_CATEGORY_ID"=PRIOR "A"."CATEGORY_ID")
- 85 - FILTER("B"."NAME"='Customers' AND "B"."LANGUAGE"='US')
- 87 - access("A"."CATEGORY_ID"="B"."CATEGORY_ID")
- FILTER("A"."CATEGORY_ID"<>1 AND "A"."CATEGORY_ID"<>(-1))
- 88 - access("A"."PARENT_CATEGORY_ID"="C"."CATEGORY_ID" AND "C"."LANGUAGE"="B"."LANGUAGE")
- 93 - FILTER("A"."CATEGORY_ID"<>1 AND "A"."CATEGORY_ID"<>(-1))
- 94 - access("connect$_by$_pump$_044"."Prior Fc.Category_Id "="A"."PARENT_CATEGORY_ID")
- 96 - access("A"."CATEGORY_ID"="B"."CATEGORY_ID" AND "B"."LANGUAGE"='US')
- 97 - access("A"."PARENT_CATEGORY_ID"="C"."CATEGORY_ID" AND "C"."LANGUAGE"="B"."LANGUAGE")
- 98 - access("SETCATEGORIES"."CATEGORY_ID"="EXCLUDEDCATEGORIES"."GROUPCATEGORYID")
- 100 - access("SETCATEGORIES"."SET_ID"="SET_ID")
- 104 - FILTER("CATEGORIES"."PATH"='\Customers\56495' OR "CATEGORIES"."PATH"='\Customers\56495\' OR
- "CATEGORIES"."PATH"='\Customers\56495\\97250' OR "CATEGORIES"."PATH"='\Customers\56495\\97250\')
- 105 - access("A"."PARENT_CATEGORY_ID"=PRIOR "A"."CATEGORY_ID")
- 108 - filter("B"."NAME"='Customers' AND "B"."LANGUAGE"='US')
- 110 - access("A"."CATEGORY_ID"="B"."CATEGORY_ID")
- filter("A"."CATEGORY_ID"<>1 AND "A"."CATEGORY_ID"<>(-1))
- 111 - access("A"."PARENT_CATEGORY_ID"="C"."CATEGORY_ID" AND "C"."LANGUAGE"="B"."LANGUAGE")
- 116 - filter("A"."CATEGORY_ID"<>1 AND "A"."CATEGORY_ID"<>(-1))
- 117 - access("connect$_by$_pump$_055"."Prior Fc.Category_Id "="A"."PARENT_CATEGORY_ID")
- 119 - access("A"."CATEGORY_ID"="B"."CATEGORY_ID" AND "B"."LANGUAGE"='US')
- 120 - access("A"."PARENT_CATEGORY_ID"="C"."CATEGORY_ID" AND "C"."LANGUAGE"="B"."LANGUAGE")
- 121 - access("SETCATEGORIES"."SET_ID"="S"."SET_ID" AND "SETCATEGORIES"."CATEGORY_ID"="CATEGORIES"."CATEGORY_ID")
- 122 - filter("SET_ID"="S"."SET_ID")
- 123 - access("EXSETCATEGORIES"."CATEGORY_ID"="EXCATEGORIES"."GROUPCATEGORYID")
- 125 - filter("EXCATEGORIES"."GROUPPATH" NOT LIKE '\FSE Knowledge Base\Customers%' AND "EXCATEGORIES"."GROUPPATH"<>'\FSE Knowledge
- Base\Uncategorized' AND "EXCATEGORIES"."GROUPPATH" LIKE '\FSE Knowledge Base%')
- 126 - access("A"."PARENT_CATEGORY_ID"=PRIOR "A"."CATEGORY_ID")
- filter( NOT EXISTS (SELECT 0 FROM "SYS"."DUAL" "DUAL","INV"."MTL_ITEM_REVISIONS_B" "MIR","INV"."MTL_SYSTEM_ITEMS_B"
- "MSI","EGO"."EGO_MTL_SY_ITEMS_EXT_TL" "TL","EGO"."EGO_MTL_SY_ITEMS_EXT_B" "B" WHERE "B"."ATTR_GROUP_ID"=7335 AND
- "MIR"."REVISION_ID"="B"."REVISION_ID" AND "MSI"."ORGANIZATION_ID"="B"."ORGANIZATION_ID" AND
- "MSI"."INVENTORY_ITEM_ID"="B"."INVENTORY_ITEM_ID" AND LNNVL("B"."C_EXT_ATTR1"<>:B1) AND
- "MIR"."INVENTORY_ITEM_ID"="B"."INVENTORY_ITEM_ID" AND "MIR"."ORGANIZATION_ID"="B"."ORGANIZATION_ID" AND
- "B"."EXTENSION_ID"="TL"."EXTENSION_ID" AND "TL"."LANGUAGE"=USERENV('LANG') AND "MSI"."ORGANIZATION_ID"=3461 AND
- "MSI"."INVENTORY_ITEM_ID"=9169275 AND "MIR"."REVISION_ID"=12274952))
- 128 - access("A"."CATEGORY_ID"="B"."CATEGORY_ID")
- 129 - filter("A"."CATEGORY_ID"<>1 AND "A"."CATEGORY_ID"<>(-1))
- 130 - filter("B"."LANGUAGE"='US')
- 131 - access("A"."PARENT_CATEGORY_ID"="C"."CATEGORY_ID" AND "C"."LANGUAGE"="B"."LANGUAGE")
- 138 - access("MIR"."REVISION_ID"=12274952)
- 139 - access("MSI"."INVENTORY_ITEM_ID"=9169275 AND "MSI"."ORGANIZATION_ID"=3461)
- 140 - filter(LNNVL("B"."C_EXT_ATTR1"<>:B1))
- 141 - access("MSI"."INVENTORY_ITEM_ID"="B"."INVENTORY_ITEM_ID" AND "MSI"."ORGANIZATION_ID"="B"."ORGANIZATION_ID" AND
- "MIR"."REVISION_ID"="B"."REVISION_ID" AND "B"."ATTR_GROUP_ID"=7335)
- filter("MIR"."INVENTORY_ITEM_ID"="B"."INVENTORY_ITEM_ID" AND "MIR"."ORGANIZATION_ID"="B"."ORGANIZATION_ID")
- 142 - access("TL"."LANGUAGE"=USERENV('LANG') AND "B"."EXTENSION_ID"="TL"."EXTENSION_ID")
- 143 - filter("STTL"."NAME"='Instruction')
- 144 - access("STTL"."SET_TYPE_ID"="ST"."SET_TYPE_ID" AND "STTL"."LANGUAGE"=USERENV('LANG'))
- 145 - access("EL"."SET_ID"="S"."SET_ID")
- 146 - filter("EB"."STATUS"='PUBLISHED')
- 147 - access("EB"."ELEMENT_ID"="EL"."ELEMENT_ID")
- 148 - access("ET"."ELEMENT_TYPE_ID"="EB"."ELEMENT_TYPE_ID")
- 149 - filter("ETL"."NAME"='Instruction')
- 150 - access("ETL"."ELEMENT_TYPE_ID"="ET"."ELEMENT_TYPE_ID" AND "ETL"."LANGUAGE"=USERENV('LANG'))
- 151 - access("EBTL"."ELEMENT_ID"="EB"."ELEMENT_ID" AND "EBTL"."LANGUAGE"=USERENV('LANG'))
- Note
- -----
- - 'PLAN_TABLE' is old version
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement