Attachment 82307 Details for Bug 66765 – Correct source file for the query

Correct source file for the query

zDP_IV00102SS_1.txt (text/plain), 1.50 KB, created by Tim Jowers on 2013-07-11 00:36:23 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Tim Jowers

Created: 2013-07-11 00:36:23 UTC

Size: 1.50 KB

patch

obsolete

>USE [CPEC]
>GO
>/****** Object:  StoredProcedure [dbo].[zDP_IV00102SS_1]    Script Date: 7/10/2013 8:34:13 PM ******/
>SET ANSI_NULLS ON
>GO
>SET QUOTED_IDENTIFIER OFF
>GO
>ALTER PROC [dbo].[zDP_IV00102SS_1] (@ITEMNMBR char(31), @RCRDTYPE smallint, @LOCNCODE char(11)) AS /* 11.00.0218.000 */ set nocount on SELECT TOP 1  ITEMNMBR, LOCNCODE, BINNMBR, RCRDTYPE, PRIMVNDR, ITMFRFLG, BGNGQTY, LSORDQTY, LRCPTQTY, LSTORDDT, LSORDVND, LSRCPTDT, QTYRQSTN, QTYONORD, QTYBKORD, QTY_Drop_Shipped, QTYINUSE, QTYINSVC, QTYRTRND, QTYDMGED, QTYONHND, ATYALLOC, QTYCOMTD, QTYSOLD, NXTCNTDT, NXTCNTTM, LSTCNTDT, LSTCNTTM, STCKCNTINTRVL, Landed_Cost_Group_ID, BUYERID, PLANNERID, ORDERPOLICY, FXDORDRQTY, ORDRPNTQTY, NMBROFDYS, MNMMORDRQTY, MXMMORDRQTY, ORDERMULTIPLE, REPLENISHMENTMETHOD, SHRINKAGEFACTOR, PRCHSNGLDTM, MNFCTRNGFXDLDTM, MNFCTRNGVRBLLDTM, STAGINGLDTME, PLNNNGTMFNCDYS, DMNDTMFNCPRDS, INCLDDINPLNNNG, CALCULATEATP, AUTOCHKATP, PLNFNLPAB, FRCSTCNSMPTNPRD, ORDRUPTOLVL, SFTYSTCKQTY, REORDERVARIANCE, PORECEIPTBIN, PORETRNBIN, SOFULFILLMENTBIN, SORETURNBIN, BOMRCPTBIN, MATERIALISSUEBIN, MORECEIPTBIN, REPAIRISSUESBIN, ReplenishmentLevel, POPOrderMethod, MasterLocationCode, POPVendorSelection, POPPricingSelection, PurchasePrice, IncludeAllocations, IncludeBackorders, IncludeRequisitions, PICKTICKETITEMOPT, INCLDMRPMOVEIN, INCLDMRPMOVEOUT, INCLDMRPCANCEL, Move_Out_Fence, DEX_ROW_ID FROM .IV00102 WHERE ITEMNMBR = @ITEMNMBR AND RCRDTYPE = @RCRDTYPE AND LOCNCODE = @LOCNCODE ORDER BY ITEMNMBR ASC, RCRDTYPE ASC, LOCNCODE ASC set nocount off

Actions: View

Attachments on bug 66765: 82267 | 82306 | 82307 | 150863