DBA Data[Home] [Help] [Dependency Information]

VIEW: INV.MTL_KANBAN_CARDS#

Object Details
Object Name: MTL_KANBAN_CARDS#
Object Type: VIEW
Owner: INV
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
KANBAN_CARD_ID NUMBER
Yes
KANBAN_CARD_NUMBER VARCHAR2 (200) Yes
PULL_SEQUENCE_ID NUMBER
Yes
INVENTORY_ITEM_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
SUBINVENTORY_NAME VARCHAR2 (10) Yes
SUPPLY_STATUS NUMBER
Yes
CARD_STATUS NUMBER
Yes
KANBAN_CARD_TYPE NUMBER
Yes
SOURCE_TYPE NUMBER
Yes
KANBAN_SIZE NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LOCATOR_ID NUMBER

SUPPLIER_ID NUMBER

SUPPLIER_SITE_ID NUMBER

SOURCE_ORGANIZATION_ID NUMBER

SOURCE_SUBINVENTORY VARCHAR2 (10)
SOURCE_LOCATOR_ID NUMBER

WIP_LINE_ID NUMBER

CURRENT_REPLNSH_CYCLE_ID NUMBER

ERROR_CODE NUMBER

LAST_UPDATE_LOGIN NUMBER

LAST_PRINT_DATE DATE

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

REPLENISHMENT_COUNT NUMBER

MAX_REPLENISHMENTS NUMBER

DISABLE_DATE DATE

REPLACEMENT_FLAG NUMBER

LAST_STATUS_CHANGE_DATE DATE

MOVE_STATUS NUMBER

Query Text

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


SELECT KANBAN_CARD_ID
,      KANBAN_CARD_NUMBER
,      PULL_SEQUENCE_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SUBINVENTORY_NAME
,      SUPPLY_STATUS
,      CARD_STATUS
,      KANBAN_CARD_TYPE
,      SOURCE_TYPE
,      KANBAN_SIZE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LOCATOR_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      SOURCE_ORGANIZATION_ID
,      SOURCE_SUBINVENTORY
,      SOURCE_LOCATOR_ID
,      WIP_LINE_ID
,      CURRENT_REPLNSH_CYCLE_ID
,      ERROR_CODE
,      LAST_UPDATE_LOGIN
,      LAST_PRINT_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REPLENISHMENT_COUNT
,      MAX_REPLENISHMENTS
,      DISABLE_DATE
,      REPLACEMENT_FLAG
,      LAST_STATUS_CHANGE_DATE
,      MOVE_STATUS
FROM INV.MTL_KANBAN_CARDS#;

Dependencies

[top of page]

INV.MTL_KANBAN_CARDS# references the following:

SchemaINV
TableMTL_KANBAN_CARDS
INV.MTL_KANBAN_CARDS# is referenced by following:

SchemaAPPS
SynonymMTL_KANBAN_CARDS