PO_CHG_RSN_LG (SQL View)	Index Back
PO Deny Change Reason RLR PO Deny Change Reason Language view.

PO_CHG_RSN_LG

(SQL View)

PO Deny Change Reason RLR

PO Deny Change Reason Language view.

SELECT setid , reason_cd , language_cd , descr50 , descrlong FROM PS_REASON_CD_LNG a WHERE a.effdt = ( SELECT MAX(aa.effdt) FROM PS_REASON_CD_LNG aa WHERE a.setid = aa.setid AND a.reason_type = aa.reason_type AND a.reason_cd = aa.reason_cd AND aa.effdt <= %CurrentDateIn)

Related Language Record for PO_CHG_RSN_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code

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

4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

5 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	REASON_CD	Character(10)	VARCHAR2(10) NOT NULL	Reason Code
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
5	DESCRLONG	Long Character	CLOB	Long Description