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

TABLE: GMF.GMF_BATCH_REQUIREMENTS_GTMP

Object Details
Object Name: GMF_BATCH_REQUIREMENTS_GTMP
Object Type: TABLE
Owner: GMF
FND Design Data: TableGMF.GMF_BATCH_REQUIREMENTS_GTMP
Subobject Name:
Status: VALID

Temporary Table Details

GMF.GMF_BATCH_REQUIREMENTS_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$TRANSACTION. 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
VIB_ID NUMBER

BATCH_ID NUMBER
Yes
PRODUCT_ITEM_ID NUMBER
Yes
PROD_MATERIAL_DETAIL_ID NUMBER
Yes
BATCHSTEP_ID NUMBER

INGREDIENT_ITEM_ID NUMBER

ING_MATERIAL_DETAIL_ID NUMBER

RESOURCES VARCHAR2 (32)
BATCHSTEP_RESOURCE_ID NUMBER

DERIVED_COST_ALLOC NUMBER
Yes
REQUIRED_DOC_QTY NUMBER
Yes
DELETE_MARK NUMBER (5) Yes
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

REQUIREMENT_ID NUMBER

ORGANIZATION_ID NUMBER

VIB_PROFILE_VALUE VARCHAR2 (1)
Query Text

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


SELECT VIB_ID
,      BATCH_ID
,      PRODUCT_ITEM_ID
,      PROD_MATERIAL_DETAIL_ID
,      BATCHSTEP_ID
,      INGREDIENT_ITEM_ID
,      ING_MATERIAL_DETAIL_ID
,      RESOURCES
,      BATCHSTEP_RESOURCE_ID
,      DERIVED_COST_ALLOC
,      REQUIRED_DOC_QTY
,      DELETE_MARK
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUIREMENT_ID
,      ORGANIZATION_ID
,      VIB_PROFILE_VALUE
FROM GMF.GMF_BATCH_REQUIREMENTS_GTMP;

Dependencies

[top of page]

GMF.GMF_BATCH_REQUIREMENTS_GTMP does not reference any database object

GMF.GMF_BATCH_REQUIREMENTS_GTMP is referenced by following:

SchemaAPPS
SynonymGMF_BATCH_REQUIREMENTS_GTMP