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: GMS.GMS_EVENT_INTERSECT

Object Details

Object Name:	GMS_EVENT_INTERSECT
Object Type:	TABLE
Owner:	GMS
FND Design Data:	GMS.GMS_EVENT_INTERSECT
Subobject Name:
Status:	VALID

GMS_EVENT_INTERSECT holds information about the expenditure items that are processed for billing and revenue accrual under the cost distribution rule.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMS_EVENT_INTERSECT_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXPENDITURE_ITEM_ID EVENT_NUM REQUEST_ID EVENT_TYPE AWARD_PROJECT_ID ADL_LINE_NUM
GMS_EVENT_INTERSECT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AWARD_PROJECT_ID REQUEST_ID
GMS_EVENT_INTERSECT_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REVENUE_ACCUMULATED EVENT_TYPE
GMS_EVENT_INTERSECT_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AWARD_PROJECT_ID EVENT_NUM EXPENDITURE_ITEM_ID EVENT_TYPE
GMS_EVENT_INTERSECT_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REVENUE_ACCUMULATED

Columns

Name	Datatype	Length	Mandatory	Comments
EXPENDITURE_ITEM_ID	NUMBER	(15)	Yes	Unique identifier of expenditure item processed for billing or revenue
EVENT_NUM	NUMBER	(15)		Event number of automatic event for the award project created as a result of expenditure item being processed
AMOUNT	NUMBER	(22)	Yes	Amount of expenditure item that is billed
REQUEST_ID	NUMBER		Yes	Request identifier of the concurrent process that is processing expenditure item for billing or revenue. This, along with the project identifier, is used to update the event number and standard Who columns in the table.
EVENT_TYPE	VARCHAR2	(15)		Event type of the event created. Revenue indicates revenue generation events and Invoice indicates billing events.
AWARD_PROJECT_ID	NUMBER	(15)	Yes	Award project unique identifier associated with the award for which billing or revenue is run
ADL_LINE_NUM	NUMBER	(15)	Yes	Award Distribution line number
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
REVENUE_ACCUMULATED	VARCHAR2	(1)		Flag indicating revenue accumulation status in balances

Query Text

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


SELECT EXPENDITURE_ITEM_ID
,      EVENT_NUM
,      AMOUNT
,      REQUEST_ID
,      EVENT_TYPE
,      AWARD_PROJECT_ID
,      ADL_LINE_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REVENUE_ACCUMULATED
FROM GMS.GMS_EVENT_INTERSECT;

Dependencies

[top of page]

GMS.GMS_EVENT_INTERSECT does not reference any database object

GMS.GMS_EVENT_INTERSECT is referenced by following:

GMS: GMS_EVENT_INTERSECT#