RO_LINE_NUM_V2

(SQL View)
 Index Back

Search Record for Number

This iview is used as Search Record for the Configurable Search for page RO_LN_NUM_SRCH_SEC.

SELECT A.RBTNUMBER , A.RBT_AREA_CODE , A.RBT_SUBSCRIBER_NUM , A.REGION_ID , A.RBTUSAGE , A.RBTTYPE , A.RBT_FACTOR_VALUE , A.RBT_FACTOR_VALUE , A.BO_ID_CUST , DECODE(A.ROLE_TYPE_ID_CUST ,42 ,2 ,46 ,9 ,A.ROLE_TYPE_ID_CUST ) , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT , A.RBTCATEGORY , A.RBTSUBCATEGORY , B.CATEGORY_DESCR , S.SUBCATEGORY_DESCR , S.PRODUCT_ID , S.PROD_SETID FROM PS_RBT_NUMBER A , PS_RBT_CATEGORY B , PS_RBT_SUBCATEGORY S WHERE A.RBTCATEGORY = B.RBTCATEGORY AND S.RBTSUBCATEGORY (+) = A.RBTSUBCATEGORY

  • Related Language Record: RO_LINE_NUM_LV2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RBTNUMBER Character(15) VARCHAR2(15) NOT NULL Number For Telco
    2 RBT_AREA_CODE Character(15) VARCHAR2(15) NOT NULL Telephone area code for use in number management
    3 RBT_SUBSCRIBER_NUM Character(15) VARCHAR2(15) NOT NULL Telephone subscriber number for use in number management
    4 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.

    Prompt Table: RBT_REGION_VW
    Set Control Field: DESCR

    5 RBTUSAGE Character(2) VARCHAR2(2) NOT NULL Usage for MSISDN
    D=Data
    F=Fax
    V=Voice
    6 RBTTYPE Character(4) VARCHAR2(4) NOT NULL Type For telco
    MO=Wireless Number
    PH=Wireline Number
    7 RBT_FACTOR_VALUE Character(20) VARCHAR2(20) NOT NULL Factor Value
    8 RBT_FACTOR_VALUE2 Character(20) VARCHAR2(20) NOT NULL Factor Value
    9 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
    10 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
    11 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
    12 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
    13 RBTCATEGORY Character(2) VARCHAR2(2) NOT NULL Number Category

    Prompt Table: RBT_CATEGORY
    Set Control Field: RBTCATEGORY

    14 RBTSUBCATEGORY Character(3) VARCHAR2(3) NOT NULL SubCategory for MSISDN
    EON=Employee Official Number
    ESR=Emergency Service Routing Key
    LDN=Local Directory Number
    LRN=Local Routing Number
    PPD=Prepaid Account Number
    PST=Postpaid Account Number
    SDT=SoftDial Tone Number
    TST=Test Number

    Prompt Table: RBT_SUBCATEGORY

    15 CATEGORY_DESCR Character(30) VARCHAR2(30) NOT NULL Category Description field. Used in Text Tray
    16 SUBCATEGORY_DESCR Character(30) VARCHAR2(30) NOT NULL Category Description field. Used in Text Tray
    17 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: RBT_PROD_VW

    18 PROD_SETID Character(5) VARCHAR2(5) NOT NULL Product SET ID