RO_LINE_NUM_VW

(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 , A.RBTSESSION ,A.RBTSTATUS , %subrec(RB_AUDIT_SBR,A) FROM PS_RBT_NUMBER A , PS_RBT_CATEGORY B , PS_RBT_SUBCATEGORY S WHERE A.RBTCATEGORY = B.RBTCATEGORY AND S.RBTSUBCATEGORY (+) = A.RBTSUBCATEGORY AND NOT EXISTS ( SELECT X.RBTNUMBER FROM PS_RBT_SIM_NUMBER X WHERE X.RBTNUMBER = A.RBTNUMBER)

  • Related Language Record: RO_LINE_NUM_LVW

    • # 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
    19 RBTSESSION Character(15) VARCHAR2(15) NOT NULL Session for Number assignment
    20 RBTSTATUS Character(2) VARCHAR2(2) NOT NULL Status for Telco
    AG=Aging
    AS=Active
    AV=Available
    BL=Blocked
    PA=Activation-Pending
    PE=Pending
    PO=Ported-Out
    RL=Released
    RS=Reserved
    21 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    22 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    23 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    24 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    25 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    26 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time