RF_CMT_LINK_VW

(SQL View)
Index Back

IP - Related Commitment

View used for getting related commitment products

SELECT link.setid , link.inst_prod_id , link.inst_link_id , link.prod_rel_type , link.rel_inst_prod_id FROM PS_RF_INST_LINK link WHERE link.prod_rel_type = 'CMNT'

# 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.

Prompt Table: SP_SETID_NONVW

2 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)
3 INST_LINK_ID Character(20) VARCHAR2(20) NOT NULL Field used for storing installed link id information
4 PROD_REL_TYPE Character(5) VARCHAR2(5) NOT NULL Product Relationship Type
5 REL_INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL Field used for storing releated installed product information