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]

VIEW: APPS.MRP_KANBAN_COMPARISON_V

Object Details

Object Name:	MRP_KANBAN_COMPARISON_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MRP.MRP_KANBAN_COMPARISON_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_TO	NUMBER		Yes	Kanban plan identifier for the plan that is compared to
PLAN_NAME_TO	VARCHAR2	(80)		Kanban plan name for the plan that is compared to
PLAN_DESCRIPTION_TO	VARCHAR2	(80)		Kanban plan description for the plan that is compared to
INPUT_TYPE_TO	NUMBER			Input type for the plan that is compared to
INPUT_DESIGNATOR_TO	VARCHAR2	(10)		Input designator for the plan that is compared to
KANBAN_PLAN_ID_FROM	NUMBER		Yes	Kanban plan identifier for the compared plan
PLAN_NAME_FROM	VARCHAR2	(10)	Yes	Kanban plan name for the compared plan
PLAN_DESCRIPTION_FROM	VARCHAR2	(50)		Kanban plan description for the compared plan
INPUT_TYPE_FROM	NUMBER		Yes	Input type for the compared plan
INPUT_DESIGNATOR_FROM	VARCHAR2	(10)		Input designator for the compared plan
PULL_SEQUENCE_ID	NUMBER		Yes	Pull sequence identifier
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
ITEM	VARCHAR2	(40)		Item name
SUBINVENTORY	VARCHAR2	(10)	Yes	Subinventory name
LOCATOR_ID	NUMBER			Locator identifier
LOCATOR	VARCHAR2	(4000)		Locator name
SOURCE_TYPE	NUMBER		Yes	Source type
KANBAN_SIZE_TO	NUMBER			Kanban size for the plan that is compared to
NUMBER_OF_CARDS_TO	NUMBER			Number of kanban cards for the plan that is compared to
KANBAN_SIZE_FROM	NUMBER			Kanban size for the compared plan
NUMBER_OF_CARDS_FROM	NUMBER			Number of kanban cards for the compared plan
VARIANCE	NUMBER			Variance between the plans that are compared
PLANNER_CODE	VARCHAR2	(10)		Identifies the Planner
CATEGORY_ID	NUMBER			Category Id of Compared Item
PLANNING_UPDATE_STATUS	NUMBER			Planning Update Status
SOURCE_TYPE_FROM	NUMBER		Yes	Kanban source type for the compared plan
SOURCE_ORGANIZATION_ID_FROM	NUMBER			Source organization identifier for the compared plan
SOURCE_SUBINVENTORY_FROM	VARCHAR2	(10)		Source subinventory name for the compared plan
SOURCE_LOCATOR_ID_FROM	NUMBER			Source locator identifier for the compared plan
LINE_ID_FROM	NUMBER			WIP line identifier for the compared plan
SUPPLIER_ID_FROM	NUMBER			Supplier identifier for the compared plan
SUPPLIER_SITE_ID_FROM	NUMBER			Supplier site identifier for the compared plan
CALCULATE_KANBAN_FLAG_FROM	NUMBER			Flag indicating what to calculate for the compared plan
REPLENISHMENT_LEAD_TIME_FROM	NUMBER			Lead time to replenish kanban for the compared plan
RELEASE_KANBAN_FLAG_FROM	NUMBER		Yes	Flag to indicate that Kanban will execute or not for the compared plan
MINIMUM_ORDER_QUANTITY_FROM	NUMBER			Minimum order quantity for the compared plan
FIXED_LOT_MULTIPLIER_FROM	NUMBER			Fixed lot multiplier for the compared plan
SAFETY_STOCK_DAYS_FROM	NUMBER			Safety stock days for the compared plan

Query Text

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


SELECT ROW_ID
,      ORGANIZATION_ID
,      KANBAN_PLAN_ID_TO
,      PLAN_NAME_TO
,      PLAN_DESCRIPTION_TO
,      INPUT_TYPE_TO
,      INPUT_DESIGNATOR_TO
,      KANBAN_PLAN_ID_FROM
,      PLAN_NAME_FROM
,      PLAN_DESCRIPTION_FROM
,      INPUT_TYPE_FROM
,      INPUT_DESIGNATOR_FROM
,      PULL_SEQUENCE_ID
,      INVENTORY_ITEM_ID
,      ITEM
,      SUBINVENTORY
,      LOCATOR_ID
,      LOCATOR
,      SOURCE_TYPE
,      KANBAN_SIZE_TO
,      NUMBER_OF_CARDS_TO
,      KANBAN_SIZE_FROM
,      NUMBER_OF_CARDS_FROM
,      VARIANCE
,      PLANNER_CODE
,      CATEGORY_ID
,      PLANNING_UPDATE_STATUS
,      SOURCE_TYPE_FROM
,      SOURCE_ORGANIZATION_ID_FROM
,      SOURCE_SUBINVENTORY_FROM
,      SOURCE_LOCATOR_ID_FROM
,      LINE_ID_FROM
,      SUPPLIER_ID_FROM
,      SUPPLIER_SITE_ID_FROM
,      CALCULATE_KANBAN_FLAG_FROM
,      REPLENISHMENT_LEAD_TIME_FROM
,      RELEASE_KANBAN_FLAG_FROM
,      MINIMUM_ORDER_QUANTITY_FROM
,      FIXED_LOT_MULTIPLIER_FROM
,      SAFETY_STOCK_DAYS_FROM
FROM APPS.MRP_KANBAN_COMPARISON_V;

Dependencies

[top of page]

APPS.MRP_KANBAN_COMPARISON_V references the following:

APPS: FLM_KANBAN_WORKBENCH_UTIL - show dependent code; MFG_LOOKUPS; MRP_GET_LOCATION - show dependent code; MRP_KANBAN_PLANS; MTL_KANBAN_PULL_SEQUENCES; MTL_SYSTEM_ITEMS_KFV

APPS.MRP_KANBAN_COMPARISON_V is not referenced by any database object