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.GMF_PROCESS_ORGANIZATIONS_GT

Object Details

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

Stores Process organizations temporarily in a Session

Temporary Table Details

GMF.GMF_PROCESS_ORGANIZATIONS_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$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER	(15)	Yes	Organization ID
ORGANIZATION_CODE	VARCHAR2	(4)		Organization Code
BASE_CURRENCY_CODE	VARCHAR2	(15)		Base Currency Code
STD_UOM	VARCHAR2	(3)
LEGAL_ENTITY_ID	NUMBER			Legal Entity of the Organization
OPERATING_UNIT_ID	NUMBER

Query Text

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


SELECT ORGANIZATION_ID
,      ORGANIZATION_CODE
,      BASE_CURRENCY_CODE
,      STD_UOM
,      LEGAL_ENTITY_ID
,      OPERATING_UNIT_ID
FROM GMF.GMF_PROCESS_ORGANIZATIONS_GT;

Dependencies

[top of page]

GMF.GMF_PROCESS_ORGANIZATIONS_GT does not reference any database object

GMF.GMF_PROCESS_ORGANIZATIONS_GT is referenced by following:

APPS: GMF_PROCESS_ORGANIZATIONS_GT