DBA Data[Home] [Help] [Dependency Information]

TABLE: CSP.CSP_USAGE_HEADERS

Object Details
Object Name: CSP_USAGE_HEADERS
Object Type: TABLE
Owner: CSP
FND Design Data: TableCSP.CSP_USAGE_HEADERS
Subobject Name:
Status: VALID


CSP_USAGE_HEADERS stores information about the summary data generated by "Create ASL Recommendations" concurrent program. INVENTORY_ITEM_ID identifies the Item. PLANNING_PARAMETERS_ID identify the Planning Parameters used. SECONDARY_INVENTORY identifies the recommendations Subinventory. ORGANIZATION_ID identifies the recommendations Organization. HEADER_DATA_TYPE identifies the summary level viz., 1 - Subinventory, 3 -Planning Top Node, 4 - Organization. PROCESS_STATUS identifies the recommedations status like Open, Completed or Rejected. RAW_AWU and AWU identify the Average Weekly Usage calculated. STANDARD_DEVIATION identify the Standard Deviation calculated. RECOMMENDED_MIN and RECOMMENDED_MAX identify the Minimum and Maximum recommeded values respectively. EXTERNAL_DATA Yes/No identify Automatic generation or Manual load of recommendations data. ITEM_COST identify the Standard cost of the item. LEAD_TIME identify the Lead time between Organizations in the Supply Chain.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSP_USAGE_HEADERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnUSAGE_HEADER_ID
CSP_USAGE_HEADERS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnINVENTORY_ITEM_ID
CSP_USAGE_HEADERS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnSECONDARY_INVENTORY
CSP_USAGE_HEADERS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLANNING_PARAMETERS_ID
Columns
Name Datatype Length Mandatory Comments
USAGE_HEADER_ID NUMBER (35)
Usage Header unique identifier
INVENTORY_ITEM_ID NUMBER (35) Yes Inventory Item identifier
CREATED_BY NUMBER (35) Yes Standard Who column - with the user id from FND_USER
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (35) Yes Standard Who column - with the user id from FND_USER
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (35)
Standard Who column
ORGANIZATION_ID NUMBER (35)
Organization identifier
SECONDARY_INVENTORY VARCHAR2 (10)
Subinventory identifier
RAW_AWU NUMBER

Raw Average Weekly Usage
AWU NUMBER

Average Weekly Usage
HEADER_DATA_TYPE VARCHAR2 (30)
Header Data Type identifier
STANDARD_DEVIATION NUMBER (35)
Standard Deviation value
PLANNING_PARAMETERS_ID NUMBER (35)
Planning Parameters identifier
ITEM_COST NUMBER

Standard Cost of the Item
LEAD_TIME NUMBER

Lead time value
PROCESS_STATUS VARCHAR2 (30)
Recoomendations Status Open, Completed or Rejected
RECOMMENDED_MIN_QUANTITY NUMBER (35)
Recommended Minimum Value
RECOMMENDED_MAX_QUANTITY NUMBER (35)
Recommended Maximum value
EXTERNAL_DATA VARCHAR2 (30)
Automatic recommendations generation or Manual Load
COMMENTS VARCHAR2 (240)
Comments
SECURITY_GROUP_ID NUMBER (35)
Used in hosted environments
TRACKING_SIGNAL VARCHAR2 (240)
Tracking signal
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT USAGE_HEADER_ID
,      INVENTORY_ITEM_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_ID
,      SECONDARY_INVENTORY
,      RAW_AWU
,      AWU
,      HEADER_DATA_TYPE
,      STANDARD_DEVIATION
,      PLANNING_PARAMETERS_ID
,      ITEM_COST
,      LEAD_TIME
,      PROCESS_STATUS
,      RECOMMENDED_MIN_QUANTITY
,      RECOMMENDED_MAX_QUANTITY
,      EXTERNAL_DATA
,      COMMENTS
,      SECURITY_GROUP_ID
,      TRACKING_SIGNAL
FROM CSP.CSP_USAGE_HEADERS;

Dependencies

[top of page]

CSP.CSP_USAGE_HEADERS does not reference any database object

CSP.CSP_USAGE_HEADERS is referenced by following:

SchemaCSP
ViewCSP_USAGE_HEADERS#