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

TABLE: GMP.GMP_HORIZONTAL_PDR_GTMP

Object Details
Object Name: GMP_HORIZONTAL_PDR_GTMP
Object Type: TABLE
Owner: GMP
FND Design Data: TableGMP.GMP_HORIZONTAL_PDR_GTMP
Subobject Name:
Status: VALID

Temporary Table Details

GMP.GMP_HORIZONTAL_PDR_GTMP 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: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

INVENTORY_ITEM_ID NUMBER

BUCKET_DATE DATE

QUANTITY1 NUMBER

QUANTITY2 NUMBER

QUANTITY3 NUMBER

QUANTITY4 NUMBER

QUANTITY5 NUMBER

QUANTITY6 NUMBER

QUANTITY7 NUMBER

QUANTITY8 NUMBER

QUANTITY9 NUMBER

QUANTITY10 NUMBER

QUANTITY11 NUMBER

QUANTITY12 NUMBER

QUANTITY13 NUMBER

QUANTITY14 NUMBER

QUANTITY15 NUMBER

QUANTITY16 NUMBER

QUANTITY17 NUMBER

QUANTITY18 NUMBER

QUANTITY19 NUMBER

QUANTITY20 NUMBER

QUANTITY21 NUMBER

QUANTITY22 NUMBER

QUANTITY23 NUMBER

QUANTITY24 NUMBER

QUANTITY25 NUMBER

QUANTITY26 NUMBER

QUANTITY27 NUMBER

QUANTITY28 NUMBER

QUANTITY29 NUMBER

QUANTITY30 NUMBER

QUANTITY31 NUMBER

QUANTITY32 NUMBER

QUANTITY33 NUMBER

QUANTITY34 NUMBER

QUANTITY35 NUMBER

QUANTITY36 NUMBER

QUANTITY37 NUMBER

QUANTITY38 NUMBER

QUANTITY39 NUMBER

QUANTITY40 NUMBER

QUANTITY41 NUMBER

QUANTITY42 NUMBER

QUANTITY43 NUMBER

QUANTITY44 NUMBER

QUANTITY45 NUMBER

Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      BUCKET_DATE
,      QUANTITY1
,      QUANTITY2
,      QUANTITY3
,      QUANTITY4
,      QUANTITY5
,      QUANTITY6
,      QUANTITY7
,      QUANTITY8
,      QUANTITY9
,      QUANTITY10
,      QUANTITY11
,      QUANTITY12
,      QUANTITY13
,      QUANTITY14
,      QUANTITY15
,      QUANTITY16
,      QUANTITY17
,      QUANTITY18
,      QUANTITY19
,      QUANTITY20
,      QUANTITY21
,      QUANTITY22
,      QUANTITY23
,      QUANTITY24
,      QUANTITY25
,      QUANTITY26
,      QUANTITY27
,      QUANTITY28
,      QUANTITY29
,      QUANTITY30
,      QUANTITY31
,      QUANTITY32
,      QUANTITY33
,      QUANTITY34
,      QUANTITY35
,      QUANTITY36
,      QUANTITY37
,      QUANTITY38
,      QUANTITY39
,      QUANTITY40
,      QUANTITY41
,      QUANTITY42
,      QUANTITY43
,      QUANTITY44
,      QUANTITY45
FROM GMP.GMP_HORIZONTAL_PDR_GTMP;

Dependencies

[top of page]

GMP.GMP_HORIZONTAL_PDR_GTMP does not reference any database object

GMP.GMP_HORIZONTAL_PDR_GTMP is referenced by following:

SchemaAPPS
SynonymGMP_HORIZONTAL_PDR_GTMP