[Home] [Help] [Dependency Information]
Object Name: | GMF_PERIOD_STATUSES_GT |
---|---|
Object Type: | TABLE |
Owner: | GMF |
FND Design Data: | GMF.GMF_PERIOD_STATUSES_GT |
Subobject Name: | |
Status: | VALID |
Global temporary table gmf_period_statuses_gt with on commit delete rows
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
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) |
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;
GMF.GMF_PERIOD_STATUSES_GT does not reference any database object
GMF.GMF_PERIOD_STATUSES_GT is referenced by following:
|
|
|