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

VIEW: APPS.MRP_KANBAN_DETAILS_V

Object Details
Object Name: MRP_KANBAN_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRP_KANBAN_DETAILS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
KANBAN_PLAN_ID NUMBER
Yes Kanban plan identifier
KANBAN_DESIGNATOR VARCHAR2 (10) Yes Kanban designator
DESCRIPTION VARCHAR2 (50)
Kanban designator description
PULL_SEQUENCE_ID NUMBER
Yes Kanban pull sequence identifier
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
ITEM VARCHAR2 (40)
Item name
SUBINVENTORY_NAME VARCHAR2 (10) Yes Subinventory name
LOCATOR_ID NUMBER

Locator Identifier
LOCATOR VARCHAR2 (4000)
Locator Name
SOURCE_TYPE NUMBER
Yes Kanban source type
SOURCE_TYPE_NAME VARCHAR2 (80) Yes Kanban source type name
SOURCE_ORGANIZATION_ID NUMBER

Source organization identifier
SOURCE_ORGANIZATION VARCHAR2 (3)
Source organization code
SOURCE_SUBINVENTORY VARCHAR2 (10)
Source subinventory
SOURCE_LOCATOR_ID NUMBER

Source locator identifier
SOURCE_LOCATOR VARCHAR2 (4000)
Source locator name
LINE_ID NUMBER

Line identifier
LINE VARCHAR2 (10)
Line code
SUPPLIER_ID NUMBER

Supplier identifier
SUPPLIER_NAME VARCHAR2 (240)
Supplier Name
SUPPLIER_SITE_ID NUMBER

Supplier Site Identifier
SUPPLIER_SITENAME VARCHAR2 (15)
Supplier sitename
CALCULATE_KANBAN_FLAG NUMBER

Flag to indicate whether Kanban size or Kanban number is calculated
NUMBER_OF_KANBANS NUMBER

Number of kanban cards
KANBAN_SIZE NUMBER

Kanban size
REPLENISHMENT_LEAD_TIME NUMBER

Replenishment lead time
FIXED_LOT_MULTIPLIER NUMBER

Fixed lot size multiplier
MINIMUM_ORDER_QUANTITY NUMBER

Minimum order quantity
UPDATED_FLAG NUMBER

Updated flag
RELEASE_KANBAN_FLAG NUMBER
Yes Whether Replenished by Kanban
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
PLANNER_CODE VARCHAR2 (10)
Identifies the Planner
CATEGORY_ID NUMBER

Category Id of Kanban Item
SAFETY_STOCK_DAYS NUMBER

PLANNING_UPDATE_STATUS NUMBER

Query Text

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


SELECT ROW_ID
,      ORGANIZATION_ID
,      KANBAN_PLAN_ID
,      KANBAN_DESIGNATOR
,      DESCRIPTION
,      PULL_SEQUENCE_ID
,      INVENTORY_ITEM_ID
,      ITEM
,      SUBINVENTORY_NAME
,      LOCATOR_ID
,      LOCATOR
,      SOURCE_TYPE
,      SOURCE_TYPE_NAME
,      SOURCE_ORGANIZATION_ID
,      SOURCE_ORGANIZATION
,      SOURCE_SUBINVENTORY
,      SOURCE_LOCATOR_ID
,      SOURCE_LOCATOR
,      LINE_ID
,      LINE
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITENAME
,      CALCULATE_KANBAN_FLAG
,      NUMBER_OF_KANBANS
,      KANBAN_SIZE
,      REPLENISHMENT_LEAD_TIME
,      FIXED_LOT_MULTIPLIER
,      MINIMUM_ORDER_QUANTITY
,      UPDATED_FLAG
,      RELEASE_KANBAN_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      PLANNER_CODE
,      CATEGORY_ID
,      SAFETY_STOCK_DAYS
,      PLANNING_UPDATE_STATUS
FROM APPS.MRP_KANBAN_DETAILS_V;

Dependencies

[top of page]

APPS.MRP_KANBAN_DETAILS_V references the following:

SchemaAPPS
PL/SQL PackageFLM_KANBAN_WORKBENCH_UTIL - show dependent code
ViewMFG_LOOKUPS
PL/SQL PackageMRP_GET_LOCATION - show dependent code
SynonymMRP_KANBAN_PLANS
SynonymMTL_KANBAN_PULL_SEQUENCES
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS_KFV
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
SynonymWIP_LINES

APPS.MRP_KANBAN_DETAILS_V is not referenced by any database object