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_MTL_ALLOCATIONS_TEMP

Object Details

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

This table holds temporary repetitive schedule allocation data for completion transactions. It is used during completion transactions to determine the repetitive schedules' available to complete quantity.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WIP_MTL_ALLOCATIONS_TEMP_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_TEMP_ID REPETITIVE_SCHEDULE_ID ORGANIZATION_ID
WIP_MTL_ALLOCATIONS_TEMP_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPLETION_TRANSACTION_ID

Columns

Name	Datatype	Mandatory	Comments
TRANSACTION_TEMP_ID	NUMBER	Yes	The transaction_temp_id of the related MTL_MATERIAL_TRANSACTIONS_TEMP row.
REPETITIVE_SCHEDULE_ID	NUMBER	Yes	The repetitive schedule of the temporary allocation
ORGANIZATION_ID	NUMBER	Yes	organization identifier
TRANSACTION_DATE	DATE	Yes	transaction date
COMPLETION_TRANSACTION_ID	NUMBER	Yes	completion transaction identifier
PRIMARY_QUANTITY	NUMBER	Yes	The quantity allocated to the specified repetitive schedule for the transaction.
TRANSACTION_QUANTITY	NUMBER	Yes	transaction quantity
CREATION_DATE	DATE	Yes	creation date
CREATED_BY	NUMBER	Yes	created by
LAST_UPDATE_DATE	DATE	Yes	last updated date
LAST_UPDATED_BY	NUMBER	Yes	last updated by
LAST_UPDATE_LOGIN	NUMBER		last update login
REQUEST_ID	NUMBER		request identifier
PROGRAM_APPLICATION_ID	NUMBER		program application identifier
PROGRAM_ID	NUMBER		program identifier
PROGRAM_UPDATE_DATE	DATE		Program update date

Query Text

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


SELECT TRANSACTION_TEMP_ID
,      REPETITIVE_SCHEDULE_ID
,      ORGANIZATION_ID
,      TRANSACTION_DATE
,      COMPLETION_TRANSACTION_ID
,      PRIMARY_QUANTITY
,      TRANSACTION_QUANTITY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM WIP.WIP_MTL_ALLOCATIONS_TEMP;

Dependencies

[top of page]

WIP.WIP_MTL_ALLOCATIONS_TEMP does not reference any database object

WIP.WIP_MTL_ALLOCATIONS_TEMP is referenced by following:

WIP: WIP_MTL_ALLOCATIONS_TEMP#