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

TABLE: CSP.CSP_PRODUCT_POPULATIONS

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


This table stores the population of a product in a region. It also stores population changes used in the Product Norm planning.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSP_PRODUCT_POPULATIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRODUCT_POPULATION_ID
CSP_PRODUCT_POPULATIONS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRODUCT_ID
ColumnPLANNING_PARAMETERS_ID
Columns
Name Datatype Length Mandatory Comments
PRODUCT_POPULATION_ID NUMBER (38) Yes Unique identifier for product population
CREATED_BY NUMBER (38) Yes Standard Who column - with user id from FND_USER
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (38) Yes Standard Who column - with user id from FND_USER
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (38)
Standard Who column
PLANNING_PARAMETERS_ID NUMBER (38) Yes planning parameter id
PRODUCT_ID NUMBER (38) Yes Product id
CURRENT_POPULATION NUMBER (38)
Current population
POPULATION_CHANGE NUMBER (38)
Population Change
SECURITY_GROUP_ID NUMBER (38)
Used in hosted environments
Query Text

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


SELECT PRODUCT_POPULATION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PLANNING_PARAMETERS_ID
,      PRODUCT_ID
,      CURRENT_POPULATION
,      POPULATION_CHANGE
,      SECURITY_GROUP_ID
FROM CSP.CSP_PRODUCT_POPULATIONS;

Dependencies

[top of page]

CSP.CSP_PRODUCT_POPULATIONS does not reference any database object

CSP.CSP_PRODUCT_POPULATIONS is referenced by following:

SchemaCSP
ViewCSP_PRODUCT_POPULATIONS#