RF_ALTPT_SRH_VW (SQL View)	Index Back
Partner Search View Used to retrieve alternate character names for partner companies associated with installed products for deep query results on installed product configurable search.

RF_ALTPT_SRH_VW

(SQL View)

Partner Search View

Used to retrieve alternate character names for partner companies associated with installed products for deep query results on installed product configurable search.

SELECT A.SYNCID , B.BO_NAME_AC FROM PS_RF_INST_PROD A , PS_BO_NAME B WHERE B.BO_ID = A.BO_ID_PTNR_CMP AND B.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

2 BO_NAME_PARTNER_AC Character(50) VARCHAR2(50) NOT NULL This field stores the Partner name in Alternate Character format.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
2	BO_NAME_PARTNER_AC	Character(50)	VARCHAR2(50) NOT NULL	This field stores the Partner name in Alternate Character format.