[Home] [Help] [Dependency Information]

VIEW: APPS.GMS_AWARDS_V

Object Details

Object Name:	GMS_AWARDS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMS.GMS_AWARDS_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

Query Text

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

SELECT AWARD_ID
,      AWARD_NUMBER
,      AWARD_TEMPLATE_FLAG
,      AWARD_PROJECT_ID
,      AGREEMENT_ID
,      FUNDING_SOURCE_ID
,      FUNDING_SOURCE_SHORT_NAME
,      AWARD_SHORT_NAME
,      FUNDING_SOURCE_AWARD_NUMBER
,      AWARD_FULL_NAME
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      CLOSE_DATE
,      PREAWARD_DATE
,      AWARD_TYPE
,      AWARD_PURPOSE_CODE
,      AWARD_PURPOSE
,      STATUS
,      STATUS_DIS
,      ALLOWABLE_SCHEDULE_ID
,      ALLOWABLE_SCHEDULE_NAME
,      IDC_SCHEDULE_ID
,      IDC_SCHEDULE_NAME
,      REVENUE_DISTRIBUTION_RULE
,      BILLING_FREQUENCY
,      BILLING_CYCLE_ID
,      BILLING_OFFSET
,      BILLING_FREQUENCY_DIS
,      BILLING_DISTRIBUTION_RULE
,      BILLING_TERM
,      BILLING_TERM_DIS
,      BILLING_FORMAT
,      LABOR_INVOICE_FORMAT_ID
,      LABOR_INVOICE_FORMAT_DIS
,      NON_LABOR_INVOICE_FORMAT_ID
,      NON_LABOR_INVOICE_FORMAT_DIS
,      TRANSACTION_NUMBER
,      BILL_TO_CUSTOMER_ID
,      BILL_TO_CUSTOMER_DIS
,      AGENCY_SPECIFIC_FORM
,      AGREEMENT_NUM
,      HARD_LIMIT_FLAG
,      FUND_CONTROL_LEVEL_AWARD
,      FUND_CONTROL_LEVEL_AWARD_DIS
,      FUND_CONTROL_LEVEL_TASK
,      FUND_CONTROL_LEVEL_TASK_DIS
,      FUND_CONTROL_LEVEL_RES_GRP
,      FUND_CONTROL_LEVEL_RES_GRP_DIS
,      FUND_CONTROL_LEVEL_RES
,      FUND_CONTROL_LEVEL_RES_DIS
,      AMOUNT_TYPE
,      AMOUNT_TYPE_DIS
,      BOUNDARY_CODE
,      BOUNDARY_CODE_DIS
,      AWARD_ORGANIZATION_ID
,      ORG_DIS
,      TOTAL_REVENUE_AMOUNT
,      TOTAL_BILLED_AMOUNT
,      IDC_SCHEDULE_FIXED_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      TEMPLATE_START_DATE_ACTIVE
,      TEMPLATE_END_DATE_ACTIVE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ROW_ID
,      UPDATE_ALLOWED
,      BILL_TO_ADDRESS_ID
,      SHIP_TO_ADDRESS_ID
,      LOC_BILL_TO_ADDRESS_ID
,      LOC_SHIP_TO_ADDRESS_ID
,      BUDGET_WF_ENABLED_FLAG
,      PROPOSAL_ID
,      INVOICE_LIMIT_FLAG
,      ORG_ID
,      OPERATING_UNIT
FROM APPS.GMS_AWARDS_V;

Dependencies

[top of page]

APPS

FND_PROFILE - show dependent code

GMS_ALLOWABILITY_SCHEDULES

GMS_AWARDS

GMS_LOOKUPS

GMS_OPERATING_UNITS_V

GMS_SECURITY - show dependent code

HR_ALL_ORGANIZATION_UNITS

HZ_CUST_ACCOUNTS

HZ_PARTIES

MO_GLOBAL - show dependent code

PA_AGREEMENTS_ALL

PA_IND_RATE_SCHEDULES

PA_INVOICE_FORMATS

PA_SUMMARY_PROJECT_FUNDINGS

PA_UTILS - show dependent code

RA_TERMS

SYS

DUAL

APPS

GMS_BUDGET_PUB - show dependent code