[Home] [Help]
[Dependency Information]
Object Name: | MSC_WIP_JOB_DTLS_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
MSC_JOB_DTLS_INTERFACE contains requests to add/delete/modify
material and/or resource requirements for existing discrete jobs
or repetitive schedules.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_ID | NUMBER | Interface identifier | ||
GROUP_ID | NUMBER | Processing group identifier | ||
OPERATION_SEQ_NUM | NUMBER | Operation sequence number | ||
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/changed to | ||
USAGE_RATE_OR_AMOUNT | NUMBER | Assembly or amount per job/schedule | ||
SCHEDULED_FLAG | NUMBER | Method of scheduling the resource | ||
ASSIGNED_UNITS | NUMBER | Number of resources assigned to do 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 | ||
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 | Required quantity | ||
QUANTITY_ISSUED | NUMBER | Issued quantity | ||
SUPPLY_SUBINVENTORY | VARCHAR2 | (10) | Supply subinventory | |
SUPPLY_LOCATOR_ID | NUMBER | Locator used to supply component to WIP | ||
MRP_NET_FLAG | NUMBER | 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 | Material or resource requirement | ||
SUBSTITUTION_TYPE | NUMBER | Add, delete or change | ||
PROCESS_PHASE | NUMBER | Process phase | ||
PROCESS_STATUS | NUMBER | Process status | ||
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
LAST_UPDATED_BY | NUMBER | Standard Who Column | ||
CREATION_DATE | DATE | Standard Who Column | ||
CREATED_BY | NUMBER | Standard Who Column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
REQUEST_ID | NUMBER | Concurrent Who Column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who Column | ||
PROGRAM_ID | NUMBER | Concurrent Who Column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Who Column | ||
PARENT_HEADER_ID | NUMBER | Identifies this rows parent in JOB_SCHEDULE_INTERFACE | ||
DESCRIPTION | VARCHAR2 | (240) | Describe the job detail | |
STANDARD_OPERATION_ID | NUMBER | Standard operation identifier | ||
FIRST_UNIT_START_DATE | DATE | First unit start date | ||
FIRST_UNIT_COMPLETION_DATE | DATE | First unit completion date | ||
LAST_UNIT_START_DATE | DATE | Last unit start date | ||
LAST_UNIT_COMPLETION_DATE | DATE | Last unit completion date | ||
COUNT_POINT_TYPE | NUMBER | Count point type | ||
BACKFLUSH_FLAG | NUMBER | Backflush flag | ||
MINIMUM_TRANSFER_QUANTITY | NUMBER | Minimum transfer quantity | ||
WIP_ENTITY_ID | NUMBER | WIP entity identifier | ||
ORGANIZATION_ID | NUMBER | Organization identifier | ||
SR_INSTANCE_ID | NUMBER | Source application instance identifier | ||
ORGANIZATION_TYPE | NUMBER | Organization type | ||
ALTERNATE_NUM | NUMBER | Alternate number | ||
CFM_ROUTING_FLAG | NUMBER | CFM routing flag | ||
FIRM_FLAG | NUMBER | Firm Flag | ||
OPERATION_SEQ_ID | NUMBER | Operation Seq Id | ||
RESOURCE_HOURS | NUMBER | Resource hours required | ||
JOB_OP_SEQ_NUM | NUMBER | Current operation seq number of the job | ||
NEXT_ROUTING_OP_SEQ_NUM | NUMBER | Next routing operation seq number defined in a network path | ||
COMPONENT_SEQ_ID | NUMBER | component unique identifier | ||
SOURCE_PHANTOM_ID | NUMBER | Top level phantom component identifier | ||
PRIMARY_COMPONENT_ID | NUMBER | component identifier of the primary component for the current operation | ||
SCHEDULED_QUANTITY | NUMBER | Scheduled quantity for an operation | ||
SERIAL_NUMBER | VARCHAR2 | (30) | serial number | |
SETUP_ID | NUMBER | setup_id | ||
GROUP_SEQUENCE_ID | NUMBER | group sequence id | ||
GROUP_SEQUENCE_NUMBER | NUMBER | group sequence number | ||
BATCH_ID | NUMBER | Batch id | ||
RESOURCE_INSTANCE_ID | NUMBER | Resource instance | ||
CHARGE_NUMBER | NUMBER | change number | ||
MAXIMUM_ASSIGNED_UNITS | NUMBER | Max. assigned units | ||
PARENT_SEQ_NUM | NUMBER | parent sequence number | ||
SCHEDULE_SEQ_NUM | NUMBER | schedule sequence number | ||
ORIG_RESOURCE_SEQ_NUM | NUMBER | original resource sequence number | ||
EAM_FLAG | NUMBER | EAM | ||
COMPONENT_YIELD_FACTOR | NUMBER | Component Yield Factor |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_ID
, GROUP_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
, COUNT_POINT_TYPE
, BACKFLUSH_FLAG
, MINIMUM_TRANSFER_QUANTITY
, WIP_ENTITY_ID
, ORGANIZATION_ID
, SR_INSTANCE_ID
, ORGANIZATION_TYPE
, ALTERNATE_NUM
, CFM_ROUTING_FLAG
, FIRM_FLAG
, OPERATION_SEQ_ID
, RESOURCE_HOURS
, JOB_OP_SEQ_NUM
, NEXT_ROUTING_OP_SEQ_NUM
, COMPONENT_SEQ_ID
, SOURCE_PHANTOM_ID
, PRIMARY_COMPONENT_ID
, SCHEDULED_QUANTITY
, SERIAL_NUMBER
, SETUP_ID
, GROUP_SEQUENCE_ID
, GROUP_SEQUENCE_NUMBER
, BATCH_ID
, RESOURCE_INSTANCE_ID
, CHARGE_NUMBER
, MAXIMUM_ASSIGNED_UNITS
, PARENT_SEQ_NUM
, SCHEDULE_SEQ_NUM
, ORIG_RESOURCE_SEQ_NUM
, EAM_FLAG
, COMPONENT_YIELD_FACTOR
FROM MSC.MSC_WIP_JOB_DTLS_INTERFACE;
MSC.MSC_WIP_JOB_DTLS_INTERFACE does not reference any database object
MSC.MSC_WIP_JOB_DTLS_INTERFACE is referenced by following:
|
|
|