SF_PURGE_PID_VW

(SQL View)
 Index Back

Prdn Id PID Purge Sel View

03/18/03 PWF MG Archive Record

SELECT business_unit , production_id , prod_status , Prdn_area_code , inv_item_id , production_type , rtg_code , ref_routing_item , scheduling_method , new_start_date , new_start_time , new_start_shift , new_end_date , new_end_time , new_end_shift , revision , config_code FROM PS_SF_PRDNID_HEADR WHERE ma_prdn_id_flg = 'Y' AND PROD_STATUS IN ('70','90') AND NOT EXISTS ( SELECT 'X' FROM PS_SF_EARNCONCOSTB A WHERE A.PRODUCTION_ID = PS_SF_PRDNID_HEADR.PRODUCTION_ID AND A.BUSINESS_UNIT = PS_SF_PRDNID_HEADR.BUSINESS_UNIT AND A.POSTED_FLAG='N') AND NOT EXISTS ( SELECT 'X' FROM PS_SF_EARNCONCOST B WHERE B.PRODUCTION_ID = PS_SF_PRDNID_HEADR.PRODUCTION_ID AND B.BUSINESS_UNIT = PS_SF_PRDNID_HEADR.BUSINESS_UNIT AND B.POSTED_FLAG='N') AND NOT EXISTS ( SELECT 'X' FROM PS_SF_SCRAPCOSTB C WHERE C.PRODUCTION_ID = PS_SF_PRDNID_HEADR.PRODUCTION_ID AND C.BUSINESS_UNIT = PS_SF_PRDNID_HEADR.BUSINESS_UNIT AND C.POSTED_FLAG='N') AND NOT EXISTS ( SELECT 'X' FROM PS_SF_SCRAPCOST D WHERE D.PRODUCTION_ID = PS_SF_PRDNID_HEADR.PRODUCTION_ID AND D.BUSINESS_UNIT = PS_SF_PRDNID_HEADR.BUSINESS_UNIT AND D.POSTED_FLAG='N') AND NOT EXISTS ( SELECT 'X' FROM PS_SF_VARIANCES E WHERE E.PRODUCTION_ID = PS_SF_PRDNID_HEADR.PRODUCTION_ID AND E.BUSINESS_UNIT = PS_SF_PRDNID_HEADR.BUSINESS_UNIT AND E.POSTED_FLAG='N') AND NOT EXISTS ( SELECT 'X' FROM PS_SF_VARIANCESB F WHERE F.PRODUCTION_ID = PS_SF_PRDNID_HEADR.PRODUCTION_ID AND F.BUSINESS_UNIT = PS_SF_PRDNID_HEADR.BUSINESS_UNIT AND F.POSTED_FLAG='N')

# 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

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 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code

Prompt Table: EN_RTG_HDR_VW

8 REF_ROUTING_ITEM Character(18) VARCHAR2(18) NOT NULL Reference Routing Item
9 SCHEDULING_METHOD Character(3) VARCHAR2(3) NOT NULL Scheduling Method
BWD=Backward
FWD=Forward
10 NEW_START_DATE Date(10) DATE Start Date
11 NEW_START_TIME Time(15) TIMESTAMP Start Time
12 NEW_START_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Start Shift
13 NEW_END_DATE Date(10) DATE Due Date
14 NEW_END_TIME Time(15) TIMESTAMP Due Time
15 NEW_END_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Due Shift
16 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label

Prompt Table: EN_REV_SRCH

17 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

Prompt Table: CP_CONFIG_VW