eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: CST_TOTAL_COST_VIEW

Product:	BOM - Bills of Material
Description:	Total item cost view : SINGLE-ORG view
Implementation/DBA Data:	APPS.CST_TOTAL_COST_VIEW

View Text

SELECT USERENV('SESSIONID')
, CIC.INVENTORY_ITEM_ID
, CIC.ORGANIZATION_ID
, CIC.COST_TYPE_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, CIC.ITEM_COST
, NULL
, CIC.TL_ITEM_COST
, CIC.PL_ITEM_COST
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM CST_ITEM_COSTS CIC

Columns

Name
SESSION_ID
INVENTORY_ITEM_ID
ORGANIZATION_ID
COST_TYPE_ID
OPERATION_SEQ_NUM
OPERATION_SEQUENCE_ID
DEPARTMENT_ID
ACTIVITY_ID
RESOURCE_ID
ITEM_COST
COST_ELEMENT_ID
THIS_LEVEL_COSTS
PREVIOUS_LEVEL_COSTS
COLUMN1_VALUE_2A
COLUMN2_VALUE_2A
COLUMN1_VALUE_2B
COLUMN2_VALUE_2B
DESCRIPTION_COLUMN
GUI_COLUMN1
GUI_COLUMN2
GUI_DESCRIPTION