RB_ATTR_GP_S_VW

(SQL View)
 Index Back

Attribute Groups

Common Object Attribute Groups View

SELECT A.FIELDVALUE FROM PSXLATITEM A WHERE A.FIELDNAME = 'MARKET' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE B.FIELDNAME = A.FIELDNAME AND B.FIELDVALUE = A.FIELDVALUE AND B.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

  • Related Language Record: RB_ATTR_GP_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MARKET Character(3) VARCHAR2(3) NOT NULL Market

    Default Value: OPR_DEF_TBL_RB.MARKET