IN_SDWCPI1_OPRV

(SQL View)
 Index Back

Pids past due date view

Pid past due - realtime

SELECT 'IN_SDWC_PID_PAST_DUE' , 'SUP_DMD_ALERTS' , 0 , %subrec(SF_PRD_NKEY_SBR, H) , H.PROD_STATUS , H.INV_ITEM_ID , H.PRDN_AREA_CODE , H.EXPECTED_PRDN_QTY , H.COMPLETED_QTY , H.SCRAP_QTY , H.EXPECTED_PRDN_QTY - H.COMPLETED_QTY , H.BUSINESS_UNIT %Concat '~' %Concat H.PRODUCTION_ID , H.NEW_END_DATE , H.MA_PRDN_ID_FLG , H.PRDN_DUE_DATE , H.PRDN_DUE_SHIFT , H.BOM_CODE , H.RTG_CODE , H.REVISION , ' ' , 0 , '0' , 0 , S.OPRID FROM PS_SF_PRDNID_HEADR H , PS_SEC_BU_OPR S , PS_SEC_BU_OPR S1 WHERE H.PROD_STATUS IN ('15','20','30','40') AND H.NEW_END_DATE < %CurrentDateIn AND (H.EXPECTED_PRDN_QTY - H.COMPLETED_QTY) <> 0 AND S.BUSINESS_UNIT = H.BUSINESS_UNIT AND S1.OPRID = S.OPRID AND S1.BUSINESS_UNIT = H.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOEN_PRCS_NAME Character(30) VARCHAR2(30) NOT NULL EOEN Process Name
2 EOEN_CATEGORY Character(30) VARCHAR2(30) NOT NULL EOEN Category
3 SEQ_NBR_EOEN Number(15,0) DECIMAL(15) NOT NULL EOEN Sequence Nbr
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
6 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
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
8 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
9 EXPECTED_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Production End Qty
10 COMPLETED_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Completed Qty
11 SCRAP_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Scrapped Qty
12 REMAINING_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL 08/16/01 JNW (CN#PL900-1.0): Added
13 IN_SDWC_HASH_KEY Character(60) VARCHAR2(60) NOT NULL Hash
14 NEW_END_DATE Date(10) DATE Due Date
15 MA_PRDN_ID_FLG Character(1) VARCHAR2(1) NOT NULL 10/18/99 SCC CN#IC800: Add label MAINTAIN_PID
N=No
Y=Yes
16 PRDN_DUE_DATE Date(10) DATE Prdn Due Date
17 PRDN_DUE_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Prdn Due Shift
18 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
19 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
20 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
21 PRDN_AREA_PB Character(1) VARCHAR2(1) NOT NULL Production Area
22 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base
23 EOEN_STATUS Character(1) VARCHAR2(1) NOT NULL EOEN Status
0=Open
1=Closed
24 ROWNBR Number(7,0) INTEGER NOT NULL Row number
25 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).