SELECT /*+KLM1*/ skuId, skuNo, skuLongName, qtyAll, qtyGoodsInWardArea, qtyUnlockedPickable, qtyUnlockedAssigned, qtyUnlockedDeliverable, qtyUnlockedPicked, qtyFinishedPickTus, qtyLocked, pricePrjId, price, currency, sellingUnitQty, abcClass, abcExt, supplierNumber FROM HostWriteOnStockXXXView WHERE qtyUnlockedPickable > '0' OR qtyUnlockedAssigned > '0' OR qtyUnlockedDeliverable > '0' OR qtyUnlockedPicked > '0' OR qtyLocked > '0' Plan hash value: 1284517961 ---------------------------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Starts | E-Rows | Cost (%CPU)| A-Rows | A-Time | Buffers | Reads | ---------------------------------------------------------------------------------------------------------------------------------------------------------- |* 1 | FILTER | | 1 | | | 0 |00:00:00.01 | 0 | 0 | | 2 | HASH GROUP BY | | 1 | 113K| 18E (0)| 0 |00:00:00.01 | 0 | 0 | | 3 | VIEW | | 1 | 113K| 18E (0)| 35 |00:00:00.30 | 273 | 56 | | 4 | UNION-ALL | | 1 | | | 35 |00:00:00.30 | 273 | 56 | | 5 | NESTED LOOPS | | 1 | 111K| 361K (1)| 35 |00:00:00.30 | 273 | 56 | | 6 | NESTED LOOPS | | 1 | 92463 | 222K (1)| 36 |00:00:00.28 | 207 | 47 | | 7 | NESTED LOOPS | | 1 | 85474 | 94321 (1)| 36 |00:00:00.04 | 103 | 9 | | 8 | NESTED LOOPS | | 1 | 101K| 17860 (1)| 43 |00:00:00.04 | 15 | 9 | | 9 | VIEW | index$_join$_007 | 1 | 350 | 3 (0)| 2 |00:00:00.01 | 6 | 3 | |* 10 | HASH JOIN | | 1 | | | 2 |00:00:00.01 | 6 | 3 | | 11 | INDEX FAST FULL SCAN | I_SUPPLIERPRJ_1 | 1 | 350 | 1 (0)| 350 |00:00:00.01 | 3 | 2 | | 12 | INDEX FAST FULL SCAN | XPKSUPPLIERPRJ | 1 | 350 | 1 (0)| 2 |00:00:00.01 | 3 | 1 | |* 13 | TABLE ACCESS BY INDEX ROWID | SKUPRJ | 2 | 291 | 51 (0)| 43 |00:00:00.03 | 9 | 6 | |* 14 | INDEX RANGE SCAN | I_SKUPRJ_SUPPLIERPRJID | 2 | 395 | 1 (0)| 51 |00:00:00.01 | 4 | 2 | |* 15 | TABLE ACCESS BY INDEX ROWID | SKU | 43 | 1 | 1 (0)| 36 |00:00:00.01 | 88 | 0 | |* 16 | INDEX UNIQUE SCAN | XPKSKU | 43 | 1 | 1 (0)| 43 |00:00:00.01 | 45 | 0 | |* 17 | TABLE ACCESS BY INDEX ROWID | PRICEPRJ | 36 | 1 | 2 (0)| 36 |00:00:00.24 | 104 | 38 | |* 18 | INDEX RANGE SCAN | XAK1PRICEPRJ | 36 | 1 | 1 (0)| 67 |00:00:00.04 | 38 | 10 | |* 19 | INDEX RANGE SCAN | I_PACKINGUNIT_1 | 36 | 1 | 2 (0)| 35 |00:00:00.02 | 72 | 10 | |* 20 | FILTER | | 0 | | | 0 |00:00:00.01 | 0 | 0 | | 21 | NESTED LOOPS | | 0 | 8751 | 251K (1)| 0 |00:00:00.01 | 0 | 0 | | 22 | NESTED LOOPS | | 0 | 8891 | 238K (1)| 0 |00:00:00.01 | 0 | 0 | | 23 | NESTED LOOPS | | 0 | 10373 | 230K (1)| 0 |00:00:00.01 | 0 | 0 | | 24 | NESTED LOOPS | | 0 | 10373 | 222K (1)| 0 |00:00:00.01 | 0 | 0 | |* 25 | HASH JOIN | | 0 | 10373 | 215K (1)| 0 |00:00:00.01 | 0 | 0 | | 26 | NESTED LOOPS | | 0 | 13557 | 214K (1)| 0 |00:00:00.01 | 0 | 0 | | 27 | NESTED LOOPS | | 0 | 13557 | 194K (1)| 0 |00:00:00.01 | 0 | 0 | | 28 | NESTED LOOPS | | 0 | 13264 | 164K (1)| 0 |00:00:00.01 | 0 | 0 | |* 29 | HASH JOIN RIGHT ANTI | | 0 | 13264 | 144K (1)| 0 |00:00:00.01 | 0 | 0 | |* 30 | INDEX FAST FULL SCAN | I_COLLI_TUNING_1 | 0 | 58103 | 1697 (1)| 0 |00:00:00.01 | 0 | 0 | |* 31 | HASH JOIN RIGHT ANTI | | 0 | 67535 | 142K (1)| 0 |00:00:00.01 | 0 | 0 | | 32 | TABLE ACCESS BY INDEX ROWID | PICKTU | 0 | 6723 | 264 (0)| 0 |00:00:00.01 | 0 | 0 | |* 33 | INDEX RANGE SCAN | I_PICKTU_TUNING_2 | 0 | 6723 | 15 (0)| 0 |00:00:00.01 | 0 | 0 | | 34 | NESTED LOOPS | | 0 | 73815 | 142K (1)| 0 |00:00:00.01 | 0 | 0 | | 35 | NESTED LOOPS | | 0 | 78769 | 125K (1)| 0 |00:00:00.01 | 0 | 0 | | 36 | NESTED LOOPS | | 0 | 79037 | 107K (1)| 0 |00:00:00.01 | 0 | 0 | |* 37 | TABLE ACCESS FULL | TU | 0 | 79037 | 48581 (1)| 0 |00:00:00.01 | 0 | 0 | |* 38 | INDEX RANGE SCAN | I_SL_TUNING_3 | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |* 39 | INDEX FAST FULL SCAN | I_RACK_TUNING_3 | 0 | 1 | 0 (0)| 0 |00:00:00.01 | 0 | 0 | |* 40 | INDEX FAST FULL SCAN | I_WAREHOUSE_TUNING_2 | 0 | 1 | 0 (0)| 0 |00:00:00.01 | 0 | 0 | | 41 | TABLE ACCESS BY INDEX ROWID | TUPRJ | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |* 42 | INDEX UNIQUE SCAN | XPKTUPRJ | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |* 43 | TABLE ACCESS BY INDEX ROWID | LU | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |* 44 | INDEX RANGE SCAN | I_LU_TUNING_4 | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | | 45 | TABLE ACCESS BY INDEX ROWID | LUPRJ | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |* 46 | INDEX UNIQUE SCAN | XPKLUPRJ | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |* 47 | TABLE ACCESS FULL | PRICEPRJ | 0 | 107K| 477 (1)| 0 |00:00:00.01 | 0 | 0 | |* 48 | TABLE ACCESS BY INDEX ROWID | SKU | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |* 49 | INDEX UNIQUE SCAN | XPKSKU | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |* 50 | INDEX RANGE SCAN | TUNING_HOPE_02 | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | | 51 | TABLE ACCESS BY INDEX ROWID | SUPPLIERPRJ | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |* 52 | INDEX UNIQUE SCAN | XPKSUPPLIERPRJ | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | | 53 | TABLE ACCESS BY INDEX ROWID | PACKINGUNIT | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |* 54 | INDEX UNIQUE SCAN | XPKPACKINGUNIT | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |* 55 | TABLE ACCESS BY INDEX ROWID | TRANSPORT | 0 | 1 | 3 (0)| 0 |00:00:00.01 | 0 | 0 | |* 56 | INDEX RANGE SCAN | I_TR_TUNING_1 | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |* 57 | TABLE ACCESS BY INDEX ROWID | TRANSPORT | 0 | 1 | 3 (0)| 0 |00:00:00.01 | 0 | 0 | |* 58 | INDEX RANGE SCAN | I_TR_TUNING_1 | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |* 59 | TABLE ACCESS BY INDEX ROWID | TRANSPORT | 0 | 1 | 3 (0)| 0 |00:00:00.01 | 0 | 0 | |* 60 | INDEX RANGE SCAN | I_TR_TUNING_1 | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |* 61 | TABLE ACCESS BY INDEX ROWID | TUPRJ | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |* 62 | INDEX UNIQUE SCAN | XPKTUPRJ | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |* 63 | INDEX RANGE SCAN | I_TR_TUNING_1 | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |* 64 | INDEX RANGE SCAN | I_TR_TUNING_1 | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | | 65 | NESTED LOOPS | | 0 | 1 | 1445 (0)| 0 |00:00:00.01 | 0 | 0 | | 66 | NESTED LOOPS | | 0 | 1 | 1444 (0)| 0 |00:00:00.01 | 0 | 0 | | 67 | NESTED LOOPS | | 0 | 1 | 1443 (0)| 0 |00:00:00.01 | 0 | 0 | | 68 | NESTED LOOPS | | 0 | 240 | 1083 (0)| 0 |00:00:00.01 | 0 | 0 | | 69 | NESTED LOOPS | | 0 | 240 | 723 (0)| 0 |00:00:00.01 | 0 | 0 | | 70 | NESTED LOOPS | | 0 | 240 | 543 (0)| 0 |00:00:00.01 | 0 | 0 | | 71 | TABLE ACCESS BY INDEX ROWID | MAILORDER | 0 | 237 | 10 (0)| 0 |00:00:00.01 | 0 | 0 | |* 72 | INDEX RANGE SCAN | XIE2MAILORDER | 0 | 237 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |* 73 | TABLE ACCESS BY INDEX ROWID | MAILORDERPOS | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |* 74 | INDEX RANGE SCAN | I_MOP_TUNING_3 | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |* 75 | TABLE ACCESS BY INDEX ROWID | SKU | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |* 76 | INDEX UNIQUE SCAN | XPKSKU | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | | 77 | TABLE ACCESS BY INDEX ROWID | MAILORDERPOSPRJ | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |* 78 | INDEX UNIQUE SCAN | XPKMAILORDERPOSPRJ | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |* 79 | TABLE ACCESS BY INDEX ROWID | PRICEPRJ | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |* 80 | INDEX RANGE SCAN | XAK1PRICEPRJ | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |* 81 | INDEX RANGE SCAN | TUNING_HOPE_02 | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | | 82 | TABLE ACCESS BY INDEX ROWID | SUPPLIERPRJ | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |* 83 | INDEX UNIQUE SCAN | XPKSUPPLIERPRJ | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | | 84 | NESTED LOOPS | | 0 | 8 | 33434 (1)| 0 |00:00:00.01 | 0 | 0 | | 85 | NESTED LOOPS | | 0 | 9 | 33427 (1)| 0 |00:00:00.01 | 0 | 0 | | 86 | NESTED LOOPS | | 0 | 9 | 33421 (1)| 0 |00:00:00.01 | 0 | 0 | | 87 | NESTED LOOPS | | 0 | 8717 | 20341 (1)| 0 |00:00:00.01 | 0 | 0 | | 88 | NESTED LOOPS | | 0 | 8717 | 7261 (1)| 0 |00:00:00.01 | 0 | 0 | | 89 | NESTED LOOPS | | 0 | 8717 | 721 (0)| 0 |00:00:00.01 | 0 | 0 | | 90 | TABLE ACCESS BY INDEX ROWID | MAILORDER | 0 | 237 | 10 (0)| 0 |00:00:00.01 | 0 | 0 | |* 91 | INDEX RANGE SCAN | XIE2MAILORDER | 0 | 237 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |* 92 | TABLE ACCESS BY INDEX ROWID | MAILORDERPOS | 0 | 37 | 3 (0)| 0 |00:00:00.01 | 0 | 0 | |* 93 | INDEX RANGE SCAN | I_MOP_TUNING_3 | 0 | 37 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |* 94 | TABLE ACCESS BY INDEX ROWID | SKU | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |* 95 | INDEX UNIQUE SCAN | XPKSKU | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | | 96 | TABLE ACCESS BY INDEX ROWID | MAILORDERPOSPRJ | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |* 97 | INDEX UNIQUE SCAN | XPKMAILORDERPOSPRJ | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |* 98 | TABLE ACCESS BY INDEX ROWID | PRICEPRJ | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |* 99 | INDEX RANGE SCAN | XAK1PRICEPRJ | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |*100 | INDEX RANGE SCAN | TUNING_HOPE_02 | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | | 101 | TABLE ACCESS BY INDEX ROWID | SUPPLIERPRJ | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |*102 | INDEX UNIQUE SCAN | XPKSUPPLIERPRJ | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | | 103 | NESTED LOOPS | | 0 | 57 | 239K (1)| 0 |00:00:00.01 | 0 | 0 | | 104 | NESTED LOOPS | | 0 | 67 | 239K (1)| 0 |00:00:00.01 | 0 | 0 | | 105 | NESTED LOOPS | | 0 | 67 | 239K (1)| 0 |00:00:00.01 | 0 | 0 | | 106 | NESTED LOOPS | | 0 | 62404 | 145K (1)| 0 |00:00:00.01 | 0 | 0 | | 107 | NESTED LOOPS | | 0 | 62404 | 51962 (1)| 0 |00:00:00.01 | 0 | 0 | | 108 | NESTED LOOPS | | 0 | 62404 | 5140 (1)| 0 |00:00:00.01 | 0 | 0 | |*109 | TABLE ACCESS BY INDEX ROWID | MAILORDER | 0 | 1694 | 56 (0)| 0 |00:00:00.01 | 0 | 0 | |*110 | INDEX RANGE SCAN | XIE2MAILORDER | 0 | 1700 | 5 (0)| 0 |00:00:00.01 | 0 | 0 | |*111 | TABLE ACCESS BY INDEX ROWID | MAILORDERPOS | 0 | 37 | 3 (0)| 0 |00:00:00.01 | 0 | 0 | |*112 | INDEX RANGE SCAN | I_MOP_TUNING_3 | 0 | 37 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*113 | TABLE ACCESS BY INDEX ROWID | SKU | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |*114 | INDEX UNIQUE SCAN | XPKSKU | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | | 115 | TABLE ACCESS BY INDEX ROWID | MAILORDERPOSPRJ | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*116 | INDEX UNIQUE SCAN | XPKMAILORDERPOSPRJ | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |*117 | TABLE ACCESS BY INDEX ROWID | PRICEPRJ | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*118 | INDEX RANGE SCAN | XAK1PRICEPRJ | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |*119 | INDEX RANGE SCAN | TUNING_HOPE_02 | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | | 120 | TABLE ACCESS BY INDEX ROWID | SUPPLIERPRJ | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |*121 | INDEX UNIQUE SCAN | XPKSUPPLIERPRJ | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | | 122 | NESTED LOOPS | | 0 | 1 | 828 (0)| 0 |00:00:00.01 | 0 | 0 | | 123 | NESTED LOOPS | | 0 | 1 | 827 (0)| 0 |00:00:00.01 | 0 | 0 | | 124 | NESTED LOOPS | | 0 | 1 | 826 (0)| 0 |00:00:00.01 | 0 | 0 | | 125 | NESTED LOOPS | | 0 | 214 | 505 (0)| 0 |00:00:00.01 | 0 | 0 | | 126 | NESTED LOOPS | | 0 | 214 | 184 (0)| 0 |00:00:00.01 | 0 | 0 | | 127 | NESTED LOOPS | | 0 | 214 | 23 (0)| 0 |00:00:00.01 | 0 | 0 | | 128 | TABLE ACCESS BY INDEX ROWID | MAILORDER | 0 | 6 | 5 (0)| 0 |00:00:00.01 | 0 | 0 | |*129 | INDEX RANGE SCAN | I_MAILORDER_TUNING_5 | 0 | 6 | 5 (0)| 0 |00:00:00.01 | 0 | 0 | |*130 | TABLE ACCESS BY INDEX ROWID | MAILORDERPOS | 0 | 37 | 3 (0)| 0 |00:00:00.01 | 0 | 0 | |*131 | INDEX RANGE SCAN | I_MOP_TUNING_3 | 0 | 37 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*132 | TABLE ACCESS BY INDEX ROWID | SKU | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |*133 | INDEX UNIQUE SCAN | XPKSKU | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | | 134 | TABLE ACCESS BY INDEX ROWID | MAILORDERPOSPRJ | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*135 | INDEX UNIQUE SCAN | XPKMAILORDERPOSPRJ | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |*136 | TABLE ACCESS BY INDEX ROWID | PRICEPRJ | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*137 | INDEX RANGE SCAN | XAK1PRICEPRJ | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |*138 | INDEX RANGE SCAN | TUNING_HOPE_02 | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | | 139 | TABLE ACCESS BY INDEX ROWID | SUPPLIERPRJ | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |*140 | INDEX UNIQUE SCAN | XPKSUPPLIERPRJ | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | | 141 | NESTED LOOPS | | 0 | 1 | 274K (1)| 0 |00:00:00.01 | 0 | 0 | | 142 | NESTED LOOPS | | 0 | 1 | 274K (1)| 0 |00:00:00.01 | 0 | 0 | | 143 | NESTED LOOPS | | 0 | 1 | 274K (1)| 0 |00:00:00.01 | 0 | 0 | | 144 | NESTED LOOPS | | 0 | 75 | 273K (1)| 0 |00:00:00.01 | 0 | 0 | | 145 | NESTED LOOPS | | 0 | 77 | 273K (1)| 0 |00:00:00.01 | 0 | 0 | | 146 | NESTED LOOPS | | 0 | 77 | 273K (1)| 0 |00:00:00.01 | 0 | 0 | | 147 | NESTED LOOPS | | 0 | 77 | 273K (1)| 0 |00:00:00.01 | 0 | 0 | | 148 | NESTED LOOPS | | 0 | 71335 | 166K (1)| 0 |00:00:00.01 | 0 | 0 | | 149 | NESTED LOOPS | | 0 | 71335 | 59399 (1)| 0 |00:00:00.01 | 0 | 0 | | 150 | NESTED LOOPS | | 0 | 71335 | 5877 (1)| 0 |00:00:00.01 | 0 | 0 | | 151 | TABLE ACCESS BY INDEX ROWID | MAILORDER | 0 | 1937 | 63 (0)| 0 |00:00:00.01 | 0 | 0 | |*152 | INDEX RANGE SCAN | XIE2MAILORDER | 0 | 1937 | 6 (0)| 0 |00:00:00.01 | 0 | 0 | |*153 | TABLE ACCESS BY INDEX ROWID | MAILORDERPOS | 0 | 37 | 3 (0)| 0 |00:00:00.01 | 0 | 0 | |*154 | INDEX RANGE SCAN | I_MOP_TUNING_3 | 0 | 37 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*155 | TABLE ACCESS BY INDEX ROWID | SKU | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |*156 | INDEX UNIQUE SCAN | XPKSKU | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | | 157 | TABLE ACCESS BY INDEX ROWID | MAILORDERPOSPRJ | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*158 | INDEX UNIQUE SCAN | XPKMAILORDERPOSPRJ | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |*159 | TABLE ACCESS BY INDEX ROWID | PRICEPRJ | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*160 | INDEX RANGE SCAN | XAK1PRICEPRJ | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | | 161 | TABLE ACCESS BY INDEX ROWID | MAILINGPOS | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*162 | INDEX RANGE SCAN | XIF2MAILINGPOS | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | | 163 | TABLE ACCESS BY INDEX ROWID | PICKORDERPOS | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*164 | INDEX RANGE SCAN | XIF5PICKORDERPOS | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*165 | TABLE ACCESS BY INDEX ROWID | PICKTU | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*166 | INDEX UNIQUE SCAN | XPKPICKTU | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |*167 | TABLE ACCESS BY INDEX ROWID | PICK | 0 | 1 | 3 (0)| 0 |00:00:00.01 | 0 | 0 | |*168 | INDEX RANGE SCAN | XIF3PICK | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*169 | INDEX RANGE SCAN | TUNING_HOPE_02 | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | | 170 | TABLE ACCESS BY INDEX ROWID | SUPPLIERPRJ | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |*171 | INDEX UNIQUE SCAN | XPKSUPPLIERPRJ | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | | 172 | CONCATENATION | | 0 | | | 0 |00:00:00.01 | 0 | 0 | | 173 | NESTED LOOPS ANTI | | 0 | 951 | 18E (0)| 0 |00:00:00.01 | 0 | 0 | | 174 | NESTED LOOPS ANTI | | 0 | 4840 | 18E (0)| 0 |00:00:00.01 | 0 | 0 | | 175 | NESTED LOOPS | | 0 | 5290 | 18E (0)| 0 |00:00:00.01 | 0 | 0 | | 176 | MERGE JOIN | | 0 | 18E| 77P (12)| 0 |00:00:00.01 | 0 | 0 | | 177 | SORT JOIN | | 0 | 15E| 70P (3)| 0 |00:00:00.01 | 0 | 0 | | 178 | MERGE JOIN CARTESIAN | | 0 | 15E| 68P (1)| 0 |00:00:00.01 | 0 | 0 | |*179 | HASH JOIN | | 0 | 144T| 10G (14)| 0 |00:00:00.01 | 0 | 0 | |*180 | INDEX FAST FULL SCAN | I_TU_TUNING_1 | 0 | 79037 | 4499 (2)| 0 |00:00:00.01 | 0 | 0 | |*181 | HASH JOIN | | 0 | 188T| 10G (8)| 0 |00:00:00.01 | 0 | 0 | | 182 | TABLE ACCESS FULL | STORAGELOCATION | 0 | 103K| 845 (1)| 0 |00:00:00.01 | 0 | 0 | | 183 | MERGE JOIN CARTESIAN | | 0 | 582G| 6429M (1)| 0 |00:00:00.01 | 0 | 0 | |*184 | HASH JOIN | | 0 | 1831M| 5094K (1)| 0 |00:00:00.01 | 0 | 0 | |*185 | TABLE ACCESS FULL | SKU | 0 | 99720 | 814 (1)| 0 |00:00:00.01 | 0 | 0 | |*186 | HASH JOIN | | 0 | 1831M| 1269K (1)| 0 |00:00:00.01 | 0 | 0 | |*187 | TABLE ACCESS FULL | SKUPRJ | 0 | 5945 | 541 (2)| 0 |00:00:00.01 | 0 | 0 | | 188 | MERGE JOIN CARTESIAN | | 0 | 125M| 1262K (1)| 0 |00:00:00.01 | 0 | 0 | | 189 | TABLE ACCESS FULL | PACKINGUNIT | 0 | 359K| 1763 (1)| 0 |00:00:00.01 | 0 | 0 | | 190 | BUFFER SORT | | 0 | 350 | 1260K (1)| 0 |00:00:00.01 | 0 | 0 | | 191 | TABLE ACCESS FULL | SUPPLIERPRJ | 0 | 350 | 4 (0)| 0 |00:00:00.01 | 0 | 0 | | 192 | BUFFER SORT | | 0 | 318 | 6429M (1)| 0 |00:00:00.01 | 0 | 0 | | 193 | TABLE ACCESS FULL | RACK | 0 | 318 | 4 (0)| 0 |00:00:00.01 | 0 | 0 | | 194 | BUFFER SORT | | 0 | 107K| 68P (1)| 0 |00:00:00.01 | 0 | 0 | |*195 | TABLE ACCESS FULL | PRICEPRJ | 0 | 107K| 475 (1)| 0 |00:00:00.01 | 0 | 0 | |*196 | SORT JOIN | | 0 | 16M| 163K (1)| 0 |00:00:00.01 | 0 | 0 | | 197 | TABLE ACCESS FULL | LUPRJ | 0 | 16M| 89671 (1)| 0 |00:00:00.01 | 0 | 0 | |*198 | TABLE ACCESS BY INDEX ROWID | LU | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*199 | INDEX UNIQUE SCAN | XPKLU | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |*200 | TABLE ACCESS BY INDEX ROWID | PICKTU | 0 | 572 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*201 | INDEX RANGE SCAN | XIF2PICKTU | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*202 | TABLE ACCESS BY INDEX ROWID | COLLI | 0 | 46692 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*203 | INDEX RANGE SCAN | XIF3COLLI | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | | 204 | NESTED LOOPS ANTI | | 0 | 946 | 18E (0)| 0 |00:00:00.01 | 0 | 0 | | 205 | NESTED LOOPS ANTI | | 0 | 4819 | 18E (0)| 0 |00:00:00.01 | 0 | 0 | | 206 | NESTED LOOPS | | 0 | 5267 | 18E (0)| 0 |00:00:00.01 | 0 | 0 | | 207 | MERGE JOIN | | 0 | 18E| 148P (12)| 0 |00:00:00.01 | 0 | 0 | | 208 | SORT JOIN | | 0 | 18E| 135P (3)| 0 |00:00:00.01 | 0 | 0 | | 209 | MERGE JOIN CARTESIAN | | 0 | 18E| 131P (1)| 0 |00:00:00.01 | 0 | 0 | | 210 | MERGE JOIN | | 0 | 277T| 46G (61)| 0 |00:00:00.01 | 0 | 0 | | 211 | SORT JOIN | | 0 | 314T| 46G (61)| 0 |00:00:00.01 | 0 | 0 | | 212 | MERGE JOIN | | 0 | 314T| 15G (9)| 0 |00:00:00.01 | 0 | 0 | | 213 | SORT JOIN | | 0 | 1137G| 13G (1)| 0 |00:00:00.01 | 0 | 0 | | 214 | MERGE JOIN CARTESIAN | | 0 | 1137G| 11G (1)| 0 |00:00:00.01 | 0 | 0 | |*215 | HASH JOIN | | 0 | 3249M| 597K (6)| 0 |00:00:00.01 | 0 | 0 | |*216 | INDEX FAST FULL SCAN | I_TU_TUNING_1 | 0 | 79037 | 4499 (2)| 0 |00:00:00.01 | 0 | 0 | |*217 | HASH JOIN | | 0 | 4242M| 576K (3)| 0 |00:00:00.01 | 0 | 0 | | 218 | TABLE ACCESS FULL | STORAGELOCATION | 0 | 103K| 845 (1)| 0 |00:00:00.01 | 0 | 0 | | 219 | MERGE JOIN CARTESIAN | | 0 | 13M| 541K (1)| 0 |00:00:00.01 | 0 | 0 | | 220 | TABLE ACCESS FULL | PACKINGUNIT | 0 | 359K| 1763 (1)| 0 |00:00:00.01 | 0 | 0 | | 221 | BUFFER SORT | | 0 | 37 | 539K (1)| 0 |00:00:00.01 | 0 | 0 | | 222 | TABLE ACCESS BY INDEX ROWID| RACK | 0 | 37 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*223 | INDEX RANGE SCAN | I_RACK_FLAGLOCK | 0 | 37 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | | 224 | BUFFER SORT | | 0 | 350 | 11G (1)| 0 |00:00:00.01 | 0 | 0 | | 225 | TABLE ACCESS FULL | SUPPLIERPRJ | 0 | 350 | 4 (0)| 0 |00:00:00.01 | 0 | 0 | |*226 | SORT JOIN | | 0 | 112K| 1059 (2)| 0 |00:00:00.01 | 0 | 0 | |*227 | TABLE ACCESS FULL | SKUPRJ | 0 | 112K| 541 (2)| 0 |00:00:00.01 | 0 | 0 | |*228 | SORT JOIN | | 0 | 99720 | 2177 (1)| 0 |00:00:00.01 | 0 | 0 | |*229 | TABLE ACCESS FULL | SKU | 0 | 99720 | 814 (1)| 0 |00:00:00.01 | 0 | 0 | | 230 | BUFFER SORT | | 0 | 107K| 131P (1)| 0 |00:00:00.01 | 0 | 0 | |*231 | TABLE ACCESS FULL | PRICEPRJ | 0 | 107K| 475 (1)| 0 |00:00:00.01 | 0 | 0 | |*232 | SORT JOIN | | 0 | 16M| 163K (1)| 0 |00:00:00.01 | 0 | 0 | | 233 | TABLE ACCESS FULL | LUPRJ | 0 | 16M| 89671 (1)| 0 |00:00:00.01 | 0 | 0 | |*234 | TABLE ACCESS BY INDEX ROWID | LU | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*235 | INDEX UNIQUE SCAN | XPKLU | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |*236 | TABLE ACCESS BY INDEX ROWID | PICKTU | 0 | 572 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*237 | INDEX RANGE SCAN | XIF2PICKTU | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*238 | TABLE ACCESS BY INDEX ROWID | COLLI | 0 | 46692 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*239 | INDEX RANGE SCAN | XIF3COLLI | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | | 240 | NESTED LOOPS ANTI | | 0 | 365 | 18E (0)| 0 |00:00:00.01 | 0 | 0 | | 241 | NESTED LOOPS ANTI | | 0 | 1858 | 18E (0)| 0 |00:00:00.01 | 0 | 0 | | 242 | NESTED LOOPS | | 0 | 2031 | 18E (0)| 0 |00:00:00.01 | 0 | 0 | | 243 | MERGE JOIN | | 0 | 18E| 1148P (12)| 0 |00:00:00.01 | 0 | 0 | | 244 | SORT JOIN | | 0 | 18E| 1045P (4)| 0 |00:00:00.01 | 0 | 0 | | 245 | MERGE JOIN CARTESIAN | | 0 | 18E| 1017P (1)| 0 |00:00:00.01 | 0 | 0 | |*246 | HASH JOIN | | 0 | 2141T| 131G (18)| 0 |00:00:00.01 | 0 | 0 | |*247 | INDEX FAST FULL SCAN | I_TU_TUNING_1 | 0 | 79037 | 4499 (2)| 0 |00:00:00.01 | 0 | 0 | | 248 | MERGE JOIN | | 0 | 2796T| 120G (10)| 0 |00:00:00.01 | 0 | 0 | | 249 | SORT JOIN | | 0 | 8647G| 109G (1)| 0 |00:00:00.01 | 0 | 0 | | 250 | MERGE JOIN CARTESIAN | | 0 | 8647G| 107G (1)| 0 |00:00:00.01 | 0 | 0 | |*251 | HASH JOIN | | 0 | 30G| 74M (1)| 0 |00:00:00.01 | 0 | 0 | |*252 | TABLE ACCESS FULL | SKU | 0 | 99720 | 814 (1)| 0 |00:00:00.01 | 0 | 0 | |*253 | HASH JOIN | | 0 | 34G| 1590K (9)| 0 |00:00:00.01 | 0 | 0 | |*254 | TABLE ACCESS FULL | SKUPRJ | 0 | 112K| 541 (2)| 0 |00:00:00.01 | 0 | 0 | | 255 | MERGE JOIN CARTESIAN | | 0 | 125M| 1262K (1)| 0 |00:00:00.01 | 0 | 0 | | 256 | TABLE ACCESS FULL | PACKINGUNIT | 0 | 359K| 1763 (1)| 0 |00:00:00.01 | 0 | 0 | | 257 | BUFFER SORT | | 0 | 350 | 1260K (1)| 0 |00:00:00.01 | 0 | 0 | | 258 | TABLE ACCESS FULL | SUPPLIERPRJ | 0 | 350 | 4 (0)| 0 |00:00:00.01 | 0 | 0 | | 259 | BUFFER SORT | | 0 | 282 | 107G (1)| 0 |00:00:00.01 | 0 | 0 | |*260 | TABLE ACCESS FULL | RACK | 0 | 282 | 4 (0)| 0 |00:00:00.01 | 0 | 0 | |*261 | SORT JOIN | | 0 | 103K| 1319 (1)| 0 |00:00:00.01 | 0 | 0 | | 262 | TABLE ACCESS FULL | STORAGELOCATION | 0 | 103K| 845 (1)| 0 |00:00:00.01 | 0 | 0 | | 263 | BUFFER SORT | | 0 | 107K| 1017P (1)| 0 |00:00:00.01 | 0 | 0 | |*264 | TABLE ACCESS FULL | PRICEPRJ | 0 | 107K| 475 (1)| 0 |00:00:00.01 | 0 | 0 | |*265 | SORT JOIN | | 0 | 16M| 163K (1)| 0 |00:00:00.01 | 0 | 0 | | 266 | TABLE ACCESS FULL | LUPRJ | 0 | 16M| 89671 (1)| 0 |00:00:00.01 | 0 | 0 | |*267 | TABLE ACCESS BY INDEX ROWID | LU | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*268 | INDEX UNIQUE SCAN | XPKLU | 0 | 1 | 1 (0)| 0 |00:00:00.01 | 0 | 0 | |*269 | TABLE ACCESS BY INDEX ROWID | PICKTU | 0 | 572 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*270 | INDEX RANGE SCAN | XIF2PICKTU | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*271 | TABLE ACCESS BY INDEX ROWID | COLLI | 0 | 46692 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | |*272 | INDEX RANGE SCAN | XIF3COLLI | 0 | 1 | 2 (0)| 0 |00:00:00.01 | 0 | 0 | ---------------------------------------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter((SUM("QTYINWHBUTNOTPICKEDANDTOS4")-SUM("QTYDISPOSEDBUTNOTPICKED")>0 OR SUM("QTYUNLOCKEDASSIGNED")>0 OR SUM("QTYUNLOCKEDDELIVERABLE")>0 OR SUM("QTYUNLOCKEDPICKED")>0 OR SUM("QTYLOCKED")>0)) 10 - access(ROWID=ROWID) 13 - filter("SKUPRJ"."SKUID">10) 14 - access("SKUPRJ"."SUPPLIERPRJID"="SUP"."SUPPLIERPRJID") 15 - filter("SKU"."STATUS"<99) 16 - access("SKU"."SKUID"="SKUPRJ"."SKUID") filter("SKU"."SKUID">10) 17 - filter("PRICEPRJ"."STATUS"<99) 18 - access("SKU"."SKUID"="PRICEPRJ"."SKUID") filter("PRICEPRJ"."SKUID">10) 19 - access("SKU"."SKUID"="PUSELLING"."SKUID" AND "PUSELLING"."PACKINGUNITCATEGORY"='SellingUnit') filter(("PUSELLING"."PACKINGUNITCATEGORY"='SellingUnit' AND "PUSELLING"."SKUID">10)) 20 - filter((( IS NULL OR ("TUPRJ"."FLAGREPORTEDTOS4"='y' AND IS NOT NULL) OR ( IS NOT NULL AND IS NOT NULL)) AND ("W"."WAREHOUSENO"<>500 OR ("W"."WAREHOUSENO"=500 AND IS NOT NULL)) AND ("W"."WAREHOUSENO"<>510 OR ("W"."WAREHOUSENO"=510 AND IS NOT NULL)))) 25 - access("LUPRJ"."PRICEPRJID"="PRICEPRJ"."PRICEPRJID") 29 - access("C"."TUID"="TU"."TUID") 30 - filter("C"."STATUS"<99) 31 - access("PTU"."TUID"="TU"."TUID") 33 - access("PTU"."STATUS"<99) 37 - filter("TU"."STATUS"<99) 38 - access("SL"."STORAGELOCATIONID"="TU"."STORAGELOCATIONID") 39 - filter("R"."RACKID"="SL"."RACKID") 40 - filter("W"."WAREHOUSEID"="R"."WAREHOUSEID") 42 - access("TU"."TUID"="TUPRJ"."TUID") 43 - filter("LU"."SKUID">10) 44 - access("TU"."TUID"="LU"."TUID" AND "LU"."STATUS"=0) 46 - access("LU"."LUID"="LUPRJ"."LUID") 47 - filter("PRICEPRJ"."STATUS"<99) 48 - filter("SKU"."STATUS"<99) 49 - access("LU"."SKUID"="SKU"."SKUID") filter("SKU"."SKUID">10) 50 - access("SKU"."SKUID"="SKUPRJ"."SKUID") filter("SKUPRJ"."SKUID">10) 52 - access("SKUPRJ"."SUPPLIERPRJID"="SUP"."SUPPLIERPRJID") 54 - access("LU"."PACKINGUNITID"="PU"."PACKINGUNITID") 55 - filter(("T"."TRANSPORTTYPE"=10 OR "T"."TRANSPORTTYPE"=15)) 56 - access("T"."ORIGINTUID"=:B1 AND "T"."STATUS"<99) 57 - filter(("T"."TRANSPORTTYPE"=10 OR "T"."TRANSPORTTYPE"=15)) 58 - access("T"."ORIGINTUID"=:B1 AND "T"."STATUS"<99) 59 - filter(("T"."TRANSPORTTYPE"=10 OR "T"."TRANSPORTTYPE"=15)) 60 - access("T"."ORIGINTUID"=:B1 AND "T"."STATUS"<99) 61 - filter("TUPRJPARENT"."FLAGREPORTEDTOS4"='y') 62 - access("TUPRJPARENT"."TUID"=:B1) 63 - access("T"."ORIGINTUID"=:B1 AND "T"."STATUS"<99) 64 - access("T"."ORIGINTUID"=:B1 AND "T"."STATUS"<99) 72 - access("MO"."STATUS"<60) 73 - filter("MOP"."SKUID">10) 74 - access("MOP"."MAILORDERID"="MO"."MAILORDERID" AND "MOP"."STATUS"<40) 75 - filter("SKU"."STATUS"<99) 76 - access("MOP"."SKUID"="SKU"."SKUID") filter("SKU"."SKUID">10) 78 - access("MOP"."MAILORDERPOSID"="MOPPRJ"."MAILORDERPOSID") 79 - filter("PRICEPRJ"."STATUS"<99) 80 - access("SKU"."SKUID"="PRICEPRJ"."SKUID" AND "MOPPRJ"."COVERCURRENCY"="PRICEPRJ"."CURRENCY" AND "MOPPRJ"."COVERPRICE"="PRICEPRJ"."PRICE") filter("PRICEPRJ"."SKUID">10) 81 - access("SKU"."SKUID"="SKUPRJ"."SKUID") filter("SKUPRJ"."SKUID">10) 83 - access("SKUPRJ"."SUPPLIERPRJID"="SUP"."SUPPLIERPRJID") 91 - access("MO"."STATUS"<60) 92 - filter("MOP"."SKUID">10) 93 - access("MOP"."MAILORDERID"="MO"."MAILORDERID") 94 - filter("SKU"."STATUS"<99) 95 - access("MOP"."SKUID"="SKU"."SKUID") filter("SKU"."SKUID">10) 97 - access("MOP"."MAILORDERPOSID"="MOPPRJ"."MAILORDERPOSID") 98 - filter("PRICEPRJ"."STATUS"<99) 99 - access("SKU"."SKUID"="PRICEPRJ"."SKUID" AND "MOPPRJ"."COVERCURRENCY"="PRICEPRJ"."CURRENCY" AND "MOPPRJ"."COVERPRICE"="PRICEPRJ"."PRICE") filter("PRICEPRJ"."SKUID">10) 100 - access("SKU"."SKUID"="SKUPRJ"."SKUID") filter("SKUPRJ"."SKUID">10) 102 - access("SKUPRJ"."SUPPLIERPRJID"="SUP"."SUPPLIERPRJID") 109 - filter(TRUNC(INTERNAL_FUNCTION("MO"."DELIVERYDAT"))<=TRUNC(SYSDATE@!)) 110 - access("MO"."STATUS">=60 AND "MO"."STATUS"<99) 111 - filter("MOP"."SKUID">10) 112 - access("MOP"."MAILORDERID"="MO"."MAILORDERID") 113 - filter("SKU"."STATUS"<99) 114 - access("MOP"."SKUID"="SKU"."SKUID") filter("SKU"."SKUID">10) 116 - access("MOP"."MAILORDERPOSID"="MOPPRJ"."MAILORDERPOSID") 117 - filter("PRICEPRJ"."STATUS"<99) 118 - access("SKU"."SKUID"="PRICEPRJ"."SKUID" AND "MOPPRJ"."COVERCURRENCY"="PRICEPRJ"."CURRENCY" AND "MOPPRJ"."COVERPRICE"="PRICEPRJ"."PRICE") filter("PRICEPRJ"."SKUID">10) 119 - access("SKU"."SKUID"="SKUPRJ"."SKUID") filter("SKUPRJ"."SKUID">10) 121 - access("SKUPRJ"."SUPPLIERPRJID"="SUP"."SUPPLIERPRJID") 129 - access("MO"."SYS_NC00055$">TRUNC(SYSDATE@!) AND "MO"."STATUS">=60 AND "MO"."SYS_NC00055$" IS NOT NULL) filter(("MO"."STATUS"<99 AND "MO"."STATUS">=60)) 130 - filter("MOP"."SKUID">10) 131 - access("MOP"."MAILORDERID"="MO"."MAILORDERID") 132 - filter("SKU"."STATUS"<99) 133 - access("MOP"."SKUID"="SKU"."SKUID") filter("SKU"."SKUID">10) 135 - access("MOP"."MAILORDERPOSID"="MOPPRJ"."MAILORDERPOSID") 136 - filter("PRICEPRJ"."STATUS"<99) 137 - access("SKU"."SKUID"="PRICEPRJ"."SKUID" AND "MOPPRJ"."COVERCURRENCY"="PRICEPRJ"."CURRENCY" AND "MOPPRJ"."COVERPRICE"="PRICEPRJ"."PRICE") filter("PRICEPRJ"."SKUID">10) 138 - access("SKU"."SKUID"="SKUPRJ"."SKUID") filter("SKUPRJ"."SKUID">10) 140 - access("SKUPRJ"."SUPPLIERPRJID"="SUP"."SUPPLIERPRJID") 152 - access("MO"."STATUS"<=60) 153 - filter("MOP"."SKUID">10) 154 - access("MOP"."MAILORDERID"="MO"."MAILORDERID") 155 - filter("SKU"."STATUS"<99) 156 - access("MOP"."SKUID"="SKU"."SKUID") filter("SKU"."SKUID">10) 158 - access("MOP"."MAILORDERPOSID"="MOPPRJ"."MAILORDERPOSID") 159 - filter("PRICEPRJ"."STATUS"<99) 160 - access("SKU"."SKUID"="PRICEPRJ"."SKUID" AND "MOPPRJ"."COVERCURRENCY"="PRICEPRJ"."CURRENCY" AND "MOPPRJ"."COVERPRICE"="PRICEPRJ"."PRICE") filter("PRICEPRJ"."SKUID">10) 162 - access("MP"."MAILORDERPOSID"="MOP"."MAILORDERPOSID") 164 - access("POP"."MAILINGPOSID"="MP"."MAILINGPOSID") 165 - filter("PICKTU"."STATUS"=99) 166 - access("PICKTU"."PICKTUID"="POP"."PICKTUID") 167 - filter("PICKTU"."PICKTUID"="P"."PICKTUID") 168 - access("P"."PICKORDERPOSID"="POP"."PICKORDERPOSID") 169 - access("SKU"."SKUID"="SKUPRJ"."SKUID") filter("SKUPRJ"."SKUID">10) 171 - access("SKUPRJ"."SUPPLIERPRJID"="SUP"."SUPPLIERPRJID") 179 - access("SL"."STORAGELOCATIONID"="TU"."STORAGELOCATIONID") 180 - filter("TU"."STATUS"<99) 181 - access("SL"."RACKID"="R"."RACKID") 184 - access("SKUPRJ"."SKUID"="SKU"."SKUID") 185 - filter(("SKU"."STATUS"<99 AND "SKU"."SKUID">10)) 186 - access("SKUPRJ"."SUPPLIERPRJID"="SUP"."SUPPLIERPRJID") 187 - filter((NVL("SKUPRJ"."LOCKEDUNTIL",TRUNC(SYSDATE@!-1))>=TRUNC(SYSDATE@!) AND "SKUPRJ"."SKUID">10)) 195 - filter("PRICEPRJ"."STATUS"<99) 196 - access("PRICEPRJ"."PRICEPRJID"="LUPRJ"."PRICEPRJID") filter("PRICEPRJ"."PRICEPRJID"="LUPRJ"."PRICEPRJID") 198 - filter(("LU"."STATUS"<99 AND "LU"."SKUID">10 AND "TU"."TUID"="LU"."TUID" AND "PU"."PACKINGUNITID"="LU"."PACKINGUNITID" AND "LU"."SKUID"="SKUPRJ"."SKUID")) 199 - access("LUPRJ"."LUID"="LU"."LUID") 200 - filter("PTU"."STATUS"<99) 201 - access("PTU"."TUID"="TU"."TUID") 202 - filter("C"."STATUS"<99) 203 - access("C"."TUID"="TU"."TUID") 215 - access("SL"."STORAGELOCATIONID"="TU"."STORAGELOCATIONID") 216 - filter("TU"."STATUS"<99) 217 - access("SL"."RACKID"="R"."RACKID") 223 - access("R"."FLAGLOCK"='y') 226 - access("SKUPRJ"."SUPPLIERPRJID"="SUP"."SUPPLIERPRJID") filter("SKUPRJ"."SUPPLIERPRJID"="SUP"."SUPPLIERPRJID") 227 - filter(("SKUPRJ"."SKUID">10 AND LNNVL(NVL("SKUPRJ"."LOCKEDUNTIL",TRUNC(SYSDATE@!-1))>=TRUNC(SYSDATE@!)))) 228 - access("SKUPRJ"."SKUID"="SKU"."SKUID") filter("SKUPRJ"."SKUID"="SKU"."SKUID") 229 - filter(("SKU"."STATUS"<99 AND "SKU"."SKUID">10)) 231 - filter("PRICEPRJ"."STATUS"<99) 232 - access("PRICEPRJ"."PRICEPRJID"="LUPRJ"."PRICEPRJID") filter("PRICEPRJ"."PRICEPRJID"="LUPRJ"."PRICEPRJID") 234 - filter(("LU"."STATUS"<99 AND "LU"."SKUID">10 AND "TU"."TUID"="LU"."TUID" AND "PU"."PACKINGUNITID"="LU"."PACKINGUNITID" AND "LU"."SKUID"="SKUPRJ"."SKUID")) 235 - access("LUPRJ"."LUID"="LU"."LUID") 236 - filter("PTU"."STATUS"<99) 237 - access("PTU"."TUID"="TU"."TUID") 238 - filter("C"."STATUS"<99) 239 - access("C"."TUID"="TU"."TUID") 246 - access("SL"."STORAGELOCATIONID"="TU"."STORAGELOCATIONID") 247 - filter("TU"."STATUS"<99) 251 - access("SKUPRJ"."SKUID"="SKU"."SKUID") 252 - filter(("SKU"."STATUS"<99 AND "SKU"."SKUID">10)) 253 - access("SKUPRJ"."SUPPLIERPRJID"="SUP"."SUPPLIERPRJID") 254 - filter(("SKUPRJ"."SKUID">10 AND LNNVL(NVL("SKUPRJ"."LOCKEDUNTIL",TRUNC(SYSDATE@!-1))>=TRUNC(SYSDATE@!)))) 260 - filter(LNNVL("R"."FLAGLOCK"='y')) 261 - access("SL"."RACKID"="R"."RACKID") filter("SL"."RACKID"="R"."RACKID") 264 - filter("PRICEPRJ"."STATUS"<99) 265 - access("PRICEPRJ"."PRICEPRJID"="LUPRJ"."PRICEPRJID") filter("PRICEPRJ"."PRICEPRJID"="LUPRJ"."PRICEPRJID") 267 - filter(("LU"."STATUS"<99 AND "LU"."SKUID">10 AND "LU"."QCLOCKCNT"+"LU"."INVENTORYLOCKCNT"+"LU"."DISPOSELOCKCNT"+"LU"."REPLENISHMENTLOCKCNT" +"LU"."MISCELLANEOUSLOCKCNT"+"LU"."STATUS"+"SL"."STOREOUTLOCKCNT">0 AND "TU"."TUID"="LU"."TUID" AND "PU"."PACKINGUNITID"="LU"."PACKINGUNITID" AND "LU"."SKUID"="SKUPRJ"."SKUID")) 268 - access("LUPRJ"."LUID"="LU"."LUID") 269 - filter("PTU"."STATUS"<99) 270 - access("PTU"."TUID"="TU"."TUID") 271 - filter("C"."STATUS"<99) 272 - access("C"."TUID"="TU"."TUID") 466 Zeilen gewählt