RF_COMM_CNTR_VW (SQL View)	Index Back
Comm Contract Views View used to retrieve Commitments Contracts

RF_COMM_CNTR_VW

(SQL View)

Comm Contract Views

View used to retrieve Commitments Contracts

SELECT DISTINCT COMM.SETID , COMM.COMM_CONT_ID , BON.BO_NAME_DISPLAY , BONC.BO_NAME_DISPLAY , COMM.COMM_STATUS , COMM.CREATING_RULE_ID , INST.PRODUCT_ID , INST.BO_ID_CUST , INST.ROLE_TYPE_ID_CUST , INST.BO_ID_CONTACT , INST.ROLE_TYPE_ID_CNTCT FROM PS_RF_INST_PROD INST , PS_RF_COMMIT_CONTR COMM LEFT OUTER JOIN PS_BO_NAME BON ON (COMM.BO_ID_CUST = BON.BO_ID AND BON.PRIMARY_IND='Y' ) LEFT OUTER JOIN PS_BO_NAME BONC ON (COMM.BO_ID_CONTACT = BONC.BO_ID AND BONC.PRIMARY_IND = 'Y' ) , PS_RF_INST_LINK LNK , PS_PROD_ITEM PROD , PS_PROD_MLPB_ITEM MLPB WHERE COMM.INST_PROD_COMM = LNK.INST_PROD_ID AND LNK.SETID = COMM.SETID AND LNK.PROD_REL_TYPE = 'CMNT' AND COMM.INST_PROD_COMM = INST.INST_PROD_ID AND COMM.SETID = INST.SETID AND PROD.SETID = ( SELECT r.setid FROM ps_set_cntrl_rec r WHERE r.setcntrlvalue = INST.setid AND r.recname = 'PROD_ITEM') AND PROD.PRODUCT_ID = INST.PRODUCT_ID AND PROD.SETID = INST.SETID AND MLPB.SETID = PROD.SETID AND MLPB.PRODUCT_ID = PROD.PRODUCT_ID AND INST.INST_PROD_TYPE IN ('002', '003', '004', '005')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_NONVW

2 COMM_CONT_ID Character(20) VARCHAR2(20) NOT NULL Field used for storing Commitment ID

3 BO_NAME_DISPLAY_1 Character(80) VARCHAR2(80) NOT NULL This field represents the Display Name for a business object

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

5 COMM_STATUS Character(3) VARCHAR2(3) NOT NULL This field represents the Commitment Contract status value.
DIS=Disconnected
INS=Active
PND=Pending-Activation
UNI=Expired
VLT=Violated

6 CREATING_RULE_ID Character(30) VARCHAR2(30) NOT NULL Field used for storing Creating Rule ID

7 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

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

9 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer

10 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

11 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW
2	COMM_CONT_ID	Character(20)	VARCHAR2(20) NOT NULL	Field used for storing Commitment ID
3	BO_NAME_DISPLAY_1	Character(80)	VARCHAR2(80) NOT NULL	This field represents the Display Name for a business object
4	BO_NAME_DISPLAY_2	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
5	COMM_STATUS	Character(3)	VARCHAR2(3) NOT NULL	This field represents the Commitment Contract status value. DIS=Disconnected INS=Active PND=Pending-Activation UNI=Expired VLT=Violated
6	CREATING_RULE_ID	Character(30)	VARCHAR2(30) NOT NULL	Field used for storing Creating Rule ID
7	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
8	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
9	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
10	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
11	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact