http://in.compucrete.com/index.php?action=history&feed=atom&title=Product_Structure_Replication_Query 2026-05-15T16:56:53Z Revision history for this page on the wiki MediaWiki 1.40.0 http://in.compucrete.com/index.php?title=Product_Structure_Replication_Query&diff=516&oldid=prev 2023-07-14T13:00:35Z

<p>1 revision imported</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 13:00, 14 July 2023</td> </tr> <!-- diff cache key my_wiki:diff::1.12:old-515:rev-516 --> </table>

WikiAdmin http://in.compucrete.com/index.php?title=Product_Structure_Replication_Query&diff=515&oldid=prev 2017-01-10T00:02:10Z

<p>1 revision imported</p> <p><b>New page</b></p><div>[[Category: Inventory]]<br /> [[Category: SQL]]<br /> == Replicate Product Structure ==<br /> <br /> NOTE: Modify to fit the data.<br /> <br /> Example: plant 20 based on plant 12<br /> <br /> &lt;pre&gt;<br /> INSERT INTO artprstr (<br /> SESSION_NO,<br /> TRANS_NO,<br /> SEQUENCE_CODE,<br /> ASSY_PRODUCT_CODE,<br /> COMP_PRODUCT_CODE,<br /> QTY_ASSEMBLY,<br /> IMPORTED_FLAG,<br /> MEMO,<br /> LAST_CHANGE_DATE,<br /> LAST_CHANGE_USER,<br /> ACTIVE_FLAG)<br /> Select<br /> 0,<br /> GEN_ID(COFX_GEN,1),<br /> SEQUENCE_CODE,<br /> substr(ASSY_PRODUCT_CODE,1,strlen(ASSY_PRODUCT_CODE)-2)||'20',<br /> substr(COMP_PRODUCT_CODE,1,strlen(COMP_PRODUCT_CODE)-2)||'20',<br /> QTY_ASSEMBLY,<br /> IMPORTED_FLAG,<br /> MEMO,<br /> '10/01/02',<br /> 'HIT',<br /> ACTIVE_FLAG<br /> FROM artprSTR<br /> WHERE substr(ASSY_PRODUCT_CODE,strlen(ASSY_PRODUCT_CODE)-1,strlen(ASSY_PRODUCT_CODE)) = '12';<br /> &lt;/pre&gt;</div>

Intra>User