details: https://code.openbravo.com/erp/devel/pi/rev/095cf3f720f6 changeset: 17624:095cf3f720f6 user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com> date: Tue Jul 31 17:50:39 2012 +0200 summary: Related to issue 21211.Replace procedure by java process.
details: https://code.openbravo.com/erp/devel/pi/rev/6ec538cab068 changeset: 17625:6ec538cab068 user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com> date: Wed Aug 08 08:47:14 2012 +0200 summary: Fixed issue 21211.Persist ma_processplan_totalized view on temporary table. diffstat: src-db/database/model/functions/MRP_RUN_EXPLODE.xml | 22 +- src-db/database/model/tables/MA_PROCESSPLAN_TOT_AUX.xml | 39 + src-db/database/sourcedata/AD_COLUMN.xml | 236 ++++++++- src-db/database/sourcedata/AD_ELEMENT.xml | 60 ++ src-db/database/sourcedata/AD_FIELD.xml | 1 - src-db/database/sourcedata/AD_MODEL_OBJECT.xml | 12 + src-db/database/sourcedata/AD_PROCESS.xml | 25 +- src-db/database/sourcedata/AD_TABLE.xml | 21 + src/org/openbravo/erpCommon/ad_actionButton/MRPManufacturingPlanProcess.java | 273 ++++++++++ 9 files changed, 680 insertions(+), 9 deletions(-) diffs (truncated from 819 to 300 lines): diff -r b28a5c0f5101 -r 6ec538cab068 src-db/database/model/functions/MRP_RUN_EXPLODE.xml --- a/src-db/database/model/functions/MRP_RUN_EXPLODE.xml Tue Aug 07 15:00:12 2012 +0200 +++ b/src-db/database/model/functions/MRP_RUN_EXPLODE.xml Wed Aug 08 08:47:14 2012 +0200 @@ -37,7 +37,7 @@ * under the License. * The Original Code is Openbravo ERP. * The Initial Developer of the Original Code is Openbravo SLU -* All portions are Copyright (C) 2001-2006 Openbravo SLU +* All portions are Copyright (C) 2001-2012 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************/ @@ -68,6 +68,15 @@ WHERE MRP_RUN_PRODUCTION_ID = p_Run_ID AND isexploded = 'N'; + --initialize ma_processplan_totalized_aux table + INSERT INTO ma_processplan_tot_aux ( + ma_processplan_tot_aux_id, ma_processplan_id, ma_processplan_version_id, + dependantproduct, depqty, produced, proqty + ) + SELECT get_uuid(), ma_processplan_id, ma_processplan_version_id, + dependantproduct, depqty, produced, proqty + FROM ma_processplan_totalized; + WHILE (v_Count <> 0) LOOP v_New := 'N'; v_lastProductID := '-1'; -- non-existant value @@ -91,11 +100,11 @@ Mrp_Run_Insertlines(p_Client_ID, p_Org_ID, p_User_ID, p_Run_ID, Cur_Run_Lines.M_Product_ID, -1*Cur_Run_Lines.Qty, -1*Cur_Run_Lines.Qty, Cur_Run_Lines.MRP_RUN_Line_ID, (CASE Cur_Run_Lines.ispurchased WHEN 'Y' THEN 'MP' ELSE 'WP' END), 'N', NULL, NULL, NULL, NULL, Cur_Run_Lines.MA_Processplan_ID, Cur_Run_Lines.planneddate - p_SecurityMargin, (CASE Cur_Run_Lines.ispurchased WHEN 'Y' THEN (Cur_Run_Lines.planneddate - p_SecurityMargin) ELSE Cur_Run_Lines.planneddate - p_SecurityMargin - (CASE Cur_Run_Lines.DELAYMIN > (CASE WHEN Cur_Run_Lines.CAPACITY IS NULL THEN 0 ELSE CEIL(Cur_Run_Lines.Qty/Cur_Run_Lines.CAPACITY) END) WHEN true THEN Cur_Run_Lines.DELAYMIN ELSE (CASE WHEN Cur_Run_Lines.CAPACITY IS NULL THEN 0 ELSE CEIL(Cur_Run_Lines.Qty/Cur_Run_Lines.CAPACITY) END) END) END), 'Y', (CASE WHEN Cur_Run_Lines.ispurchased = 'Y' THEN 'Y' ELSE 'N' END), NULL, v_Aux_ID); ELSE v_ResultStr := 'Explode dependant products'; - FOR Cur_Dependants IN (SELECT MA_PROCESSPLAN_TOTALIZED.DEPENDANTPRODUCT, DEPQTY/PROQTY AS qty, + FOR Cur_Dependants IN (SELECT MA_PROCESSPLAN_TOT_AUX.DEPENDANTPRODUCT, DEPQTY/PROQTY AS qty, M_PRODUCT.ISPURCHASED - FROM MA_PROCESSPLAN_TOTALIZED, M_PRODUCT + FROM MA_PROCESSPLAN_TOT_AUX, M_PRODUCT WHERE PRODUCED = Cur_Run_Lines.M_Product_ID - AND MA_PROCESSPLAN_TOTALIZED.DEPENDANTPRODUCT = M_PRODUCT.M_PRODUCT_ID) LOOP + AND MA_PROCESSPLAN_TOT_AUX.DEPENDANTPRODUCT = M_PRODUCT.M_PRODUCT_ID) LOOP MRP_RUN_INITIALIZE(p_User_ID, p_Org_ID, p_Client_ID, p_Run_ID, p_Planner_ID, Cur_Dependants.DependantProduct, NULL, NULL, NULL, NULL, p_TimeHorizon, p_PlanningDate, 'Y'); @@ -110,7 +119,7 @@ v_ResultStr := 'Other dependant products'; FOR Cur_Parents IN (SELECT pt.PRODUCED - FROM MA_PROCESSPLAN_TOTALIZED pt + FROM MA_PROCESSPLAN_TOT_AUX pt WHERE pt.DEPENDANTPRODUCT = Cur_Run_Lines.M_Product_ID) LOOP MRP_RUN_INITIALIZE(p_User_ID, p_Org_ID, p_Client_ID, p_Run_ID, p_Planner_ID, Cur_Parents.Produced, NULL, NULL, NULL, NULL, p_TimeHorizon, @@ -141,6 +150,9 @@ v_Count := v_NewCount; END LOOP; + --Delete ma_processplan_totalized_aux table. + DELETE FROM ma_processplan_tot_aux; + END; --BODY EXCEPTION WHEN OTHERS THEN diff -r b28a5c0f5101 -r 6ec538cab068 src-db/database/model/tables/MA_PROCESSPLAN_TOT_AUX.xml --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src-db/database/model/tables/MA_PROCESSPLAN_TOT_AUX.xml Wed Aug 08 08:47:14 2012 +0200 @@ -0,0 +1,39 @@ +<?xml version="1.0"?> + <database name="TABLE MA_PROCESSPLAN_TOT_AUX"> + <table name="MA_PROCESSPLAN_TOT_AUX" primaryKey="MA_PROCESSPLAN_TOT_AUX_KEY"> + <column name="MA_PROCESSPLAN_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="MA_PROCESSPLAN_VERSION_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="PRODUCED" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="PROQTY" primaryKey="false" required="false" type="DECIMAL" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="DEPENDANTPRODUCT" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="DEPQTY" primaryKey="false" required="false" type="DECIMAL" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="MA_PROCESSPLAN_TOT_AUX_ID" primaryKey="true" required="true" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <foreign-key foreignTable="MA_PROCESSPLAN" name="MA_PROCESSPLAN_TOT_AUX_PP"> + <reference local="MA_PROCESSPLAN_ID" foreign="MA_PROCESSPLAN_ID"/> + </foreign-key> + <foreign-key foreignTable="MA_PROCESSPLAN_VERSION" name="MA_PROCESSPLAN_TOT_AUX_PPV"> + <reference local="MA_PROCESSPLAN_VERSION_ID" foreign="MA_PROCESSPLAN_VERSION_ID"/> + </foreign-key> + </table> + </database> diff -r b28a5c0f5101 -r 6ec538cab068 src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Tue Aug 07 15:00:12 2012 +0200 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Wed Aug 08 08:47:14 2012 +0200 @@ -199588,7 +199588,7 @@ <!--803619--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> <!--803619--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> <!--803619--> <AD_ELEMENT_ID><![CDATA[800756]]></AD_ELEMENT_ID> -<!--803619--> <AD_PROCESS_ID><![CDATA[800162]]></AD_PROCESS_ID> +<!--803619--> <AD_PROCESS_ID><![CDATA[6FBD65B0FDB74D1AB07F0EADF18D48AE]]></AD_PROCESS_ID> <!--803619--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> <!--803619--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> <!--803619--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> @@ -288509,6 +288509,240 @@ <!--C5E48D4E187A4B7D9F33FA4F42C8F243--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> <!--C5E48D4E187A4B7D9F33FA4F42C8F243--></AD_COLUMN> +<!--C621D181EEAECF2BE040007F010027AD--><AD_COLUMN> +<!--C621D181EEAECF2BE040007F010027AD--> <AD_COLUMN_ID><![CDATA[C621D181EEAECF2BE040007F010027AD]]></AD_COLUMN_ID> +<!--C621D181EEAECF2BE040007F010027AD--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--C621D181EEAECF2BE040007F010027AD--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--C621D181EEAECF2BE040007F010027AD--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--C621D181EEAECF2BE040007F010027AD--> <NAME><![CDATA[Process Plan]]></NAME> +<!--C621D181EEAECF2BE040007F010027AD--> <DESCRIPTION><![CDATA[A guide stating how a certain item must move through the transformation process.]]></DESCRIPTION> +<!--C621D181EEAECF2BE040007F010027AD--> <HELP><![CDATA[Indicates a process plan.]]></HELP> +<!--C621D181EEAECF2BE040007F010027AD--> <COLUMNNAME><![CDATA[MA_Processplan_ID]]></COLUMNNAME> +<!--C621D181EEAECF2BE040007F010027AD--> <AD_TABLE_ID><![CDATA[03FB31878402432A927AEE8FD3650E2B]]></AD_TABLE_ID> +<!--C621D181EEAECF2BE040007F010027AD--> <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID> +<!--C621D181EEAECF2BE040007F010027AD--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> +<!--C621D181EEAECF2BE040007F010027AD--> <ISKEY><![CDATA[N]]></ISKEY> +<!--C621D181EEAECF2BE040007F010027AD--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--C621D181EEAECF2BE040007F010027AD--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> +<!--C621D181EEAECF2BE040007F010027AD--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--C621D181EEAECF2BE040007F010027AD--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--C621D181EEAECF2BE040007F010027AD--> <SEQNO><![CDATA[10]]></SEQNO> +<!--C621D181EEAECF2BE040007F010027AD--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--C621D181EEAECF2BE040007F010027AD--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--C621D181EEAECF2BE040007F010027AD--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--C621D181EEAECF2BE040007F010027AD--> <AD_ELEMENT_ID><![CDATA[800342]]></AD_ELEMENT_ID> +<!--C621D181EEAECF2BE040007F010027AD--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--C621D181EEAECF2BE040007F010027AD--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--C621D181EEAECF2BE040007F010027AD--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--C621D181EEAECF2BE040007F010027AD--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--C621D181EEAECF2BE040007F010027AD--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--C621D181EEAECF2BE040007F010027AD--> <POSITION><![CDATA[1]]></POSITION> +<!--C621D181EEAECF2BE040007F010027AD--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--C621D181EEAECF2BE040007F010027AD--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--C621D181EEAECF2BE040007F010027AD--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--C621D181EEAECF2BE040007F010027AD--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--C621D181EEAECF2BE040007F010027AD--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> +<!--C621D181EEAECF2BE040007F010027AD--></AD_COLUMN> + +<!--C621D181EEAFCF2BE040007F010027AD--><AD_COLUMN> +<!--C621D181EEAFCF2BE040007F010027AD--> <AD_COLUMN_ID><![CDATA[C621D181EEAFCF2BE040007F010027AD]]></AD_COLUMN_ID> +<!--C621D181EEAFCF2BE040007F010027AD--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--C621D181EEAFCF2BE040007F010027AD--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--C621D181EEAFCF2BE040007F010027AD--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--C621D181EEAFCF2BE040007F010027AD--> <NAME><![CDATA[Process Plan Version]]></NAME> +<!--C621D181EEAFCF2BE040007F010027AD--> <HELP><![CDATA[Indicates a process plan version.]]></HELP> +<!--C621D181EEAFCF2BE040007F010027AD--> <COLUMNNAME><![CDATA[MA_Processplan_Version_ID]]></COLUMNNAME> +<!--C621D181EEAFCF2BE040007F010027AD--> <AD_TABLE_ID><![CDATA[03FB31878402432A927AEE8FD3650E2B]]></AD_TABLE_ID> +<!--C621D181EEAFCF2BE040007F010027AD--> <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID> +<!--C621D181EEAFCF2BE040007F010027AD--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> +<!--C621D181EEAFCF2BE040007F010027AD--> <ISKEY><![CDATA[N]]></ISKEY> +<!--C621D181EEAFCF2BE040007F010027AD--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--C621D181EEAFCF2BE040007F010027AD--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> +<!--C621D181EEAFCF2BE040007F010027AD--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--C621D181EEAFCF2BE040007F010027AD--> <ISIDENTIFIER><![CDATA[Y]]></ISIDENTIFIER> +<!--C621D181EEAFCF2BE040007F010027AD--> <SEQNO><![CDATA[20]]></SEQNO> +<!--C621D181EEAFCF2BE040007F010027AD--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--C621D181EEAFCF2BE040007F010027AD--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--C621D181EEAFCF2BE040007F010027AD--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--C621D181EEAFCF2BE040007F010027AD--> <AD_ELEMENT_ID><![CDATA[800455]]></AD_ELEMENT_ID> +<!--C621D181EEAFCF2BE040007F010027AD--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--C621D181EEAFCF2BE040007F010027AD--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--C621D181EEAFCF2BE040007F010027AD--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--C621D181EEAFCF2BE040007F010027AD--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--C621D181EEAFCF2BE040007F010027AD--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--C621D181EEAFCF2BE040007F010027AD--> <POSITION><![CDATA[2]]></POSITION> +<!--C621D181EEAFCF2BE040007F010027AD--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--C621D181EEAFCF2BE040007F010027AD--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--C621D181EEAFCF2BE040007F010027AD--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--C621D181EEAFCF2BE040007F010027AD--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--C621D181EEAFCF2BE040007F010027AD--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> +<!--C621D181EEAFCF2BE040007F010027AD--></AD_COLUMN> + +<!--C621D181EEB0CF2BE040007F010027AD--><AD_COLUMN> +<!--C621D181EEB0CF2BE040007F010027AD--> <AD_COLUMN_ID><![CDATA[C621D181EEB0CF2BE040007F010027AD]]></AD_COLUMN_ID> +<!--C621D181EEB0CF2BE040007F010027AD--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--C621D181EEB0CF2BE040007F010027AD--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--C621D181EEB0CF2BE040007F010027AD--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--C621D181EEB0CF2BE040007F010027AD--> <NAME><![CDATA[Produced]]></NAME> +<!--C621D181EEB0CF2BE040007F010027AD--> <COLUMNNAME><![CDATA[Produced]]></COLUMNNAME> +<!--C621D181EEB0CF2BE040007F010027AD--> <AD_TABLE_ID><![CDATA[03FB31878402432A927AEE8FD3650E2B]]></AD_TABLE_ID> +<!--C621D181EEB0CF2BE040007F010027AD--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> +<!--C621D181EEB0CF2BE040007F010027AD--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> +<!--C621D181EEB0CF2BE040007F010027AD--> <ISKEY><![CDATA[N]]></ISKEY> +<!--C621D181EEB0CF2BE040007F010027AD--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--C621D181EEB0CF2BE040007F010027AD--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--C621D181EEB0CF2BE040007F010027AD--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--C621D181EEB0CF2BE040007F010027AD--> <ISIDENTIFIER><![CDATA[Y]]></ISIDENTIFIER> +<!--C621D181EEB0CF2BE040007F010027AD--> <SEQNO><![CDATA[30]]></SEQNO> +<!--C621D181EEB0CF2BE040007F010027AD--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--C621D181EEB0CF2BE040007F010027AD--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--C621D181EEB0CF2BE040007F010027AD--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--C621D181EEB0CF2BE040007F010027AD--> <AD_ELEMENT_ID><![CDATA[C6ACAA689C81BBDEE040007F01005838]]></AD_ELEMENT_ID> +<!--C621D181EEB0CF2BE040007F010027AD--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--C621D181EEB0CF2BE040007F010027AD--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--C621D181EEB0CF2BE040007F010027AD--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--C621D181EEB0CF2BE040007F010027AD--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--C621D181EEB0CF2BE040007F010027AD--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--C621D181EEB0CF2BE040007F010027AD--> <POSITION><![CDATA[3]]></POSITION> +<!--C621D181EEB0CF2BE040007F010027AD--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--C621D181EEB0CF2BE040007F010027AD--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--C621D181EEB0CF2BE040007F010027AD--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--C621D181EEB0CF2BE040007F010027AD--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--C621D181EEB0CF2BE040007F010027AD--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> +<!--C621D181EEB0CF2BE040007F010027AD--></AD_COLUMN> + +<!--C621D181EEB1CF2BE040007F010027AD--><AD_COLUMN> +<!--C621D181EEB1CF2BE040007F010027AD--> <AD_COLUMN_ID><![CDATA[C621D181EEB1CF2BE040007F010027AD]]></AD_COLUMN_ID> +<!--C621D181EEB1CF2BE040007F010027AD--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--C621D181EEB1CF2BE040007F010027AD--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--C621D181EEB1CF2BE040007F010027AD--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--C621D181EEB1CF2BE040007F010027AD--> <NAME><![CDATA[Proqty]]></NAME> +<!--C621D181EEB1CF2BE040007F010027AD--> <COLUMNNAME><![CDATA[Proqty]]></COLUMNNAME> +<!--C621D181EEB1CF2BE040007F010027AD--> <AD_TABLE_ID><![CDATA[03FB31878402432A927AEE8FD3650E2B]]></AD_TABLE_ID> +<!--C621D181EEB1CF2BE040007F010027AD--> <AD_REFERENCE_ID><![CDATA[29]]></AD_REFERENCE_ID> +<!--C621D181EEB1CF2BE040007F010027AD--> <FIELDLENGTH><![CDATA[12]]></FIELDLENGTH> +<!--C621D181EEB1CF2BE040007F010027AD--> <ISKEY><![CDATA[N]]></ISKEY> +<!--C621D181EEB1CF2BE040007F010027AD--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--C621D181EEB1CF2BE040007F010027AD--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--C621D181EEB1CF2BE040007F010027AD--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--C621D181EEB1CF2BE040007F010027AD--> <ISIDENTIFIER><![CDATA[Y]]></ISIDENTIFIER> +<!--C621D181EEB1CF2BE040007F010027AD--> <SEQNO><![CDATA[40]]></SEQNO> +<!--C621D181EEB1CF2BE040007F010027AD--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--C621D181EEB1CF2BE040007F010027AD--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--C621D181EEB1CF2BE040007F010027AD--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--C621D181EEB1CF2BE040007F010027AD--> <AD_ELEMENT_ID><![CDATA[C6ACAA689C80BBDEE040007F01005838]]></AD_ELEMENT_ID> +<!--C621D181EEB1CF2BE040007F010027AD--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--C621D181EEB1CF2BE040007F010027AD--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--C621D181EEB1CF2BE040007F010027AD--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--C621D181EEB1CF2BE040007F010027AD--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--C621D181EEB1CF2BE040007F010027AD--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--C621D181EEB1CF2BE040007F010027AD--> <POSITION><![CDATA[4]]></POSITION> +<!--C621D181EEB1CF2BE040007F010027AD--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--C621D181EEB1CF2BE040007F010027AD--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--C621D181EEB1CF2BE040007F010027AD--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--C621D181EEB1CF2BE040007F010027AD--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--C621D181EEB1CF2BE040007F010027AD--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> +<!--C621D181EEB1CF2BE040007F010027AD--></AD_COLUMN> + +<!--C621D181EEB2CF2BE040007F010027AD--><AD_COLUMN> +<!--C621D181EEB2CF2BE040007F010027AD--> <AD_COLUMN_ID><![CDATA[C621D181EEB2CF2BE040007F010027AD]]></AD_COLUMN_ID> +<!--C621D181EEB2CF2BE040007F010027AD--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--C621D181EEB2CF2BE040007F010027AD--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--C621D181EEB2CF2BE040007F010027AD--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--C621D181EEB2CF2BE040007F010027AD--> <NAME><![CDATA[Dependantproduct]]></NAME> +<!--C621D181EEB2CF2BE040007F010027AD--> <COLUMNNAME><![CDATA[Dependantproduct]]></COLUMNNAME> +<!--C621D181EEB2CF2BE040007F010027AD--> <AD_TABLE_ID><![CDATA[03FB31878402432A927AEE8FD3650E2B]]></AD_TABLE_ID> +<!--C621D181EEB2CF2BE040007F010027AD--> <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> +<!--C621D181EEB2CF2BE040007F010027AD--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> +<!--C621D181EEB2CF2BE040007F010027AD--> <ISKEY><![CDATA[N]]></ISKEY> +<!--C621D181EEB2CF2BE040007F010027AD--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--C621D181EEB2CF2BE040007F010027AD--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--C621D181EEB2CF2BE040007F010027AD--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--C621D181EEB2CF2BE040007F010027AD--> <ISIDENTIFIER><![CDATA[Y]]></ISIDENTIFIER> +<!--C621D181EEB2CF2BE040007F010027AD--> <SEQNO><![CDATA[50]]></SEQNO> +<!--C621D181EEB2CF2BE040007F010027AD--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--C621D181EEB2CF2BE040007F010027AD--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--C621D181EEB2CF2BE040007F010027AD--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--C621D181EEB2CF2BE040007F010027AD--> <AD_ELEMENT_ID><![CDATA[C6ACAA689C7EBBDEE040007F01005838]]></AD_ELEMENT_ID> +<!--C621D181EEB2CF2BE040007F010027AD--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--C621D181EEB2CF2BE040007F010027AD--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--C621D181EEB2CF2BE040007F010027AD--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--C621D181EEB2CF2BE040007F010027AD--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--C621D181EEB2CF2BE040007F010027AD--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--C621D181EEB2CF2BE040007F010027AD--> <POSITION><![CDATA[5]]></POSITION> +<!--C621D181EEB2CF2BE040007F010027AD--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--C621D181EEB2CF2BE040007F010027AD--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--C621D181EEB2CF2BE040007F010027AD--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--C621D181EEB2CF2BE040007F010027AD--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--C621D181EEB2CF2BE040007F010027AD--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> +<!--C621D181EEB2CF2BE040007F010027AD--></AD_COLUMN> + +<!--C621D181EEB3CF2BE040007F010027AD--><AD_COLUMN> +<!--C621D181EEB3CF2BE040007F010027AD--> <AD_COLUMN_ID><![CDATA[C621D181EEB3CF2BE040007F010027AD]]></AD_COLUMN_ID> +<!--C621D181EEB3CF2BE040007F010027AD--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--C621D181EEB3CF2BE040007F010027AD--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--C621D181EEB3CF2BE040007F010027AD--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--C621D181EEB3CF2BE040007F010027AD--> <NAME><![CDATA[Depqty]]></NAME> +<!--C621D181EEB3CF2BE040007F010027AD--> <COLUMNNAME><![CDATA[Depqty]]></COLUMNNAME> +<!--C621D181EEB3CF2BE040007F010027AD--> <AD_TABLE_ID><![CDATA[03FB31878402432A927AEE8FD3650E2B]]></AD_TABLE_ID> +<!--C621D181EEB3CF2BE040007F010027AD--> <AD_REFERENCE_ID><![CDATA[29]]></AD_REFERENCE_ID> +<!--C621D181EEB3CF2BE040007F010027AD--> <FIELDLENGTH><![CDATA[12]]></FIELDLENGTH> +<!--C621D181EEB3CF2BE040007F010027AD--> <ISKEY><![CDATA[N]]></ISKEY> ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits