SCP_REG_VW

(SQL View)
 Index Back

Registration links View


SELECT A.DISPLAY_ORDER , A.SCP_CONTENT_ID , A.SCP_REG_LINK_TYPE , A.SCP_SECURITY_GROUP , A.SCP_SUMMARY , A.SCP_DETAIL , B.SCP_GRP_LINK_LBL , B.PORTAL_NAME , B.PORTAL_OBJNAME , B.SUP_OB_TEMPLATE_ID , A.PSIMAGEVER , A.SCP_ICON FROM PS_SCP_CONTENT_HDR A LEFT JOIN PS_SCP_CONT_LINKS B ON A.SCP_CONTENT_ID = B.SCP_CONTENT_ID AND B.SCP_CONT_LINK_TYPE = 'R' WHERE A.SCP_CONTENT_TYPE = 'R' AND A.SCP_CONTENT_STATUS = 'P' ORDER BY A.DISPLAY_ORDER

  • Related Language Record: SCP_REG_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DISPLAY_ORDER Number(3,0) SMALLINT NOT NULL Display order for ordering items in a list - web style
    2 SCP_CONTENT_ID Character(15) VARCHAR2(15) NOT NULL Content ID
    3 SCP_REG_LINK_TYPE Character(1) VARCHAR2(1) NOT NULL Registration Link Type: S - Supplier; B - Bidder; U - User;
    B=Bidder
    S=Supplier
    U=User
    4 SCP_SECURITY_GROUP Character(4) VARCHAR2(4) NOT NULL Content Security Group
    5 SCP_SUMMARY Character(254) VARCHAR2(254) NOT NULL Content Summary
    6 SCP_DETAIL Long Character CLOB Content Detail
    7 SCP_GRP_LINK_LBL Character(30) VARCHAR2(30) NOT NULL Group Link Label
    8 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    9 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    10 SUP_OB_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Supplier On boarding template Id

    Prompt Table: SUP_OB_TMPL_RS

    11 PSIMAGEVER Number(10,0) DECIMAL(10) NOT NULL Image Version
    12 SCP_ICON Image / Attachment CLOB Registration Links Icon