RC_PHONELVW3 (SQL View)	Index Back
View for Phone Related Language view for Phone.

RC_PHONELVW3

(SQL View)

View for Phone

Related Language view for Phone.

SELECT DISTINCT D.SETID , A.PHONE , B.LANGUAGE_CD , %Substring(C.BO_NAME_DISPLAY,1,50) , C.NAME_AC , B.DESCR FROM PS_BO_SRCH_PHN A , PS_CM_PURP_TYP_LNG B , PS_BO_NAME C , PS_BC D , PS_BO_REL REL WHERE A.ROLE_TYPE_ID = 8 AND A.BO_CM_USE_TYPE = 'R' AND A.CM_PURPOSE_TYPE_ID = B.CM_PURPOSE_TYPE_ID AND A.BO_ID = C.BO_ID AND C.PRIMARY_IND = 'Y' AND A.BO_ID = REL.BO_ID_1 AND REL.REL_TYPE_ID IN (10, 9, 14, 13) AND REL.START_DT <= %CurrentDateIn AND REL.END_DT > %CurrentDateIn AND REL.BO_ID_2 = D.BO_ID AND D.CUST_STATUS = 'A'

Related Language Record for RC_PHONE_VW3

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

2 RC_PHONE Character(24) VARCHAR2(24) NOT NULL This is the phone field used in case search. The reason is to have the ability to enter partial value for the phone and search on it. The standard PHONE field has a format mask associated with it, which does not permit entering partial values.

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

5 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

6 RC_PURP_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Short Description
Prompt Table: RC_CM_PURP_VW2

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	RC_PHONE	Character(24)	VARCHAR2(24) NOT NULL	This is the phone field used in case search. The reason is to have the ability to enter partial value for the phone and search on it. The standard PHONE field has a format mask associated with it, which does not permit entering partial values.
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	BO_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
5	BO_NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
6	RC_PURP_TYPE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Short Description Prompt Table: RC_CM_PURP_VW2