EN_OP_RESRC_VW

(SQL View)
Index Back

SF Op Rsrc/Area/Prd Header Vw

07/07/97 MEG CN# SF750-1.0: In view text, removed join to sf_prdn_area_it and get ma_prdn_id_flg from sf_prdnid_headr. 9/8/97 ebn CN#EN750-1.0 : Added Reference Routing Item for Master Routing Enhancement 7/29/98 rs CN# MG800-1.0 : Added Op_Start and Op_End Date/Time fields from Op List to merge the PID and Schedules scrolls into one grid in the Where Used panel .

select a.business_unit, a.crew_code, a.machine_code, a.tool_code, a.production_id, a.op_sequence, a.sf_resrc_type, b.prod_status, b.prdn_area_code, b.inv_item_id, b.production_type, b.rtg_code, b.ref_routing_item, b.scheduling_method, c.op_start_dt, c.op_start_shift, c.op_start_time, c.op_end_dt, c.op_end_shift, c.op_end_time, b.new_start_date, b.new_start_time, b.new_start_shift, b.new_end_date, b.new_end_time, b.new_end_shift, b.ma_prdn_id_flg from ps_sf_op_resrc a, ps_sf_prdnid_headr b, PS_SF_OP_LIST c where b.business_unit = a.business_unit and c.business_unit = a.business_unit and b.production_id=a.production_id and c.production_id=a.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 CREW_CODE Character(10) VARCHAR2(10) NOT NULL Crew Name
3 MACHINE_CODE Character(10) VARCHAR2(10) NOT NULL Machine Code
4 TOOL_CODE Character(10) VARCHAR2(10) NOT NULL Tool ID
5 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
6 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
7 SF_RESRC_TYPE Character(2) VARCHAR2(2) NOT NULL Resource Type
10=Crew
30=Machine
50=Tool
8 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
9 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area

Prompt Table: SF_PRDN_AREA

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

Prompt Table: SF_PRDN_AREA_IT

11 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

12 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code

Prompt Table: EN_RTG_HDR_VW

13 REF_ROUTING_ITEM Character(18) VARCHAR2(18) NOT NULL Reference Routing Item
14 SCHEDULING_METHOD Character(3) VARCHAR2(3) NOT NULL Scheduling Method
BWD=Backward
FWD=Forward
15 OP_START_DT Date(10) DATE Operation Start Date
16 OP_START_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Operation's Start Shift
17 OP_START_TIME Time(15) TIMESTAMP Operation's Start Time
18 OP_END_DT Date(10) DATE Operation Due Date
19 OP_END_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Operation's Due Shift
20 OP_END_TIME Time(15) TIMESTAMP Operation's Due Time
21 NEW_START_DATE Date(10) DATE Start Date
22 NEW_START_TIME Time(15) TIMESTAMP Start Time
23 NEW_START_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Start Shift
24 NEW_END_DATE Date(10) DATE Due Date
25 NEW_END_TIME Time(15) TIMESTAMP Due Time
26 NEW_END_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Due Shift
27 MA_PRDN_ID_FLG Character(1) VARCHAR2(1) NOT NULL 10/18/99 SCC CN#IC800: Add label MAINTAIN_PID
N=No
Y=Yes

Y/N Table Edit