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

TABLE: PA.PA_ALLOC_EXCEPTIONS

Object Details
Object Name: PA_ALLOC_EXCEPTIONS
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_ALLOC_EXCEPTIONS
Subobject Name:
Status: VALID


PA_ALLOC_EXCEPTIONS stores all exceptions in an allocation run.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_ALLOC_EXCEPTIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRUN_ID
ColumnLEVEL_CODE
ColumnEXCEPTION_TYPE
Columns
Name Datatype Length Mandatory Comments
RUN_ID NUMBER
Yes Allocation run identification number
RULE_ID NUMBER
Yes Allocation rule identification number
LEVEL_CODE VARCHAR2 (1) Yes It can be R(rule), S(source), T (target), B (basis) or O(offset)
EXCEPTION_TYPE VARCHAR2 (1) Yes Exception type. It can be W(warning) or E(error)
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
PROJECT_ID NUMBER

Project ID
TASK_ID NUMBER

Task ID
EXCEPTION_CODE VARCHAR2 (30)
Exception code to indicate exceptions
Query Text

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


SELECT RUN_ID
,      RULE_ID
,      LEVEL_CODE
,      EXCEPTION_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROJECT_ID
,      TASK_ID
,      EXCEPTION_CODE
FROM PA.PA_ALLOC_EXCEPTIONS;

Dependencies

[top of page]

PA.PA_ALLOC_EXCEPTIONS does not reference any database object

PA.PA_ALLOC_EXCEPTIONS is referenced by following:

SchemaPA
ViewPA_ALLOC_EXCEPTIONS#