RI_STATUS_LNG

(SQL View)
 Index Back

Interaction Status View

This view is based on RB_MCF_DETAIL_TYPE = "NONE".

SELECT a.RB_MCF_STATUS , b.LANGUAGE_CD , b.DESCR_SHORT FROM PS_RI_STATUS_TBL a , PS_RI_STATUS_LANG b WHERE a.RB_MCF_DETAIL_TYPE = 'NONE' AND a.RB_MCF_STATUS = b.RB_MCF_STATUS AND a.RB_MCF_DETAIL_TYPE = b.RB_MCF_DETAIL_TYPE

  • Related Language Record for RI_STATUS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RB_MCF_STATUS Character(4) VARCHAR2(4) NOT NULL Interaction status code in multi function
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR_SHORT Character(30) VARCHAR2(30) NOT NULL Description Short