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: ViewMRP.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:

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_SYSTEM_ITEMS_KFV

APPS.MRP_KANBAN_COMPARISON_V is not referenced by any database object