SF_KIT_1_BC_VW

(SQL View)
 Index Back

BCT Prdn ID Kit View 1

971209 cam (CN# SF750-10.0) : PID view for barcode processing limited to PID with status = 20 or 30 and at least one component on list is specified as 'KIT' and a shortage exists. 980120 cam (CN# SF750-10.0) : Replace PRODUCTION_ID with TO_PRODUCTION_ID and INV_ITEM_ID with COMPONENT_ID to facilitate additional view. 980212 cam (CN# SF750-10.0) : Rename to SF_KIT_1_BC_VW. 04/22/03 PWF Modified view to use %decmult and %decdiv.

SELECT DISTINCT a.business_unit , a.production_id , a.prod_status , a.prdn_area_code , b.component_id , a.production_type FROM ps_sf_prdnid_headr a , PS_SF_COMP_LIST b WHERE a.ma_prdn_id_flg = 'Y' AND a.prod_status IN ('20', '30') AND a.business_unit = b.business_unit AND a.production_id = b.production_id AND b.issue_method = 'KIT' AND ((b.pend_consume_qty + b.pend_loss_qty > 0) OR ((b.yield_qty <= %DecMult (b.curr_sched_qty, (1 - (%DecDiv (b.yield, 100))))) AND (b.curr_sched_qty - b.issue_qty - b.yield_qty > 0)) OR ((b.yield_qty > %DecMult (b.curr_sched_qty, (1 - (%DecDiv (b.yield, 100))))) AND (b.curr_sched_qty - b.issue_qty - %DecMult (b.curr_sched_qty,(1 - (%DecDiv (b.yield, 100)))) > 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

2 TO_PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL To Production ID
3 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
4 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
5 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
6 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

Default Value: PR