eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: WSM.WSM_LOT_BASED_JOBS

Object Details

Object Name:	WSM_LOT_BASED_JOBS
Object Type:	TABLE
Owner:	WSM
Subobject Name:
Status:	VALID

Child table of WDJ to lot based job related information

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WSM_LOT_BASED_JOBS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	WIP_ENTITY_ID ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
WIP_ENTITY_ID	NUMBER		Yes	WIP Entity ID
ORGANIZATION_ID	NUMBER		Yes	Organization ID
ON_REC_PATH	VARCHAR2	(1)	Yes	Determines whether the job is currently on the recommended path or not
INTERNAL_COPY_TYPE	NUMBER		Yes	Type of Copy (0=Correct copy, 1=Make copy from copy of COPY_PARENT_WIP_ENTITY_ID, 2=Make copy from current Routing, 3=Copy incorrect due to Upgrade)
COPY_PARENT_WIP_ENTITY_ID	NUMBER			Lot Based Job Identifier of the parent job, if this job was a result of a Split/Merge transaction.
INFINITE_SCHEDULE	VARCHAR2	(1)		Infinite Schedule Flag
ROUTING_REFRESH_DATE	DATE			Date on which Copy was last refreshed.
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).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_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).
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).
SERIALIZATION_START_OP	NUMBER			Serialization start operation for the job (default value is obtained from the routing)
FIRST_SERIAL_TXN_ID	NUMBER			Move transaction ID at which serial tracking had begun for a job
CURRENT_RTG_OP_SEQ_NUM	NUMBER			Current Routing Operation Identifier
CURRENT_JOB_OP_SEQ_NUM	NUMBER			Current Job Operation Identifier

Query Text

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


SELECT WIP_ENTITY_ID
,      ORGANIZATION_ID
,      ON_REC_PATH
,      INTERNAL_COPY_TYPE
,      COPY_PARENT_WIP_ENTITY_ID
,      INFINITE_SCHEDULE
,      ROUTING_REFRESH_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SERIALIZATION_START_OP
,      FIRST_SERIAL_TXN_ID
,      CURRENT_RTG_OP_SEQ_NUM
,      CURRENT_JOB_OP_SEQ_NUM
FROM WSM.WSM_LOT_BASED_JOBS;

Dependencies

[top of page]

WSM.WSM_LOT_BASED_JOBS does not reference any database object

WSM.WSM_LOT_BASED_JOBS is referenced by following:

APPS: WSM_LOT_BASED_JOBS