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: GHG.GHG_ORGANIZATIONS_D_TMP

Object Details

Object Name:	GHG_ORGANIZATIONS_D_TMP
Object Type:	TABLE
Owner:	GHG
FND Design Data:	GHG.GHG_ORGANIZATIONS_D_TMP
Subobject Name:
Status:	VALID

Temporary Table Details

GHG.GHG_ORGANIZATIONS_D_TMP 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:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length	Mandatory
SOURCE_APPLICATION_CODE	VARCHAR2	(10)	Yes
ORGANIZATION_ID	NUMBER		Yes
ORGANIZATION_EXTERNAL_ID	VARCHAR2	(240)	Yes
ORGANIZATION_CODE	VARCHAR2	(240)	Yes
ORGANIZATION_NAME	VARCHAR2	(240)
CEO_NAME	VARCHAR2	(240)
COMPANY_IDENTIFIER	VARCHAR2	(240)
DATE_EFFECTIVE_FROM	DATE
DATE_EFFECTIVE_TO	DATE
SIC_GROUP_CODE	VARCHAR2	(240)
SIC_GROUP_DESC	VARCHAR2	(240)
SIC_DIVISION_CODE	VARCHAR2	(240)
SIC_DIVISION_DESC	VARCHAR2	(240)
ORGANIZATION_SIZE	VARCHAR2	(240)
ORGANIZATION_TYPE	VARCHAR2	(240)
ADDRESS_LINE_1	VARCHAR2	(240)
ADDRESS_LINE_2	VARCHAR2	(240)
ADDRESS_LINE_3	VARCHAR2	(240)
ADDRESS_LINE_4	VARCHAR2	(240)
ADDRESS_SUBURB	VARCHAR2	(240)
ADDRESS_STATE	VARCHAR2	(240)
ADDRESS_COUNTY	VARCHAR2	(240)
ADDRESS_COUNTRY	VARCHAR2	(240)
ADDRESS_POSTCODE	VARCHAR2	(240)
ADDRESS_LATITUDE	VARCHAR2	(240)
ADDRESS_LONGITUDE	VARCHAR2	(240)
ADDRESS_LOCATION	VARCHAR2	(240)
INFO_CODE_1	VARCHAR2	(240)
INFO_DESCRIPTION_1	VARCHAR2	(240)
INFO_CODE_2	VARCHAR2	(240)
INFO_DESCRIPTION_2	VARCHAR2	(240)
INFO_CODE_3	VARCHAR2	(240)
INFO_DESCRIPTION_3	VARCHAR2	(240)
INFO_CODE_4	VARCHAR2	(240)
INFO_DESCRIPTION_4	VARCHAR2	(240)
INFO_CODE_5	VARCHAR2	(240)
INFO_DESCRIPTION_5	VARCHAR2	(240)
INFO_CODE_6	VARCHAR2	(240)
INFO_DESCRIPTION_6	VARCHAR2	(240)
INFO_CODE_7	VARCHAR2	(240)
INFO_DESCRIPTION_7	VARCHAR2	(240)
INFO_CODE_8	VARCHAR2	(240)
INFO_DESCRIPTION_8	VARCHAR2	(240)
INFO_CODE_9	VARCHAR2	(240)
INFO_DESCRIPTION_9	VARCHAR2	(240)
INFO_CODE_10	VARCHAR2	(240)
INFO_DESCRIPTION_10	VARCHAR2	(240)
INFO_CODE_11	VARCHAR2	(240)
INFO_DESCRIPTION_11	VARCHAR2	(240)
INFO_CODE_12	VARCHAR2	(240)
INFO_DESCRIPTION_12	VARCHAR2	(240)
INFO_CODE_13	VARCHAR2	(240)
INFO_DESCRIPTION_13	VARCHAR2	(240)
INFO_CODE_14	VARCHAR2	(240)
INFO_DESCRIPTION_14	VARCHAR2	(240)
INFO_CODE_15	VARCHAR2	(240)
INFO_DESCRIPTION_15	VARCHAR2	(240)
INFO_CODE_16	VARCHAR2	(240)
INFO_DESCRIPTION_16	VARCHAR2	(240)
INFO_CODE_17	VARCHAR2	(240)
INFO_DESCRIPTION_17	VARCHAR2	(240)
INFO_CODE_18	VARCHAR2	(240)
INFO_DESCRIPTION_18	VARCHAR2	(240)
INFO_CODE_19	VARCHAR2	(240)
INFO_DESCRIPTION_19	VARCHAR2	(240)
INFO_CODE_20	VARCHAR2	(240)
INFO_DESCRIPTION_20	VARCHAR2	(240)
INFO_CODE_21	VARCHAR2	(240)
INFO_DESCRIPTION_21	VARCHAR2	(240)
INFO_CODE_22	VARCHAR2	(240)
INFO_DESCRIPTION_22	VARCHAR2	(240)
INFO_CODE_23	VARCHAR2	(240)
INFO_DESCRIPTION_23	VARCHAR2	(240)
INFO_CODE_24	VARCHAR2	(240)
INFO_DESCRIPTION_24	VARCHAR2	(240)
INFO_CODE_25	VARCHAR2	(240)
INFO_DESCRIPTION_25	VARCHAR2	(240)
INFO_CODE_26	VARCHAR2	(240)
INFO_DESCRIPTION_26	VARCHAR2	(240)
INFO_CODE_27	VARCHAR2	(240)
INFO_DESCRIPTION_27	VARCHAR2	(240)
INFO_CODE_28	VARCHAR2	(240)
INFO_DESCRIPTION_28	VARCHAR2	(240)
INFO_CODE_29	VARCHAR2	(240)
INFO_DESCRIPTION_29	VARCHAR2	(240)
INFO_CODE_30	VARCHAR2	(240)
INFO_DESCRIPTION_30	VARCHAR2	(240)

Query Text

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


SELECT SOURCE_APPLICATION_CODE
,      ORGANIZATION_ID
,      ORGANIZATION_EXTERNAL_ID
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      CEO_NAME
,      COMPANY_IDENTIFIER
,      DATE_EFFECTIVE_FROM
,      DATE_EFFECTIVE_TO
,      SIC_GROUP_CODE
,      SIC_GROUP_DESC
,      SIC_DIVISION_CODE
,      SIC_DIVISION_DESC
,      ORGANIZATION_SIZE
,      ORGANIZATION_TYPE
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      ADDRESS_LINE_4
,      ADDRESS_SUBURB
,      ADDRESS_STATE
,      ADDRESS_COUNTY
,      ADDRESS_COUNTRY
,      ADDRESS_POSTCODE
,      ADDRESS_LATITUDE
,      ADDRESS_LONGITUDE
,      ADDRESS_LOCATION
,      INFO_CODE_1
,      INFO_DESCRIPTION_1
,      INFO_CODE_2
,      INFO_DESCRIPTION_2
,      INFO_CODE_3
,      INFO_DESCRIPTION_3
,      INFO_CODE_4
,      INFO_DESCRIPTION_4
,      INFO_CODE_5
,      INFO_DESCRIPTION_5
,      INFO_CODE_6
,      INFO_DESCRIPTION_6
,      INFO_CODE_7
,      INFO_DESCRIPTION_7
,      INFO_CODE_8
,      INFO_DESCRIPTION_8
,      INFO_CODE_9
,      INFO_DESCRIPTION_9
,      INFO_CODE_10
,      INFO_DESCRIPTION_10
,      INFO_CODE_11
,      INFO_DESCRIPTION_11
,      INFO_CODE_12
,      INFO_DESCRIPTION_12
,      INFO_CODE_13
,      INFO_DESCRIPTION_13
,      INFO_CODE_14
,      INFO_DESCRIPTION_14
,      INFO_CODE_15
,      INFO_DESCRIPTION_15
,      INFO_CODE_16
,      INFO_DESCRIPTION_16
,      INFO_CODE_17
,      INFO_DESCRIPTION_17
,      INFO_CODE_18
,      INFO_DESCRIPTION_18
,      INFO_CODE_19
,      INFO_DESCRIPTION_19
,      INFO_CODE_20
,      INFO_DESCRIPTION_20
,      INFO_CODE_21
,      INFO_DESCRIPTION_21
,      INFO_CODE_22
,      INFO_DESCRIPTION_22
,      INFO_CODE_23
,      INFO_DESCRIPTION_23
,      INFO_CODE_24
,      INFO_DESCRIPTION_24
,      INFO_CODE_25
,      INFO_DESCRIPTION_25
,      INFO_CODE_26
,      INFO_DESCRIPTION_26
,      INFO_CODE_27
,      INFO_DESCRIPTION_27
,      INFO_CODE_28
,      INFO_DESCRIPTION_28
,      INFO_CODE_29
,      INFO_DESCRIPTION_29
,      INFO_CODE_30
,      INFO_DESCRIPTION_30
FROM GHG.GHG_ORGANIZATIONS_D_TMP;

Dependencies

[top of page]

GHG.GHG_ORGANIZATIONS_D_TMP does not reference any database object

GHG.GHG_ORGANIZATIONS_D_TMP is referenced by following:

APPS: GHG_ORGANIZATIONS_D_TMP