RB_ATTR_OBJ_LNG

(SQL View)
 Index Back

Attribute Object View

Common Object used for Attribute Object View

SELECT O.MARKET , O.RB_OBJECT_TYPE , G.ATTR_GRP_MARKET , O.ATTR_GROUP_ID , O.ATTRIBUTE_ID , AL.LANGUAGE_CD , AL.ATTR_NAME , AL.ATTR_DEFAULT_VAL , GP.DESCR60 FROM PS_RB_OBJ_ATTR_GRP G , PS_RB_OBJ_ATTR O , PS_RB_ATTRIBUTE A , PS_RB_ATTR_ITEM AI , PS_RB_ATTR_LNG AL , PS_RB_OBJECT_TYPE T , PS_RB_ATTR_GROUP GP WHERE G.RB_OBJECT_TYPE = O.RB_OBJECT_TYPE AND G.MARKET = O.MARKET AND G.ATTR_GROUP_ID = O.ATTR_GROUP_ID AND O.ATTRIBUTE_ID = A.ATTRIBUTE_ID AND O.ATTR_GRP_MARKET = A.MARKET AND O.RB_OBJECT_TYPE = T.RB_OBJECT_TYPE AND O.MARKET = T.MARKET AND G.ATTR_GROUP_ID = GP.ATTR_GROUP_ID AND G.ATTR_GRP_MARKET = GP.MARKET AND O.USE_ATTR_FLG = 'Y' AND A.ATTR_STATUS = 'ACTV' AND A.MARKET = AI.MARKET (+) AND A.ATTRIBUTE_ID = AI.ATTRIBUTE_ID (+) AND AI.DEFAULT_FLG (+) = 'Y' AND A.ATTRIBUTE_ID = AL.ATTRIBUTE_ID AND A.MARKET = AL.MARKET

  • Related Language Record for RB_ATTR_OBJ_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MARKET Character(3) VARCHAR2(3) NOT NULL Market
    2 RB_OBJECT_TYPE Character(30) VARCHAR2(30) NOT NULL Attribute Object Type
    3 ATTR_GRP_MARKET Character(3) VARCHAR2(3) NOT NULL Used in the Object Type Attributes page

    Prompt Table: RB_MARKET_VW

    4 ATTR_GROUP_ID Character(15) VARCHAR2(15) NOT NULL attribute group id field used by applications
    5 ATTRIBUTE_ID Character(15) VARCHAR2(15) NOT NULL Attribute Label, Name or Properties
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 ATTR_NAME Character(30) VARCHAR2(30) NOT NULL Attribute name
    8 ATTR_DEFAULT_VAL Character(254) VARCHAR2(254) NOT NULL Attribute default value
    9 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description