SF_COMP_PEND_VW

(SQL View)
 Index Back

Component Existing Pending Vw

11/13/97 DDW (CN#MG750-7.0) -Added source_code for floor stock enhancement CN#SF750-1.1 ARG 11/18/97 - Removed Issue_loc_qty 01/21/1999 MDS CN# EN800-1.0: Added MG_ORIG_COMP_ID, MG_ORIG_CURSCH_QTY and PARENT_ITEM_ID. 10/04/99 ST CN# EN800-13.0 Modified edittable17 to 21 on Op_Sequence

SELECT a.business_unit , a.inv_item_id , a.prdn_area_code , a.production_id , b.component_id , b.op_sequence , b.mg_orig_comp_id , b.qty_code , a.revision , a.prdn_due_date , b.sf_qty_per , b.yield , b.sched_qty , b.curr_sched_qty , b.mg_orig_qty_per , b.issue_qty , b.yield_qty , b.pend_consume_qty , b.pend_loss_qty , b.pick_qty , b.parent_item_id , b.transaction_flag , b.issue_method , b.non_own_flag , b.config_code , b.source_code , b.text254 , 'N' FROM ps_sf_prdnid_headr a , PS_SF_COMP_LIST b WHERE a.business_unit = b.business_unit AND a.production_id = b.production_id AND a.ma_prdn_id_flg = 'N' AND (b.pend_consume_qty <> 0 OR b.pend_loss_qty <> 0)

# 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 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
4 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID

Prompt Table: SF_COMP_MTN_VW

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

Prompt Table: MG_ITEM_APPR_VW

6 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence

Prompt Table: %EDITTABLE21

7 MG_ORIG_COMP_ID Character(18) VARCHAR2(18) NOT NULL original component ID
8 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
9 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
10 PRDN_DUE_DATE Date(10) DATE Prdn Due Date
11 SF_QTY_PER Number(16,10) DECIMAL(15,10) NOT NULL 07/06/99 SCC CN# SF800-9.0: Added label Quantity
12 YIELD Number(8,4) DECIMAL(7,4) NOT NULL Component Yield
13 SCHED_QTY Number(12,4) DECIMAL(11,4) NOT NULL Component Scheduled Qty
14 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
15 MG_ORIG_QTY_PER Number(16,10) DECIMAL(15,10) NOT NULL original qty per
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 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
19 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
20 PICK_QTY Number(12,4) DECIMAL(11,4) NOT NULL Pending Pick Quantity
21 PARENT_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Parent Item ID
22 TRANSACTION_FLAG Character(1) VARCHAR2(1) NOT NULL Component Issue/Receipt Flag
1=Issue Material from Stock
2=Return Material to Stock
23 ISSUE_METHOD Character(4) VARCHAR2(4) NOT NULL Component Issue Method
COM=Use Comp.
ISS=Issue
KIT=Kit
REPL=Replenish
24 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

25 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

Prompt Table: CP_CONFIG_VW

26 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
27 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text
28 MATCH_FLG Character(1) VARCHAR2(1) NOT NULL Match FLag