BCT_MG_PID_VW

(SQL View)
 Index Back

Val PIDs for Rec Assy Srl page

View of valid PIDs for Record Assembly Serial page

SELECT A.BUSINESS_UNIT , A.PRODUCTION_ID , A.PROD_STATUS , A.PRDN_AREA_CODE , A.INV_ITEM_ID , A.NEW_START_DATE , A.NEW_END_DATE , A.CONFIG_CODE FROM PS_SF_PRDNID_HEADR A WHERE A.MA_PRDN_ID_FLG = 'Y' AND A.PROD_STATUS >= '15' AND A.PROD_STATUS < '40' AND A.PRODUCTION_TYPE = 'PR' AND A.SERIAL_IN_PRDN = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
3 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
4 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area

Prompt Table: SF_PRDN_AREA

5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: SF_PA_IT_ID_VW

6 NEW_START_DATE Date(10) DATE Start Date
7 NEW_END_DATE Date(10) DATE Due Date
8 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

Prompt Table: CP_CONFIG_VW