[Home] [Help] [Dependency Information]
Object Name: | OTFV_RESOURCE_CHECKLIST |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OTA.OTFV_RESOURCE_CHECKLIST |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view shows the infomation about minimum resources required to conduct an activity.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | |
RESOURCE_TYPE | VARCHAR2 | (4000) | ||
RESOURCE_NAME | VARCHAR2 | (400) | ||
RESOURCE_QUANTITY | NUMBER | |||
RESOURCE_REQUIRED | VARCHAR2 | (4000) | ||
RESOURCE_USAGE | VARCHAR2 | (4000) | ||
RESOURCE_ROLE | VARCHAR2 | (4000) | ||
RESOURCE_START_DATE | DATE | Yes | ||
RESOURCE_END_DATE | DATE | |||
RESOURCE_USAGE_COMMENTS | VARCHAR2 | (2000) | Free text comments | |
INVENTORY_ORGANIZATION | VARCHAR2 | (240) | ||
_KF:INVENTORY_ITEM | CHAR | (16) | ||
ACTIVITY_NAME | VARCHAR2 | (80) | Yes | |
ACTIVITY_DESCRIPTION | VARCHAR2 | (4000) | ||
ACTIVITY_AUDIENCE | VARCHAR2 | (4000) | ||
ACTIVITY_OBJECTIVES | VARCHAR2 | (4000) | ||
ACTIVITY_LANGUAGE | VARCHAR2 | (255) | ||
NEXT_ACTIVITY | VARCHAR2 | (80) | ||
ACTIVITY_FROM | DATE | |||
ACTIVITY_TO | DATE | |||
SPONSOR_BY | VARCHAR2 | (240) | ||
MANAGED_BY | VARCHAR2 | (240) | ||
ACTIVITY_STATUS | VARCHAR2 | (4000) | ||
SUCCESS_CRITERIA | VARCHAR2 | (4000) | ||
ALLOW_EXPENSES | VARCHAR2 | (4000) | ||
MINIMUM_STUDENTS | NUMBER | (9) | ||
MAXIMUM_STUDENTS | NUMBER | (9) | ||
MAXIMUM_INTERNAL_STUDENTS | NUMBER | (9) | ||
CURRENCY | VARCHAR2 | (4000) | ||
DURATION | NUMBER | (9) | ||
DURATION_UNITS | VARCHAR2 | (4000) | ||
PROFESSIONAL_CREDITS_TYPE | VARCHAR2 | (4000) | ||
PROFESSIONAL_CREDIT_AMOUNT | NUMBER | |||
SUPPLIER_NAME | VARCHAR2 | (240) | ||
ACTIVITY_TYPE | VARCHAR2 | (240) | Yes | |
ACTIVITY_TYPE_DESCRIPTION | VARCHAR2 | (4000) | ||
CATEGORY_NAME | VARCHAR2 | (240) | ||
_DF | CHAR | (31) | ||
BUSINESS_GROUP_ID | NUMBER | (9) | Yes | |
RESOURCE_CHECK_LIST_ID | NUMBER | (9) | Yes | |
SUPPLIED_RESOURCE_ID | NUMBER | (9) | ||
ACTIVITY_VERSION_ID | NUMBER | (9) | Yes | |
INVENTORY_ORGANIZATION_ID | NUMBER | (15) | ||
INVENTORY_ITEM_ID | NUMBER | (10) | ||
SPONSOR_ORGANIZATION_ID | NUMBER | (9) | Yes | |
MANAGED_BY_PERSON_ID | NUMBER | (10) | ||
LANGUAGE_ID | NUMBER | (9) | ||
SUPERSESED_ACT_VERSION_ID | NUMBER | (9) | ||
ACTIVITY_ID | NUMBER | (9) | Yes | |
RCO_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_NAME
, RESOURCE_TYPE
, RESOURCE_NAME
, RESOURCE_QUANTITY
, RESOURCE_REQUIRED
, RESOURCE_USAGE
, RESOURCE_ROLE
, RESOURCE_START_DATE
, RESOURCE_END_DATE
, RESOURCE_USAGE_COMMENTS
, INVENTORY_ORGANIZATION
, _KF:INVENTORY_ITEM
, ACTIVITY_NAME
, ACTIVITY_DESCRIPTION
, ACTIVITY_AUDIENCE
, ACTIVITY_OBJECTIVES
, ACTIVITY_LANGUAGE
, NEXT_ACTIVITY
, ACTIVITY_FROM
, ACTIVITY_TO
, SPONSOR_BY
, MANAGED_BY
, ACTIVITY_STATUS
, SUCCESS_CRITERIA
, ALLOW_EXPENSES
, MINIMUM_STUDENTS
, MAXIMUM_STUDENTS
, MAXIMUM_INTERNAL_STUDENTS
, CURRENCY
, DURATION
, DURATION_UNITS
, PROFESSIONAL_CREDITS_TYPE
, PROFESSIONAL_CREDIT_AMOUNT
, SUPPLIER_NAME
, ACTIVITY_TYPE
, ACTIVITY_TYPE_DESCRIPTION
, CATEGORY_NAME
, _DF
, BUSINESS_GROUP_ID
, RESOURCE_CHECK_LIST_ID
, SUPPLIED_RESOURCE_ID
, ACTIVITY_VERSION_ID
, INVENTORY_ORGANIZATION_ID
, INVENTORY_ITEM_ID
, SPONSOR_ORGANIZATION_ID
, MANAGED_BY_PERSON_ID
, LANGUAGE_ID
, SUPERSESED_ACT_VERSION_ID
, ACTIVITY_ID
, RCO_ID
FROM APPS.OTFV_RESOURCE_CHECKLIST;
|
|
|