CREATE COLUMN VIEW "IMCYC"."ES_BOM" WITH PARAMETERS (indexType=6,
joinIndex="IMCYC"."OITT",joinIndexType=0,joinIndexEstimation=0,
joinIndex="IMCYC"."OITM",joinIndexType=0,joinIndexEstimation=0,
joinIndex="IMCYC"."OPLN",joinIndexType=0,joinIndexEstimation=0,
joinIndex="IMCYC"."ITM1",joinIndexType=0,joinIndexEstimation=0,
joinIndex="IMCYC"."ITT1",joinIndexType=0,joinIndexEstimation=0,
joinCondition=('join1_0',"IMCYC"."OITT", "Code","IMCYC"."OITM", "ItemCode",'',49,0),
joinCondition=('join2_0',"IMCYC"."OITT", "PriceList","IMCYC"."OPLN", "ListNum",'',65809,1),
joinCondition=('join3_0',"IMCYC"."OITT", "Code","IMCYC"."ITM1", "ItemCode",'',145,2),
joinCondition=('join3_1',"IMCYC"."OITT", "PriceList","IMCYC"."ITM1", "PriceList",'',65617,3),
joinCondition=('join4_0',"IMCYC"."OITT", "Code","IMCYC"."ITT1", "Father",'',145,4),
joinCondition=('join5_0',"IMCYC"."ITT1", "PriceList","IMCYC"."OPLN.temp1", "ListNum",'',65809,5),
joinPath=('JoinPath1','join1_0'),
joinPath=('JoinPath2','join2_0'),
joinPath=('JoinPath3','join3_0,join3_1'),
joinPath=('JoinPath4','join4_0'),
joinPath=('JoinPath5','join4_0,join5_0'),
viewAttribute=('OITM_ItemCode',"IMCYC"."OITM", "ItemCode",'JoinPath1','V_ES_BOM','attribute'),
viewAttribute=('OITM_ItemName',"IMCYC"."OITM", "ItemName",'JoinPath1','V_ES_BOM','attribute'),
viewAttribute=('OITM_LastPurPrc',"IMCYC"."OITM", "LastPurPrc",'JoinPath1','V_ES_BOM','attribute'),
viewAttribute=('OITM_LstEvlPric',"IMCYC"."OITM", "LstEvlPric",'JoinPath1','V_ES_BOM','attribute'),
viewAttribute=('OPLN.temp0_ListNum',"IMCYC"."OPLN", "ListNum",'JoinPath2','V_ES_BOM','attribute'),
viewAttribute=('OPLN.temp0_ListName',"IMCYC"."OPLN", "ListName",'JoinPath2','V_ES_BOM','attribute'),
viewAttribute=('ITM1_ItemCode',"IMCYC"."ITM1", "ItemCode",'JoinPath3','V_ES_BOM','attribute'),
viewAttribute=('ITM1_PriceList',"IMCYC"."ITM1", "PriceList",'JoinPath3','V_ES_BOM','attribute'),
viewAttribute=('ITM1_Price',"IMCYC"."ITM1", "Price",'JoinPath3','V_ES_BOM','attribute'),
viewAttribute=('OPLN.temp1_ListNum',"IMCYC"."OPLN.temp1", "ListNum",'JoinPath5','V_ES_BOM','attribute'),
viewAttribute=('OPLN.temp1_ListName',"IMCYC"."OPLN.temp1", "ListName",'JoinPath5','V_ES_BOM','attribute'),
viewAttribute=('ITT1_Father',"IMCYC"."ITT1", "Father",'JoinPath4','V_ES_BOM','attribute'),
viewAttribute=('ITT1_Code',"IMCYC"."ITT1", "Code",'JoinPath4','V_ES_BOM','attribute'),
viewAttribute=('ITT1_Quantity',"IMCYC"."ITT1", "Quantity",'JoinPath4','V_ES_BOM','attribute'),
viewAttribute=('ITT1_Price',"IMCYC"."ITT1", "Price",'JoinPath4','V_ES_BOM','attribute'),
viewAttribute=('ITT1_PriceList',"IMCYC"."ITT1", "PriceList",'JoinPath4','V_ES_BOM','attribute'),
viewAttribute=('OITT_Code',"IMCYC"."OITT", "Code",'JoinPath1','V_ES_BOM','attribute'),
viewAttribute=('OITT_TreeType',"IMCYC"."OITT", "TreeType",'JoinPath1','V_ES_BOM','attribute'),
viewAttribute=('OITT_ToWH',"IMCYC"."OITT", "ToWH",'JoinPath1','V_ES_BOM','attribute'),
viewAttribute=('OITT_PriceList',"IMCYC"."OITT", "PriceList",'JoinPath1','V_ES_BOM','attribute'),
viewAttribute=('OITT_Project',"IMCYC"."OITT", "Project",'JoinPath1','V_ES_BOM','attribute'),
freeStyleSearchAttribute='OITM_ItemName:1:0',
freeStyleSearchAttribute='OPLN.temp0_ListName:1:0',
freeStyleSearchAttribute='OPLN.temp1_ListName:1:0',
freeStyleSearchAttribute='ITT1_Code:1:0',
freeStyleSearchAttribute='ITT1_Quantity:1:0',
freeStyleSearchAttribute='ITT1_Price:1:0',
freeStyleSearchAttribute='OITT_Code:1:0',
freeStyleSearchAttribute='OITT_TreeType:1:0',
freeStyleSearchAttribute='OITT_ToWH:1:0',
freeStyleSearchAttribute='OITT_Project:1:0',
view=('V_ES_BOM',"IMCYC"."OITT"),defaultView='V_ES_BOM',OPTIMIZEMETAMODEL=0)