DP_IMWKQUELN_VW (SQL View)	Index Back
Workqueue Messages Workqueue Messages by language for Ineventory Policy

DP_IMWKQUELN_VW

(SQL View)

Workqueue Messages

Workqueue Messages by language for Ineventory Policy

SELECT A.DP_MESSAGENUMBER , A.LANGUAGE_CD , A.DP_CAPTION FROM PS_DP_MSGSWRKQ_LNG A , PS_DP_MSGSWRKQUEUE B WHERE A.DP_MESSAGENUMBER = B.DP_MESSAGENUMBER AND B.DP_IPINUSE <> 0

Related Language Record for DP_IMSGWKQUE_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DP_MESSAGENUMBER Number(8,0) INTEGER NOT NULL DP_MESSAGENUMBER

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 DP_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_CAPTION

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DP_MESSAGENUMBER	Number(8,0)	INTEGER NOT NULL	DP_MESSAGENUMBER
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DP_CAPTION	Character(30)	VARCHAR2(30) NOT NULL	DP_CAPTION