[Home] [Help] [Dependency Information]
Object Name: | FLM_KANBAN_SUMMARY |
---|---|
Object Type: | TABLE |
Owner: | FLM |
FND Design Data: | FLM.FLM_KANBAN_SUMMARY |
Subobject Name: | |
Status: | VALID |
FLM_KANBAN_SUMMARY table stores the summary information for ranges of pull sequences that
are displayed in the Graphical Kanban Workbench
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FLM_KANBAN_SUMMARY_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SUMMARY_ID |
FLM_KANBAN_SUMMARY_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
SUMMARY_TYPE SUMMARY_CODE KANBAN_PLAN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUMMARY_ID | NUMBER | Yes | Summary identifier | |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
SUMMARY_TYPE | NUMBER | Yes | Summary Type | |
SUMMARY_CODE | VARCHAR2 | (30) | Yes | Summary Code |
KANBAN_PLAN_ID | NUMBER | Yes | Kanban plan identifier | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
NODE_TYPE | NUMBER | Node type | ||
SOURCE_ORGANIZATION_ID | NUMBER | Source organization identifier | ||
SUPPLIER_ID | NUMBER | Supplier identifier | ||
SUPPLIER_SITE_ID | NUMBER | Supplier site identifier | ||
SUBINVENTORY_NAME | VARCHAR2 | (10) | Subinventory name | |
LOCATOR_ID | NUMBER | Locator identifier | ||
WIP_LINE_ID | NUMBER | Production line identifier | ||
X_COORDINATE | NUMBER | The X coordinate for pull sequence summary node | ||
Y_COORDINATE | NUMBER | The Y coordinate for pull sequence summary node |
Cut, paste (and edit) the following text to query this object:
SELECT SUMMARY_ID
, ORGANIZATION_ID
, SUMMARY_TYPE
, SUMMARY_CODE
, KANBAN_PLAN_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, NODE_TYPE
, SOURCE_ORGANIZATION_ID
, SUPPLIER_ID
, SUPPLIER_SITE_ID
, SUBINVENTORY_NAME
, LOCATOR_ID
, WIP_LINE_ID
, X_COORDINATE
, Y_COORDINATE
FROM FLM.FLM_KANBAN_SUMMARY;
FLM.FLM_KANBAN_SUMMARY does not reference any database object
FLM.FLM_KANBAN_SUMMARY is referenced by following:
|
|
|