[Home] [Help] [Dependency Information]
Object Name: | AMW_EXCEPTIONS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMW.AMW_EXCEPTIONS_VL |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Combination of exceptions _b and _tl tables
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXCEPTION_ID | NUMBER | Yes | Exception Identifier | |
OBJECT_TYPE | VARCHAR2 | (30) | Yes | Object Type to record the type of exception |
OLD_PK1 | VARCHAR2 | (100) | Primary Key of entity deleted/replaced | |
OLD_PK2 | VARCHAR2 | (100) | Primary Key of entity deleted/replaced | |
OLD_PK3 | VARCHAR2 | (100) | Primary Key of entity deleted/replaced | |
OLD_PK4 | VARCHAR2 | (100) | Primary Key of entity deleted/replaced | |
OLD_PK5 | VARCHAR2 | (100) | Primary Key of entity deleted/replaced | |
OLD_PK6 | VARCHAR2 | (100) | Primary Key of entity deleted/replaced | |
NEW_PK1 | VARCHAR2 | (100) | Primary Key of entity added/replaced with | |
NEW_PK2 | VARCHAR2 | (100) | Primary Key of entity added/replaced with | |
NEW_PK3 | VARCHAR2 | (100) | Primary Key of entity added/replaced with | |
NEW_PK4 | VARCHAR2 | (100) | Primary Key of entity added/replaced with | |
NEW_PK5 | VARCHAR2 | (100) | Primary Key of entity added/replaced with | |
NEW_PK6 | VARCHAR2 | (100) | Primary Key of entity added/replaced with | |
TRANSACTION_TYPE | VARCHAR2 | (30) | Yes | Transaction Type for recording exception |
TRANSACTION_DATE | DATE | Yes | Transaction Date | |
END_DATE | DATE | End Effectivity date for exception generating transaction | ||
LAST_UPDATE_DATE | DATE | Who Column | ||
LAST_UPDATED_BY | NUMBER | Who Column | ||
CREATION_DATE | DATE | Who Column | ||
CREATED_BY | NUMBER | Who Column | ||
LAST_UPDATE_LOGIN | NUMBER | Who Column | ||
SECURITY_GROUP_ID | NUMBER | Security Group Identifier | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | Object Version Number | |
JUSTIFICATION | VARCHAR2 | (4000) | Justification 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
, JUSTIFICATION
FROM APPS.AMW_EXCEPTIONS_VL;
APPS.AMW_EXCEPTIONS_VL is not referenced by any database object
|
|
|