Skip to content

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

VIEW: APPS.GMS_EVENTS_V

Object Details
Object Name: GMS_EVENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMS.GMS_EVENTS_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 Comments
TASK_ID NUMBER (15)
EVENT_NUM NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
EVENT_TYPE VARCHAR2 (30) Yes
DESCRIPTION VARCHAR2 (240) Yes
EVENT_BILL_AMOUNT NUMBER (22) Yes
EVENT_REVENUE_AMOUNT NUMBER (22) Yes
REVENUE_DISTRIBUTED_FLAG VARCHAR2 (1) Yes
BILL_HOLD_FLAG VARCHAR2 (1)
COMPLETION_DATE DATE

REV_DIST_REJECTION_CODE VARCHAR2 (30)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

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)
PROJECT_ID NUMBER (15) Yes
ORGANIZATION_ID NUMBER (15) Yes
BILLING_ASSIGNMENT_ID NUMBER (15)
EVENT_NUM_REVERSED NUMBER (15)
CALLING_PLACE VARCHAR2 (30)
CALLING_PROCESS VARCHAR2 (30)
AUDIT_COST_BUDGET_TYPE_CODE VARCHAR2 (30)
AUDIT_REV_BUDGET_TYPE_CODE VARCHAR2 (30)
AUDIT_AMOUNT1 NUMBER

AUDIT_AMOUNT2 NUMBER

AUDIT_AMOUNT3 NUMBER

AUDIT_AMOUNT4 NUMBER

AUDIT_AMOUNT5 NUMBER

AUDIT_AMOUNT6 NUMBER

AUDIT_AMOUNT7 NUMBER

AUDIT_AMOUNT8 NUMBER

AUDIT_AMOUNT9 NUMBER

AUDIT_AMOUNT10 NUMBER

EVENT_ID NUMBER
Yes
INSTALLMENT_ID NUMBER (15) Yes
ACTUAL_PROJECT_ID NUMBER (15)
ACTUAL_TASK_ID NUMBER (15)
BURDEN_COST_CODE VARCHAR2 (30)
EXPENDITURE_ORG_ID NUMBER (15)
BILL_AMOUNT NUMBER (22)
REVENUE_AMOUNT NUMBER (22)
WRITE_OFF_AMOUNT NUMBER (22)
REVENUE_ACCUMULATED VARCHAR2 (1)
RESOURCE_LIST_MEMBER_ID NUMBER (15)
EVENT_REQUEST_ID NUMBER (15)
EXPENDITURE_TYPE VARCHAR2 (30)
EVENT_CALLING_PROCESS VARCHAR2 (30)
Query Text

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


SELECT TASK_ID
,      EVENT_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      EVENT_TYPE
,      DESCRIPTION
,      EVENT_BILL_AMOUNT
,      EVENT_REVENUE_AMOUNT
,      REVENUE_DISTRIBUTED_FLAG
,      BILL_HOLD_FLAG
,      COMPLETION_DATE
,      REV_DIST_REJECTION_CODE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      PROJECT_ID
,      ORGANIZATION_ID
,      BILLING_ASSIGNMENT_ID
,      EVENT_NUM_REVERSED
,      CALLING_PLACE
,      CALLING_PROCESS
,      AUDIT_COST_BUDGET_TYPE_CODE
,      AUDIT_REV_BUDGET_TYPE_CODE
,      AUDIT_AMOUNT1
,      AUDIT_AMOUNT2
,      AUDIT_AMOUNT3
,      AUDIT_AMOUNT4
,      AUDIT_AMOUNT5
,      AUDIT_AMOUNT6
,      AUDIT_AMOUNT7
,      AUDIT_AMOUNT8
,      AUDIT_AMOUNT9
,      AUDIT_AMOUNT10
,      EVENT_ID
,      INSTALLMENT_ID
,      ACTUAL_PROJECT_ID
,      ACTUAL_TASK_ID
,      BURDEN_COST_CODE
,      EXPENDITURE_ORG_ID
,      BILL_AMOUNT
,      REVENUE_AMOUNT
,      WRITE_OFF_AMOUNT
,      REVENUE_ACCUMULATED
,      RESOURCE_LIST_MEMBER_ID
,      EVENT_REQUEST_ID
,      EXPENDITURE_TYPE
,      EVENT_CALLING_PROCESS
FROM APPS.GMS_EVENTS_V;

Dependencies

[top of page]

APPS.GMS_EVENTS_V references the following:

SchemaAPPS
SynonymGMS_EVENT_ATTRIBUTE
SynonymPA_EVENTS
APPS.GMS_EVENTS_V is referenced by following:

SchemaAPPS
Package BodyGMS_BILLING_ADJUSTMENTS - show dependent code
Package BodyGMS_EVT_BILLING - show dependent code