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: WIP.WIP_DJ_CLOSE_TEMP

Object Details

Object Name:	WIP_DJ_CLOSE_TEMP
Object Type:	TABLE
Owner:	WIP
FND Design Data:	WIP.WIP_DJ_CLOSE_TEMP
Subobject Name:
Status:	VALID

WIP_DJ_CLOSE_TEMP is a temporary table that holds information for
discrete jobs that have a status of Pending Close. Oracle Work in
Process inserts records into this table from the Close Discrete Jobs
window and also the Discrete Job Close process. Records are deleted
from this table once jobs are closed.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WIP_DJ_CLOSE_TEMP_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	WIP_ENTITY_ID
WIP_DJ_CLOSE_TEMP_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
WIP_ENTITY_ID	NUMBER		Yes	WIP job or repetitive assembly Identifier
ORGANIZATION_ID	NUMBER		Yes	Organization Identifier
WIP_ENTITY_NAME	VARCHAR2	(240)	Yes	WIP job or repetitive assembly name
STATUS_TYPE	NUMBER		Yes	Status of job
PRIMARY_ITEM_ID	NUMBER			Inventory item Identifier for the assembly the job creates
ACTUAL_CLOSE_DATE	DATE			Date the job closed
GROUP_ID	NUMBER		Yes	Processing group Identifier

Query Text

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


SELECT WIP_ENTITY_ID
,      ORGANIZATION_ID
,      WIP_ENTITY_NAME
,      STATUS_TYPE
,      PRIMARY_ITEM_ID
,      ACTUAL_CLOSE_DATE
,      GROUP_ID
FROM WIP.WIP_DJ_CLOSE_TEMP;

Dependencies

[top of page]

WIP.WIP_DJ_CLOSE_TEMP does not reference any database object

WIP.WIP_DJ_CLOSE_TEMP is referenced by following:

APPS: WIP_DJ_CLOSE_TEMP