RO_PK_REGN_VW(SQL View) |
Index Back |
---|---|
Pricing RegionThis vie expands the Pricing Region |
SELECT a.REGION_ID , a.DESCR FROM PS_RB_REGION a WHERE a.STATUS = 'A' AND a.REGION_CATEGORY = 'GEOG' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | REGION_ID | Character(15) | VARCHAR2(15) NOT NULL | This field stores the region id value. |
2 | EOEP_CHAR | Character(254) | VARCHAR2(254) NOT NULL | Long field |