RB_PROD_ATTRLNG

(SQL View)
 Index Back

attributes used in catalog

Related language view for RB_PROD_ATTR_VW used in ocss

SELECT A.SETID , A.PRODUCT_ID , A.ATTRIBUTE_ID , B.LANGUAGE_CD , B.ATTR_NAME , A.ATTRIBUTE_VALUE , C.DESCR60 FROM PS_PROD_ATTR_LNG A , PS_RB_ATTR_LNG B , PS_RB_ATTRG_VW_LNG C , PS_RB_ATTRIBUTE D WHERE A.ATTRIBUTE_ID = B.ATTRIBUTE_ID AND B.MARKET = D.MARKET AND B.ATTRIBUTE_ID = D.ATTRIBUTE_ID AND D.ATTR_GROUP_ID = C.ATTR_GROUP_ID AND C.ATTR_GRP_MARKET = A.MARKET AND B.LANGUAGE_CD = C.LANGUAGE_CD AND A.LANGUAGE_CD = B.LANGUAGE_CD

  • Related Language Record for RB_PROD_ATTR_VW

    • # 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 ATTRIBUTE_ID Character(15) VARCHAR2(15) NOT NULL Attribute Label, Name or Properties
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 ATTRNAME Character(30) VARCHAR2(30) NOT NULL Pub/Sub Attribute Name
    6 ATTRIBUTE_VALUE Character(254) VARCHAR2(254) NOT NULL Attribute value
    7 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description