RB_BO_CUSTLVW1 (SQL View)	Index Back
Customer View Customer View

RB_BO_CUSTLVW1

(SQL View)

Customer View

SELECT A.BO_ID , E.LANGUAGE_CD , E.DESCR FROM PS_BO A , PS_BC B , PS_BO_ROLE C , PS_BO_ROLE_TYPE D , PS_BO_ROLE_TYP_LNG E WHERE A.BO_ID = B.BO_ID AND A.BO_ID = C.BO_ID AND B.CUSTOMER_IND = 'Y' AND C.ROLE_TYPE_ID IN (2, 9, 30, 31) AND C.ROLE_TYPE_ID = D.ROLE_TYPE_ID AND D.ROLE_TYPE_ID = E.ROLE_TYPE_ID

Related Language Record for RB_BO_CNTACT_VW RB_BO_CUST_VW1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

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

3 ROLE_NAME Character(40) VARCHAR2(40) NOT NULL Role name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	ROLE_NAME	Character(40)	VARCHAR2(40) NOT NULL	Role name