Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | Kanban details view |
Implementation/DBA Data: | APPS.MRP_KANBAN_DETAILS_V |
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
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