RO_LINE_NUM_LVW

(SQL View)
Index Back

Numbers based on Category

View used to get Phone Numbers based on Category.

SELECT A.RBTNUMBER , B.LANGUAGE_CD , B.CATEGORY_DESCR FROM PS_RBT_NUMBER A , PS_RBT_CATEGORY_LN B WHERE A.RBTCATEGORY = B.RBTCATEGORY

  • Related Language Record for RO_LINE_NUM_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RBTNUMBER Character(15) VARCHAR2(15) NOT NULL Number For Telco
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 CATEGORY_DESCR Character(30) VARCHAR2(30) NOT NULL Category Description field. Used in Text Tray