SF_SRH_COMP_VW

(SQL View)
Index Back

Comp Mtnce: Gen View by PID

12/18/98 lee 8.0 enhancement force rank #1785. Sort by PID in descending order. 01/20/1999 rag (CN#PL800-1) Included firmed status 5/28/99 SPL CN# MG800-11.0 Added configuration code to record. 11/20/00 ST (#5619501) - Modified Prdn Area Code prompt table to use SF_PRDN_AREA instead of SF_SRH_COMP_VW2.

SELECT a.business_unit , a.production_id , a.prod_status , a.prdn_area_code , a.inv_item_id , a.production_type , a.new_start_date , a.new_end_date , a.config_code FROM PS_SF_PRDNID_HEADR a WHERE a.ma_prdn_id_flg = 'Y' AND (a.prod_status = '20' OR a.prod_status = '15' OR a.prod_status = '30')

# 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_COMP_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_PRDN_AREA

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

Prompt Table: SF_SRH_COMP_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