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: GMS.GMS_ENCUMBRANCE_GROUPS_ALL

Object Details

Object Name:	GMS_ENCUMBRANCE_GROUPS_ALL
Object Type:	TABLE
Owner:	GMS
FND Design Data:	GMS.GMS_ENCUMBRANCE_GROUPS_ALL
Subobject Name:
Status:	VALID

GMS_ENCUMBRANCE_GROUPS_ALL stores pre-approved encumbrance batches. Encumbrance batches can be for manual encumbrances or encumbrances interfaced from Oracle Labor Distribution.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMS_ENCUBMBRACE_GROUPS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ENCUMBRANCE_GROUP
GMS_ENCUMBRANCE_GROUPS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ENCUMBRANCE_GROUP	VARCHAR2	(240)	Yes	User-defined name that uniquely identifies the encumbrance group
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
ENCUMBRANCE_GROUP_STATUS_CODE	VARCHAR2	(30)	Yes	Status of the encumbrance group as it is entered, approved, and released for costing
ENCUMBRANCE_ENDING_DATE	DATE		Yes	Last day of the encumbrance week period
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(30)	Yes	Classification of the encumbrance group that indicates what type of charges are entered for the group. All encumbrance items entered for the group have an encumbrance type defined with the same system linkage as the group system linkage.
CONTROL_COUNT	VARCHAR2	(20)		User-entered control count of the encumbrance for the encumbrance group
CONTROL_TOTAL_AMOUNT	NUMBER	(22)		User-entered control total of the encumbrances for the encumbrance group
DESCRIPTION	VARCHAR2	(250)		Description of the encumbrance group. Upon entry of the encumbrance group, the description is defaulted to the type of encumbrances entered. Timecards, Expense Reports, and Usages.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
REQUEST_ID	NUMBER	(15)		Standard Who column
PROGRAM_ID	NUMBER	(15)		Standard Who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
TRANSACTION_SOURCE	VARCHAR2	(30)		Transaction source of the imported expenditures loaded by the Transaction Import process
ORG_ID	NUMBER	(15)		Operating unit identifier for multi-organization installations

Query Text

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


SELECT ENCUMBRANCE_GROUP
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      ENCUMBRANCE_GROUP_STATUS_CODE
,      ENCUMBRANCE_ENDING_DATE
,      SYSTEM_LINKAGE_FUNCTION
,      CONTROL_COUNT
,      CONTROL_TOTAL_AMOUNT
,      DESCRIPTION
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      TRANSACTION_SOURCE
,      ORG_ID
FROM GMS.GMS_ENCUMBRANCE_GROUPS_ALL;

Dependencies

[top of page]

GMS.GMS_ENCUMBRANCE_GROUPS_ALL does not reference any database object

GMS.GMS_ENCUMBRANCE_GROUPS_ALL is referenced by following:

GMS: GMS_ENCUMBRANCE_GROUPS_ALL#