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

TABLE: WSM.WSM_RESULTING_JOBS_INTERFACE

Object Details
Object Name: WSM_RESULTING_JOBS_INTERFACE
Object Type: TABLE
Owner: WSM
FND Design Data: TableWSM.WSM_RESULTING_JOBS_INTERFACE
Subobject Name:
Status: VALID


Interface table for Import WIP Lot Transaction's Resulting Lots - Child Table for WSM_SPLIT_MERGE_TXN_INTERFACE.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WSM_RESULT_JOBS_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnHEADER_ID
ColumnWIP_ENTITY_NAME
WSM_RESULT_JOBS_INTERFACE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnWIP_ENTITY_NAME
ColumnORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER (15) Yes Header Identifier
GROUP_ID NUMBER (15)
Transaction Group Identifier
WIP_ENTITY_NAME VARCHAR2 (240) Yes Lot based Job Name.
DESCRIPTION VARCHAR2 (240)
Job Description.
PRIMARY_ITEM_ID NUMBER
Yes Inventory item Identifier for the assembly the job or schedule creates
CLASS_CODE VARCHAR2 (10)
WIP Accounting class associated with the job
START_QUANTITY NUMBER
Yes Job start quantity
BOM_REFERENCE_ID NUMBER

Assembly identifier used as bill of material reference for explosions of nonstandard job
ROUTING_REFERENCE_ID NUMBER

Assembly identifier used as routing reference for explosions of nonstandard job
COMMON_BOM_SEQUENCE_ID NUMBER

Bill of material identifier when a common bill is used
COMMON_ROUTING_SEQUENCE_ID NUMBER

Routing identifier when a common routing is used
ROUTING_REVISION VARCHAR2 (3)
Short code that uniquely identifies the Routing revision
BOM_REVISION VARCHAR2 (3)
BOM revision for the primary assembly
BOM_REVISION_DATE DATE

Date of assembly item revision used to explode the bills of material used in the job
ROUTING_REVISION_DATE DATE

Routing revision date
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Designator if an Alternate Bill is used in this Job.
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Designator if an Alternate Routing is used in this Job.
COMPLETION_SUBINVENTORY VARCHAR2 (10)
Default completion subinventory for assemblies completed by the job
STARTING_OPERATION_SEQ_NUM NUMBER

Starting Operation Sequence Number
STARTING_INTRAOPERATION_STEP NUMBER

Starting Intra-operation step
SCHEDULED_COMPLETION_DATE DATE

Last unit scheduled completion date
STARTING_WIP_ENTITY_RENAME VARCHAR2 (240)
Starting WIP Entity Rename
FORWARD_OP_OPTION NUMBER

Forward Operations Option
BONUS_ACCT_ID NUMBER (15)
Bonus Account Identifier
DEMAND_CLASS VARCHAR2 (30)
Demand class.
PROCESS_STATUS NUMBER
Yes Transaction processing status
ERROR_MESSAGE VARCHAR2 (2000)
Error Message
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes 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 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).
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
REQUEST_ID NUMBER (15)
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 (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
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).
COMPLETION_LOCATOR_ID NUMBER (15)
Default completion locator identifier for assemblies completed by the job
STARTING_OPERATION_CODE VARCHAR2 (4)
Starting Operation Code
STARTING_STD_OP_ID NUMBER

Starting Standard Operation Identifier
SCHEDULED_START_DATE DATE

Scheduled Start date.
COPRODUCTS_SUPPLY NUMBER

Coproducts Supply
NET_QUANTITY NUMBER

Planning Net Quantity.
XML_DOCUMENT_ID VARCHAR2 (240)
Xml Document Identifier
JOB_TYPE NUMBER

Job Type 1- Standard 3-Nonstandard
ORGANIZATION_ID NUMBER

organization Identifier
INTERNAL_GROUP_ID NUMBER

Internal only. System generated
SPLIT_HAS_UPDATE_ASSY NUMBER

Value of '0' means 'no update assy' and value of '1' means 'split and update assembly'
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT HEADER_ID
,      GROUP_ID
,      WIP_ENTITY_NAME
,      DESCRIPTION
,      PRIMARY_ITEM_ID
,      CLASS_CODE
,      START_QUANTITY
,      BOM_REFERENCE_ID
,      ROUTING_REFERENCE_ID
,      COMMON_BOM_SEQUENCE_ID
,      COMMON_ROUTING_SEQUENCE_ID
,      ROUTING_REVISION
,      BOM_REVISION
,      BOM_REVISION_DATE
,      ROUTING_REVISION_DATE
,      ALTERNATE_BOM_DESIGNATOR
,      ALTERNATE_ROUTING_DESIGNATOR
,      COMPLETION_SUBINVENTORY
,      STARTING_OPERATION_SEQ_NUM
,      STARTING_INTRAOPERATION_STEP
,      SCHEDULED_COMPLETION_DATE
,      STARTING_WIP_ENTITY_RENAME
,      FORWARD_OP_OPTION
,      BONUS_ACCT_ID
,      DEMAND_CLASS
,      PROCESS_STATUS
,      ERROR_MESSAGE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      COMPLETION_LOCATOR_ID
,      STARTING_OPERATION_CODE
,      STARTING_STD_OP_ID
,      SCHEDULED_START_DATE
,      COPRODUCTS_SUPPLY
,      NET_QUANTITY
,      XML_DOCUMENT_ID
,      JOB_TYPE
,      ORGANIZATION_ID
,      INTERNAL_GROUP_ID
,      SPLIT_HAS_UPDATE_ASSY
FROM WSM.WSM_RESULTING_JOBS_INTERFACE;

Dependencies

[top of page]

WSM.WSM_RESULTING_JOBS_INTERFACE does not reference any database object

WSM.WSM_RESULTING_JOBS_INTERFACE is referenced by following:

SchemaAPPS
SynonymWSM_RESULTING_JOBS_INTERFACE