DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.CSF_PLAN_OPTIONS_V

Object Details
Object Name: CSF_PLAN_OPTIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSF.CSF_PLAN_OPTIONS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
SCHED_REQUEST_ID NUMBER
Yes Schedule Request Id
PLAN_OPTION_ID NUMBER
Yes Plan Option Id
COST NUMBER

Cost
RESOURCE_ID NUMBER

Resource Id
RESOURCE_TYPE VARCHAR2 (30)
Resource Type
RESOURCE_NAME VARCHAR2 (4000)
Resource Name
START_TIME DATE

Plan Option Start Time
END_TIME DATE

Plan Option End Time
TRAVEL_TIME VARCHAR2 (5)
Travel Time
SPARES_DATE DATE

Spares Availability Date
SPARES_COST NUMBER

Spares Cost
TASK_TYPE_ID NUMBER

Task Type Id
OBJECT_CAPACITY_ID NUMBER
Yes Object Capacity Id
TASK_ID NUMBER

Task Id
TASK_ASSIGNMENT_ID NUMBER

Task Assignment Id
Query Text

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


SELECT SCHED_REQUEST_ID
,      PLAN_OPTION_ID
,      COST
,      RESOURCE_ID
,      RESOURCE_TYPE
,      RESOURCE_NAME
,      START_TIME
,      END_TIME
,      TRAVEL_TIME
,      SPARES_DATE
,      SPARES_COST
,      TASK_TYPE_ID
,      OBJECT_CAPACITY_ID
,      TASK_ID
,      TASK_ASSIGNMENT_ID
FROM APPS.CSF_PLAN_OPTIONS_V;

Dependencies

[top of page]

APPS.CSF_PLAN_OPTIONS_V references the following:

SchemaAPPS
PL/SQL PackageCSF_RESOURCE_PUB - show dependent code
SynonymCSF_R_PLAN_OPTIONS
SynonymCSF_R_PLAN_OPTION_TASKS
SynonymCSF_R_REQUEST_TASKS
SynonymCSF_R_RESOURCE_RESULTS
SynonymCSF_R_SPARES_OPTIONS
SynonymJTF_TASKS_B
APPS.CSF_PLAN_OPTIONS_V is referenced by following:

SchemaAPPS
Package BodyCSF_GANTT_DATA_PKG - show dependent code