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

VIEW: APPS.OE_AUDIT_ATTR_DESC_V

Object Details
Object Name: OE_AUDIT_ATTR_DESC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewONT.OE_AUDIT_ATTR_DESC_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ENTITY_ID NUMBER

Transaction entity
ENTITY_DISPLAY_NAME VARCHAR2 (30)
ATTRIBUTE_ID NUMBER

Attribute ID for entity
ATTRIBUTE_DISPLAY_NAME VARCHAR2 (4000)
OLD_DISPLAY_VALUE VARCHAR2 (4000)
NEW_DISPLAY_VALUE VARCHAR2 (4000)
HIST_CREATION_DATE DATE

ORDER_NUMBER NUMBER

ENTITY_NUMBER NUMBER

ORG_ID NUMBER

REASON VARCHAR2 (80)
HIST_COMMENTS VARCHAR2 (2000)
USER_ID NUMBER

USER_NAME VARCHAR2 (100) Yes
RESPONSIBILITY_ID NUMBER

RESPONSIBILITY_NAME VARCHAR2 (100) Yes
OLD_CONTEXT_VALUE VARCHAR2 (30)
NEW_CONTEXT_VALUE VARCHAR2 (30)
Query Text

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


SELECT ENTITY_ID
,      ENTITY_DISPLAY_NAME
,      ATTRIBUTE_ID
,      ATTRIBUTE_DISPLAY_NAME
,      OLD_DISPLAY_VALUE
,      NEW_DISPLAY_VALUE
,      HIST_CREATION_DATE
,      ORDER_NUMBER
,      ENTITY_NUMBER
,      ORG_ID
,      REASON
,      HIST_COMMENTS
,      USER_ID
,      USER_NAME
,      RESPONSIBILITY_ID
,      RESPONSIBILITY_NAME
,      OLD_CONTEXT_VALUE
,      NEW_CONTEXT_VALUE
FROM APPS.OE_AUDIT_ATTR_DESC_V;

Dependencies

[top of page]

APPS.OE_AUDIT_ATTR_DESC_V references the following:

SchemaAPPS
SynonymFND_RESPONSIBILITY_TL
SynonymFND_USER
SynonymOE_AUDIT_ATTR_HISTORY
PL/SQL PackageOE_AUDIT_HISTORY_PVT - show dependent code
ViewOE_LOOKUPS
ViewOE_PC_ENTITIES_V

APPS.OE_AUDIT_ATTR_DESC_V is not referenced by any database object