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

TABLE: CSP.CSP_SAFETY_FACTORS

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


CSP_SAFETY_FACTORS stores information about the Safety factor lookup values based on Service Level and exposures. SERVICE_LEVEL identifies the Service Level value. EXPOSURES identify the exposures value calculated from Economic Delivery Quantity (EDQ). SAFETY_FACTOR identifies the Safety factor value based on Service Level and Exposures.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSP_SAFETY_FACTORS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnSAFETY_FACTOR_ID
CSP_SAFETY_FACTORS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnSERVICE_LEVEL
ColumnEXPOSURES
Columns
Name Datatype Length Mandatory Comments
SAFETY_FACTOR_ID NUMBER (35) Yes Safety Factor unique identifier
SERVICE_LEVEL NUMBER
Yes Service Level value
EXPOSURES NUMBER
Yes Exposures calculated from Economic Delivery Quantity (EDQ)
SAFETY_FACTOR NUMBER
Yes Safety Factor Value
CREATION_DATE DATE
Yes Standard WHO column
CREATED_BY NUMBER (35) Yes Standard Who column - with the user id from FND_USER
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER (35) Yes Standard Who column - with the user id from FND_USER
LAST_UPDATE_LOGIN NUMBER (35)
Standard WHO column
SECURITY_GROUP_ID NUMBER (35)
Used in hosted environments
Query Text

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


SELECT SAFETY_FACTOR_ID
,      SERVICE_LEVEL
,      EXPOSURES
,      SAFETY_FACTOR
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM CSP.CSP_SAFETY_FACTORS;

Dependencies

[top of page]

CSP.CSP_SAFETY_FACTORS does not reference any database object

CSP.CSP_SAFETY_FACTORS is referenced by following:

SchemaAPPS
SynonymCSP_SAFETY_FACTORS