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

VIEW: APPS.INVBV_KANBAN_CARDS

Object Details
Object Name: INVBV_KANBAN_CARDS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.INVBV_KANBAN_CARDS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows information of Kanban card details.


[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
_LA:SUPPLY_STATUS CHAR (66)

_LA:CARD_STATUS CHAR (62)

_LA:KANBAN_CARD_TYPE CHAR (65)

_LA:SOURCE_TYPE CHAR (62)

KANBAN_SIZE NUMBER
Yes
INVENTORY_LOCATOR_ID NUMBER


SUPPLIER_ID NUMBER


SUPPLIER_SITE_ID NUMBER


SOURCE_ORGANIZATION_ID NUMBER


SOURCE_SUBINVENTORY_NAME VARCHAR2 (10)

SOURCE_INVENTORY_LOCATOR_ID NUMBER


_LA:ERROR_CODE CHAR (60)

LAST_PRINT_DATE DATE


CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
WIP_LINE_ID 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
,      _LA:SUPPLY_STATUS
,      _LA:CARD_STATUS
,      _LA:KANBAN_CARD_TYPE
,      _LA:SOURCE_TYPE
,      KANBAN_SIZE
,      INVENTORY_LOCATOR_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      SOURCE_ORGANIZATION_ID
,      SOURCE_SUBINVENTORY_NAME
,      SOURCE_INVENTORY_LOCATOR_ID
,      _LA:ERROR_CODE
,      LAST_PRINT_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      WIP_LINE_ID
FROM APPS.INVBV_KANBAN_CARDS;

Dependencies

[top of page]

APPS.INVBV_KANBAN_CARDS references the following:

SchemaAPPS
SynonymMTL_KANBAN_CARDS

APPS.INVBV_KANBAN_CARDS is not referenced by any database object