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

TABLE: CSP.CSP_USAGE_ORGS

Object Details
Object Name: CSP_USAGE_ORGS
Object Type: TABLE
Owner: CSP
Subobject Name:
Status: VALID


Usage history for the inventory org.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER (38) Yes Organization identifier
INVENTORY_ITEM_ID NUMBER (38) Yes Inventory item identifier
PERIOD_START_DATE DATE
Yes Period start date
QUANTITY NUMBER (38)
Usage quantity
Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      PERIOD_START_DATE
,      QUANTITY
FROM CSP.CSP_USAGE_ORGS;

Dependencies

[top of page]

CSP.CSP_USAGE_ORGS does not reference any database object

CSP.CSP_USAGE_ORGS is referenced by following:

SchemaCSP
ViewCSP_USAGE_ORGS#