View: MRP_KANBAN_DEMAND_V

Product:	MRP - Master Scheduling/MRP
Description:	Kanban demand view
Implementation/DBA Data:	APPS.MRP_KANBAN_DEMAND_V

View Text

SELECT DEM.ROWID
, DEM.DEMAND_ID
, DEM.KANBAN_PLAN_ID
, KAN.KANBAN_DESIGNATOR
, DEM.ORGANIZATION_ID
, ORG.ORGANIZATION_CODE
, DEM.INVENTORY_ITEM_ID
, ITEM.CONCATENATED_SEGMENTS
, DEM.SUBINVENTORY
, DEM.LOCATOR_ID
, MRP_GET_LOCATION.LOCATION(DEM.LOCATOR_ID
, DEM.ORGANIZATION_ID)
, DEM.ASSEMBLY_ITEM_ID
, ASSYITEM.CONCATENATED_SEGMENTS
, DEM.ASSEMBLY_ORG_ID
, ASSYORG.ORGANIZATION_CODE
, DEM.ASSEMBLY_SUBINVENTORY
, DEM.ASSEMBLY_LOCATOR_ID
, MRP_GET_LOCATION.LOCATION(DEM.ASSEMBLY_LOCATOR_ID
, DEM.ASSEMBLY_ORG_ID)
, DEM.DEMAND_DATE
, DEM.DEMAND_QUANTITY
, DEM.ORDER_TYPE
, MFO.MEANING
, ITEM.PLANNER_CODE
, FLM_KANBAN_WORKBENCH_UTIL.GET_CATEGORY_ID(KAN.KANBAN_PLAN_ID
, ITEM.ORGANIZATION_ID
, ITEM.INVENTORY_ITEM_ID) COMPONENT_CATEGORY_ID
FROM MFG_LOOKUPS MFO
, MTL_PARAMETERS ORG
, MTL_PARAMETERS ASSYORG
, MTL_SYSTEM_ITEMS_KFV ASSYITEM
, MTL_SYSTEM_ITEMS_KFV ITEM
, MRP_KANBAN_PLANS KAN
, MRP_KANBAN_DEMAND DEM
WHERE MFO.LOOKUP_TYPE = DECODE(KAN.INPUT_TYPE
, 1
, 'MRP_FORECAST_ORIG'
, 2
, 'MRP_SCHEDULE_ORIG'
, 3
, 'MRP_SCHEDULE_ORIG'
, 'MRP_WIP_SCHEDULE_TYPE')
AND MFO.LOOKUP_CODE = DEM.ORDER_TYPE
AND ORG.ORGANIZATION_ID = DEM.ORGANIZATION_ID
AND ASSYORG.ORGANIZATION_ID(+) = DEM.ASSEMBLY_ORG_ID
AND ASSYITEM.ORGANIZATION_ID(+) = DEM.ASSEMBLY_ORG_ID
AND ASSYITEM.INVENTORY_ITEM_ID(+) = DEM.ASSEMBLY_ITEM_ID
AND ITEM.ORGANIZATION_ID = DEM.ORGANIZATION_ID
AND ITEM.INVENTORY_ITEM_ID = DEM.INVENTORY_ITEM_ID
AND KAN.KANBAN_PLAN_ID = DEM.KANBAN_PLAN_ID

Columns