details: https://code.openbravo.com/erp/devel/pi/rev/42c4ede6b0ae
changeset: 21390:42c4ede6b0ae
user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
date: Mon Oct 28 17:23:02 2013 +0100
summary: Fixed issue 24949. Ability to create movements related to
reservations.
Goods movement lines can be related to reservations. In that case its reserved
stock is reallocated to the source locator and then the reservation is moved
to the destination locator.
diffstat:
src-db/database/model/functions/M_MOVEMENT_POST.xml | 70 ++++-
src-db/database/model/functions/M_RESERVATION_REALLOCATE.xml | 3 +
src-db/database/model/tables/M_MOVEMENTLINE.xml | 7 +
src-db/database/sourcedata/AD_COLUMN.xml | 38 ++-
src-db/database/sourcedata/AD_FIELD.xml | 28 +
src-db/database/sourcedata/AD_REFERENCE.xml | 12 +
src-db/database/sourcedata/OBUISEL_SELECTOR.xml | 16 +
src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml | 172 +++++++++++
src/org/openbravo/materialmgmt/CSResponse.java | 1 +
src/org/openbravo/materialmgmt/ReservationUtils.java | 37 ++
src/org/openbravo/materialmgmt/ReservationUtils_data.xsql | 13 +
11 files changed, 389 insertions(+), 8 deletions(-)
diffs (truncated from 619 to 300 lines):
diff -r e6945815f1e7 -r 42c4ede6b0ae
src-db/database/model/functions/M_MOVEMENT_POST.xml
--- a/src-db/database/model/functions/M_MOVEMENT_POST.xml Fri Oct 25
17:43:27 2013 +0200
+++ b/src-db/database/model/functions/M_MOVEMENT_POST.xml Mon Oct 28
17:23:02 2013 +0100
@@ -178,19 +178,76 @@
*/
DECLARE
Cur_MoveLine RECORD;
- NextNo varchar2(32);
+ cur_res_stock RECORD;
+ v_res_stock_id VARCHAR2(32);
+ v_reservedqty NUMBER;
+ v_qtytorelease NUMBER;
+ v_res_result NUMBER;
+ v_res_msg NVARCHAR2(2000);
+ v_storage_detail_id VARCHAR2(32);
BEGIN --FOR COMMIT
FOR Cur_MoveLine IN
(SELECT * FROM M_MovementLine WHERE M_Movement_ID=v_Record_ID
ORDER BY Line)
LOOP
v_ResultStr:='Transaction for line' || Cur_MoveLine.Line;
- -- FROM
- AD_Sequence_Next('M_Transaction', v_Client_ID, NextNo);
IF (Cur_MoveLine.MovementQty = 0) THEN
RAISE_APPLICATION_ERROR(-20000,'@GoodsMovementsWithZeroQty@' || '
@Inline@ ' || Cur_MoveLine.line) ;
END IF;
+
+ IF (cur_moveline.m_reservation_id IS NOT NULL) THEN
+ SELECT COALESCE(SUM(quantity - COALESCE(releasedqty,0)), 0) INTO
v_reservedqty
+ FROM m_reservation_stock
+ WHERE m_reservation_id = cur_moveline.m_reservation_id
+ AND m_locator_id = cur_moveline.m_locator_id
+ AND COALESCE(m_attributesetinstance_id, '0') =
COALESCE(cur_moveline.m_attributesetinstance_id, '0');
+ IF (v_reservedqty < cur_moveline.movementqty) THEN
+ -- There is not enough stock reserved in given storage bin and
attributes
+ -- Try to reallocate no allocated reserved stock.
+ -- An error means that there is not available stock to assign to
the given reservation because:
+ -- 1) there is not enough on hand stock
+ -- 2) there are other reservations using that stock and cannot
be reallocated to use a different stock
+ -- 3) the given reservation has some allocated stock with
different storage bin or attributes
+ M_RESERVATION_REALLOCATE(cur_moveline.m_reservation_id,
cur_moveline.m_locator_id, cur_moveline.m_attributesetinstance_id,
cur_moveline.movementqty, v_p_User, v_res_result, v_res_msg);
+ IF (v_res_result IN (0, 2)) THEN
+ RAISE_APPLICATION_ERROR(-20000, v_res_msg);
+ END IF;
+ END IF;
+ -- If there is enough stock reserved release the stock and reserve
it in the destination storage bin
+ SELECT m_storage_detail_id INTO v_storage_detail_id
+ FROM m_storage_detail
+ WHERE m_product_id = cur_moveline.m_product_id
+ AND m_locator_id = cur_moveline.m_locatorto_id
+ AND m_attributesetinstance_id =
COALESCE(cur_moveline.m_attributesetinstance_id, '0')
+ AND m_product_uom_id IS NULL;
+ v_reservedqty := cur_moveline.movementqty;
+ FOR cur_res_stock IN (
+ SELECT m_reservation_stock_id, quantity -
COALESCE(releasedqty,0) AS reservedqty, isallocated
+ FROM m_reservation_stock
+ WHERE m_reservation_id = cur_moveline.m_reservation_id
+ AND m_locator_id = cur_moveline.m_locator_id
+ AND COALESCE(m_attributesetinstance_id, '0') =
COALESCE(cur_moveline.m_attributesetinstance_id, '0')
+ ORDER BY CASE isallocated WHEN 'Y' THEN 0 ELSE 1 END
+ ) LOOP
+ v_qtytorelease := LEAST(v_reservedqty,
cur_res_stock.reservedqty);
+ UPDATE m_reservation_stock
+ SET quantity = quantity - v_qtytorelease
+ WHERE m_reservation_stock_id =
cur_res_stock.m_reservation_stock_id;
+ M_RESERVE_STOCK_MANUAL(cur_moveline.m_reservation_id, 'SD',
v_storage_detail_id, v_qtytorelease, v_p_user, cur_res_stock.isallocated,
v_res_stock_id);
+
+ v_reservedqty := v_reservedqty - v_qtytorelease;
+ IF (v_reservedqty <= 0) THEN
+ EXIT;
+ END IF;
+ END LOOP;
+
+ DELETE FROM m_reservation_stock
+ WHERE quantity = 0
+ AND m_reservation_id = cur_moveline.m_reservation_id;
+ END IF;
+
+ -- FROM
INSERT
INTO M_Transaction
(
@@ -202,7 +259,7 @@
)
VALUES
(
- NextNo, Cur_MoveLine.AD_Client_ID, Cur_MoveLine.AD_Org_ID, 'Y',
+ get_uuid(), Cur_MoveLine.AD_Client_ID, Cur_MoveLine.AD_Org_ID,
'Y',
now(), v_p_User, now(), v_p_User,
'M-', Cur_MoveLine.M_Locator_ID, Cur_MoveLine.M_Product_ID,
COALESCE(Cur_MoveLine.M_AttributeSetInstance_ID, '0'),
v_MoveDate, (Cur_MoveLine.MovementQty * -1),
Cur_MoveLine.M_MovementLine_ID, Cur_MoveLine.M_Product_UOM_ID,
@@ -210,7 +267,6 @@
)
;
-- TO
- AD_Sequence_Next('M_Transaction', v_Client_ID, NextNo) ;
INSERT
INTO M_Transaction
(
@@ -222,7 +278,7 @@
)
VALUES
(
- NextNo, Cur_MoveLine.AD_Client_ID, Cur_MoveLine.AD_Org_ID, 'Y',
+ get_uuid(), Cur_MoveLine.AD_Client_ID, Cur_MoveLine.AD_Org_ID,
'Y',
now(), v_p_User, now(), v_p_User,
'M+', Cur_MoveLine.M_LocatorTo_ID, Cur_MoveLine.M_Product_ID,
COALESCE(Cur_MoveLine.M_AttributeSetInstance_ID, '0'),
v_MoveDate, Cur_MoveLine.MovementQty,
Cur_MoveLine.M_MovementLine_ID, Cur_MoveLine.M_Product_UOM_ID,
@@ -238,7 +294,7 @@
END; -- FOR COMMIT
END IF;--END_PROCESS
--M_Movement_Post - Finish_Process Extension Point
- --Extension point at the end of the M_Inout_Post. It has 5 available
parameters Record_ID, DocAction, User, Message and Result
+ --Extension point at the end of the M_Movement_Post. It has 4 available
parameters Record_ID, User, Message and Result
SELECT count(*) INTO v_count
FROM DUAL
where exists (select 1 from ad_ep_procedures where ad_extension_points_id
= 'FB653E9B971343B3989222ECD5B73A72');
diff -r e6945815f1e7 -r 42c4ede6b0ae
src-db/database/model/functions/M_RESERVATION_REALLOCATE.xml
--- a/src-db/database/model/functions/M_RESERVATION_REALLOCATE.xml Fri Oct
25 17:43:27 2013 +0200
+++ b/src-db/database/model/functions/M_RESERVATION_REALLOCATE.xml Mon Oct
28 17:23:02 2013 +0100
@@ -77,6 +77,9 @@
cur_reserved_stock RECORD;
cur_not_allocated_stock RECORD;
BEGIN
+ IF (p_result IS NULL) THEN
+ p_result := 1;
+ END IF;
SELECT r.m_product_id, r.c_uom_id, COALESCE(r.reservedqty, 0),
COALESCE(r.releasedqty, 0), r.quantity - COALESCE(r.reservedqty, 0),
COALESCE(SUM(alloc.quantity - COALESCE(alloc.releasedqty, 0)), 0),
r.m_warehouse_id, r.m_locator_id, r.m_attributesetinstance_id,
r.res_status
diff -r e6945815f1e7 -r 42c4ede6b0ae
src-db/database/model/tables/M_MOVEMENTLINE.xml
--- a/src-db/database/model/tables/M_MOVEMENTLINE.xml Fri Oct 25 17:43:27
2013 +0200
+++ b/src-db/database/model/tables/M_MOVEMENTLINE.xml Mon Oct 28 17:23:02
2013 +0100
@@ -77,6 +77,10 @@
<default/>
<onCreateDefault/>
</column>
+ <column name="M_RESERVATION_ID" primaryKey="false" required="false"
type="VARCHAR" size="32" autoIncrement="false">
+ <default/>
+ <onCreateDefault/>
+ </column>
<foreign-key foreignTable="AD_CLIENT" name="M_MOVEMENTLINE_AD_CLIENT">
<reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
</foreign-key>
@@ -104,6 +108,9 @@
<foreign-key foreignTable="M_PRODUCT_UOM"
name="M_MOVEMENTLINE_M_PRODUCT_UOM">
<reference local="M_PRODUCT_UOM_ID" foreign="M_PRODUCT_UOM_ID"/>
</foreign-key>
+ <foreign-key foreignTable="M_RESERVATION"
name="M_MOVEMENTLINE_RESERVATION">
+ <reference local="M_RESERVATION_ID" foreign="M_RESERVATION_ID"/>
+ </foreign-key>
<index name="M_MOVEMENTLINE_MOVEMENT" unique="false">
<index-column name="M_MOVEMENT_ID"/>
</index>
diff -r e6945815f1e7 -r 42c4ede6b0ae src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml Fri Oct 25 17:43:27 2013 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml Mon Oct 28 17:23:02 2013 +0100
@@ -58354,7 +58354,7 @@
<!--3591--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
<!--3591--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
<!--3591--> <AD_ELEMENT_ID><![CDATA[448]]></AD_ELEMENT_ID>
-<!--3591--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--3591--> <ISSESSIONATTR><![CDATA[Y]]></ISSESSIONATTR>
<!--3591--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
<!--3591--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
<!--3591--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
@@ -317367,6 +317367,42 @@
<!--E6CB7938B2AB40EDB5BE6BFEEA6AFE53-->
<ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
<!--E6CB7938B2AB40EDB5BE6BFEEA6AFE53--></AD_COLUMN>
+<!--E70F66E18E27150CE040007F01001ECB--><AD_COLUMN>
+<!--E70F66E18E27150CE040007F01001ECB-->
<AD_COLUMN_ID><![CDATA[E70F66E18E27150CE040007F01001ECB]]></AD_COLUMN_ID>
+<!--E70F66E18E27150CE040007F01001ECB-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E70F66E18E27150CE040007F01001ECB--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E70F66E18E27150CE040007F01001ECB--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E70F66E18E27150CE040007F01001ECB--> <NAME><![CDATA[Stock
Reservation]]></NAME>
+<!--E70F66E18E27150CE040007F01001ECB--> <HELP><![CDATA[The Reservation is the
definition of a product reservation is set the owner, the quantity and the
desired dimensions.]]></HELP>
+<!--E70F66E18E27150CE040007F01001ECB-->
<COLUMNNAME><![CDATA[M_Reservation_ID]]></COLUMNNAME>
+<!--E70F66E18E27150CE040007F01001ECB-->
<AD_TABLE_ID><![CDATA[324]]></AD_TABLE_ID>
+<!--E70F66E18E27150CE040007F01001ECB-->
<AD_REFERENCE_ID><![CDATA[95E2A8B50A254B2AAE6774B8C2F28120]]></AD_REFERENCE_ID>
+<!--E70F66E18E27150CE040007F01001ECB-->
<AD_REFERENCE_VALUE_ID><![CDATA[8DC520C5887F4F20822DF61609E1A4C6]]></AD_REFERENCE_VALUE_ID>
+<!--E70F66E18E27150CE040007F01001ECB-->
<FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--E70F66E18E27150CE040007F01001ECB--> <ISKEY><![CDATA[N]]></ISKEY>
+<!--E70F66E18E27150CE040007F01001ECB--> <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--E70F66E18E27150CE040007F01001ECB-->
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--E70F66E18E27150CE040007F01001ECB-->
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--E70F66E18E27150CE040007F01001ECB-->
<READONLYLOGIC><![CDATA[@Processed@='Y']]></READONLYLOGIC>
+<!--E70F66E18E27150CE040007F01001ECB-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--E70F66E18E27150CE040007F01001ECB--> <SEQNO><![CDATA[13]]></SEQNO>
+<!--E70F66E18E27150CE040007F01001ECB-->
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--E70F66E18E27150CE040007F01001ECB-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--E70F66E18E27150CE040007F01001ECB-->
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--E70F66E18E27150CE040007F01001ECB-->
<AD_ELEMENT_ID><![CDATA[CA9E531DC5FAEB11E040007F0100672C]]></AD_ELEMENT_ID>
+<!--E70F66E18E27150CE040007F01001ECB-->
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--E70F66E18E27150CE040007F01001ECB-->
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--E70F66E18E27150CE040007F01001ECB-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--E70F66E18E27150CE040007F01001ECB-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--E70F66E18E27150CE040007F01001ECB-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--E70F66E18E27150CE040007F01001ECB--> <POSITION><![CDATA[20]]></POSITION>
+<!--E70F66E18E27150CE040007F01001ECB-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--E70F66E18E27150CE040007F01001ECB--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--E70F66E18E27150CE040007F01001ECB-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--E70F66E18E27150CE040007F01001ECB-->
<IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--E70F66E18E27150CE040007F01001ECB-->
<ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--E70F66E18E27150CE040007F01001ECB--></AD_COLUMN>
+
<!--E7465E1AA1424E5481A1CF71F6885D65--><AD_COLUMN>
<!--E7465E1AA1424E5481A1CF71F6885D65-->
<AD_COLUMN_ID><![CDATA[E7465E1AA1424E5481A1CF71F6885D65]]></AD_COLUMN_ID>
<!--E7465E1AA1424E5481A1CF71F6885D65-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r e6945815f1e7 -r 42c4ede6b0ae src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/sourcedata/AD_FIELD.xml Fri Oct 25 17:43:27 2013 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml Mon Oct 28 17:23:02 2013 +0100
@@ -274911,6 +274911,34 @@
<!--E8C2E6B2D68C4E67A150855E205848CB-->
<EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
<!--E8C2E6B2D68C4E67A150855E205848CB--></AD_FIELD>
+<!--E8C4070D09A99077E040007F01001EF0--><AD_FIELD>
+<!--E8C4070D09A99077E040007F01001EF0-->
<AD_FIELD_ID><![CDATA[E8C4070D09A99077E040007F01001EF0]]></AD_FIELD_ID>
+<!--E8C4070D09A99077E040007F01001EF0-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E8C4070D09A99077E040007F01001EF0--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E8C4070D09A99077E040007F01001EF0--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E8C4070D09A99077E040007F01001EF0--> <NAME><![CDATA[Stock
Reservation]]></NAME>
+<!--E8C4070D09A99077E040007F01001EF0--> <HELP><![CDATA[The Reservation is the
definition of a product reservation is set the owner, the quantity and the
desired dimensions.]]></HELP>
+<!--E8C4070D09A99077E040007F01001EF0-->
<ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--E8C4070D09A99077E040007F01001EF0--> <AD_TAB_ID><![CDATA[260]]></AD_TAB_ID>
+<!--E8C4070D09A99077E040007F01001EF0-->
<AD_COLUMN_ID><![CDATA[E70F66E18E27150CE040007F01001ECB]]></AD_COLUMN_ID>
+<!--E8C4070D09A99077E040007F01001EF0-->
<IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--E8C4070D09A99077E040007F01001EF0-->
<ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--E8C4070D09A99077E040007F01001EF0-->
<DISPLAYLOGIC><![CDATA[@StockReservations@!'']]></DISPLAYLOGIC>
+<!--E8C4070D09A99077E040007F01001EF0-->
<DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
+<!--E8C4070D09A99077E040007F01001EF0--> <ISREADONLY><![CDATA[Y]]></ISREADONLY>
+<!--E8C4070D09A99077E040007F01001EF0--> <SEQNO><![CDATA[120]]></SEQNO>
+<!--E8C4070D09A99077E040007F01001EF0--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--E8C4070D09A99077E040007F01001EF0-->
<ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--E8C4070D09A99077E040007F01001EF0-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--E8C4070D09A99077E040007F01001EF0-->
<SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--E8C4070D09A99077E040007F01001EF0-->
<ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--E8C4070D09A99077E040007F01001EF0-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--E8C4070D09A99077E040007F01001EF0-->
<STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--E8C4070D09A99077E040007F01001EF0-->
<STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--E8C4070D09A99077E040007F01001EF0-->
<ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--E8C4070D09A99077E040007F01001EF0-->
<EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--E8C4070D09A99077E040007F01001EF0--></AD_FIELD>
+
<!--E8C91A2D821242B8B7F85008A172991F--><AD_FIELD>
<!--E8C91A2D821242B8B7F85008A172991F-->
<AD_FIELD_ID><![CDATA[E8C91A2D821242B8B7F85008A172991F]]></AD_FIELD_ID>
<!--E8C91A2D821242B8B7F85008A172991F-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r e6945815f1e7 -r 42c4ede6b0ae src-db/database/sourcedata/AD_REFERENCE.xml
--- a/src-db/database/sourcedata/AD_REFERENCE.xml Fri Oct 25 17:43:27
2013 +0200
+++ b/src-db/database/sourcedata/AD_REFERENCE.xml Mon Oct 28 17:23:02
2013 +0100
@@ -5485,6 +5485,18 @@
<!--8CEE50DD83244E51AF4949827A04FC52-->
<ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
<!--8CEE50DD83244E51AF4949827A04FC52--></AD_REFERENCE>
+<!--8DC520C5887F4F20822DF61609E1A4C6--><AD_REFERENCE>
+<!--8DC520C5887F4F20822DF61609E1A4C6-->
<AD_REFERENCE_ID><![CDATA[8DC520C5887F4F20822DF61609E1A4C6]]></AD_REFERENCE_ID>
+<!--8DC520C5887F4F20822DF61609E1A4C6-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--8DC520C5887F4F20822DF61609E1A4C6--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--8DC520C5887F4F20822DF61609E1A4C6--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--8DC520C5887F4F20822DF61609E1A4C6--> <NAME><![CDATA[Open reservations of
product]]></NAME>
+<!--8DC520C5887F4F20822DF61609E1A4C6-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--8DC520C5887F4F20822DF61609E1A4C6-->
<ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE>
+<!--8DC520C5887F4F20822DF61609E1A4C6-->
<PARENTREFERENCE_ID><![CDATA[95E2A8B50A254B2AAE6774B8C2F28120]]></PARENTREFERENCE_ID>
+<!--8DC520C5887F4F20822DF61609E1A4C6-->
<ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--8DC520C5887F4F20822DF61609E1A4C6--></AD_REFERENCE>
+
<!--8FAA2F7B2F67456780B3551099E13917--><AD_REFERENCE>
<!--8FAA2F7B2F67456780B3551099E13917-->
<AD_REFERENCE_ID><![CDATA[8FAA2F7B2F67456780B3551099E13917]]></AD_REFERENCE_ID>
<!--8FAA2F7B2F67456780B3551099E13917-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r e6945815f1e7 -r 42c4ede6b0ae
src-db/database/sourcedata/OBUISEL_SELECTOR.xml
--- a/src-db/database/sourcedata/OBUISEL_SELECTOR.xml Fri Oct 25 17:43:27
2013 +0200
+++ b/src-db/database/sourcedata/OBUISEL_SELECTOR.xml Mon Oct 28 17:23:02
2013 +0100
@@ -263,6 +263,22 @@
<!--5E026139F74D4FD5AC4FA23189A03C92-->
<CUSTOM_QUERY><![CDATA[N]]></CUSTOM_QUERY>
<!--5E026139F74D4FD5AC4FA23189A03C92--></OBUISEL_SELECTOR>
+<!--632F319DE1564495B3B5D710127DA6DC--><OBUISEL_SELECTOR>
+<!--632F319DE1564495B3B5D710127DA6DC-->
<OBUISEL_SELECTOR_ID><![CDATA[632F319DE1564495B3B5D710127DA6DC]]></OBUISEL_SELECTOR_ID>
+<!--632F319DE1564495B3B5D710127DA6DC-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--632F319DE1564495B3B5D710127DA6DC--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--632F319DE1564495B3B5D710127DA6DC-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--632F319DE1564495B3B5D710127DA6DC--> <NAME><![CDATA[Reservation]]></NAME>
+<!--632F319DE1564495B3B5D710127DA6DC-->
<AD_REFERENCE_ID><![CDATA[8DC520C5887F4F20822DF61609E1A4C6]]></AD_REFERENCE_ID>
+<!--632F319DE1564495B3B5D710127DA6DC-->
<AD_TABLE_ID><![CDATA[77264B07BB0E4FA483A07FB40C2E0FE0]]></AD_TABLE_ID>
+<!--632F319DE1564495B3B5D710127DA6DC--> <WHERECLAUSE><![CDATA[e.product.id =
@inpmProductId@ AND e.rESStatus not in ('DR', 'CL') AND (e.storageBin IS NULL
OR e.storageBin = (SELECT e FROM Locator e WHERE e.id = @M_Locator_ID@)) AND
(e.warehouse IS NULL OR e.warehouse = (SELECT warehouse FROM Locator WHERE id =
@M_Locator_ID@))]]></WHERECLAUSE>
+<!--632F319DE1564495B3B5D710127DA6DC-->
<OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID>
+<!--632F319DE1564495B3B5D710127DA6DC--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--632F319DE1564495B3B5D710127DA6DC-->
<SUGGESTIONTEXTMATCHSTYLE><![CDATA[startsWith]]></SUGGESTIONTEXTMATCHSTYLE>
+<!--632F319DE1564495B3B5D710127DA6DC-->
<POPUPTEXTMATCHSTYLE><![CDATA[startsWith]]></POPUPTEXTMATCHSTYLE>
+<!--632F319DE1564495B3B5D710127DA6DC-->
<CUSTOM_QUERY><![CDATA[N]]></CUSTOM_QUERY>
+<!--632F319DE1564495B3B5D710127DA6DC--></OBUISEL_SELECTOR>
+
<!--720AAD2B1552455582E5D15103F59923--><OBUISEL_SELECTOR>
<!--720AAD2B1552455582E5D15103F59923-->
<OBUISEL_SELECTOR_ID><![CDATA[720AAD2B1552455582E5D15103F59923]]></OBUISEL_SELECTOR_ID>
<!--720AAD2B1552455582E5D15103F59923-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r e6945815f1e7 -r 42c4ede6b0ae
src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
--- a/src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml Fri Oct 25
17:43:27 2013 +0200
+++ b/src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml Mon Oct 28
17:23:02 2013 +0100
@@ -1,5 +1,27 @@
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
