PL_PLNPRD_COVW

(SQL View)
 Index Back

Planned Prod CompOp List

Same as PL_PLNPRD_C_VW, except it also joins in PL_PLNPRD_OP table to see if there is a PLAN_START_DTTM.

SELECT %subrec(PL_PLNPRD_C_SBR, B) , A.PL_PLAN_STATUS , C.PLAN_START_DTTM , A.PLAN_END_DTTM , A.FROZEN_SUBSTITUTES , A.PRIORITY_RANK , A.INCL_QTY_FLG , A.INV_ITEM_ID , A.NEW_PRDN_QTY , A.RTG_CODE , A.BOM_CODE , A.PLAN_FROZEN_FLG FROM PS_PL_PLNPRD_HEADR A , PS_PL_PLNPRD_COMP B , PS_PL_PLNPRD_OP C WHERE A.PROBINST = B.PROBINST AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PL_SEQ_NBR = B.PL_SEQ_NBR AND B.PROBINST = C.PROBINST AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.PL_SEQ_NBR = C.PL_SEQ_NBR AND B.OP_SEQUENCE = C.OP_SEQUENCE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
2 PL_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL 01/09/02 EGS (CN#PL900-1): Added
3 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence

Prompt Table: PL_PP_C_OP_VW

4 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
5 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

Prompt Table: PL_PI_ITMCFG_VW

6 MG_ORIG_COMP_ID Character(18) VARCHAR2(18) NOT NULL original component ID
7 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
9 CURR_SCHED_QTY Number(12,4) DECIMAL(11,4) NOT NULL 07/28/99 SCC CN#SF800-9.0: Added label id TO_CURR_SCHED
10 SF_QTY_PER Number(16,10) DECIMAL(15,10) NOT NULL 07/06/99 SCC CN# SF800-9.0: Added label Quantity
11 YIELD Number(8,4) DECIMAL(7,4) NOT NULL Component Yield

Default Value: 100

12 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
13 PL_PLAN_STATUS Character(2) VARCHAR2(2) NOT NULL 11/01/01 PCL (CN#PL900-1): Added
05=Planned
15=Firmed
90=Canceled
14 PLAN_START_DTTM DateTime(26) TIMESTAMP 08/29/01 EGS (CN#PL900-1): Added.
15 PLAN_END_DTTM DateTime(26) TIMESTAMP 08/29/01 EGS (CN#PL900-1): Added.
16 FROZEN_SUBSTITUTES Character(1) VARCHAR2(1) NOT NULL Frozen Substitutes
B=Both
N=No
Y=Yes

Y/N Table Edit

17 PRIORITY_RANK Number(3,0) SMALLINT NOT NULL Priority rank value of demand prioritization rule
18 INCL_QTY_FLG Character(1) VARCHAR2(1) NOT NULL Include Quantity
B=Both
N=No
Y=Yes

Y/N Table Edit

19 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
20 NEW_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Production Start Qty
21 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
22 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
23 PLAN_FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL 11/01/01 PCL (CN#PL900-1): Updated
N=No
Y=Yes

Y/N Table Edit