eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: GMP.GMP_RESOURCE_AVAIL

Object Details

Object Name:	GMP_RESOURCE_AVAIL
Object Type:	TABLE
Owner:	GMP
FND Design Data:	GMP.GMP_RESOURCE_AVAIL
Subobject Name:
Status:	VALID

Table for Resource Availability

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMP_RESOURCE_AVAIL_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	CALENDAR_ID RESOURCE_ID SHIFT_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
INSTANCE_ID	NUMBER			instance ID
PLANT_CODE	VARCHAR2	(4)		plant code
RESOURCE_ID	NUMBER		Yes	The Surrogate Key of the Resource
CALENDAR_ID	NUMBER			Surrogate Key to uniquely identify the Calendar
RESOURCE_INSTANCE_ID	NUMBER			The surrogate key identifying the resource instance . This will be a coming from the sequence GMP_RESOURCE_INSTANCES_S
SHIFT_NUM	NUMBER		Yes	The integer number for the Shift
SHIFT_DATE	DATE		Yes	the Date in which the Shift Occurs
FROM_TIME	NUMBER			the number of seconds from the start of the day for the shift to the begin
TO_TIME	NUMBER			the number of seconds from the start of the day for the shift to the end
RESOURCE_UNITS	NUMBER		Yes	Integer number which indicates the number of resource units available. If instance_id is NOT NULL, then this must be 1
CREATION_DATE	DATE		Yes	Standard "Row Who" column
CREATED_BY	NUMBER		Yes	Standard "Row Who" column
LAST_UPDATE_DATE	DATE		Yes	Standard "Row Who" column
LAST_UPDATED_BY	NUMBER		Yes	Standard "Row Who" column
LAST_UPDATE_LOGIN	NUMBER			Standard "Row Who" column
CALENDAR_CODE	VARCHAR2	(10)		Holds the calendar
ORGANIZATION_ID	NUMBER			Organization ID.

Query Text

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


SELECT INSTANCE_ID
,      PLANT_CODE
,      RESOURCE_ID
,      CALENDAR_ID
,      RESOURCE_INSTANCE_ID
,      SHIFT_NUM
,      SHIFT_DATE
,      FROM_TIME
,      TO_TIME
,      RESOURCE_UNITS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CALENDAR_CODE
,      ORGANIZATION_ID
FROM GMP.GMP_RESOURCE_AVAIL;

Dependencies

[top of page]

GMP.GMP_RESOURCE_AVAIL does not reference any database object

GMP.GMP_RESOURCE_AVAIL is referenced by following:

APPS: GMP_RESOURCE_AVAIL