java.lang.Objectcom.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
com.ibm.commerce.order.objects.OrderAccessBean
Each row in this table represents an order in a store. This access bean corresponds to the database table 'ORDERS'.
Constructor Summary | |
OrderAccessBean() Zero argument constructor used to initialize the access bean. |
|
OrderAccessBean(javax.ejb.EJBObject o) constructor |
|
OrderAccessBean(java.lang.Long arg1, java.lang.Integer arg2, java.lang.Double arg3, java.math.BigDecimal arg4, java.sql.Timestamp arg5) Maps to a corresponding ejbCreate method in the home interface of the EJB |
|
OrderAccessBean(java.lang.Long arg1, java.lang.Integer arg2, java.lang.Double arg3, java.sql.Timestamp arg4) Maps to a corresponding ejbCreate method in the home interface of the EJB |
|
OrderAccessBean(java.lang.Long arg1, java.lang.Integer arg2, java.sql.Timestamp arg3) Maps to a corresponding ejbCreate method in the home interface of the EJB |
Method Summary | |
void | clearOrderItemsCache() |
void | commitCopyHelper() Update(flush) data to the EJBObject (persistent storage). |
protected java.lang.String | defaultJNDIName() |
java.util.Enumeration | findByMemberForUpdate(java.lang.Long memberId)
Retrieves all the orders for given customer.
The SQL query used to fetch all the required rows from the ORDERS table is: SELECT * FROM ORDERS T1 WHERE T1.MEMBER_ID = ? for update |
OrderAccessBean | findByOrderForUpdate(java.lang.Long orderId)
Retrieves OrderAccessBean representing the order with specified order identifier.
The SQL query used to fetch all the required rows from the ORDERS table is: SELECT * FROM ORDERS T1 WHERE T1.ORDERS_ID = ? for update |
java.util.Enumeration | findByOrderIds(java.lang.Long[] anOrderIds) findByOrderIds |
java.util.Enumeration | findByStatus(java.lang.String argStatus)
Retrieves all the orders with specified status.
The SQL query used to fetch all the required rows from the ORDERS table is: SELECT * FROM ORDERS T1 WHERE (T1.STATUS = ?) |
java.util.Enumeration | findByStatusAndMember(java.lang.String argStatus, java.lang.Long argMemberId)
Retrieves all the orders for specified status and member.
The SQL query used to fetch all the required rows from the ORDERS table is: SELECT * FROM ORDERS T1 WHERE (T1.STATUS = ?) AND (T1.MEMBER_ID = ?) ORDER BY T1.ORDERS_ID |
java.util.Enumeration | findByStatusAndMemberScopedByLastUpdate(java.lang.String argStatus, java.lang.Long argMemberId, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate) findByStatusAndMemberScopedByLastUpdate |
java.util.Enumeration | findByStatusAndMemberScopedByTimePlaced(java.lang.String argStatus, java.lang.Long argMemberId, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate) findByStatusAndMemberScopedByTimePlaced |
java.util.Enumeration | findByStatusesMemberStoreHostedAtChannelStartEndDateAndDateField(java.lang.String[] aStatusList, java.lang.Long aMemberId, java.lang.Integer aChannelStoreId, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField) findByStatusesMemberStoreHostedAtChannelStartEndDateAndDateField |
java.util.Enumeration | findByStatusesMemberStoresRelTypeStartEndDateAndDateField(java.lang.String[] aStatusList, java.lang.Long aMemberId, java.lang.Integer[] aStoreIdList, java.lang.String aRelType, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField) findByStatusesMemberStoresRelTypeStartEndDateAndDateField |
java.util.Enumeration | findByStatusesMemberStoresStartEndDateAndDateField(java.lang.String[] aStatusList, java.lang.Long aMemberId, java.lang.Integer[] aStoreIdList, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField) findByStatusesMemberStoresStartEndDateAndDateField |
java.util.Enumeration | findByStatusMemberAndRelType(java.lang.String istrOrderStatus, java.lang.Long inUserId, java.lang.String istrRelType) findByStatusMemberAndRelType |
java.util.Enumeration | findByStatusMemberAndRelTypeScopedByLastUpdate(java.lang.String istrOrderStatus, java.lang.Long inUserId, java.lang.String istrRelType, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate) findByStatusMemberAndRelTypeScopedByLastUpdate |
java.util.Enumeration | findByStatusMemberAndRelTypeScopedByTimePlaced(java.lang.String istrOrderStatus, java.lang.Long inUserId, java.lang.String istrRelType, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate) findByStatusMemberAndRelTypeScopedByTimePlaced |
java.util.Enumeration | findByStatusMemberAndStore(java.lang.String argStatus, java.lang.Long argMemberId, java.lang.Integer argStoreId)
Retrieves all the orders for specified status, member and store.
The SQL query used to fetch all the required rows from the ORDERS table is: SELECT * FROM ORDERS T1 WHERE (T1.STATUS = ?) AND (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?) ORDER BY T1.ORDERS_ID |
java.util.Enumeration | findByStatusMemberAndStoreForUpdate(java.lang.String status, java.lang.Long memberId, java.lang.Integer storeId)
Retrieves all the orders for specified status, member and store.
The SQL query used to fetch all the required rows from the ORDERS table is: SELECT * FROM ORDERS T1 WHERE (T1.STATUS = ?) AND (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?) ORDER BY T1.ORDERS_ID for update |
java.util.Enumeration | findByStatusMemberAndStoreHostedAtChannel(java.lang.String argStatus, java.lang.Long argMemberId, java.lang.Integer argStoreId) Gets all the orders for the user under those merchant hosted at channel merchant that are in the state specified. |
java.util.Enumeration | findByStatusMemberAndStoreScopedByLastUpdate(java.lang.String argStatus, java.lang.Long argMemberId, java.lang.Integer argStoreId, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate) findByStatusMemberAndStoreScopedByLastUpdate |
java.util.Enumeration | findByStatusMemberAndStoreScopedByTimePlaced(java.lang.String argStatus, java.lang.Long argMemberId, java.lang.Integer argStoreId, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate) findByStatusMemberAndStoreScopedByTimePlaced |
java.util.Enumeration | findByStatusMemberRelTypeAndStore(java.lang.String istrOrderStatus, java.lang.Long inUserId, java.lang.String istrRelType, java.lang.Integer inStoreId) findByStatusMemberRelTypeAndStore |
java.util.Enumeration | findByStatusMemberRelTypeAndStoreScopedByLastUpdate(java.lang.String istrOrderStatus, java.lang.Long inUserId, java.lang.String istrRelType, java.lang.Integer inStoreId, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate) findByStatusMemberRelTypeAndStoreScopedByLastUpdate |
java.util.Enumeration | findByStatusMemberRelTypeAndStoreScopedByTimePlaced(java.lang.String istrOrderStatus, java.lang.Long inUserId, java.lang.String istrRelType, java.lang.Integer inStoreId, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate) findByStatusMemberRelTypeAndStoreScopedByTimePlaced |
java.util.Enumeration | findByStatusStoreentIdAndDescription(java.lang.String status, java.lang.Integer storeentId, java.lang.String description) findByStatusStoreentIdAndDescription |
java.util.Enumeration | findByStoreIdMemberIdAndStatus(java.lang.Integer storeId, java.lang.Long memberId, java.lang.String status, java.lang.String orderByClause, boolean forUpdate) IBM internal use only. |
java.util.Enumeration | findChildOrderByDistributorStoreIdsAndOrdersIdAndRelType(java.lang.Integer[] aDistributorStoreIds, java.lang.Long aOrdersId, java.lang.String aRelType) findChildOrderByDistributorStoreIdsAndOrdersIdAndRelType |
java.util.Enumeration | findCurrentPendingOrders()
Retrieves all the current pending orders.
The SQL query used to fetch all the required rows from the ORDERS table is: SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'P') AND T1.ORDERS_ID IN (SELECT ORDERS_ID FROM CPENDORDER) ORDER BY T1.LASTUPDATE |
java.util.Enumeration | findCurrentPendingOrdersByMember(java.lang.Long argMemberId)
Retrieves all the current pending orders for specified customer.
The SQL query used to fetch all the required rows from the ORDERS table is: SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'P') AND T1.ORDERS_ID IN (SELECT ORDERS_ID FROM CPENDORDER) ORDER BY T1.LASTUPDATE |
java.util.Enumeration | findCurrentPendingOrdersByMemberAndStore(java.lang.Long argMemberId, java.lang.Integer argStoreId)
Retrieves all the current pending orders for specified customer and store.
The SQL query used to fetch all the required rows from the ORDERS table is: SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'P') AND (T1.ORDERS_ID IN (SELECT ORDERS_ID FROM CPENDORDER WHERE MEMBER_ID = ?)) AND (STOREENT_ID = ?) ORDER BY T1.LASTUPDATE |
java.util.Enumeration | findFullyTransferredOrdersByChannelStoreIdAndShopperId(java.lang.Integer aChannelStoreId, java.lang.Long aShopperId) findFullyTransferredOrdersByChannelStoreIdAndShopperId |
java.util.Enumeration | findFullyTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField(java.lang.Integer storeId, java.lang.Long memberId, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField) findFullyTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField |
java.util.Enumeration | findNotTransferredOrdersByChannelStoreIdAndShopperId(java.lang.Integer aChannelStoreId, java.lang.Long aShopperId) findNotTransferredOrdersByChannelStoreIdAndShopperId |
java.util.Enumeration | findNotTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField(java.lang.Integer storeId, java.lang.Long memberId, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField) findNotTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField |
java.util.Enumeration | findOrderTemplatesByMember(java.lang.Long memberId)
Retrieves all the order templates for specified member.
The SQL query used to fetch all the required rows from the ORDERS table is: SELECT * FROM ORDERS T1 WHERE T1.ORDERS_ID in (select ORDERS_ID from ORDERTMPL where MEMBER_ID = ?) |
java.util.Enumeration | findOrderTemplatesByMemberAndUsage(java.lang.Long memberId, java.lang.Integer usage)
Retrieves all the order templates for specified member and usage.
The SQL query used to fetch all the required rows from the ORDERS table is: SELECT * FROM ORDERS T1 WHERE T1.ORDERS_ID in (select ORDERS_ID from ORDERTMPL where MEMBER_ID = ? and USAGE = ?) |
java.util.Enumeration | findOrderTemplatesByStoreAndMember(java.lang.Integer storeId, java.lang.Long memberId)
Retrieves all the order templates for specified store and member.
The SQL query used to fetch all the required rows from the ORDERS table is: SELECT * FROM ORDERS T1 WHERE T1.STOREENT_ID = ? and T1.ORDERS_ID in (select ORDERS_ID from ORDERTMPL where MEMBER_ID = ?) |
java.util.Enumeration | findOrderTemplatesByStoreMemberAndUsage(java.lang.Integer storeId, java.lang.Long memberId, java.lang.Integer usage)
Retrieves all the order templates for specified store, member and usage.
The SQL query used to fetch all the required rows from the ORDERS table is: SELECT * FROM ORDERS T1 WHERE T1.STOREENT_ID = ? and T1.ORDERS_ID in (select ORDERS_ID from ORDERTMPL where MEMBER_ID = ? and USAGE = ?) |
OrderAccessBean | findParentOrderByOrdersId(java.lang.Long aOrdersId) findParentOrderByOrdersId |
java.util.Enumeration | findPartlyTransferredOrdersByChannelStoreIdAndShopperId(java.lang.Integer aChannelStoreId, java.lang.Long aShopperId) findPartlyTransferredOrdersByChannelStoreIdAndShopperId |
java.util.Enumeration | findPartlyTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField(java.lang.Integer storeId, java.lang.Long memberId, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField) findPartlyTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField |
java.util.Enumeration | findPendingOrders(java.lang.Long argUserReferenceNumber, java.lang.Long argMerchantReferenceNumber)
Retrieves all the pending orders for given customer and store.
The SQL query used to fetch all the required rows from the ORDERS table is: SELECT * FROM ORDERS T1 WHERE (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?) AND (T1.STATUS = 'P') |
java.util.Enumeration | findPrivateRequisitionListByMember(java.lang.Long memberId)
Retrieves all the private requisition lists for specified customer.
The SQL query used to fetch all the required rows from the ORDERS table is: SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Y') AND (T1.MEMBER_ID = ?) ORDER BY T1.LASTUPDATE |
java.util.Enumeration | findPrivateRequisitionListByMemberAndStore(java.lang.Long memberId, java.lang.Integer storeId)
Retrieves all the private requisition lists for specified customer and store.
The SQL query used to fetch all the required rows from the ORDERS table is: SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Y') AND (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?) |
java.util.Enumeration | findPrivateRequisitionListByMemberAndStoreHostedAtChannel(java.lang.Long memberId, java.lang.Integer channelStoreId) |
java.util.Enumeration | findPrivateRequisitionListByMemberOrderByLastUpdate(java.lang.Long memberId)
Retrieves all the private requisition lists for specified customer.
The SQL query used to fetch all the required rows from the ORDERS table is: SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Y') AND (T1.MEMBER_ID = ?) ORDER BY T1.LASTUPDATE |
java.util.Enumeration | findProcessedOrdersByChannelStoreIdAndShopperId(java.lang.Integer aChannelStoreId, java.lang.Long aShopperId) findProcessedOrdersByChannelStoreIdAndShopperId |
java.util.Enumeration | findProcessedOrdersByChannelStoreIdShopperIdStartEndDateAndDateField(java.lang.Integer storeId, java.lang.Long memberId, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField) findProcessedOrdersByChannelStoreIdShopperIdStartEndDateAndDateField |
java.util.Enumeration | findShareableRequisitionListByMember(java.lang.Long memberId)
Retrieves all the shareable requisition lists that can be accessed by the specified customer.
The SQL query used to fetch all the required rows from the ORDERS table is: SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Z') AND (T1.MEMBER_ID = ANY (SELECT T3.DESCENDANT_ID FROM MBRREL T2, MBRREL T3 WHERE T2.ANCESTOR_ID = T3.ANCESTOR_ID AND T2.SEQUENCE = 1 AND T3.SEQUENCE = 1 AND T2.DESCENDANT_ID = ?)) |
java.util.Enumeration | findShareableRequisitionListByMemberAndStore(java.lang.Long memberId, java.lang.Integer storeId)
Retrieves all the shareable requisition lists for given store that can be accessed by the specified customer.
The SQL query used to fetch all the required rows from the ORDERS table is: SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Z') AND (T1.MEMBER_ID = ANY (SELECT T3.DESCENDANT_ID FROM MBRREL T2, MBRREL T3 WHERE T2.ANCESTOR_ID = T3.ANCESTOR_ID AND T2.SEQUENCE = 1 AND T3.SEQUENCE = 1 AND T2.DESCENDANT_ID = ?)) AND (T1.STOREENT_ID = ?) |
java.util.Enumeration | findShareableRequisitionListByMemberAndStoreHostedAtChannel(java.lang.Long memberId, java.lang.Integer channelStoreId) |
java.util.Enumeration | findShareableRequisitionListOwnedByMember(java.lang.Long memberId)
Retrieves all the shareable requisition lists for specified customer.
The SQL query used to fetch all the required rows from the ORDERS table is: SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Z') AND (T1.MEMBER_ID = ?) |
java.util.Enumeration | findShareableRequisitionListOwnedByMemberAndStore(java.lang.Long memberId, java.lang.Integer storeId)
Retrieves all the shareable requisition lists for specified customer and store.
The SQL query used to fetch all the required rows from the ORDERS table is: SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Z') AND (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?) |
java.util.Enumeration | findShareableRequisitionListOwnedByMemberAndStoreHostedAtChannel(java.lang.Long memberId, java.lang.Integer channelStoreId) findShareableRequisitionListOwnedByMemberAndStoreHostedAtChannel |
java.util.Enumeration | findTemplatedOrdersByStoreIdMemberIdAndUsage(java.lang.Integer storeId, java.lang.Long memberId, java.lang.Integer usage, java.lang.String orderByClause, boolean forUpdate) IBM internal use only. |
java.util.Collection | findWithParameterizedPushDownQuery(java.lang.String pushDownQuery, java.lang.Object[] parameters) findWithParameterizedPushDownQuery |
java.util.Enumeration | findWithPushDownQuery(java.lang.String query) Retrieves orders identified by the specified WHERE clause. |
boolean | fulfills(java.lang.Long arg0, java.lang.String arg1) |
java.sql.Timestamp | getActualShipDate()
Retrieves the latest time any of the order items in the order have been shipped.
The SQL query used to fetch the requested data from the ORDERITEMS table is: SELECT MAX(T1.TIMESHIPPED) FROM ORDERITEMS T1 WHERE T1.ORDERS_ID=?"; |
java.lang.String | getAddressId() This method provides access to the ORDERS.ADDRESS_ID column of DB2 type BIGINT. |
java.lang.Long | getAddressIdInEJBType() This method provides access to the ORDERS.ADDRESS_ID column of DB2 type BIGINT. |
java.lang.String | getComment() getComment |
java.lang.String | getCurrency() This method provides access to the ORDERS.CURRENCY column of DB2 type CHAR(10). |
java.lang.String | getDescription() This method provides access to the ORDERS.DESCRIPTION column of DB2 type VARCHAR(254). |
java.sql.Timestamp | getEstimatedOrPromisedShipDate() Retreives the latest time any of the order items in the order are expected or promised (for placed orders) to be shipped. |
java.sql.Timestamp | getEstimatedShipDate() Retreives the latest time any of the order items in the order are expected to be shipped. |
java.lang.String | getField1() This method provides access to the ORDERS.FIELD1 column of DB2 type INTEGER. |
java.lang.Integer | getField1InEJBType() This method provides access to the ORDERS.FIELD1 column of DB2 type INTEGER. |
java.lang.String | getField2() This method provides access to the ORDERS.FIELD2 column of DB2 type DECIMAL(20 5). |
java.math.BigDecimal | getField2InEJBType() This method provides access to the ORDERS.FIELD2 column of DB2 type DECIMAL(20 5). |
java.lang.String | getField3() This method provides access to the ORDERS.FIELD3 column of DB2 type VARCHAR(254). |
java.lang.Object | getGroupingAttributeValue(java.lang.String arg0, GroupingContext arg1) This method accesses a non-CMP field |
java.lang.String | getLastUpdate() This method provides access to the ORDERS.LASTUPDATE column of DB2 type TIMESTAMP. |
java.sql.Timestamp | getLastUpdateInEJBType() This method provides access to the ORDERS.LASTUPDATE column of DB2 type TIMESTAMP. |
java.lang.String | getLock() This method provides access to the ORDERS.LOCKED column of DB2 type CHAR(1). |
java.lang.String | getMemberId() This method provides access to the ORDERS.MEMBER_ID column of DB2 type BIGINT NOT NULL. |
java.lang.Long | getMemberIdInEJBType() This method provides access to the ORDERS.MEMBER_ID column of DB2 type BIGINT NOT NULL. |
java.lang.String | getMerchantOrderId() This method provides access to the ORDERS.ORMORDER column of DB2 type CHAR(30). |
java.lang.String | getNotificationId() getNotificationId |
java.lang.Long | getNotificationIdInEJBType() getNotificationIdInEJBType |
java.lang.String | getOrderChannelTypeId() This method provides access to the ORDERS.ORDCHNLTYP_ID column of DB2 type BIGINT. |
java.lang.Long | getOrderChannelTypeIdInEJBType() This method provides access to the ORDERS.ORDCHNLTYP_ID column of DB2 type BIGINT. |
java.lang.String | getOrderId() This method provides access to the ORDERS.ORDERS_ID column of DB2 type BIGINT NOT NULL. |
java.lang.Long | getOrderIdInEJBType() This method provides access to the ORDERS.ORDERS_ID column of DB2 type BIGINT NOT NULL. |
OrderItemAccessBean[] | getOrderItems() Returns an array of OrderItemAccessBean objects representing order items in this order. |
OrderItemAccessBean[] | getOrderItemsByFulfillmentStatus(java.lang.String strFulfillmentStatus) |
OrderItemAccessBean[] | getOrderItemsByFulfillmentStatusForUpdate(java.lang.String strFulfillmentStatus) |
OrderItemAccessBean[] | getOrderItemsForUpdate() Returns an array of OrderItemAccessBean objects representing order items in this order. |
OrderItemAccessBean[] | getOrderItemsSortedByCatalogEntryId() Returns an array of OrderItemAccessBean objects sorted by order item id representing order items in this order. |
OrderItemAccessBean[] | getOrderItemsSortedByOrderItemId() Returns an array of OrderItemAccessBean objects sorted by order item id representing order items in this order. |
java.lang.String | getOrganizationId() This method provides access to the ORDERS.ORGENTITY_ID column of DB2 type BIGINT. |
java.lang.Long | getOrganizationIdInEJBType() This method provides access to the ORDERS.ORGENTITY_ID column of DB2 type BIGINT. |
java.lang.Long | getOwner() This method accesses a non-CMP field |
java.lang.String | getPlaceOrderTime() This method provides access to the ORDERS.TIMEPLACED column of DB2 type TIMESTAMP. |
java.sql.Timestamp | getPlaceOrderTimeInEJBType() This method provides access to the ORDERS.TIMEPLACED column of DB2 type TIMESTAMP. |
java.sql.Timestamp | getPromisedShipDate() Retreives the latest time that any of the order items in the order are promised to be shipped. |
java.lang.String | getProviderOrderNumber() This method provides access to the ORDERS.PROVIDERORDERNUM column of DB2 type INTEGER. |
java.lang.Integer | getProviderOrderNumberInEJBType() This method provides access to the ORDERS.PROVIDERORDERNUM column of DB2 type INTEGER. |
java.lang.String | getSequence() This method provides access to the ORDERS.SEQUENCE column of DB2 type FLOAT NOT NULL DEFAULT 0. |
java.lang.Double | getSequenceInEJBType() This method provides access to the ORDERS.SEQUENCE column of DB2 type FLOAT NOT NULL DEFAULT 0. |
java.lang.String | getShipAsComplete() This method provides access to the ORDERS.SHIPASCOMPLETE column of DB2 type CHAR(1) NOT NULL DEFAULT 'Y'. |
java.lang.String | getStatus() This method provides access to the ORDERS.STATUS column of DB2 type CHAR(1). |
java.lang.String | getStoreEntityId() This method provides access to the ORDERS.STOREENT_ID column of DB2 type INTEGER NOT NULL. |
java.lang.Integer | getStoreEntityIdInEJBType() This method provides access to the ORDERS.STOREENT_ID column of DB2 type INTEGER NOT NULL. |
SubOrderAccessBean[] | getSubOrders() Returns an array of SubOrderAccessBean objects representing suborders for this order. |
java.lang.String | getTotalAdjustment() This method provides access to the ORDERS.TOTALADJUSTMENT column of DB2 type DECIMAL(20 5) DEFAULT 0. |
java.math.BigDecimal | getTotalAdjustmentByDisplayLevel(java.lang.Integer displayLevel) IBM internal use only. |
java.math.BigDecimal | getTotalAdjustmentInEJBType() This method provides access to the ORDERS.TOTALADJUSTMENT column of DB2 type DECIMAL(20 5) DEFAULT 0. |
java.lang.String | getTotalProductPrice() This method provides access to the ORDERS.TOTALPRODUCT column of DB2 type DECIMAL(20 5) DEFAULT 0. |
java.math.BigDecimal | getTotalProductPriceInEJBType() This method provides access to the ORDERS.TOTALPRODUCT column of DB2 type DECIMAL(20 5) DEFAULT 0. |
java.lang.String | getTotalShippingCharge() This method provides access to the ORDERS.TOTALSHIPPING column of DB2 type DECIMAL(20 5) DEFAULT 0. |
java.math.BigDecimal | getTotalShippingChargeInEJBType() This method provides access to the ORDERS.TOTALSHIPPING column of DB2 type DECIMAL(20 5) DEFAULT 0. |
java.lang.String | getTotalShippingTax() This method provides access to the ORDERS.TOTALTAXSHIPPING column of DB2 type DECIMAL(20 5) DEFAULT 0. |
java.math.BigDecimal | getTotalShippingTaxInEJBType() This method provides access to the ORDERS.TOTALTAXSHIPPING column of DB2 type DECIMAL(20 5) DEFAULT 0. |
java.lang.String | getTotalTax() This method provides access to the ORDERS.TOTALTAX column of DB2 type DECIMAL(20 5) DEFAULT 0. |
java.math.BigDecimal | getTotalTaxInEJBType() This method provides access to the ORDERS.TOTALTAX column of DB2 type DECIMAL(20 5) DEFAULT 0. |
protected void | instantiateEJB() |
protected boolean | instantiateEJBByPrimaryKey() |
void | refreshCopyHelper() Load data from the EJBObject. |
void | setAddressId(java.lang.Long newValue) This method accesses a non-CMP field |
void | setAddressId(java.lang.String newValue) This method accesses a non-CMP field |
void | setComment(java.lang.String newValue) This method accesses a non-CMP field |
void | setCurrency(java.lang.String newValue) This method accesses a non-CMP field |
void | setDescription(java.lang.String newValue) This method accesses a non-CMP field |
void | setField1(java.lang.Integer newValue) This method accesses a non-CMP field |
void | setField1(java.lang.String newValue) This method accesses a non-CMP field |
void | setField2(java.math.BigDecimal newValue) This method accesses a non-CMP field |
void | setField2(java.lang.String newValue) This method accesses a non-CMP field |
void | setField3(java.lang.String newValue) This method accesses a non-CMP field |
void | setInitKey_orderId(java.lang.String newValue) Set the primary key for this object |
void | setLastUpdate(java.lang.String newValue) This method accesses a non-CMP field |
void | setLastUpdate(java.sql.Timestamp newValue) This method accesses a non-CMP field |
void | setLastUpdateWithoutCheck(java.sql.Timestamp argLastUpdate) The time this Order was most recently updated without checking whether the previous update time. |
void | setLock(java.lang.String newValue) This method accesses a non-CMP field |
void | setMemberId(java.lang.Long newValue) This method accesses a non-CMP field |
void | setMemberId(java.lang.String newValue) This method accesses a non-CMP field |
void | setMerchantOrderId(java.lang.String newValue) This method accesses a non-CMP field |
void | setNotificationId(java.lang.Long newValue) This method accesses a non-CMP field |
void | setNotificationId(java.lang.String newValue) This method accesses a non-CMP field |
void | setOrderChannelTypeId(java.lang.Long newValue) This method accesses a non-CMP field |
void | setOrderChannelTypeId(java.lang.String newValue) This method accesses a non-CMP field |
void | setOrganizationId(java.lang.Long newValue) This method accesses a non-CMP field |
void | setOrganizationId(java.lang.String newValue) This method accesses a non-CMP field |
void | setPlaceOrderTime(java.lang.String newValue) This method accesses a non-CMP field |
void | setPlaceOrderTime(java.sql.Timestamp newValue) This method accesses a non-CMP field |
void | setProviderOrderNumber(java.lang.Integer newValue) This method accesses a non-CMP field |
void | setProviderOrderNumber(java.lang.String newValue) This method accesses a non-CMP field |
void | setSequence(java.lang.Double newValue) This method accesses a non-CMP field |
void | setSequence(java.lang.String newValue) This method accesses a non-CMP field |
void | setShipAsComplete(java.lang.String newValue) This method accesses a non-CMP field |
void | setStatus(java.lang.String newValue) This method accesses a non-CMP field |
void | setStoreEntityId(java.lang.Integer newValue) This method accesses a non-CMP field |
void | setStoreEntityId(java.lang.String newValue) This method accesses a non-CMP field |
void | setTotalAdjustment(java.math.BigDecimal newValue) This method accesses a non-CMP field |
void | setTotalAdjustment(java.lang.String newValue) This method accesses a non-CMP field |
void | setTotalProductPrice(java.math.BigDecimal newValue) This method accesses a non-CMP field |
void | setTotalProductPrice(java.lang.String newValue) This method accesses a non-CMP field |
void | setTotalShippingCharge(java.math.BigDecimal newValue) This method accesses a non-CMP field |
void | setTotalShippingCharge(java.lang.String newValue) This method accesses a non-CMP field |
void | setTotalShippingTax(java.math.BigDecimal newValue) This method accesses a non-CMP field |
void | setTotalShippingTax(java.lang.String newValue) This method accesses a non-CMP field |
void | setTotalTax(java.math.BigDecimal newValue) This method accesses a non-CMP field |
void | setTotalTax(java.lang.String newValue) This method accesses a non-CMP field |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
public OrderAccessBean()
public OrderAccessBean(javax.ejb.EJBObject o) throws java.rmi.RemoteException
public OrderAccessBean(java.lang.Long arg1, java.lang.Integer arg2, java.lang.Double arg3, java.math.BigDecimal arg4, java.sql.Timestamp arg5) throws javax.naming.NamingException, javax.ejb.CreateException, javax.ejb.FinderException, java.rmi.RemoteException
Maps to a corresponding ejbCreate method in the home interface of the EJB
public OrderAccessBean(java.lang.Long arg1, java.lang.Integer arg2, java.lang.Double arg3, java.sql.Timestamp arg4) throws javax.naming.NamingException, javax.ejb.CreateException, javax.ejb.FinderException, java.rmi.RemoteException
Maps to a corresponding ejbCreate method in the home interface of the EJB
public OrderAccessBean(java.lang.Long arg1, java.lang.Integer arg2, java.sql.Timestamp arg3) throws javax.naming.NamingException, javax.ejb.CreateException, javax.ejb.FinderException, java.rmi.RemoteException
Maps to a corresponding ejbCreate method in the home interface of the EJB
Method Detail |
public OrderAccessBean findByOrderForUpdate(java.lang.Long orderId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves OrderAccessBean representing the order with specified order identifier.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.ORDERS_ID = ? for update
public java.util.Enumeration findByMemberForUpdate(java.lang.Long memberId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the orders for given customer.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.MEMBER_ID = ? for update
public java.util.Enumeration findByStatus(java.lang.String argStatus) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the orders with specified status.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = ?)
public java.util.Enumeration findByStatusAndMember(java.lang.String argStatus, java.lang.Long argMemberId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the orders for specified status and member.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = ?) AND (T1.MEMBER_ID = ?) ORDER BY T1.ORDERS_ID
public java.util.Enumeration findByStatusMemberAndStore(java.lang.String argStatus, java.lang.Long argMemberId, java.lang.Integer argStoreId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the orders for specified status, member and store.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = ?) AND (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?) ORDER BY T1.ORDERS_ID
public java.util.Enumeration findByStatusMemberAndStoreForUpdate(java.lang.String status, java.lang.Long memberId, java.lang.Integer storeId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the orders for specified status, member and store.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = ?) AND (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?) ORDER BY T1.ORDERS_ID for update
public java.util.Enumeration findByStoreIdMemberIdAndStatus(java.lang.Integer storeId, java.lang.Long memberId, java.lang.String status, java.lang.String orderByClause, boolean forUpdate) throws javax.ejb.FinderException, java.rmi.RemoteException, javax.naming.NamingException
IBM internal use only.
public java.util.Enumeration findCurrentPendingOrders() throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the current pending orders.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'P') AND T1.ORDERS_ID IN (SELECT ORDERS_ID FROM CPENDORDER) ORDER BY T1.LASTUPDATE
public java.util.Enumeration findCurrentPendingOrdersByMember(java.lang.Long argMemberId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the current pending orders for specified customer.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'P') AND T1.ORDERS_ID IN (SELECT ORDERS_ID FROM CPENDORDER) ORDER BY T1.LASTUPDATE
public java.util.Enumeration findCurrentPendingOrdersByMemberAndStore(java.lang.Long argMemberId, java.lang.Integer argStoreId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the current pending orders for specified customer and store.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'P') AND (T1.ORDERS_ID IN (SELECT ORDERS_ID FROM CPENDORDER WHERE MEMBER_ID = ?)) AND (STOREENT_ID = ?) ORDER BY T1.LASTUPDATE
public java.util.Enumeration findOrderTemplatesByMember(java.lang.Long memberId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the order templates for specified member.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.ORDERS_ID in (select ORDERS_ID from ORDERTMPL where MEMBER_ID = ?)
public java.util.Enumeration findOrderTemplatesByMemberAndUsage(java.lang.Long memberId, java.lang.Integer usage) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the order templates for specified member and usage.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.ORDERS_ID in (select ORDERS_ID from ORDERTMPL where MEMBER_ID = ? and USAGE = ?)
public java.util.Enumeration findOrderTemplatesByStoreAndMember(java.lang.Integer storeId, java.lang.Long memberId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the order templates for specified store and member.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.STOREENT_ID = ? and T1.ORDERS_ID in (select ORDERS_ID from ORDERTMPL where MEMBER_ID = ?)
public java.util.Enumeration findOrderTemplatesByStoreMemberAndUsage(java.lang.Integer storeId, java.lang.Long memberId, java.lang.Integer usage) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the order templates for specified store, member and usage.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.STOREENT_ID = ? and T1.ORDERS_ID in (select ORDERS_ID from ORDERTMPL where MEMBER_ID = ? and USAGE = ?)
public java.util.Enumeration findPendingOrders(java.lang.Long argUserReferenceNumber, java.lang.Long argMerchantReferenceNumber) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the pending orders for given customer and store.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?) AND (T1.STATUS = 'P')
public java.util.Enumeration findPrivateRequisitionListByMember(java.lang.Long memberId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the private requisition lists for specified customer.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Y') AND (T1.MEMBER_ID = ?) ORDER BY T1.LASTUPDATE
public java.util.Enumeration findPrivateRequisitionListByMemberAndStore(java.lang.Long memberId, java.lang.Integer storeId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the private requisition lists for specified customer and store.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Y') AND (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?)
public java.util.Enumeration findPrivateRequisitionListByMemberOrderByLastUpdate(java.lang.Long memberId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the private requisition lists for specified customer.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Y') AND (T1.MEMBER_ID = ?) ORDER BY T1.LASTUPDATE
public java.util.Enumeration findShareableRequisitionListByMember(java.lang.Long memberId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the shareable requisition lists that can be accessed by the specified customer.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Z') AND (T1.MEMBER_ID = ANY (SELECT T3.DESCENDANT_ID FROM MBRREL T2, MBRREL T3 WHERE T2.ANCESTOR_ID = T3.ANCESTOR_ID AND T2.SEQUENCE = 1 AND T3.SEQUENCE = 1 AND T2.DESCENDANT_ID = ?))
public java.util.Enumeration findShareableRequisitionListByMemberAndStore(java.lang.Long memberId, java.lang.Integer storeId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the shareable requisition lists for given store that can be accessed by the specified customer.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Z') AND (T1.MEMBER_ID = ANY (SELECT T3.DESCENDANT_ID FROM MBRREL T2, MBRREL T3 WHERE T2.ANCESTOR_ID = T3.ANCESTOR_ID AND T2.SEQUENCE = 1 AND T3.SEQUENCE = 1 AND T2.DESCENDANT_ID = ?)) AND (T1.STOREENT_ID = ?)
public java.util.Enumeration findShareableRequisitionListOwnedByMember(java.lang.Long memberId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the shareable requisition lists for specified customer.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Z') AND (T1.MEMBER_ID = ?)
public java.util.Enumeration findShareableRequisitionListOwnedByMemberAndStore(java.lang.Long memberId, java.lang.Integer storeId) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves all the shareable requisition lists for specified customer and store.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Z') AND (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?)
public java.util.Enumeration findTemplatedOrdersByStoreIdMemberIdAndUsage(java.lang.Integer storeId, java.lang.Long memberId, java.lang.Integer usage, java.lang.String orderByClause, boolean forUpdate) throws javax.ejb.FinderException, java.rmi.RemoteException, javax.naming.NamingException
IBM internal use only.
public java.util.Enumeration findWithPushDownQuery(java.lang.String query) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Retrieves orders identified by the specified WHERE clause.
public void setInitKey_orderId(java.lang.String newValue)
Set the primary key for this object
protected java.lang.String defaultJNDIName()
protected void instantiateEJB() throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
protected boolean instantiateEJBByPrimaryKey() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.naming.NamingException
public void commitCopyHelper() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
Update(flush) data to the EJBObject (persistent storage).
public void refreshCopyHelper() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
Load data from the EJBObject.
public java.lang.String getDescription() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.DESCRIPTION column of DB2 type VARCHAR(254).
The following is a description of this column:
A mnemonic description of the order, entered by the customer, suitable for display to the customer.
public void setDescription(java.lang.String newValue)
public java.lang.String getLastUpdate() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.LASTUPDATE column of DB2 type TIMESTAMP.
The following is a description of this column:
The time this order was most recently updated.
public java.sql.Timestamp getLastUpdateInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.LASTUPDATE column of DB2 type TIMESTAMP.
The following is a description of this column:
The time this order was most recently updated.
public void setLastUpdate(java.lang.String newValue)
public void setLastUpdate(java.sql.Timestamp newValue)
public java.lang.String getPlaceOrderTime() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.TIMEPLACED column of DB2 type TIMESTAMP.
The following is a description of this column:
The time this order was processed by the OrderProcess command.
public java.sql.Timestamp getPlaceOrderTimeInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.TIMEPLACED column of DB2 type TIMESTAMP.
The following is a description of this column:
The time this order was processed by the OrderProcess command.
public void setPlaceOrderTime(java.lang.String newValue)
public void setPlaceOrderTime(java.sql.Timestamp newValue)
public java.lang.String getTotalShippingTax() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.TOTALTAXSHIPPING column of DB2 type DECIMAL(20 5) DEFAULT 0.
The following is a description of this column:
The sum of ORDERITEMS.SHIPTAXAMOUNT for the OrderItems in the Order.
public java.math.BigDecimal getTotalShippingTaxInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.TOTALTAXSHIPPING column of DB2 type DECIMAL(20 5) DEFAULT 0.
The following is a description of this column:
The sum of ORDERITEMS.SHIPTAXAMOUNT for the OrderItems in the Order.
public void setTotalShippingTax(java.lang.String newValue)
public void setTotalShippingTax(java.math.BigDecimal newValue)
public java.lang.String getCurrency() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.CURRENCY column of DB2 type CHAR(10).
The following is a description of this column:
The currency for monetary amounts associated with this order. This is the currency code according to ISO 4217 standards.
public void setCurrency(java.lang.String newValue)
public java.lang.String getField3() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.FIELD3 column of DB2 type VARCHAR(254).
The following is a description of this column:
Customizable.
public void setField3(java.lang.String newValue)
public java.lang.String getField2() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.FIELD2 column of DB2 type DECIMAL(20 5).
The following is a description of this column:
Customizable.
public java.math.BigDecimal getField2InEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.FIELD2 column of DB2 type DECIMAL(20 5).
The following is a description of this column:
Customizable.
public void setField2(java.lang.String newValue)
public void setField2(java.math.BigDecimal newValue)
public java.lang.String getField1() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.FIELD1 column of DB2 type INTEGER.
The following is a description of this column:
Customizable.
public java.lang.Integer getField1InEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.FIELD1 column of DB2 type INTEGER.
The following is a description of this column:
Customizable.
public void setField1(java.lang.String newValue)
public void setField1(java.lang.Integer newValue)
public java.lang.String getShipAsComplete() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.SHIPASCOMPLETE column of DB2 type CHAR(1) NOT NULL DEFAULT 'Y'.
The following is a description of this column:
Reserved for IBM internal use.
public void setShipAsComplete(java.lang.String newValue)
public java.lang.String getTotalShippingCharge() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.TOTALSHIPPING column of DB2 type DECIMAL(20 5) DEFAULT 0.
The following is a description of this column:
The sum of ORDERITEMS.SHIPCHARGE for the OrderItems in the Order. This quantity should be the result of (ORDERS.BASETOTALSHIPPING - ORDERS.TOTALSHIPADJUST). It is the adjusted amount acually charged to the customer.
public java.math.BigDecimal getTotalShippingChargeInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.TOTALSHIPPING column of DB2 type DECIMAL(20 5) DEFAULT 0.
The following is a description of this column:
The sum of ORDERITEMS.SHIPCHARGE for the OrderItems in the Order. This quantity should be the result of (ORDERS.BASETOTALSHIPPING - ORDERS.TOTALSHIPADJUST). It is the adjusted amount acually charged to the customer.
public void setTotalShippingCharge(java.lang.String newValue)
public void setTotalShippingCharge(java.math.BigDecimal newValue)
public java.lang.String getOrganizationId() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.ORGENTITY_ID column of DB2 type BIGINT.
The following is a description of this column:
The immediate parent organization ID of the creator.
public java.lang.Long getOrganizationIdInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.ORGENTITY_ID column of DB2 type BIGINT.
The following is a description of this column:
The immediate parent organization ID of the creator.
public void setOrganizationId(java.lang.String newValue)
public void setOrganizationId(java.lang.Long newValue)
public java.lang.String getStatus() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.STATUS column of DB2 type CHAR(1).
The following is a description of this column:
The status of a standard order.
public void setStatus(java.lang.String newValue)
public java.lang.String getProviderOrderNumber() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.PROVIDERORDERNUM column of DB2 type INTEGER.
The following is a description of this column:
Reserved for IBM internal use.
public java.lang.Integer getProviderOrderNumberInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.PROVIDERORDERNUM column of DB2 type INTEGER.
The following is a description of this column:
Reserved for IBM internal use.
public void setProviderOrderNumber(java.lang.String newValue)
public void setProviderOrderNumber(java.lang.Integer newValue)
public java.lang.String getLock() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.LOCKED column of DB2 type CHAR(1).
The following is a description of this column:
Reserved for IBM internal use.
public void setLock(java.lang.String newValue)
public java.lang.String getOrderId() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.ORDERS_ID column of DB2 type BIGINT NOT NULL.
The following is a description of this column:
Generated unique key.
public java.lang.Long getOrderIdInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.ORDERS_ID column of DB2 type BIGINT NOT NULL.
The following is a description of this column:
Generated unique key.
public java.lang.String getStoreEntityId() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.STOREENT_ID column of DB2 type INTEGER NOT NULL.
The following is a description of this column:
The store entity the order is part of. This is normally a store unless STATUS is Q, in which case it is normally a store group.
public java.lang.Integer getStoreEntityIdInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.STOREENT_ID column of DB2 type INTEGER NOT NULL.
The following is a description of this column:
The store entity the order is part of. This is normally a store unless STATUS is Q, in which case it is normally a store group.
public void setStoreEntityId(java.lang.String newValue)
public void setStoreEntityId(java.lang.Integer newValue)
public java.lang.String getMemberId() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.MEMBER_ID column of DB2 type BIGINT NOT NULL.
The following is a description of this column:
The customer that placed the order.
public java.lang.Long getMemberIdInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.MEMBER_ID column of DB2 type BIGINT NOT NULL.
The following is a description of this column:
The customer that placed the order.
public void setMemberId(java.lang.String newValue)
public void setMemberId(java.lang.Long newValue)
public java.lang.String getTotalProductPrice() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.TOTALPRODUCT column of DB2 type DECIMAL(20 5) DEFAULT 0.
The following is a description of this column:
The sum of ORDERITEMS.TOTALPRODUCT for the OrderItems in the Order.
public java.math.BigDecimal getTotalProductPriceInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.TOTALPRODUCT column of DB2 type DECIMAL(20 5) DEFAULT 0.
The following is a description of this column:
The sum of ORDERITEMS.TOTALPRODUCT for the OrderItems in the Order.
public void setTotalProductPrice(java.lang.String newValue)
public void setTotalProductPrice(java.math.BigDecimal newValue)
public java.lang.String getTotalTax() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.TOTALTAX column of DB2 type DECIMAL(20 5) DEFAULT 0.
The following is a description of this column:
The sum of ORDERITEMS.TAXAMOUNT for the OrderItems in the Order.
public java.math.BigDecimal getTotalTaxInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.TOTALTAX column of DB2 type DECIMAL(20 5) DEFAULT 0.
The following is a description of this column:
The sum of ORDERITEMS.TAXAMOUNT for the OrderItems in the Order.
public void setTotalTax(java.lang.String newValue)
public void setTotalTax(java.math.BigDecimal newValue)
public java.lang.String getMerchantOrderId() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.ORMORDER column of DB2 type CHAR(30).
The following is a description of this column:
A merchant-assigned order reference number, if any.
public void setMerchantOrderId(java.lang.String newValue)
public java.lang.String getSequence() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.SEQUENCE column of DB2 type FLOAT NOT NULL DEFAULT 0.
The following is a description of this column:
Can be used by a user interface to control the sequence of orders in a list.
public java.lang.Double getSequenceInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.SEQUENCE column of DB2 type FLOAT NOT NULL DEFAULT 0.
The following is a description of this column:
Can be used by a user interface to control the sequence of orders in a list.
public void setSequence(java.lang.String newValue)
public void setSequence(java.lang.Double newValue)
public java.lang.String getAddressId() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.ADDRESS_ID column of DB2 type BIGINT.
The following is a description of this column:
The billing address, if known.
public java.lang.Long getAddressIdInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.ADDRESS_ID column of DB2 type BIGINT.
The following is a description of this column:
The billing address, if known.
public void setAddressId(java.lang.String newValue)
public void setAddressId(java.lang.Long newValue)
public java.lang.String getOrderChannelTypeId() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.ORDCHNLTYP_ID column of DB2 type BIGINT.
The following is a description of this column:
Reserved for IBM internal use.
public java.lang.Long getOrderChannelTypeIdInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.ORDCHNLTYP_ID column of DB2 type BIGINT.
The following is a description of this column:
Reserved for IBM internal use.
public void setOrderChannelTypeId(java.lang.String newValue)
public void setOrderChannelTypeId(java.lang.Long newValue)
public java.lang.String getTotalAdjustment() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.TOTALADJUSTMENT column of DB2 type DECIMAL(20 5) DEFAULT 0.
The following is a description of this column:
The sum of ORDERITEMS.TOTALADJUSTMENT for the order items in the order.
public java.math.BigDecimal getTotalAdjustmentInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
This method provides access to the ORDERS.TOTALADJUSTMENT column of DB2 type DECIMAL(20 5) DEFAULT 0.
The following is a description of this column:
The sum of ORDERITEMS.TOTALADJUSTMENT for the order items in the order.
public void setTotalAdjustment(java.lang.String newValue)
public void setTotalAdjustment(java.math.BigDecimal newValue)
public boolean fulfills(java.lang.Long arg0, java.lang.String arg1) throws java.rmi.RemoteException, java.lang.Exception, javax.ejb.FinderException, javax.naming.NamingException
public OrderItemAccessBean[] getOrderItems() throws javax.naming.NamingException, java.rmi.RemoteException, javax.ejb.FinderException
Returns an array of OrderItemAccessBean objects representing order items in this order.
The SQL query used to fetch all the required rows from the ORDERITEMS table is:
SELECT * FROM ORDERITEMS T1 WHERE (T1.ORDERS_ID = ?) order by T1.ADDRESS_ID, T1.ORDERITEMS_ID
public OrderItemAccessBean[] getOrderItemsForUpdate() throws javax.naming.NamingException, java.rmi.RemoteException, javax.ejb.FinderException
Returns an array of OrderItemAccessBean objects representing order items in this order.
The SQL query used to fetch all the required rows from the ORDERITEMS table is:
SELECT * FROM ORDERITEMS T1 WHERE T1.ORDERS_ID = ? for update
public OrderItemAccessBean[] getOrderItemsSortedByOrderItemId() throws javax.naming.NamingException, java.rmi.RemoteException, javax.ejb.FinderException
Returns an array of OrderItemAccessBean objects sorted by order item id representing order items in this order.
The SQL query used to fetch all the required rows from the ORDERITEMS table is:
SELECT * FROM ORDERITEMS T1 WHERE (T1.ORDERS_ID = ?) order by T1.ORDERITEMS_ID
public SubOrderAccessBean[] getSubOrders() throws javax.naming.NamingException, java.rmi.RemoteException, javax.ejb.FinderException
Returns an array of SubOrderAccessBean objects representing suborders for this order.
public java.lang.Long getOwner() throws java.lang.Exception, java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.Object getGroupingAttributeValue(java.lang.String arg0, GroupingContext arg1) throws java.lang.Exception, java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
public java.math.BigDecimal getTotalAdjustmentByDisplayLevel(java.lang.Integer displayLevel) throws javax.naming.NamingException, javax.ejb.CreateException, java.sql.SQLException, java.rmi.RemoteException, javax.ejb.FinderException
IBM internal use only.
public java.sql.Timestamp getActualShipDate() throws javax.naming.NamingException, javax.ejb.CreateException, java.sql.SQLException, java.rmi.RemoteException, javax.ejb.FinderException
Retrieves the latest time any of the order items in the order have been shipped.
The SQL query used to fetch the requested data from the ORDERITEMS table is:
SELECT MAX(T1.TIMESHIPPED) FROM ORDERITEMS T1 WHERE T1.ORDERS_ID=?";
public java.sql.Timestamp getEstimatedOrPromisedShipDate() throws javax.naming.NamingException, javax.ejb.CreateException, java.sql.SQLException, java.rmi.RemoteException, javax.ejb.FinderException
Retreives the latest time any of the order items in the order are expected or promised (for placed orders) to be shipped.
public java.sql.Timestamp getEstimatedShipDate() throws javax.naming.NamingException, javax.ejb.CreateException, java.sql.SQLException, java.rmi.RemoteException, javax.ejb.FinderException
Retreives the latest time any of the order items in the order are expected to be shipped.
public java.sql.Timestamp getPromisedShipDate() throws javax.naming.NamingException, javax.ejb.CreateException, java.sql.SQLException, java.rmi.RemoteException, javax.ejb.FinderException
Retreives the latest time that any of the order items in the order are promised to be shipped.
public void clearOrderItemsCache() throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.String getComment() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setComment(java.lang.String newValue)
public OrderAccessBean findParentOrderByOrdersId(java.lang.Long aOrdersId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public OrderItemAccessBean[] getOrderItemsByFulfillmentStatus(java.lang.String strFulfillmentStatus) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public OrderItemAccessBean[] getOrderItemsByFulfillmentStatusForUpdate(java.lang.String strFulfillmentStatus) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findNotTransferredOrdersByChannelStoreIdAndShopperId(java.lang.Integer aChannelStoreId, java.lang.Long aShopperId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findProcessedOrdersByChannelStoreIdAndShopperId(java.lang.Integer aChannelStoreId, java.lang.Long aShopperId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findFullyTransferredOrdersByChannelStoreIdAndShopperId(java.lang.Integer aChannelStoreId, java.lang.Long aShopperId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findPartlyTransferredOrdersByChannelStoreIdAndShopperId(java.lang.Integer aChannelStoreId, java.lang.Long aShopperId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByStatusMemberRelTypeAndStore(java.lang.String istrOrderStatus, java.lang.Long inUserId, java.lang.String istrRelType, java.lang.Integer inStoreId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByStatusMemberAndRelType(java.lang.String istrOrderStatus, java.lang.Long inUserId, java.lang.String istrRelType) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByOrderIds(java.lang.Long[] anOrderIds) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findChildOrderByDistributorStoreIdsAndOrdersIdAndRelType(java.lang.Integer[] aDistributorStoreIds, java.lang.Long aOrdersId, java.lang.String aRelType) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByStatusMemberAndRelTypeScopedByTimePlaced(java.lang.String istrOrderStatus, java.lang.Long inUserId, java.lang.String istrRelType, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByStatusMemberAndStoreScopedByLastUpdate(java.lang.String argStatus, java.lang.Long argMemberId, java.lang.Integer argStoreId, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByStatusMemberRelTypeAndStoreScopedByLastUpdate(java.lang.String istrOrderStatus, java.lang.Long inUserId, java.lang.String istrRelType, java.lang.Integer inStoreId, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByStatusMemberAndRelTypeScopedByLastUpdate(java.lang.String istrOrderStatus, java.lang.Long inUserId, java.lang.String istrRelType, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByStatusAndMemberScopedByLastUpdate(java.lang.String argStatus, java.lang.Long argMemberId, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByStatusMemberAndStoreScopedByTimePlaced(java.lang.String argStatus, java.lang.Long argMemberId, java.lang.Integer argStoreId, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByStatusMemberRelTypeAndStoreScopedByTimePlaced(java.lang.String istrOrderStatus, java.lang.Long inUserId, java.lang.String istrRelType, java.lang.Integer inStoreId, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByStatusAndMemberScopedByTimePlaced(java.lang.String argStatus, java.lang.Long argMemberId, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByStatusesMemberStoresRelTypeStartEndDateAndDateField(java.lang.String[] aStatusList, java.lang.Long aMemberId, java.lang.Integer[] aStoreIdList, java.lang.String aRelType, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByStatusesMemberStoresStartEndDateAndDateField(java.lang.String[] aStatusList, java.lang.Long aMemberId, java.lang.Integer[] aStoreIdList, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findPartlyTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField(java.lang.Integer storeId, java.lang.Long memberId, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findFullyTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField(java.lang.Integer storeId, java.lang.Long memberId, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findNotTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField(java.lang.Integer storeId, java.lang.Long memberId, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findProcessedOrdersByChannelStoreIdShopperIdStartEndDateAndDateField(java.lang.Integer storeId, java.lang.Long memberId, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findShareableRequisitionListOwnedByMemberAndStoreHostedAtChannel(java.lang.Long memberId, java.lang.Integer channelStoreId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findShareableRequisitionListByMemberAndStoreHostedAtChannel(java.lang.Long memberId, java.lang.Integer channelStoreId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findPrivateRequisitionListByMemberAndStoreHostedAtChannel(java.lang.Long memberId, java.lang.Integer channelStoreId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByStatusMemberAndStoreHostedAtChannel(java.lang.String argStatus, java.lang.Long argMemberId, java.lang.Integer argStoreId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.lang.String getNotificationId() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setNotificationId(java.lang.Long newValue)
public java.lang.Long getNotificationIdInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setNotificationId(java.lang.String newValue)
public void setLastUpdateWithoutCheck(java.sql.Timestamp argLastUpdate)
public java.util.Enumeration findByStatusStoreentIdAndDescription(java.lang.String status, java.lang.Integer storeentId, java.lang.String description) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Collection findWithParameterizedPushDownQuery(java.lang.String pushDownQuery, java.lang.Object[] parameters) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByStatusesMemberStoreHostedAtChannelStartEndDateAndDateField(java.lang.String[] aStatusList, java.lang.Long aMemberId, java.lang.Integer aChannelStoreId, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public OrderItemAccessBean[] getOrderItemsSortedByCatalogEntryId() throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
Returns an array of OrderItemAccessBean objects sorted by order item id representing order items in this order.
The SQL query used to fetch all the required rows from the ORDERITEMS table is:
SELECT * FROM ORDERITEMS T1 WHERE (T1.ORDERS_ID = ?) order by T1.CATENTRY_ID
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.