View: MRP_KANBAN_COMPARISON_V

Product:	MRP - Master Scheduling/MRP
Description:	Kanban comparison view
Implementation/DBA Data:	APPS.MRP_KANBAN_COMPARISON_V

View Text

SELECT PSFROM.ROWID
, PSTO.ORGANIZATION_ID
, PSTO.KANBAN_PLAN_ID
, DECODE(PSTO.KANBAN_PLAN_ID
, -1
, MKP.MEANING
, KANTO.KANBAN_DESIGNATOR)
, DECODE(PSTO.KANBAN_PLAN_ID
, -1
, MKP.MEANING
, KANTO.DESCRIPTION)
, KANTO.INPUT_TYPE
, KANTO.INPUT_DESIGNATOR
, KANFROM.KANBAN_PLAN_ID
, KANFROM.KANBAN_DESIGNATOR
, KANFROM.DESCRIPTION
, KANFROM.INPUT_TYPE
, KANFROM.INPUT_DESIGNATOR
, PSFROM.PULL_SEQUENCE_ID
, PSTO.INVENTORY_ITEM_ID
, ITEM.CONCATENATED_SEGMENTS
, PSTO.SUBINVENTORY_NAME
, PSTO.LOCATOR_ID
, MRP_GET_LOCATION.LOCATION(PSTO.LOCATOR_ID
, PSTO.ORGANIZATION_ID)
, PSTO.SOURCE_TYPE
, PSTO.KANBAN_SIZE
, PSTO.NUMBER_OF_CARDS
, PSFROM.KANBAN_SIZE
, PSFROM.NUMBER_OF_CARDS
, ROUND(DECODE(PSTO.KANBAN_SIZE * PSTO.NUMBER_OF_CARDS
, 0
, 0
, ((NVL(PSFROM.NUMBER_OF_CARDS
, 0)* NVL(PSFROM.KANBAN_SIZE
, 0) - (NVL(PSTO.NUMBER_OF_CARDS
, 0)*NVL(PSTO.KANBAN_SIZE
, 0)))/ (PSTO.KANBAN_SIZE*PSTO.NUMBER_OF_CARDS))*100)
, 2)
, ITEM.PLANNER_CODE
, FLM_KANBAN_WORKBENCH_UTIL.GET_CATEGORY_ID( KANFROM.KANBAN_PLAN_ID
, PSFROM.ORGANIZATION_ID
, PSFROM.INVENTORY_ITEM_ID) COMPONENT_CATEGORY_ID
FROM MFG_LOOKUPS MKP
, MTL_SYSTEM_ITEMS_KFV ITEM
, MRP_KANBAN_PLANS KANTO
, MTL_KANBAN_PULL_SEQUENCES PSFROM
, MRP_KANBAN_PLANS KANFROM
, MTL_KANBAN_PULL_SEQUENCES PSTO
WHERE MKP.LOOKUP_TYPE = 'MRP_KANBAN_PRODUCTION_NAME'
AND MKP.LOOKUP_CODE = -1
AND ITEM.ORGANIZATION_ID = PSTO.ORGANIZATION_ID
AND ITEM.INVENTORY_ITEM_ID = PSTO.INVENTORY_ITEM_ID
AND NVL(PSFROM.LOCATOR_ID
, 1) = NVL(PSTO.LOCATOR_ID
, 1)
AND PSFROM.SUBINVENTORY_NAME = PSTO.SUBINVENTORY_NAME
AND PSFROM.INVENTORY_ITEM_ID = PSTO.INVENTORY_ITEM_ID
AND KANTO.KANBAN_PLAN_ID (+) = PSTO.KANBAN_PLAN_ID
AND PSFROM.KANBAN_PLAN_ID = KANFROM.KANBAN_PLAN_ID
AND KANFROM.ORGANIZATION_ID = PSTO.ORGANIZATION_ID

Columns