[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | 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 |
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;
FLM.FLM_KANBAN_PURGE_TEMP does not reference any database object
FLM.FLM_KANBAN_PURGE_TEMP is referenced by following:
|
|
|