CP_CFGCD_PM2_VW (SQL View)	Index Back
CP Cfg Code Prompt - CP Order CP Cfg Code Prompt - CP Order

CP_CFGCD_PM2_VW

(SQL View)

CP Cfg Code Prompt - CP Order

SELECT DISTINCT INV_ITEM_ID, CONFIG_CODE FROM PS_CP_OPT_HDR WHERE CONFIG_CODE <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
2	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator