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

TABLE: AMW.AMW_EXCEPTIONS_B

Object Details
Object Name: AMW_EXCEPTIONS_B
Object Type: TABLE
Owner: AMW
FND Design Data: TableAMW.AMW_EXCEPTIONS_B
Subobject Name:
Status: VALID


Stores the organization and process variation exceptions


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
EXCEPTION_ID NUMBER
Yes Exception Identifier
OBJECT_TYPE VARCHAR2 (30) Yes Type of the object involved in the exception
OLD_PK1 VARCHAR2 (100)
Primary Key for entity deleted/replaced
OLD_PK2 VARCHAR2 (100)
Primary Key for entity deleted/replaced
OLD_PK3 VARCHAR2 (100)
Primary Key for entity deleted/replaced
OLD_PK4 VARCHAR2 (100)
Primary Key for entity deleted/replaced
OLD_PK5 VARCHAR2 (100)
Primary Key for entity deleted/replaced
OLD_PK6 VARCHAR2 (100)
Primary Key for entity deleted/replaced
NEW_PK1 VARCHAR2 (100)
Primary Key for entity added/replaced with
NEW_PK2 VARCHAR2 (100)
Primary Key for entity added/replaced with
NEW_PK3 VARCHAR2 (100)
Primary Key for entity added/replaced with
NEW_PK4 VARCHAR2 (100)
Primary Key for entity added/replaced with
NEW_PK5 VARCHAR2 (100)
Primary Key for entity added/replaced with
NEW_PK6 VARCHAR2 (100)
Primary Key for entity added/replaced with
TRANSACTION_TYPE VARCHAR2 (30) Yes Transaction Type
TRANSACTION_DATE DATE
Yes Transaction Date
END_DATE DATE

End Date
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
SECURITY_GROUP_ID NUMBER

Used in hosted environments
OBJECT_VERSION_NUMBER NUMBER
Yes This column is used for optimistic locking.
EXCEPTION_OBJECT_ID NUMBER

Stores the exception object id
APPROVED_FLAG VARCHAR2 (1)
Stores the approved flag
Query Text

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


SELECT EXCEPTION_ID
,      OBJECT_TYPE
,      OLD_PK1
,      OLD_PK2
,      OLD_PK3
,      OLD_PK4
,      OLD_PK5
,      OLD_PK6
,      NEW_PK1
,      NEW_PK2
,      NEW_PK3
,      NEW_PK4
,      NEW_PK5
,      NEW_PK6
,      TRANSACTION_TYPE
,      TRANSACTION_DATE
,      END_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      EXCEPTION_OBJECT_ID
,      APPROVED_FLAG
FROM AMW.AMW_EXCEPTIONS_B;

Dependencies

[top of page]

AMW.AMW_EXCEPTIONS_B does not reference any database object

AMW.AMW_EXCEPTIONS_B is referenced by following:

SchemaAPPS
SynonymAMW_EXCEPTIONS_B