VIEW: APPS.MRP_KANBAN_DETAILS_V

Source

View Text - Preformatted

SELECT PS.ROWID , PS.ORGANIZATION_ID , PS.KANBAN_PLAN_ID , KAN.KANBAN_DESIGNATOR , KAN.DESCRIPTION , PS.PULL_SEQUENCE_ID , PS.INVENTORY_ITEM_ID , ITEM.CONCATENATED_SEGMENTS , PS.SUBINVENTORY_NAME , PS.LOCATOR_ID , MRP_GET_LOCATION.LOCATION(PS.LOCATOR_ID, PS.ORGANIZATION_ID) , PS.SOURCE_TYPE , KST.MEANING , PS.SOURCE_ORGANIZATION_ID , MP.ORGANIZATION_CODE , PS.SOURCE_SUBINVENTORY , PS.SOURCE_LOCATOR_ID , MRP_GET_LOCATION.LOCATION(PS.SOURCE_LOCATOR_ID, PS.SOURCE_ORGANIZATION_ID) , PS.WIP_LINE_ID , WL.LINE_CODE , PS.SUPPLIER_ID , PV.VENDOR_NAME , PS.SUPPLIER_SITE_ID , PVS.VENDOR_SITE_CODE , PS.CALCULATE_KANBAN_FLAG , PS.NUMBER_OF_CARDS , PS.KANBAN_SIZE , PS.REPLENISHMENT_LEAD_TIME , PS.FIXED_LOT_MULTIPLIER , PS.MINIMUM_ORDER_QUANTITY , PS.UPDATED_FLAG , PS.RELEASE_KANBAN_FLAG , PS.LAST_UPDATE_DATE , PS.LAST_UPDATED_BY , PS.LAST_UPDATE_LOGIN , PS.CREATION_DATE , PS.CREATED_BY , ITEM.PLANNER_CODE ,FLM_KANBAN_WORKBENCH_UTIL.Get_Category_Id(KAN.KANBAN_PLAN_ID, ITEM.ORGANIZATION_ID, ITEM.INVENTORY_ITEM_ID) COMPONENT_CATEGORY_ID ,PS.SAFETY_STOCK_DAYS ,PS.PLANNING_UPDATE_STATUS FROM MFG_LOOKUPS KST, MTL_PARAMETERS MP, PO_VENDORS PV, PO_VENDOR_SITES_ALL PVS, WIP_LINES WL, MTL_SYSTEM_ITEMS_KFV ITEM, MRP_KANBAN_PLANS KAN, MTL_KANBAN_PULL_SEQUENCES PS WHERE KST.LOOKUP_TYPE = 'MTL_KANBAN_SOURCE_TYPE' AND KST.LOOKUP_CODE = PS.SOURCE_TYPE AND MP.ORGANIZATION_ID (+) = PS.SOURCE_ORGANIZATION_ID AND PV.VENDOR_ID (+) = PS.SUPPLIER_ID AND PVS.VENDOR_SITE_ID (+) = PS.SUPPLIER_SITE_ID AND WL.ORGANIZATION_ID (+) = PS.ORGANIZATION_ID AND WL.LINE_ID (+) = PS.WIP_LINE_ID AND ITEM.ORGANIZATION_ID = PS.ORGANIZATION_ID AND ITEM.INVENTORY_ITEM_ID = PS.INVENTORY_ITEM_ID AND PS.KANBAN_PLAN_ID = KAN.KANBAN_PLAN_ID

View Text - HTML Formatted

SELECT PS.ROWID
, PS.ORGANIZATION_ID
, PS.KANBAN_PLAN_ID
, KAN.KANBAN_DESIGNATOR
, KAN.DESCRIPTION
, PS.PULL_SEQUENCE_ID
, PS.INVENTORY_ITEM_ID
, ITEM.CONCATENATED_SEGMENTS
, PS.SUBINVENTORY_NAME
, PS.LOCATOR_ID
, MRP_GET_LOCATION.LOCATION(PS.LOCATOR_ID
, PS.ORGANIZATION_ID)
, PS.SOURCE_TYPE
, KST.MEANING
, PS.SOURCE_ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, PS.SOURCE_SUBINVENTORY
, PS.SOURCE_LOCATOR_ID
, MRP_GET_LOCATION.LOCATION(PS.SOURCE_LOCATOR_ID
, PS.SOURCE_ORGANIZATION_ID)
, PS.WIP_LINE_ID
, WL.LINE_CODE
, PS.SUPPLIER_ID
, PV.VENDOR_NAME
, PS.SUPPLIER_SITE_ID
, PVS.VENDOR_SITE_CODE
, PS.CALCULATE_KANBAN_FLAG
, PS.NUMBER_OF_CARDS
, PS.KANBAN_SIZE
, PS.REPLENISHMENT_LEAD_TIME
, PS.FIXED_LOT_MULTIPLIER
, PS.MINIMUM_ORDER_QUANTITY
, PS.UPDATED_FLAG
, PS.RELEASE_KANBAN_FLAG
, PS.LAST_UPDATE_DATE
, PS.LAST_UPDATED_BY
, PS.LAST_UPDATE_LOGIN
, PS.CREATION_DATE
, PS.CREATED_BY
, ITEM.PLANNER_CODE
, FLM_KANBAN_WORKBENCH_UTIL.GET_CATEGORY_ID(KAN.KANBAN_PLAN_ID
, ITEM.ORGANIZATION_ID
, ITEM.INVENTORY_ITEM_ID) COMPONENT_CATEGORY_ID
, PS.SAFETY_STOCK_DAYS
, PS.PLANNING_UPDATE_STATUS
FROM MFG_LOOKUPS KST
, MTL_PARAMETERS MP
, PO_VENDORS PV
, PO_VENDOR_SITES_ALL PVS
, WIP_LINES WL
, MTL_SYSTEM_ITEMS_KFV ITEM
, MRP_KANBAN_PLANS KAN
, MTL_KANBAN_PULL_SEQUENCES PS
WHERE KST.LOOKUP_TYPE = 'MTL_KANBAN_SOURCE_TYPE'
AND KST.LOOKUP_CODE = PS.SOURCE_TYPE
AND MP.ORGANIZATION_ID (+) = PS.SOURCE_ORGANIZATION_ID
AND PV.VENDOR_ID (+) = PS.SUPPLIER_ID
AND PVS.VENDOR_SITE_ID (+) = PS.SUPPLIER_SITE_ID
AND WL.ORGANIZATION_ID (+) = PS.ORGANIZATION_ID
AND WL.LINE_ID (+) = PS.WIP_LINE_ID
AND ITEM.ORGANIZATION_ID = PS.ORGANIZATION_ID
AND ITEM.INVENTORY_ITEM_ID = PS.INVENTORY_ITEM_ID
AND PS.KANBAN_PLAN_ID = KAN.KANBAN_PLAN_ID