CP_CFGCD_CST_VW (SQL View)	Index Back
CP Cfg Code for Cust Alias CP Cfg Code for Cust Alias

CP_CFGCD_CST_VW

(SQL View)

CP Cfg Code for Cust Alias

SELECT DISTINCT MI.SETID , CP.PRODUCT_ID , CP.CONFIG_CODE FROM PS_CP_OPT_HDR CP , PS_MASTER_ITEM_TBL MI WHERE MI.INV_ITEM_ID = CP.INV_ITEM_ID AND MI.ITM_STATUS_CURRENT = '1' AND MI.CFG_CODE_OPT = 'Y' AND CP.CP_MODE = 'S' AND CP.CP_COMP_SEQ = 1 AND CP.CONFIG_CODE <> ' ' AND MI.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = CP.BUSINESS_UNIT AND RECNAME = 'MASTER_ITEM_TBL')

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

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

3 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

#	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.
2	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
3	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator