SF_PRDN_ED1_VW5

(SQL View)
Index Back

SF Production End Date View


SELECT DISTINCT a.business_unit , a.prdn_area_code , a.inv_item_id , a.production_type , a.prdn_due_date , a.prdn_start_date , a.new_prdn_qty , a.expected_prdn_qty , a.prod_status , a.completed_qty , a.production_id FROM ps_sf_prdnid_headr a , ps_sf_variances b WHERE a.ma_prdn_id_flg = 'N' AND a.business_unit = b.business_unit AND a.production_id = b.production_id AND (EXISTS ( SELECT 'x' FROM ps_sf_vars_detail c WHERE a.business_unit = c.BUSINESS_UNIT AND a.production_id = c.production_id) OR EXISTS ( SELECT 'x' FROM PS_SF_CFGVAR_DET d WHERE a.business_unit = d.BUSINESS_UNIT AND a.production_id = d.PRODUCTION_ID))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 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
5 PRDN_DUE_DATE Date(10) DATE Prdn Due Date
6 PRDN_START_DATE Date(10) DATE Prdn Start Date
7 NEW_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Production Start Qty
8 EXPECTED_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Production End Qty
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 COMPLETED_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Completed Qty
11 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID