API tools faq
paste
Guest User

from code

a guest
Feb 4th, 2019
437
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 44.21 KB | None | 0 0
raw download clone embed print report
  1.  
  2. Plan hash VALUE: 1901021240
  3.  
  4. ------------------------------------------------------------------------------------------------------------
  5. | Id  | Operation                              | Name      | ROWS  | Bytes |TempSpc| Cost (%CPU)| TIME     |
  6. ------------------------------------------------------------------------------------------------------------
  7. |   0 | SELECT STATEMENT                       |           |   209 | 85272 |       | 54193   (1)| 00:00:03 |
  8. |   1 |  SORT ORDER BY                         |           |   209 | 85272 |       | 54193   (1)| 00:00:03 |
  9. |*  2 |   HASH JOIN OUTER                      |           |   209 | 85272 |       | 54192   (1)| 00:00:03 |
  10. |   3 |    NESTED LOOPS OUTER                  |           |   209 | 75031 |       | 34312   (1)| 00:00:02 |
  11. |   4 |     NESTED LOOPS OUTER                 |           |   209 | 65626 |       | 34103   (1)| 00:00:02 |
  12. |   5 |      NESTED LOOPS OUTER                |           |   209 | 55803 |       | 33685   (1)| 00:00:02 |
  13. |   6 |       NESTED LOOPS                     |           |   209 | 46398 |       | 33476   (1)| 00:00:02 |
  14. |   7 |        VIEW                            |           |  2781 |   404K|       | 22352   (1)| 00:00:01 |
  15. |   8 |         UNION-ALL                      |           |       |       |       |            |          |
  16. |*  9 |          FILTER                        |           |       |       |       |            |          |
  17. |* 10 |           CONNECT BY WITH FILTERING    |           |       |       |       |            |          |
  18. |  11 |            NESTED LOOPS                |           |       |       |       |            |          |
  19. |  12 |             NESTED LOOPS               |           |  1003 |   177K|       |  6037   (1)| 00:00:01 |
  20. |* 13 |              HASH JOIN OUTER           |           |  1003 |   120K|       |  4031   (1)| 00:00:01 |
  21. |* 14 |               HASH JOIN                |           |  1003 | 84252 |       |  1338   (1)| 00:00:01 |
  22. |  15 |                VIEW                    | VW_NSO_1  |     1 |    18 |       |  1033   (1)| 00:00:01 |
  23. |  16 |                 HASH UNIQUE            |           |     1 |    94 |       |  1033   (1)| 00:00:01 |
  24. |* 17 |                  FILTER                |           |       |       |       |            |          |
  25. |* 18 |                   HASH JOIN RIGHT OUTER|           |  1003 | 94282 |  4512K|  1032   (1)| 00:00:01 |
  26. |* 19 |                    INDEX FAST FULL SCAN| PK_WOWOB  |   100K|  3330K|       |   166   (1)| 00:00:01 |
  27. |* 20 |                    INDEX FAST FULL SCAN| X_WOWOB   |   100K|  5876K|       |   305   (1)| 00:00:01 |
  28. |  21 |                INDEX FAST FULL SCAN    | X_WOWOB   |   100K|  6464K|       |   305   (1)| 00:00:01 |
  29. |  22 |               VIEW                     |           | 24541 |   934K|       |  2692   (1)| 00:00:01 |
  30. |  23 |                HASH GROUP BY           |           | 24541 |  1198K|  1752K|  2692   (1)| 00:00:01 |
  31. |* 24 |                 INDEX RANGE SCAN       | XI_APSTP  | 24541 |  1198K|       |  2386   (1)| 00:00:01 |
  32. |* 25 |              INDEX UNIQUE SCAN         | PK_WO     |     1 |       |       |     1   (0)| 00:00:01 |
  33. |  26 |             TABLE ACCESS BY INDEX ROWID| WO        |     1 |    58 |       |     2   (0)| 00:00:01 |
  34. |  27 |            NESTED LOOPS                |           |  1003 |   183K|       | 11041   (1)| 00:00:01 |
  35. |* 28 |             HASH JOIN OUTER            |           |  1003 |   126K|       |  9035   (1)| 00:00:01 |
  36. |* 29 |              HASH JOIN                 |           |  1003 | 90270 |       |  6342   (1)| 00:00:01 |
  37. |  30 |               CONNECT BY PUMP          |           |       |       |       |            |          |
  38. |  31 |               INDEX FAST FULL SCAN     | X_WOWOB   |   100K|  6464K|       |   305   (1)| 00:00:01 |
  39. |  32 |              VIEW                      |           | 24541 |   934K|       |  2692   (1)| 00:00:01 |
  40. |  33 |               SORT GROUP BY            |           | 24541 |  1198K|  1752K|  2692   (1)| 00:00:01 |
  41. |* 34 |                INDEX RANGE SCAN        | XI_APSTP  | 24541 |  1198K|       |  2386   (1)| 00:00:01 |
  42. |  35 |             TABLE ACCESS BY INDEX ROWID| WO        |     1 |    58 |       |     2   (0)| 00:00:01 |
  43. |* 36 |              INDEX UNIQUE SCAN         | PK_WO     |     1 |       |       |     1   (0)| 00:00:01 |
  44. |  37 |          HASH GROUP BY                 |           |   775 |   123K|       |  5271   (1)| 00:00:01 |
  45. |* 38 |           HASH JOIN                    |           |   775 |   123K|       |  5270   (1)| 00:00:01 |
  46. |  39 |            NESTED LOOPS                |           |       |       |       |            |          |
  47. |  40 |             NESTED LOOPS               |           |  1210 |   151K|       |  3598   (1)| 00:00:01 |
  48. |* 41 |              INDEX RANGE SCAN          | XI_APSTP  |  1210 | 54450 |       |  2386   (1)| 00:00:01 |
  49. |* 42 |              INDEX RANGE SCAN          | PK_WO     |     1 |       |       |     1   (0)| 00:00:01 |
  50. |  43 |             TABLE ACCESS BY INDEX ROWID| WO        |     1 |    83 |       |     2   (0)| 00:00:01 |
  51. |* 44 |            TABLE ACCESS FULL           | ITEM_CCN  | 76449 |  2613K|       |  1672   (1)| 00:00:01 |
  52. |  45 |        TABLE ACCESS BY INDEX ROWID     | WO_BOM    |     1 |    73 |       |     4   (0)| 00:00:01 |
  53. |* 46 |         INDEX RANGE SCAN               | PK_WO_BOM |     1 |       |       |     3   (0)| 00:00:01 |
  54. |  47 |       TABLE ACCESS BY INDEX ROWID      | ITEM      |     1 |    45 |       |     1   (0)| 00:00:01 |
  55. |* 48 |        INDEX UNIQUE SCAN               | PK_ITEM   |     1 |       |       |     0   (0)| 00:00:01 |
  56. |  49 |      TABLE ACCESS BY INDEX ROWID       | WO        |     1 |    47 |       |     2   (0)| 00:00:01 |
  57. |* 50 |       INDEX UNIQUE SCAN                | PK_WO     |     1 |       |       |     1   (0)| 00:00:01 |
  58. |  51 |     TABLE ACCESS BY INDEX ROWID        | ITEM      |     1 |    45 |       |     1   (0)| 00:00:01 |
  59. |* 52 |      INDEX UNIQUE SCAN                 | PK_ITEM   |     1 |       |       |     0   (0)| 00:00:01 |
  60. |  53 |    VIEW                                |           |   869K|    40M|       | 19878   (1)| 00:00:01 |
  61. |* 54 |     HASH JOIN RIGHT OUTER              |           |   869K|    70M|    39M| 19878   (1)| 00:00:01 |
  62. |  55 |      VIEW                              |           |   824K|    29M|       |  6885   (1)| 00:00:01 |
  63. |  56 |       HASH GROUP BY                    |           |   824K|    30M|    46M|  6885   (1)| 00:00:01 |
  64. |  57 |        INDEX FULL SCAN                 | PK_WO_RTG |   869K|    32M|       |  6885   (1)| 00:00:01 |
  65. |  58 |      TABLE ACCESS FULL                 | WO_RTG    |   869K|    38M|       |  8611   (1)| 00:00:01 |
  66. ------------------------------------------------------------------------------------------------------------
  67.  
  68. Query Block Name / Object Alias (IDENTIFIED BY operation id):
  69. -------------------------------------------------------------
  70.  
  71.    1 - SEL$40D00EE7
  72.    7 - SET$1        / FROM$_subquery$_009@SEL$8
  73.    8 - SET$1      
  74.    9 - SEL$13      
  75.   11 - SEL$C3DEBEA4
  76.   15 - SEL$D1537436 / VW_NSO_1@SEL$C3DEBEA4
  77.   16 - SEL$D1537436
  78.   19 - SEL$D1537436 / PARENT_WOWOB@SEL$26
  79.   20 - SEL$D1537436 / WOWOB@SEL$27
  80.   21 - SEL$C3DEBEA4 / WOWOB@SEL$28
  81.   22 - SEL$30       / APSSPLIT_MIN_OPERATION@SEL$29
  82.   23 - SEL$30      
  83.   24 - SEL$30       / APSSPLIT@SEL$30
  84.   25 - SEL$C3DEBEA4 / WO@SEL$28
  85.   26 - SEL$C3DEBEA4 / WO@SEL$28
  86.   27 - SEL$D68BA284
  87.   31 - SEL$D68BA284 / WOWOB@SEL$21
  88.   32 - SEL$23       / APSSPLIT_MIN_OPERATION@SEL$22
  89.   33 - SEL$23      
  90.   34 - SEL$23       / APSSPLIT@SEL$23
  91.   35 - SEL$D68BA284 / WO@SEL$21
  92.   36 - SEL$D68BA284 / WO@SEL$21
  93.   37 - SEL$E54D090A
  94.   41 - SEL$E54D090A / APSSPLIT@SEL$11
  95.   42 - SEL$E54D090A / WO@SEL$9
  96.   43 - SEL$E54D090A / WO@SEL$9
  97.   44 - SEL$E54D090A / ITEM_CCN@SEL$9
  98.   45 - SEL$40D00EE7 / WO_BOM@SEL$6
  99.   46 - SEL$40D00EE7 / WO_BOM@SEL$6
  100.   47 - SEL$40D00EE7 / WO_BOM_ITEM@SEL$40
  101.   48 - SEL$40D00EE7 / WO_BOM_ITEM@SEL$40
  102.   49 - SEL$40D00EE7 / WO@SEL$36
  103.   50 - SEL$40D00EE7 / WO@SEL$36
  104.   51 - SEL$40D00EE7 / WO_ITEM@SEL$38
  105.   52 - SEL$40D00EE7 / WO_ITEM@SEL$38
  106.   53 - SEL$EBDC700B / WO_RTG@SEL$1
  107.   54 - SEL$EBDC700B
  108.   55 - SEL$3        / WO_RTG_MIN_OPERATION@SEL$2
  109.   56 - SEL$3      
  110.   57 - SEL$3        / WO_RTG@SEL$3
  111.   58 - SEL$EBDC700B / WO_RTG@SEL$4
  112.  
  113. Outline DATA
  114. -------------
  115.  
  116.   /*+
  117.       BEGIN_OUTLINE_DATA
  118.       USE_HASH_AGGREGATION(@"SEL$3")
  119.       INDEX(@"SEL$3" "WO_RTG"@"SEL$3" ("WO_RTG"."CCN" "WO_RTG"."MAS_LOC" "WO_RTG"."WO_NUM"
  120.               "WO_RTG"."WO_LINE" "WO_RTG"."OPERATION"))
  121.       USE_HASH_AGGREGATION(@"SEL$30")
  122.       INDEX(@"SEL$30" "APSSPLIT"@"SEL$30" ("APSSPLIT"."SCHEDULE" "APSSPLIT"."CCN" "APSSPLIT"."MAS_LOC"
  123.               "APSSPLIT"."ORDER_TYPE" "APSSPLIT"."ORDERIDENT" "APSSPLIT"."ORDER_LINE" "APSSPLIT"."ITEM"
  124.               "APSSPLIT"."REVISION" "APSSPLIT"."RP_DATE" "APSSPLIT"."OPERATION" "APSSPLIT"."SPLIT_NUM"
  125.               "APSSPLIT"."MACHINE_NUM" "APSSPLIT"."BLOCK_IDENT" "APSSPLIT"."OPERATION_START_DATE"
  126.               "APSSPLIT"."OPERATION_START_TIME" "APSSPLIT"."OPERATION_END_DATE" "APSSPLIT"."OPERATION_END_TIME"))
  127.       USE_HASH_AGGREGATION(@"SEL$D1537436")
  128.       SWAP_JOIN_INPUTS(@"SEL$D1537436" "PARENT_WOWOB"@"SEL$26")
  129.       USE_HASH(@"SEL$D1537436" "PARENT_WOWOB"@"SEL$26")
  130.       LEADING(@"SEL$D1537436" "WOWOB"@"SEL$27" "PARENT_WOWOB"@"SEL$26")
  131.       INDEX_FFS(@"SEL$D1537436" "PARENT_WOWOB"@"SEL$26" ("WOWOB"."CCN" "WOWOB"."MAS_LOC" "WOWOB"."WO_NUM"
  132.               "WOWOB"."WO_LINE"))
  133.       INDEX_FFS(@"SEL$D1537436" "WOWOB"@"SEL$27" ("WOWOB"."CCN" "WOWOB"."MAS_LOC" "WOWOB"."PARENT_WO_NUM"
  134.               "WOWOB"."PARENT_WO_LINE" "WOWOB"."PARENT_WO_BOM_USEQ" "WOWOB"."WO_NUM" "WOWOB"."WO_LINE"))
  135.       INDEX(@"SEL$23" "APSSPLIT"@"SEL$23" ("APSSPLIT"."SCHEDULE" "APSSPLIT"."CCN" "APSSPLIT"."MAS_LOC"
  136.               "APSSPLIT"."ORDER_TYPE" "APSSPLIT"."ORDERIDENT" "APSSPLIT"."ORDER_LINE" "APSSPLIT"."ITEM"
  137.               "APSSPLIT"."REVISION" "APSSPLIT"."RP_DATE" "APSSPLIT"."OPERATION" "APSSPLIT"."SPLIT_NUM"
  138.               "APSSPLIT"."MACHINE_NUM" "APSSPLIT"."BLOCK_IDENT" "APSSPLIT"."OPERATION_START_DATE"
  139.               "APSSPLIT"."OPERATION_START_TIME" "APSSPLIT"."OPERATION_END_DATE" "APSSPLIT"."OPERATION_END_TIME"))
  140.       USE_NL(@"SEL$1089D2EB" "PARENT_WOWOB"@"SEL$14")
  141.       LEADING(@"SEL$1089D2EB" "WOWOB"@"SEL$15" "PARENT_WOWOB"@"SEL$14")
  142.       INDEX(@"SEL$1089D2EB" "PARENT_WOWOB"@"SEL$14" ("WOWOB"."CCN" "WOWOB"."MAS_LOC" "WOWOB"."WO_NUM"
  143.               "WOWOB"."WO_LINE"))
  144.       INDEX_RS_ASC(@"SEL$1089D2EB" "WOWOB"@"SEL$15" ("WOWOB"."CCN" "WOWOB"."MAS_LOC" "WOWOB"."WO_NUM"
  145.               "WOWOB"."WO_LINE"))
  146.       USE_HASH_AGGREGATION(@"SEL$18")
  147.       INDEX(@"SEL$18" "APSSPLIT"@"SEL$18" ("APSSPLIT"."SCHEDULE" "APSSPLIT"."CCN" "APSSPLIT"."MAS_LOC"
  148.               "APSSPLIT"."ORDER_TYPE" "APSSPLIT"."ORDERIDENT" "APSSPLIT"."ORDER_LINE" "APSSPLIT"."ITEM"
  149.               "APSSPLIT"."REVISION" "APSSPLIT"."RP_DATE" "APSSPLIT"."OPERATION" "APSSPLIT"."SPLIT_NUM"
  150.               "APSSPLIT"."MACHINE_NUM" "APSSPLIT"."BLOCK_IDENT" "APSSPLIT"."OPERATION_START_DATE"
  151.               "APSSPLIT"."OPERATION_START_TIME" "APSSPLIT"."OPERATION_END_DATE" "APSSPLIT"."OPERATION_END_TIME"))
  152.       SWAP_JOIN_INPUTS(@"SEL$2C22443D" "APSSPLIT_MIN_OPERATION"@"SEL$17")
  153.       USE_HASH(@"SEL$2C22443D" "APSSPLIT_MIN_OPERATION"@"SEL$17")
  154.       USE_HASH(@"SEL$2C22443D" "WO"@"SEL$16")
  155.       LEADING(@"SEL$2C22443D" "WOWOB"@"SEL$16" "WO"@"SEL$16" "APSSPLIT_MIN_OPERATION"@"SEL$17")
  156.       NO_ACCESS(@"SEL$2C22443D" "APSSPLIT_MIN_OPERATION"@"SEL$17")
  157.       FULL(@"SEL$2C22443D" "WO"@"SEL$16")
  158.       INDEX_FFS(@"SEL$2C22443D" "WOWOB"@"SEL$16" ("WOWOB"."CCN" "WOWOB"."MAS_LOC" "WOWOB"."PARENT_WO_NUM"
  159.               "WOWOB"."PARENT_WO_LINE" "WOWOB"."PARENT_WO_BOM_USEQ" "WOWOB"."WO_NUM" "WOWOB"."WO_LINE"))
  160.       USE_NL(@"SEL$D68BA284" "WO"@"SEL$21")
  161.       USE_HASH(@"SEL$D68BA284" "APSSPLIT_MIN_OPERATION"@"SEL$22")
  162.       USE_HASH(@"SEL$D68BA284" "WOWOB"@"SEL$21")
  163.       LEADING(@"SEL$D68BA284" "connect$_by$_pump$_019"@"SEL$25" "WOWOB"@"SEL$21"
  164.               "APSSPLIT_MIN_OPERATION"@"SEL$22" "WO"@"SEL$21")
  165.       INDEX_RS_ASC(@"SEL$D68BA284" "WO"@"SEL$21" ("WO"."CCN" "WO"."MAS_LOC" "WO"."WO_NUM" "WO"."WO_LINE"))
  166.       NO_ACCESS(@"SEL$D68BA284" "APSSPLIT_MIN_OPERATION"@"SEL$22")
  167.       INDEX_FFS(@"SEL$D68BA284" "WOWOB"@"SEL$21" ("WOWOB"."CCN" "WOWOB"."MAS_LOC" "WOWOB"."PARENT_WO_NUM"
  168.               "WOWOB"."PARENT_WO_LINE" "WOWOB"."PARENT_WO_BOM_USEQ" "WOWOB"."WO_NUM" "WOWOB"."WO_LINE"))
  169.       FULL(@"SEL$D68BA284" "connect$_by$_pump$_019"@"SEL$25")
  170.       NLJ_BATCHING(@"SEL$C3DEBEA4" "WO"@"SEL$28")
  171.       USE_NL(@"SEL$C3DEBEA4" "WO"@"SEL$28")
  172.       USE_HASH(@"SEL$C3DEBEA4" "APSSPLIT_MIN_OPERATION"@"SEL$29")
  173.       USE_HASH(@"SEL$C3DEBEA4" "WOWOB"@"SEL$28")
  174.       LEADING(@"SEL$C3DEBEA4" "VW_NSO_1"@"SEL$C3DEBEA4" "WOWOB"@"SEL$28"
  175.               "APSSPLIT_MIN_OPERATION"@"SEL$29" "WO"@"SEL$28")
  176.       INDEX(@"SEL$C3DEBEA4" "WO"@"SEL$28" ("WO"."CCN" "WO"."MAS_LOC" "WO"."WO_NUM" "WO"."WO_LINE"))
  177.       NO_ACCESS(@"SEL$C3DEBEA4" "APSSPLIT_MIN_OPERATION"@"SEL$29")
  178.       INDEX_FFS(@"SEL$C3DEBEA4" "WOWOB"@"SEL$28" ("WOWOB"."CCN" "WOWOB"."MAS_LOC" "WOWOB"."PARENT_WO_NUM"
  179.               "WOWOB"."PARENT_WO_LINE" "WOWOB"."PARENT_WO_BOM_USEQ" "WOWOB"."WO_NUM" "WOWOB"."WO_LINE"))
  180.       NO_ACCESS(@"SEL$C3DEBEA4" "VW_NSO_1"@"SEL$C3DEBEA4")
  181.       CONNECT_BY_FILTERING(@"SEL$13")
  182.       NO_ACCESS(@"SEL$13" "connect$_by$_work$_set$_044"@"SEL$13")
  183.       USE_HASH_AGGREGATION(@"SEL$E54D090A")
  184.       USE_HASH(@"SEL$E54D090A" "ITEM_CCN"@"SEL$9")
  185.       NLJ_BATCHING(@"SEL$E54D090A" "WO"@"SEL$9")
  186.       USE_NL(@"SEL$E54D090A" "WO"@"SEL$9")
  187.       LEADING(@"SEL$E54D090A" "APSSPLIT"@"SEL$11" "WO"@"SEL$9" "ITEM_CCN"@"SEL$9")
  188.       FULL(@"SEL$E54D090A" "ITEM_CCN"@"SEL$9")
  189.       INDEX(@"SEL$E54D090A" "WO"@"SEL$9" ("WO"."CCN" "WO"."MAS_LOC" "WO"."WO_NUM" "WO"."WO_LINE"))
  190.       INDEX(@"SEL$E54D090A" "APSSPLIT"@"SEL$11" ("APSSPLIT"."SCHEDULE" "APSSPLIT"."CCN"
  191.               "APSSPLIT"."MAS_LOC" "APSSPLIT"."ORDER_TYPE" "APSSPLIT"."ORDERIDENT" "APSSPLIT"."ORDER_LINE"
  192.               "APSSPLIT"."ITEM" "APSSPLIT"."REVISION" "APSSPLIT"."RP_DATE" "APSSPLIT"."OPERATION"
  193.               "APSSPLIT"."SPLIT_NUM" "APSSPLIT"."MACHINE_NUM" "APSSPLIT"."BLOCK_IDENT"
  194.               "APSSPLIT"."OPERATION_START_DATE" "APSSPLIT"."OPERATION_START_TIME" "APSSPLIT"."OPERATION_END_DATE"
  195.               "APSSPLIT"."OPERATION_END_TIME"))
  196.       SWAP_JOIN_INPUTS(@"SEL$EBDC700B" "WO_RTG_MIN_OPERATION"@"SEL$2")
  197.       USE_HASH(@"SEL$EBDC700B" "WO_RTG_MIN_OPERATION"@"SEL$2")
  198.       LEADING(@"SEL$EBDC700B" "WO_RTG"@"SEL$4" "WO_RTG_MIN_OPERATION"@"SEL$2")
  199.       NO_ACCESS(@"SEL$EBDC700B" "WO_RTG_MIN_OPERATION"@"SEL$2")
  200.       FULL(@"SEL$EBDC700B" "WO_RTG"@"SEL$4")
  201.       USE_HASH(@"SEL$40D00EE7" "WO_RTG"@"SEL$1")
  202.       USE_NL(@"SEL$40D00EE7" "WO_ITEM"@"SEL$38")
  203.       USE_NL(@"SEL$40D00EE7" "WO"@"SEL$36")
  204.       USE_NL(@"SEL$40D00EE7" "WO_BOM_ITEM"@"SEL$40")
  205.       USE_NL(@"SEL$40D00EE7" "WO_BOM"@"SEL$6")
  206.       LEADING(@"SEL$40D00EE7" "from$_subquery$_009"@"SEL$8" "WO_BOM"@"SEL$6" "WO_BOM_ITEM"@"SEL$40"
  207.               "WO"@"SEL$36" "WO_ITEM"@"SEL$38" "WO_RTG"@"SEL$1")
  208.       NO_ACCESS(@"SEL$40D00EE7" "WO_RTG"@"SEL$1")
  209.       INDEX_RS_ASC(@"SEL$40D00EE7" "WO_ITEM"@"SEL$38" ("ITEM"."ITEM" "ITEM"."REVISION"))
  210.       INDEX_RS_ASC(@"SEL$40D00EE7" "WO"@"SEL$36" ("WO"."CCN" "WO"."MAS_LOC" "WO"."WO_NUM" "WO"."WO_LINE"))
  211.       INDEX_RS_ASC(@"SEL$40D00EE7" "WO_BOM_ITEM"@"SEL$40" ("ITEM"."ITEM" "ITEM"."REVISION"))
  212.       INDEX_RS_ASC(@"SEL$40D00EE7" "WO_BOM"@"SEL$6" ("WO_BOM"."CCN" "WO_BOM"."MAS_LOC" "WO_BOM"."WO_NUM"
  213.               "WO_BOM"."WO_LINE" "WO_BOM"."WO_BOM_USEQ"))
  214.       NO_ACCESS(@"SEL$40D00EE7" "from$_subquery$_009"@"SEL$8")
  215.       OUTLINE(@"SEL$1")
  216.       OUTLINE(@"SEL$6")
  217.       MERGE(@"SEL$1")
  218.       OUTLINE(@"SEL$88215DA2")
  219.       OUTLINE(@"SEL$7")
  220.       MERGE(@"SEL$88215DA2")
  221.       OUTLINE(@"SEL$A21F0E08")
  222.       OUTLINE(@"SEL$36")
  223.       OUTLINE(@"SEL$37")
  224.       MERGE(@"SEL$A21F0E08")
  225.       MERGE(@"SEL$36")
  226.       OUTLINE(@"SEL$B718BC10")
  227.       OUTLINE(@"SEL$38")
  228.       OUTLINE(@"SEL$39")
  229.       MERGE(@"SEL$B718BC10")
  230.       MERGE(@"SEL$38")
  231.       OUTLINE(@"SEL$CD974F44")
  232.       OUTLINE(@"SEL$40")
  233.       OUTLINE(@"SEL$41")
  234.       OUTLINE(@"SEL$9")
  235.       OUTLINE(@"SEL$10")
  236.       OUTLINE(@"SEL$12")
  237.       OUTLINE(@"SEL$35")
  238.       OUTLINE(@"SEL$29")
  239.       OUTLINE(@"SEL$28")
  240.       OUTLINE(@"SEL$31")
  241.       OUTLINE(@"SEL$26")
  242.       OUTLINE(@"SEL$27")
  243.       MERGE(@"SEL$CD974F44")
  244.       MERGE(@"SEL$40")
  245.       OUTLINE(@"SEL$4B64BC97")
  246.       OUTLINE(@"SEL$42")
  247.       MERGE(@"SEL$9")
  248.       MERGE(@"SEL$10")
  249.       OUTLINE(@"SEL$D12B0443")
  250.       OUTER_JOIN_TO_INNER(@"SEL$35")
  251.       OUTLINE(@"SEL$7AE1EEFE")
  252.       MERGE(@"SEL$29")
  253.       MERGE(@"SEL$28")
  254.       OUTLINE(@"SEL$99EC3EEC")
  255.       OUTLINE(@"SEL$32")
  256.       MERGE(@"SEL$26")
  257.       OUTLINE(@"SEL$86FB5FDD")
  258.       OUTLINE(@"SEL$34")
  259.       OUTLINE(@"SEL$22")
  260.       OUTLINE(@"SEL$21")
  261.       OUTLINE(@"SEL$24")
  262.       OUTLINE(@"SEL$17")
  263.       OUTLINE(@"SEL$16")
  264.       OUTLINE(@"SEL$19")
  265.       OUTLINE(@"SEL$14")
  266.       OUTLINE(@"SEL$15")
  267.       OUTLINE(@"SEL$2")
  268.       OUTLINE(@"SEL$4")
  269.       OUTLINE(@"SEL$8")
  270.       MERGE(@"SEL$4B64BC97")
  271.       OUTLINE(@"SEL$24828B10")
  272.       OUTLINE(@"SEL$11")
  273.       MERGE(@"SEL$D12B0443")
  274.       OUTLINE(@"SEL$2FA95C49")
  275.       MERGE(@"SEL$99EC3EEC")
  276.       OUTLINE(@"SEL$F7FEA1E4")
  277.       MERGE(@"SEL$86FB5FDD")
  278.       OUTLINE(@"SEL$245B113C")
  279.       MERGE(@"SEL$22")
  280.       MERGE(@"SEL$21")
  281.       OUTLINE(@"SEL$152C305E")
  282.       OUTLINE(@"SEL$25")
  283.       MERGE(@"SEL$17")
  284.       MERGE(@"SEL$16")
  285.       OUTLINE(@"SEL$479BA092")
  286.       OUTLINE(@"SEL$20")
  287.       MERGE(@"SEL$14")
  288.       OUTLINE(@"SEL$DD6B2BE9")
  289.       OUTLINE(@"SEL$33")
  290.       MERGE(@"SEL$2")
  291.       OUTLINE(@"SEL$5BF935F8")
  292.       OUTLINE(@"SEL$5")
  293.       MERGE(@"SEL$8")
  294.       OUTLINE_LEAF(@"SEL$40D00EE7")
  295.       OUTLINE_LEAF(@"SET$1")
  296.       MERGE(@"SEL$11")
  297.       OUTLINE_LEAF(@"SEL$E54D090A")
  298.       OUTLINE_LEAF(@"SEL$13")
  299.       OUTLINE_LEAF(@"SET$2")
  300.       UNNEST(@"SEL$245B113C" UNNEST_INNERJ_DISTINCT_VIEW)
  301.       OUTLINE_LEAF(@"SEL$C3DEBEA4")
  302.       OUTLINE_LEAF(@"SEL$30")
  303.       OUTLINE_LEAF(@"SEL$D1537436")
  304.       MERGE(@"SEL$152C305E")
  305.       OUTLINE_LEAF(@"SEL$D68BA284")
  306.       OUTLINE_LEAF(@"SEL$23")
  307.       MERGE(@"SEL$479BA092")
  308.       OUTLINE_LEAF(@"SEL$2C22443D")
  309.       OUTLINE_LEAF(@"SEL$18")
  310.       MERGE(@"SEL$DD6B2BE9")
  311.       OUTLINE_LEAF(@"SEL$1089D2EB")
  312.       MERGE(@"SEL$5BF935F8")
  313.       OUTLINE_LEAF(@"SEL$EBDC700B")
  314.       OUTLINE_LEAF(@"SEL$3")
  315.       ALL_ROWS
  316.       OPT_PARAM('_fix_control' '17376322:0')
  317.       DB_VERSION('12.1.0.2')
  318.       OPTIMIZER_FEATURES_ENABLE('11.2.0.2')
  319.       IGNORE_OPTIM_EMBEDDED_HINTS
  320.       END_OUTLINE_DATA
  321.   */
  322.  
  323. Predicate Information (IDENTIFIED BY operation id):
  324. ---------------------------------------------------
  325.  
  326.    2 - access("WO_RTG"."WO_LINE"(+)="WO_BOM"."WO_LINE" AND "WO_RTG"."WO_NUM"(+)="WO_BOM"."WO_NUM"
  327.               AND "WO_RTG"."MAS_LOC"(+)="WO_BOM"."MAS_LOC" AND "WO_RTG"."CCN"(+)="WO_BOM"."CCN")
  328.        FILTER("WO_RTG"."OPERATION"(+)=CASE "WO_BOM"."OPERATION" WHEN ' ' THEN
  329.               "WO_RTG"."MIN_OPERATION"(+) ELSE "WO_BOM"."OPERATION" END )
  330.    9 - FILTER("APSSPLIT_MIN_OPERATION"."OPERATION_START_DATE" IS NOT NULL AND
  331.               "APSSPLIT_MIN_OPERATION"."OPERATION_START_DATE"<SYSDATE@!+:DAYS_AHEAD)
  332.   10 - access("WOWOB"."CCN"=PRIOR "WOWOB"."CCN" AND "WOWOB"."MAS_LOC"=PRIOR "WOWOB"."MAS_LOC" AND
  333.               "WOWOB"."PARENT_WO_NUM"=PRIOR "WOWOB"."WO_NUM" AND "WOWOB"."PARENT_WO_LINE"=PRIOR "WOWOB"."WO_LINE")
  334.   13 - access("APSSPLIT_MIN_OPERATION"."ORDER_LINE"(+)="WOWOB"."WO_LINE" AND
  335.               "APSSPLIT_MIN_OPERATION"."ORDERIDENT"(+)="WOWOB"."WO_NUM" AND
  336.               "APSSPLIT_MIN_OPERATION"."MAS_LOC"(+)="WOWOB"."MAS_LOC" AND
  337.               "APSSPLIT_MIN_OPERATION"."CCN"(+)="WOWOB"."CCN")
  338.   14 - access("WOWOB_KEY"="WOWOB"."CCN"||"WOWOB"."MAS_LOC"||"WOWOB"."WO_NUM"||"WOWOB"."WO_LINE")
  339.   17 - FILTER("PARENT_WOWOB"."CCN" IS NULL)
  340.   18 - access("WOWOB"."PARENT_WO_LINE"="PARENT_WOWOB"."WO_LINE"(+) AND
  341.               "WOWOB"."PARENT_WO_NUM"="PARENT_WOWOB"."WO_NUM"(+) AND
  342.               "WOWOB"."MAS_LOC"="PARENT_WOWOB"."MAS_LOC"(+) AND "WOWOB"."CCN"="PARENT_WOWOB"."CCN"(+))
  343.   19 - FILTER("PARENT_WOWOB"."CCN"(+)=:CCN AND "PARENT_WOWOB"."MAS_LOC"(+)=:MAS_LOC)
  344.   20 - FILTER("WOWOB"."CCN"=:CCN AND "WOWOB"."MAS_LOC"=:MAS_LOC)
  345.   24 - access("SCHEDULE"='SHOP' AND "ORDER_TYPE"='W')
  346.        FILTER("ORDER_TYPE"='W')
  347.   25 - access("WO"."CCN"="WOWOB"."CCN" AND "WO"."MAS_LOC"="WOWOB"."MAS_LOC" AND
  348.               "WO"."WO_NUM"="WOWOB"."WO_NUM" AND "WO"."WO_LINE"="WOWOB"."WO_LINE")
  349.   28 - access("APSSPLIT_MIN_OPERATION"."ORDER_LINE"(+)="WOWOB"."WO_LINE" AND
  350.               "APSSPLIT_MIN_OPERATION"."ORDERIDENT"(+)="WOWOB"."WO_NUM" AND
  351.               "APSSPLIT_MIN_OPERATION"."MAS_LOC"(+)="WOWOB"."MAS_LOC" AND
  352.               "APSSPLIT_MIN_OPERATION"."CCN"(+)="WOWOB"."CCN")
  353.   29 - access("connect$_by$_pump$_019"."prior wowob.ccn      "="WOWOB"."CCN" AND
  354.               "connect$_by$_pump$_019"."prior wowob.mas_loc  "="WOWOB"."MAS_LOC" AND
  355.               "connect$_by$_pump$_019"."prior wowob.wo_num   "="WOWOB"."PARENT_WO_NUM" AND
  356.               "connect$_by$_pump$_019"."prior wowob.wo_line  "="WOWOB"."PARENT_WO_LINE")
  357.   34 - access("SCHEDULE"='SHOP' AND "ORDER_TYPE"='W')
  358.        FILTER("ORDER_TYPE"='W')
  359.   36 - access("WO"."CCN"="WOWOB"."CCN" AND "WO"."MAS_LOC"="WOWOB"."MAS_LOC" AND
  360.               "WO"."WO_NUM"="WOWOB"."WO_NUM" AND "WO"."WO_LINE"="WOWOB"."WO_LINE")
  361.   38 - access("ITEM_CCN"."CCN"="WO"."CCN" AND "ITEM_CCN"."ITEM"="WO"."ITEM" AND
  362.               "ITEM_CCN"."REVISION"="WO"."REVISION")
  363.   41 - access("SCHEDULE"='SHOP' AND "ORDER_TYPE"='W' AND
  364.               "OPERATION_START_DATE"<SYSDATE@!+:DAYS_AHEAD)
  365.        FILTER("ORDER_TYPE"='W' AND "OPERATION_START_DATE"<SYSDATE@!+:DAYS_AHEAD)
  366.   42 - access("CCN"="WO"."CCN" AND "MAS_LOC"="WO"."MAS_LOC" AND "ORDERIDENT"="WO"."WO_NUM" AND
  367.               "ORDER_LINE"="WO"."WO_LINE")
  368.   44 - FILTER("ITEM_CCN"."MASTSCHED"='Y' AND "ITEM_CCN"."PRP"=' ' AND "ITEM_CCN"."PLANNED"=' ')
  369.   46 - access("CCN"="WO_BOM"."CCN" AND "MAS_LOC"="WO_BOM"."MAS_LOC" AND "WO_NUM"="WO_BOM"."WO_NUM"
  370.               AND "WO_LINE"="WO_BOM"."WO_LINE")
  371.   48 - access("WO_BOM_ITEM"."ITEM"(+)="WO_BOM"."ITEM" AND
  372.               "WO_BOM_ITEM"."REVISION"(+)="WO_BOM"."REVISION")
  373.   50 - access("WO"."CCN"(+)="CCN" AND "WO"."MAS_LOC"(+)="MAS_LOC" AND "WO"."WO_NUM"(+)="WO_NUM" AND
  374.               "WO"."WO_LINE"(+)="WO_LINE")
  375.   52 - access("WO_ITEM"."ITEM"(+)="WO"."ITEM" AND "WO_ITEM"."REVISION"(+)="WO"."REVISION")
  376.   54 - access("WO_RTG_MIN_OPERATION"."WO_LINE"(+)="WO_RTG"."WO_LINE" AND
  377.               "WO_RTG_MIN_OPERATION"."WO_NUM"(+)="WO_RTG"."WO_NUM" AND
  378.               "WO_RTG_MIN_OPERATION"."MAS_LOC"(+)="WO_RTG"."MAS_LOC" AND
  379.               "WO_RTG_MIN_OPERATION"."CCN"(+)="WO_RTG"."CCN")
  380.  
  381. COLUMN Projection Information (IDENTIFIED BY operation id):
  382. -----------------------------------------------------------
  383.  
  384.    1 - (#keys=1) "STARTDATE"[DATE,7], "CCN"[VARCHAR2,6], "MAS_LOC"[VARCHAR2,3],
  385.        "WO_NUM"[VARCHAR2,20], "WO_LINE"[VARCHAR2,4], "WO"."ITEM"[VARCHAR2,30],
  386.        "WO"."REVISION"[VARCHAR2,6], "WO_ITEM"."DESCRIPTION"[VARCHAR2,50], "WO_RTG"."WC"[VARCHAR2,8],
  387.        "WO_BOM"."REQD_QTY"[NUMBER,22], "MFGCLOSEDATE"[DATE,7], "CHASSISNUMBERS"[VARCHAR2,144],
  388.        "WO_LEVEL"[NUMBER,22], "PARENT_WO_NUM"[VARCHAR2,20], "PARENT_WO_LINE"[VARCHAR2,4],
  389.        "PARENT_WO_BOM_USEQ"[VARCHAR2,5], "WO_BOM"."CCN"[VARCHAR2,6], "WO_BOM"."MAS_LOC"[VARCHAR2,3],
  390.        "WO_BOM"."WO_NUM"[VARCHAR2,20], "WO_BOM"."WO_LINE"[VARCHAR2,4], "WO_BOM"."WO_BOM_USEQ"[VARCHAR2,5],
  391.        "WO_BOM"."ITEM"[VARCHAR2,30], "WO_BOM"."REVISION"[VARCHAR2,6],
  392.        "WO_BOM_ITEM"."DESCRIPTION"[VARCHAR2,50], "WO_BOM"."BOM_COMP_QTY"[NUMBER,22],
  393.        "WO_BOM"."BOM_COMMIT"[VARCHAR2,1], "WO_BOM"."BACKFLUSH"[VARCHAR2,1],
  394.        "WO_BOM"."ISSUE_QTY"[NUMBER,22], "WO_BOM"."COMMIT_QTY"[NUMBER,22]
  395.    2 - (#keys=4) "WO_BOM"."WO_LINE"[VARCHAR2,4], "WO_BOM"."WO_NUM"[VARCHAR2,20],
  396.        "WO_BOM"."MAS_LOC"[VARCHAR2,3], "WO_BOM"."CCN"[VARCHAR2,6], "CCN"[VARCHAR2,6],
  397.        "MAS_LOC"[VARCHAR2,3], "WO_NUM"[VARCHAR2,20], "WO_LINE"[VARCHAR2,4], "STARTDATE"[DATE,7],
  398.        "MFGCLOSEDATE"[DATE,7], "CHASSISNUMBERS"[VARCHAR2,144], "WO_LEVEL"[NUMBER,22],
  399.        "PARENT_WO_NUM"[VARCHAR2,20], "PARENT_WO_LINE"[VARCHAR2,4], "PARENT_WO_BOM_USEQ"[VARCHAR2,5],
  400.        "WO_ITEM"."DESCRIPTION"[VARCHAR2,50], "WO_BOM"."WO_BOM_USEQ"[VARCHAR2,5],
  401.        "WO_BOM"."ITEM"[VARCHAR2,30], "WO_BOM"."BOM_COMP_QTY"[NUMBER,22], "WO_BOM"."REVISION"[VARCHAR2,6],
  402.        "WO_BOM"."BOM_COMMIT"[VARCHAR2,1], "WO_BOM"."ISSUE_QTY"[NUMBER,22],
  403.        "WO_BOM"."COMMIT_QTY"[NUMBER,22], "WO_BOM"."REQD_QTY"[NUMBER,22], "WO_BOM"."BACKFLUSH"[VARCHAR2,1],
  404.        "WO_BOM_ITEM"."DESCRIPTION"[VARCHAR2,50], "WO"."ITEM"[VARCHAR2,30], "WO"."REVISION"[VARCHAR2,6],
  405.        "WO_RTG"."WC"[VARCHAR2,8]
  406.    3 - (#keys=0) "CCN"[VARCHAR2,6], "MAS_LOC"[VARCHAR2,3], "WO_NUM"[VARCHAR2,20],
  407.        "WO_LINE"[VARCHAR2,4], "STARTDATE"[DATE,7], "MFGCLOSEDATE"[DATE,7], "CHASSISNUMBERS"[VARCHAR2,144],
  408.        "WO_LEVEL"[NUMBER,22], "PARENT_WO_NUM"[VARCHAR2,20], "PARENT_WO_LINE"[VARCHAR2,4],
  409.        "PARENT_WO_BOM_USEQ"[VARCHAR2,5], "WO_BOM"."CCN"[VARCHAR2,6], "WO_BOM"."MAS_LOC"[VARCHAR2,3],
  410.        "WO_BOM"."WO_NUM"[VARCHAR2,20], "WO_BOM"."WO_LINE"[VARCHAR2,4], "WO_BOM"."WO_BOM_USEQ"[VARCHAR2,5],
  411.        "WO_BOM"."ITEM"[VARCHAR2,30], "WO_BOM"."BOM_COMP_QTY"[NUMBER,22], "WO_BOM"."REVISION"[VARCHAR2,6],
  412.        "WO_BOM"."OPERATION"[VARCHAR2,4], "WO_BOM"."BOM_COMMIT"[VARCHAR2,1],
  413.        "WO_BOM"."ISSUE_QTY"[NUMBER,22], "WO_BOM"."COMMIT_QTY"[NUMBER,22], "WO_BOM"."REQD_QTY"[NUMBER,22],
  414.        "WO_BOM"."BACKFLUSH"[VARCHAR2,1], "WO_BOM_ITEM"."DESCRIPTION"[VARCHAR2,50],
  415.        "WO"."ITEM"[VARCHAR2,30], "WO"."REVISION"[VARCHAR2,6], "WO_ITEM"."DESCRIPTION"[VARCHAR2,50]
  416.    4 - (#keys=0) "CCN"[VARCHAR2,6], "MAS_LOC"[VARCHAR2,3], "WO_NUM"[VARCHAR2,20],
  417.        "WO_LINE"[VARCHAR2,4], "STARTDATE"[DATE,7], "MFGCLOSEDATE"[DATE,7], "CHASSISNUMBERS"[VARCHAR2,144],
  418.        "WO_LEVEL"[NUMBER,22], "PARENT_WO_NUM"[VARCHAR2,20], "PARENT_WO_LINE"[VARCHAR2,4],
  419.        "PARENT_WO_BOM_USEQ"[VARCHAR2,5], "WO_BOM"."CCN"[VARCHAR2,6], "WO_BOM"."MAS_LOC"[VARCHAR2,3],
  420.        "WO_BOM"."WO_NUM"[VARCHAR2,20], "WO_BOM"."WO_LINE"[VARCHAR2,4], "WO_BOM"."WO_BOM_USEQ"[VARCHAR2,5],
  421.        "WO_BOM"."ITEM"[VARCHAR2,30], "WO_BOM"."BOM_COMP_QTY"[NUMBER,22], "WO_BOM"."REVISION"[VARCHAR2,6],
  422.        "WO_BOM"."OPERATION"[VARCHAR2,4], "WO_BOM"."BOM_COMMIT"[VARCHAR2,1],
  423.        "WO_BOM"."ISSUE_QTY"[NUMBER,22], "WO_BOM"."COMMIT_QTY"[NUMBER,22], "WO_BOM"."REQD_QTY"[NUMBER,22],
  424.        "WO_BOM"."BACKFLUSH"[VARCHAR2,1], "WO_BOM_ITEM"."DESCRIPTION"[VARCHAR2,50],
  425.        "WO"."ITEM"[VARCHAR2,30], "WO"."REVISION"[VARCHAR2,6]
  426.    5 - (#keys=0) "CCN"[VARCHAR2,6], "MAS_LOC"[VARCHAR2,3], "WO_NUM"[VARCHAR2,20],
  427.        "WO_LINE"[VARCHAR2,4], "STARTDATE"[DATE,7], "MFGCLOSEDATE"[DATE,7], "CHASSISNUMBERS"[VARCHAR2,144],
  428.        "WO_LEVEL"[NUMBER,22], "PARENT_WO_NUM"[VARCHAR2,20], "PARENT_WO_LINE"[VARCHAR2,4],
  429.        "PARENT_WO_BOM_USEQ"[VARCHAR2,5], "WO_BOM"."CCN"[VARCHAR2,6], "WO_BOM"."MAS_LOC"[VARCHAR2,3],
  430.        "WO_BOM"."WO_NUM"[VARCHAR2,20], "WO_BOM"."WO_LINE"[VARCHAR2,4], "WO_BOM"."WO_BOM_USEQ"[VARCHAR2,5],
  431.        "WO_BOM"."ITEM"[VARCHAR2,30], "WO_BOM"."BOM_COMP_QTY"[NUMBER,22], "WO_BOM"."REVISION"[VARCHAR2,6],
  432.        "WO_BOM"."OPERATION"[VARCHAR2,4], "WO_BOM"."BOM_COMMIT"[VARCHAR2,1],
  433.        "WO_BOM"."ISSUE_QTY"[NUMBER,22], "WO_BOM"."COMMIT_QTY"[NUMBER,22], "WO_BOM"."REQD_QTY"[NUMBER,22],
  434.        "WO_BOM"."BACKFLUSH"[VARCHAR2,1], "WO_BOM_ITEM"."DESCRIPTION"[VARCHAR2,50]
  435.    6 - (#keys=0) "CCN"[VARCHAR2,6], "MAS_LOC"[VARCHAR2,3], "WO_NUM"[VARCHAR2,20],
  436.        "WO_LINE"[VARCHAR2,4], "STARTDATE"[DATE,7], "MFGCLOSEDATE"[DATE,7], "CHASSISNUMBERS"[VARCHAR2,144],
  437.        "WO_LEVEL"[NUMBER,22], "PARENT_WO_NUM"[VARCHAR2,20], "PARENT_WO_LINE"[VARCHAR2,4],
  438.        "PARENT_WO_BOM_USEQ"[VARCHAR2,5], "WO_BOM"."CCN"[VARCHAR2,6], "WO_BOM"."MAS_LOC"[VARCHAR2,3],
  439.        "WO_BOM"."WO_NUM"[VARCHAR2,20], "WO_BOM"."WO_LINE"[VARCHAR2,4], "WO_BOM"."WO_BOM_USEQ"[VARCHAR2,5],
  440.        "WO_BOM"."ITEM"[VARCHAR2,30], "WO_BOM"."BOM_COMP_QTY"[NUMBER,22], "WO_BOM"."REVISION"[VARCHAR2,6],
  441.        "WO_BOM"."OPERATION"[VARCHAR2,4], "WO_BOM"."BOM_COMMIT"[VARCHAR2,1],
  442.        "WO_BOM"."ISSUE_QTY"[NUMBER,22], "WO_BOM"."COMMIT_QTY"[NUMBER,22], "WO_BOM"."REQD_QTY"[NUMBER,22],
  443.        "WO_BOM"."BACKFLUSH"[VARCHAR2,1]
  444.    7 - "CCN"[VARCHAR2,6], "MAS_LOC"[VARCHAR2,3], "WO_NUM"[VARCHAR2,20], "WO_LINE"[VARCHAR2,4],
  445.        "STARTDATE"[DATE,7], "MFGCLOSEDATE"[DATE,7], "CHASSISNUMBERS"[VARCHAR2,144], "WO_LEVEL"[NUMBER,22],
  446.        "PARENT_WO_NUM"[VARCHAR2,20], "PARENT_WO_LINE"[VARCHAR2,4], "PARENT_WO_BOM_USEQ"[VARCHAR2,5]
  447.    8 - STRDEF[3], STRDEF[6], STRDEF[3], STRDEF[20], STRDEF[4], STRDEF[7], STRDEF[7], STRDEF[144],
  448.        STRDEF[22], STRDEF[20], STRDEF[4], STRDEF[5]
  449.    9 - "WOWOB"."PARENT_WO_LINE"[VARCHAR2,4], "WOWOB"."WO_LINE"[VARCHAR2,4],
  450.        "WOWOB"."PARENT_WO_NUM"[VARCHAR2,20], "WOWOB"."WO_NUM"[VARCHAR2,20], "WOWOB"."MAS_LOC"[VARCHAR2,3],
  451.        "WOWOB"."CCN"[VARCHAR2,6], "APSSPLIT_MIN_OPERATION"."OPERATION_START_DATE"[DATE,7],
  452.        "WOWOB"."PARENT_WO_BOM_USEQ"[VARCHAR2,5], "WO"."CHASSIS5"[VARCHAR2,30],
  453.        "WO"."CHASSIS4"[VARCHAR2,30], "WO"."CHASSIS3"[VARCHAR2,30], "WO"."USER_ALPHA3"[VARCHAR2,30],
  454.        "WO"."USER_ALPHA2"[VARCHAR2,20], "WO"."MFG_CLOSE_DATE"[DATE,7], LEVEL[4]
  455.   10 - "WOWOB"."PARENT_WO_LINE"[VARCHAR2,4], "WOWOB"."WO_LINE"[VARCHAR2,4],
  456.        "WOWOB"."PARENT_WO_NUM"[VARCHAR2,20], "WOWOB"."WO_NUM"[VARCHAR2,20], "WOWOB"."MAS_LOC"[VARCHAR2,3],
  457.        "WOWOB"."CCN"[VARCHAR2,6], "APSSPLIT_MIN_OPERATION"."OPERATION_START_DATE"[DATE,7],
  458.        "WOWOB"."PARENT_WO_BOM_USEQ"[VARCHAR2,5], "WO"."CHASSIS5"[VARCHAR2,30],
  459.        "WO"."CHASSIS4"[VARCHAR2,30], "WO"."CHASSIS3"[VARCHAR2,30], "WO"."USER_ALPHA3"[VARCHAR2,30],
  460.        "WO"."USER_ALPHA2"[VARCHAR2,20], "WO"."MFG_CLOSE_DATE"[DATE,7], PRIOR NULL[6], PRIOR NULL[3], PRIOR
  461.        NULL[20], PRIOR NULL[4], LEVEL[4]
  462.   11 - (#keys=0) "WOWOB"."WO_LINE"[VARCHAR2,4], "APSSPLIT_MIN_OPERATION"."ORDER_LINE"[VARCHAR2,4],
  463.        "WOWOB"."WO_NUM"[VARCHAR2,20], "APSSPLIT_MIN_OPERATION"."ORDERIDENT"[VARCHAR2,20],
  464.        "WOWOB"."MAS_LOC"[VARCHAR2,3], "APSSPLIT_MIN_OPERATION"."MAS_LOC"[VARCHAR2,3],
  465.        "WOWOB"."CCN"[VARCHAR2,6], "APSSPLIT_MIN_OPERATION"."CCN"[VARCHAR2,6], "WOWOB_KEY"[VARCHAR2,33],
  466.        "WOWOB"."CCN"||"WOWOB"."MAS_LOC"||"WOWOB"."WO_NUM"||"WOWOB"."WO_LINE"[33],
  467.        "WOWOB"."PARENT_WO_BOM_USEQ"[VARCHAR2,5], "WOWOB"."PARENT_WO_NUM"[VARCHAR2,20],
  468.        "WOWOB"."PARENT_WO_LINE"[VARCHAR2,4], "APSSPLIT_MIN_OPERATION"."OPERATION_START_DATE"[DATE,7],
  469.        "WO".ROWID[ROWID,10], "WO"."CCN"[VARCHAR2,6], "WO"."MAS_LOC"[VARCHAR2,3],
  470.        "WO"."WO_NUM"[VARCHAR2,20], "WO"."WO_LINE"[VARCHAR2,4], "WO"."MFG_CLOSE_DATE"[DATE,7],
  471.        "WO"."USER_ALPHA2"[VARCHAR2,20], "WO"."USER_ALPHA3"[VARCHAR2,30], "WO"."CHASSIS3"[VARCHAR2,30],
  472.        "WO"."CHASSIS4"[VARCHAR2,30], "WO"."CHASSIS5"[VARCHAR2,30]
  473.   12 - (#keys=0) "WOWOB"."WO_LINE"[VARCHAR2,4], "APSSPLIT_MIN_OPERATION"."ORDER_LINE"[VARCHAR2,4],
  474.        "WOWOB"."WO_NUM"[VARCHAR2,20], "APSSPLIT_MIN_OPERATION"."ORDERIDENT"[VARCHAR2,20],
  475.        "WOWOB"."MAS_LOC"[VARCHAR2,3], "APSSPLIT_MIN_OPERATION"."MAS_LOC"[VARCHAR2,3],
  476.        "WOWOB"."CCN"[VARCHAR2,6], "APSSPLIT_MIN_OPERATION"."CCN"[VARCHAR2,6], "WOWOB_KEY"[VARCHAR2,33],
  477.        "WOWOB"."CCN"||"WOWOB"."MAS_LOC"||"WOWOB"."WO_NUM"||"WOWOB"."WO_LINE"[33],
  478.        "WOWOB"."PARENT_WO_BOM_USEQ"[VARCHAR2,5], "WOWOB"."PARENT_WO_NUM"[VARCHAR2,20],
  479.        "WOWOB"."PARENT_WO_LINE"[VARCHAR2,4], "APSSPLIT_MIN_OPERATION"."OPERATION_START_DATE"[DATE,7],
  480.        "WO".ROWID[ROWID,10], "WO"."CCN"[VARCHAR2,6], "WO"."MAS_LOC"[VARCHAR2,3],
  481.        "WO"."WO_NUM"[VARCHAR2,20], "WO"."WO_LINE"[VARCHAR2,4]
  482.   13 - (#keys=4) "WOWOB"."WO_LINE"[VARCHAR2,4], "APSSPLIT_MIN_OPERATION"."ORDER_LINE"[VARCHAR2,4],
  483.        "WOWOB"."WO_NUM"[VARCHAR2,20], "APSSPLIT_MIN_OPERATION"."ORDERIDENT"[VARCHAR2,20],
  484.        "WOWOB"."MAS_LOC"[VARCHAR2,3], "APSSPLIT_MIN_OPERATION"."MAS_LOC"[VARCHAR2,3],
  485.        "WOWOB"."CCN"[VARCHAR2,6], "APSSPLIT_MIN_OPERATION"."CCN"[VARCHAR2,6], "WOWOB_KEY"[VARCHAR2,33],
  486.        "WOWOB"."CCN"||"WOWOB"."MAS_LOC"||"WOWOB"."WO_NUM"||"WOWOB"."WO_LINE"[33],
  487.        "WOWOB"."PARENT_WO_BOM_USEQ"[VARCHAR2,5], "WOWOB"."PARENT_WO_NUM"[VARCHAR2,20],
  488.        "WOWOB"."PARENT_WO_LINE"[VARCHAR2,4], "APSSPLIT_MIN_OPERATION"."OPERATION_START_DATE"[DATE,7]
  489.   14 - (#keys=1) "WOWOB_KEY"[VARCHAR2,33], "WOWOB"."CCN"||"WOWOB"."MAS_LOC"||"WOWOB"."WO_NUM"||"WOWO
  490.       B"."WO_LINE"[33], "WOWOB"."CCN"[VARCHAR2,6], "WOWOB"."MAS_LOC"[VARCHAR2,3],
  491.        "WOWOB"."WO_NUM"[VARCHAR2,20], "WOWOB"."WO_LINE"[VARCHAR2,4], "WOWOB"."PARENT_WO_NUM"[VARCHAR2,20],
  492.        "WOWOB"."PARENT_WO_LINE"[VARCHAR2,4], "WOWOB"."PARENT_WO_BOM_USEQ"[VARCHAR2,5]
  493.   15 - "WOWOB_KEY"[VARCHAR2,33]
  494.   16 - (#keys=1) "WOWOB"."CCN"||"WOWOB"."MAS_LOC"||"WOWOB"."WO_NUM"||"WOWOB"."WO_LINE"[33]
  495.   17 - "PARENT_WOWOB"."WO_LINE"[VARCHAR2,4], "WOWOB"."PARENT_WO_LINE"[VARCHAR2,4],
  496.        "PARENT_WOWOB"."WO_NUM"[VARCHAR2,20], "WOWOB"."PARENT_WO_NUM"[VARCHAR2,20],
  497.        "PARENT_WOWOB"."MAS_LOC"[VARCHAR2,3], "WOWOB"."MAS_LOC"[VARCHAR2,3],
  498.        "PARENT_WOWOB"."CCN"[VARCHAR2,6], "WOWOB"."CCN"[VARCHAR2,6], "WOWOB"."WO_NUM"[VARCHAR2,20],
  499.        "WOWOB"."WO_LINE"[VARCHAR2,4]
  500.   18 - (#keys=4) "PARENT_WOWOB"."WO_LINE"[VARCHAR2,4], "WOWOB"."PARENT_WO_LINE"[VARCHAR2,4],
  501.        "PARENT_WOWOB"."WO_NUM"[VARCHAR2,20], "WOWOB"."PARENT_WO_NUM"[VARCHAR2,20],
  502.        "PARENT_WOWOB"."MAS_LOC"[VARCHAR2,3], "WOWOB"."MAS_LOC"[VARCHAR2,3],
  503.        "PARENT_WOWOB"."CCN"[VARCHAR2,6], "WOWOB"."CCN"[VARCHAR2,6], "WOWOB"."WO_NUM"[VARCHAR2,20],
  504.        "WOWOB"."WO_LINE"[VARCHAR2,4]
  505.   19 - "PARENT_WOWOB"."CCN"[VARCHAR2,6], "PARENT_WOWOB"."MAS_LOC"[VARCHAR2,3],
  506.        "PARENT_WOWOB"."WO_NUM"[VARCHAR2,20], "PARENT_WOWOB"."WO_LINE"[VARCHAR2,4]
  507.   20 - "WOWOB"."CCN"[VARCHAR2,6], "WOWOB"."MAS_LOC"[VARCHAR2,3], "WOWOB"."WO_NUM"[VARCHAR2,20],
  508.        "WOWOB"."WO_LINE"[VARCHAR2,4], "WOWOB"."PARENT_WO_NUM"[VARCHAR2,20],
  509.        "WOWOB"."PARENT_WO_LINE"[VARCHAR2,4]
  510.   21 - "WOWOB"."CCN"[VARCHAR2,6], "WOWOB"."MAS_LOC"[VARCHAR2,3], "WOWOB"."WO_NUM"[VARCHAR2,20],
  511.        "WOWOB"."WO_LINE"[VARCHAR2,4], "WOWOB"."PARENT_WO_NUM"[VARCHAR2,20],
  512.        "WOWOB"."PARENT_WO_LINE"[VARCHAR2,4], "WOWOB"."PARENT_WO_BOM_USEQ"[VARCHAR2,5]
  513.   22 - "APSSPLIT_MIN_OPERATION"."CCN"[VARCHAR2,6], "APSSPLIT_MIN_OPERATION"."MAS_LOC"[VARCHAR2,3],
  514.        "APSSPLIT_MIN_OPERATION"."ORDERIDENT"[VARCHAR2,20],
  515.        "APSSPLIT_MIN_OPERATION"."ORDER_LINE"[VARCHAR2,4],
  516.        "APSSPLIT_MIN_OPERATION"."OPERATION_START_DATE"[DATE,7]
  517.   23 - (#keys=5) "CCN"[VARCHAR2,6], "MAS_LOC"[VARCHAR2,3], "ORDERIDENT"[VARCHAR2,20],
  518.        "ORDER_LINE"[VARCHAR2,4], "OPERATION_START_DATE"[DATE,7], MIN(TO_NUMBER(TRIM("OPERATION")))[22]
  519.   24 - "APSSPLIT".ROWID[ROWID,10], "SCHEDULE"[VARCHAR2,6], "CCN"[VARCHAR2,6],
  520.        "MAS_LOC"[VARCHAR2,3], "ORDER_TYPE"[VARCHAR2,1], "ORDERIDENT"[VARCHAR2,20],
  521.        "ORDER_LINE"[VARCHAR2,4], "OPERATION"[VARCHAR2,4], "OPERATION_START_DATE"[DATE,7]
  522.   25 - "WO".ROWID[ROWID,10], "WO"."CCN"[VARCHAR2,6], "WO"."MAS_LOC"[VARCHAR2,3],
  523.        "WO"."WO_NUM"[VARCHAR2,20], "WO"."WO_LINE"[VARCHAR2,4]
  524.   26 - "WO".ROWID[ROWID,10], "WO"."MFG_CLOSE_DATE"[DATE,7], "WO"."USER_ALPHA2"[VARCHAR2,20],
  525.        "WO"."USER_ALPHA3"[VARCHAR2,30], "WO"."CHASSIS3"[VARCHAR2,30], "WO"."CHASSIS4"[VARCHAR2,30],
  526.        "WO"."CHASSIS5"[VARCHAR2,30]
  527.   27 - (#keys=0) "WOWOB"."WO_LINE"[VARCHAR2,4], "APSSPLIT_MIN_OPERATION"."ORDER_LINE"[VARCHAR2,4],
  528.        "WOWOB"."WO_NUM"[VARCHAR2,20], "APSSPLIT_MIN_OPERATION"."ORDERIDENT"[VARCHAR2,20],
  529.        "WOWOB"."MAS_LOC"[VARCHAR2,3], "APSSPLIT_MIN_OPERATION"."MAS_LOC"[VARCHAR2,3],
  530.        "WOWOB"."CCN"[VARCHAR2,6], "APSSPLIT_MIN_OPERATION"."CCN"[VARCHAR2,6],
  531.        "connect$_by$_pump$_019"."prior wowob.ccn      "[VARCHAR2,6], "WOWOB"."PARENT_WO_LINE"[VARCHAR2,4],
  532.        "connect$_by$_pump$_019"."prior wowob.mas_loc  "[VARCHAR2,3],
  533.        "WOWOB"."PARENT_WO_BOM_USEQ"[VARCHAR2,5], "connect$_by$_pump$_019"."prior wowob.wo_num  
  534.       "[VARCHAR2,20], "WOWOB"."PARENT_WO_NUM"[VARCHAR2,20], "connect$_by$_pump$_019"."prior wowob.wo_line
  535.        "[VARCHAR2,4], "APSSPLIT_MIN_OPERATION"."OPERATION_START_DATE"[DATE,7], "WO".ROWID[ROWID,10],
  536.        "WO"."CCN"[VARCHAR2,6], "WO"."MAS_LOC"[VARCHAR2,3], "WO"."WO_NUM"[VARCHAR2,20],
  537.        "WO"."WO_LINE"[VARCHAR2,4], "WO"."MFG_CLOSE_DATE"[DATE,7], "WO"."USER_ALPHA2"[VARCHAR2,20],
  538.        "WO"."USER_ALPHA3"[VARCHAR2,30], "WO"."CHASSIS3"[VARCHAR2,30], "WO"."CHASSIS4"[VARCHAR2,30],
  539.        "WO"."CHASSIS5"[VARCHAR2,30]
  540.   28 - (#keys=4) "WOWOB"."WO_LINE"[VARCHAR2,4], "APSSPLIT_MIN_OPERATION"."ORDER_LINE"[VARCHAR2,4],
  541.        "WOWOB"."WO_NUM"[VARCHAR2,20], "APSSPLIT_MIN_OPERATION"."ORDERIDENT"[VARCHAR2,20],
  542.        "WOWOB"."MAS_LOC"[VARCHAR2,3], "APSSPLIT_MIN_OPERATION"."MAS_LOC"[VARCHAR2,3],
  543.        "WOWOB"."CCN"[VARCHAR2,6], "APSSPLIT_MIN_OPERATION"."CCN"[VARCHAR2,6],
  544.        "connect$_by$_pump$_019"."prior wowob.ccn      "[VARCHAR2,6], "WOWOB"."PARENT_WO_LINE"[VARCHAR2,4],
  545.        "connect$_by$_pump$_019"."prior wowob.mas_loc  "[VARCHAR2,3],
  546.        "WOWOB"."PARENT_WO_BOM_USEQ"[VARCHAR2,5], "connect$_by$_pump$_019"."prior wowob.wo_num  
  547.       "[VARCHAR2,20], "WOWOB"."PARENT_WO_NUM"[VARCHAR2,20], "connect$_by$_pump$_019"."prior wowob.wo_line
  548.        "[VARCHAR2,4], "APSSPLIT_MIN_OPERATION"."OPERATION_START_DATE"[DATE,7]
  549.   29 - (#keys=4) "connect$_by$_pump$_019"."prior wowob.ccn      "[VARCHAR2,6],
  550.        "WOWOB"."CCN"[VARCHAR2,6], "connect$_by$_pump$_019"."prior wowob.mas_loc  "[VARCHAR2,3],
  551.        "WOWOB"."MAS_LOC"[VARCHAR2,3], "connect$_by$_pump$_019"."prior wowob.wo_num   "[VARCHAR2,20],
  552.        "WOWOB"."PARENT_WO_NUM"[VARCHAR2,20], "connect$_by$_pump$_019"."prior wowob.wo_line  "[VARCHAR2,4],
  553.        "WOWOB"."PARENT_WO_LINE"[VARCHAR2,4], "WOWOB"."PARENT_WO_BOM_USEQ"[VARCHAR2,5],
  554.        "WOWOB"."WO_LINE"[VARCHAR2,4], "WOWOB"."WO_NUM"[VARCHAR2,20]
  555.   30 - "connect$_by$_pump$_019"."prior wowob.ccn      "[VARCHAR2,6],
  556.        "connect$_by$_pump$_019"."prior wowob.mas_loc  "[VARCHAR2,3], "connect$_by$_pump$_019"."prior
  557.       wowob.wo_num   "[VARCHAR2,20], "connect$_by$_pump$_019"."prior wowob.wo_line  "[VARCHAR2,4]
  558.   31 - "WOWOB"."CCN"[VARCHAR2,6], "WOWOB"."MAS_LOC"[VARCHAR2,3], "WOWOB"."WO_NUM"[VARCHAR2,20],
  559.        "WOWOB"."WO_LINE"[VARCHAR2,4], "WOWOB"."PARENT_WO_NUM"[VARCHAR2,20],
  560.        "WOWOB"."PARENT_WO_LINE"[VARCHAR2,4], "WOWOB"."PARENT_WO_BOM_USEQ"[VARCHAR2,5]
  561.   32 - "APSSPLIT_MIN_OPERATION"."CCN"[VARCHAR2,6], "APSSPLIT_MIN_OPERATION"."MAS_LOC"[VARCHAR2,3],
  562.        "APSSPLIT_MIN_OPERATION"."ORDERIDENT"[VARCHAR2,20],
  563.        "APSSPLIT_MIN_OPERATION"."ORDER_LINE"[VARCHAR2,4],
  564.        "APSSPLIT_MIN_OPERATION"."OPERATION_START_DATE"[DATE,7]
  565.   33 - (#keys=5) "CCN"[VARCHAR2,6], "MAS_LOC"[VARCHAR2,3], "ORDERIDENT"[VARCHAR2,20],
  566.        "ORDER_LINE"[VARCHAR2,4], "OPERATION_START_DATE"[DATE,7], MIN(TO_NUMBER(TRIM("OPERATION")))[22]
  567.   34 - "APSSPLIT".ROWID[ROWID,10], "SCHEDULE"[VARCHAR2,6], "CCN"[VARCHAR2,6],
  568.        "MAS_LOC"[VARCHAR2,3], "ORDER_TYPE"[VARCHAR2,1], "ORDERIDENT"[VARCHAR2,20],
  569.        "ORDER_LINE"[VARCHAR2,4], "OPERATION"[VARCHAR2,4], "OPERATION_START_DATE"[DATE,7]
  570.   35 - "WO".ROWID[ROWID,10], "WO"."CCN"[VARCHAR2,6], "WO"."MAS_LOC"[VARCHAR2,3],
  571.        "WO"."WO_NUM"[VARCHAR2,20], "WO"."WO_LINE"[VARCHAR2,4], "WO"."MFG_CLOSE_DATE"[DATE,7],
  572.        "WO"."USER_ALPHA2"[VARCHAR2,20], "WO"."USER_ALPHA3"[VARCHAR2,30], "WO"."CHASSIS3"[VARCHAR2,30],
  573.        "WO"."CHASSIS4"[VARCHAR2,30], "WO"."CHASSIS5"[VARCHAR2,30]
  574.   36 - "WO".ROWID[ROWID,10], "WO"."CCN"[VARCHAR2,6], "WO"."MAS_LOC"[VARCHAR2,3],
  575.        "WO"."WO_NUM"[VARCHAR2,20], "WO"."WO_LINE"[VARCHAR2,4]
  576.   37 - (#keys=17) "CCN"[VARCHAR2,6], "MAS_LOC"[VARCHAR2,3], "ORDERIDENT"[VARCHAR2,20],
  577.        "ORDER_LINE"[VARCHAR2,4], "OPERATION_START_DATE"[DATE,7], ROWID[ROWID,10], ROWID[ROWID,10],
  578.        "WO"."CHASSIS5"[VARCHAR2,30], "WO"."CHASSIS4"[VARCHAR2,30], "WO"."CHASSIS3"[VARCHAR2,30],
  579.        "WO"."USER_ALPHA3"[VARCHAR2,30], "WO"."USER_ALPHA2"[VARCHAR2,20], "WO"."MFG_CLOSE_DATE"[DATE,7],
  580.        "WO"."WO_LINE"[VARCHAR2,4], "WO"."WO_NUM"[VARCHAR2,20], "WO"."MAS_LOC"[VARCHAR2,3],
  581.        "WO"."CCN"[VARCHAR2,6]
  582.   38 - (#keys=3) "WO"."CCN"[VARCHAR2,6], "CCN"[VARCHAR2,6], "MAS_LOC"[VARCHAR2,3],
  583.        "ORDERIDENT"[VARCHAR2,20], "ORDER_LINE"[VARCHAR2,4], "OPERATION_START_DATE"[DATE,7],
  584.        ROWID[ROWID,10], "WO"."CHASSIS5"[VARCHAR2,30], "WO"."MAS_LOC"[VARCHAR2,3],
  585.        "WO"."WO_NUM"[VARCHAR2,20], "WO"."WO_LINE"[VARCHAR2,4], "WO"."CHASSIS4"[VARCHAR2,30],
  586.        "WO"."CHASSIS3"[VARCHAR2,30], "WO"."MFG_CLOSE_DATE"[DATE,7], "WO"."USER_ALPHA2"[VARCHAR2,20],
  587.        "WO"."USER_ALPHA3"[VARCHAR2,30], ROWID[ROWID,10]
  588.   39 - (#keys=0) "CCN"[VARCHAR2,6], "MAS_LOC"[VARCHAR2,3], "ORDERIDENT"[VARCHAR2,20],
  589.        "ORDER_LINE"[VARCHAR2,4], "OPERATION_START_DATE"[DATE,7], ROWID[ROWID,10], "WO"."CCN"[VARCHAR2,6],
  590.        "WO"."MAS_LOC"[VARCHAR2,3], "WO"."WO_NUM"[VARCHAR2,20], "WO"."WO_LINE"[VARCHAR2,4],
  591.        "WO"."ITEM"[VARCHAR2,30], "WO"."REVISION"[VARCHAR2,6], "WO"."MFG_CLOSE_DATE"[DATE,7],
  592.        "WO"."USER_ALPHA2"[VARCHAR2,20], "WO"."USER_ALPHA3"[VARCHAR2,30], "WO"."CHASSIS3"[VARCHAR2,30],
  593.        "WO"."CHASSIS4"[VARCHAR2,30], "WO"."CHASSIS5"[VARCHAR2,30]
  594.   40 - (#keys=0) "CCN"[VARCHAR2,6], "MAS_LOC"[VARCHAR2,3], "ORDERIDENT"[VARCHAR2,20],
  595.        "ORDER_LINE"[VARCHAR2,4], "OPERATION_START_DATE"[DATE,7], ROWID[ROWID,10], "WO"."CCN"[VARCHAR2,6],
  596.        "WO"."MAS_LOC"[VARCHAR2,3], "WO"."WO_NUM"[VARCHAR2,20], "WO"."WO_LINE"[VARCHAR2,4]
  597.   41 - "CCN"[VARCHAR2,6], "MAS_LOC"[VARCHAR2,3], "ORDERIDENT"[VARCHAR2,20],
  598.        "ORDER_LINE"[VARCHAR2,4], "OPERATION_START_DATE"[DATE,7]
  599.   42 - ROWID[ROWID,10], "WO"."CCN"[VARCHAR2,6], "WO"."MAS_LOC"[VARCHAR2,3],
  600.        "WO"."WO_NUM"[VARCHAR2,20], "WO"."WO_LINE"[VARCHAR2,4]
  601.   43 - ROWID[ROWID,10], "WO"."ITEM"[VARCHAR2,30], "WO"."REVISION"[VARCHAR2,6],
  602.        "WO"."MFG_CLOSE_DATE"[DATE,7], "WO"."USER_ALPHA2"[VARCHAR2,20], "WO"."USER_ALPHA3"[VARCHAR2,30],
  603.        "WO"."CHASSIS3"[VARCHAR2,30], "WO"."CHASSIS4"[VARCHAR2,30], "WO"."CHASSIS5"[VARCHAR2,30]
  604.   44 - ROWID[ROWID,10], "ITEM_CCN"."CCN"[VARCHAR2,6], "ITEM_CCN"."ITEM"[VARCHAR2,30],
  605.        "ITEM_CCN"."REVISION"[VARCHAR2,6]
  606.   45 - "WO_BOM"."CCN"[VARCHAR2,6], "WO_BOM"."MAS_LOC"[VARCHAR2,3], "WO_BOM"."WO_NUM"[VARCHAR2,20],
  607.        "WO_BOM"."WO_LINE"[VARCHAR2,4], "WO_BOM"."WO_BOM_USEQ"[VARCHAR2,5], "WO_BOM"."ITEM"[VARCHAR2,30],
  608.        "WO_BOM"."BOM_COMP_QTY"[NUMBER,22], "WO_BOM"."REVISION"[VARCHAR2,6],
  609.        "WO_BOM"."OPERATION"[VARCHAR2,4], "WO_BOM"."BOM_COMMIT"[VARCHAR2,1],
  610.        "WO_BOM"."ISSUE_QTY"[NUMBER,22], "WO_BOM"."COMMIT_QTY"[NUMBER,22], "WO_BOM"."REQD_QTY"[NUMBER,22],
  611.        "WO_BOM"."BACKFLUSH"[VARCHAR2,1]
  612.   46 - "WO_BOM".ROWID[ROWID,10], "WO_BOM"."CCN"[VARCHAR2,6], "WO_BOM"."MAS_LOC"[VARCHAR2,3],
  613.        "WO_BOM"."WO_NUM"[VARCHAR2,20], "WO_BOM"."WO_LINE"[VARCHAR2,4], "WO_BOM"."WO_BOM_USEQ"[VARCHAR2,5]
  614.   47 - "WO_BOM_ITEM"."DESCRIPTION"[VARCHAR2,50]
  615.   48 - "WO_BOM_ITEM".ROWID[ROWID,10]
  616.   49 - "WO"."ITEM"[VARCHAR2,30], "WO"."REVISION"[VARCHAR2,6]
  617.   50 - "WO".ROWID[ROWID,10]
  618.   51 - "WO_ITEM"."DESCRIPTION"[VARCHAR2,50]
  619.   52 - "WO_ITEM".ROWID[ROWID,10]
  620.   53 - "WO_RTG"."MIN_OPERATION"[VARCHAR2,4], "WO_RTG"."CCN"[VARCHAR2,6],
  621.        "WO_RTG"."MAS_LOC"[VARCHAR2,3], "WO_RTG"."WO_NUM"[VARCHAR2,20], "WO_RTG"."WO_LINE"[VARCHAR2,4],
  622.        "WO_RTG"."OPERATION"[VARCHAR2,4], "WO_RTG"."WC"[VARCHAR2,8]
  623.   54 - (#keys=4) "WO_RTG"."WO_LINE"[VARCHAR2,4], "WO_RTG"."WO_NUM"[VARCHAR2,20],
  624.        "WO_RTG"."MAS_LOC"[VARCHAR2,3], "WO_RTG"."CCN"[VARCHAR2,6],
  625.        "WO_RTG_MIN_OPERATION"."MIN_OPERATION"[VARCHAR2,4], "WO_RTG"."OPERATION"[VARCHAR2,4],
  626.        "WO_RTG"."WC"[VARCHAR2,8]
  627.   55 - "WO_RTG_MIN_OPERATION"."CCN"[VARCHAR2,6], "WO_RTG_MIN_OPERATION"."MAS_LOC"[VARCHAR2,3],
  628.        "WO_RTG_MIN_OPERATION"."WO_NUM"[VARCHAR2,20], "WO_RTG_MIN_OPERATION"."WO_LINE"[VARCHAR2,4],
  629.        "WO_RTG_MIN_OPERATION"."MIN_OPERATION"[VARCHAR2,4]
  630.   56 - (#keys=4) "CCN"[VARCHAR2,6], "MAS_LOC"[VARCHAR2,3], "WO_NUM"[VARCHAR2,20],
  631.        "WO_LINE"[VARCHAR2,4], MIN(TO_NUMBER(TRIM("OPERATION")))[22]
  632.   57 - "CCN"[VARCHAR2,6], "MAS_LOC"[VARCHAR2,3], "WO_NUM"[VARCHAR2,20], "WO_LINE"[VARCHAR2,4],
  633.        "OPERATION"[VARCHAR2,4]
  634.   58 - "WO_RTG"."CCN"[VARCHAR2,6], "WO_RTG"."MAS_LOC"[VARCHAR2,3], "WO_RTG"."WO_NUM"[VARCHAR2,20],
  635.        "WO_RTG"."WO_LINE"[VARCHAR2,4], "WO_RTG"."OPERATION"[VARCHAR2,4], "WO_RTG"."WC"[VARCHAR2,8]
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!