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: TableGMF.GL_EVNT_PLC
Subobject Name:
Status: VALID


This table contains the Event specific Company Fiscal Policy
information.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_EVNT_PLC_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEVNT_PLC_ID
GL_EVNT_PLC_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLEGAL_ENTITY_ID
ColumnENTITY_CODE
ColumnEVENT_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
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
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:

SchemaAPPS
SynonymGL_EVNT_PLC