IN_WO_STAT_VW

(SQL View)
 Index Back

SELECT B.DEMAND_HASH , A.INTERNAL_STATUS FROM PS_WM_WO_HDR A , PS_IN_PEGGING B , PS_WM_WO_PO_HASH C WHERE C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.WO_ID = A.WO_ID AND B.DEMAND_HASH = C.HASH_KEY AND B.DMD_ORDER_TYPE = '115'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DEMAND_HASH Character(28) VARCHAR2(28) NOT NULL 08/11/04 EGS: Created.
2 INTERNAL_STATUS Character(2) VARCHAR2(2) NOT NULL Internal Status
01=Open
02=Awaiting Schedule
03=Scheduled
04=Work In Progress
05=Complete
06=Closed
07=Canceled
08=On Hold
09=Work Order Created