[Home] [Help] [Dependency Information]
Object Name: | QA_SEQ_AUDIT_HISTORY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | QA.QA_SEQ_AUDIT_HISTORY_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Yes | plan ID | |
PLAN_NAME | VARCHAR2 | (30) | Yes | plan name |
PLAN_DESCRIPTION | VARCHAR2 | (150) | plan description | |
ORGANIZATION_ID | NUMBER | Yes | organization ID | |
ORGANIZATION_CODE | VARCHAR2 | (3) | organization code | |
COLLECTION_ID | NUMBER | Yes | collection ID | |
OCCURRENCE | NUMBER | Yes | occurrence | |
CHAR_ID | NUMBER | Yes | element ID | |
CHAR_NAME | VARCHAR2 | (30) | Yes | element name |
SEQUENCE_VALUE | VARCHAR2 | (50) | Yes | the generated sequence value |
TXN_HEADER_ID | NUMBER | txn header ID | ||
USER_ID | NUMBER | Yes | user ID | |
USER_NAME | VARCHAR2 | (100) | Yes | user name |
SOURCE_CODE | VARCHAR2 | (30) | source code | |
SOURCE_ID | NUMBER | source ID | ||
AUDIT_TYPE | VARCHAR2 | (30) | Yes | audit type |
AUDIT_TYPE_MEANING | VARCHAR2 | (80) | Yes | audit type meaning |
AUDIT_TYPE_DESCRIPTION | VARCHAR2 | (240) | audit type description | |
AUDIT_DATE | DATE | Yes | audit date | |
LAST_UPDATE_DATE | DATE | Yes | standard WHO column | |
LAST_UPDATED_BY | NUMBER | Yes | standard WHO column | |
CREATION_DATE | DATE | Yes | standard WHO column | |
CREATED_BY | NUMBER | Yes | standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | standard WHO column |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, PLAN_NAME
, PLAN_DESCRIPTION
, ORGANIZATION_ID
, ORGANIZATION_CODE
, COLLECTION_ID
, OCCURRENCE
, CHAR_ID
, CHAR_NAME
, SEQUENCE_VALUE
, TXN_HEADER_ID
, USER_ID
, USER_NAME
, SOURCE_CODE
, SOURCE_ID
, AUDIT_TYPE
, AUDIT_TYPE_MEANING
, AUDIT_TYPE_DESCRIPTION
, AUDIT_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM APPS.QA_SEQ_AUDIT_HISTORY_V;
APPS.QA_SEQ_AUDIT_HISTORY_V is not referenced by any database object
|
|
|