IN_SDWCPID_OPRV

(SQL View)
 Index Back

Pids past due date view


SELECT %subrec(EOEN_LOG_KEY, P) , %subrec(IN_SDWC_CTX_SBR, P) , %subrec(SF_PRD_NKEY_SBR, P) , 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 , P.IN_SDWC_HASH_KEY , 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 , D.EOEN_STATUS , 0 , S.OPRID FROM PS_IN_SDWC_PID_CTX P , PS_EOEN_DASHBRD D , PS_SF_PRDNID_HEADR H , PS_SEC_BU_OPR S WHERE %Join(COMMON_KEYS, IN_SDWC_PID_CTX P, EOEN_DASHBRD D) AND D.EOEN_STATUS = '0' AND S.BUSINESS_UNIT = P.BUSINESS_UNIT AND H.BUSINESS_UNIT = P.BUSINESS_UNIT AND H.PRODUCTION_ID = P.PRODUCTION_ID AND H.PROD_STATUS IN ('15','20','30','40') AND H.EXPECTED_PRDN_QTY - H.COMPLETED_QTY <> 0

# 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 EOEN_EMAIL_GROUP Number(10,0) DECIMAL(10) NOT NULL Email group id
5 EOEN_NOTIFY_TO Character(30) VARCHAR2(30) NOT NULL Notification receiver
6 EMAIL_ADDRESS Long Character CLOB Email Addresses
7 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
8 EOEN_LAST_DTTIME DateTime(26) TIMESTAMP Last Date Time
9 EOEN_EMAIL_SUBJECT Character(100) VARCHAR2(100) NOT NULL EOEN Email subject field
10 EOEC_UL_ID Character(30) VARCHAR2(30) NOT NULL Identifies the user list to be used when creating the approval process.
11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
12 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
13 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
14 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
15 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
16 EXPECTED_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Production End Qty
17 COMPLETED_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Completed Qty
18 SCRAP_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Scrapped Qty
19 REMAINING_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL 08/16/01 JNW (CN#PL900-1.0): Added
20 IN_SDWC_HASH_KEY Character(60) VARCHAR2(60) NOT NULL Hash
21 NEW_END_DATE Date(10) DATE Due Date
22 MA_PRDN_ID_FLG Character(1) VARCHAR2(1) NOT NULL 10/18/99 SCC CN#IC800: Add label MAINTAIN_PID
N=No
Y=Yes
23 PRDN_DUE_DATE Date(10) DATE Prdn Due Date
24 PRDN_DUE_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Prdn Due Shift
25 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
26 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
27 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
28 PRDN_AREA_PB Character(1) VARCHAR2(1) NOT NULL Production Area
29 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base
30 EOEN_STATUS Character(1) VARCHAR2(1) NOT NULL EOEN Status
0=Open
1=Closed
31 ROWNBR Number(7,0) INTEGER NOT NULL Row number
32 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).