[Home] [Help] [Dependency Information]
Object Name: | WSM_LOT_JOB_DTL_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | WSM |
Subobject Name: | |
Status: | VALID |
Interface table for the Import of Lot Based Job Details in OSFM.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 20 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WSM_LOT_JOB_DTL_INTERFACE_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | RECORD_ID |
WSM_LOT_JOB_DTL_INTERFACE_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
WIP_ENTITY_ID
ROUTING_OP_SEQ_NUM NEXT_ROUTING_OP_SEQ_NUM JOB_OP_SEQ_NUM |
WSM_LOT_JOB_DTL_INTERFACE_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
JOB_NAME
ORGANIZATION_ID |
WSM_LOT_JOB_DTL_INTERFACE_N3 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | PARENT_HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECORD_ID | NUMBER | Yes | Primary Key of the table, must be unique | |
INTERFACE_ID | NUMBER | Interface identifier | ||
GROUP_ID | NUMBER | Processing group identifier | ||
PARENT_HEADER_ID | NUMBER | Identifies this row's parent in WSM_LOT_JOB _INTERFACE | ||
LOAD_TYPE | NUMBER | Yes | 1-resource, 2-component, 3-operation, 4-resource usage, 5-link, 6-link and operation, 7-resource instance | |
SUBSTITUTION_TYPE | NUMBER | Yes | 1-delete, 2-add, 3-change, 4-recommend and update, 5-discommend | |
PROCESS_PHASE | NUMBER | Yes | Process phase | |
PROCESS_STATUS | NUMBER | Yes | 1-Pending, 2-Running, 3-Error, 4-Completed and 5-Warning | |
JOB_NAME | VARCHAR2 | (240) | Lot based job name | |
WIP_ENTITY_ID | NUMBER | WIP entity identifier, when parent_header_id = NULL, this / job_name is needed to push details | ||
ORGANIZATION_ID | NUMBER | Organization Identifier | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization Code | |
DEPARTMENT_ID | NUMBER | Department Identifier | ||
DEPARTMENT_CODE | VARCHAR2 | (10) | Department Code | |
DESCRIPTION | VARCHAR2 | (240) | Long Description | |
JOB_OP_SEQ_NUM | NUMBER | Current operation sequence number of the job | ||
ROUTING_OP_SEQ_NUM | NUMBER | Operation sequence number within a network routing | ||
NEXT_ROUTING_OP_SEQ_NUM | NUMBER | The next routing operation sequence number defined in a network path | ||
RESOURCE_SEQ_NUM | NUMBER | Resource sequence number | ||
RESOURCE_ID_OLD | NUMBER | Resource identifier existing in current job | ||
RESOURCE_ID_NEW | NUMBER | Resource identifier to be added, changed or recommended | ||
RESOURCE_CODE_OLD | VARCHAR2 | (10) | Resource code existing in current job | |
RESOURCE_CODE_NEW | VARCHAR2 | (10) | Resource code to be added, changed or recommended | |
USAGE_RATE_OR_AMOUNT | NUMBER | Rate per assembly or amount per job | ||
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 | ||
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 | ||
SCHEDULE_SEQ_NUM | NUMBER | Schedule sequence number | ||
SUBSTITUTE_GROUP_NUM | NUMBER | Substitute group number of the resource | ||
REPLACEMENT_GROUP_NUM | NUMBER | Replacement group number of the resource | ||
SETUP_ID | NUMBER | Setup identifier | ||
BATCH_ID | NUMBER | Batch identifier | ||
INVENTORY_ITEM_ID_OLD | NUMBER | Old material requirement identifier | ||
INVENTORY_ITEM_ID_NEW | NUMBER | New material requirement identifier to be added, modified and recommended | ||
INVENTORY_ITEM_OLD | VARCHAR2 | (150) | Old material requirement | |
INVENTORY_ITEM_NEW | VARCHAR2 | (150) | New material requirement to be added, modified and recommended | |
PRIMARY_ITEM_ID | NUMBER | The primary item identifier defined in BOM | ||
PRIMARY_ITEM | VARCHAR2 | (150) | The primary item defined in BOM | |
SRC_PHANTOM_ITEM_ID | NUMBER | The top phantom item identifier from which this item comes | ||
SRC_PHANTOM_ITEM | VARCHAR2 | (150) | The top phantom item from which this item comes | |
COMPONENT_SEQUENCE_ID | NUMBER | Component sequence identifier | ||
QUANTITY_PER_ASSEMBLY | NUMBER | Part usage quantity | ||
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 | ||
STANDARD_OPERATION_ID | NUMBER | Standard operation identifier | ||
SCHEDULED_QUANTITY | NUMBER | Scheduled quantity for the operation | ||
OPERATION_YIELD | NUMBER | Operation yield | ||
OPERATION_START_DATE | DATE | Scheduled operation start date | ||
OPERATION_COMPLETION_DATE | DATE | Scheduled operation completion date | ||
MINIMUM_TRANSFER_QUANTITY | NUMBER | Minimum operation transfer quantity | ||
BACKFLUSH_FLAG | NUMBER | Backflush control code | ||
COUNT_POINT_TYPE | NUMBER | Count point type | ||
PLANNING_PCT | NUMBER | Network path planning percentage | ||
TRANSACTION_DATE | DATE | Yes | Indicating the date of transaction, only records transaction_date > sysdate are picked up for processing. | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY_NAME | VARCHAR2 | (100) | User who last updated this row | |
LAST_UPDATED_BY | NUMBER | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | ||
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY_NAME | VARCHAR2 | (100) | Name of the user who created this row | |
CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition 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 | |
INSTANCE_ID_NEW | NUMBER | Instance identifier to be added, changed, recommended | ||
INSTANCE_ID_OLD | NUMBER | Instance identifier that is in the job | ||
SERIAL_NUMBER_NEW | VARCHAR2 | (30) | Serial number to be added, changed, recommended | |
SERIAL_NUMBER_OLD | VARCHAR2 | (30) | Serial number that is in the job | |
AUTO_REQUEST_MATERIAL | VARCHAR2 | (1) | Autometice request material | |
COMMENTS | VARCHAR2 | (240) | Comments | |
ERROR_CODE | NUMBER | Processing error code, populated by the concurrent program | ||
ERROR_MSG | VARCHAR2 | (2000) | Processing error message, populated by the concurrent program | |
FIRM_TYPE | NUMBER | Firm Type | ||
GROUP_SEQUENCE_ID | NUMBER | Group Sequence Id | ||
GROUP_SEQUENCE_NUM | NUMBER | Group Sequence Number | ||
MAX_ASSIGNED_UNITS | NUMBER | Maximum Assigned Units | ||
PARENT_RESOURCE_SEQ_NUM | NUMBER | This Identifies Parent Resource for a setup resource | ||
RESOURCE_HOURS | NUMBER | Resource Hours | ||
SETUP_CODE | VARCHAR2 | (10) | Code For Setup Resources | |
INCLUDE_IN_ROLLUP | NUMBER | Include in rollup | ||
OPTION_DEPENDENT_FLAG | NUMBER | Option dependent flag | ||
OPERATION_YIELD_ENABLED | NUMBER | Operation Yield Enabled | ||
RECOMMENDED | VARCHAR2 | (1) | Recommended | |
STANDARD_OPERATION_CODE | VARCHAR2 | (4) | Standard Operation Code | |
CUMULATIVE_YIELD | NUMBER | CUMULATIVE YIELD | ||
REVERSE_CUMULATIVE_YIELD | NUMBER | REVERSE CUMULATIVE YIELD |
Cut, paste (and edit) the following text to query this object:
SELECT RECORD_ID
, INTERFACE_ID
, GROUP_ID
, PARENT_HEADER_ID
, LOAD_TYPE
, SUBSTITUTION_TYPE
, PROCESS_PHASE
, PROCESS_STATUS
, JOB_NAME
, WIP_ENTITY_ID
, ORGANIZATION_ID
, ORGANIZATION_CODE
, DEPARTMENT_ID
, DEPARTMENT_CODE
, DESCRIPTION
, JOB_OP_SEQ_NUM
, ROUTING_OP_SEQ_NUM
, NEXT_ROUTING_OP_SEQ_NUM
, RESOURCE_SEQ_NUM
, RESOURCE_ID_OLD
, RESOURCE_ID_NEW
, RESOURCE_CODE_OLD
, RESOURCE_CODE_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
, SCHEDULE_SEQ_NUM
, SUBSTITUTE_GROUP_NUM
, REPLACEMENT_GROUP_NUM
, SETUP_ID
, BATCH_ID
, INVENTORY_ITEM_ID_OLD
, INVENTORY_ITEM_ID_NEW
, INVENTORY_ITEM_OLD
, INVENTORY_ITEM_NEW
, PRIMARY_ITEM_ID
, PRIMARY_ITEM
, SRC_PHANTOM_ITEM_ID
, SRC_PHANTOM_ITEM
, COMPONENT_SEQUENCE_ID
, QUANTITY_PER_ASSEMBLY
, WIP_SUPPLY_TYPE
, DATE_REQUIRED
, REQUIRED_QUANTITY
, QUANTITY_ISSUED
, SUPPLY_SUBINVENTORY
, SUPPLY_LOCATOR_ID
, MRP_NET_FLAG
, MPS_REQUIRED_QUANTITY
, MPS_DATE_REQUIRED
, STANDARD_OPERATION_ID
, SCHEDULED_QUANTITY
, OPERATION_YIELD
, OPERATION_START_DATE
, OPERATION_COMPLETION_DATE
, MINIMUM_TRANSFER_QUANTITY
, BACKFLUSH_FLAG
, COUNT_POINT_TYPE
, PLANNING_PCT
, TRANSACTION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY_NAME
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY_NAME
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, INSTANCE_ID_NEW
, INSTANCE_ID_OLD
, SERIAL_NUMBER_NEW
, SERIAL_NUMBER_OLD
, AUTO_REQUEST_MATERIAL
, COMMENTS
, ERROR_CODE
, ERROR_MSG
, FIRM_TYPE
, GROUP_SEQUENCE_ID
, GROUP_SEQUENCE_NUM
, MAX_ASSIGNED_UNITS
, PARENT_RESOURCE_SEQ_NUM
, RESOURCE_HOURS
, SETUP_CODE
, INCLUDE_IN_ROLLUP
, OPTION_DEPENDENT_FLAG
, OPERATION_YIELD_ENABLED
, RECOMMENDED
, STANDARD_OPERATION_CODE
, CUMULATIVE_YIELD
, REVERSE_CUMULATIVE_YIELD
FROM WSM.WSM_LOT_JOB_DTL_INTERFACE;
WSM.WSM_LOT_JOB_DTL_INTERFACE does not reference any database object
WSM.WSM_LOT_JOB_DTL_INTERFACE is referenced by following:
|
|
|