VIEW: BOM.CST_INQUIRY_TEMP#

Source

View Text - Preformatted

select SESSION_ID SESSION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, COST_TYPE_ID COST_TYPE_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, OPERATION_SEQUENCE_ID OPERATION_SEQUENCE_ID, DEPARTMENT_ID DEPARTMENT_ID, ACTIVITY_ID ACTIVITY_ID, RESOURCE_ID RESOURCE_ID, ITEM_COST ITEM_COST, COST_ELEMENT_ID COST_ELEMENT_ID, THIS_LEVEL_COSTS THIS_LEVEL_COSTS, PREVIOUS_LEVEL_COSTS PREVIOUS_LEVEL_COSTS, COLUMN1_VALUE_2A COLUMN1_VALUE_2A, COLUMN2_VALUE_2A COLUMN2_VALUE_2A, COLUMN1_VALUE_2B COLUMN1_VALUE_2B, COLUMN2_VALUE_2B COLUMN2_VALUE_2B, DESCRIPTION_COLUMN DESCRIPTION_COLUMN, VALUE_ADDED_ACTIVITY_FLAG VALUE_ADDED_ACTIVITY_FLAG, GUI_COLUMN1 GUI_COLUMN1, GUI_COLUMN2 GUI_COLUMN2, GUI_DESCRIPTION GUI_DESCRIPTION, YIELDED_COSTS YIELDED_COSTS from "BOM"."CST_INQUIRY_TEMP"

View Text - HTML Formatted

SELECT SESSION_ID SESSION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, COST_TYPE_ID COST_TYPE_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, OPERATION_SEQUENCE_ID OPERATION_SEQUENCE_ID
, DEPARTMENT_ID DEPARTMENT_ID
, ACTIVITY_ID ACTIVITY_ID
, RESOURCE_ID RESOURCE_ID
, ITEM_COST ITEM_COST
, COST_ELEMENT_ID COST_ELEMENT_ID
, THIS_LEVEL_COSTS THIS_LEVEL_COSTS
, PREVIOUS_LEVEL_COSTS PREVIOUS_LEVEL_COSTS
, COLUMN1_VALUE_2A COLUMN1_VALUE_2A
, COLUMN2_VALUE_2A COLUMN2_VALUE_2A
, COLUMN1_VALUE_2B COLUMN1_VALUE_2B
, COLUMN2_VALUE_2B COLUMN2_VALUE_2B
, DESCRIPTION_COLUMN DESCRIPTION_COLUMN
, VALUE_ADDED_ACTIVITY_FLAG VALUE_ADDED_ACTIVITY_FLAG
, GUI_COLUMN1 GUI_COLUMN1
, GUI_COLUMN2 GUI_COLUMN2
, GUI_DESCRIPTION GUI_DESCRIPTION
, YIELDED_COSTS YIELDED_COSTS
FROM "BOM"."CST_INQUIRY_TEMP"