SCP_REG_VW_FL

(SQL View)
 Index Back

Registration View


SELECT c.oprid ,A.DISPLAY_ORDER , A.SCP_CONTENT_TYPE , A.SCP_CONTENT_ID , A.SCP_REG_LINK_TYPE , A.SCP_SUMMARY , A.SCP_ICON , A.SCP_DETAIL , B.SCP_GRP_LINK_LBL , B.PORTAL_NAME , B.PORTAL_OBJNAME , B.SUP_OB_TEMPLATE_ID FROM PS_SCP_CONGRPUS_VW C , 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 C.SCP_SECURITY_GROUP = A.SCP_SECURITY_GROUP AND A.SCP_CONTENT_STATUS = 'P' ORDER BY A.DISPLAY_ORDER

  • Related Language Record: SCP_REG_VW_LNG

    • # 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 DISPLAY_ORDER Number(3,0) SMALLINT NOT NULL Display order for ordering items in a list - web style
    3 SCP_CONTENT_TYPE Character(1) VARCHAR2(1) NOT NULL Content Type
    4 SCP_CONTENT_ID Character(15) VARCHAR2(15) NOT NULL Content ID
    5 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
    6 SCP_SUMMARY Character(254) VARCHAR2(254) NOT NULL Content Summary
    7 SCP_ICON Image / Attachment CLOB Registration Links Icon
    8 SCP_DETAIL Long Character CLOB Content Detail
    9 SCP_GRP_LINK_LBL Character(30) VARCHAR2(30) NOT NULL Group Link Label
    10 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    11 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    12 SUP_OB_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Supplier On boarding template Id

    Prompt Table: SUP_OB_TMPL_RS