Skip to content

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

TABLE: WSM.WSM_LOT_JOB_DTL_INTERFACE

Object Details
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.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 20
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WSM_LOT_JOB_DTL_INTERFACE_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnRECORD_ID
WSM_LOT_JOB_DTL_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnWIP_ENTITY_ID
ColumnROUTING_OP_SEQ_NUM
ColumnNEXT_ROUTING_OP_SEQ_NUM
ColumnJOB_OP_SEQ_NUM
WSM_LOT_JOB_DTL_INTERFACE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnJOB_NAME
ColumnORGANIZATION_ID
WSM_LOT_JOB_DTL_INTERFACE_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPARENT_HEADER_ID
Columns
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
STANDARD_OPERATION_CODE VARCHAR2 (4)
STANDARD OPERATION CODE
CUMULATIVE_YIELD NUMBER

CUMULATIVE_YIELD
REVERSE_CUMULATIVE_YIELD NUMBER

REVERSE_CUMULATIVE_YIELD
Query Text

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;

Dependencies

[top of page]

WSM.WSM_LOT_JOB_DTL_INTERFACE does not reference any database object

WSM.WSM_LOT_JOB_DTL_INTERFACE is referenced by following:

SchemaWSM
ViewWSM_LOT_JOB_DTL_INTERFACE#