GP_RPD_CTRY_VW (SQL View)	Index Back
Rto Prc Defn ctry w profile Lists countries found in the RTO PRC DEFN table while enforcing GP user profile country selection

GP_RPD_CTRY_VW

(SQL View)

Rto Prc Defn ctry w profile

Lists countries found in the RTO PRC DEFN table while enforcing GP user profile country selection

SELECT C.OPRID , A.COUNTRY , B.DESCR FROM PS_GP_RTO_PRC_DEFN A , PS_COUNTRY_TBL B , ps_gp_opr_rule_prf c WHERE A.COUNTRY = B.COUNTRY AND (C.USED_BY = 'A' OR B.country = C.country)

Related Language Record: GP_USR_CNTR_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description