OM_MCP_LCUR_VW (SQL View)	Index Back
Price List Filter View for Price List Filter

OM_MCP_LCUR_VW

(SQL View)

Price List Filter

View for Price List Filter

SELECT DISTINCT B.OPRID ,A.CURRENCY_CD , A.DESCR FROM PS_CURRENCY_CD_TBL A , PS_OM_MCP_LPRC_DTL B WHERE A.CURRENCY_CD = B.CURRENCY_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description