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

VIEW: APPS.GMF_RESOURCE_COSTS_V

Object Details
Object Name: GMF_RESOURCE_COSTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMF.GMF_RESOURCE_COSTS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Resource Costs View


[View Source]

Columns
Name Datatype Length Mandatory Comments
RESOURCES VARCHAR2 (16) Yes Resource for which the cost is entered
USAGE_UOM VARCHAR2 (3)
Unit of Measure code
COST_TYPE_ID NUMBER (15)
cost type identifier
PERIOD_ID NUMBER (15)
period identifier
ORGANIZATION_ID NUMBER (15) Yes organization identifier
ORGANIZATION_CODE VARCHAR2 (4)
organization code
CALENDAR_CODE VARCHAR2 (10)
calendar code
PERIOD_CODE VARCHAR2 (10)
cost period code
NOMINAL_COST NUMBER

nominal cost
Query Text

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


SELECT RESOURCES
,      USAGE_UOM
,      COST_TYPE_ID
,      PERIOD_ID
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      CALENDAR_CODE
,      PERIOD_CODE
,      NOMINAL_COST
FROM APPS.GMF_RESOURCE_COSTS_V;

Dependencies

[top of page]

APPS.GMF_RESOURCE_COSTS_V references the following:

SchemaAPPS
SynonymCM_RSRC_DTL
SynonymGMF_PROCESS_ORGANIZATIONS_GT

APPS.GMF_RESOURCE_COSTS_V is not referenced by any database object