PL_PROP_LST_VW

(SQL View)
 Index Back

PL_PROP_LST_VW

PL_PROP_LST_VW

SELECT A.PROBINST , A.BUSINESS_UNIT , A.PRODUCTION_ID , A.OP_SEQUENCE , A.PLAN_START_DTTM , A.PLAN_END_DTTM , B.INV_ITEM_ID , B.CONFIG_CODE , B.PROD_STATUS , A.PLAN_FROZEN_FLG ,'N' , B.PLAN_END_DTTM , B.NEW_PRDN_QTY FROM PS_PL_PR_OP_LIST A , PS_PL_PRDNID_HEADR B WHERE A.PROBINST = B.PROBINST AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PRODUCTION_ID = B.PRODUCTION_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 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
4 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
5 PLAN_START_DTTM DateTime(26) TIMESTAMP 08/29/01 EGS (CN#PL900-1): Added.
6 PLAN_END_DTTM DateTime(26) TIMESTAMP 08/29/01 EGS (CN#PL900-1): Added.
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
8 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
9 PL_SC_ORDER_STATUS Character(2) VARCHAR2(2) NOT NULL PL_SC_ORDER_STATUS
05=Planned
10=Entered
15=Firmed
20=Released
30=In Process
40=Pending Complete
50=Completed
60=Open
70=Active
75=Picked
77=Received
80=Intransit
85=Dispatched
90=Canceled
95=Closed
10 PLAN_FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL 11/01/01 PCL (CN#PL900-1): Updated
N=No
Y=Yes
11 FLAG_PLNPROD Character(1) VARCHAR2(1) NOT NULL FLAG_PLNPROD
12 PLAN_DUE_DTTM DateTime(26) TIMESTAMP Planning Due Date/Time
13 REMAINING_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL 08/16/01 JNW (CN#PL900-1.0): Added