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_INSTANCES

Object Details

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

Table for Resource Instances

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMP_RESOURCE_INSTANCES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EQUIPMENT_ITEM_ID EQP_SERIAL_NUMBER
GMP_RESOURCE_INSTANCES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID INSTANCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RESOURCE_ID	NUMBER		Yes	The Surrogate Key of the Resource
INSTANCE_ID	NUMBER		Yes	Surrogate Key to uniquely identify the Instance
INSTANCE_NUMBER	NUMBER		Yes	The number identifying the resource uniquely. This will be a serial number staring from 1 and progress up to the total number of resources at the Plant
VENDOR_ID	NUMBER			the Key to the Vendor from whom the Equipment was purchased
MODEL_NUMBER	VARCHAR2	(30)		the Model number from the manufacturer for the resource
SERIAL_NUMBER	VARCHAR2	(30)		the Combination of numbers, Letters and Symbols the manufacturer uses to identify the resource
TRACKING_NUMBER	VARCHAR2	(30)		the unique combination of numbers, Letters and symbols to identify the resource for internal tracking
EFF_START_DATE	DATE		Yes	The Start Date for the Resource when it becomes Active
EFF_END_DATE	DATE			The End Date for the Resource when it becomes Inactive
LAST_MAINTENANCE_DATE	DATE			The Date maintenance last occurred for the resource
MAINTENANCE_INTERVAL	NUMBER			The number of Days from the last time maintenance was done where maintenance should occur again
INACTIVE_IND	NUMBER		Yes	inactive indicator
CALIBRATION_FREQUENCY	NUMBER			Resource Calibration Frequency, If there is a value in calibration_frequency, there must be a value in calibration_period
CALIBRATION_PERIOD	VARCHAR2	(4)		Resource Calibration Period, If there is a value in calibration_period, there must be a value in calibration_frequency
CALIBRATION_ITEM_ID	NUMBER			The Item with which the Calibration is done - Must be valid from ic_item_mst
LAST_CALIBRATION_DATE	DATE			Standard date validation + cannot be greater than sysdate
NEXT_CALIBRATION_DATE	DATE			Standard date validation + cannot be greater than sysdate
LAST_CERTIFICATION_DATE	DATE			Standard date validation + cannot be greater than sysdate
CERTIFIED_BY	VARCHAR2	(32)		Person Who has done the Calibration Certification
CREATION_DATE	DATE		Yes	Standard "Who" column
CREATED_BY	NUMBER		Yes	Standard "Who" column
LAST_UPDATE_DATE	DATE		Yes	Standard "Who" column
LAST_UPDATED_BY	NUMBER		Yes	Standard "Who" column
LAST_UPDATE_LOGIN	NUMBER			Standard "Who" column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Standard Flex fields
ATTRIBUTE1	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE2	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE3	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE4	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE5	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE6	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE7	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE8	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE9	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE10	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE11	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE12	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE13	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE14	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE15	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE16	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE17	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE18	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE19	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE20	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE21	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE22	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE23	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE24	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE25	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE26	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE27	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE28	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE29	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE30	VARCHAR2	(240)		Standard Flex fields
EQUIPMENT_ITEM_ID	NUMBER			The surrogate key for equipment item
EQP_SERIAL_NUMBER	VARCHAR2	(30)		This is the Equipment Serial Number - this comes from the Serial numbers defined from Oracle Inventory APPS
LAST_SETUP_ID	NUMBER			Identifier of the last sequence depndent setup performed on the resource instance

Query Text

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


SELECT RESOURCE_ID
,      INSTANCE_ID
,      INSTANCE_NUMBER
,      VENDOR_ID
,      MODEL_NUMBER
,      SERIAL_NUMBER
,      TRACKING_NUMBER
,      EFF_START_DATE
,      EFF_END_DATE
,      LAST_MAINTENANCE_DATE
,      MAINTENANCE_INTERVAL
,      INACTIVE_IND
,      CALIBRATION_FREQUENCY
,      CALIBRATION_PERIOD
,      CALIBRATION_ITEM_ID
,      LAST_CALIBRATION_DATE
,      NEXT_CALIBRATION_DATE
,      LAST_CERTIFICATION_DATE
,      CERTIFIED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      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
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      EQUIPMENT_ITEM_ID
,      EQP_SERIAL_NUMBER
,      LAST_SETUP_ID
FROM GMP.GMP_RESOURCE_INSTANCES;

Dependencies

[top of page]

GMP.GMP_RESOURCE_INSTANCES does not reference any database object

GMP.GMP_RESOURCE_INSTANCES is referenced by following:

GMP: GMP_RESOURCE_INSTANCES#