RD_PTR_VLIS_LVW

(SQL View)
 Index Back

Partner View Lists

This is view of Partner View Lists

SELECT A.BO_ID , E.LANGUAGE_CD , E.DESCR , E.DESCRLONG FROM PS_RSEC_ML_PARTNER A , PS_RSEC_PROFILEMDM B , PS_RSEC_PROFILEVDM C , PS_RSEC_VIEW_DEFN D , PS_RSEC_VIEW_LNG E 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.RSEC_VIEW_ID = E.RSEC_VIEW_ID AND D.STATUS = 'A'

  • Related Language Record for RD_PTNR_VLIS_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRLONG Long Character CLOB Long Description