EODP_SRHPRD_LVW

(SQL View)
 Index Back

Search ref View for EODP comp

Search reference language view for data privacy components

SELECT A.PTSF_SRCCAT_NAME , C.LANGUAGE_CD , C.XLATLONGNAME FROM PSPTSF_SRCCAT A , PSXLATITEM B , PSXLATITEMLANG C WHERE B.FIELDNAME = 'OBJECTOWNERID' AND B.FIELDVALUE = A.OBJECTOWNERID AND %EffdtCheck(PSXLATITEM C, B, %CurrentDateIn) AND B.FIELDNAME = C.FIELDNAME AND B.FIELDVALUE = C.FIELDVALUE AND B.EFFDT = C.EFFDT

  • Related Language Record for EODP_SRCHPRD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTSF_SRCCAT_NAME Character(65) VARCHAR2(65) NOT NULL Search Category Name (see PSPTSF_SRCCAT).
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EODP_PROD_DESCR Character(30) VARCHAR2(30) NOT NULL Product Description