read-ahead left-join problem

I added a left-join entry in jbosscmp-jdbc.xml file for a jboss query. The generated query is correct, but the data for the bean corresponding to the CMR field defined in read-ahead/left-join are loaded from database, not from read ahead cache.

First, the correct left-join SQL statement is pushed and shown on the server.
Then, the standard behaviour of lazy-loading from the database follows immediatly whenever you access an entities' bean local object.

This is a strange behaviour.

Corresponding fragment in jbosscmp-jdbc.xml is:
<query>
<query-method>
<method-name>findOfferProposalByContractIDAndOfferType</method-name>
<method-params>
<method-param>java.lang.String</method-param>
<method-param>int</method-param>
<method-param>java.lang.Integer</method-param>
</method-params>
</query-method>
<jboss-ql><![CDATA[SELECT OBJECT(a) FROM OfferProposalEntityBean AS a WHERE a.domain = ?1 AND a.contractNo = ?2 AND a.offerTypeEntity.iD = ?3]]></jboss-ql>
<read-ahead>
<strategy>on-find</strategy>
<eager-load-group>*</eager-load-group>
<left-join cmr-field="offerProposalItems" eager-load-group="*">
<left-join cmr-field="offerProposalItemCriteria" eager-load-group="*"/>
<left-join cmr-field="process" eager-load-group="*">
<left-join cmr-field="processType" eager-load-group="*"/>
</left-join>
<left-join cmr-field="offerProposalMappingItems" eager-load-group="*">
<left-join cmr-field="offerProductOptionMapping" eager-load-group="*">
<left-join cmr-field="offerProduct" eager-load-group="*">
<left-join cmr-field="offerProductTypeEntity" eager-load-group="*"/>
</left-join>
<left-join cmr-field="offerOption" eager-load-group="*"/>
</left-join>
</left-join>
</left-join>
<left-join cmr-field="offerProposalCriteria" eager-load-group="*"/>
<left-join cmr-field="offerChannelEntity" eager-load-group="*"/>
<left-join cmr-field="offerTypeGroupEntity" eager-load-group="*"/>
<left-join cmr-field="offerTypeEntity" eager-load-group="*"/>
</read-ahead>

</query>

Generated query (is correct):
13:54:44,087 DEBUG OfferProposalEntityBean#findOfferProposalByContractID Executing SQL: SELECT t0_a.ID, t0_a.DOMAIN, t
0_a.CONTRACT_NO, t0_a.PARTY_NO, t0_a.OFFER_PERIOD, t0_a.VALID_FROM, t0_a.VALID_TO, t0_a.PROPOSAL_PERMISSION, t0_a.OFFER_
CHANNEL_ID, t0_a.OFFER_TYPE_GROUP_ID, t0_a.OFFER_TYPE_ID, t1_a_offerProposalItems.ID, t1_a_offerProposalItems.PROPOSAL_I
D, t1_a_offerProposalItems.POSITION, t1_a_offerProposalItems.RANK_AFFINITY, t1_a_offerProposalItems.RANK_MARGIN, t1_a_of
ferProposalItems.RANK_PRIORITY, t1_a_offerProposalItems.PROCESS_ID, t2_a_offerProposalItems_offerP.ID, t2_a_offerProposa
lItems_offerP.CRITERIA_VALUE, t2_a_offerProposalItems_offerP.CRITERIA_TYPE_ID, t2_a_offerProposalItems_offerP.PROPOSAL_I
TEM_ID, t3_a_offerProposalItems_proces.ID, t3_a_offerProposalItems_proces.PROCESS_LABEL, t3_a_offerProposalItems_proces.
PROCESS_DESCRIPTION, t3_a_offerProposalItems_proces.PROCESS_TYPE_ID, t4_a_offerProposalItems_proces.ID, t4_a_offerPropos
alItems_proces.SHORTCUT, t4_a_offerProposalItems_proces.LABEL, t4_a_offerProposalItems_proces.DESCRIPTION, t5_a_offerPro
posalItems_offerP.ID, t5_a_offerProposalItems_offerP.PROPOSAL_ITEM_ID, t5_a_offerProposalItems_offerP.PRODUCT_MAPPING_ID
, t6_a_offerProposalItems_offerP.ID, t6_a_offerProposalItems_offerP.OPTIONAL, t6_a_offerProposalItems_offerP.SELECTED, t
6_a_offerProposalItems_offerP.PRODUCT_ID, t6_a_offerProposalItems_offerP.OPTION_ID, t7_a_offerProposalItems_offerP.ID, t
7_a_offerProposalItems_offerP.PRODUCT_VARIANT_ID, t7_a_offerProposalItems_offerP.PRODUCT_EXTERNAL_REFERENCE, t7_a_offerP
roposalItems_offerP.PRODUCT_LABEL, t7_a_offerProposalItems_offerP.PRODUCT_PROVIDER, t7_a_offerProposalItems_offerP.PRODU
CT_DESCRIPTION, t7_a_offerProposalItems_offerP.PRODUCT_TYPE_ID, t8_a_offerProposalItems_offerP.ID, t8_a_offerProposalIte
ms_offerP.SHORTCUT, t8_a_offerProposalItems_offerP.LABEL, t8_a_offerProposalItems_offerP.DESCRIPTION, t9_a_offerProposal
Items_offerP.ID, t9_a_offerProposalItems_offerP.OPTION_NUMBER, t9_a_offerProposalItems_offerP.OPTION_EXTERNAL_REFERENCE,
t9_a_offerProposalItems_offerP.OPTION_LABEL, t10_a_offerProposalCriteria.ID, t10_a_offerProposalCriteria.CRITERIA_VALUE
, t10_a_offerProposalCriteria.PROPOSAL_ID, t10_a_offerProposalCriteria.CRITERIA_TYPE_ID, t11_a_offerChannelEntity.ID, t1
1_a_offerChannelEntity.SHORTCUT, t12_a_offerTypeGroupEntity.ID, t12_a_offerTypeGroupEntity.SHORTCUT, t13_a_offerTypeEnti
ty.ID, t13_a_offerTypeEntity.SHORTCUT FROM OFFER_PROPOSAL t0_a LEFT OUTER JOIN OFFER_PROPOSAL_ITEM t1_a_offerProposalIte
ms ON t0_a.ID=t1_a_offerProposalItems.PROPOSAL_ID LEFT OUTER JOIN OFFER_PROPOSAL_ITEM_CRITERIA t2_a_offerProposalItems_o
fferP ON t1_a_offerProposalItems.ID=t2_a_offerProposalItems_offerP.PROPOSAL_ITEM_ID LEFT OUTER JOIN OFFER_PROCESS t3_a_o
fferProposalItems_proces ON t1_a_offerProposalItems.PROCESS_ID=t3_a_offerProposalItems_proces.ID LEFT OUTER JOIN OFFER_P
ROCESS_TYPE t4_a_offerProposalItems_proces ON t3_a_offerProposalItems_proces.PROCESS_TYPE_ID=t4_a_offerProposalItems_pro
ces.ID LEFT OUTER JOIN OFFER_PROPOSAL_MAPPING t5_a_offerProposalItems_offerP ON t1_a_offerProposalItems.ID=t5_a_offerPro
posalItems_offerP.PROPOSAL_ITEM_ID LEFT OUTER JOIN OFFER_PRODUCT_2_OFFER_OPTION t6_a_offerProposalItems_offerP ON t5_a_o
fferProposalItems_offerP.PRODUCT_MAPPING_ID=t6_a_offerProposalItems_offerP.ID LEFT OUTER JOIN OFFER_PRODUCT t7_a_offerPr
oposalItems_offerP ON t6_a_offerProposalItems_offerP.PRODUCT_ID=t7_a_offerProposalItems_offerP.ID LEFT OUTER JOIN OFFER_
PRODUCT_TYPE t8_a_offerProposalItems_offerP ON t7_a_offerProposalItems_offerP.PRODUCT_TYPE_ID=t8_a_offerProposalItems_of
ferP.ID LEFT OUTER JOIN OFFER_OPTION t9_a_offerProposalItems_offerP ON t6_a_offerProposalItems_offerP.OPTION_ID=t9_a_off
erProposalItems_offerP.ID LEFT OUTER JOIN OFFER_PROPOSAL_CRITERIA t10_a_offerProposalCriteria ON t0_a.ID=t10_a_offerProp
osalCriteria.PROPOSAL_ID LEFT OUTER JOIN OFFER_CHANNEL t11_a_offerChannelEntity ON t0_a.OFFER_CHANNEL_ID=t11_a_offerChan
nelEntity.ID LEFT OUTER JOIN OFFER_TYPE_GROUP t12_a_offerTypeGroupEntity ON t0_a.OFFER_TYPE_GROUP_ID=t12_a_offerTypeGrou
pEntity.ID LEFT OUTER JOIN OFFER_TYPE t13_a_offerTypeEntity ON t0_a.OFFER_TYPE_ID=t13_a_offerTypeEntity.ID WHERE (t0_a.D
OMAIN = ? AND t0_a.CONTRACT_NO = ?)

Lazy-loading from database when entity bean locals are accessed to be transferred to DTOs:
13:54:45,134 DEBUG [OfferProposalEntityBean] Executing SQL: SELECT DOMAIN, CONTRACT_NO, PARTY_NO, OFFER_PERIOD, VALID_FR
OM, VALID_TO, PROPOSAL_PERMISSION, OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID FROM OFFER_PROPOSAL WHERE (ID=?)

13:54:45,165 DEBUG [OfferProposalEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM WHERE (PROPOSAL_ID=?)

13:54:45,212 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:45,259 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:54:45,290 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:45,337 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:45,400 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:45,447 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:45,493 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:45,540 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_LABEL, PROCESS_DESCRIPTION, PROCESS_TYPE_ID FR
OM OFFER_PROCESS WHERE (ID=?)
13:54:45,603 DEBUG [OfferProcessTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM OFFER_PROCESS_TY
PE WHERE (ID=?)
13:54:45,650 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:45,697 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:45,743 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:45,790 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:54:45,822 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:45,868 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:54:45,900 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:45,947 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:45,993 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:46,056 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:46,103 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:46,150 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:46,212 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:46,259 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:46,306 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:46,353 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:54:46,384 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:46,415 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:54:46,447 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:46,509 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:46,556 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:46,603 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:46,650 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:46,712 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:46,759 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:46,806 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:46,853 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:46,900 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:54:46,931 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:46,978 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:54:47,009 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA
L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:47,056 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O
FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:47,118 DEBUG [ItemCriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM ITEM_CRITERIA_TY
PE WHERE (ID=?)
13:54:47,165 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA
L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:47,228 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O
FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:47,275 DEBUG [ItemCriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM ITEM_CRITERIA_TY
PE WHERE (ID=?)
13:54:47,337 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA
L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:47,384 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O
FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:47,447 DEBUG [ItemCriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM ITEM_CRITERIA_TY
PE WHERE (ID=?)
13:54:47,493 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA
L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:47,540 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O
FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:47,603 DEBUG [ItemCriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM ITEM_CRITERIA_TY
PE WHERE (ID=?)
13:54:47,650 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA
L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:47,697 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O
FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:47,743 DEBUG [ItemCriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM ITEM_CRITERIA_TY
PE WHERE (ID=?)
13:54:47,806 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA
L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:47,853 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O
FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:47,900 DEBUG [ItemCriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM ITEM_CRITERIA_TY
PE WHERE (ID=?)
13:54:47,962 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA
L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:48,009 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O
FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:48,056 DEBUG [ItemCriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM ITEM_CRITERIA_TY
PE WHERE (ID=?)
13:54:48,119 INFO [STDOUT] leer
13:54:48,119 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:48,165 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:48,212 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:48,275 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:48,322 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:48,369 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:48,415 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:48,478 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:48,525 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:48,556 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:54:48,587 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:48,634 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:54:48,665 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:48,712 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:48,775 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:48,837 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:48,884 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:48,931 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:48,978 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:49,040 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:49,087 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:49,134 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:54:49,150 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:49,197 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:54:49,228 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:49,275 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:49,337 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:49,384 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:49,431 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:49,478 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:49,540 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:49,587 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:49,634 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:49,681 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:54:49,712 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:49,759 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:54:49,790 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA
L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:49,837 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O
FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:49,884 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA
L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:49,931 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O
FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:49,994 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA
L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:50,040 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O
FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:50,103 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA
L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:50,150 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O
FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:50,197 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA
L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:50,244 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O
FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:50,306 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA
L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:50,353 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O
FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:50,400 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA
L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:50,447 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O
FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?)
13:54:50,509 INFO [STDOUT] leer
13:54:50,509 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:50,556 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:50,619 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:50,666 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:50,712 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:50,775 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:50,822 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:50,869 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:50,931 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:50,962 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:54:50,994 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:51,041 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:54:51,072 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:51,119 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:51,166 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:51,228 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:51,275 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:51,322 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:51,384 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:51,431 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:51,478 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:51,525 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:54:51,556 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:51,587 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:54:51,619 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:51,666 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:51,728 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:51,775 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:51,837 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:51,884 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:51,931 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:51,994 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:52,041 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:52,072 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:54:52,119 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:52,166 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:54:52,181 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:52,244 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:52,291 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:52,353 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:52,400 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:52,447 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:52,509 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:52,556 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:52,634 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:52,681 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:54:52,712 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:52,744 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:54:52,775 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:52,837 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:52,884 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:52,931 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:52,994 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:53,041 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:53,087 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:53,134 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:53,197 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:53,228 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:54:53,259 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:53,306 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:54:53,337 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:53,384 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:53,431 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:53,478 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:53,541 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:53,588 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:53,634 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:53,681 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:53,744 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:53,775 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:54:53,806 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:53,853 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:54:53,884 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:53,931 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:53,978 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:54,041 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:54,088 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:54,134 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:54,197 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:54,244 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:54,291 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:54,338 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:54:54,369 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:54,400 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:54:54,431 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:54,494 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:54,541 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:54,588 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:54,650 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:54,697 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:54,744 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:54,791 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:54,853 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:54,884 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:54:54,916 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:54,963 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:54:54,994 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:55,041 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:55,088 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:55,150 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:55,197 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:55,244 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:55,291 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:55,353 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:55,400 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:55,447 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:54:55,478 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:55,509 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:54:55,541 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:55,588 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:55,650 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:55,697 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:55,744 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:55,791 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:55,853 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:55,900 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:55,947 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:55,994 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:54:56,025 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:56,056 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:54:56,088 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:56,150 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:56,197 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:56,244 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:56,291 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:56,353 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:56,400 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:56,447 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:56,494 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:56,541 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:54:56,572 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:56,619 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:54:56,650 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:56,697 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:56,744 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:56,791 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:56,853 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:56,900 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:56,947 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:57,010 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:57,056 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:57,103 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:54:57,135 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:57,166 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:54:57,197 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:57,244 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:57,306 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:57,353 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:57,400 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:57,447 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:57,510 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:57,556 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:57,603 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:57,650 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:54:57,681 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:57,713 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:54:57,744 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:57,806 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:57,853 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:57,900 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:57,963 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:58,010 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:58,056 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:58,103 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:58,166 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:58,197 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:54:58,228 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:58,275 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:54:58,306 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:58,353 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:58,416 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:58,463 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:58,510 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:58,572 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:58,619 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:58,666 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:58,713 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:58,760 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:54:58,791 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:58,838 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:54:58,869 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:58,916 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:58,963 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:59,010 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:59,072 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:59,119 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:59,166 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:59,213 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:59,275 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:59,307 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:54:59,338 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:59,385 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:54:59,416 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:59,463 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:59,510 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:59,572 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:59,619 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:59,666 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:59,713 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:59,775 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:54:59,822 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:59,869 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:54:59,900 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:54:59,932 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:54:59,978 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:55:00,025 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:55:00,072 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:55:00,135 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:55:00,182 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:55:00,228 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:55:00,275 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:55:00,322 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:55:00,385 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:55:00,416 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:55:00,447 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN
, RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:55:00,494 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P
ROPOSAL_ITEM_ID=?)
13:55:00,525 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:55:00,572 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:55:00,635 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:55:00,682 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:55:00,728 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:55:00,791 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:55:00,838 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:55:00,885 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?)
13:55:00,932 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?)
13:55:00,978 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA
L_ITEM_ID=?)
13:55:01,010 DEBUG [OfferProposalEntityBean] Executing SQL: SELECT OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID
FROM OFFER_PROPOSAL WHERE (ID=?)
13:55:01,057 DEBUG [OfferProposalEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_CRITERIA WHERE (PROPOSAL_I
D=?)
13:55:01,088 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, PROPOSAL_ID, CRITERIA_TYPE_ID
FROM OFFER_PROPOSAL_CRITERIA WHERE (ID=?)
13:55:01,135 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT PROPOSAL_ID, CRITERIA_TYPE_ID FROM OFFER_PROP
OSAL_CRITERIA WHERE (ID=?)
13:55:01,182 DEBUG [CriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE
(ID=?)
13:55:01,244 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, PROPOSAL_ID, CRITERIA_TYPE_ID
FROM OFFER_PROPOSAL_CRITERIA WHERE (ID=?)
13:55:01,291 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT PROPOSAL_ID, CRITERIA_TYPE_ID FROM OFFER_PROP
OSAL_CRITERIA WHERE (ID=?)
13:55:01,338 DEBUG [CriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE
(ID=?)
13:55:01,385 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, PROPOSAL_ID, CRITERIA_TYPE_ID
FROM OFFER_PROPOSAL_CRITERIA WHERE (ID=?)
13:55:01,447 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT PROPOSAL_ID, CRITERIA_TYPE_ID FROM OFFER_PROP
OSAL_CRITERIA WHERE (ID=?)
13:55:01,494 DEBUG [CriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE
(ID=?)
13:55:01,541 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, PROPOSAL_ID, CRITERIA_TYPE_ID
FROM OFFER_PROPOSAL_CRITERIA WHERE (ID=?)
13:55:01,588 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT PROPOSAL_ID, CRITERIA_TYPE_ID FROM OFFER_PROP
OSAL_CRITERIA WHERE (ID=?)
13:55:01,650 DEBUG [CriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE
(ID=?)
13:55:01,697 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, PROPOSAL_ID, CRITERIA_TYPE_ID
FROM OFFER_PROPOSAL_CRITERIA WHERE (ID=?)
13:55:01,744 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT PROPOSAL_ID, CRITERIA_TYPE_ID FROM OFFER_PROP
OSAL_CRITERIA WHERE (ID=?)
13:55:01,791 DEBUG [CriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE
(ID=?)
13:55:01,854 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, PROPOSAL_ID, CRITERIA_TYPE_ID
FROM OFFER_PROPOSAL_CRITERIA WHERE (ID=?)
13:55:01,900 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT PROPOSAL_ID, CRITERIA_TYPE_ID FROM OFFER_PROP
OSAL_CRITERIA WHERE (ID=?)
13:55:01,963 DEBUG [CriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE
(ID=?)
13:55:02,010 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, PROPOSAL_ID, CRITERIA_TYPE_ID
FROM OFFER_PROPOSAL_CRITERIA WHERE (ID=?)
13:55:02,057 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT PROPOSAL_ID, CRITERIA_TYPE_ID FROM OFFER_PROP
OSAL_CRITERIA WHERE (ID=?)
13:55:02,119 DEBUG [CriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE
(ID=?)
13:55:02,166 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, PROPOSAL_ID, CRITERIA_TYPE_ID
FROM OFFER_PROPOSAL_CRITERIA WHERE (ID=?)
13:55:02,213 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT PROPOSAL_ID, CRITERIA_TYPE_ID FROM OFFER_PROP
OSAL_CRITERIA WHERE (ID=?)
13:55:02,260 DEBUG [CriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE
(ID=?)
13:55:02,322 DEBUG [OfferProposalEntityBean] Executing SQL: SELECT OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID
FROM OFFER_PROPOSAL WHERE (ID=?)
13:55:02,369 DEBUG [OfferProposalEntityBean] Executing SQL: SELECT OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID
FROM OFFER_PROPOSAL WHERE (ID=?)
13:55:02,416 DEBUG [OfferProposalEntityBean] Executing SQL: SELECT OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID
FROM OFFER_PROPOSAL WHERE (ID=?)
13:55:02,479 DEBUG [OfferChannelEntityBean] Executing SQL: SELECT SHORTCUT FROM OFFER_CHANNEL WHERE (ID=?)
13:55:02,525 DEBUG [OfferProposalEntityBean] Executing SQL: SELECT OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID
FROM OFFER_PROPOSAL WHERE (ID=?)
13:55:02,572 DEBUG [OfferTypeEntityBean] Executing SQL: SELECT SHORTCUT FROM OFFER_TYPE WHERE (ID=?)
13:55:02,666 DEBUG [OfferProposalEntityBean] Executing SQL: SELECT OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID
FROM OFFER_PROPOSAL WHERE (ID=?)
13:55:02,713 DEBUG [OfferTypeGroupEntityBean] Executing SQL: SELECT SHORTCUT FROM OFFER_TYPE_GROUP WHERE (ID=?)
13:55:02,760 DEBUG [OfferProposalEntityBean] Executing SQL: SELECT OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID
FROM OFFER_PROPOSAL WHERE (ID=?)
13:55:02,822 DEBUG [OfferProposalEntityBean] Executing SQL: SELECT OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID
FROM OFFER_PROPOSAL WHERE (ID=?)
13:55:02,869 DEBUG [OfferProposalEntityBean] Executing SQL: SELECT OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID
FROM OFFER_PROPOSAL WHERE (ID=?)
13:55:02,916 DEBUG [OfferProposalEntityBean] Executing SQL: SELECT OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID
FROM OFFER_PROPOSAL WHERE (ID=?)
13:55:02,979 DEBUG [OfferProposalEntityBean] Executing SQL: SELECT OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID
FROM OFFER_PROPOSAL WHERE (ID=?)