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

TABLE: CSP.CSP_POPULATION_CHANGES

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


Stores population changes over time for a product. This is used for Warehouse replenishment planning to forecast the need for spare parts for the product.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSP_POPULATION_CHANGES_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOPULATION_CHANGES_ID
Columns
Name Datatype Length Mandatory Comments
PRODUCT_ID NUMBER

Product Identifier
POPULATION_CHANGES_ID NUMBER (38) Yes Unique identifier for the population change record.
ORGANIZATION_ID NUMBER

Organization Identifier
START_DATE DATE
Yes Start date for the population change.
END_DATE DATE
Yes End date for the population change.
POPULATION_CHANGE NUMBER (38) Yes Population change quantity.
CREATION_DATE DATE
Yes Standard WHO column.
CREATED_BY NUMBER (38) Yes Standard WHO column.
LAST_UPDATE_DATE DATE
Yes Standard WHO column.
LAST_UPDATED_BY NUMBER (38) Yes Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (38)
Standard WHO column.
SECURITY_GROUP_ID NUMBER (38)
Used in hosted environments
OBJECT_VERSION NUMBER (38)
Object version.
Query Text

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


SELECT PRODUCT_ID
,      POPULATION_CHANGES_ID
,      ORGANIZATION_ID
,      START_DATE
,      END_DATE
,      POPULATION_CHANGE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION
FROM CSP.CSP_POPULATION_CHANGES;

Dependencies

[top of page]

CSP.CSP_POPULATION_CHANGES does not reference any database object

CSP.CSP_POPULATION_CHANGES is referenced by following:

SchemaCSP
ViewCSP_POPULATION_CHANGES#