SF_COMPLST_VW

(SQL View)
 Index Back

Prod ID Component List View

971112 cam (CN# MG750-6.0) : Add SF_QTY_PER and SOURCE_CODE to view. CN#SF750-1.1 ARG 11/18/97 - Removed Issue_loc_qty 01/21/99 MDS CN#EN800-1.0: Added MG_ORIG_COMP_ID. 04/15/99 ST CN# EN800-1.0 Added Teardown_flag, MG_ORIG_CURSCHED_QTY, PARENT_ITEM_ID 09/28/99 MDS CN#EN800-1.0: Made OP_SEQUENCE, MG_ORIG_COMP_ID & QTY_CODE key fields so that component list inquiry processes attachments correctly.

SELECT a.BUSINESS_UNIT , a.PRODUCTION_ID , a.COMPONENT_ID , a.OP_SEQUENCE , a.MG_ORIG_COMP_ID , a.QTY_CODE , b.PRDN_AREA_CODE , b.INV_ITEM_ID , b.PROD_STATUS , a.SF_QTY_PER , a.YIELD , a.CURR_SCHED_QTY , a.PEND_CONSUME_QTY , a.PEND_LOSS_QTY , a.PICK_QTY , a.ISSUE_QTY , a.YIELD_QTY , a.ISSUE_METHOD , a.NON_OWN_FLAG , a.CONFIG_CODE , a.SOURCE_CODE , a.TEARDOWN_FLAG , a.TEXT254 , a.MG_ORIG_QTY_PER , a.PARENT_ITEM_ID FROM PS_SF_COMP_LIST a , ps_sf_prdnid_headr b WHERE a.business_unit = b.business_unit AND a.production_id = b.production_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUMGOP_NONVW

2 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID

Prompt Table: SF_COMP_PID_VW

3 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.

Prompt Table: INV_ITEMS

4 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
5 MG_ORIG_COMP_ID Character(18) VARCHAR2(18) NOT NULL original component ID
6 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
7 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
8 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
9 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
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 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
13 PEND_CONSUME_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL 10/12/99 SCC CN#SF800-9.0: Added label id TO_PEND_CONSUME
14 PEND_LOSS_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL 10/12/99 SCC CN#SF800-9.0: Added label id TO_PEND_LOSS
15 PICK_QTY Number(12,4) DECIMAL(11,4) NOT NULL Pending Pick Quantity
16 ISSUE_QTY Number(12,4) DECIMAL(11,4) NOT NULL 07/28/99 SCC CN#SF800-9.0: Added label id TO_ISSUE_QTY
17 YIELD_QTY Number(12,4) DECIMAL(11,4) NOT NULL 10/12/99 SCC CN#SF800-9.0: Added label id TO_YIELD_QTY
18 ISSUE_METHOD Character(4) VARCHAR2(4) NOT NULL Component Issue Method
COM=Use Comp.
ISS=Issue
KIT=Kit
REPL=Replenish
19 NON_OWN_FLAG Character(1) VARCHAR2(1) NOT NULL 07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No
Y=Yes

Y/N Table Edit

20 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
21 SOURCE_CODE Character(2) VARCHAR2(2) NOT NULL 8/5/97 lee - inactivated source code 4 - service
1=Make
2=Buy
3=Expense
4=Service
5=Floor Stock
6=Planning
22 TEARDOWN_FLAG Character(1) VARCHAR2(1) NOT NULL 01/28/99 jnw (CN#SF800-13) added field

Y/N Table Edit

23 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text
24 MG_ORIG_QTY_PER Number(16,10) DECIMAL(15,10) NOT NULL original qty per
25 PARENT_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Parent Item ID