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

TABLE: WIP.WIP_OPERATION_RESOURCES

Object Details
Object Name: WIP_OPERATION_RESOURCES
Object Type: TABLE
Owner: WIP
FND Design Data: TableWIP.WIP_OPERATION_RESOURCES
Subobject Name:
Status: VALID


WIP_OPERATION_RESOURCES stores information about the resource requirements associated with job and repetitive schedule operations. Each
row represents a resource requirement and contains a sequence number,
the resource's unit of measure, its usage rate or amount, and several
other attributes that control how it is scheduled and costed.
Oracle Work in Process uses this information to schedule jobs and
repetitive schedules and to charge resources to jobs and schedules.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WIP_OPERATION_RESOURCES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnWIP_ENTITY_ID
ColumnOPERATION_SEQ_NUM
ColumnRESOURCE_SEQ_NUM
ColumnORGANIZATION_ID
ColumnREPETITIVE_SCHEDULE_ID
WIP_OPERATION_RESOURCES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREPETITIVE_SCHEDULE_ID
ColumnORGANIZATION_ID
ColumnOPERATION_SEQ_NUM
WIP_OPERATION_RESOURCES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESOURCE_ID
WIP_OPERATION_RESOURCES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnSTART_DATE
ColumnCOMPLETION_DATE
ColumnRESOURCE_ID
WIP_OPERATION_RESOURCES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnRESOURCE_ID
ColumnACTUAL_START_DATE
ColumnWIP_ENTITY_ID
ColumnOPERATION_SEQ_NUM
ColumnRESOURCE_SEQ_NUM
ColumnDEPARTMENT_ID
Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER
Yes WIP job or repetitive assembly Identifier
OPERATION_SEQ_NUM NUMBER
Yes Operation sequence number within a routing
RESOURCE_SEQ_NUM NUMBER
Yes Resource sequence number
ORGANIZATION_ID NUMBER
Yes Organization Identifier
REPETITIVE_SCHEDULE_ID NUMBER

WIP repetitive schedule Identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Enhanced Who column
PROGRAM_APPLICATION_ID NUMBER

Enhanced Who column
PROGRAM_ID NUMBER

Enhanced Who column
PROGRAM_UPDATE_DATE DATE

Enhanced Who column
RESOURCE_ID NUMBER
Yes Resource Identifier
UOM_CODE VARCHAR2 (3)
Unit of measure code
BASIS_TYPE NUMBER
Yes Basis for scheduling and charging resource
USAGE_RATE_OR_AMOUNT NUMBER
Yes Rate per assembly or amount per job/schedule
ACTIVITY_ID NUMBER

Activity Identifier
SCHEDULED_FLAG NUMBER
Yes Method of scheduling the resource
ASSIGNED_UNITS NUMBER

Number of resources assigned to do work
AUTOCHARGE_TYPE NUMBER
Yes Method of charging the resource
STANDARD_RATE_FLAG NUMBER
Yes Indicates whether the resource is charged at the standard rate
APPLIED_RESOURCE_UNITS NUMBER
Yes Amount of resource units charged
APPLIED_RESOURCE_VALUE NUMBER
Yes Value of resource units charged
START_DATE DATE
Yes Scheduled start date of the resource
COMPLETION_DATE DATE
Yes Scheduled completion date of the resource
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
RELIEVED_RES_COMPLETION_UNITS NUMBER

Units of resource relieved due to WIP completion
RELIEVED_RES_SCRAP_UNITS NUMBER

Units of resource relieved due to WIP scrap
RELIEVED_RES_COMPLETION_VALUE NUMBER

Value of resource relieved due to WIP completion
RELIEVED_RES_SCRAP_VALUE NUMBER

Value of resource relieved due to WIP scrap
RELIEVED_VARIANCE_VALUE NUMBER

Value of variance relieved
TEMP_RELIEVED_VALUE NUMBER

Temporary column used in completion cost implementation
RELIEVED_RES_FINAL_COMP_UNITS NUMBER

Units of resource relieved due to negative final completion
DEPARTMENT_ID NUMBER

Department of this resource, if different from that of parent operation
PHANTOM_FLAG NUMBER

Indicates whether or not this is a phantom routing resource (1 for yes, 2 for no)
PHANTOM_OP_SEQ_NUM NUMBER

Operation sequence number, if part of a phantom routing
PHANTOM_ITEM_ID NUMBER

Item, if part of a phantom routing
SCHEDULE_SEQ_NUM NUMBER

schedule sequence number
SUBSTITUTE_GROUP_NUM NUMBER

substitution group number
REPLACEMENT_GROUP_NUM NUMBER

replacement group number
PRINCIPLE_FLAG NUMBER

principle flag, for aps
SETUP_ID NUMBER

Setup Identifier
PARENT_RESOURCE_SEQ NUMBER

Parent Resource Sequence
BATCH_ID NUMBER

Batch Id used in grouping operation resources across jobs
RELIEVED_RES_UNITS NUMBER

Relieved Resource Units
RELIEVED_RES_VALUE NUMBER

Relieved Resource Value
MAXIMUM_ASSIGNED_UNITS NUMBER

maximum allowed assigned_units, inserted during job creation
FIRM_FLAG NUMBER

NOT FIRM - 0, FIRM_START - 1,FIRM_END - 2, FIRM_RESOURCE -3 ,FIRM_START_END- 4, FIRM_START_RESOURCE - 5, FIRM_END_RESOURCE - 6, FIRM_ALL 7
GROUP_SEQUENCE_ID NUMBER

Identifies the firmed fixed sequence for resource req
GROUP_SEQUENCE_NUMBER NUMBER

Sequence in firmed sequence for resource requirement
ACTUAL_START_DATE DATE

An actual resource start date.
ACTUAL_COMPLETION_DATE DATE

An actual resource completion date.
PROJECTED_COMPLETION_DATE DATE

Projected Completion Date
Query Text

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


SELECT WIP_ENTITY_ID
,      OPERATION_SEQ_NUM
,      RESOURCE_SEQ_NUM
,      ORGANIZATION_ID
,      REPETITIVE_SCHEDULE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      RESOURCE_ID
,      UOM_CODE
,      BASIS_TYPE
,      USAGE_RATE_OR_AMOUNT
,      ACTIVITY_ID
,      SCHEDULED_FLAG
,      ASSIGNED_UNITS
,      AUTOCHARGE_TYPE
,      STANDARD_RATE_FLAG
,      APPLIED_RESOURCE_UNITS
,      APPLIED_RESOURCE_VALUE
,      START_DATE
,      COMPLETION_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      RELIEVED_RES_COMPLETION_UNITS
,      RELIEVED_RES_SCRAP_UNITS
,      RELIEVED_RES_COMPLETION_VALUE
,      RELIEVED_RES_SCRAP_VALUE
,      RELIEVED_VARIANCE_VALUE
,      TEMP_RELIEVED_VALUE
,      RELIEVED_RES_FINAL_COMP_UNITS
,      DEPARTMENT_ID
,      PHANTOM_FLAG
,      PHANTOM_OP_SEQ_NUM
,      PHANTOM_ITEM_ID
,      SCHEDULE_SEQ_NUM
,      SUBSTITUTE_GROUP_NUM
,      REPLACEMENT_GROUP_NUM
,      PRINCIPLE_FLAG
,      SETUP_ID
,      PARENT_RESOURCE_SEQ
,      BATCH_ID
,      RELIEVED_RES_UNITS
,      RELIEVED_RES_VALUE
,      MAXIMUM_ASSIGNED_UNITS
,      FIRM_FLAG
,      GROUP_SEQUENCE_ID
,      GROUP_SEQUENCE_NUMBER
,      ACTUAL_START_DATE
,      ACTUAL_COMPLETION_DATE
,      PROJECTED_COMPLETION_DATE
FROM WIP.WIP_OPERATION_RESOURCES;

Dependencies

[top of page]

WIP.WIP_OPERATION_RESOURCES does not reference any database object

WIP.WIP_OPERATION_RESOURCES is referenced by following:

SchemaWIP
ViewWIP_OPERATION_RESOURCES#