<?php
$strTableName="SPC_Approval";
$_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,  lead_bom.Special_Price,  lead_bom.SPC_Approved_By,  material_master.List_Price,  material_master.MDP,  material_master.`Last Updated on`,  material_master.`Last Updated by`,  lead_bom.Quantity*lead_bom.Target_Price AS Target_Amt,  lead_bom.Quantity*lead_bom.Special_Price AS SPC_Amt";
$gsqlFrom="FROM lead_bom  INNER JOIN material_master ON lead_bom.`Material Code` = material_master.`Material Code`";
$gsqlWhereExpr="";
$gsqlTail="";

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

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

$reportCaseSensitiveGroupFields = false;

$gstrSQL = gSQLWhere("");


?>