PL_PR_OUTRB_OVW

(SQL View)
Index Back

PL Prod Output List Opt Tbl

PL Prod Output List Opt Tbl

SELECT %subrec(PL_PR_OUT_L_SBR, B) , A.PLAN_START_DTTM , C.PLAN_END_DTTM , A.PLAN_FROZEN_FLG , A.INCL_QTY_FLG , A.PROD_STATUS , A.ORIG_START_DTTM , A.ORIG_END_DTTM , A.PRIORITY_RANK , A.APPROVED_FLG , A.INV_ITEM_ID , A.PRODUCTION_TYPE , A.PRDN_AREA_CODE , A.NEW_PRDN_QTY , A.ORIG_PRDN_QTY , A.SCRAP_QTY , A.ORIG_SCRAP_QTY , A.BOM_CODE , A.RTG_CODE , A.FROZEN_SUBSTITUTES , A.CUM_YIELD , A.EXPECTED_PRDN_QTY FROM PS_PL_PRDNID_HEADR A , PS_PL_PR_OUT_LIST B , PS_PL_PR_OP_LIST C WHERE A.PROBINST = B.PROBINST AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PRODUCTION_ID = B.PRODUCTION_ID AND B.PROBINST = C.PROBINST AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.PRODUCTION_ID = C.PRODUCTION_ID AND B.OP_SEQUENCE = C.OP_SEQUENCE AND B.MG_OUTPUT_TYPE = 'RB'

# 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 MG_OUTPUT_TYPE Character(2) VARCHAR2(2) NOT NULL 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item type on a Bill of Materials. The type could represent either a co-product (primary or secondary) or a by-product (waste or recycle). 11/23/98 (CN#SF800-13) JNW added teardown xlat
CP=Primary
CS=Co-Product
RB=Recycle
TD=Teardown
WB=Waste
5 MG_OUTPUT_ITEM Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id. 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item number on a Bill of Materials. This item may be either a co-product or a by-product on the BOM. The output type field determines which one it represents. There should always be at least one output item on the BOM at all times; this output item is the same as the BOMs item id.
6 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
7 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence

Prompt Table: PL_PR_T_OP_VW

8 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
9 MG_OUTPUT_SCHD_QTY Number(12,4) DECIMAL(11,4) NOT NULL Schedule qty
10 MG_OUTPUT_RES_PCT Number(3,0) SMALLINT NOT NULL 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item's resource allocation percentage on a Bill of Material. Since it is a percentage, it cannot store a value greater than 100. It is used to determine what percentage of the inputs (components) on the BOM are used to produce the output (co-product).
11 COMPLETED_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Completed Qty
12 REMAINING_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL 08/16/01 JNW (CN#PL900-1.0): Added
13 ORIG_OUT_SCHED_QTY Number(12,4) DECIMAL(11,4) NOT NULL 08/29/01 EGS (CN#PL900-1): Added.
14 ORIG_COMP_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL 08/29/01 EGS (CN#PL900-1): Added.
15 INCR_REL_TYPE Character(1) VARCHAR2(1) NOT NULL 07/22/02 EGS (CN#PL880-1): Added
1=None
2=Over Time

Default Value: 1

16 INCR_REL_OFFSET Number(16,4) DECIMAL(15,4) NOT NULL 07/22/02 EGS (CN#PL880-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

Default Value: 40

18 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
19 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
20 PLAN_START_DTTM DateTime(26) TIMESTAMP 08/29/01 EGS (CN#PL900-1): Added.
21 PLAN_END_DTTM DateTime(26) TIMESTAMP 08/29/01 EGS (CN#PL900-1): Added.
22 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

23 INCL_QTY_FLG Character(1) VARCHAR2(1) NOT NULL Include Quantity
B=Both
N=No
Y=Yes

Y/N Table Edit

24 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
25 ORIG_START_DTTM DateTime(26) TIMESTAMP 04/29/02 EGS (CN#PL900-1): Added
26 ORIG_END_DTTM DateTime(26) TIMESTAMP 04/29/02 EGS (CN#PL900-1): Added.
27 PRIORITY_RANK Number(3,0) SMALLINT NOT NULL Priority rank value of demand prioritization rule
28 APPROVED_FLG Character(1) VARCHAR2(1) NOT NULL Approved by Auditor
D=Denied
N=Not Approved
Y=Approved

Y/N Table Edit

29 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
30 PRODUCTION_TYPE Character(2) VARCHAR2(2) NOT NULL JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production
RW=Rework
SV=Service
TD=Teardown
31 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
32 NEW_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Production Start Qty
33 ORIG_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Original Production Qty
34 SCRAP_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Scrapped Qty
35 ORIG_SCRAP_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL 08/29/01 EGS (CN#PL900-1): Added.
36 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
37 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
38 FROZEN_SUBSTITUTES Character(1) VARCHAR2(1) NOT NULL Frozen Substitutes
B=Both
N=No
Y=Yes

Y/N Table Edit

39 CUM_YIELD Number(8,4) DECIMAL(7,4) NOT NULL Expected Yield %
40 EXPECTED_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Production End Qty