<?php
$strTableName="SPC_Req";
$_SESSION["OwnerID"] = $_SESSION["_".$strTableName."_OwnerID"];

$strOriginalTableName="lead_bom";

$gstrOrderBy="";
if(strlen($gstrOrderBy) && strtolower(substr($gstrOrderBy,0,8))!="order by")
	$gstrOrderBy="order by ".$gstrOrderBy;

$g_orderindexes=array();
$gsqlHead="SELECT lead_bom.LBOMID,  lead_bom.Lead_ID,  lead_bom.`Material Category`,  lead_bom.`Material Code`,  lead_bom.Quantity,  lead_bom.SPC_REQ_BY,  lead_bom.Target_Price,  lead_bom.SPC_Status,  material_master.List_Price AS `Unit Price`,  lead_bom.Quantity*material_master.List_price AS Amount,  lead_bom.Quantity*lead_bom.Target_Price AS `Target Amt`";
$gsqlFrom="FROM lead_bom  INNER JOIN material_master ON lead_bom.`Material Code` = material_master.`Material Code`";
$gsqlWhereExpr="";
$gsqlTail="";

include(getabspath("include/SPC_Req_settings.php"));

// alias for 'SQLQuery' object
$gQuery = &$queryData_SPC_Req;
$eventObj = &$tableEvents["SPC_Req"];

$reportCaseSensitiveGroupFields = false;

$gstrSQL = gSQLWhere("");


?>