View: INVFV_KANBAN_LOCATION_ITEMS

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.INVFV_KANBAN_LOCATION_ITEMS

View Text

SELECT MKP.PULL_SEQUENCE_ID
, MKP.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI'
, /* KEYFLEX */ MKP.ORGANIZATION_ID
, MP1.ORGANIZATION_CODE
, HOU1.NAME
, MKP.SUBINVENTORY_NAME
, '_LA:MKP.SOURCE_TYPE:MFG_LOOKUPS:MTL_KANBAN_SOURCE_TYPE:MEANING'
, /* LOOKUP */ MKP.LOCATOR_ID
, '_KF:INV:MTLL:MIL1'
, /* KEYFLEX */ MKP.SUPPLIER_ID
, NULL SUPPLIER_NAME
, MKP.SUPPLIER_SITE_ID
, NULL SUPPLIER_SITE_CODE
, MKP.SOURCE_ORGANIZATION_ID
, MP2.ORGANIZATION_CODE
, HOU2.NAME
, MKP.SOURCE_SUBINVENTORY
, MKP.SOURCE_LOCATOR_ID
, '_KF:INV:MTLL:MIL2'
, /* KEYFLEX */ MKP.WIP_LINE_ID
, NULL WIP_LINE_CODE
, MKP.REPLENISHMENT_LEAD_TIME
, '_LA:MKP.CALCULATE_KANBAN_FLAG:MFG_LOOKUPS:MTL_CALCULATE_KANBAN_FLAG:MEANING'
, /* LOOKUP */ MKP.KANBAN_SIZE
, MKP.FIXED_LOT_MULTIPLIER
, MKP.SAFETY_STOCK_DAYS
, MKP.NUMBER_OF_CARDS
, MKP.MINIMUM_ORDER_QUANTITY
, MKP.ALLOCATION_PERCENT
, MKP.CREATED_BY
, MKP.CREATION_DATE
, MKP.LAST_UPDATED_BY
, MKP.LAST_UPDATE_DATE
FROM MTL_ITEM_LOCATIONS MIL1
, MTL_ITEM_LOCATIONS MIL2
, HR_ALL_ORGANIZATION_UNITS HOU1
, HR_ALL_ORGANIZATION_UNITS HOU2
, MTL_PARAMETERS MP1
, MTL_PARAMETERS MP2
, MTL_SYSTEM_ITEMS MSI
, MTL_KANBAN_PULL_SEQUENCES MKP WHERE MKP.SOURCE_TYPE IN (1
, 3) AND MKP.KANBAN_PLAN_ID = -1 AND MP1.ORGANIZATION_ID = MKP.ORGANIZATION_ID AND MP2.ORGANIZATION_ID (+) = MKP.SOURCE_ORGANIZATION_ID AND HOU1.ORGANIZATION_ID = MKP.ORGANIZATION_ID AND HOU2.ORGANIZATION_ID (+) = MKP.SOURCE_ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID = MKP.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = MKP.ORGANIZATION_ID AND MIL1.INVENTORY_LOCATION_ID (+) = MKP.LOCATOR_ID AND MIL1.ORGANIZATION_ID (+) = MKP.ORGANIZATION_ID AND MIL2.INVENTORY_LOCATION_ID (+) = MKP.SOURCE_LOCATOR_ID AND MIL2.ORGANIZATION_ID (+) = MKP.SOURCE_ORGANIZATION_ID
AND '_SEC:MKP.ORGANIZATION_ID' IS NOT NULL UNION SELECT MKP.PULL_SEQUENCE_ID
, MKP.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI'
, /* KEYFLEX */ MKP.ORGANIZATION_ID
, MP1.ORGANIZATION_CODE
, HOU1.NAME
, MKP.SUBINVENTORY_NAME
, '_LA:MKP.SOURCE_TYPE:MFG_LOOKUPS:MTL_KANBAN_SOURCE_TYPE:MEANING'
, /* LOOKUP */ MKP.LOCATOR_ID
, '_KF:INV:MTLL:MIL1'
, /* KEYFLEX */ MKP.SUPPLIER_ID
, POV.VENDOR_NAME SUPPLIER_NAME
, MKP.SUPPLIER_SITE_ID
, POS.VENDOR_SITE_CODE
, MKP.SOURCE_ORGANIZATION_ID
, NULL SOURCE_ORGANIZATION_CODE
, NULL SOURCE_ORGANIZATION_NAME
, MKP.SOURCE_SUBINVENTORY
, MKP.SOURCE_LOCATOR_ID
, '_KF:_EX:TO_CHAR(NULL)'
, /* KEYFLEX */ MKP.WIP_LINE_ID
, NULL WIP_LINE_CODE
, MKP.REPLENISHMENT_LEAD_TIME
, '_LA:MKP.CALCULATE_KANBAN_FLAG:MFG_LOOKUPS:MTL_CALCULATE_KANBAN_FLAG:MEANING'
, /* LOOKUP */ MKP.KANBAN_SIZE
, MKP.FIXED_LOT_MULTIPLIER
, MKP.SAFETY_STOCK_DAYS
, MKP.NUMBER_OF_CARDS
, MKP.MINIMUM_ORDER_QUANTITY
, MKP.ALLOCATION_PERCENT
, MKP.CREATED_BY
, MKP.CREATION_DATE
, MKP.LAST_UPDATED_BY
, MKP.LAST_UPDATE_DATE
FROM MTL_ITEM_LOCATIONS MIL1
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL POS
, HR_ALL_ORGANIZATION_UNITS HOU1
, MTL_PARAMETERS MP1
, MTL_SYSTEM_ITEMS MSI
, MTL_KANBAN_PULL_SEQUENCES MKP WHERE MKP.SOURCE_TYPE = 2 AND MKP.KANBAN_PLAN_ID = -1 AND MP1.ORGANIZATION_ID = MKP.ORGANIZATION_ID AND HOU1.ORGANIZATION_ID = MKP.ORGANIZATION_ID AND POV.VENDOR_ID (+) = MKP.SUPPLIER_ID AND POS.VENDOR_SITE_ID (+) = MKP.SUPPLIER_SITE_ID AND MSI.INVENTORY_ITEM_ID = MKP.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = MKP.ORGANIZATION_ID AND MIL1.INVENTORY_LOCATION_ID (+) = MKP.LOCATOR_ID AND MIL1.ORGANIZATION_ID (+) = MKP.ORGANIZATION_ID
AND '_SEC:MKP.ORGANIZATION_ID' IS NOT NULL UNION SELECT MKP.PULL_SEQUENCE_ID
, MKP.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI'
, /* KEYFLEX */ MKP.ORGANIZATION_ID
, MP1.ORGANIZATION_CODE
, HOU1.NAME
, MKP.SUBINVENTORY_NAME
, '_LA:MKP.SOURCE_TYPE:MFG_LOOKUPS:MTL_KANBAN_SOURCE_TYPE:MEANING'
, /* LOOKUP */ MKP.LOCATOR_ID
, '_KF:INV:MTLL:MIL1'
, /* KEYFLEX */ MKP.SUPPLIER_ID
, NULL SUPPLIER_NAME
, MKP.SUPPLIER_SITE_ID
, NULL SUPPLIER_SITE_CODE
, MKP.SOURCE_ORGANIZATION_ID
, NULL SOURCE_ORGANIZATION_CODE
, NULL SOURCE_ORGANIZATION_NAME
, MKP.SOURCE_SUBINVENTORY
, MKP.SOURCE_LOCATOR_ID
, '_KF:_EX:TO_CHAR(NULL)'
, /* KEYFLEX */ MKP.WIP_LINE_ID
, WIP.LINE_CODE WIP_LINE_CODE
, MKP.REPLENISHMENT_LEAD_TIME
, '_LA:MKP.CALCULATE_KANBAN_FLAG:MFG_LOOKUPS:MTL_CALCULATE_KANBAN_FLAG:MEANING'
, /* LOOKUP */ MKP.KANBAN_SIZE
, MKP.FIXED_LOT_MULTIPLIER
, MKP.SAFETY_STOCK_DAYS
, MKP.NUMBER_OF_CARDS
, MKP.MINIMUM_ORDER_QUANTITY
, MKP.ALLOCATION_PERCENT
, MKP.CREATED_BY
, MKP.CREATION_DATE
, MKP.LAST_UPDATED_BY
, MKP.LAST_UPDATE_DATE
FROM MTL_ITEM_LOCATIONS MIL1
, WIP_LINES WIP
, HR_ALL_ORGANIZATION_UNITS HOU1
, MTL_PARAMETERS MP1
, MTL_SYSTEM_ITEMS MSI
, MTL_KANBAN_PULL_SEQUENCES MKP WHERE MKP.SOURCE_TYPE = 4 AND MKP.KANBAN_PLAN_ID = -1 AND MP1.ORGANIZATION_ID = MKP.ORGANIZATION_ID AND HOU1.ORGANIZATION_ID = MKP.ORGANIZATION_ID AND WIP.LINE_ID = MKP.WIP_LINE_ID AND WIP.ORGANIZATION_ID = MKP.ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID = MKP.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = MKP.ORGANIZATION_ID AND MIL1.INVENTORY_LOCATION_ID (+) = MKP.LOCATOR_ID AND MIL1.ORGANIZATION_ID (+) = MKP.ORGANIZATION_ID AND '_SEC:MKP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns