Hibernate: select orderdetai0_.ID as ID, orderdetai0_.UUID as UUID, orderdetai0_.ORDER_NO as ORDER_NO, orderdetai0_.ORDER_ITEM_INDEX as ORDER_IT4_, orderdetai0_.MATERIAL as MATERIAL, orderdetai0_.ORDER_QTY as ORDER_QTY, orderdetai0_.SALES_UNIT as SALES_UNIT, orderdetai0_.DESCRIPTION as DESCRIPT8_, orderdetai0_.EACH_RATE as EACH_RATE, orderdetai0_.CUSTOMER_MATERIAL_NO as CUSTOME10_, orderdetai0_.ITEM_CATEGORY as ITEM_CA11_, orderdetai0_.PLANT as PLANT, orderdetai0_.PRICE as PRICE, orderdetai0_.CURRENCY as CURRENCY, orderdetai0_.PER as PER, orderdetai0_.SHIP_TO as SHIP_TO, orderdetai0_.BILL_TO as BILL_TO, orderdetai0_.PAYER_TO as PAYER_TO, orderdetai0_.CUST_REQUIRE_DATE as CUST_RE19_, orderdetai0_.SHIP_CODE as SHIP_CODE, orderdetai0_.CONDITION_TYPE as CONDITI21_, orderdetai0_.PO_NO as PO_NO, orderdetai0_.PO_ITEM as PO_ITEM, orderdetai0_.SHIP_TO_PO_NO as SHIP_TO24_, orderdetai0_.SHIP_TO_PO_ITEM as SHIP_TO25_, orderdetai0_.PRODUCTION_SITUATION as PRODUCT26_, orderdetai0_.SALES_USAGE_CATEGORY as SALES_U27_, orderdetai0_.INCO_TERMS1 as INCO_TE28_, orderdetai0_.INCO_TERMS2 as INCO_TE29_, orderdetai0_.PAYMENT_TERM as PAYMENT30_, orderdetai0_.TAX_CLASSIFFC as TAX_CLA31_, orderdetai0_.TAX_RATE as TAX_RATE, orderdetai0_.ITEM_PO_DATE as ITEM_PO33_, orderdetai0_.ITEM_NET_VALUE as ITEM_NE34_, orderdetai0_.ITEM_NOTE as ITEM_NOTE, orderdetai0_.REMARK as REMARK, orderdetai0_.SOLD_TO as SOLD_TO, orderdetai0_.REFERENCE_DOCUMENT_NO as REFEREN38_, orderdetai0_.CLOSE_DATE as CLOSE_DATE, orderdetai0_.ORDER_TYPE as ORDER_TYPE, orderdetai0_.REFER_ITEM_NO as REFER_I41_, orderdetai0_.REFER_NO as REFER_NO, orderdetai0_.REJECT_FOR_REASON as REJECT_43_, orderdetai0_.SAP_DESCRIPTION as SAP_DES44_, orderdetai0_.SHIPPING_QTY as SHIPPIN45_, orderdetai0_.OLD_SHIPPING_QTY as OLD_SHI46_, orderdetai0_.BASE_UNIT as BASE_UNIT, orderdetai0_.GROSS_DIE as GROSS_DIE, orderdetai0_.DEL_FLAG as DEL_FLAG, orderdetai0_.CREATED_BY_OA_ID as CREATED50_, orderdetai0_.UPDATED_BY_OA_ID as UPDATED51_, orderdetai0_.CREATED_TIME as CREATED52_, orderdetai0_.UPDATED_TIME as UPDATED53_, orderdetai0_.CREATED_BY_COMPANY as CREATED54_, orderdetai0_.CREATED_BY_FAB as CREATED55_, orderdetai0_.CREATED_BY_WORKCODE as CREATED56_, orderdetai0_.UPDATED_BY_WORKCODE as UPDATED57_, orderdetai0_.FOUNDARY_FAB as FOUNDAR58_, orderdetai0_.SHIP_FROM_FAB as SHIP_FR59_, orderdetai0_.CUST_PO_ITEM as CUST_PO60_, orderdetai0_.PART_NO as PART_NO, orderdetai0_.PAGE_DELIVERY_QTY as PAGE_DE62_, orderdetai0_.LABEL_FIELD_1 as LABEL_F63_, orderdetai0_.LABEL_FIELD_2 as LABEL_F64_ from CERP_OMS_ORDER_DETAIL orderdetai0_ where (orderdetai0_.DEL_FLAG=0 )and(orderdetai0_.ORDER_NO!='New' )and(orderdetai0_.ORDER_NO=? )and(orderdetai0_.CREATED_BY_COMPANY=? )and(exists(select order1_.ID from CERP_OMS_ORDER order1_ where (order1_.DEL_FLAG=0 )and(order1_.RELEASE_STATUS='Close' )and(orderdetai0_.ORDER_NO=order1_.ORDER_NO )and(orderdetai0_.CREATED_BY_COMPANY=order1_.CREATED_BY_COMPANY ))) order by orderdetai0_.CREATED_TIME desc , orderdetai0_.ORDER_NO asc , cast(orderdetai0_.ORDER_ITEM_INDEX as integer)asc
Hibernate: select * from ( select orderdetai0_.ID as ID, orderdetai0_.UUID as UUID, orderdetai0_.ORDER_NO as ORDER_NO, orderdetai0_.ORDER_ITEM_INDEX as ORDER_IT4_, orderdetai0_.MATERIAL as MATERIAL, orderdetai0_.ORDER_QTY as ORDER_QTY, orderdetai0_.SALES_UNIT as SALES_UNIT, orderdetai0_.DESCRIPTION as DESCRIPT8_, orderdetai0_.EACH_RATE as EACH_RATE, orderdetai0_.CUSTOMER_MATERIAL_NO as CUSTOME10_, orderdetai0_.ITEM_CATEGORY as ITEM_CA11_, orderdetai0_.PLANT as PLANT, orderdetai0_.PRICE as PRICE, orderdetai0_.CURRENCY as CURRENCY, orderdetai0_.PER as PER, orderdetai0_.SHIP_TO as SHIP_TO, orderdetai0_.BILL_TO as BILL_TO, orderdetai0_.PAYER_TO as PAYER_TO, orderdetai0_.CUST_REQUIRE_DATE as CUST_RE19_, orderdetai0_.SHIP_CODE as SHIP_CODE, orderdetai0_.CONDITION_TYPE as CONDITI21_, orderdetai0_.PO_NO as PO_NO, orderdetai0_.PO_ITEM as PO_ITEM, orderdetai0_.SHIP_TO_PO_NO as SHIP_TO24_, orderdetai0_.SHIP_TO_PO_ITEM as SHIP_TO25_, orderdetai0_.PRODUCTION_SITUATION as PRODUCT26_, orderdetai0_.SALES_USAGE_CATEGORY as SALES_U27_, orderdetai0_.INCO_TERMS1 as INCO_TE28_, orderdetai0_.INCO_TERMS2 as INCO_TE29_, orderdetai0_.PAYMENT_TERM as PAYMENT30_, orderdetai0_.TAX_CLASSIFFC as TAX_CLA31_, orderdetai0_.TAX_RATE as TAX_RATE, orderdetai0_.ITEM_PO_DATE as ITEM_PO33_, orderdetai0_.ITEM_NET_VALUE as ITEM_NE34_, orderdetai0_.ITEM_NOTE as ITEM_NOTE, orderdetai0_.REMARK as REMARK, orderdetai0_.SOLD_TO as SOLD_TO, orderdetai0_.REFERENCE_DOCUMENT_NO as REFEREN38_, orderdetai0_.CLOSE_DATE as CLOSE_DATE, orderdetai0_.ORDER_TYPE as ORDER_TYPE, orderdetai0_.REFER_ITEM_NO as REFER_I41_, orderdetai0_.REFER_NO as REFER_NO, orderdetai0_.REJECT_FOR_REASON as REJECT_43_, orderdetai0_.SAP_DESCRIPTION as SAP_DES44_, orderdetai0_.SHIPPING_QTY as SHIPPIN45_, orderdetai0_.OLD_SHIPPING_QTY as OLD_SHI46_, orderdetai0_.BASE_UNIT as BASE_UNIT, orderdetai0_.GROSS_DIE as GROSS_DIE, orderdetai0_.DEL_FLAG as DEL_FLAG, orderdetai0_.CREATED_BY_OA_ID as CREATED50_, orderdetai0_.UPDATED_BY_OA_ID as UPDATED51_, orderdetai0_.CREATED_TIME as CREATED52_, orderdetai0_.UPDATED_TIME as UPDATED53_, orderdetai0_.CREATED_BY_COMPANY as CREATED54_, orderdetai0_.CREATED_BY_FAB as CREATED55_, orderdetai0_.CREATED_BY_WORKCODE as CREATED56_, orderdetai0_.UPDATED_BY_WORKCODE as UPDATED57_, orderdetai0_.FOUNDARY_FAB as FOUNDAR58_, orderdetai0_.SHIP_FROM_FAB as SHIP_FR59_, orderdetai0_.CUST_PO_ITEM as CUST_PO60_, orderdetai0_.PART_NO as PART_NO, orderdetai0_.PAGE_DELIVERY_QTY as PAGE_DE62_, orderdetai0_.LABEL_FIELD_1 as LABEL_F63_, orderdetai0_.LABEL_FIELD_2 as LABEL_F64_ from CERP_OMS_ORDER_DETAIL orderdetai0_ where (orderdetai0_.DEL_FLAG=0 )and(orderdetai0_.ORDER_NO!='New' )and(orderdetai0_.ORDER_NO=? )and(orderdetai0_.CREATED_BY_COMPANY=? )and(exists(select order1_.ID from CERP_OMS_ORDER order1_ where (order1_.DEL_FLAG=0 )and(order1_.RELEASE_STATUS='Close' )and(orderdetai0_.ORDER_NO=order1_.ORDER_NO )and(orderdetai0_.CREATED_BY_COMPANY=order1_.CREATED_BY_COMPANY ))) order by orderdetai0_.CREATED_TIME desc , orderdetai0_.ORDER_NO asc , cast(orderdetai0_.ORDER_ITEM_INDEX as integer)asc ) where rownum <= ?
10-20 15:36:00.439 WARN [DefaultActionInvocation.java:265] No result defined for action com.smec.apps.oms.orderContract.action.SearchOrderAction and result null
最新发布