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

TABLE: ZPB.ZPB_AC_PARAM_VALUES

Object Details
Object Name: ZPB_AC_PARAM_VALUES
Object Type: TABLE
Owner: ZPB
Subobject Name:
Status: VALID


This table is used to store the parameters for defining the Business Process. e.g. for the Calendar definition.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ZPB_AC_PARAM_VALUES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnANALYSIS_CYCLE_ID
ColumnPARAM_ID
ZPB_AC_PARAM_VALUES_INDEX NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnANALYSIS_CYCLE_ID
Columns
Name Datatype Length Mandatory Comments
ANALYSIS_CYCLE_ID NUMBER
Yes A unique identifier of a Business Process, for which we are storing parameters - refers to ZPB_ANALYSIS_CYCLES.ANALYSIS_CYCLE_ID
PARAM_ID NUMBER
Yes A unique identifier used to identify the parameter within the Business Process, for which we are storing the values.
VALUE VARCHAR2 (100) Yes Stores the values for the parameters within the Business Process.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
Query Text

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


SELECT ANALYSIS_CYCLE_ID
,      PARAM_ID
,      VALUE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM ZPB.ZPB_AC_PARAM_VALUES;

Dependencies

[top of page]

ZPB.ZPB_AC_PARAM_VALUES does not reference any database object

ZPB.ZPB_AC_PARAM_VALUES is referenced by following:

SchemaAPPS
SynonymZPB_AC_PARAM_VALUES