RO_REGIONPR_VWL (SQL View)	Index Back
Region View View of Region by Product Region Type used in ocs

RO_REGIONPR_VWL

(SQL View)

Region View

View of Region by Product Region Type used in ocs

SELECT a.REGION_ID , b.LANGUAGE_CD ,b.DESCR FROM PS_RB_REGION a , PS_RB_REGION_LNG b WHERE a.STATUS = 'A' AND a.REGION_CATEGORY = 'PROD' AND a. REGION_ID = b. REGION_ID AND b.REGION_CATEGORY = 'PROD'

Related Language Record for RO_REGIONPRD_VW

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description