[Home] [Help] [Dependency Information]
Object Name: | FA_MAINT_REP_ITF |
---|---|
Object Type: | TABLE |
Owner: | FA |
FND Design Data: | OFA.FA_MAINT_REP_ITF |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FA_MAINT_REP_ITF_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | REQUEST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | (15) | Yes | |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | |
ASSET_ID | NUMBER | (15) | Yes | |
ASSET_NUMBER | VARCHAR2 | (15) | Yes | |
DESCRIPTION | VARCHAR2 | (80) | Yes | |
SERIAL_NUMBER | VARCHAR2 | (35) | ||
TAG_NUMBER | VARCHAR2 | (15) | ||
ASSET_KEY_FF | VARCHAR2 | (500) | ||
ASSET_COST | NUMBER | |||
LOCATION_FF | VARCHAR2 | (500) | ||
CATEGORY_FF | VARCHAR2 | (500) | ||
EVENT_NAME | VARCHAR2 | (50) | ||
MAINTENANCE_COST | NUMBER | |||
MAINTENANCE_DATE | DATE | |||
VENDOR_NAME | VARCHAR2 | (240) | ||
VENDOR_NUMBER | VARCHAR2 | (30) | ||
CONTACT_NAME | VARCHAR2 | (240) | ||
CONTACT_NUMBER | VARCHAR2 | (30) | ||
WARRANTY_NUMBER | VARCHAR2 | (15) | ||
WARRANTY_DESC | VARCHAR2 | (30) | ||
WARRANTY_START_DATE | DATE | |||
WARRANTY_END_DATE | DATE | |||
MANUFACTURER_NAME | VARCHAR2 | (30) | ||
MODEL_NUMBER | VARCHAR2 | (40) | ||
WARRANTY_CONTACT_NAME | VARCHAR2 | (240) | ||
WARRANTY_CONTACT_NUMBER | VARCHAR2 | (30) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, BOOK_TYPE_CODE
, ASSET_ID
, ASSET_NUMBER
, DESCRIPTION
, SERIAL_NUMBER
, TAG_NUMBER
, ASSET_KEY_FF
, ASSET_COST
, LOCATION_FF
, CATEGORY_FF
, EVENT_NAME
, MAINTENANCE_COST
, MAINTENANCE_DATE
, VENDOR_NAME
, VENDOR_NUMBER
, CONTACT_NAME
, CONTACT_NUMBER
, WARRANTY_NUMBER
, WARRANTY_DESC
, WARRANTY_START_DATE
, WARRANTY_END_DATE
, MANUFACTURER_NAME
, MODEL_NUMBER
, WARRANTY_CONTACT_NAME
, WARRANTY_CONTACT_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
FROM FA.FA_MAINT_REP_ITF;
FA.FA_MAINT_REP_ITF does not reference any database object
FA.FA_MAINT_REP_ITF is referenced by following:
|
|
|