RF_CNAME_PR_VW2 (SQL View)	Index Back
Customer Name prompt view Retrieves primary customer names that are not sites and are in the same setcontrol record as RB_INT_CUSTOMER.

RF_CNAME_PR_VW2

(SQL View)

Customer Name prompt view

Retrieves primary customer names that are not sites and are in the same setcontrol record as RB_INT_CUSTOMER.

SELECT %Substring(C.SETCNTRLVALUE, 1, 5) , C.SETID , A.CUST_ID , B.BO_NAME_DISPLAY , B.BO_NAME_AC FROM PS_BC A , PS_BO_NAME B , PS_SET_CNTRL_REC C , PS_BO D WHERE A.SETID = C.SETID AND B.BO_ID = A.BO_ID AND B.PRIMARY_IND = 'Y' AND A.CUST_ID <> ' ' AND A.BO_ID NOT IN ( SELECT BO_ID FROM PS_RD_SITE) AND C.RECNAME = 'RB_INT_CUSTOMER' AND A.BO_ID = D.BO_ID AND D.MERGE_STATUS <> 'I'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

3 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID

4 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
3	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID
4	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
5	BO_NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object