WM_WO_STATUS_VW (SQL View)	Index Back
WM Internal Status View View used to limit the valid INTERNAL_STATUS xlat values for the Inventory Commit Rule setup at the WO Business unit and shop levels.

WM_WO_STATUS_VW

(SQL View)

WM Internal Status View

View used to limit the valid INTERNAL_STATUS xlat values for the Inventory Commit Rule setup at the WO Business unit and shop levels.

SELECT %Substring(FIELDVALUE,1,2) , XLATLONGNAME FROM PSXLATITEM WHERE FIELDNAME = 'INTERNAL_STATUS' AND FIELDVALUE IN ('02', '03', '04')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name