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: FLM.FLM_KANBAN_PURGE_TEMP

Object Details

Object Name:	FLM_KANBAN_PURGE_TEMP
Object Type:	TABLE
Owner:	FLM
FND Design Data:	FLM.FLM_KANBAN_PURGE_TEMP
Subobject Name:
Status:	VALID

FLM_KANBAN_PURGE_TEMP table stores the temporary information for building kanban purging report.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
ORGANIZATION_ID	NUMBER		Organization identifier
ITEM_ID	NUMBER		Item identifier
SUBINVENTORY_CODE	VARCHAR2	(10)	Subinventory code
LOCATOR_ID	NUMBER		Locator identifier
COUNT	NUMBER		Count
TYPE	NUMBER		Type of data in the table.There are 3 different types : type 1 indicates the count of cards deleted for particular item in the subinventory/locator, type 2 indicates the pull sequence belonging to item in the subinventory/locator as the unreferenced pull sequence and type 3 indicates the pull sequence beloning to item in the subinventory/locator has been deleted.
GROUP_ID	NUMBER		Group identifier

Query Text

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


SELECT ORGANIZATION_ID
,      ITEM_ID
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      COUNT
,      TYPE
,      GROUP_ID
FROM FLM.FLM_KANBAN_PURGE_TEMP;

Dependencies

[top of page]

FLM.FLM_KANBAN_PURGE_TEMP does not reference any database object

FLM.FLM_KANBAN_PURGE_TEMP is referenced by following:

FLM: FLM_KANBAN_PURGE_TEMP#