IN_SDA_MG_S_VW2

(SQL View)
 Index Back

Sup/Dmd Mfg Supply - Op list

Prdn supply analytic view - operations exist. Includes status '10' to '30'.

SELECT H.BUSINESS_UNIT , H.BUSINESS_UNIT , H.PRDN_AREA_CODE , O.MG_OUTPUT_ITEM , O.MG_OUTPUT_ITEM , O.MG_OUTPUT_TYPE , H.PRODUCTION_ID , H.PROD_STATUS , H.PRODUCTION_TYPE , H.MA_PRDN_ID_FLG , H.PRDN_DUE_DATE , H.PRDN_DUE_SHIFT , H.BOM_CODE , H.RTG_CODE , H.REVISION , H.NEW_START_DATE , H.NEW_END_DATE , H.NEW_PRDN_QTY , O.MG_OUTPUT_SCHD_QTY , O.COMPLETED_QTY , CASE WHEN O.MG_OUTPUT_TYPE = 'CP' THEN H.SCRAP_QTY ELSE 0 END , O.PEG_STATUS , H.BUSINESS_UNIT_OM , H.ORDER_NO , H.ORDER_INT_LINE_NO , H.CONFIG_CODE , M.INV_ITEM_GROUP , M.INV_PROD_FAM_CD , M.UNIT_MEASURE_STD FROM PS_SF_PRDNID_HEADR H , PS_SF_OUTPUT_LIST O , PS_SF_OP_LIST L , PS_MASTER_ITEM_TBL M , PS_SET_CNTRL_REC C WHERE H.PROD_STATUS < '40' AND O.BUSINESS_UNIT = H.BUSINESS_UNIT AND O.PRODUCTION_ID = H.PRODUCTION_ID AND L.BUSINESS_UNIT = H.BUSINESS_UNIT AND L.PRODUCTION_ID = H.PRODUCTION_ID AND O.MG_OUTPUT_TYPE <> 'WB' AND O.OP_SEQUENCE > 0 AND O.OP_SEQUENCE = L.OP_SEQUENCE AND M.SETID = C.SETID AND C.SETCNTRLVALUE = O.BUSINESS_UNIT AND C.RECNAME = 'MASTER_ITEM_TBL' AND M.INV_ITEM_ID = O.MG_OUTPUT_ITEM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BUSINESS_UNIT_MG Character(5) VARCHAR2(5) NOT NULL Business Unit Manufacturing
3 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
5 INV_ITEM_ID3 Character(18) VARCHAR2(18) NOT NULL Item ID
6 MG_OUTPUT_TYPE Character(2) VARCHAR2(2) NOT NULL 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item type on a Bill of Materials. The type could represent either a co-product (primary or secondary) or a by-product (waste or recycle). 11/23/98 (CN#SF800-13) JNW added teardown xlat
CP=Primary
CS=Co-Product
RB=Recycle
TD=Teardown
WB=Waste
7 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
8 PROD_STATUS Character(2) VARCHAR2(2) NOT NULL Production Status
10=Entered
15=Firmed
20=Released
30=In Process
40=Pend Cmpl
50=Completed
60=Clsd/Labor
70=Clsd/Acctg
90=Canceled
9 PRODUCTION_TYPE Character(2) VARCHAR2(2) NOT NULL JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production
RW=Rework
SV=Service
TD=Teardown
10 MA_PRDN_ID_FLG Character(1) VARCHAR2(1) NOT NULL 10/18/99 SCC CN#IC800: Add label MAINTAIN_PID
N=No
Y=Yes
11 PRDN_DUE_DATE Date(10) DATE Prdn Due Date
12 PRDN_DUE_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Prdn Due Shift
13 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
14 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
15 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
16 NEW_START_DATE Date(10) DATE Start Date
17 NEW_END_DATE Date(10) DATE Due Date
18 NEW_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Production Start Qty
19 EXPECTED_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Production End Qty
20 COMPLETED_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Completed Qty
21 SCRAP_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Scrapped Qty
22 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged
23 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
24 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
25 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
26 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

Prompt Table: CP_CONFIG_VW

27 INV_ITEM_GROUP3 Character(15) VARCHAR2(15) NOT NULL Item Group
28 INV_PROD_FAM_CD3 Character(10) VARCHAR2(10) NOT NULL Item Family
29 UNIT_MEASURE_STD3 Character(3) VARCHAR2(3) NOT NULL Standard UOM