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

VIEW: APPS.GMS_AWARDS_BASIC_V

Object Details
Object Name: GMS_AWARDS_BASIC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMS.GMS_AWARDS_BASIC_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
AWARD_ID NUMBER (15) Yes Unique identifier for the award
AWARD_NUMBER VARCHAR2 (15) Yes A user-defined or system-generated unique number for the award
AWARD_SHORT_NAME VARCHAR2 (30) Yes User-defined short name for the award
PROJECT_ID NUMBER
Yes Project identifier of the project that the award is funding
TASK_ID NUMBER (15) Yes Task identifier within the project that the award is funding if the funding is at the task level
PROJECT_NUMBER VARCHAR2 (25) Yes Project number of the project that is funded by the award
ORG_ID NUMBER (15)
Query Text

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


SELECT AWARD_ID
,      AWARD_NUMBER
,      AWARD_SHORT_NAME
,      PROJECT_ID
,      TASK_ID
,      PROJECT_NUMBER
,      ORG_ID
FROM APPS.GMS_AWARDS_BASIC_V;

Dependencies

[top of page]

APPS.GMS_AWARDS_BASIC_V references the following:

SchemaAPPS
SynonymGMS_AWARDS
SynonymGMS_BUDGET_VERSIONS
SynonymGMS_INSTALLMENTS
SynonymGMS_SUMMARY_PROJECT_FUNDINGS
SynonymPA_PROJECTS_ALL
SynonymPA_TASKS
APPS.GMS_AWARDS_BASIC_V is referenced by following:

SchemaAPPS
ViewGMS_PQH_AWARDS_V
Package BodyPON_CP_INTRFAC_TO_TRANSACTION - show dependent code
Package BodyPON_NEGOTIATION_PUBLISH_PVT - show dependent code
Package BodyPON_VALIDATE_ITEM_PRICES_INT - show dependent code
Package BodyPON_VALIDATE_PAYMENTS_INT - show dependent code
Package BodyPSP_POA_BUS - show dependent code
Package BodyPSP_PSPENCDU_XMLP_PKG - show dependent code
Package BodyPSP_PSPENCSC_XMLP_PKG - show dependent code