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_ENCUMBRANCES_ALL

Object Details

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

GMS_ENCUMBRANCES_ALL stores the group of encumbrance items incurred by employees or organizations in an encumbrance batch. Encumbrance transactions can be manual encumbrances of 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_ENCUMBRANCE_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ENCUMBRANCE_ID
GMS_ENCUMBRANCES_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INCURRED_BY_ORGANIZATION_ID
GMS_ENCUMBRANCE_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENCUMBRANCE_GROUP

Columns

Name	Datatype	Length	Mandatory	Comments
ENCUMBRANCE_ID	NUMBER	(15)	Yes	System-generated number that uniquely identifies the encumbrance
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_STATUS_CODE	VARCHAR2	(30)	Yes	Status of the encumbrance as it is entered and approved
ENCUMBRANCE_ENDING_DATE	DATE		Yes	Last day of the encumbrance week period. All encumbrance items for the encumbrance must be on or before this encumbrance ending date. All timecard items must be within this encumbrance ending date period.
ENCUMBRANCE_CLASS_CODE	VARCHAR2	(2)	Yes	Classification of the encumbrance, indicating the type of items grouped into it
INCURRED_BY_PERSON_ID	NUMBER	(9)		Identifier of the employee who incurred the charges. This column is always populated for labor and expense report charges and is not populated for supplier invoices. For usages, specifying employees who incurred the charges is optional.
INCURRED_BY_ORGANIZATION_ID	NUMBER	(15)		Identifier of the organization that incurred the charges. Column is populated for all charges except supplier invoices, where the organization is held at the expenditure item level, as each invoice distribution may have different organizations.
ENCUMBRANCE_GROUP	VARCHAR2	(240)		Encumbrance group to which encumbrance belongs. This is only applicable for pre-approved encumbrances. This column is blank for online encumbrances.
CONTROL_TOTAL_AMOUNT	NUMBER	(22)		User-entered control total of the encumbrance items for the encumbrance
ENTERED_BY_PERSON_ID	NUMBER	(9)		Identifier of the person who entered the encumbrance. This value is not populated for supplier invoice encumbrances.
DESCRIPTION	VARCHAR2	(250)		Comment of the online encumbrances
INITIAL_SUBMISSION_DATE	DATE			Date on which the online encumbrance was initially submitted
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
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield context field
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
PTE_REFERENCE	NUMBER	(15)		Encumbrance identifier of the GMS_ENCUMBRANCES table in the local database for Oracle Personal Time and Expense
ORG_ID	NUMBER	(15)		Operating unit identifier for multi-organization installations
DENOM_CURRENCY_CODE	VARCHAR2	(15)		Transaction currency of the transaction
ACCT_CURRENCY_CODE	VARCHAR2	(15)		Functional currency of the transaction
ACCT_RATE_DATE	DATE			Functional currency conversion rate date
ACCT_RATE_TYPE	VARCHAR2	(30)		Functional currency conversion rate type
ACCT_EXCHANGE_RATE	NUMBER			Functional currency conversion exchange rate
ORIG_ENC_TXN_REFERENCE1	VARCHAR2	(60)		Encumbrance identifier in external system or system reference. For Supplier invoices created in Oracle Payables, this holds the value of AP_INVOICESINVOICE_ID.
ORIG_ENC_TXN_REFERENCE2	VARCHAR2	(60)		Additional column provided to group imported transactions into encumbrances
ORIG_ENC_TXN_REFERENCE3	VARCHAR2	(60)		Additional column provided to group imported transactions into encumbrances
ORIG_USER_ENC_TXN_REFERENCE	VARCHAR2	(60)		User reference for the encumbrance that may be populated for items imported into Projects via Transaction Import For Supplier Invoices. This holds the value of AP_INVOICESINVOICE_NUM. For timecards created via Oracle Self Service Time, this holds the value.
VENDOR_ID	NUMBER			Supplier identifier
OVERRIDING_APPROVER_PERSON_ID	NUMBER			For Oracle Self Service Time use only. The Overriding Approver to whom this timecard was sent for approval.
WF_STATUS_CODE	VARCHAR2	(30)		This column stores the workflow status code for self service timecards.
TRANSFER_STATUS_CODE	VARCHAR2	(1)		Status of the timecard as the timecard is transferred from Self Service Time to Oracle Projects
USER_BATCH_NAME	VARCHAR2	(50)		Batch name for timecards entered through Self Service Time. Used to group timecards into batches through Transaction Import.

Query Text

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


SELECT ENCUMBRANCE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      ENCUMBRANCE_STATUS_CODE
,      ENCUMBRANCE_ENDING_DATE
,      ENCUMBRANCE_CLASS_CODE
,      INCURRED_BY_PERSON_ID
,      INCURRED_BY_ORGANIZATION_ID
,      ENCUMBRANCE_GROUP
,      CONTROL_TOTAL_AMOUNT
,      ENTERED_BY_PERSON_ID
,      DESCRIPTION
,      INITIAL_SUBMISSION_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      PTE_REFERENCE
,      ORG_ID
,      DENOM_CURRENCY_CODE
,      ACCT_CURRENCY_CODE
,      ACCT_RATE_DATE
,      ACCT_RATE_TYPE
,      ACCT_EXCHANGE_RATE
,      ORIG_ENC_TXN_REFERENCE1
,      ORIG_ENC_TXN_REFERENCE2
,      ORIG_ENC_TXN_REFERENCE3
,      ORIG_USER_ENC_TXN_REFERENCE
,      VENDOR_ID
,      OVERRIDING_APPROVER_PERSON_ID
,      WF_STATUS_CODE
,      TRANSFER_STATUS_CODE
,      USER_BATCH_NAME
FROM GMS.GMS_ENCUMBRANCES_ALL;

Dependencies

[top of page]

GMS.GMS_ENCUMBRANCES_ALL does not reference any database object

GMS.GMS_ENCUMBRANCES_ALL is referenced by following:

GMS: GMS_ENCUMBRANCES_ALL#