bom_line.xpj

<?xml version="1.0" encoding="UTF-8"?><biztoolcfg qryfmtOpCreate="" qryfmtOpUpdate="" loadedClick="0" tableNm="bom_line" referLst="0" onLoadInit="0" tableTxt="bom_line" LstTP="Lst" lines2Link="" jointbls="1" header2Link="bom_header_id" exdata4select=""><DataLstExtElmt><![CDATA[<DbDetails> <DbTable>mes_trace.bom_line b JOIN bom_header bh ON bh.bom_header_id=b.bom_header_id LEFT JOIN mes_trace.bom_routing_line b0 ON (b.routing_sequence=b0.routing_sequence AND b0.routing_seq_num=b.routing_seq_num) JOIN bom_routing_header rh ON (rh.bom_routing_header_id=b0.bom_routing_header_id AND (bh.item_id_m=rh.item_id_m AND bh.org_id=rh.org_id)) LEFT JOIN mes_trace.item i ON b.component_item_id_m=i.item_id_m and i.org_id=bh.org_id left join uom on i.uom_id=uom.uom_id LEFT JOIN mes_trace.option_line o ON b.usage_basis=o.option_line_id LEFT JOIN mes_trace.option_line o0 ON b.wip_supply_type=o0.option_line_id LEFT JOIN mes_trace.subinventory s ON b.supply_sub_inventory=s.subinventory_id LEFT JOIN mes_trace.locator l ON b.supply_locator=l.locator_id JOIN mes_trace.bom_standard_operation bso ON b0.standard_operation_id=bso.bom_standard_operation_id</DbTable></DbDetails><OnClick><if cond="'%{bom_lineLst[component_item_id_m]}'"><DbDetails><Where>and item_number='%{bom_lineLst[component_item_id_m]}'</Where></DbDetails><submit next="component_item_id_m" namelist="DbDetails"/></if></OnClick>]]></DataLstExtElmt><operators4v><![CDATA[<xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="bom_line_ops.xml"/>]]></operators4v><Ctrls><Ctrl Required="1" name="bom_sequence" xTp="ComboBox" ctrldbdata="1~50*10" ctrltype="ComboBox"/><Ctrl dbfcsm="1" Required="1" ctrldbname="mes_trace." name="routing_sequence" ctrldbwhere="bom_header_id='%{bom_header_id}'" ctrldbtable="bom_routing_line" xTp="ComboBox" ctrldbdata="routing_sequence,routing_seq_num,routing_sequence" ctrldbdatarel="routing_sequence" ctrltype="ComboBox"/><Ctrl noused="1" nomodify="1" name="routing_seq_num" xTp="CheckBox" ctrltype="CheckBox"/><Ctrl Required="1" noquery="1" nomodify="1" ctrldbname="mes_trace." ctrlhide="1" noSelect="1" name="bom_header_id"><extelmt><![CDATA[<OnEnChange><DbDetails fcsm="true"><DbTable>mes_trace.bom_routing_line brl JOIN mes_trace.bom_routing_header brh ON brl.bom_routing_header_id=brh.bom_routing_header_id JOIN mes_trace.bom_header bh ON bh.item_id_m=brh.item_id_m AND bh.org_id=brh.org_id JOIN mes_trace.bom_standard_operation bso ON brl.standard_operation_id=bso.bom_standard_operation_id</DbTable><Data>standard_operation,concat(routing_sequence,'-',routing_seq_num) rsrsn,routing_seq_num,routing_sequence</Data></DbDetails><submit namelist="DbDetails" next="routing_sequence"/></OnEnChange>]]></extelmt></Ctrl><Ctrl Required="1" nomodify="1" ctrldbname="mes_trace." name="component_item_id_m" ctrldbwhere="(item_type=106 or item_type=105) and org_id='%{orgid}'" ctrldbtable="item" ctrldbdata="item_number,wip_supply_subinventory,wip_supply_locator,wip_supply_type,item_id_m" ctrldbdatarel="item_id_m"><extelmt><![CDATA[<OnEditChange><DbDetails><Where>and item_number like'%%{component_item_id_m[windowtext]}%'</Where></DbDetails><submit namelist="DbDetails"/></OnEditChange> <OnEnChange><if cond="!%{bom_lineLst[wip_supply_type]}"><assign name="wip_supply_type[option_line_id]" expr="%{component_item_id_m[wip_supply_type]}" function="SetSel"/></if><if cond="!%{bom_lineLst[supply_sub_inventory]}"><assign name="supply_sub_inventory[subinventory_id]" expr="%{component_item_id_m[wip_supply_subinventory]}" function="SetSel"/></if><if cond="!%{bom_lineLst[supply_locator]}"><assign name="supply_locator[locator_id]" expr="%{component_item_id_m[wip_supply_locator]}" function="SetSel"/></if></OnEnChange>]]></extelmt><addon><![CDATA[<MagicCtrl Name="pick%{colNm}" Link="tip:Pick" images=",data/search.png" button="type:0" Size="20,20"><OnClick><assign name="$parent.item_pick.frmwndctrl" expr="bom_line.component_item_id_m"/><assign name="$parent.item_pick.org_id" expr="%{orgid}"/><assign name="$parent.item_pick.excond" expr="and item_type in (105,106)"/><submit next="$parent.item_pick.itemLst"/></OnClick></MagicCtrl>\r\n]]></addon></Ctrl><Ctrl noused="1" name="component_revision"/><Ctrl Required="1" ctrldbname="mes_trace." name="usage_basis" ctrldbwhere="option_header_id=138" ctrldbtable="option_line" xTp="ComboBox" ctrldbdata="option_line_value,option_line_id" ctrldbdatarel="option_line_id" ctrltype="ComboBox"><extattr><![CDATA[onload="init" SelectedIndex="0"]]></extattr></Ctrl><Ctrl Required="1" name="usage_quantity"/><Ctrl noused="1" name="effective_start_date"/><Ctrl noused="1" name="effective_end_date"/><Ctrl noused="1" name="eco_number"/><Ctrl noused="1" name="eco_implemented_cb"/><Ctrl noused="1" name="planning_percentage"/><Ctrl noquery="1" name="yield"/><Ctrl noused="1" name="include_in_cost_rollup_cb"/><Ctrl noused="1" Required="1" ctrldbname="mes_trace." name="wip_supply_type" ctrldbwhere="option_header_id=135 and status is true" ctrldbtable="option_line" xTp="ComboBox" ctrldbdata="option_line_value,option_line_id" ctrldbdatarel="option_line_id" ctrltype="ComboBox"><extattr><![CDATA[onload="init"]]></extattr></Ctrl><Ctrl noused="1" Required="1" ctrldbname="mes_trace." name="supply_sub_inventory" ctrldbwhere="org_id='%{orgid}'" ctrldbtable="subinventory" xTp="ComboBox" ctrldbdata="subinventory,subinventory_id" ctrldbdatarel="subinventory_id" ctrltype="ComboBox"><extelmt><![CDATA[<OnSelEndOk><submit next="supply_locator"/></OnSelEndOk>]]></extelmt><extattr><![CDATA[onload="init"]]></extattr></Ctrl><Ctrl noused="1" ctrldbname="mes_trace." name="supply_locator" ctrldbwhere="subinventory_id='%{supply_sub_inventory[subinventory_id]}'" ctrldbtable="locator" xTp="ComboBox" ctrldbdata="locator,locator_id" ctrldbdatarel="locator_id" ctrltype="ComboBox"/><Ctrl noused="1" name="auto_request_material_cb"/><Ctrl noused="1" name="ef_id"/><Ctrl noquery="1" ctrlhide="1" name="created_by" insertparam="'%{operaid}'" noUpdate="1"/><Ctrl noquery="1" ctrlhide="1" name="creation_date" insertparam="now()" noUpdate="1"/><Ctrl noquery="1" ctrlhide="1" name="last_update_by" insertparam="'%{operaid}'" updateparam="'%{operaid}'"/><Ctrl noquery="1" ctrlhide="1" name="last_update_date" insertparam="now()" updateparam="now()"/><Ctrl noquery="1" nomodify="1" ctrlhide="1" name="bom_line_id" noInsert="1" noInAndUp="1" noUpdate="1"/></Ctrls></biztoolcfg>