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

TABLE: WIP.WIP_OPS_RES_INTERFACE

Object Details
Object Name: WIP_OPS_RES_INTERFACE
Object Type: TABLE
Owner: WIP
Subobject Name:
Status: VALID


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:
Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER

WIP job or repetitive assembly Identifier
ORGANIZATION_ID NUMBER

Organization Identifier
OPERATION_SEQ_NUM NUMBER

Operation sequence number within a routing
RESOURCE_SEQ_NUM NUMBER

Resource sequence number
RESOURCE_ID NUMBER

Resource identifier
UOM_CODE VARCHAR2 (10)
Unit of measure code
BASIS_TYPE NUMBER

Basis for scheduling and charging resource
USAGE_RATE_OR_AMOUNT NUMBER

Rate per assembly or amount per job/schedule
SCHEDULED_FLAG NUMBER

Method of scheduling the resource
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
ASSIGNED_UNITS NUMBER

Number of resources assigned to do work
MAXIMUM_ASSIGNED_UNITS NUMBER

maximum allowed assigned_units, inserted during job creation
AUTOCHARGE_TYPE NUMBER

Method of charging the resource
STANDARD_RATE_FLAG NUMBER

Indicates whether the resource is charged at the standard rate
APPLIED_RESOURCE_UNITS NUMBER

Amount of resource units charged
APPLIED_RESOURCE_VALUE NUMBER

Value of resource units charged
START_DATE DATE

Scheduled start date of the resource
COMPLETION_DATE DATE

Scheduled completion date of the resource
SCHEDULE_SEQ_NUM NUMBER

schedule sequence number
DEPARTMENT_ID NUMBER

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

Standard Who column
CREATION_DATE DATE

Standard Who column
HEADER_ID NUMBER

Header identifier
BATCH_ID NUMBER

Batch Id used in grouping operation resources across jobs
ROW_ID NUMBER

Row identifier
OP_START_DATE DATE

Operation start date
OP_COMPLETION_DATE DATE

Operation completion date
OP_DESCRIPTION VARCHAR2 (240)
Operation description
OP_MINIMUM_TRANSFER_QUANTITY NUMBER

Operation minimum transfer quantity
Query Text

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


SELECT WIP_ENTITY_ID
,      ORGANIZATION_ID
,      OPERATION_SEQ_NUM
,      RESOURCE_SEQ_NUM
,      RESOURCE_ID
,      UOM_CODE
,      BASIS_TYPE
,      USAGE_RATE_OR_AMOUNT
,      SCHEDULED_FLAG
,      FIRM_FLAG
,      ASSIGNED_UNITS
,      MAXIMUM_ASSIGNED_UNITS
,      AUTOCHARGE_TYPE
,      STANDARD_RATE_FLAG
,      APPLIED_RESOURCE_UNITS
,      APPLIED_RESOURCE_VALUE
,      START_DATE
,      COMPLETION_DATE
,      SCHEDULE_SEQ_NUM
,      DEPARTMENT_ID
,      CREATED_BY
,      CREATION_DATE
,      HEADER_ID
,      BATCH_ID
,      ROW_ID
,      OP_START_DATE
,      OP_COMPLETION_DATE
,      OP_DESCRIPTION
,      OP_MINIMUM_TRANSFER_QUANTITY
FROM WIP.WIP_OPS_RES_INTERFACE;

Dependencies

[top of page]

WIP.WIP_OPS_RES_INTERFACE does not reference any database object

WIP.WIP_OPS_RES_INTERFACE is referenced by following:

SchemaWIP
ViewWIP_OPS_RES_INTERFACE#