RBT_PRD_COMP_VW (SQL View)	Index Back
Product Kit Components This view is to get all the components of all the kits that are associated to a product as Service Features (Relationship). This views that these kits are 2 level kits.

RBT_PRD_COMP_VW

(SQL View)

Product Kit Components

This view is to get all the components of all the kits that are associated to a product as Service Features (Relationship). This views that these kits are 2 level kits.

SELECT a.SETID , c.PRODUCT_ID , c.PRODUCT_ID_ALT , b.PROD_COMPONENT_ID , a.DESCR , b.PROD_DISPLAY_ORDER FROM PS_PROD_RELATIONS c , PS_PRODKIT_COMPS b , PS_PROD_ITEM a WHERE c.SETID = b.SETID AND c.SETID = a.SETID AND c.PRODUCT_ID_ALT = b.PRODUCT_ID AND b.PROD_COMPONENT_ID = a.PRODUCT_ID AND c.START_DT <= %CurrentDateIn AND c.END_DT >%CurrentDateIn AND b.DATE_IN_EFFECT <= %CurrentDateIn AND b.DATE_OBSOLETE >%CurrentDateIn

Related Language Record: RBT_PRDCOMP_LVW

Parent record: RBT_PRD_REL_VW2

# 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 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
Default Value: NEXT

3 PRODUCT_ID_ALT Character(18) VARCHAR2(18) NOT NULL Product ID Alternate
Prompt Table: PRODREL_SRCH_VW

4 PROD_COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL Field is used to store components of a product
Prompt Table: PROD_SRCH_VW

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

6 PROD_DISPLAY_ORDER Number(2,0) SMALLINT NOT NULL We (PeopleSoft) plan on setting a 'Display Order' on the service features in a product. That is how we would decide the order to show the service features. Instead of just doing it alphabetically.

#	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	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Default Value: NEXT
3	PRODUCT_ID_ALT	Character(18)	VARCHAR2(18) NOT NULL	Product ID Alternate Prompt Table: PRODREL_SRCH_VW
4	PROD_COMPONENT_ID	Character(18)	VARCHAR2(18) NOT NULL	Field is used to store components of a product Prompt Table: PROD_SRCH_VW
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	PROD_DISPLAY_ORDER	Number(2,0)	SMALLINT NOT NULL	We (PeopleSoft) plan on setting a 'Display Order' on the service features in a product. That is how we would decide the order to show the service features. Instead of just doing it alphabetically.