[Home] [Help] [Dependency Information]
Object Name: | CSP_USAGE_HISTORIES |
---|---|
Object Type: | TABLE |
Owner: | CSP |
FND Design Data: | CSP.CSP_USAGE_HISTORIES |
Subobject Name: | |
Status: | VALID |
CSP_USAGE_HISTORIES stores the information generated by the concurrent program "Create Usage History". This is summarized information for usage transactions and sales order transactions. Information for all service parts in all levels of reporting hierarchies and parts loops is stored. The information is also generated for the 2 period types supported. TRANSACTION_TYPE_ID identifies the transaction type.
CSP_USAGE_HISTORIES also stores the Usage History and Forecast generated by "Create ASL recommendations" concurrent program. The Usage Data generated by this concurrent program is identified by unique value for each level in the column HEADER_DATA_TYPE viz., 1 - Subinventory level Usage Data, 2 -Organization and Subinventory level Forecast Data, 3 - Top Node level Usage Data, 4 - Organization Level Usage Data, 5 - Subinventory Level Usage data for the number of History periods specified for the subinventory other than the Actual Usage periods for the Subinventory , 6 - Organization Level Usage data for the number of History periods specified for the Organization other than the Actual Usage periods for the Organization. USAGE_HEADER_ID identifies the recommendations summary for the Usage.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CSP_USAGE_HISTORIES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | USAGE_ID |
CSP_USAGE_HISTORIES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PARTS_LOOP_ID |
CSP_USAGE_HISTORIES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | HIERARCHY_NODE_ID |
CSP_USAGE_HISTORIES_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
SUBINVENTORY_CODE INVENTORY_ITEM_ID HISTORY_DATA_TYPE PERIOD_START_DATE HIERARCHY_NODE_ID PARTS_LOOP_ID PERIOD_TYPE TRANSACTION_TYPE_ID |
CSP_USAGE_HISTORIES_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
INVENTORY_ITEM_ID HISTORY_DATA_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USAGE_ID | NUMBER | (35) | Usage history unique identifier | |
CREATED_BY | NUMBER | (35) | Yes | Standard Who column - with user id from FND_USER |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Yes | Standard Who column - with user id from FND_USER |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
REQUEST_ID | NUMBER | (35) | Standard Who column | |
PROGRAM_APPLICATION_ID | NUMBER | (35) | Standard Who column | |
PROGRAM_ID | NUMBER | (35) | Standard Who column | |
PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
INVENTORY_ITEM_ID | NUMBER | (35) | Yes | Inventory item identifier |
ORGANIZATION_ID | NUMBER | (35) | Yes | Organization identifier |
HIERARCHY_NODE_ID | NUMBER | (35) | Reporting hierarchy node identifier | |
PARTS_LOOP_ID | NUMBER | (35) | Parts loop identifier | |
SUBINVENTORY_CODE | VARCHAR2 | (30) | Yes | Subinventory identifier |
PERIOD_TYPE | VARCHAR2 | (30) | Yes | Period type. 1=Weekly 2=Periodic |
PERIOD_START_DATE | DATE | Yes | Period start date | |
TRANSACTION_TYPE_ID | NUMBER | (35) | Transaction type identifier | |
QUANTITY | NUMBER | (35) | Yes | Quantity |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
USAGE_HEADER_ID | VARCHAR2 | (240) | CSP_USAGE_HEADERS Foreign Key. | |
HISTORY_DATA_TYPE | VARCHAR2 | (240) | Yes | Usage History Data Type |
Cut, paste (and edit) the following text to query this object:
SELECT USAGE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, HIERARCHY_NODE_ID
, PARTS_LOOP_ID
, SUBINVENTORY_CODE
, PERIOD_TYPE
, PERIOD_START_DATE
, TRANSACTION_TYPE_ID
, QUANTITY
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, USAGE_HEADER_ID
, HISTORY_DATA_TYPE
FROM CSP.CSP_USAGE_HISTORIES;
CSP.CSP_USAGE_HISTORIES does not reference any database object
CSP.CSP_USAGE_HISTORIES is referenced by following:
|
|
|