SCP_SUHOUSR_LNG

(SQL View)
 Index Back

Supplier Home Users View

Supplier Home Content Users View - Related Language

SELECT B.OPRID , A.SCP_CONTENT_ID , A.LANGUAGE_CD , A.SCP_SUMMARY , A.SCP_DETAIL FROM PS_SCP_SUPHOME_LNG A , PS_SCP_CONGRPUS_VW B , PS_SCP_SUPPHOME_VW C WHERE B.SCP_SECURITY_GROUP = C.SCP_SECURITY_GROUP AND A.SCP_CONTENT_ID = C.SCP_CONTENT_ID

  • Related Language Record for SCP_SUHO_USR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 SCP_CONTENT_ID Character(15) VARCHAR2(15) NOT NULL Content ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 SCP_SUMMARY Character(254) VARCHAR2(254) NOT NULL Content Summary
    5 SCP_DETAIL Long Character CLOB Content Detail