RB_PROD_ATGR_VW

(SQL View)
 Index Back

Record is used for get attribu

Record is used for getting the attributes

SELECT DISTINCT A.SETID , A.PRODUCT_ID ,B.ATTR_GROUP_ID , C.DESCR60 ,C.ATTR_USAGE FROM PS_PROD_ATTR A , PS_RB_ATTRIBUTE B , PS_RB_ATTR_GRP_VW C WHERE A.ATTRIBUTE_ID = B.ATTRIBUTE_ID AND B.ATTR_GROUP_ID = C.ATTR_GROUP_ID

  • Related Language Record: RB_PRD_ATGR_VLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    3 ATTR_GROUP_ID Character(15) VARCHAR2(15) NOT NULL attribute group id field used by applications
    4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    5 ATTR_USAGE Character(4) VARCHAR2(4) NOT NULL Attribute usage
    CONF=Configuration
    INFO=Information