[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CSP_POPULATION_CHANGES_U1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | POPULATION_CHANGES_ID |
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. |
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;
CSP.CSP_POPULATION_CHANGES does not reference any database object
CSP.CSP_POPULATION_CHANGES is referenced by following:
|
|
|