PL_CNCL_PROD_VW

(SQL View)
 Index Back

Cancelled Production

04/11/03 JC (ICE582988000): Added

SELECT A.PROBINST , A.BUSINESS_UNIT , A.INV_ITEM_ID , C.CFG_CODE_OPT , A.CONFIG_CODE , B.REMAINING_QTY , C.UNIT_MEASURE_STD , 0 , 0 , ' ' , A.PRODUCTION_ID , A.PROD_STATUS , A.ORIG_START_DTTM , A.ORIG_END_DTTM , A.PLAN_START_DTTM , A.PLAN_END_DTTM , B.PEG_STATUS FROM PS_PL_PRDNID_HEADR A , PS_PL_PR_OUT_LIST B , PS_PL_BU_ITEMS C WHERE A.PROBINST = B.PROBINST AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PRODUCTION_ID = B.PRODUCTION_ID AND B.MG_OUTPUT_TYPE = 'CP' AND B.MG_OUTPUT_ITEM = A.INV_ITEM_ID AND A.INCL_QTY_FLG = 'Y' AND A.PROD_STATUS = '90' AND C.PROBINST = A.PROBINST AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.INV_ITEM_ID = A.INV_ITEM_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDITTABLE2

4 CFG_CODE_OPT Character(1) VARCHAR2(1) NOT NULL Configuration Code Generation
B=Both
N=No
Y=Yes
5 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
6 REMAINING_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL 08/16/01 JNW (CN#PL900-1.0): Added
7 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
8 RESCHED_DAYS_IN Number(5,0) INTEGER NOT NULL 10/22/02 JC (CN#PL880-1):Added
9 RESCHED_DAYS_OUT Number(5,0) INTEGER NOT NULL 10/22/02 JC (CN#PL880-1):Added
10 DETAIL_BTN Character(1) VARCHAR2(1) NOT NULL Details
11 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
12 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
13 ORIG_START_DTTM DateTime(26) TIMESTAMP 04/29/02 EGS (CN#PL900-1): Added
14 ORIG_END_DTTM DateTime(26) TIMESTAMP 04/29/02 EGS (CN#PL900-1): Added.
15 PLAN_START_DTTM DateTime(26) TIMESTAMP 08/29/01 EGS (CN#PL900-1): Added.
16 PLAN_END_DTTM DateTime(26) TIMESTAMP 08/29/01 EGS (CN#PL900-1): Added.
17 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged