WM_CSINQ_VW

(SQL View)
 Index Back

Crew Schedule Inquiry View


SELECT DISTINCT H.BUSINESS_UNIT , H.SHOP_ID , R.CREW_ID , H.WO_ID , T.WO_TASK_ID , R.RQMT_LN_NBR , R.CRAFT_ID , R.RQMT_QTY , R.REQ_DURATION , H.WO_TYPE , H.PRIORITY_CD , %Substring(T.DESCR254 , 1 ,27) %Concat '...' , T.DESCR254 , A.DESCR , T.SUPERVISOR , T.LOCATION , T.ASSET_UP_FLG , T.BUSINESS_UNIT_AM , T.ASSET_ID , A.TAG_NUMBER , A.SERIAL_ID , A.VIN , T.COMPLTED_DT , T.STATUS_CD , T.RES_LBR_EXIST , T.RES_MAT_EXIST , T.RES_PO_EXIST , T.RES_TLS_EXIST , R.SCHED_START_DT , R.SCHED_START_TIME , R.SCHED_END_DT , R.SCHED_END_TIME , T.WO_DURATION FROM PS_WM_WO_HDR H , PS_WM_CREW_HDR D , PS_WM_WO_RQMT_LBR R , PS_WM_SHOP_HDR S , PS_WM_WO_TSK T , PS_ASSET A WHERE %Join(COMMON_KEYS, WM_WO_HDR H, WM_WO_TSK T) AND %Join(COMMON_KEYS, WM_WO_TSK T, WM_WO_RQMT_LBR R ) AND %Join(COMMON_KEYS, WM_WO_HDR H, WM_CREW_HDR D) AND S.BUSINESS_UNIT = D.BUSINESS_UNIT AND D.SHOP_ID = H.SHOP_ID AND H.SHOP_ID = S.SHOP_ID AND T.BUSINESS_UNIT_AM = A.BUSINESS_UNIT (+) AND T.ASSET_ID = A.ASSET_ID (+) AND %EffdtCheck(WM_SHOP_HDR SAUX, S, %CurrentDateIn) AND S.EFF_STATUS = 'A' AND S.SCHED_CREW_FLG = 'Y' AND D.EFF_STATUS = 'A' AND D.EFFDT >= ( SELECT MAX(EFFDT) FROM PS_WM_CREW_HDR WHERE BUSINESS_UNIT = H.BUSINESS_UNIT AND SHOP_ID = H.SHOP_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_BU_WM_NONVW

2 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification

Default Value: OPR_DEF_TBL_WM.SHOP_ID

Prompt Table: WM_SHOP_LOC_VW

3 CREW_ID Character(10) VARCHAR2(10) NOT NULL Crew Name
4 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
5 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number

Default Value: 1

6 RQMT_LN_NBR Number(5,0) INTEGER NOT NULL Requirement Line Number
7 CRAFT_ID Character(16) VARCHAR2(16) NOT NULL Craft Identification

Prompt Table: RS_RES_CRAFT

8 RQMT_QTY Signed Number(12,0) DECIMAL(11) NOT NULL Required Quantity
9 REQ_DURATION Signed Number(9,2) DECIMAL(7,2) NOT NULL Schedule Duration
10 WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type

Prompt Table: WM_WO_TYPE

11 PRIORITY_CD Character(3) VARCHAR2(3) NOT NULL Priority Code

Prompt Table: WM_PRIORITY

12 DESCR Character(30) VARCHAR2(30) NOT NULL Description
13 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
14 ASSET_DESCR30 Character(30) VARCHAR2(30) NOT NULL Asset Description
15 SUPERVISOR Character(30) VARCHAR2(30) NOT NULL Supervisor

Prompt Table: WM_SHOP_RES_VW

16 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_VW

17 ASSET_UP_FLG Character(1) VARCHAR2(1) NOT NULL Asset in Production Flag
18 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Default Value: OPR_DEF_TBL_WM.BUSINESS_UNIT_AM

Prompt Table: SP_BUS_AM_NONVW

19 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

Prompt Table: WM_ASSET_VWA

20 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
21 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
22 VIN Character(18) VARCHAR2(18) NOT NULL VIN
23 COMPLTED_DT Date(10) DATE Completed Date
24 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code

Prompt Table: WM_STATUS_HDR

25 RES_LBR_EXIST Character(1) VARCHAR2(1) NOT NULL Labor exists flag - used on WO

Y/N Table Edit

Default Value: N

26 RES_MAT_EXIST Character(1) VARCHAR2(1) NOT NULL Inventory exists flag - indicates if inventory exists on WO

Y/N Table Edit

Default Value: N

27 RES_PO_EXIST Character(1) VARCHAR2(1) NOT NULL Procurement exists flag - indicates if Procurement exists in WO

Y/N Table Edit

Default Value: N

28 RES_TLS_EXIST Character(1) VARCHAR2(1) NOT NULL Tools exists flag - indicates if Tools exists on a WO

Y/N Table Edit

Default Value: N

29 SCHED_START_DT Date(10) DATE Scheduled Start Date
30 SCHED_START_TIME Time(15) TIMESTAMP Schedule Start Time
31 SCHED_END_DT Date(10) DATE Scheduled End Date
32 SCHED_END_TIME Time(15) TIMESTAMP Schedule End Time
33 WO_DURATION Number(8,2) DECIMAL(7,2) NOT NULL Estimated Work Order Duration

Default Value: WM_WO_HDR.WO_DURATION