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

TABLE: ZPB.ZPB_EXCP_RESULTS

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


Results of exception alert tasks. Information for members that satisfy the exception criteria are stored here


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ZPB_EXCP_RESULTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTASK_ID
ColumnMEMBER_ID
Columns
Name Datatype Length Mandatory Comments
TASK_ID NUMBER
Yes Foreign key into zpb_analysis_cycle_tasks
MEMBER_ID VARCHAR2 (240) Yes AW exception dimension member id
MEMBER_DISPLAY VARCHAR2 (240) Yes Exception member name
OWNER_ID NUMBER
Yes Foreign key into fnd_user
OWNER VARCHAR2 (100)
Owner display name
APPROVER_ID NUMBER
Yes Explanation approver id, frm fnd_user
APPROVER VARCHAR2 (100)
Apporver display name
VALUE_FLAG NUMBER
Yes Type of exceptional data
VALUE_CHAR VARCHAR2 (240)
Character exceptional data
VALUE_NUMBER NUMBER

Numeric exceptional data
VALUE_DATE DATE

Date exceptional data
CREATED_BY NUMBER (15) Yes Bookkeeping column
CREATION_DATE DATE
Yes Bookkeeping column
LAST_UPDATED_BY NUMBER (15) Yes Bookkeeping column
LAST_UPDATE_DATE DATE
Yes Bookkeeping column
LAST_UPDATE_LOGIN NUMBER (15)
Bookkeeping column
Query Text

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


SELECT TASK_ID
,      MEMBER_ID
,      MEMBER_DISPLAY
,      OWNER_ID
,      OWNER
,      APPROVER_ID
,      APPROVER
,      VALUE_FLAG
,      VALUE_CHAR
,      VALUE_NUMBER
,      VALUE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM ZPB.ZPB_EXCP_RESULTS;

Dependencies

[top of page]

ZPB.ZPB_EXCP_RESULTS does not reference any database object

ZPB.ZPB_EXCP_RESULTS is referenced by following:

SchemaAPPS
SynonymZPB_EXCP_RESULTS