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

TABLE: GME.GME_RESOURCE_TXNS_GTMP

Object Details
Object Name: GME_RESOURCE_TXNS_GTMP
Object Type: TABLE
Owner: GME
FND Design Data: TableGME.GME_RESOURCE_TXNS_GTMP
Subobject Name:
Status: VALID

Temporary Table Details

GME.GME_RESOURCE_TXNS_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
POC_TRANS_ID NUMBER (10)
Surrogate for table.
ORGN_CODE VARCHAR2 (4)
Organization Code. Not used anymore.
DOC_TYPE VARCHAR2 (4)
Document type.
DOC_ID NUMBER (10)
Batch ID
LINE_ID NUMBER (10)
Batch step resource ID
LINE_TYPE NUMBER (5)
Line Type
RESOURCES VARCHAR2 (16)
Resource
RESOURCE_USAGE NUMBER

Usage
TRANS_UM VARCHAR2 (4)
Unit Of Measure
TRANS_DATE DATE

Transaction Date
COMPLETED_IND NUMBER (5)
Completed or Pending Indicator
POSTED_IND NUMBER (5)
Posted to GL Indicator
REASON_CODE VARCHAR2 (4)
Reason for transaction. Not used anymore.
EVENT_ID NUMBER (10)
Event ID
INSTANCE_ID NUMBER (15)
Resource Instance
SEQUENCE_DEPENDENT_IND NUMBER (5)
Sequence Dependent Indicator
START_DATE DATE

Start Date
END_DATE DATE

End Date
TEXT_CODE NUMBER (10)
Text Code for Edit Text
OVERRIDED_PROTECTED_IND VARCHAR2 (1)
Override Protected Indicator
ACTION_CODE VARCHAR2 (4)
Action Code
TRANSACTION_NO NUMBER (10)
Transaction Number
DELETE_MARK NUMBER (10)
Delete Mark
ORGANIZATION_ID NUMBER (10)
Organization ID
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute Category
ATTRIBUTE1 VARCHAR2 (240)
Attribute
ATTRIBUTE2 VARCHAR2 (240)
Attribute
ATTRIBUTE3 VARCHAR2 (240)
Attribute
ATTRIBUTE4 VARCHAR2 (240)
Attribute
ATTRIBUTE5 VARCHAR2 (240)
Attribute
ATTRIBUTE6 VARCHAR2 (240)
Attribute
ATTRIBUTE7 VARCHAR2 (240)
Attribute
ATTRIBUTE8 VARCHAR2 (240)
Attribute
ATTRIBUTE9 VARCHAR2 (240)
Attribute
ATTRIBUTE10 VARCHAR2 (240)
Attribute
ATTRIBUTE11 VARCHAR2 (240)
Attribute
ATTRIBUTE12 VARCHAR2 (240)
Attribute
ATTRIBUTE13 VARCHAR2 (240)
Attribute
ATTRIBUTE14 VARCHAR2 (240)
Attribute
ATTRIBUTE15 VARCHAR2 (240)
Attribute
ATTRIBUTE16 VARCHAR2 (240)
Attribute
ATTRIBUTE17 VARCHAR2 (240)
Attribute
ATTRIBUTE18 VARCHAR2 (240)
Attribute
ATTRIBUTE19 VARCHAR2 (240)
Attribute
ATTRIBUTE20 VARCHAR2 (240)
Attribute
ATTRIBUTE21 VARCHAR2 (240)
Attribute
ATTRIBUTE22 VARCHAR2 (240)
Attribute
ATTRIBUTE23 VARCHAR2 (240)
Attribute
ATTRIBUTE24 VARCHAR2 (240)
Attribute
ATTRIBUTE25 VARCHAR2 (240)
Attribute
ATTRIBUTE26 VARCHAR2 (240)
Attribute
ATTRIBUTE27 VARCHAR2 (240)
Attribute
ATTRIBUTE28 VARCHAR2 (240)
Attribute
ATTRIBUTE29 VARCHAR2 (240)
Attribute
ATTRIBUTE30 VARCHAR2 (240)
Attribute
REASON_ID NUMBER

Reason for transaction
Query Text

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


SELECT POC_TRANS_ID
,      ORGN_CODE
,      DOC_TYPE
,      DOC_ID
,      LINE_ID
,      LINE_TYPE
,      RESOURCES
,      RESOURCE_USAGE
,      TRANS_UM
,      TRANS_DATE
,      COMPLETED_IND
,      POSTED_IND
,      REASON_CODE
,      EVENT_ID
,      INSTANCE_ID
,      SEQUENCE_DEPENDENT_IND
,      START_DATE
,      END_DATE
,      TEXT_CODE
,      OVERRIDED_PROTECTED_IND
,      ACTION_CODE
,      TRANSACTION_NO
,      DELETE_MARK
,      ORGANIZATION_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      REASON_ID
FROM GME.GME_RESOURCE_TXNS_GTMP;

Dependencies

[top of page]

GME.GME_RESOURCE_TXNS_GTMP does not reference any database object

GME.GME_RESOURCE_TXNS_GTMP is referenced by following:

SchemaAPPS
SynonymGME_RESOURCE_TXNS_GTMP