CP_COST_VW (SQL View)	Index Back
CP Configured Cost View The view contains the cost for configured items. It is a summary of all cost elements to show the cost of the configuration at this level and at lower levels.

CP_COST_VW

(SQL View)

CP Configured Cost View

The view contains the cost for configured items. It is a summary of all cost elements to show the cost of the configuration at this level and at lower levels.

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.CONFIG_CODE , SUM(A.TL_COST) , SUM(A.LL_COST) FROM PS_CM_PRODCOST A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_CM_PRODCOST B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.CONFIG_CODE = B.CONFIG_CODE AND B.EFFDT <= %CurrentDateIn) GROUP BY A.BUSINESS_UNIT, A.INV_ITEM_ID, A.CONFIG_CODE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.

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

4 TL_COST Number(15,4) DECIMAL(14,4) NOT NULL This Level Cost

5 LL_COST Number(15,4) DECIMAL(14,4) NOT NULL Lower Level Cost

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	COMPONENT_ID	Character(18)	VARCHAR2(18) NOT NULL	04/10/00 (Internet Architecture) SCC: Uppercase label Id.
3	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator
4	TL_COST	Number(15,4)	DECIMAL(14,4) NOT NULL	This Level Cost
5	LL_COST	Number(15,4)	DECIMAL(14,4) NOT NULL	Lower Level Cost