[Home] [Help] [Dependency Information]
Object Name: | GMP_HORIZONTAL_PDR_GTMP |
---|---|
Object Type: | TABLE |
Owner: | GMP |
FND Design Data: | GMP.GMP_HORIZONTAL_PDR_GTMP |
Subobject Name: | |
Status: | VALID |
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
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 |
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;
GMP.GMP_HORIZONTAL_PDR_GTMP does not reference any database object
GMP.GMP_HORIZONTAL_PDR_GTMP is referenced by following:
|
|
|