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]

VIEW: APPS.GMS_ENCUMBRANCE_ITEMS_V

Object Details

Object Name:	GMS_ENCUMBRANCE_ITEMS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMS.GMS_ENCUMBRANCE_ITEMS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory
ROW_ID	ROWID	(10)
ENCUMBRANCE_ITEM_ID	NUMBER	(15)	Yes
ENCUMBRANCE_ID	NUMBER	(15)	Yes
PROJECT_ID	NUMBER	(15)	Yes
PROJECT_NUMBER	VARCHAR2	(25)	Yes
PROJECT_NAME	VARCHAR2	(30)	Yes
TASK_ID	NUMBER	(15)	Yes
TASK_NUMBER	VARCHAR2	(25)	Yes
TASK_NAME	VARCHAR2	(20)	Yes
ENCUMBRANCE_GROUP	VARCHAR2	(240)
ENCUMBRANCE_STATUS_CODE	VARCHAR2	(30)	Yes
INCURRED_BY_PERSON_ID	NUMBER	(9)
UNIT_OF_MEASURE_M	VARCHAR2	(80)	Yes
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(3)	Yes
ENCUMBRANCE_ITEM_DATE	DATE		Yes
ENCUMBRANCE_TYPE	VARCHAR2	(30)	Yes
ENC_DISTRIBUTED_FLAG	VARCHAR2	(1)	Yes
OVERRIDE_TO_ORGANIZATION_ID	NUMBER	(15)
ADJUSTED_ENCUMBRANCE_ITEM_ID	NUMBER	(15)
NET_ZERO_ADJUSTMENT_FLAG	VARCHAR2	(1)
TRANSFERRED_FROM_ENC_ITEM_ID	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
ATTRIBUTE_CATEGORY	VARCHAR2	(30)
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
ORIG_TRANSACTION_REFERENCE	VARCHAR2	(30)
TRANSACTION_SOURCE	VARCHAR2	(30)
SOURCE_ENCUMBRANCE_ITEM_ID	NUMBER	(15)
JOB_ID	NUMBER	(15)
USER_TRANSACTION_SOURCE	VARCHAR2	(80)
DENOM_CURRENCY_CODE	VARCHAR2	(15)
DENOM_RAW_AMOUNT	NUMBER
ACCT_EXCHANGE_ROUNDING_LIMIT	NUMBER
ACCT_CURRENCY_CODE	VARCHAR2	(15)
ACCT_RATE_DATE	DATE
ACCT_RATE_TYPE	VARCHAR2	(30)
ACCT_EXCHANGE_RATE	NUMBER
ACCT_RAW_COST	NUMBER
PROJECT_CURRENCY_CODE	VARCHAR2	(15)
PROJECT_RATE_DATE	DATE
PROJECT_RATE_TYPE	VARCHAR2	(30)
PROJECT_EXCHANGE_RATE	NUMBER
COST_RATE_FLAG	VARCHAR2	(1)	Yes
INCURRED_BY_ORGANIZATION_ID	NUMBER	(15)
ALLOW_REVERSAL_FLAG	VARCHAR2	(1)
AMOUNT	NUMBER	(22)
ENCUMBRANCE_COMMENT	VARCHAR2	(240)
IND_COMPILED_SET_ID	NUMBER	(15)
PA_DATE	DATE
GL_DATE	DATE
LINE_NUM	NUMBER
BURDEN_SUM_DEST_RUN_ID	NUMBER	(15)
BURDEN_SUM_SOURCE_RUN_ID	NUMBER	(4)
ORG_ID	NUMBER	(15)

Query Text

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


SELECT ROW_ID
,      ENCUMBRANCE_ITEM_ID
,      ENCUMBRANCE_ID
,      PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      TASK_ID
,      TASK_NUMBER
,      TASK_NAME
,      ENCUMBRANCE_GROUP
,      ENCUMBRANCE_STATUS_CODE
,      INCURRED_BY_PERSON_ID
,      UNIT_OF_MEASURE_M
,      SYSTEM_LINKAGE_FUNCTION
,      ENCUMBRANCE_ITEM_DATE
,      ENCUMBRANCE_TYPE
,      ENC_DISTRIBUTED_FLAG
,      OVERRIDE_TO_ORGANIZATION_ID
,      ADJUSTED_ENCUMBRANCE_ITEM_ID
,      NET_ZERO_ADJUSTMENT_FLAG
,      TRANSFERRED_FROM_ENC_ITEM_ID
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ORIG_TRANSACTION_REFERENCE
,      TRANSACTION_SOURCE
,      SOURCE_ENCUMBRANCE_ITEM_ID
,      JOB_ID
,      USER_TRANSACTION_SOURCE
,      DENOM_CURRENCY_CODE
,      DENOM_RAW_AMOUNT
,      ACCT_EXCHANGE_ROUNDING_LIMIT
,      ACCT_CURRENCY_CODE
,      ACCT_RATE_DATE
,      ACCT_RATE_TYPE
,      ACCT_EXCHANGE_RATE
,      ACCT_RAW_COST
,      PROJECT_CURRENCY_CODE
,      PROJECT_RATE_DATE
,      PROJECT_RATE_TYPE
,      PROJECT_EXCHANGE_RATE
,      COST_RATE_FLAG
,      INCURRED_BY_ORGANIZATION_ID
,      ALLOW_REVERSAL_FLAG
,      AMOUNT
,      ENCUMBRANCE_COMMENT
,      IND_COMPILED_SET_ID
,      PA_DATE
,      GL_DATE
,      LINE_NUM
,      BURDEN_SUM_DEST_RUN_ID
,      BURDEN_SUM_SOURCE_RUN_ID
,      ORG_ID
FROM APPS.GMS_ENCUMBRANCE_ITEMS_V;

Dependencies

[top of page]

APPS.GMS_ENCUMBRANCE_ITEMS_V references the following:

APPS: GMS_ENCUMBRANCES; GMS_ENCUMBRANCE_ITEMS_ALL; PA_EXPENDITURE_TYPES; PA_LOOKUPS; PA_PROJECTS_ALL; PA_TASKS; PA_TRANSACTION_SOURCES

APPS.GMS_ENCUMBRANCE_ITEMS_V is not referenced by any database object