[Home] [Help] [Dependency Information]
Object Name: | WIP_JOB_DTLS_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | WIP |
FND Design Data: | WIP.WIP_JOB_DTLS_INTERFACE |
Subobject Name: | |
Status: | VALID |
WIP_JOB_DTLS_INTERFACE contains requests to add, delete, and modify
material and/or resource requirements for existing discrete jobs or
repetitive schedules. Third party Applications products place requests
in this table in order to load material and resource requirement
information into WIP. This table needs to be used in conjunction with
table WIP_JOB_SCHEDULE_INTERFACE that holds job header level
information.
Scope: public
Product: WIP
Lifecycle: active
Display Name: WIP Job Details Interface
Category: BUSINESS_ENTITY WIP_WORK_ORDER
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WIP_JOB_DTLS_INTERFACE_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
GROUP_ID
PARENT_HEADER_ID WIP_ENTITY_ID ORGANIZATION_ID LOAD_TYPE SUBSTITUTION_TYPE |
WIP_JOB_DTLS_INTERFACE_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
GROUP_ID
WIP_ENTITY_ID ORGANIZATION_ID LOAD_TYPE SUBSTITUTION_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_ID | NUMBER | Interface Identifier | ||
GROUP_ID | NUMBER | Processing group Identifier | ||
WIP_ENTITY_ID | NUMBER | WIP job or repetitive assembly Identifier | ||
ORGANIZATION_ID | NUMBER | Organization Identifier | ||
OPERATION_SEQ_NUM | NUMBER | Yes | Operation sequence number within a routing | |
RESOURCE_SEQ_NUM | NUMBER | Resource sequence number | ||
RESOURCE_ID_OLD | NUMBER | Resource Identifier existing in current jobs/schedules | ||
RESOURCE_ID_NEW | NUMBER | Resource Identifier to be added or changed | ||
USAGE_RATE_OR_AMOUNT | NUMBER | Rate per assembly or amount per job or schedule | ||
SCHEDULED_FLAG | NUMBER | Method of scheduling the resource | ||
ASSIGNED_UNITS | NUMBER | Number of resources assigned to work | ||
APPLIED_RESOURCE_UNITS | NUMBER | Amount of resource units charged | ||
APPLIED_RESOURCE_VALUE | NUMBER | Value of resource units charged | ||
UOM_CODE | VARCHAR2 | (3) | Unit of measure code | |
BASIS_TYPE | NUMBER | Basis for scheduling and charging resource if loading resource detail. Basis for component requirement if loading material detail. | ||
ACTIVITY_ID | NUMBER | Activity Identifier | ||
AUTOCHARGE_TYPE | NUMBER | Method of charging the resource | ||
STANDARD_RATE_FLAG | NUMBER | Indicates whether the resource is charged at the standard rate | ||
START_DATE | DATE | Scheduled start date of the resource | ||
COMPLETION_DATE | DATE | Scheduled completion date of the resource | ||
INVENTORY_ITEM_ID_OLD | NUMBER | Old material requirement Identifier | ||
INVENTORY_ITEM_ID_NEW | NUMBER | New material requirement Identifier | ||
QUANTITY_PER_ASSEMBLY | NUMBER | Part usage quantity | ||
DEPARTMENT_ID | NUMBER | Department Identifier | ||
WIP_SUPPLY_TYPE | NUMBER | Method of material consumption within WIP | ||
DATE_REQUIRED | DATE | Operation requirement start date | ||
REQUIRED_QUANTITY | NUMBER | Part quantity required | ||
QUANTITY_ISSUED | NUMBER | Part quantity issued | ||
SUPPLY_SUBINVENTORY | VARCHAR2 | (10) | Subinventory used to supply component to WIP | |
SUPPLY_LOCATOR_ID | NUMBER | Locator used to supply component to WIP | ||
MRP_NET_FLAG | NUMBER | Indicates whether or not MRP should consider the component requirement in its netting process | ||
MPS_REQUIRED_QUANTITY | NUMBER | Quantity used by MPS relief process | ||
MPS_DATE_REQUIRED | DATE | Date used by MPS relief process | ||
LOAD_TYPE | NUMBER | Yes | Material or resource requirement | |
SUBSTITUTION_TYPE | NUMBER | Yes | Add, delete or change | |
PROCESS_PHASE | NUMBER | Yes | Process phase | |
PROCESS_STATUS | NUMBER | Yes | Process status | |
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 | ||
PARENT_HEADER_ID | NUMBER | Identifies this row's parent in WIP_JOB_SCHEDULE_INTERFACE | ||
DESCRIPTION | VARCHAR2 | (240) | Descriptive text | |
STANDARD_OPERATION_ID | NUMBER | Standard Operation Identifier | ||
FIRST_UNIT_START_DATE | DATE | First unit scheduled receipt date | ||
FIRST_UNIT_COMPLETION_DATE | DATE | First unit scheduled completion date | ||
LAST_UNIT_START_DATE | DATE | Last unit scheduled receipt date | ||
LAST_UNIT_COMPLETION_DATE | DATE | Last unit scheduled completion date | ||
MINIMUM_TRANSFER_QUANTITY | NUMBER | Minimum operation transfer quantity | ||
BACKFLUSH_FLAG | NUMBER | Backflush control code | ||
COUNT_POINT_TYPE | NUMBER | Count Point Type | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield | |
SCHEDULE_SEQ_NUM | NUMBER | schedule sequence number | ||
SUBSTITUTE_GROUP_NUM | NUMBER | substitute group number | ||
REPLACEMENT_GROUP_NUM | NUMBER | replacement group number | ||
SETUP_ID | NUMBER | Setup Identifier | ||
BATCH_ID | NUMBER | Batch Identifier | ||
NEXT_NETWORK_OP_SEQ_NUM | NUMBER | next network operation sequence number | ||
COMMENTS | VARCHAR2 | (240) | Comment | |
SERIAL_NUMBER_NEW | VARCHAR2 | (30) | New serial number for Association to assembly | |
SERIAL_NUMBER_OLD | VARCHAR2 | (30) | Old Serial Number for Association to assembly | |
LONG_DESCRIPTION | VARCHAR2 | (4000) | long description | |
AUTO_REQUEST_MATERIAL | VARCHAR2 | (1) | For EAM only to auto create pick release for the material | |
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 | ||
RESOURCE_SERIAL_NUMBER | VARCHAR2 | (30) | used for resource instances and resource instance usage | |
GROUP_SEQUENCE_ID | NUMBER | Used if resource req is part of a fixed sequence | ||
GROUP_SEQUENCE_NUMBER | NUMBER | Used if resource req is part of a fixed sequence | ||
RESOURCE_INSTANCE_ID | NUMBER | For add/update instances of resource requirements | ||
CHARGE_NUMBER | NUMBER | Added for APS, used for OPM's resource charges | ||
PARENT_SEQ_NUM | NUMBER | Tto specify setup resource | ||
COMPONENT_YIELD_FACTOR | NUMBER | Component Yield Factor |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_ID
, GROUP_ID
, WIP_ENTITY_ID
, ORGANIZATION_ID
, OPERATION_SEQ_NUM
, RESOURCE_SEQ_NUM
, RESOURCE_ID_OLD
, RESOURCE_ID_NEW
, USAGE_RATE_OR_AMOUNT
, SCHEDULED_FLAG
, ASSIGNED_UNITS
, APPLIED_RESOURCE_UNITS
, APPLIED_RESOURCE_VALUE
, UOM_CODE
, BASIS_TYPE
, ACTIVITY_ID
, AUTOCHARGE_TYPE
, STANDARD_RATE_FLAG
, START_DATE
, COMPLETION_DATE
, INVENTORY_ITEM_ID_OLD
, INVENTORY_ITEM_ID_NEW
, QUANTITY_PER_ASSEMBLY
, DEPARTMENT_ID
, WIP_SUPPLY_TYPE
, DATE_REQUIRED
, REQUIRED_QUANTITY
, QUANTITY_ISSUED
, SUPPLY_SUBINVENTORY
, SUPPLY_LOCATOR_ID
, MRP_NET_FLAG
, MPS_REQUIRED_QUANTITY
, MPS_DATE_REQUIRED
, LOAD_TYPE
, SUBSTITUTION_TYPE
, PROCESS_PHASE
, PROCESS_STATUS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PARENT_HEADER_ID
, DESCRIPTION
, STANDARD_OPERATION_ID
, FIRST_UNIT_START_DATE
, FIRST_UNIT_COMPLETION_DATE
, LAST_UNIT_START_DATE
, LAST_UNIT_COMPLETION_DATE
, MINIMUM_TRANSFER_QUANTITY
, BACKFLUSH_FLAG
, COUNT_POINT_TYPE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SCHEDULE_SEQ_NUM
, SUBSTITUTE_GROUP_NUM
, REPLACEMENT_GROUP_NUM
, SETUP_ID
, BATCH_ID
, NEXT_NETWORK_OP_SEQ_NUM
, COMMENTS
, SERIAL_NUMBER_NEW
, SERIAL_NUMBER_OLD
, LONG_DESCRIPTION
, AUTO_REQUEST_MATERIAL
, MAXIMUM_ASSIGNED_UNITS
, FIRM_FLAG
, RESOURCE_SERIAL_NUMBER
, GROUP_SEQUENCE_ID
, GROUP_SEQUENCE_NUMBER
, RESOURCE_INSTANCE_ID
, CHARGE_NUMBER
, PARENT_SEQ_NUM
, COMPONENT_YIELD_FACTOR
FROM WIP.WIP_JOB_DTLS_INTERFACE;
WIP.WIP_JOB_DTLS_INTERFACE does not reference any database object
WIP.WIP_JOB_DTLS_INTERFACE is referenced by following:
|
|
|