RB_REGION_PT_VW

(SQL View)
 Index Back

Regions and Parent ID View

Get Regions and their parent region ID.

SELECT DISTINCT P.REGION_CATEGORY , P.REGION_ID , P.STATUS , P.DESCR , P.PARENT_REGION_ID , C.PARENT_REGION_ID FROM PS_RB_REGION P , PS_RB_REGION C WHERE P.REGION_ID = C.PARENT_REGION_ID (+) AND P.REGION_CATEGORY = C.REGION_CATEGORY (+)

  • Related Language Record: RB_REGION_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REGION_CATEGORY Character(4) VARCHAR2(4) NOT NULL Region Category
    GEOG=Geography
    NMGT=Number Management
    PROD=Product Sales
    TERR=Territory Assignment
    2 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.
    3 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 PARENT_REGION_ID Character(15) VARCHAR2(15) NOT NULL Unique identifier for Parent Region.

    Prompt Table: RB_REGION_SRCH

    6 CHILD_REGION_ID Character(15) VARCHAR2(15) NOT NULL The region ID of a child region