[Production-Development] Copy Atribute From Sequence Product
authorrafaeldemiguel <rdm@openbravo.com>
Fri, 23 Sep 2011 08:52:29 +0200
changeset 14984 683e0e1ac318
parent 14983 fcf3ccf492f3
child 14985 ca2d1dec3bb7
[Production-Development] Copy Atribute From Sequence Product
src-db/database/model/tables/MA_SEQUENCEPRODUCTATT.xml
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_ELEMENT.xml
src-db/database/sourcedata/AD_FIELD.xml
src-db/database/sourcedata/AD_PROCESS_PARA.xml
src-db/database/sourcedata/AD_REFERENCE.xml
src-db/database/sourcedata/AD_REF_TABLE.xml
src/org/openbravo/erpCommon/ad_actionButton/SequenceProductCreate.java
src/org/openbravo/erpCommon/ad_callouts/SL_SequenceProduct_Product_Attribute.java
--- a/src-db/database/model/tables/MA_SEQUENCEPRODUCTATT.xml	Thu Sep 22 18:28:46 2011 +0200
+++ b/src-db/database/model/tables/MA_SEQUENCEPRODUCTATT.xml	Fri Sep 23 08:52:29 2011 +0200
@@ -37,10 +37,6 @@
         <default/>
         <onCreateDefault/>
       </column>
-      <column name="M_PRODUCT_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
-        <default/>
-        <onCreateDefault/>
-      </column>
       <column name="M_ATTRIBUTEUSETO_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
         <default/>
         <onCreateDefault/>
@@ -57,6 +53,10 @@
         <default/>
         <onCreateDefault/>
       </column>
+      <column name="MA_SEQUENCEPRODUCTFROM_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
       <foreign-key foreignTable="AD_ORG" name="AD_ORG_MASEQUENCEATTPRODUCT">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
@@ -66,8 +66,8 @@
       <foreign-key foreignTable="M_ATTRIBUTEUSE" name="M_ATTUSETO_MASEQATTPRODUCT">
         <reference local="M_ATTRIBUTEUSETO_ID" foreign="M_ATTRIBUTEUSE_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="M_PRODUCT" name="M_PRODUCT_MASEQUENCEATTPRODUCT">
-        <reference local="M_PRODUCT_ID" foreign="M_PRODUCT_ID"/>
+      <foreign-key foreignTable="MA_SEQUENCEPRODUCT" name="MA_SEQPRODFROM_MASEQNCEATTPROD">
+        <reference local="MA_SEQUENCEPRODUCTFROM_ID" foreign="MA_SEQUENCEPRODUCT_ID"/>
       </foreign-key>
       <foreign-key foreignTable="MA_SEQUENCEPRODUCT" name="MA_SEQPRODUCT_MA_SEQATTPRODUCT">
         <reference local="MA_SEQUENCEPRODUCT_ID" foreign="MA_SEQUENCEPRODUCT_ID"/>
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Thu Sep 22 18:28:46 2011 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Fri Sep 23 08:52:29 2011 +0200
@@ -208543,12 +208543,11 @@
 <!--1395BD95B14149C29B10B1B455A154DC-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--1395BD95B14149C29B10B1B455A154DC-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--1395BD95B14149C29B10B1B455A154DC-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--1395BD95B14149C29B10B1B455A154DC-->  <NAME><![CDATA[Product]]></NAME>
-<!--1395BD95B14149C29B10B1B455A154DC-->  <DESCRIPTION><![CDATA[An item produced by a process.]]></DESCRIPTION>
-<!--1395BD95B14149C29B10B1B455A154DC-->  <HELP><![CDATA[Identifies an item which is either purchased or sold in this organization.]]></HELP>
-<!--1395BD95B14149C29B10B1B455A154DC-->  <COLUMNNAME><![CDATA[M_Product_ID]]></COLUMNNAME>
+<!--1395BD95B14149C29B10B1B455A154DC-->  <NAME><![CDATA[Product From]]></NAME>
+<!--1395BD95B14149C29B10B1B455A154DC-->  <COLUMNNAME><![CDATA[MA_SequenceProductFrom_ID]]></COLUMNNAME>
 <!--1395BD95B14149C29B10B1B455A154DC-->  <AD_TABLE_ID><![CDATA[FF80818132144FDB01321456E8AC000E]]></AD_TABLE_ID>
-<!--1395BD95B14149C29B10B1B455A154DC-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--1395BD95B14149C29B10B1B455A154DC-->  <AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID>
+<!--1395BD95B14149C29B10B1B455A154DC-->  <AD_REFERENCE_VALUE_ID><![CDATA[FF808181329203980132921324270015]]></AD_REFERENCE_VALUE_ID>
 <!--1395BD95B14149C29B10B1B455A154DC-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
 <!--1395BD95B14149C29B10B1B455A154DC-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--1395BD95B14149C29B10B1B455A154DC-->  <ISPARENT><![CDATA[N]]></ISPARENT>
@@ -208559,7 +208558,7 @@
 <!--1395BD95B14149C29B10B1B455A154DC-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
 <!--1395BD95B14149C29B10B1B455A154DC-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
 <!--1395BD95B14149C29B10B1B455A154DC-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
-<!--1395BD95B14149C29B10B1B455A154DC-->  <AD_ELEMENT_ID><![CDATA[454]]></AD_ELEMENT_ID>
+<!--1395BD95B14149C29B10B1B455A154DC-->  <AD_ELEMENT_ID><![CDATA[E477C1D243AE4810B21FEE449181DAD8]]></AD_ELEMENT_ID>
 <!--1395BD95B14149C29B10B1B455A154DC-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
 <!--1395BD95B14149C29B10B1B455A154DC-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
 <!--1395BD95B14149C29B10B1B455A154DC-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
@@ -210330,7 +210329,9 @@
 <!--24A3A68F65AC4ACB93051653575F4A3F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--24A3A68F65AC4ACB93051653575F4A3F-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--24A3A68F65AC4ACB93051653575F4A3F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--24A3A68F65AC4ACB93051653575F4A3F-->  <NAME><![CDATA[Runtime]]></NAME>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <NAME><![CDATA[Run Time]]></NAME>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <DESCRIPTION><![CDATA[Operation run time]]></DESCRIPTION>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <HELP><![CDATA[Operation run time]]></HELP>
 <!--24A3A68F65AC4ACB93051653575F4A3F-->  <COLUMNNAME><![CDATA[Runtime]]></COLUMNNAME>
 <!--24A3A68F65AC4ACB93051653575F4A3F-->  <AD_TABLE_ID><![CDATA[800201]]></AD_TABLE_ID>
 <!--24A3A68F65AC4ACB93051653575F4A3F-->  <AD_REFERENCE_ID><![CDATA[11]]></AD_REFERENCE_ID>
@@ -210346,6 +210347,7 @@
 <!--24A3A68F65AC4ACB93051653575F4A3F-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
 <!--24A3A68F65AC4ACB93051653575F4A3F-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
 <!--24A3A68F65AC4ACB93051653575F4A3F-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--24A3A68F65AC4ACB93051653575F4A3F-->  <AD_ELEMENT_ID><![CDATA[FF80818131FFA2FC0131FFC874C5001D]]></AD_ELEMENT_ID>
 <!--24A3A68F65AC4ACB93051653575F4A3F-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
 <!--24A3A68F65AC4ACB93051653575F4A3F-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
 <!--24A3A68F65AC4ACB93051653575F4A3F-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
@@ -224844,8 +224846,7 @@
 <!--5A02BD2E7E2C4C0497524E2748B11BBE-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--5A02BD2E7E2C4C0497524E2748B11BBE-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--5A02BD2E7E2C4C0497524E2748B11BBE-->  <NAME><![CDATA[Validate Work Effort]]></NAME>
-<!--5A02BD2E7E2C4C0497524E2748B11BBE-->  <DESCRIPTION><![CDATA[Process to validate and actualize stocks of production run.]]></DESCRIPTION>
-<!--5A02BD2E7E2C4C0497524E2748B11BBE-->  <HELP><![CDATA[Process to validate the work effort in Production Run Window. With this process the work effort is closed. Stocks are actualized and average costs are calculated]]></HELP>
+<!--5A02BD2E7E2C4C0497524E2748B11BBE-->  <HELP><![CDATA[Process to validate the work effort.]]></HELP>
 <!--5A02BD2E7E2C4C0497524E2748B11BBE-->  <COLUMNNAME><![CDATA[Validating]]></COLUMNNAME>
 <!--5A02BD2E7E2C4C0497524E2748B11BBE-->  <AD_TABLE_ID><![CDATA[385]]></AD_TABLE_ID>
 <!--5A02BD2E7E2C4C0497524E2748B11BBE-->  <AD_REFERENCE_ID><![CDATA[28]]></AD_REFERENCE_ID>
--- a/src-db/database/sourcedata/AD_ELEMENT.xml	Thu Sep 22 18:28:46 2011 +0200
+++ b/src-db/database/sourcedata/AD_ELEMENT.xml	Fri Sep 23 08:52:29 2011 +0200
@@ -22836,6 +22836,17 @@
 <!--78BBC5006BB24FD5E040007F01017F06-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--78BBC5006BB24FD5E040007F01017F06--></AD_ELEMENT>
 
+<!--78D2DD1779FA4787B3C19558E2E65812--><AD_ELEMENT>
+<!--78D2DD1779FA4787B3C19558E2E65812-->  <AD_ELEMENT_ID><![CDATA[78D2DD1779FA4787B3C19558E2E65812]]></AD_ELEMENT_ID>
+<!--78D2DD1779FA4787B3C19558E2E65812-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--78D2DD1779FA4787B3C19558E2E65812-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--78D2DD1779FA4787B3C19558E2E65812-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--78D2DD1779FA4787B3C19558E2E65812-->  <COLUMNNAME><![CDATA[Copyattribute]]></COLUMNNAME>
+<!--78D2DD1779FA4787B3C19558E2E65812-->  <NAME><![CDATA[Copy Attributes in Production Process ]]></NAME>
+<!--78D2DD1779FA4787B3C19558E2E65812-->  <PRINTNAME><![CDATA[Copy Attributes in Production Process ]]></PRINTNAME>
+<!--78D2DD1779FA4787B3C19558E2E65812-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--78D2DD1779FA4787B3C19558E2E65812--></AD_ELEMENT>
+
 <!--79957912A873C7D8E040007F010156EE--><AD_ELEMENT>
 <!--79957912A873C7D8E040007F010156EE-->  <AD_ELEMENT_ID><![CDATA[79957912A873C7D8E040007F010156EE]]></AD_ELEMENT_ID>
 <!--79957912A873C7D8E040007F010156EE-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -25508,6 +25519,17 @@
 <!--E46619B0FD944516A50C9B18E0E4E727-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--E46619B0FD944516A50C9B18E0E4E727--></AD_ELEMENT>
 
+<!--E477C1D243AE4810B21FEE449181DAD8--><AD_ELEMENT>
+<!--E477C1D243AE4810B21FEE449181DAD8-->  <AD_ELEMENT_ID><![CDATA[E477C1D243AE4810B21FEE449181DAD8]]></AD_ELEMENT_ID>
+<!--E477C1D243AE4810B21FEE449181DAD8-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E477C1D243AE4810B21FEE449181DAD8-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E477C1D243AE4810B21FEE449181DAD8-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E477C1D243AE4810B21FEE449181DAD8-->  <COLUMNNAME><![CDATA[MA_SequenceProductFrom_ID]]></COLUMNNAME>
+<!--E477C1D243AE4810B21FEE449181DAD8-->  <NAME><![CDATA[Product From]]></NAME>
+<!--E477C1D243AE4810B21FEE449181DAD8-->  <PRINTNAME><![CDATA[Product From]]></PRINTNAME>
+<!--E477C1D243AE4810B21FEE449181DAD8-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--E477C1D243AE4810B21FEE449181DAD8--></AD_ELEMENT>
+
 <!--E54611099D4C4228A5D88E246D789308--><AD_ELEMENT>
 <!--E54611099D4C4228A5D88E246D789308-->  <AD_ELEMENT_ID><![CDATA[E54611099D4C4228A5D88E246D789308]]></AD_ELEMENT_ID>
 <!--E54611099D4C4228A5D88E246D789308-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_FIELD.xml	Thu Sep 22 18:28:46 2011 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Fri Sep 23 08:52:29 2011 +0200
@@ -179210,7 +179210,9 @@
 <!--748A08B0350744ADA48DE2FAC4033F3E-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--748A08B0350744ADA48DE2FAC4033F3E-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--748A08B0350744ADA48DE2FAC4033F3E-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--748A08B0350744ADA48DE2FAC4033F3E-->  <NAME><![CDATA[Runtime]]></NAME>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <NAME><![CDATA[Run Time]]></NAME>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <DESCRIPTION><![CDATA[Operation run time]]></DESCRIPTION>
+<!--748A08B0350744ADA48DE2FAC4033F3E-->  <HELP><![CDATA[Operation run time]]></HELP>
 <!--748A08B0350744ADA48DE2FAC4033F3E-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--748A08B0350744ADA48DE2FAC4033F3E-->  <AD_TAB_ID><![CDATA[800237]]></AD_TAB_ID>
 <!--748A08B0350744ADA48DE2FAC4033F3E-->  <AD_COLUMN_ID><![CDATA[24A3A68F65AC4ACB93051653575F4A3F]]></AD_COLUMN_ID>
@@ -193744,7 +193746,9 @@
 <!--CDCEB8A436794783BE180739C34F49FE-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--CDCEB8A436794783BE180739C34F49FE-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--CDCEB8A436794783BE180739C34F49FE-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--CDCEB8A436794783BE180739C34F49FE-->  <NAME><![CDATA[Runtime]]></NAME>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <NAME><![CDATA[Run Time]]></NAME>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <DESCRIPTION><![CDATA[Operation run time]]></DESCRIPTION>
+<!--CDCEB8A436794783BE180739C34F49FE-->  <HELP><![CDATA[Operation run time]]></HELP>
 <!--CDCEB8A436794783BE180739C34F49FE-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--CDCEB8A436794783BE180739C34F49FE-->  <AD_TAB_ID><![CDATA[ABCEE18A05EB4C7CADB2DC30C9924717]]></AD_TAB_ID>
 <!--CDCEB8A436794783BE180739C34F49FE-->  <AD_COLUMN_ID><![CDATA[24A3A68F65AC4ACB93051653575F4A3F]]></AD_COLUMN_ID>
@@ -194451,9 +194455,7 @@
 <!--DB94175C6E6E4408BC29758B1F578A83-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--DB94175C6E6E4408BC29758B1F578A83-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--DB94175C6E6E4408BC29758B1F578A83-->  <NAME><![CDATA[Product From]]></NAME>
-<!--DB94175C6E6E4408BC29758B1F578A83-->  <DESCRIPTION><![CDATA[An item produced by a process.]]></DESCRIPTION>
-<!--DB94175C6E6E4408BC29758B1F578A83-->  <HELP><![CDATA[Identifies an item which is either purchased or sold in this organization.]]></HELP>
-<!--DB94175C6E6E4408BC29758B1F578A83-->  <ISCENTRALLYMAINTAINED><![CDATA[N]]></ISCENTRALLYMAINTAINED>
+<!--DB94175C6E6E4408BC29758B1F578A83-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--DB94175C6E6E4408BC29758B1F578A83-->  <AD_TAB_ID><![CDATA[FF80818132144FDB0132146AAFCA0042]]></AD_TAB_ID>
 <!--DB94175C6E6E4408BC29758B1F578A83-->  <AD_COLUMN_ID><![CDATA[1395BD95B14149C29B10B1B455A154DC]]></AD_COLUMN_ID>
 <!--DB94175C6E6E4408BC29758B1F578A83-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
--- a/src-db/database/sourcedata/AD_PROCESS_PARA.xml	Thu Sep 22 18:28:46 2011 +0200
+++ b/src-db/database/sourcedata/AD_PROCESS_PARA.xml	Fri Sep 23 08:52:29 2011 +0200
@@ -4541,6 +4541,7 @@
 <!--FF80818132813610013281789D2E0088-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
 <!--FF80818132813610013281789D2E0088-->  <ISRANGE><![CDATA[N]]></ISRANGE>
 <!--FF80818132813610013281789D2E0088-->  <DEFAULTVALUE><![CDATA[Y]]></DEFAULTVALUE>
+<!--FF80818132813610013281789D2E0088-->  <AD_ELEMENT_ID><![CDATA[78D2DD1779FA4787B3C19558E2E65812]]></AD_ELEMENT_ID>
 <!--FF80818132813610013281789D2E0088--></AD_PROCESS_PARA>
 
 </data>
--- a/src-db/database/sourcedata/AD_REFERENCE.xml	Thu Sep 22 18:28:46 2011 +0200
+++ b/src-db/database/sourcedata/AD_REFERENCE.xml	Fri Sep 23 08:52:29 2011 +0200
@@ -5147,4 +5147,16 @@
 <!--FF808181322476640132249E3417002F-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
 <!--FF808181322476640132249E3417002F--></AD_REFERENCE>
 
+<!--FF808181329203980132921324270015--><AD_REFERENCE>
+<!--FF808181329203980132921324270015-->  <AD_REFERENCE_ID><![CDATA[FF808181329203980132921324270015]]></AD_REFERENCE_ID>
+<!--FF808181329203980132921324270015-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF808181329203980132921324270015-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF808181329203980132921324270015-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF808181329203980132921324270015-->  <NAME><![CDATA[MA_SequenceProductFrom]]></NAME>
+<!--FF808181329203980132921324270015-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FF808181329203980132921324270015-->  <ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE>
+<!--FF808181329203980132921324270015-->  <PARENTREFERENCE_ID><![CDATA[18]]></PARENTREFERENCE_ID>
+<!--FF808181329203980132921324270015-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--FF808181329203980132921324270015--></AD_REFERENCE>
+
 </data>
--- a/src-db/database/sourcedata/AD_REF_TABLE.xml	Thu Sep 22 18:28:46 2011 +0200
+++ b/src-db/database/sourcedata/AD_REF_TABLE.xml	Fri Sep 23 08:52:29 2011 +0200
@@ -1271,4 +1271,16 @@
 <!--FF808181321576F301321587CBB4004A-->  <ORDERBYCLAUSE><![CDATA[M_AttributeUse.seqno]]></ORDERBYCLAUSE>
 <!--FF808181321576F301321587CBB4004A--></AD_REF_TABLE>
 
+<!--FF808181329203980132921324270015--><AD_REF_TABLE>
+<!--FF808181329203980132921324270015-->  <AD_REFERENCE_ID><![CDATA[FF808181329203980132921324270015]]></AD_REFERENCE_ID>
+<!--FF808181329203980132921324270015-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF808181329203980132921324270015-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF808181329203980132921324270015-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF808181329203980132921324270015-->  <AD_TABLE_ID><![CDATA[800097]]></AD_TABLE_ID>
+<!--FF808181329203980132921324270015-->  <AD_KEY><![CDATA[801536]]></AD_KEY>
+<!--FF808181329203980132921324270015-->  <AD_DISPLAY><![CDATA[801546]]></AD_DISPLAY>
+<!--FF808181329203980132921324270015-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--FF808181329203980132921324270015-->  <WHERECLAUSE><![CDATA[MA_SequenceProduct.MA_Sequence_ID = @MA_Sequence_ID@ AND MA_SequenceProduct.Productiontype = '-']]></WHERECLAUSE>
+<!--FF808181329203980132921324270015--></AD_REF_TABLE>
+
 </data>
--- a/src/org/openbravo/erpCommon/ad_actionButton/SequenceProductCreate.java	Thu Sep 22 18:28:46 2011 +0200
+++ b/src/org/openbravo/erpCommon/ad_actionButton/SequenceProductCreate.java	Fri Sep 23 08:52:29 2011 +0200
@@ -92,14 +92,14 @@
       if (copyAttribute.equals("Y") && newProduct.getAttributeSet() != null) {
         // Special Attribute
         if (newProduct.getAttributeSet().isLot())
-          copyAtt(newOpProduct, opProduct.getProduct(), true, lotSearchKey, null);
+          copyAtt(newOpProduct, opProduct, true, lotSearchKey, null);
         if (newProduct.getAttributeSet().isSerialNo())
-          copyAtt(newOpProduct, opProduct.getProduct(), true, serialNoSearchKey, null);
+          copyAtt(newOpProduct, opProduct, true, serialNoSearchKey, null);
         if (newProduct.getAttributeSet().isExpirationDate())
-          copyAtt(newOpProduct, opProduct.getProduct(), true, expirationDateSearchKey, null);
+          copyAtt(newOpProduct, opProduct, true, expirationDateSearchKey, null);
         // Normal Attribute
         for (AttributeUse attributeuse : newProduct.getAttributeSet().getAttributeUseList()) {
-          copyAtt(newOpProduct, opProduct.getProduct(), false, "", attributeuse);
+          copyAtt(newOpProduct, opProduct, false, "", attributeuse);
         }
       }
 
@@ -130,15 +130,15 @@
     }
   }
 
-  private void copyAtt(OperationProduct newOpProduct, Product productFrom, boolean isSpecial,
-      String specialValue, AttributeUse attributeuse) throws Exception {
+  private void copyAtt(OperationProduct newOpProduct, OperationProduct fromOpProduct,
+      boolean isSpecial, String specialValue, AttributeUse attributeuse) throws Exception {
 
     OperationProductAttribute opProductAtt = OBProvider.getInstance().get(
         OperationProductAttribute.class);
     opProductAtt.setSequenceproduct(newOpProduct);
     opProductAtt.setClient(newOpProduct.getClient());
     opProductAtt.setOrganization(newOpProduct.getOrganization());
-    opProductAtt.setProduct(productFrom);
+    opProductAtt.setProductFrom(fromOpProduct);
     opProductAtt.setSpecialatt(isSpecial);
     if (isSpecial) {
       opProductAtt.setSpecialatt(specialValue);
--- a/src/org/openbravo/erpCommon/ad_callouts/SL_SequenceProduct_Product_Attribute.java	Thu Sep 22 18:28:46 2011 +0200
+++ b/src/org/openbravo/erpCommon/ad_callouts/SL_SequenceProduct_Product_Attribute.java	Fri Sep 23 08:52:29 2011 +0200
@@ -26,7 +26,6 @@
 import org.openbravo.dal.service.OBDal;
 import org.openbravo.model.ad.domain.Reference;
 import org.openbravo.model.common.plm.AttributeUse;
-import org.openbravo.model.common.plm.Product;
 import org.openbravo.model.manufacturing.processplan.OperationProduct;
 
 public class SL_SequenceProduct_Product_Attribute extends SimpleCallout {
@@ -42,18 +41,19 @@
   protected void execute(CalloutInfo info) throws ServletException {
 
     // String strLastFieldChanged = info.getLastFieldChanged();
-    String strmProductId = info.getStringParameter("inpmProductId", idFilter);
+    String strmSequenceProductId = info.getStringParameter("inpmaSequenceproductfromId", idFilter);
     String strmProductSequenceId = info.getStringParameter("inpmaSequenceproductId", idFilter);
 
-    Product product = OBDal.getInstance().get(Product.class, strmProductId);
-    if (product.getAttributeSet() != null) {
+    OperationProduct fromOpProduct = OBDal.getInstance().get(OperationProduct.class,
+        strmSequenceProductId);
+    if (fromOpProduct.getProduct().getAttributeSet() != null) {
       // Fill Normal Attributes
       OperationProduct opProduct = OBDal.getInstance().get(OperationProduct.class,
           strmProductSequenceId);
 
       OBCriteria attributeUseCriteria = OBDal.getInstance().createCriteria(AttributeUse.class);
-      attributeUseCriteria.add(Restrictions.eq(AttributeUse.PROPERTY_ATTRIBUTESET,
-          product.getAttributeSet()));
+      attributeUseCriteria.add(Restrictions.eq(AttributeUse.PROPERTY_ATTRIBUTESET, fromOpProduct
+          .getProduct().getAttributeSet()));
       attributeUseCriteria.addOrderBy(AttributeUse.PROPERTY_SEQUENCENUMBER, true);
       java.util.List<AttributeUse> attUseList = attributeUseCriteria.list();
 
@@ -67,14 +67,15 @@
       if (opProduct.getProduct().getAttributeSet() != null) {
         info.addSelect("inpspecialatt");
         // Lot
-        if (product.getAttributeSet().isLot() && opProduct.getProduct().getAttributeSet().isLot()) {
+        if (fromOpProduct.getProduct().getAttributeSet().isLot()
+            && opProduct.getProduct().getAttributeSet().isLot()) {
           org.openbravo.model.ad.domain.List lot = SpecialAttListValue(lotSearchKey);
           if (lot != null)
             info.addSelectResult(lot.getSearchKey(), lot.getName());
         }
 
         // Serial No.
-        if (product.getAttributeSet().isSerialNo()
+        if (fromOpProduct.getProduct().getAttributeSet().isSerialNo()
             && opProduct.getProduct().getAttributeSet().isSerialNo()) {
           org.openbravo.model.ad.domain.List sn = SpecialAttListValue(serialNoSearchKey);
           if (sn != null)
@@ -82,7 +83,7 @@
         }
 
         // ExpirationDate
-        if (product.getAttributeSet().isExpirationDate()
+        if (fromOpProduct.getProduct().getAttributeSet().isExpirationDate()
             && opProduct.getProduct().getAttributeSet().isExpirationDate()) {
           org.openbravo.model.ad.domain.List ed = SpecialAttListValue(expirationDateSearchKey);
           if (ed != null)