[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 |