eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AMS.AMS_APPROVAL_HISTORY

Object Details

Object Name:	AMS_APPROVAL_HISTORY
Object Type:	TABLE
Owner:	AMS
FND Design Data:	AMS.AMS_APPROVAL_HISTORY
Subobject Name:
Status:	VALID

This table stores the approval history for a marketing object like Campaign, Event etc.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_APPROVAL_HISTORY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_ID OBJECT_TYPE_CODE APPROVAL_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_ID	NUMBER		Yes	Unique Identifier of the Marketing Object
OBJECT_TYPE_CODE	VARCHAR2	(25)	Yes	Marketing Object Type like 'CAMP', 'EVEH' etc.
SEQUENCE_NUM	NUMBER		Yes	Approver Sequence
OBJECT_VERSION_NUM	NUMBER	(9)	Yes	The Version Number of the Marketing Object being approved
LAST_UPDATE_DATE	DATE		Yes	Stanadard WHO
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO
CREATION_DATE	DATE		Yes	Standard WHO
CREATED_BY	NUMBER	(15)	Yes	Standard WHO
ACTION_CODE	VARCHAR2	(25)		Type of Approval Action
ACTION_DATE	DATE			Approval Action Date
APPROVER_ID	NUMBER			Resource ID of Approver
APPROVAL_DETAIL_ID	NUMBER			Approval Rule Identifier
NOTE	VARCHAR2	(4000)		Approvers Note
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO
APPROVAL_TYPE	VARCHAR2	(30)		Concept or Budget Approval?
APPROVER_TYPE	VARCHAR2	(30)		User, Function or Role
CUSTOM_SETUP_ID	NUMBER			Custom Setup of Object. Not Used.
LOG_MESSAGE	VARCHAR2	(2000)		For Future Use.
SECURITY_GROUP_ID	NUMBER			Internal use

Query Text

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


SELECT OBJECT_ID
,      OBJECT_TYPE_CODE
,      SEQUENCE_NUM
,      OBJECT_VERSION_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      ACTION_CODE
,      ACTION_DATE
,      APPROVER_ID
,      APPROVAL_DETAIL_ID
,      NOTE
,      LAST_UPDATE_LOGIN
,      APPROVAL_TYPE
,      APPROVER_TYPE
,      CUSTOM_SETUP_ID
,      LOG_MESSAGE
,      SECURITY_GROUP_ID
FROM AMS.AMS_APPROVAL_HISTORY;

Dependencies

[top of page]

AMS.AMS_APPROVAL_HISTORY does not reference any database object

AMS.AMS_APPROVAL_HISTORY is referenced by following:

APPS: AMS_APPROVAL_HISTORY