eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.INVFV_KANBAN_LOCATION_ITEMS

Source

View Text - Preformatted


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

View Text - HTML Formatted

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