Explain plan of the query:- PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------------------------------------------------- Plan hash value: 3959607522 --------------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | Inst |IN-OUT| --------------------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 43782 | 202M| | 141K (2)| 00:28:17 | | | | 1 | VIEW | | 43782 | 202M| | 141K (2)| 00:28:17 | | | | 2 | TEMP TABLE TRANSFORMATION | | | | | | | | | | 3 | LOAD AS SELECT | SYS_TEMP_0FD9D6A69_5E4D09D9 | | | | | | | | | 4 | VIEW | | 2366K| 232M| | 131K (2)| 00:26:22 | | | |* 5 | HASH JOIN RIGHT OUTER | | 2366K| 266M| 34M| 131K (2)| 00:26:22 | | | |* 6 | TABLE ACCESS FULL | ETA | 1264K| 20M| | 3109 (3)| 00:00:38 | | | | 7 | VIEW | | 2366K| 227M| | 114K (2)| 00:22:51 | | | |* 8 | HASH JOIN RIGHT OUTER | | 2366K| 241M| 41M| 114K (2)| 00:22:51 | | | | 9 | TABLE ACCESS FULL | PICKUP | 1671K| 22M| | 3925 (2)| 00:00:48 | | | | 10 | VIEW | | 2366K| 209M| | 96380 (2)| 00:19:17 | | | |* 11 | HASH JOIN RIGHT OUTER | | 2366K| 230M| 46M| 96380 (2)| 00:19:17 | | | |* 12 | TABLE ACCESS FULL | DELIVERY | 1667K| 27M| | 5066 (3)| 00:01:01 | | | | 13 | VIEW | | 2366K| 191M| | 78077 (2)| 00:15:37 | | | |* 14 | HASH JOIN | | 2366K| 176M| 94M| 78077 (2)| 00:15:37 | | | |* 15 | TABLE ACCESS FULL | TRANS_ORDER | 2466K| 65M| | 16321 (2)| 00:03:16 | | | | 16 | VIEW | | 2366K| 112M| | 50044 (2)| 00:10:01 | | | |* 17 | HASH JOIN RIGHT OUTER | | 2366K| 78M| 54M| 50044 (2)| 00:10:01 | | | | 18 | VIEW | V_SHIPMENT_ORDER | 2366K| 27M| | 32421 (2)| 00:06:30 | | | | 19 | SORT UNIQUE | | 2366K| 27M| 45M| 32421 (2)| 00:06:30 | | | | 20 | VIEW | | 2366K| 27M| | 21406 (2)| 00:04:17 | | | |* 21 | HASH JOIN | | 2366K| 54M| 54M| 21406 (2)| 00:04:17 | | | | 22 | INDEX FAST FULL SCAN| IDX_SHIPLINE_ORDLINEID | 2366K| 27M| | 5391 (1)| 00:01:05 | | | | 23 | INDEX FAST FULL SCAN| IDX_ORDERLINE_ORDERID | 3873K| 44M| | 8792 (1)| 00:01:46 | | | | 24 | TABLE ACCESS FULL | SHIPMENT | 1798K| 39M| | 11864 (3)| 00:02:23 | | | |* 25 | HASH JOIN OUTER | | 43782 | 204M| | 9612 (2)| 00:01:56 | | | | 26 | VIEW | | 185 | 867K| | 5 (20)| 00:00:01 | | | | 27 | REMOTE | | | | | | | SU | R->S | | 28 | VIEW | | 2366K| 225M| | 9579 (2)| 00:01:55 | | | | 29 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6A69_5E4D09D9 | 2366K| 212M| | 9579 (2)| 00:01:55 | | | --------------------------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 5 - access("PSH"."SHIPMENT_ID"="ALT_PETA"."SHIPMENT_ID"(+)) 6 - filter("ALT_PETA"."ETA_NUMBER"(+)=1) 8 - access("PSH"."SHIPMENT_ID"="PPICKUP"."SHIPMENT_ID"(+)) 11 - access("PSH"."SHIPMENT_ID"="PDE"."SHIPMENT_ID"(+)) 12 - filter("PDE"."FAILED"(+)=0) 14 - access("PTO"."ORDER_ID"="SO"."ORDER_ID") 15 - filter("PTO"."ORIG_DATE_CREATED">=TO_DATE(' 2013-09-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 17 - access("PSH"."SHIPMENT_ID"="SO"."SHIPMENT_ID"(+)) 21 - access("S"."ORDER_LINE_ID"="O"."ID") 25 - access(TRIM("WMS_ORDERS"."SHIPMENT_NO")=TRIM("PUCM_SHIPMENTS"."PUCM_SHIPMENT_NO"(+)) AND TRIM("WMS_ORDERS"."ORDER_NO")=TRIM("PUCM_SHIPMENTS"."PUCM_ORDER_NO"(+))) Remote SQL Information (identified by operation id): ---------------------------------------------------- 27 - EXPLAIN PLAN INTO PLAN_TABLE@! FOR SELECT NVL("A2"."QCSJ_C000000006800003_573","A1"."TIMEZONE"),TRIM("A2"."ENTERPRISE_KEY_1"), TRIM(NVL("A2"."QCSJ_C000000004800002_189","A2"."QCSJ_C000000004800003_348")),"A2"."CODE_LONG_DESCRIPTION_491",CASE "A2"."DOCUMENT_TYPE_6" WHEN '0001' THEN 'Sales Order' ELSE 'Transfer Order' END ,TRIM(NVL("A2"."QCSJ_C000000004600048_100","A2"."LEVEL_OF_SERVICE_349")),TRIM("A2"."EXTN_REFERENCE_1_119"),TRIM("A2"."SHIPMENT_NO_347 "),TRIM("A2"."ORDER_NO_2"),TRIM(TO_CHAR("A2"."PRIME_LINE_NO_156")),TRIM("A2"."QCSJ_C000000004800005_354"),TRIM("A2"."SOURCE_ZONE_ID_3 81"),"A2"."QCSJ_C000000004600009_195","A2"."QCSJ_C000000006200008_464", (SELECT MAX("A6"."CREATETS") FROM "YFS_SHIPMENT_STATUS_AUDIT" "A6" WHERE "A6"."SHIPMENT_KEY"="A2"."QCSJ_C000000005800000_345" AND "A6"."NEW_STATUS"='1200'), (SELECT MAX("A5"."CREATETS") FROM "YFS_SHIPMENT_STATUS_AUDIT" "A5" WHERE "A5"."SHIPMENT_KEY"="A2"."QCSJ_C000000005800000_345" AND "A5"."NEW_STATUS"='1300'),"A2"."QCSJ_C000000005800005_449",TRIM("A2"."QCSJ_C000000005400006_374"),TRIM("A2"."QCSJ_C000000005400004_37 3"),"A2"."QCSJ_C000000006200004_369",TRIM(NVL("A2"."QCSJ_C000000004800006_160","A2"."QCSJ_C000000004800007_355")),TRIM(NVL("A2"."QCSJ _C000000004800008_163","A2"."QCSJ_C000000004800009_356")),TRIM(NVL("A2"."INVENTORY_STATUS_380",'ATP')),TRIM("A2"."CONTAINER_SCM_365") ,TRIM("A2"."LOT_NUMBER_361"),TRIM("A2"."BATCH_NO_362"),TRIM("A2"."REVISION_NO_363"),TRIM("A2"."QCSJ_C000000004800011_357"),TRIM("A2". "SOURCE_LOCATION_ID_379"),TRIM("A2"."QCSJ_C000000004800015_364"),TRIM("A2"."BOL_NO_352"),TRIM("A2"."SCAC_351"),TRIM("A2"."EXTN_RAWB_N O_133"),"A2"."ORIGINAL_ORDERED_QTY_232","A2"."TOTAL_QUANTITY_479",NVL(NVL("A2"."SERIAL_SHIPPED_QTY_366","A2"."CONTAINER_LINE_DETAIL_Q TY_367"),"A2"."QUANTITY_358"),TRIM("A2"."QCSJ_C000000004800013_359"),TRIM("A2"."QCSJ_C000000006800000_408"), (SELECT DISTINCT FIRST_VALUE("A4"."INSTRUCTION_TEXT") OVER ( ORDER BY "A4"."SEQUENCE_NO" RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW ) FROM "YFS_INSTRUCTION_DETAIL" "A4" WHERE "A4"."REFERENCE_KEY"="A2"."QCSJ_C000000004800000_154" AND "A4"."TABLE_NAME"='YFS_ORDER_LINE' AND TRIM("A4"."INSTRUCTION_TYPE")='PICK'), (SELECT DISTINCT FIRST_VALUE("A3"."INSTRUCTION_TEXT") OVER ( ORDER BY "A3"."SEQUENCE_NO" RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW ) FROM "YFS_INSTRUCTION_DETAIL" "A3" WHERE "A3"."REFERENCE_KEY"="A2"."QCSJ_C000000004800000_154" AND "A3"."TABLE_NAME"='YFS_ORDER_LINE' AND TRIM("A3"."INSTRUCTION_TYPE")='PACK'),"A2"."SHIPPED_DATE_382","A2"."QCSJ_C000000004600050_104","A2"."QCSJ_C000000004600052_105","A2". "QCSJ_C000000004600053_306","A2"."SH_MODIFYTS_353","A2"."SL_MODIFYTS_360" FROM (SELECT "A8"."QCSJ_C000000004600000_0" "QCSJ_C000000004600000_0","A8"."ENTERPRISE_KEY_1" "ENTERPRISE_KEY_1","A8"."ORDER_NO_2" "ORDER_NO_2","A8"."SOURCING_CLASSIFICATION_3" "SOURCING_CLASSIFICATION","A8"."BUYER_ORGANIZATION_CODE_4" "BUYER_ORGANIZATION_CODE","A8"."SELLER_ORGANIZATION_CODE_5" "SELLER_ORGANIZATION_CODE","A8"."DOCUMENT_TYPE_6" "DOCUMENT_TYPE_6","A8"."BILL_TO_KEY_7" "BILL_TO_KEY","A8"."BILL_TO_ID_8" "BILL_TO_ID","A8"."VENDOR_ID_9" "VENDOR_ID","A8"."QCSJ_C000000004600002_10" "QCSJ_C000000004600002","A8"."QCSJ_C000000004600038_11" "QCSJ_C000000004600038","A8"."SHIP_NODE_12" "SHIP_NODE","A8"."QCSJ_C000000004600042_13" "QCSJ_C000000004600042","A8"."QCSJ_C000000004600044_14" "QCSJ_C000000004600044","A8"."QCSJ_C000000004600004_15" "QCSJ_C000000004600004","A8"."QCSJ_C000000004600006_16" "QCSJ_C000000004600006","A8"."QCSJ_C000000004600008_17" "QCSJ_C000000004600008","A8"."QCSJ_C000000004600010_18" "QCSJ_C000000004600010","A8"."QCSJ_C000000004600012_19" "QCSJ_C000000004600012","A8"."DEFAULT_TEMPLATE_20" "DEFAULT_TEMPLATE","A8"."DIVISION_21" "DIVISION","A8"."ORDER_DATE_22" "ORDER_DATE","A8"."ORDER_TYPE_23" "ORDER_TYPE","A8"."DRAFT_ORDER_FLAG_24" "DRAFT_ORDER_FLAG","A8"."ORDER_PURPOSE_25" "ORDER_PURPOSE","A8"."RETURN_OH_KEY_FOR_EXCHANGE_26" "RETURN_OH_KEY_FOR_EXCHANGE","A8"."EXCHANGE_TYPE_27" "EXCHANGE_TYPE","A8"."PENDING_TRANSFER_IN_28" "PENDING_TRANSFER_IN","A8"."RETURN_BY_GIFT_RECIPIENT_29" "RETURN_BY_GIFT_RECIPIENT","A8"."ALLOCATION_RULE_ID_30" "ALLOCATION_RULE_ID","A8"."PRIORITY_CODE_31" "PRIORITY_CODE","A8"."PRIORITY_NUMBER_32" "PRIORITY_NUMBER","A8"."CONTACT_KEY_33" "CONTACT_KEY","A8"."QCSJ_C000000004600014_34" "QCSJ_C000000004600014","A8"."QCSJ_C000000004600016_35" "QCSJ_C000000004600016","A8"."CUSTCARRIER_ACCOUNT_NO_36" "CUSTCARRIER_ACCOUNT_NO","A8"."NOTIFY_AFTER_SHIPMENT_FLAG_37" "NOTIFY_AFTER_SHIPMENT_FLAG","A8"."CREATED_AT_NODE_38" "CREATED_AT_NODE","A8"."HAS_DERIVED_CHILD_39" "HAS_DERIVED_CHILD","A8"."HAS_DERIVED_PARENT_40" "HAS_DERIVED_PARENT","A8"."NOTIFICATION_TYPE_41" "NOTIFICATION_TYPE","A8"."NOTIFICATION_REFERENCE_42" "NOTIFICATION_REFERENCE","A8"."ENTRY_TYPE_43" "ENTRY_TYPE","A8"."AUTHORIZED_CLIENT_44" "AUTHORIZED_CLIENT","A8"."ENTERED_BY_45" "ENTERED_BY","A8"."QCSJ_C000000004600026_46" "QCSJ_C000000004600026","A8"."QCSJ_C000000004600018_47" "QCSJ_C000000004600018","A8"."QCSJ_C000000004600020_48" "QCSJ_C000000004600020","A8"."QCSJ_C000000004600030_49" "QCSJ_C000000004600030","A8"."CUSTOMER_CUSTOMER_PO_NO_50" "CUSTOMER_CUSTOMER_PO_NO","A8"."ORDER_NAME_51" "ORDER_NAME","A8"."PAYMENT_RULE_ID_52" "PAYMENT_RULE_ID","A8"."TERMS_CODE_53" "TERMS_CODE","A8"."QCSJ_C000000004600034_54" "QCSJ_C000000004600034","A8"."CHARGE_ACTUAL_FREIGHT_55" "CHARGE_ACTUAL_FREIGHT","A8"."QCSJ_C000000004600032_56" "QCSJ_C000000004600032","A8"."TOTAL_AMOUNT_57" "TOTAL_AMOUNT","A8"."ORIGINAL_TOTAL_AMOUNT_58" "ORIGINAL_TOTAL_AMOUNT","A8"."ORIGINAL_TAX_59" "ORIGINAL_TAX","A8"."CURRENCY_60" "QCSJ_C000000006800004","A8"."ENTERPRISE_CURRENCY_61" "ENTERPRISE_CURRENCY","A8"."REPORTING_CONVERSION_RATE_62" "REPORTING_CONVERSION_RATE","A8"."REPORTING_CONVERSION_DATE_63" "REPORTING_CONVERSION_DATE","A8"."PAYMENT_STATUS_64" "PAYMENT_STATUS","A8"."AUTHORIZATION_EXPIRATION_DATE_" "AUTHORIZATION_EXPIRATION_DATE","A8"."SEARCH_CRITERIA_1_66" "SEARCH_CRITERIA_1","A8"."SEARCH_CRITERIA_2_67" "SEARCH_CRITERIA_2","A8"."CUSTOMER_EMAILID_68" "CUSTOMER_EMAILID","A8"."QCSJ_C000000004600036_69" "QCSJ_C000000004600036","A8"."TOTAL_ADJUSTMENT_AMOUNT_70" "TOTAL_ADJUSTMENT_AMOUNT","A8"."QCSJ_C000000004600022_71" "QCSJ_C000000004600022","A8"."PRICE_PROGRAM_KEY_72" "PRICE_PROGRAM_KEY","A8"."QCSJ_C000000006600000_73" "QCSJ_C000000006600000","A8"."QCSJ_C000000006600002_74" "QCSJ_C000000006600002","A8"."QCSJ_C000000006600004_75" "QCSJ_C000000006600004","A8"."QCSJ_C000000004600024_76" "QCSJ_C000000004600024","A8"."QCSJ_C000000004600040_77" "QCSJ_C000000004600040","A8"."QCSJ_C000000004600046_78" "QCSJ_C000000004600046","A8"."ORDER_CLOSED_79" "ORDER_CLOSED","A8"."NEXT_ALERT_TS_80" "NEXT_ALERT_TS","A8"."DO_NOT_CONSOLIDATE_81" "DO_NOT_CONSOLIDATE","A8"."CHAIN_TYPE_82" "CHAIN_TYPE","A8"."ADJUSTMENT_INVOICE_PENDING_83" "ADJUSTMENT_INVOICE_PENDING","A8"."AUTO_CANCEL_DATE_84" "AUTO_CANCEL_DATE","A8"."SALE_VOIDED_85" "SALE_VOIDED","A8"."IS_SHIP_COMPLETE_86" "IS_SHIP_COMPLETE","A8"."IS_LINE_SHIP_COMPLETE_87" "IS_LINE_SHIP_COMPLETE","A8"."IS_SHIP_SINGLE_NODE_88" "IS_SHIP_SINGLE_NODE","A8"."IS_LINE_SHIP_SINGLE_NODE_89" "IS_LINE_SHIP_SINGLE_NODE","A8"."CANCEL_ORDER_ON_EXCP_FLAG_90" "CANCEL_ORDER_ON_EXCP_FLAG","A8"."OPTIMIZATION_TYPE_91" "OPTIMIZATION_TYPE","A8"."PURGE_HISTORY_DATE_92" "PURGE_HISTORY_DATE","A8"."PRICING_CLASSIFICATION_CODE_93" "PRICING_CLASSIFICATION_CODE","A8"."SOURCE_TYPE_94" "SOURCE_TYPE","A8"."SOURCE_KEY_95" "SOURCE_KEY","A8"."LINKED_SOURCE_KEY_96" "LINKED_SOURCE_KEY","A8"."ORIGINAL_CONTAINER_KEY_97" "ORIGINAL_CONTAINER_KEY","A8"."SOLD_TO_KEY_98" "SOLD_TO_KEY","A8"."TEAM_CODE_99" "TEAM_CODE","A8"."QCSJ_C000000004600048_100" "QCSJ_C000000004600048_100","A8"."NEXT_ITER_SEQ_NO_101" "NEXT_ITER_SEQ_NO","A8"."NEXT_ITER_DATE_102" "NEXT_ITER_DATE","A8"."HRS_BEFORE_NEXT_ITER_103" "HRS_BEFORE_NEXT_ITER","A8"."QCSJ_C000000004600050_104" "QCSJ_C000000004600050_104","A8"."QCSJ_C000000004600052_105" "QCSJ_C000000004600052_105","A8"."QCSJ_C000000004600054_106" "QCSJ_C000000004600054","A8"."QCSJ_C000000004600056_107" "QCSJ_C000000004600056","A8"."QCSJ_C000000004600058_108" "QCSJ_C000000004600058","A8"."QCSJ_C000000004600060_109" "QCSJ_C000000004600060","A8"."QCSJ_C000000004600062_110" "QCSJ_C000000004600062","A8"."QCSJ_C000000004600028_111" "QCSJ_C000000004600028","A8"."BUYER_USER_ID_112" "BUYER_USER_ID","A8"."RECREATE_AUTHORIZATIONS_113" "RECREATE_AUTHORIZATIONS","A8"."CUSTOMER_CONTACT_ID_114" "CUSTOMER_CONTACT_ID","A8"."OPPORTUNITY_KEY_115" "OPPORTUNITY_KEY","A8"."IS_EXPIRATION_DATE_OVERRIDDEN_" "IS_EXPIRATION_DATE_OVERRIDDEN","A8"."EXPIRATION_DATE_117" "EXPIRATION_DATE","A8"."APPROVAL_CYCLE_118" "APPROVAL_CYCLE","A8"."EXTN_REFERENCE_1_119" "EXTN_REFERENCE_1_119","A8"."EXTN_REFERENCE_2_120" "EXTN_REFERENCE_2","A8"."EXTN_REFERENCE_3_121" "EXTN_REFERENCE_3","A8"."EXTN_REFERENCE_4_122" "EXTN_REFERENCE_4","A8"."EXTN_REFERENCE_5_123" "EXTN_REFERENCE_5","A8"."EXTN_REFERENCE_6_124" "EXTN_REFERENCE_6","A8"."EXTN_DOCUMENT_IDENTIFIER_125" "EXTN_DOCUMENT_IDENTIFIER","A8"."EXTN_DOCUMENT_DATE_126" "EXTN_DOCUMENT_DATE","A8"."EXTN_SHIP_TO_LOCATION_ID_127" "EXTN_SHIP_TO_LOCATION_ID","A8"."EXTN_CUST_CREATE_TIME_128" "EXTN_CUST_CREATE_TIME","A8"."EXTN_CUST_SVC_TIME_129" "EXTN_CUST_SVC_TIME","A8"."EXTN_LEG_TYPE_130" "EXTN_LEG_TYPE","A8"."EXTN_FIRST_LEG_ORDER_NO_131" "EXTN_FIRST_LEG_ORDER_NO","A8"."EXTN_AWB_132" "EXTN_AWB","A8"."EXTN_RAWB_NO_133" "EXTN_RAWB_NO_133","A8"."EXTN_SHIPMENT_CONSOLIDATED_134" "EXTN_SHIPMENT_CONSOLIDATED","A8"."EXTN_DEFAULT_ETA_USED_135" "EXTN_DEFAULT_ETA_USED","A8"."EXTN_SHIP_TO_TIME_ZONE_136" "EXTN_SHIP_TO_TIME_ZONE","A8"."EXTN_DHL_SERVICE_TYPE_137" "EXTN_DHL_SERVICE_TYPE","A8"."EXTN_TRAVEL_DISTANCE_138" "EXTN_TRAVEL_DISTANCE","A8"."EXTN_TRAVEL_DISTANCE_MILES_139" "EXTN_TRAVEL_DISTANCE_MILES","A8"."EXTN_ACTUAL_PICK_UP_DATETIME_1" "EXTN_ACTUAL_PICK_UP_DATETIME","A8"."EXTN_POD_141" "EXTN_POD","A8"."EXTN_SIGNER_142" "EXTN_SIGNER","A8"."EXTN_EVENT_STATUS_143" "EXTN_EVENT_STATUS","A8"."EXTN_ADDITIONAL_FEE_144" "EXTN_ADDITIONAL_FEE","A8"."EXTN_LEG_SEQUENCE_145" "EXTN_LEG_SEQUENCE","A8"."EXTN_ORDER_SEQUENCE_146" "EXTN_ORDER_SEQUENCE","A8"."EXTN_IS_SUBSTITUTION_ALLOWED_1" "EXTN_IS_SUBSTITUTION_ALLOWED","A8"."EXTN_FIELD_ENGINEER_ID_148" "EXTN_FIELD_ENGINEER_ID","A8"."EXTN_REQUESTOR_ID_149" "EXTN_REQUESTOR_ID","A8"."EXTN_INSTANCE_ID_150" "EXTN_INSTANCE_ID","A8"."EXTN_SHIP_TO_TAXID_151" "EXTN_SHIP_TO_TAXID","A8"."EXTN_TERMS_OF_DELIVERY_152" "EXTN_TERMS_OF_DELIVERY","A8"."EXTN_REQ_SHIP_DATE_153" "EXTN_REQ_SHIP_DATE","A8"."QCSJ_C000000004800000_154" "QCSJ_C000000004800000_154","A8"."QCSJ_C000000004600001_155" "QCSJ_C000000004600001","A8"."PRIME_LINE_NO_156" "PRIME_LINE_NO_156","A8"."SUB_LINE_NO_157" "SUB_LINE_NO","A8"."LINE_TYPE_158" "LINE_TYPE","A8"."ORDER_CLASS_159" "ORDER_CLASS","A8"."QCSJ_C000000004800006_160" "QCSJ_C000000004800006_160","A8"."ALTERNATE_ITEM_ID_161" "ALTERNATE_ITEM_ID","A8"."QCSJ_C000000004800012_162" "QCSJ_C000000004800012","A8"."QCSJ_C000000004800008_163" "QCSJ_C000000004800008_163","A8"."UNIT_PRICE_164" "UNIT_PRICE","A8"."COST_CURRENCY_165" "COST_CURRENCY","A8"."ORDERED_QTY_166" "ORDERED_QTY","A8"."BASIC_CAPACITY_REQUIRED_167" "BASIC_CAPACITY_REQUIRED","A8"."OPTION_CAPACITY_REQUIRED_168" "OPTION_CAPACITY_REQUIRED","A8"."ALLOCATION_LEAD_TIME_169" "ALLOCATION_LEAD_TIME","A8"."DEPENDENT_ON_LINE_KEY_170" "DEPENDENT_ON_LINE_KEY","A8"."CURRENT_WORK_ORDER_KEY_171" "CURRENT_WORK_ORDER_KEY","A8"."DEPENDENCY_SHIPPING_RULE_172" "DEPENDENCY_SHIPPING_RULE","A8"."FILL_QUANTITY_173" "FILL_QUANTITY","A8"."COMMITTED_QUANTITY_174" "COMMITTED_QUANTITY","A8"."DEPENDENCY_RATIO_175" "DEPENDENCY_RATIO","A8"."MAINTAIN_RATIO_176" "MAINTAIN_RATIO","A8"."MERGE_NODE_177" "MERGE_NODE","A8"."PARENT_OF_DEPENDENT_GROUP_178" "PARENT_OF_DEPENDENT_GROUP","A8"."SOURCE_FROM_ORGANIZATION_179" "SOURCE_FROM_ORGANIZATION","A8"."CHAINED_FROM_ORDER_LINE_KEY_18" "CHAINED_FROM_ORDER_LINE_KEY","A8"."CHAINED_FROM_ORDER_HEADER_KEY_" "CHAINED_FROM_ORDER_HEADER_KEY","A8"."DERIVED_FROM_ORDER_LINE_KEY_18" "DERIVED_FROM_ORDER_LINE_KEY","A8"."DERIVED_FROM_ORDER_HEADER_KEY_" "DERIVED_FROM_ORDER_HEADER_KEY","A8"."DERIVED_FROM_ORDER_RELEASE_KEY" "DERIVED_FROM_ORDER_RELEASE_KEY","A8"."DISTRIBUTION_RULE_ID_185" "DISTRIBUTION_RULE_ID","A8"."INVOICED_QUANTITY_186" "INVOICED_QUANTITY","A8"."OVER_RECEIPT_QUANTITY_187" "OVER_RECEIPT_QUANTITY","A8"."RETURN_REASON_188" "RETURN_REASON","A8"."QCSJ_C000000004800002_189" "QCSJ_C000000004800002_189","A8"."PROCURE_FROM_NODE_190" "PROCURE_FROM_NODE","A8"."QCSJ_C000000004600003_191" "QCSJ_C000000004600003","A8"."QCSJ_C000000004600005_192" "QCSJ_C000000004600005","A8"."QCSJ_C000000004600007_193" "QCSJ_C000000004600007","A8"."ALLOCATE_DATE_194" "ALLOCATE_DATE","A8"."QCSJ_C000000004600009_195" "QCSJ_C000000004600009_195","A8"."QCSJ_C000000004600011_196" "QCSJ_C000000004600011","A8"."QCSJ_C000000004600013_197" "QCSJ_C000000004600013","A8"."QCSJ_C000000004600015_198" "QCSJ_C000000004600015","A8"."QCSJ_C000000004600017_199" "QCSJ_C000000004600017","A8"."CARRIER_ACCOUNT_NO_200" "CARRIER_ACCOUNT_NO","A8"."PICKABLE_FLAG_201" "PICKABLE_FLAG","A8"."SHIP_TOGETHER_NO_202" "SHIP_TOGETHER_NO","A8"."QCSJ_C000000004600019_203" "QCSJ_C000000004600019","A8"."KIT_CODE_204" "KIT_CODE","A8"."QCSJ_C000000004600021_205" "QCSJ_C000000004600021","A8"."QCSJ_C000000004600023_206" "QCSJ_C000000004600023","A8"."LINE_TOTAL_207" "LINE_TOTAL","A8"."INVOICED_LINE_TOTAL_208" "INVOICED_LINE_TOTAL","A8"."INVOICED_EXTENDED_PRICE_209" "INVOICED_EXTENDED_PRICE","A8"."SETTLED_QUANTITY_210" "SETTLED_QUANTITY","A8"."SETTLED_AMOUNT_211" "SETTLED_AMOUNT","A8"."TAXABLE_FLAG_212" "TAXABLE_FLAG","A8"."QCSJ_C000000004600025_213" "QCSJ_C000000004600025","A8"."DISCOUNT_TYPE_214" "DISCOUNT_TYPE","A8"."DISCOUNT_REFERENCE_215" "DISCOUNT_REFERENCE","A8"."GIFT_FLAG_216" "GIFT_FLAG","A8"."PERSONALIZE_FLAG_217" "PERSONALIZE_FLAG","A8"."QCSJ_C000000004600027_218" "QCSJ_C000000004600027","A8"."QCSJ_C000000004600029_219" "QCSJ_C000000004600029","A8"."CUSTOMER_ITEM_220" "CUSTOMER_ITEM","A8"."CUSTOMER_ITEM_DESCRIPTION_221" "CUSTOMER_ITEM_DESCRIPTION","A8"."ITEM_WEIGHT_222" "ITEM_WEIGHT","A8"."ITEM_WEIGHT_UOM_223" "ITEM_WEIGHT_UOM","A8"."ITEM_DESCRIPTION_224" "ITEM_DESCRIPTION","A8"."ITEM_SHORT_DESCRIPTION_225" "ITEM_SHORT_DESCRIPTION","A8"."RESERVATION_ID_226" "RESERVATION_ID","A8"."RESERVATION_POOL_227" "RESERVATION_POOL","A8"."QCSJ_C000000004600031_228" "QCSJ_C000000004600031","A8"."CUSTOMER_PO_LINE_NO_229" "CUSTOMER_PO_LINE_NO","A8"."QCSJ_C000000004600033_230" "QCSJ_C000000004600033","A8"."QCSJ_C000000004600035_231" "QCSJ_C000000004600035","A8"."ORIGINAL_ORDERED_QTY_232" "ORIGINAL_ORDERED_QTY_232","A8"."LIST_PRICE_233" "LIST_PRICE","A8"."RETAIL_PRICE_234" "RETAIL_PRICE","A8"."DISCOUNT_PERCENTAGE_235" "DISCOUNT_PERCENTAGE","A8"."PACKLIST_TYPE_236" "PACKLIST_TYPE","A8"."SUPPLIER_ITEM_237" "SUPPLIER_ITEM","A8"."SUPPLIER_ITEM_DESCRIPTION_238" "SUPPLIER_ITEM_DESCRIPTION","A8"."UNIT_COST_239" "UNIT_COST","A8"."UPC_CODE_240" "UPC_CODE","A8"."QCSJ_C000000004600037_241" "QCSJ_C000000004600037","A8"."MANUFACTURER_NAME_242" "MANUFACTURER_NAME","A8"."MANUFACTURER_ITEM_243" "MANUFACTURER_ITEM","A8"."MANUFACTURER_ITEM_DESC_244" "MANUFACTURER_ITEM_DESC","A8"."QCSJ_C000000004800010_245" "QCSJ_C000000004800010","A8"."ISBN_246" "ISBN","A8"."HARMONIZED_CODE_247" "HARMONIZED_CODE","A8"."QCSJ_C000000004600039_248" "QCSJ_C000000004600039","A8"."PRODUCT_LINE_249" "PRODUCT_LINE","A8"."NMFC_CODE_250" "NMFC_CODE","A8"."NMFC_CLASS_251" "NMFC_CLASS","A8"."NMFC_DESCRIPTION_252" "NMFC_DESCRIPTION","A8"."TAX_PRODUCT_CODE_253" "TAX_PRODUCT_CODE","A8"."IMPORT_LICENSE_NO_254" "IMPORT_LICENSE_NO","A8"."IMPORT_LICENSE_EXP_DATE_255" "IMPORT_LICENSE_EXP_DATE","A8"."ECCN_NO_256" "ECCN_NO","A8"."SCHEDULE_B_CODE_257" "SCHEDULE_B_CODE","A8"."SUPPLIER_CODE_258" "SUPPLIER_CODE","A8"."QCSJ_C000000004600041_259" "QCSJ_C000000004600041","A8"."QCSJ_C000000004600043_260" "QCSJ_C000000004600043","A8"."QCSJ_C000000004600045_261" "QCSJ_C000000004600045","A8"."SHIPMENT_CONSOL_GROUP_ID_262" "SHIPMENT_CONSOL_GROUP_ID","A8"."ORIG_ORDER_LINE_KEY_263" "ORIG_ORDER_LINE_KEY","A8"."LINE_SEQ_NO_264" "LINE_SEQ_NO","A8"."SPLIT_QTY_265" "SPLIT_QTY","A8"."PRICING_DATE_266" "PRICING_DATE","A8"."QCSJ_C000000006200006_267" "QCSJ_C000000006200006","A8"."CONDITION_VARIABLE_1_268" "CONDITION_VARIABLE_1","A8"."CONDITION_VARIABLE_2_269" "CONDITION_VARIABLE_2","A8"."IS_PRICE_LOCKED_270" "IS_PRICE_LOCKED","A8"."IS_COST_OVERRIDDEN_271" "IS_COST_OVERRIDDEN","A8"."IS_CAPACITY_OVERRIDDEN_272" "IS_CAPACITY_OVERRIDDEN","A8"."QCSJ_C000000004600047_273" "QCSJ_C000000004600047","A8"."DELIVERY_METHOD_274" "DELIVERY_METHOD","A8"."ITEM_GROUP_CODE_275" "ITEM_GROUP_CODE","A8"."CANNOT_COMPLETE_BEFORE_DATE_27" "CANNOT_COMPLETE_BEFORE_DATE","A8"."CANNOT_COMPLETE_AFTER_DATE_277" "CANNOT_COMPLETE_AFTER_DATE","A8"."APPT_STATUS_278" "APPT_STATUS","A8"."CAN_ADD_SERVICE_LINES_279" "CAN_ADD_SERVICE_LINES","A8"."PRICING_UOM_280" "PRICING_UOM","A8"."CAPACITY_UOM_281" "CAPACITY_UOM","A8"."PRICING_QUANTITY_282" "PRICING_QUANTITY","A8"."SHIPPED_QUANTITY_283" "SHIPPED_QUANTITY","A8"."FIXED_CAPACITY_QTY_PER_LINE_28" "FIXED_CAPACITY_QTY_PER_LINE","A8"."FIXED_PRICING_QTY_PER_LINE_285" "FIXED_PRICING_QTY_PER_LINE","A8"."WAIT_FOR_SEQ_LINE_286" "WAIT_FOR_SEQ_LINE","A8"."SCHED_FAILURE_REASON_CODE_287" "SCHED_FAILURE_REASON_CODE","A8"."EARLIEST_SHIP_DATE_288" "EARLIEST_SHIP_DATE","A8"."EARLIEST_DELIVERY_DATE_289" "EARLIEST_DELIVERY_DATE","A8"."CANNOT_MEET_APPT_290" "CANNOT_MEET_APPT","A8"."PROMISED_APPT_START_DATE_291" "PROMISED_APPT_START_DATE","A8"."PROMISED_APPT_END_DATE_292" "PROMISED_APPT_END_DATE","A8"."QCSJ_C000000004800004_293" "QCSJ_C000000004800004","A8"."SEGMENT_TYPE_294" "SEGMENT_TYPE","A8"."EARLIEST_SCHEDULE_DATE_295" "EARLIEST_SCHEDULE_DATE","A8"."TIMEZONE_296" "QCSJ_C000000006800002","A8"."IS_FORWARDING_ALLOWED_297" "IS_FORWARDING_ALLOWED","A8"."IS_PROCUREMENT_ALLOWED_298" "IS_PROCUREMENT_ALLOWED","A8"."RESHIP_PARENT_LINE_KEY_299" "RESHIP_PARENT_LINE_KEY","A8"."BUNDLE_PARENT_ORDER_LINE_KEY_3" "BUNDLE_PARENT_ORDER_LINE_KEY","A8"."IS_PRICE_INFO_ONLY_301" "IS_PRICE_INFO_ONLY","A8"."QCSJ_C000000004600049_302" "QCSJ_C000000004600049","A8"."FIRST_ITER_SEQ_NO_303" "FIRST_ITER_SEQ_NO","A8"."LAST_ITER_SEQ_NO_304" "LAST_ITER_SEQ_NO","A8"."QCSJ_C000000004600051_305" "QCSJ_C000000004600051","A8"."QCSJ_C000000004600053_306" "QCSJ_C000000004600053_306","A8"."QCSJ_C000000004600055_307" "QCSJ_C000000004600055","A8"."QCSJ_C000000004600057_308" "QCSJ_C000000004600057","A8"."QCSJ_C000000004600059_309" "QCSJ_C000000004600059","A8"."QCSJ_C000000004600061_310" "QCSJ_C000000004600061","A8"."QCSJ_C000000004600063_311" "QCSJ_C000000004600063","A8"."ORDERING_UOM_312" "ORDERING_UOM","A8"."PRICING_QUANTITY_CONV_FACTOR_3" "PRICING_QUANTITY_CONV_FACTOR","A8"."PRICING_QUANTITY_STRATEGY_314" "PRICING_QUANTITY_STRATEGY","A8"."INVOICED_PRICING_QUANTITY_315" "INVOICED_PRICING_QUANTITY","A8"."IS_STANDALONE_SERVICE_316" "IS_STANDALONE_SERVICE","A8"."TRAN_DISCREPANCY_QTY_317" "TRAN_DISCREPANCY_QTY","A8"."RECEIVED_QUANTITY_318" "RECEIVED_QUANTITY","A8"."INVOICE_BASED_ON_ACTUALS_319" "INVOICE_BASED_ON_ACTUALS","A8"."ACTUAL_PRICING_QUANTITY_320" "ACTUAL_PRICING_QUANTITY","A8"."FULFILLMENT_TYPE_321" "FULFILLMENT_TYPE","A8"."QCSJ_C000000004800014_322" "QCSJ_C000000004800014","A8"."RESERVATION_MANDATORY_323" "RESERVATION_MANDATORY","A8"."IS_FIRM_PREDEFINED_NODE_324" "IS_FIRM_PREDEFINED_NODE","A8"."INTENTIONAL_BACKORDER_325" "INTENTIONAL_BACKORDER","A8"."FUTURE_AVAIL_DATE_326" "FUTURE_AVAIL_DATE","A8"."REPRICING_QUANTITY_327" "REPRICING_QUANTITY","A8"."MIN_SHIP_BY_DATE_328" "MIN_SHIP_BY_DATE","A8"."KIT_QTY_329" "KIT_QTY","A8"."BOM_CONFIG_KEY_330" "BOM_CONFIG_KEY","A8"."BUNDLE_FULFILLMENT_MODE_331" "BUNDLE_FULFILLMENT_MODE","A8"."IS_GIFT_WRAP_332" "IS_GIFT_WRAP","A8"."EXTN_IS_RETURNABLE_333" "EXTN_IS_RETURNABLE","A8"."EXTN_JOB_NO_334" "EXTN_JOB_NO","A8"."EXTN_HOT_FLAG_335" "EXTN_HOT_FLAG","A8"."EXTN_INSPECTION_FLAG_336" "EXTN_INSPECTION_FLAG","A8"."EXTN_GOOD_WHSE_337" "EXTN_GOOD_WHSE","A8"."EXTN_BAD_WHSE_338" "EXTN_BAD_WHSE","A8"."EXTN_ORIG_LINE_NO_339" "EXTN_ORIG_LINE_NO","A8"."EXTN_ITEM_VOLUME_340" "EXTN_ITEM_VOLUME","A8"."EXTN_ITEM_VOLUME_UOM_341" "EXTN_ITEM_VOLUME_UOM","A8"."EXTN_LICENSE_EXCEPTION_342" "EXTN_LICENSE_EXCEPTION","A8"."QCSJ_C000000005000000_343" "QCSJ_C000000005000000","A8"."QCSJ_C000000004800001_344" "QCSJ_C000000004800001","A8"."QCSJ_C000000005800000_345" "QCSJ_C000000005800000_345","A8"."QCSJ_C000000005200000_346" "QCSJ_C000000005200000","A8"."SHIPMENT_NO_347" "SHIPMENT_NO_347","A8"."QCSJ_C000000004800003_348" "QCSJ_C000000004800003_348","A8"."LEVEL_OF_SERVICE_349" "LEVEL_OF_SERVICE_349","A8"."ACTUAL_SHIPMENT_DATE_350" "ACTUAL_SHIPMENT_DATE","A8"."SCAC_351" "SCAC_351","A8"."BOL_NO_352" "BOL_NO_352","A8"."SH_MODIFYTS_353" "SH_MODIFYTS_353","A8"."QCSJ_C000000004800005_354" "QCSJ_C000000004800005_354","A8"."QCSJ_C000000004800007_355" "QCSJ_C000000004800007_355","A8"."QCSJ_C000000004800009_356" "QCSJ_C000000004800009_356","A8"."QCSJ_C000000004800011_357" "QCSJ_C000000004800011_357","A8"."QUANTITY_358" "QUANTITY_358","A8"."QCSJ_C000000004800013_359" "QCSJ_C000000004800013_359","A8"."SL_MODIFYTS_360" "SL_MODIFYTS_360","A8"."LOT_NUMBER_361" "LOT_NUMBER_361","A8"."BATCH_NO_362" "BATCH_NO_362","A8"."REVISION_NO_363" "REVISION_NO_363","A8"."QCSJ_C000000004800015_364" "QCSJ_C000000004800015_364","A8"."CONTAINER_SCM_365" "CONTAINER_SCM_365","A8"."SERIAL_SHIPPED_QTY_366" "SERIAL_SHIPPED_QTY_366","A8"."CONTAINER_LINE_DETAIL_QTY_367" "CONTAINER_LINE_DETAIL_QTY_367","A8"."QCSJ_C000000006200000_368" "QCSJ_C000000006200000","A8"."QCSJ_C000000006200004_369" "QCSJ_C000000006200004_369","A8"."QCSJ_C000000005400000_370" "QCSJ_C000000005400000","A8"."QCSJ_C000000005400002_371" "QCSJ_C000000005400002","A8"."QCSJ_C000000005000001_372" "QCSJ_C000000005000001","A8"."QCSJ_C000000005400004_373" "QCSJ_C000000005400004_373","A8"."QCSJ_C000000005400006_374" "QCSJ_C000000005400006_374","A8"."QCSJ_C000000005200001_375" "QCSJ_C000000005200001","A8"."TASK_KEY_376" "TASK_KEY","A8"."TASK_TYPE_377" "TASK_TYPE","A8"."TASK_STATUS_378" "TASK_STATUS","A8"."SOURCE_LOCATION_ID_379" "SOURCE_LOCATION_ID_379","A8"."INVENTORY_STATUS_380" "INVENTORY_STATUS_380","A8"."SOURCE_ZONE_ID_381" "SOURCE_ZONE_ID_381","A8"."SHIPPED_DATE_382" "SHIPPED_DATE_382","A8"."QCSJ_C000000005400001_383" "QCSJ_C000000005400001","A8"."QCSJ_C000000005400003_384" "QCSJ_C000000005400003","A8"."QCSJ_C000000006200002_385" "QCSJ_C000000006200002","A8"."QCSJ_C000000005400005_386" "QCSJ_C000000005400005","A8"."QCSJ_C000000005400007_387" "QCSJ_C000000005400007","A8"."COUNT(*)_388" "COUNT(*)","A8"."PERSON_INFO_KEY_389" "PERSON_INFO_KEY","A8"."PERSON_ID_390" "PERSON_ID","A8"."TITLE_391" "TITLE","A8"."FIRST_NAME_392" "FIRST_NAME","A8"."MIDDLE_NAME_393" "MIDDLE_NAME","A8"."LAST_NAME_394" "LAST_NAME","A8"."SUFFIX_395" "SUFFIX","A8"."DEPARTMENT_396" "DEPARTMENT","A8"."COMPANY_397" "COMPANY","A8"."JOB_TITLE_398" "JOB_TITLE","A8"."ADDRESS_LINE1_399" "ADDRESS_LINE1","A8"."ADDRESS_LINE2_400" "ADDRESS_LINE2","A8"."ADDRESS_LINE3_401" "ADDRESS_LINE3","A8"."ADDRESS_LINE4_402" "ADDRESS_LINE4","A8"."ADDRESS_LINE5_403" "ADDRESS_LINE5","A8"."ADDRESS_LINE6_404" "ADDRESS_LINE6","A8"."CITY_405" "CITY","A8"."STATE_406" "STATE","A8"."ZIP_CODE_407" "ZIP_CODE","A8"."COUNTRY_408" "QCSJ_C000000006800000_408","A8"."DAY_PHONE_409" "DAY_PHONE","A8"."EVENING_PHONE_410" "EVENING_PHONE","A8"."MOBILE_PHONE_411" "MOBILE_PHONE","A8"."BEEPER_412" "BEEPER","A8"."OTHER_PHONE_413" "OTHER_PHONE","A8"."DAY_FAX_NO_414" "DAY_FAX_NO","A8"."EVENING_FAX_NO_415" "EVENING_FAX_NO","A8"."EMAILID_416" "EMAILID","A8"."ALTERNATE_EMAILID_417" "ALTERNATE_EMAILID","A8"."PREFERRED_SHIP_ADDRESS_418" "PREFERRED_SHIP_ADDRESS","A8"."HTTP_URL_419" "HTTP_URL","A8"."USE_COUNT_420" "USE_COUNT","A8"."VERIFICATION_STATUS_421" "VERIFICATION_STATUS","A8"."IS_ADDRESS_VERIFIED_422" "IS_ADDRESS_VERIFIED","A8"."LATITUDE_423" "LATITUDE","A8"."LONGITUDE_424" "LONGITUDE","A8"."TAX_GEO_CODE_425" "TAX_GEO_CODE","A8"."ERROR_TXT_426" "ERROR_TXT","A8"."IS_COMMERCIAL_ADDRESS_427" "IS_COMMERCIAL_ADDRESS","A8"."TIME_ZONE_428" "TIME_ZONE","A8"."QCSJ_C000000005800002_429" "QCSJ_C000000005800002","A8"."QCSJ_C000000005800004_430" "QCSJ_C000000005800004","A8"."QCSJ_C000000005800006_431" "QCSJ_C000000005800006","A8"."QCSJ_C000000005800008_432" "QCSJ_C000000005800008","A8"."QCSJ_C000000005800010_433" "QCSJ_C000000005800010","A8"."QCSJ_C000000005800012_434" "QCSJ_C000000005800012","A8"."QCSJ_C000000005800014_435" "QCSJ_C000000005800014","A8"."ADDRESS_ID_436" "ADDRESS_ID","A8"."SHORT_ZIP_CODE_437" "SHORT_ZIP_CODE","A8"."EXTN_LATITUDE_438" "EXTN_LATITUDE","A8"."EXTN_LONGITUDE_439" "EXTN_LONGITUDE","A8"."QCSJ_C000000006000000_440" "QCSJ_C000000006000000","A8"."QCSJ_C000000005800001_441" "QCSJ_C000000005800001","A8"."QCSJ_C000000006000002_442" "QCSJ_C000000006000002","A8"."QCSJ_C000000006000004_443" "QCSJ_C000000006000004","A8"."QCSJ_C000000006000006_444" "Q (accessing 'SU' ) 280 rows selected.