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

VIEW: APPS.GMP_RESOURCE_AVAIL_V

Object Details
Object Name: GMP_RESOURCE_AVAIL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMP.GMP_RESOURCE_AVAIL_V
Subobject Name:
Status: VALID

View Type

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


Resource availability per calendar and downtime


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Unique identifier of the owner organization
CALENDAR_CODE VARCHAR2 (10)
Code of the calendar used in calculating this availability
RESOURCE_ID NUMBER
Yes Unique identifier of the resource
RESOURCE_INSTANCE_ID NUMBER

Unique identifier of the specific instance of resource
Query Text

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


SELECT ORGANIZATION_ID
,      CALENDAR_CODE
,      RESOURCE_ID
,      RESOURCE_INSTANCE_ID
FROM APPS.GMP_RESOURCE_AVAIL_V;

Dependencies

[top of page]

APPS.GMP_RESOURCE_AVAIL_V references the following:

SchemaAPPS
SynonymCR_RSRC_DTL
SynonymGMP_RESOURCE_AVAIL

APPS.GMP_RESOURCE_AVAIL_V is not referenced by any database object