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

TABLE: GMF.GMF_PERIOD_STATUSES_GT

Object Details
Object Name: GMF_PERIOD_STATUSES_GT
Object Type: TABLE
Owner: GMF
FND Design Data: TableGMF.GMF_PERIOD_STATUSES_GT
Subobject Name:
Status: VALID

Global temporary table gmf_period_statuses_gt with on commit delete rows

Temporary Table Details

GMF.GMF_PERIOD_STATUSES_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
PERIOD_ID NUMBER (15)
period identifier
COST_TYPE_ID NUMBER (15)
cost type identifier
CALENDAR_CODE VARCHAR2 (10)
calendar code
PERIOD_CODE VARCHAR2 (10)
period code
PERIOD_STATUS VARCHAR2 (1)
period status
CREATION_DATE DATE

creation date
CREATED_BY NUMBER (15)
created by
LAST_UPDATE_DATE DATE

last update date
LAST_UPDATED_BY NUMBER (15)
last updated by
LAST_UPDATE_LOGIN NUMBER (15)
last update login
LEGAL_ENTITY_ID NUMBER (15)
legal entity identifier
START_DATE DATE

start date
END_DATE DATE

end date
DESCRIPTION VARCHAR2 (40)
period description
DELETE_MARK NUMBER

Delete Mark
TEXT_CODE NUMBER (10)
Query Text

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


SELECT PERIOD_ID
,      COST_TYPE_ID
,      CALENDAR_CODE
,      PERIOD_CODE
,      PERIOD_STATUS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LEGAL_ENTITY_ID
,      START_DATE
,      END_DATE
,      DESCRIPTION
,      DELETE_MARK
,      TEXT_CODE
FROM GMF.GMF_PERIOD_STATUSES_GT;

Dependencies

[top of page]

GMF.GMF_PERIOD_STATUSES_GT does not reference any database object

GMF.GMF_PERIOD_STATUSES_GT is referenced by following:

SchemaAPPS
SynonymGMF_PERIOD_STATUSES_GT