VIEW: APPS.MRP_KANBAN_COMPARISON_V

Source

View Text - Preformatted

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 , PSFROM.PLANNING_UPDATE_STATUS , PSFROM.SOURCE_TYPE , PSFROM.SOURCE_ORGANIZATION_ID , PSFROM.SOURCE_SUBINVENTORY , PSFROM.SOURCE_LOCATOR_ID , PSFROM.WIP_LINE_ID , PSFROM.SUPPLIER_ID , PSFROM.SUPPLIER_SITE_ID , PSFROM.CALCULATE_KANBAN_FLAG , PSFROM.REPLENISHMENT_LEAD_TIME , PSFROM.RELEASE_KANBAN_FLAG , PSFROM.MINIMUM_ORDER_QUANTITY , PSFROM.FIXED_LOT_MULTIPLIER , PSFROM.SAFETY_STOCK_DAYS 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

View Text - HTML Formatted

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
, PSFROM.PLANNING_UPDATE_STATUS
, PSFROM.SOURCE_TYPE
, PSFROM.SOURCE_ORGANIZATION_ID
, PSFROM.SOURCE_SUBINVENTORY
, PSFROM.SOURCE_LOCATOR_ID
, PSFROM.WIP_LINE_ID
, PSFROM.SUPPLIER_ID
, PSFROM.SUPPLIER_SITE_ID
, PSFROM.CALCULATE_KANBAN_FLAG
, PSFROM.REPLENISHMENT_LEAD_TIME
, PSFROM.RELEASE_KANBAN_FLAG
, PSFROM.MINIMUM_ORDER_QUANTITY
, PSFROM.FIXED_LOT_MULTIPLIER
, PSFROM.SAFETY_STOCK_DAYS
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