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

RC_AGR_RL_VW

(SQL View)

Agreement View

Call Center Agreement View for BO Search Setup

SELECT B.BO_ID_CONTACT , CASE WHEN B.BO_ID_CONTACT = B.BO_ID_CUST THEN 9 WHEN B.BO_ID_CONTACT <> B.BO_ID_CUST THEN 8 END , 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 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID

3 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	ROLE_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID
3	AGREEMENT_CODE	Character(30)	VARCHAR2(30) NOT NULL	This field represents the agreement code (name) for an agreement