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

TABLE: ZPB.ZPB_BP_VALIDATION_RESULTS

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

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000411116C00003$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
ZPB_BP_VAL_RES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnVAL_ID
Columns
Name Datatype Length Mandatory Comments
VAL_ID NUMBER
Yes
BUS_PROC_ID NUMBER
Yes Business Process Identifier
VAL_MESSAGE CLOB (4000) Yes Validation message name
MESSAGE_TYPE VARCHAR2 (1) Yes Message Type. Warning/Error
TIP1_TEXT VARCHAR2 (4000) Yes Tip Text
TIP1_LINK VARCHAR2 (4000) Yes Tip Link
TIP2_TEXT VARCHAR2 (4000)
Tip Text
TIP2_LINK VARCHAR2 (4000)
Tip Link
TIP3_TEXT VARCHAR2 (4000)
Tip Text
TIP3_LINK VARCHAR2 (4000)
Tip Link
TIP4_TEXT VARCHAR2 (4000)
Tip Text
TIP4_LINK VARCHAR2 (4000)
Tip Link
TIP5_TEXT VARCHAR2 (4000)
Tip Text
TIP5_LINK VARCHAR2 (4000)
Tip Link
CREATED_BY NUMBER (15) Yes Who Column
CREATION_DATE DATE
Yes Date on which the record was created
LAST_UPDATED_BY NUMBER (15) Yes Last updated login
LAST_UPDATE_DATE DATE
Yes Last updated date
LAST_UPDATE_LOGIN NUMBER (15)
Last updated user
Query Text

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


SELECT VAL_ID
,      BUS_PROC_ID
,      VAL_MESSAGE
,      MESSAGE_TYPE
,      TIP1_TEXT
,      TIP1_LINK
,      TIP2_TEXT
,      TIP2_LINK
,      TIP3_TEXT
,      TIP3_LINK
,      TIP4_TEXT
,      TIP4_LINK
,      TIP5_TEXT
,      TIP5_LINK
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM ZPB.ZPB_BP_VALIDATION_RESULTS;

Dependencies

[top of page]

ZPB.ZPB_BP_VALIDATION_RESULTS does not reference any database object

ZPB.ZPB_BP_VALIDATION_RESULTS is referenced by following:

SchemaAPPS
SynonymZPB_BP_VALIDATION_RESULTS