VIEW: APPS.INVBV_KANBAN_LOCATION_ITEMS

Source

View Text - Preformatted

SELECT MKP.PULL_SEQUENCE_ID, MKP.INVENTORY_ITEM_ID, MKP.ORGANIZATION_ID, MKP.SUBINVENTORY_NAME, '_LA:MKP.SOURCE_TYPE:MFG_LOOKUPS:MTL_KANBAN_SOURCE_TYPE:MEANING', /* LOOKUP */ MKP.LOCATOR_ID, MKP.SUPPLIER_ID, MKP.SUPPLIER_SITE_ID, MKP.SOURCE_ORGANIZATION_ID, MKP.SOURCE_SUBINVENTORY, MKP.SOURCE_LOCATOR_ID, MKP.WIP_LINE_ID, 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_KANBAN_PULL_SEQUENCES MKP WHERE MKP.KANBAN_PLAN_ID = -1 AND '_SEC:MKP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT MKP.PULL_SEQUENCE_ID
, MKP.INVENTORY_ITEM_ID
, MKP.ORGANIZATION_ID
, MKP.SUBINVENTORY_NAME
, '_LA:MKP.SOURCE_TYPE:MFG_LOOKUPS:MTL_KANBAN_SOURCE_TYPE:MEANING'
, /* LOOKUP */ MKP.LOCATOR_ID
, MKP.SUPPLIER_ID
, MKP.SUPPLIER_SITE_ID
, MKP.SOURCE_ORGANIZATION_ID
, MKP.SOURCE_SUBINVENTORY
, MKP.SOURCE_LOCATOR_ID
, MKP.WIP_LINE_ID
, 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_KANBAN_PULL_SEQUENCES MKP
WHERE MKP.KANBAN_PLAN_ID = -1
AND '_SEC:MKP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY