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

VIEW: GMS.GMS_TRANSACTION_INTERFACE_ALL#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
TXN_INTERFACE_ID NUMBER (15) Yes
BATCH_NAME VARCHAR2 (50)
TRANSACTION_SOURCE VARCHAR2 (30)
EXPENDITURE_ENDING_DATE DATE

EXPENDITURE_ITEM_DATE DATE

PROJECT_NUMBER VARCHAR2 (25)
TASK_NUMBER VARCHAR2 (25)
AWARD_ID NUMBER (15)
EXPENDITURE_TYPE VARCHAR2 (30)
TRANSACTION_STATUS_CODE VARCHAR2 (2)
ORIG_TRANSACTION_REFERENCE VARCHAR2 (30)
ORG_ID NUMBER (15)
SYSTEM_LINKAGE VARCHAR2 (30)
USER_TRANSACTION_SOURCE VARCHAR2 (80)
TRANSACTION_TYPE VARCHAR2 (1)
BURDENABLE_RAW_COST NUMBER (22)
FUNDING_PATTERN_ID NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

AWARD_NUMBER VARCHAR2 (15)
ORIGINAL_ENCUMBRANCE_ITEM_ID NUMBER (15)
Query Text

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


SELECT TXN_INTERFACE_ID
,      BATCH_NAME
,      TRANSACTION_SOURCE
,      EXPENDITURE_ENDING_DATE
,      EXPENDITURE_ITEM_DATE
,      PROJECT_NUMBER
,      TASK_NUMBER
,      AWARD_ID
,      EXPENDITURE_TYPE
,      TRANSACTION_STATUS_CODE
,      ORIG_TRANSACTION_REFERENCE
,      ORG_ID
,      SYSTEM_LINKAGE
,      USER_TRANSACTION_SOURCE
,      TRANSACTION_TYPE
,      BURDENABLE_RAW_COST
,      FUNDING_PATTERN_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      AWARD_NUMBER
,      ORIGINAL_ENCUMBRANCE_ITEM_ID
FROM GMS.GMS_TRANSACTION_INTERFACE_ALL#;

Dependencies

[top of page]

GMS.GMS_TRANSACTION_INTERFACE_ALL# references the following:

SchemaGMS
TableGMS_TRANSACTION_INTERFACE_ALL
GMS.GMS_TRANSACTION_INTERFACE_ALL# is referenced by following:

SchemaAPPS
SynonymGMS_TRANSACTION_INTERFACE
SynonymGMS_TRANSACTION_INTERFACE_ALL