SF_SPLIT_ID_VW

(SQL View)
 Index Back

Production IDs with Splits

06/02/99 SCC CN#SF800-9.0: Production ID with Split History

SELECT a.business_unit , a.production_id , a.prod_status , a.prdn_area_code , a.inv_item_id , a.production_type , a.config_code FROM ps_sf_prdnid_headr a WHERE a.ma_prdn_id_flg = 'Y' AND (EXISTS ( SELECT 'x' FROM PS_SF_SPLIT_HIST b WHERE a.business_unit = b.business_unit AND a.production_id = b.from_prdn_id) OR EXISTS ( SELECT 'x' FROM PS_SF_SPLIT_HIST c WHERE a.business_unit = c.business_unit AND a.production_id = c.to_prdn_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

Default Value: NEXT

Prompt Table: SF_SPLIT_ID_VW

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_PA_IT_ID_VW

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 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

Prompt Table: CP_CONFIG_VW