Description |
I imported their ag and grain inventory. All looking good.
This part of the stored procedure doesn't renturn any records. :
{panel:bgColor=#E0EFFF}
SELECT LTRIM(RTRIM(ITM.strDescription))+'_'+LTRIM(agfml_seq_no)
,ITM.[intItemId]
,UOM.dblUnitQty--[dblQuantity]
,UOM.intItemUOMId--[intItemUOMId]
,LOC.intCompanyLocationId--[intLocationId]
,1--[intVersionNo]
,(select intRecipeTypeId from tblMFRecipeType where strName = 'By Quantity')--[intRecipeTypeId]
,(select intManufacturingProcessId from tblMFManufacturingProcess where strProcessName= 'Blending')--[intManufacturingProcessId]
,1--[ysnActive]
,0--[ysnImportOverride]
,0--[ysnAutoBlend]
,1--@EntityId--[intCreatedUserId]
,(CASE WHEN ISDATE(FRM.agfml_user_rev_dt) = 1 THEN CONVERT(DATE, CAST(FRM.agfml_user_rev_dt AS CHAR(12)), 112) ELSE GETDATE() END)--,[dtmCreated]
,1--@EntityId--[intLastModifiedUserId]
,(CASE WHEN ISDATE(FRM.agfml_user_rev_dt) = 1 THEN CONVERT(DATE, CAST(FRM.agfml_user_rev_dt AS CHAR(12)), 112) ELSE GETDATE() END)--[dtmLastModified]
,1--[intConcurrencyId]
FROM agfmlmst FRM
INNER JOIN agitmmst OITM ON OITM.agitm_no = FRM.agfml_itm_no AND OITM.agitm_loc_no = FRM.agfml_loc_no
INNER JOIN tblICItem ITM ON ITM.strItemNo COLLATE SQL_Latin1_General_CP1_CS_AS = FRM.agfml_itm_no COLLATE SQL_Latin1_General_CP1_CS_AS
INNER JOIN tblSMCompanyLocation LOC ON LOC.strLocationNumber COLLATE SQL_Latin1_General_CP1_CS_AS = FRM.agfml_loc_no COLLATE SQL_Latin1_General_CP1_CS_AS
INNER JOIN tblICUnitMeasure UM ON Upper(UM.strUnitMeasure) COLLATE SQL_Latin1_General_CP1_CS_AS = Upper(OITM.agitm_un_desc) COLLATE SQL_Latin1_General_CP1_CS_AS
INNER JOIN tblICItemUOM UOM ON UOM.intItemId = ITM.intItemId AND UOM.intUnitMeasureId = UM.intUnitMeasureId
{panel}
|