RD_PTNR_VLIS_VW

(SQL View)
 Index Back

Partner View Lists

This is view of Partner View Lists

SELECT A.BO_ID , C.RSEC_VIEW_ID , D.DESCR , D.DESCRLONG FROM PS_RSEC_ML_PARTNER A , PS_RSEC_PROFILEMDM B , PS_RSEC_PROFILEVDM C , PS_RSEC_VIEW_DEFN D WHERE A.RSEC_MEMBER_ID = B.RSEC_MEMBER_ID AND B.RSEC_PROFILE_ID = C.RSEC_PROFILE_ID AND C.RSEC_VIEW_ID = D.RSEC_VIEW_ID AND D.STATUS = 'A'

  • Related Language Record: RD_PTR_VLIS_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

    Prompt Table: RSEC_BO_PART_VW

    2 RSEC_VIEW_ID Character(30) VARCHAR2(30) NOT NULL Unique identifier of a view list used in application security.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRLONG Long Character CLOB Long Description