http://in.compucrete.com/index.php?action=history&feed=atom&title=Product_Structure_Cost_Analysis
Product Structure Cost Analysis - Revision history
2026-05-15T16:10:29Z
Revision history for this page on the wiki
MediaWiki 1.40.0
http://in.compucrete.com/index.php?title=Product_Structure_Cost_Analysis&diff=514&oldid=prev
WikiAdmin: 1 revision imported
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-513:rev-514 -->
</table>
WikiAdmin
http://in.compucrete.com/index.php?title=Product_Structure_Cost_Analysis&diff=513&oldid=prev
Intra>User: 1 revision imported
2017-01-10T00:02:09Z
<p>1 revision imported</p>
<p><b>New page</b></p><div>This query report will give extend out the costs of each assembly.<br />
<br />
<PRE><br />
select assy_product_code "Assembly", pa.description_1 "Assembly Name", sequence_code "Seq",<br />
comp_product_code "Component", pc.description_1 "Compenent Name",<br />
pa.standard_cost "Assembly Cost", qty_assembly "Qty",pc.standard_cost "Comp Unit Cost",<br />
pc.standard_cost*qty_assembly "Comp Ext Cost"<br />
from artprstr s<br />
inner join artprod pa on pa.product_code = s.assy_product_code<br />
inner join artprod pc on pc.product_code = s.comp_product_code<br />
where artprod.plant_no = :PLANT <br />
order by assy_product_code,sequence_code<br />
</PRE><br />
<br />
Break/Group:<br />
:1/1: Assembly,Assembly Name<br />
Total:<br />
: Comp Ext Cost</div>
Intra>User