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

VIEW: APPS.GMS_STATUS_RESOURCES_BASE_V

Object Details
Object Name: GMS_STATUS_RESOURCES_BASE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMS.GMS_STATUS_RESOURCES_BASE_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
AWARD_ID NUMBER (15)
PROJECT_ID NUMBER (15)
PROJECT_NAME VARCHAR2 (30)
PROJECT_NUMBER VARCHAR2 (25)
RESOURCE_ID NUMBER (15)
RESOURCE_NAME VARCHAR2 (240)
RESOURCE_LIST_MEMBER_ID NUMBER (15)
RESOURCE_LIST_ID NUMBER (15)
TOTAL_REVENUE NUMBER

BUDGET_AMOUNT NUMBER

ACTUAL_COST NUMBER

REQUISITION_AMOUNT NUMBER

PURCHASE_ORDER_AMOUNT NUMBER

SUPPLIER_INVOICE_AMOUNT NUMBER

MANUAL_ENCUMBRANCE_AMOUNT NUMBER

START_DATE DATE

END_DATE DATE

Query Text

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


SELECT AWARD_ID
,      PROJECT_ID
,      PROJECT_NAME
,      PROJECT_NUMBER
,      RESOURCE_ID
,      RESOURCE_NAME
,      RESOURCE_LIST_MEMBER_ID
,      RESOURCE_LIST_ID
,      TOTAL_REVENUE
,      BUDGET_AMOUNT
,      ACTUAL_COST
,      REQUISITION_AMOUNT
,      PURCHASE_ORDER_AMOUNT
,      SUPPLIER_INVOICE_AMOUNT
,      MANUAL_ENCUMBRANCE_AMOUNT
,      START_DATE
,      END_DATE
FROM APPS.GMS_STATUS_RESOURCES_BASE_V;

Dependencies

[top of page]

APPS.GMS_STATUS_RESOURCES_BASE_V references the following:

SchemaAPPS
SynonymGMS_BALANCES
SynonymGMS_BC_PACKETS
SynonymGMS_BUDGET_VERSIONS
SynonymPA_PROJECTS_ALL
SynonymPA_RESOURCES
SynonymPA_RESOURCE_LISTS_ALL_BG
SynonymPA_RESOURCE_LIST_MEMBERS
APPS.GMS_STATUS_RESOURCES_BASE_V is referenced by following:

SchemaAPPS
ViewGMS_STATUS_RESOURCES_V