[Home] [Help] [Dependency Information]
Object Name: | OTFV_RESOURCES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OTA.OTFV_RESOURCES |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view shows Suppliable Resources information.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | |
RESOURCE_TYPE | VARCHAR2 | (4000) | ||
RESOURCE_NAME | VARCHAR2 | (400) | ||
SUPPLIABLE_RESOURCE_COMMENTS | VARCHAR2 | (2000) | Any special instructions attached to this resource supply. | |
ADDRESS | VARCHAR2 | (80) | The further address detail relating to a location | |
COST | NUMBER | (9) | ||
COST_UNIT | VARCHAR2 | (80) | ||
CURRENCY | VARCHAR2 | (4000) | ||
RESOURCE_ADDRESS | VARCHAR2 | (80) | ||
RESOURCE_CAPACITY | NUMBER | |||
RESOURCE_START_DATE | DATE | |||
RESOURCE_END_DATE | DATE | |||
RESOURCE_CONSUMABLE | VARCHAR2 | (4000) | ||
TRAINING_CENTER | VARCHAR2 | (240) | ||
SUPPLIER_LEAD_TIME | NUMBER | (9) | ||
SUPPLIER_REFERENCE | VARCHAR2 | (80) | ||
SUPPLIER_NAME | VARCHAR2 | (240) | ||
_KF:RESOURCE_DEFINITIONS | CHAR | (15) | ||
_DF | CHAR | (36) | ||
BUSINESS_GROUP_ID | NUMBER | (9) | Yes | |
SUPPLIER_ID | NUMBER | (15) | ||
RESOURCE_DEFINITION_ID | NUMBER | (15) | Yes | |
TRAINING_CENTER_ID | NUMBER | (15) | ||
SUPPLIED_RESOURCE_ID | NUMBER | (9) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_NAME
, RESOURCE_TYPE
, RESOURCE_NAME
, SUPPLIABLE_RESOURCE_COMMENTS
, ADDRESS
, COST
, COST_UNIT
, CURRENCY
, RESOURCE_ADDRESS
, RESOURCE_CAPACITY
, RESOURCE_START_DATE
, RESOURCE_END_DATE
, RESOURCE_CONSUMABLE
, TRAINING_CENTER
, SUPPLIER_LEAD_TIME
, SUPPLIER_REFERENCE
, SUPPLIER_NAME
, _KF:RESOURCE_DEFINITIONS
, _DF
, BUSINESS_GROUP_ID
, SUPPLIER_ID
, RESOURCE_DEFINITION_ID
, TRAINING_CENTER_ID
, SUPPLIED_RESOURCE_ID
FROM APPS.OTFV_RESOURCES;
APPS.OTFV_RESOURCES is not referenced by any database object
|
|
|