[Home] [Help] [Dependency Information]
Object Name: | CST_INQUIRY_TEMP |
---|---|
Object Type: | TABLE |
Owner: | BOM |
FND Design Data: | BOM.CST_INQUIRY_TEMP |
Subobject Name: | |
Status: | VALID |
CST_INQUIRY_TEMP stores item cost information used by the View Item
Cost Information window for each inquiry session. The window has two
templates (summary and summary by level) to display item costs.
Tablespace: | APPS_TS_NOLOGGING |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CST_INQUIRY_TEMP_N1 | NORMAL | NONUNIQUE | APPS_TS_NOLOGGING | SESSION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESSION_ID | NUMBER | Yes | Oracle session identifier | |
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier | |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
COST_TYPE_ID | NUMBER | Yes | Cost type identifier | |
OPERATION_SEQ_NUM | NUMBER | Operation sequence number in a routing | ||
OPERATION_SEQUENCE_ID | NUMBER | Operation sequence identifier | ||
DEPARTMENT_ID | NUMBER | Department identifier | ||
ACTIVITY_ID | NUMBER | Activity identifier | ||
RESOURCE_ID | NUMBER | Resource identifier (subelement) | ||
ITEM_COST | NUMBER | Yes | Item unit cost | |
COST_ELEMENT_ID | NUMBER | Cost element identifier | ||
THIS_LEVEL_COSTS | NUMBER | This level cost | ||
PREVIOUS_LEVEL_COSTS | NUMBER | Previous level cost | ||
COLUMN1_VALUE_2A | VARCHAR2 | (240) | Column 1 value for the Summary By Level template in the View Item Cost information | |
COLUMN2_VALUE_2A | VARCHAR2 | (240) | Column 2 value for the Summary By Level template in the View Item Cost information | |
COLUMN1_VALUE_2B | VARCHAR2 | (240) | Column 1 value for the Summary template in the View Item Cost information | |
COLUMN2_VALUE_2B | VARCHAR2 | (240) | Column 2 value for the Summary template in the View Item Cost information | |
DESCRIPTION_COLUMN | VARCHAR2 | (240) | Column 3 value for the Summary template in the View Item Cost information | |
VALUE_ADDED_ACTIVITY_FLAG | NUMBER | Not currently used | ||
GUI_COLUMN1 | VARCHAR2 | (240) | Activity | |
GUI_COLUMN2 | VARCHAR2 | (240) | Department code | |
GUI_DESCRIPTION | VARCHAR2 | (240) | Description | |
YIELDED_COSTS | NUMBER | Inflation in item cost for operation yield in WSM organizations |
Cut, paste (and edit) the following text to query this object:
SELECT 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
, VALUE_ADDED_ACTIVITY_FLAG
, GUI_COLUMN1
, GUI_COLUMN2
, GUI_DESCRIPTION
, YIELDED_COSTS
FROM BOM.CST_INQUIRY_TEMP;
BOM.CST_INQUIRY_TEMP does not reference any database object
BOM.CST_INQUIRY_TEMP is referenced by following:
|
|
|