PLAN_TABLE_OUTPUT mirror ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ SQL_ID g3qd4g60wz1u9, child number 0 ------------------------------------- SELECT :"SYS_B_00" AS source_system, customer_name, whs_inbound_order_no, source_ib_order_level, request_number, source_order_type, whs_order_line_no, whs_segment, quantity_requested, source_service_type, shipment_no, receipt_number, receipt_line_number, lpn_number, lot_number, batch_number, revision_number, country_of_origin, actual_part_serial_number, disposition_code, quantity_received, quantity_uom, weight, weight_uom, :"SYS_B_01" AS volume, volume_uom, source_whs_name, part_number, product_class, source_awb_mcr, cource_carrier_name, NULL AS delivery_record_number, batch_task_number, putaway_task_number, whs_zone, to_bin_location, NULL AS delivery_record_creat_date_loc, NULL AS delivery_record_creat_date_gmt, NULL AS label_printtimestamp_loc, NULL AS label_printtimestamp_gmt, sib_whs_order_status, receipt_status, source_system_part_status, timeconvertor_oracle (truck_arrival_time_gmt, :"SYS_B_02 Plan hash value: 1323636927 ------------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ------------------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | | | | 71051 (100)| | | 1 | TABLE ACCESS BY INDEX ROWID | YFS_COMMON_CODE | 1 | 75 | | 3 (0)| 00:00:01 | |* 2 | INDEX RANGE SCAN | YFS_COMMON_CODE_I1 | 1 | | | 2 (0)| 00:00:01 | | 3 | SORT AGGREGATE | | 1 | 53 | | | | |* 4 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 53 | | 5 (0)| 00:00:01 | |* 5 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 6 | SORT AGGREGATE | | 1 | 53 | | | | |* 7 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 53 | | 5 (0)| 00:00:01 | |* 8 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 9 | SORT AGGREGATE | | 1 | 53 | | | | |* 10 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 53 | | 5 (0)| 00:00:01 | |* 11 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 12 | NESTED LOOPS | | 1 | 109 | | 2 (0)| 00:00:01 | | 13 | TABLE ACCESS BY INDEX ROWID | YFS_PIPELINE | 1 | 50 | | 1 (0)| 00:00:01 | |* 14 | INDEX UNIQUE SCAN | YFS_PIPELINE_PK | 1 | | | 0 (0)| | | 15 | HASH UNIQUE | | 1 | 78 | | 6 (17)| 00:00:01 | |* 16 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 78 | | 5 (0)| 00:00:01 | |* 17 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 18 | TABLE ACCESS BY INDEX ROWID | YFS_STATUS | 1 | 59 | | 1 (0)| 00:00:01 | |* 19 | INDEX UNIQUE SCAN | YFS_STATUS_I1 | 1 | | | 0 (0)| | | 20 | SORT AGGREGATE | | 1 | 69 | | | | |* 21 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 69 | | 5 (0)| 00:00:01 | |* 22 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 23 | SORT AGGREGATE | | 1 | 69 | | | | |* 24 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 69 | | 5 (0)| 00:00:01 | |* 25 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 26 | SORT AGGREGATE | | 1 | 69 | | | | |* 27 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 69 | | 5 (0)| 00:00:01 | |* 28 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 29 | NESTED LOOPS | | 1 | 109 | | 2 (0)| 00:00:01 | | 30 | TABLE ACCESS BY INDEX ROWID | YFS_PIPELINE | 1 | 50 | | 1 (0)| 00:00:01 | |* 31 | INDEX UNIQUE SCAN | YFS_PIPELINE_PK | 1 | | | 0 (0)| | | 32 | HASH UNIQUE | | 1 | 78 | | 6 (17)| 00:00:01 | |* 33 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 78 | | 5 (0)| 00:00:01 | |* 34 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 35 | TABLE ACCESS BY INDEX ROWID | YFS_STATUS | 1 | 59 | | 1 (0)| 00:00:01 | |* 36 | INDEX UNIQUE SCAN | YFS_STATUS_I1 | 1 | | | 0 (0)| | | 37 | SORT AGGREGATE | | 1 | 69 | | | | |* 38 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 69 | | 5 (0)| 00:00:01 | |* 39 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 40 | SORT AGGREGATE | | 1 | 69 | | | | |* 41 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 69 | | 5 (0)| 00:00:01 | |* 42 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 43 | SORT AGGREGATE | | 1 | 69 | | | | |* 44 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 69 | | 5 (0)| 00:00:01 | |* 45 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 46 | NESTED LOOPS | | 1 | 109 | | 2 (0)| 00:00:01 | | 47 | TABLE ACCESS BY INDEX ROWID | YFS_PIPELINE | 1 | 50 | | 1 (0)| 00:00:01 | |* 48 | INDEX UNIQUE SCAN | YFS_PIPELINE_PK | 1 | | | 0 (0)| | | 49 | HASH UNIQUE | | 1 | 78 | | 6 (17)| 00:00:01 | |* 50 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 78 | | 5 (0)| 00:00:01 | |* 51 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 52 | TABLE ACCESS BY INDEX ROWID | YFS_STATUS | 1 | 59 | | 1 (0)| 00:00:01 | |* 53 | INDEX UNIQUE SCAN | YFS_STATUS_I1 | 1 | | | 0 (0)| | | 54 | SORT AGGREGATE | | 1 | 69 | | | | |* 55 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 69 | | 5 (0)| 00:00:01 | |* 56 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 57 | NESTED LOOPS | | 1 | 109 | | 2 (0)| 00:00:01 | | 58 | TABLE ACCESS BY INDEX ROWID | YFS_PIPELINE | 1 | 50 | | 1 (0)| 00:00:01 | |* 59 | INDEX UNIQUE SCAN | YFS_PIPELINE_PK | 1 | | | 0 (0)| | | 60 | HASH UNIQUE | | 1 | 78 | | 6 (17)| 00:00:01 | |* 61 | TABLE ACCESS BY INDEX ROWID| YFS_ORDER_RELEASE_STATUS | 1 | 78 | | 5 (0)| 00:00:01 | |* 62 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 63 | TABLE ACCESS BY INDEX ROWID | YFS_STATUS | 1 | 59 | | 1 (0)| 00:00:01 | |* 64 | INDEX UNIQUE SCAN | YFS_STATUS_I1 | 1 | | | 0 (0)| | | 65 | SORT AGGREGATE | | 1 | 69 | | | | |* 66 | TABLE ACCESS BY INDEX ROWID| YFS_ORDER_RELEASE_STATUS | 1 | 69 | | 5 (0)| 00:00:01 | |* 67 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 68 | NESTED LOOPS | | 1 | 56 | | 3 (0)| 00:00:01 | |* 69 | TABLE ACCESS BY INDEX ROWID | YFS_ORGANIZATION | 1 | 34 | | 2 (0)| 00:00:01 | |* 70 | INDEX UNIQUE SCAN | YFS_ORGANIZATION_PK | 1 | | | 1 (0)| 00:00:01 | | 71 | TABLE ACCESS BY INDEX ROWID | YFS_LOCALE | 188 | 4136 | | 1 (0)| 00:00:01 | |* 72 | INDEX UNIQUE SCAN | YFS_LOCALE_I1 | 1 | | | 0 (0)| | | 73 | SORT AGGREGATE | | 1 | 49 | | | | |* 74 | TABLE ACCESS BY INDEX ROWID | YFS_RECEIPT_STATUS_AUDIT | 1 | 49 | | 6 (0)| 00:00:01 | |* 75 | INDEX RANGE SCAN | YFS_RECEIPT_STATUS_AUDIT_I1 | 3 | | | 3 (0)| 00:00:01 | | 76 | SORT AGGREGATE | | 1 | 49 | | | | |* 77 | TABLE ACCESS BY INDEX ROWID | YFS_RECEIPT_STATUS_AUDIT | 1 | 49 | | 6 (0)| 00:00:01 | |* 78 | INDEX RANGE SCAN | YFS_RECEIPT_STATUS_AUDIT_I1 | 3 | | | 3 (0)| 00:00:01 | | 79 | SORT AGGREGATE | | 1 | 53 | | | | |* 80 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 53 | | 5 (0)| 00:00:01 | |* 81 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 82 | SORT AGGREGATE | | 1 | 53 | | | | |* 83 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 53 | | 5 (0)| 00:00:01 | |* 84 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 85 | SORT AGGREGATE | | 1 | 53 | | | | |* 86 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 53 | | 5 (0)| 00:00:01 | |* 87 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 88 | NESTED LOOPS | | 1 | 109 | | 2 (0)| 00:00:01 | | 89 | TABLE ACCESS BY INDEX ROWID | YFS_PIPELINE | 1 | 50 | | 1 (0)| 00:00:01 | |* 90 | INDEX UNIQUE SCAN | YFS_PIPELINE_PK | 1 | | | 0 (0)| | | 91 | HASH UNIQUE | | 1 | 78 | | 6 (17)| 00:00:01 | |* 92 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 78 | | 5 (0)| 00:00:01 | |* 93 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 94 | TABLE ACCESS BY INDEX ROWID | YFS_STATUS | 1 | 59 | | 1 (0)| 00:00:01 | |* 95 | INDEX UNIQUE SCAN | YFS_STATUS_I1 | 1 | | | 0 (0)| | | 96 | SORT AGGREGATE | | 1 | 69 | | | | |* 97 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 69 | | 5 (0)| 00:00:01 | |* 98 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 99 | SORT AGGREGATE | | 1 | 69 | | | | |*100 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 69 | | 5 (0)| 00:00:01 | |*101 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 102 | SORT AGGREGATE | | 1 | 69 | | | | |*103 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 69 | | 5 (0)| 00:00:01 | |*104 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 105 | NESTED LOOPS | | 1 | 109 | | 2 (0)| 00:00:01 | | 106 | TABLE ACCESS BY INDEX ROWID | YFS_PIPELINE | 1 | 50 | | 1 (0)| 00:00:01 | |*107 | INDEX UNIQUE SCAN | YFS_PIPELINE_PK | 1 | | | 0 (0)| | | 108 | HASH UNIQUE | | 1 | 78 | | 6 (17)| 00:00:01 | |*109 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 78 | | 5 (0)| 00:00:01 | |*110 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 111 | TABLE ACCESS BY INDEX ROWID | YFS_STATUS | 1 | 59 | | 1 (0)| 00:00:01 | |*112 | INDEX UNIQUE SCAN | YFS_STATUS_I1 | 1 | | | 0 (0)| | | 113 | SORT AGGREGATE | | 1 | 69 | | | | |*114 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 69 | | 5 (0)| 00:00:01 | |*115 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 116 | SORT AGGREGATE | | 1 | 69 | | | | |*117 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 69 | | 5 (0)| 00:00:01 | |*118 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 119 | SORT AGGREGATE | | 1 | 69 | | | | |*120 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 69 | | 5 (0)| 00:00:01 | |*121 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 122 | NESTED LOOPS | | 1 | 109 | | 2 (0)| 00:00:01 | | 123 | TABLE ACCESS BY INDEX ROWID | YFS_PIPELINE | 1 | 50 | | 1 (0)| 00:00:01 | |*124 | INDEX UNIQUE SCAN | YFS_PIPELINE_PK | 1 | | | 0 (0)| | | 125 | HASH UNIQUE | | 1 | 78 | | 6 (17)| 00:00:01 | |*126 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 78 | | 5 (0)| 00:00:01 | |*127 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 128 | TABLE ACCESS BY INDEX ROWID | YFS_STATUS | 1 | 59 | | 1 (0)| 00:00:01 | |*129 | INDEX UNIQUE SCAN | YFS_STATUS_I1 | 1 | | | 0 (0)| | | 130 | SORT AGGREGATE | | 1 | 69 | | | | |*131 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 69 | | 5 (0)| 00:00:01 | |*132 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 133 | NESTED LOOPS | | 1 | 109 | | 2 (0)| 00:00:01 | | 134 | TABLE ACCESS BY INDEX ROWID | YFS_PIPELINE | 1 | 50 | | 1 (0)| 00:00:01 | |*135 | INDEX UNIQUE SCAN | YFS_PIPELINE_PK | 1 | | | 0 (0)| | | 136 | HASH UNIQUE | | 1 | 78 | | 6 (17)| 00:00:01 | |*137 | TABLE ACCESS BY INDEX ROWID| YFS_ORDER_RELEASE_STATUS | 1 | 78 | | 5 (0)| 00:00:01 | |*138 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 139 | TABLE ACCESS BY INDEX ROWID | YFS_STATUS | 1 | 59 | | 1 (0)| 00:00:01 | |*140 | INDEX UNIQUE SCAN | YFS_STATUS_I1 | 1 | | | 0 (0)| | | 141 | SORT AGGREGATE | | 1 | 69 | | | | |*142 | TABLE ACCESS BY INDEX ROWID| YFS_ORDER_RELEASE_STATUS | 1 | 69 | | 5 (0)| 00:00:01 | |*143 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 144 | SORT AGGREGATE | | 1 | 49 | | | | |*145 | TABLE ACCESS BY INDEX ROWID | YFS_RECEIPT_STATUS_AUDIT | 1 | 49 | | 6 (0)| 00:00:01 | |*146 | INDEX RANGE SCAN | YFS_RECEIPT_STATUS_AUDIT_I1 | 3 | | | 3 (0)| 00:00:01 | | 147 | SORT AGGREGATE | | 1 | 53 | | | | |*148 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 53 | | 5 (0)| 00:00:01 | |*149 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 150 | SORT AGGREGATE | | 1 | 53 | | | | |*151 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 53 | | 5 (0)| 00:00:01 | |*152 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 153 | SORT AGGREGATE | | 1 | 53 | | | | |*154 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 53 | | 5 (0)| 00:00:01 | |*155 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 156 | NESTED LOOPS | | 1 | 109 | | 2 (0)| 00:00:01 | | 157 | TABLE ACCESS BY INDEX ROWID | YFS_PIPELINE | 1 | 50 | | 1 (0)| 00:00:01 | |*158 | INDEX UNIQUE SCAN | YFS_PIPELINE_PK | 1 | | | 0 (0)| | | 159 | HASH UNIQUE | | 1 | 78 | | 6 (17)| 00:00:01 | |*160 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 78 | | 5 (0)| 00:00:01 | |*161 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 162 | TABLE ACCESS BY INDEX ROWID | YFS_STATUS | 1 | 59 | | 1 (0)| 00:00:01 | |*163 | INDEX UNIQUE SCAN | YFS_STATUS_I1 | 1 | | | 0 (0)| | | 164 | SORT AGGREGATE | | 1 | 69 | | | | |*165 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 69 | | 5 (0)| 00:00:01 | |*166 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 167 | SORT AGGREGATE | | 1 | 69 | | | | |*168 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 69 | | 5 (0)| 00:00:01 | |*169 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 170 | SORT AGGREGATE | | 1 | 69 | | | | |*171 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 69 | | 5 (0)| 00:00:01 | |*172 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 173 | NESTED LOOPS | | 1 | 109 | | 2 (0)| 00:00:01 | | 174 | TABLE ACCESS BY INDEX ROWID | YFS_PIPELINE | 1 | 50 | | 1 (0)| 00:00:01 | |*175 | INDEX UNIQUE SCAN | YFS_PIPELINE_PK | 1 | | | 0 (0)| | | 176 | HASH UNIQUE | | 1 | 78 | | 6 (17)| 00:00:01 | |*177 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 78 | | 5 (0)| 00:00:01 | |*178 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 179 | TABLE ACCESS BY INDEX ROWID | YFS_STATUS | 1 | 59 | | 1 (0)| 00:00:01 | |*180 | INDEX UNIQUE SCAN | YFS_STATUS_I1 | 1 | | | 0 (0)| | | 181 | SORT AGGREGATE | | 1 | 69 | | | | |*182 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 69 | | 5 (0)| 00:00:01 | |*183 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 184 | SORT AGGREGATE | | 1 | 69 | | | | |*185 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 69 | | 5 (0)| 00:00:01 | |*186 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 187 | SORT AGGREGATE | | 1 | 69 | | | | |*188 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 69 | | 5 (0)| 00:00:01 | |*189 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 190 | NESTED LOOPS | | 1 | 109 | | 2 (0)| 00:00:01 | | 191 | TABLE ACCESS BY INDEX ROWID | YFS_PIPELINE | 1 | 50 | | 1 (0)| 00:00:01 | |*192 | INDEX UNIQUE SCAN | YFS_PIPELINE_PK | 1 | | | 0 (0)| | | 193 | HASH UNIQUE | | 1 | 78 | | 6 (17)| 00:00:01 | |*194 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 78 | | 5 (0)| 00:00:01 | |*195 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 196 | TABLE ACCESS BY INDEX ROWID | YFS_STATUS | 1 | 59 | | 1 (0)| 00:00:01 | |*197 | INDEX UNIQUE SCAN | YFS_STATUS_I1 | 1 | | | 0 (0)| | | 198 | SORT AGGREGATE | | 1 | 69 | | | | |*199 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 69 | | 5 (0)| 00:00:01 | |*200 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 201 | NESTED LOOPS | | 1 | 109 | | 2 (0)| 00:00:01 | | 202 | TABLE ACCESS BY INDEX ROWID | YFS_PIPELINE | 1 | 50 | | 1 (0)| 00:00:01 | |*203 | INDEX UNIQUE SCAN | YFS_PIPELINE_PK | 1 | | | 0 (0)| | | 204 | HASH UNIQUE | | 1 | 78 | | 6 (17)| 00:00:01 | |*205 | TABLE ACCESS BY INDEX ROWID| YFS_ORDER_RELEASE_STATUS | 1 | 78 | | 5 (0)| 00:00:01 | |*206 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 207 | TABLE ACCESS BY INDEX ROWID | YFS_STATUS | 1 | 59 | | 1 (0)| 00:00:01 | |*208 | INDEX UNIQUE SCAN | YFS_STATUS_I1 | 1 | | | 0 (0)| | | 209 | SORT AGGREGATE | | 1 | 69 | | | | |*210 | TABLE ACCESS BY INDEX ROWID| YFS_ORDER_RELEASE_STATUS | 1 | 69 | | 5 (0)| 00:00:01 | |*211 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I7 | 2 | | | 4 (0)| 00:00:01 | | 212 | SORT AGGREGATE | | 1 | 49 | | | | |*213 | TABLE ACCESS BY INDEX ROWID | YFS_RECEIPT_STATUS_AUDIT | 1 | 49 | | 6 (0)| 00:00:01 | |*214 | INDEX RANGE SCAN | YFS_RECEIPT_STATUS_AUDIT_I1 | 3 | | | 3 (0)| 00:00:01 | | 215 | VIEW | | 1 | 1151 | | 71051 (8)| 00:07:00 | | 216 | TEMP TABLE TRANSFORMATION | | | | | | | | 217 | LOAD AS SELECT | | | | | | | | 218 | NESTED LOOPS | | | | | | | | 219 | NESTED LOOPS | | 16323 | 11M| | 16356 (1)| 00:01:37 | | 220 | SORT UNIQUE | | 16323 | 398K| | 6 (0)| 00:00:01 | | 221 | TABLE ACCESS FULL | FACT05_ORDER_HEADER | 16323 | 398K| | 6 (0)| 00:00:01 | |*222 | INDEX UNIQUE SCAN | YFS_ORDER_HEADER_PK | 1 | | | 1 (0)| 00:00:01 | | 223 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_HEADER | 1 | 725 | | 2 (0)| 00:00:01 | | 224 | LOAD AS SELECT | | | | | | | |*225 | HASH JOIN | | 26250 | 18M| | 35865 (12)| 00:03:32 | | 226 | VIEW | | 16323 | 398K| | 75 (12)| 00:00:01 | | 227 | TABLE ACCESS FULL | SYS_TEMP_0FD9D8774_39197D | 16323 | 11M| | 75 (12)| 00:00:01 | | 228 | TABLE ACCESS FULL | YFS_ORDER_LINE | 5794K| 3840M| | 35705 (12)| 00:03:31 | | 229 | NESTED LOOPS OUTER | | 1 | 1448 | | 18830 (6)| 00:01:52 | | 230 | NESTED LOOPS OUTER | | 1 | 1286 | | 18785 (6)| 00:01:51 | | 231 | VIEW | | 1 | 1228 | | 18782 (6)| 00:01:51 | |*232 | FILTER | | | | | | | | 233 | NESTED LOOPS OUTER | | 1 | 1106 | | 18782 (6)| 00:01:51 | | 234 | NESTED LOOPS OUTER | | 1 | 999 | | 18780 (6)| 00:01:51 | | 235 | NESTED LOOPS OUTER | | 1 | 821 | | 18778 (6)| 00:01:51 | | 236 | NESTED LOOPS OUTER | | 1 | 661 | | 18774 (6)| 00:01:51 | |*237 | HASH JOIN | | 1 | 609 | | 18767 (6)| 00:01:51 | |*238 | HASH JOIN | | 1 | 392 | | 18691 (6)| 00:01:51 | |*239 | HASH JOIN | | 2 | 402 | | 18571 (6)| 00:01:50 | | 240 | VIEW | | 16323 | 797K| | 75 (12)| 00:00:01 | | 241 | TABLE ACCESS FULL | SYS_TEMP_0FD9D8774_39197D | 16323 | 11M| | 75 (12)| 00:00:01 | |*242 | HASH JOIN | | 26250 | 3870K| 2128K| 18495 (5)| 00:01:50 | | 243 | VIEW | | 26250 | 1820K| | 119 (16)| 00:00:01 | | 244 | TABLE ACCESS FULL | SYS_TEMP_0FD9D8775_39197D | 26250 | 18M| | 119 (16)| 00:00:01 | | 245 | TABLE ACCESS FULL | YFS_ITEM | 2781K| 212M| | 14338 (6)| 00:01:25 | | 246 | VIEW | | 26250 | 4896K| | 119 (16)| 00:00:01 | | 247 | TABLE ACCESS FULL | SYS_TEMP_0FD9D8775_39197D | 26250 | 18M| | 119 (16)| 00:00:01 | | 248 | VIEW | | 16323 | 3459K| | 75 (12)| 00:00:01 | | 249 | TABLE ACCESS FULL | SYS_TEMP_0FD9D8774_39197D | 16323 | 11M| | 75 (12)| 00:00:01 | |*250 | TABLE ACCESS BY INDEX ROWID | YFS_ORDER_RELEASE_STATUS | 1 | 52 | | 7 (0)| 00:00:01 | |*251 | INDEX RANGE SCAN | YFS_ORDER_RELEASE_STATUS_I2 | 4 | | | 3 (0)| 00:00:01 | | 252 | TABLE ACCESS BY INDEX ROWID | YFS_RECEIPT_LINE | 1 | 160 | | 4 (0)| 00:00:01 | |*253 | INDEX RANGE SCAN | EXTN_YFS_RECEIPT_LINE_I4 | 1 | | | 2 (0)| 00:00:01 | | 254 | VIEW PUSHED PREDICATE | | 1 | 178 | | 2 (0)| 00:00:01 | | 255 | NESTED LOOPS | | 1 | 266 | | 5 (0)| 00:00:01 | | 256 | NESTED LOOPS | | 1 | 207 | | 4 (0)| 00:00:01 | | 257 | TABLE ACCESS BY INDEX ROWID | YFS_RECEIPT_HEADER | 1 | 157 | | 3 (0)| 00:00:01 | |*258 | INDEX UNIQUE SCAN | YFS_RECEIPT_HEADER_PK | 1 | | | 2 (0)| 00:00:01 | | 259 | TABLE ACCESS BY INDEX ROWID | YFS_PIPELINE | 1 | 50 | | 1 (0)| 00:00:01 | |*260 | INDEX UNIQUE SCAN | YFS_PIPELINE_PK | 1 | | | 0 (0)| | | 261 | TABLE ACCESS BY INDEX ROWID | YFS_STATUS | 1 | 59 | | 1 (0)| 00:00:01 | |*262 | INDEX UNIQUE SCAN | YFS_STATUS_I1 | 1 | | | 0 (0)| | | 263 | TABLE ACCESS BY INDEX ROWID | YFS_SHIPMENT | 1 | 107 | | 2 (0)| 00:00:01 | |*264 | INDEX UNIQUE SCAN | YFS_SHIPMENT_PK | 1 | | | 1 (0)| 00:00:01 | |*265 | TABLE ACCESS BY INDEX ROWID | YFS_SHIPMENT_LINE | 1 | 58 | | 3 (0)| 00:00:01 | |*266 | INDEX RANGE SCAN | YFS_SHIPMENT_LINE_I4 | 1 | | | 2 (0)| 00:00:01 | |*267 | TABLE ACCESS BY INDEX ROWID | YFS_TASK | 1 | 162 | | 45 (0)| 00:00:01 | |*268 | INDEX RANGE SCAN | YFS_TASK_I22 | 56 | | | 2 (0)| 00:00:01 | ------------------------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 2 - access("ORGANIZATION_CODE"=:SYS_B_18 AND "CODE_VALUE"=:B1) filter(("CODE_VALUE"=:B1 AND TRIM("CODE_TYPE")=:SYS_B_17)) 4 - filter("STS"."ORDER_LINE_KEY"=:B1) 5 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_19) filter("STS"."STATUS_QUANTITY">:SYS_B_19) 7 - filter("STS"."ORDER_LINE_KEY"=:B1) 8 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_22) filter("STS"."STATUS_QUANTITY">:SYS_B_22) 10 - filter("STS"."ORDER_LINE_KEY"=:B1) 11 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_23) filter("STS"."STATUS_QUANTITY">:SYS_B_23) 14 - access("P"."PIPELINE_KEY"=) 16 - filter("ORS"."ORDER_LINE_KEY"=:B1) 17 - access("ORS"."ORDER_HEADER_KEY"=:B1 AND "ORS"."STATUS_QUANTITY">:SYS_B_25) filter("ORS"."STATUS_QUANTITY">:SYS_B_25) 19 - access("ST"."STATUS"= AND "P"."PROCESS_TYPE_KEY"="ST"."PROCESS_TYPE_KEY") 21 - filter("STS"."ORDER_LINE_KEY"=:B1) 22 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_24) filter("STS"."STATUS_QUANTITY">:SYS_B_24) 24 - filter("STS"."ORDER_LINE_KEY"=:B1) 25 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_26) filter("STS"."STATUS_QUANTITY">:SYS_B_26) 27 - filter("STS"."ORDER_LINE_KEY"=:B1) 28 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_27) filter("STS"."STATUS_QUANTITY">:SYS_B_27) 31 - access("P"."PIPELINE_KEY"=) 33 - filter("ORS"."ORDER_LINE_KEY"=:B1) 34 - access("ORS"."ORDER_HEADER_KEY"=:B1 AND "ORS"."STATUS_QUANTITY">:SYS_B_29) filter("ORS"."STATUS_QUANTITY">:SYS_B_29) 36 - access("ST"."STATUS"= AND "P"."PROCESS_TYPE_KEY"="ST"."PROCESS_TYPE_KEY") 38 - filter("STS"."ORDER_LINE_KEY"=:B1) 39 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_28) filter("STS"."STATUS_QUANTITY">:SYS_B_28) 41 - filter("STS"."ORDER_LINE_KEY"=:B1) 42 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_30) filter("STS"."STATUS_QUANTITY">:SYS_B_30) 44 - filter("STS"."ORDER_LINE_KEY"=:B1) 45 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_31 AND "STS"."STATUS"<:SYS_B_32) filter("STS"."STATUS_QUANTITY">:SYS_B_31) 48 - access("P"."PIPELINE_KEY"=) 50 - filter("ORS"."ORDER_LINE_KEY"=:B1) 51 - access("ORS"."ORDER_HEADER_KEY"=:B1 AND "ORS"."STATUS_QUANTITY">:SYS_B_34) filter("ORS"."STATUS_QUANTITY">:SYS_B_34) 53 - access("ST"."STATUS"= AND "P"."PROCESS_TYPE_KEY"="ST"."PROCESS_TYPE_KEY") 55 - filter("STS"."ORDER_LINE_KEY"=:B1) 56 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_33) filter("STS"."STATUS_QUANTITY">:SYS_B_33) 59 - access("P"."PIPELINE_KEY"=) 61 - filter("ORS"."ORDER_LINE_KEY"=:B1) 62 - access("ORS"."ORDER_HEADER_KEY"=:B1 AND "ORS"."STATUS_QUANTITY">:SYS_B_38) filter("ORS"."STATUS_QUANTITY">:SYS_B_38) 64 - access("ST"."STATUS"= AND "P"."PROCESS_TYPE_KEY"="ST"."PROCESS_TYPE_KEY") 66 - filter("STS"."ORDER_LINE_KEY"=:B1) 67 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_36 AND "STS"."STATUS"<:SYS_B_37) filter("STS"."STATUS_QUANTITY">:SYS_B_36) 69 - filter("OG"."IS_NODE"=:SYS_B_88) 70 - access("OG"."ORGANIZATION_KEY"=:B1) 72 - access("OG"."LOCALE_CODE"="LO"."LOCALECODE") 74 - filter("RCPT_STATUS"."NEW_STATUS"=:SYS_B_40) 75 - access("RCPT_STATUS"."RECEIPT_HEADER_KEY"=:B1) 77 - filter("RCPT_STATUS"."NEW_STATUS"=:SYS_B_41) 78 - access("RCPT_STATUS"."RECEIPT_HEADER_KEY"=:B1) 80 - filter("STS"."ORDER_LINE_KEY"=:B1) 81 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_44) filter("STS"."STATUS_QUANTITY">:SYS_B_44) 83 - filter("STS"."ORDER_LINE_KEY"=:B1) 84 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_47) filter("STS"."STATUS_QUANTITY">:SYS_B_47) 86 - filter("STS"."ORDER_LINE_KEY"=:B1) 87 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_48) filter("STS"."STATUS_QUANTITY">:SYS_B_48) 90 - access("P"."PIPELINE_KEY"=) 92 - filter("ORS"."ORDER_LINE_KEY"=:B1) 93 - access("ORS"."ORDER_HEADER_KEY"=:B1 AND "ORS"."STATUS_QUANTITY">:SYS_B_50) filter("ORS"."STATUS_QUANTITY">:SYS_B_50) 95 - access("ST"."STATUS"= AND "P"."PROCESS_TYPE_KEY"="ST"."PROCESS_TYPE_KEY") 97 - filter("STS"."ORDER_LINE_KEY"=:B1) 98 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_49) filter("STS"."STATUS_QUANTITY">:SYS_B_49) 100 - filter("STS"."ORDER_LINE_KEY"=:B1) 101 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_51) filter("STS"."STATUS_QUANTITY">:SYS_B_51) 103 - filter("STS"."ORDER_LINE_KEY"=:B1) 104 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_52) filter("STS"."STATUS_QUANTITY">:SYS_B_52) 107 - access("P"."PIPELINE_KEY"=) 109 - filter("ORS"."ORDER_LINE_KEY"=:B1) 110 - access("ORS"."ORDER_HEADER_KEY"=:B1 AND "ORS"."STATUS_QUANTITY">:SYS_B_54) filter("ORS"."STATUS_QUANTITY">:SYS_B_54) 112 - access("ST"."STATUS"= AND "P"."PROCESS_TYPE_KEY"="ST"."PROCESS_TYPE_KEY") 114 - filter("STS"."ORDER_LINE_KEY"=:B1) 115 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_53) filter("STS"."STATUS_QUANTITY">:SYS_B_53) 117 - filter("STS"."ORDER_LINE_KEY"=:B1) 118 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_55) filter("STS"."STATUS_QUANTITY">:SYS_B_55) 120 - filter("STS"."ORDER_LINE_KEY"=:B1) 121 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_56 AND "STS"."STATUS"<:SYS_B_57) filter("STS"."STATUS_QUANTITY">:SYS_B_56) 124 - access("P"."PIPELINE_KEY"=) 126 - filter("ORS"."ORDER_LINE_KEY"=:B1) 127 - access("ORS"."ORDER_HEADER_KEY"=:B1 AND "ORS"."STATUS_QUANTITY">:SYS_B_59) filter("ORS"."STATUS_QUANTITY">:SYS_B_59) 129 - access("ST"."STATUS"= AND "P"."PROCESS_TYPE_KEY"="ST"."PROCESS_TYPE_KEY") 131 - filter("STS"."ORDER_LINE_KEY"=:B1) 132 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_58) filter("STS"."STATUS_QUANTITY">:SYS_B_58) 135 - access("P"."PIPELINE_KEY"=) 137 - filter("ORS"."ORDER_LINE_KEY"=:B1) 138 - access("ORS"."ORDER_HEADER_KEY"=:B1 AND "ORS"."STATUS_QUANTITY">:SYS_B_63) filter("ORS"."STATUS_QUANTITY">:SYS_B_63) 140 - access("ST"."STATUS"= AND "P"."PROCESS_TYPE_KEY"="ST"."PROCESS_TYPE_KEY") 142 - filter("STS"."ORDER_LINE_KEY"=:B1) 143 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_61 AND "STS"."STATUS"<:SYS_B_62) filter("STS"."STATUS_QUANTITY">:SYS_B_61) 145 - filter("RCPT_STATUS"."NEW_STATUS"=:SYS_B_65) 146 - access("RCPT_STATUS"."RECEIPT_HEADER_KEY"=:B1) 148 - filter("STS"."ORDER_LINE_KEY"=:B1) 149 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_66) filter("STS"."STATUS_QUANTITY">:SYS_B_66) 151 - filter("STS"."ORDER_LINE_KEY"=:B1) 152 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_69) filter("STS"."STATUS_QUANTITY">:SYS_B_69) 154 - filter("STS"."ORDER_LINE_KEY"=:B1) 155 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_70) filter("STS"."STATUS_QUANTITY">:SYS_B_70) 158 - access("P"."PIPELINE_KEY"=) 160 - filter("ORS"."ORDER_LINE_KEY"=:B1) 161 - access("ORS"."ORDER_HEADER_KEY"=:B1 AND "ORS"."STATUS_QUANTITY">:SYS_B_72) filter("ORS"."STATUS_QUANTITY">:SYS_B_72) 163 - access("ST"."STATUS"= AND "P"."PROCESS_TYPE_KEY"="ST"."PROCESS_TYPE_KEY") 165 - filter("STS"."ORDER_LINE_KEY"=:B1) 166 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_71) filter("STS"."STATUS_QUANTITY">:SYS_B_71) 168 - filter("STS"."ORDER_LINE_KEY"=:B1) 169 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_73) filter("STS"."STATUS_QUANTITY">:SYS_B_73) 171 - filter("STS"."ORDER_LINE_KEY"=:B1) 172 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_74) filter("STS"."STATUS_QUANTITY">:SYS_B_74) 175 - access("P"."PIPELINE_KEY"=) 177 - filter("ORS"."ORDER_LINE_KEY"=:B1) 178 - access("ORS"."ORDER_HEADER_KEY"=:B1 AND "ORS"."STATUS_QUANTITY">:SYS_B_76) filter("ORS"."STATUS_QUANTITY">:SYS_B_76) 180 - access("ST"."STATUS"= AND "P"."PROCESS_TYPE_KEY"="ST"."PROCESS_TYPE_KEY") 182 - filter("STS"."ORDER_LINE_KEY"=:B1) 183 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_75) filter("STS"."STATUS_QUANTITY">:SYS_B_75) 185 - filter("STS"."ORDER_LINE_KEY"=:B1) 186 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_77) filter("STS"."STATUS_QUANTITY">:SYS_B_77) 188 - filter("STS"."ORDER_LINE_KEY"=:B1) 189 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_78 AND "STS"."STATUS"<:SYS_B_79) filter("STS"."STATUS_QUANTITY">:SYS_B_78) 192 - access("P"."PIPELINE_KEY"=) 194 - filter("ORS"."ORDER_LINE_KEY"=:B1) 195 - access("ORS"."ORDER_HEADER_KEY"=:B1 AND "ORS"."STATUS_QUANTITY">:SYS_B_81) filter("ORS"."STATUS_QUANTITY">:SYS_B_81) 197 - access("ST"."STATUS"= AND "P"."PROCESS_TYPE_KEY"="ST"."PROCESS_TYPE_KEY") 199 - filter("STS"."ORDER_LINE_KEY"=:B1) 200 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_80) filter("STS"."STATUS_QUANTITY">:SYS_B_80) 203 - access("P"."PIPELINE_KEY"=) 205 - filter("ORS"."ORDER_LINE_KEY"=:B1) 206 - access("ORS"."ORDER_HEADER_KEY"=:B1 AND "ORS"."STATUS_QUANTITY">:SYS_B_85) filter("ORS"."STATUS_QUANTITY">:SYS_B_85) 208 - access("ST"."STATUS"= AND "P"."PROCESS_TYPE_KEY"="ST"."PROCESS_TYPE_KEY") 210 - filter("STS"."ORDER_LINE_KEY"=:B1) 211 - access("STS"."ORDER_HEADER_KEY"=:B1 AND "STS"."STATUS_QUANTITY">:SYS_B_83 AND "STS"."STATUS"<:SYS_B_84) filter("STS"."STATUS_QUANTITY">:SYS_B_83) 213 - filter("RCPT_STATUS"."NEW_STATUS"=:SYS_B_87) 214 - access("RCPT_STATUS"."RECEIPT_HEADER_KEY"=:B1) 222 - access("EA"."ORDER_HEADER_KEY"="OH"."ORDER_HEADER_KEY") 225 - access("OH"."ORDER_HEADER_KEY"="OL"."ORDER_HEADER_KEY") 232 - filter(:SYS_B_93=:SYS_B_94) 237 - access("ITEM"."ORGANIZATION_CODE"="OH"."ENTERPRISE_KEY" AND "OH"."ORDER_HEADER_KEY"="OL"."ORDER_HEADER_KEY") 238 - access("ITEM"."ITEM_ID"="OL"."ITEM_ID" AND "ITEM"."UOM"="OL"."UOM") 239 - access("ITEM"."ORGANIZATION_CODE"="OH"."ENTERPRISE_KEY" AND "OL"."ORDER_HEADER_KEY"="OH"."ORDER_HEADER_KEY") 242 - access("ITEM"."ITEM_ID"="OL"."ITEM_ID" AND "ITEM"."UOM"="OL"."UOM") 250 - filter(("CANCELLED_DATE"."STATUS_QUANTITY">:SYS_B_89 AND "CANCELLED_DATE"."STATUS"=:SYS_B_90)) 251 - access("CANCELLED_DATE"."ORDER_LINE_KEY"="OL"."ORDER_LINE_KEY") 253 - access("OL"."ORDER_LINE_KEY"="RL"."ORDER_LINE_KEY") 258 - access("RH"."RECEIPT_HEADER_KEY"="RL"."RECEIPT_HEADER_KEY") 260 - access("RHP"."PIPELINE_KEY"="RH"."PIPELINE_KEY") 262 - access("RHST"."STATUS"="RH"."STATUS" AND "RHP"."PROCESS_TYPE_KEY"="RHST"."PROCESS_TYPE_KEY") 264 - access("SH"."SHIPMENT_KEY"="from$_subquery$_100"."SHIPMENT_KEY") 265 - filter("SL"."SHIPMENT_KEY"="from$_subquery$_103"."QCSJ_C000000010300001") 266 - access("from$_subquery$_103"."QCSJ_C000000009300000"="SL"."ORDER_LINE_KEY") 267 - filter(("TS"."TASK_TYPE"=:SYS_B_91 AND "TS"."TASK_STATUS"<>:SYS_B_92 AND "TS"."ITEM_ID"="RL"."ITEM_ID" AND "TS"."RECEIPT_HEADER_KEY"="RH"."RECEIPT_HEADER_KEY")) 268 - access("TS"."SOURCE_LPN_NO"="RL"."LPN_NO") 490 rows selected.