EODP_RPT_PRDLVW (SQL View)	Index Back
Product View for EODP Search Product view for data privacy Search

EODP_RPT_PRDLVW

(SQL View)

Product View for EODP Search

Product view for data privacy Search

SELECT A.REPORT_DEFN_ID ,B.LANGUAGE_CD , B.XLATLONGNAME FROM PSXPRPTDEFN A , PSXLATITEMLANG B WHERE B.FIELDNAME = 'OBJECTOWNERID' AND B.FIELDVALUE = A.OBJECTOWNERID AND %EffdtCheck(PSXLATITEMLANG C, B, %CurrentDateIn)

Related Language Record for EODP_RPT_PRD_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL Report Name (see PSXPRPTDEFN).
Prompt Table: EODP_RPT_RDF_VW

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

3 EODP_PROD_DESCR Character(30) VARCHAR2(30) NOT NULL Product Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REPORT_DEFN_ID	Character(12)	VARCHAR2(12) NOT NULL	Report Name (see PSXPRPTDEFN). Prompt Table: EODP_RPT_RDF_VW
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	EODP_PROD_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Product Description