SF_SRH_OP_VW

(SQL View)
 Index Back

OP Mtnce: Gen View by PID

12/18/98 lee 8.0 enhancement force rank #1785. Sort by PID in descending order. 01/20/1998 Rag (CN#PL800-1) Included 'Firmed' Status 5/28/99 SPL CN# MG800-11.0 Added configuration code to record.

select g.business_unit, g.production_id, g.prod_status, g.prdn_area_code, g.inv_item_id, g.production_type, g.new_start_date, g.new_end_date, g.config_code from ps_sf_prdnid_headr g where g.ma_prdn_id_flg = 'Y' and ( (g.prod_status = '15' or g.prod_status = '20' ) or (g.prod_status = '30' and not ((g.completed_qty + g.scrap_qty) > 0 and not exists (select h.production_id from PS_SF_OP_LIST h where g.business_unit = h.business_unit and g.production_id = h.production_id)) )) and exists (select m.production_id from PS_SF_OP_LIST m where m.business_unit = g.business_unit and m.production_id = g.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_SRH_OP_VW1

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

Prompt Table: SF_SRH_OP_VW2

5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: SF_SRH_OP_VW3

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

7 NEW_START_DATE Date(10) DATE Start Date
8 NEW_END_DATE Date(10) DATE Due Date
9 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

Prompt Table: CP_CONFIG_VW