VIEW: APPS.MRP_KANBAN_DEMAND_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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