WM_WO_SCHPO_NC

(SQL View)
 Index Back

PO schedules


SELECT A.BUSINESS_UNIT , A.WO_ID , A.WO_TASK_ID , B.RSRC_TYPE , B.INV_ITEM_ID , C.CATEGORY_CD , B.RES_LN_NBR , B.CATEGORY_ID , A.LEAD_PERSON , A.SCHED_START_DT , A.SCHED_START_TIME , B.DESCR254_MIXED FROM PS_WM_WO_TSK A , PS_WM_WO_SCHED_PO B , PS_ITM_CAT_TBL C WHERE A.INTERNAL_STATUS NOT IN('06', '07') AND %Join(COMMON_KEYS, WM_WO_TSK A, WM_WO_SCHED_PO B) AND B.ON_HAND_STOCK <> 'Y' AND C.SETID = ( SELECT SCR.SETID FROM PS_SET_CNTRL_REC SCR WHERE SCR.SETCNTRLVALUE = B.BUSINESS_UNIT AND SCR.REC_GROUP_ID = 'FS_18' AND RECNAME = 'ITM_CAT_TBL') AND C.CATEGORY_ID = B.CATEGORY_ID AND C.EFFDT = ( SELECT MAX(CAT.EFFDT) FROM PS_ITM_CAT_TBL CAT WHERE CAT.SETID = C.SETID AND CAT.CATEGORY_TYPE = C.CATEGORY_TYPE AND CAT.CATEGORY_CD = C.CATEGORY_CD AND CAT.CATEGORY_ID = C.CATEGORY_ID AND CAT.EFF_STATUS = 'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order

Prompt Table: SP_BU_WM_NONVW

2 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
3 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
4 RSRC_TYPE Character(1) VARCHAR2(1) NOT NULL Work Order Management Resource Types
1=Labor
2=Tools
3=Material
5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: WM_MST_ITEM_VW

6 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code

Prompt Table: ITM_CAT_SET_VW

7 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.
8 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
9 LEAD_PERSON Character(30) VARCHAR2(30) NOT NULL Lead Person
10 SCHED_START_DT Date(10) DATE Scheduled Start Date
11 SCHED_START_TIME Time(15) TIMESTAMP Schedule Start Time
12 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description