RC_AGREEMENT_VW (SQL View)	Index Back
Agreement View Call Center Agreement View for BO Search Setup

RC_AGREEMENT_VW

(SQL View)

Agreement View

Call Center Agreement View for BO Search Setup

SELECT B.BO_ID_CONTACT , A.AGREEMENT_CODE FROM PS_RF_AGREEMENT A , PS_RF_AGR_CONTACT B WHERE A.AGRT_STATUS = '005' AND A.SETID = B.SETID AND A.AGREEMENT_CODE = B.AGREEMENT_CODE AND A.AGR_RENEWAL_NUM = B.AGR_RENEWAL_NUM AND A.AGR_SCOPE = 'CONT'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

2 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	AGREEMENT_CODE	Character(30)	VARCHAR2(30) NOT NULL	This field represents the agreement code (name) for an agreement