[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSC_WIP_JOB_DTLS_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | MSC |
| FND Design Data: |  MSC.MSC_WIP_JOB_DTLS_INTERFACE
|
| 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: |  APPS_TS_INTERFACE |
|---|---|
| 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:
APPS
MSC_WIP_JOB_DTLS_INTERFACE
|
|
|
|