eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: MRP.MRP_KANBAN_DEMAND

Object Details

Object Name:	MRP_KANBAN_DEMAND
Object Type:	TABLE
Owner:	MRP
FND Design Data:	MRP.MRP_KANBAN_DEMAND
Subobject Name:
Status:	VALID

MRP_KANBAN_DEMAND stores demand information for items included in a
Kanban plan.
INVENTORY_ITEM_ID is the item for which there is demand.
SUBINVENTORY and LOCATOR_ID represent the location against
which the demand is applied. ASSEMBLY_ITEM_ID is the demanding
item and ASSEMBLY_SUBINVENTORY and ASSEMBLY_LOCATOR_ID
represent the location of the demanding item.
ORDER_TYPE indicates the type of demand, whether it is manual
or exploded, etc.
This table is populated by the Kanban planning engine as a part of
the Kanban planning process.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MRP_KANBAN_DEMAND_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DEMAND_ID
MRP_KANBAN_DEMAND_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	KANBAN_PLAN_ID KANBAN_ITEM_FLAG INVENTORY_ITEM_ID SUBINVENTORY LOCATOR_ID
MRP_KANBAN_DEMAND_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	KANBAN_PLAN_ID KANBAN_ITEM_FLAG ORDER_TYPE
MRP_KANBAN_DEMAND_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID KANBAN_PLAN_ID SUBINVENTORY

Columns

Name	Datatype	Length	Mandatory	Comments
DEMAND_ID	NUMBER		Yes	Demand record identifier
KANBAN_PLAN_ID	NUMBER		Yes	Kanban plan identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
INVENTORY_ITEM_ID	NUMBER		Yes	Demanded item identifier
SUBINVENTORY	VARCHAR2	(10)		Subinventory of demanded item
LOCATOR_ID	NUMBER			Locator identifier of demanded item
ASSEMBLY_ITEM_ID	NUMBER			Demanding item identifier
ASSEMBLY_ORG_ID	NUMBER			Organization of demanding item
ASSEMBLY_SUBINVENTORY	VARCHAR2	(10)		Subinventory of demanding item
ASSEMBLY_LOCATOR_ID	NUMBER			Locator identifier of demanding item
DEMAND_DATE	DATE			Demand date
DEMAND_QUANTITY	NUMBER			Demanded quantity
ORDER_TYPE	NUMBER			Demand type identifier
KANBAN_ITEM_FLAG	VARCHAR2	(1)		Flag to indicate if this item is replenished using Kanbans
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATED_LOGIN	NUMBER			Standard Who column
REQUEST_ID	NUMBER			Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who column
PROGRAM_ID	NUMBER			Concurrent Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who column

Query Text

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


SELECT DEMAND_ID
,      KANBAN_PLAN_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      SUBINVENTORY
,      LOCATOR_ID
,      ASSEMBLY_ITEM_ID
,      ASSEMBLY_ORG_ID
,      ASSEMBLY_SUBINVENTORY
,      ASSEMBLY_LOCATOR_ID
,      DEMAND_DATE
,      DEMAND_QUANTITY
,      ORDER_TYPE
,      KANBAN_ITEM_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM MRP.MRP_KANBAN_DEMAND;

Dependencies

[top of page]

MRP.MRP_KANBAN_DEMAND does not reference any database object

MRP.MRP_KANBAN_DEMAND is referenced by following:

APPS: MRP_KANBAN_DEMAND