Skip to content

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

VIEW: GMS.GMS_ENCUMBRANCE_ITEMS_ALL#

Object Details
Object Name: GMS_ENCUMBRANCE_ITEMS_ALL#
Object Type: VIEW
Owner: GMS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ENCUMBRANCE_ITEM_ID NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
ENCUMBRANCE_ID NUMBER (15) Yes
TASK_ID NUMBER (15) 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)
REQUEST_ID NUMBER (15)
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)
PROJECT_ID NUMBER (15)
SOURCE_ENCUMBRANCE_ITEM_ID NUMBER (15)
JOB_ID NUMBER (15)
ORG_ID NUMBER (15)
SYSTEM_LINKAGE_FUNCTION VARCHAR2 (3) Yes
DENOM_CURRENCY_CODE VARCHAR2 (15)
ACCT_CURRENCY_CODE VARCHAR2 (15)
ACCT_RATE_DATE DATE

ACCT_RATE_TYPE VARCHAR2 (30)
ACCT_EXCHANGE_RATE NUMBER

ACCT_EXCHANGE_ROUNDING_LIMIT NUMBER

PROJECT_CURRENCY_CODE VARCHAR2 (15)
PROJECT_RATE_DATE DATE

PROJECT_RATE_TYPE VARCHAR2 (30)
PROJECT_EXCHANGE_RATE NUMBER

DENOM_TP_CURRENCY_CODE VARCHAR2 (15)
DENOM_TRANSFER_PRICE NUMBER

PROJACCT_TRANSFER_PRICE NUMBER

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)
DENOM_RAW_AMOUNT NUMBER

INCURRED_BY_PERSON_ID NUMBER (9)
PERSON_ID NUMBER (9)
ACCT_RAW_COST NUMBER

ADJUSTMENT_TYPE VARCHAR2 (150)
Query Text

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


SELECT ENCUMBRANCE_ITEM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      ENCUMBRANCE_ID
,      TASK_ID
,      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
,      REQUEST_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ORIG_TRANSACTION_REFERENCE
,      TRANSACTION_SOURCE
,      PROJECT_ID
,      SOURCE_ENCUMBRANCE_ITEM_ID
,      JOB_ID
,      ORG_ID
,      SYSTEM_LINKAGE_FUNCTION
,      DENOM_CURRENCY_CODE
,      ACCT_CURRENCY_CODE
,      ACCT_RATE_DATE
,      ACCT_RATE_TYPE
,      ACCT_EXCHANGE_RATE
,      ACCT_EXCHANGE_ROUNDING_LIMIT
,      PROJECT_CURRENCY_CODE
,      PROJECT_RATE_DATE
,      PROJECT_RATE_TYPE
,      PROJECT_EXCHANGE_RATE
,      DENOM_TP_CURRENCY_CODE
,      DENOM_TRANSFER_PRICE
,      PROJACCT_TRANSFER_PRICE
,      AMOUNT
,      ENCUMBRANCE_COMMENT
,      IND_COMPILED_SET_ID
,      PA_DATE
,      GL_DATE
,      LINE_NUM
,      BURDEN_SUM_DEST_RUN_ID
,      BURDEN_SUM_SOURCE_RUN_ID
,      DENOM_RAW_AMOUNT
,      INCURRED_BY_PERSON_ID
,      PERSON_ID
,      ACCT_RAW_COST
,      ADJUSTMENT_TYPE
FROM GMS.GMS_ENCUMBRANCE_ITEMS_ALL#;

Dependencies

[top of page]

GMS.GMS_ENCUMBRANCE_ITEMS_ALL# references the following:

SchemaGMS
TableGMS_ENCUMBRANCE_ITEMS_ALL
GMS.GMS_ENCUMBRANCE_ITEMS_ALL# is referenced by following:

SchemaAPPS
SynonymGMS_ENCUMBRANCE_ITEMS
SynonymGMS_ENCUMBRANCE_ITEMS_ALL