[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GMP_RESOURCE_INSTANCES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
EQUIPMENT_ITEM_ID
EQP_SERIAL_NUMBER |
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 |
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;
GMP.GMP_RESOURCE_INSTANCES does not reference any database object
GMP.GMP_RESOURCE_INSTANCES is referenced by following:
|
|
|