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: GMF.GL_EVNT_PLC

Object Details

Object Name:	GL_EVNT_PLC
Object Type:	TABLE
Owner:	GMF
FND Design Data:	GMF.GL_EVNT_PLC
Subobject Name:
Status:	VALID

This table contains the Event specific Company Fiscal Policy
information.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_EVNT_PLC_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	EVNT_PLC_ID
GL_EVNT_PLC_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEGAL_ENTITY_ID ENTITY_CODE EVENT_CLASS_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
EVNT_PLC_ID	NUMBER	(15)	Yes	Surrogate for the row
CO_CODE	VARCHAR2	(4)		Company for which the Event fiscal policy is defined
TRANS_SOURCE_TYPE	NUMBER	(5)		Source within the Company for which the Fiscal policy is defined. A NULL value indicates all sources.
EVENT_TYPE	NUMBER	(5)		Event within the Source for which the Fiscal policy is defined. A NULL value indicates all Events.
SUMMARIZE_FLAG	NUMBER	(5)	Yes	Indcator to summarize sub-ledger data before creating voucher. 0 = Do Not Sum Subevents for Journal Voucher; 1 = Sum Subevents for Journal Voucher.
GL_INTERFACE_FLAG	NUMBER	(5)	Yes	*** OBSOLETE COLUMN ***
STD_ACTUAL_IND	NUMBER	(5)		For the PO receipt financial implication, 0=Book inventory at Standard cost (calculate PPV); 1=Book Inventory at PO unit price (no PPV).
EXP_BOOKED_IND	NUMBER	(5)		0=Expenses are booked at AP Invoice entry; 1=Expenses are booked at PO receipt.
ACQUIS_COST_IND	NUMBER	(5)		0=Acquisition cost is accrued to the item A/P account; 1=Acquisition cost is accrued to its own accrual account.
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
TRANS_CNT	NUMBER	(10)		Not currently used
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
ENTITY_CODE	VARCHAR2	(30)		SLA Event Entity
EVENT_CLASS_CODE	VARCHAR2	(30)		SLA Event Class
LEGAL_ENTITY_ID	NUMBER	(15)		legal entity identifier
INTERNAL_ORDER_INV_IND	NUMBER	(15)		Internal Order INV indicato

Query Text

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


SELECT EVNT_PLC_ID
,      CO_CODE
,      TRANS_SOURCE_TYPE
,      EVENT_TYPE
,      SUMMARIZE_FLAG
,      GL_INTERFACE_FLAG
,      STD_ACTUAL_IND
,      EXP_BOOKED_IND
,      ACQUIS_COST_IND
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      TEXT_CODE
,      DELETE_MARK
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      LEGAL_ENTITY_ID
,      INTERNAL_ORDER_INV_IND
FROM GMF.GL_EVNT_PLC;

Dependencies

[top of page]

GMF.GL_EVNT_PLC does not reference any database object

GMF.GL_EVNT_PLC is referenced by following:

GMF: GL_EVNT_PLC#