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_ELEMENT_OPYLD_COST_VIEW

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.CST_ELEMENT_OPYLD_COST_VIEW

View Text

SELECT USERENV('SESSIONID')
, CICD.INVENTORY_ITEM_ID
, CICD.ORGANIZATION_ID
, CICD.COST_TYPE_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, SUM(CICD.ITEM_COST)
, NVL(CICD.COST_ELEMENT_ID
, -1)
, SUM(DECODE(CICD.LEVEL_TYPE
, '1'
, CICD.ITEM_COST
, 0))
, SUM(DECODE(CICD.LEVEL_TYPE
, '2'
, CICD.ITEM_COST
, 0))
, SUM(NVL(CICD.YIELDED_COST
, 0))
, CCE.COST_ELEMENT
, NULL
, NULL
, CCE.COST_ELEMENT
, CCE.DESCRIPTION
, NULL
, CCE.COST_ELEMENT
, CCE.DESCRIPTION
FROM CST_ITEM_COST_DETAILS CICD
, CST_COST_ELEMENTS CCE
WHERE CCE.COST_ELEMENT_ID (+) = CICD.COST_ELEMENT_ID GROUP BY USERENV('SESSIONID')
, CICD.INVENTORY_ITEM_ID
, CICD.ORGANIZATION_ID
, CICD.COST_TYPE_ID
, CICD.COST_ELEMENT_ID
, CCE.COST_ELEMENT
, CCE.DESCRIPTION

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
YIELDED_COSTS
COLUMN1_VALUE_2A
COLUMN2_VALUE_2A
COLUMN1_VALUE_2B
COLUMN2_VALUE_2B
DESCRIPTION_COLUMN
GUI_COLUMN1
GUI_COLUMN2
GUI_DESCRIPTION