EODP_SRCHPRD_VW

(SQL View)
 Index Back

Product View for EODP Search

Product view for data privacy Search

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

  • Related Language Record: EODP_SRHPRD_LVW

    • # 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 EODP_PROD_DESCR Character(30) VARCHAR2(30) NOT NULL Product Description