EODP_QRY_REF_VW

(SQL View)
 Index Back

Query Ref Product View

Query Ref Product View

SELECT A.CONQRSNAME , B.EODP_PRODUCT_CD , B.EODP_OBJ_DESCR FROM PSCONQRSDEFN A , PS_EODP_PROD_VW B WHERE A.OBJECTOWNERID = B.EODP_PRODUCT_CD UNION SELECT A.CPQNAME , B.EODP_PRODUCT_CD , B.EODP_OBJ_DESCR FROM PSCPQDEFN A , PS_EODP_PROD_VW B WHERE A.OBJECTOWNERID = B.EODP_PRODUCT_CD

  • Related Language Record: EODP_QRY_RF_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EODP_QUERYNAME Character(30) VARCHAR2(30) NOT NULL Query Name Field
    2 EODP_PRODUCT_CD Character(4) VARCHAR2(4) NOT NULL PeopleSoft Product Code. Created for Sensitive Data Framework
    3 EODP_PROD_DESCR Character(30) VARCHAR2(30) NOT NULL Product Description