COMM_CD_EU_VW (SQL View)	Index Back
Comm Code Last Eff Date

COMM_CD_EU_VW

(SQL View)

Comm Code Last Eff Date

SELECT A.COMMODITY_CD_EU , A.EFFDT FROM PS_COMMOD_CODE_EU A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_COMMOD_CODE_EU B WHERE B.COMMODITY_CD_EU = A.COMMODITY_CD_EU AND B.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMMODITY_CD_EU Character(10) VARCHAR2(10) NOT NULL EU Commodity Code

2 EFFDT Date(10) DATE Effective Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMMODITY_CD_EU	Character(10)	VARCHAR2(10) NOT NULL	EU Commodity Code
2	EFFDT	Date(10)	DATE	Effective Date