Product: | INV - Inventory |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.INVBV_KANBAN_LOCATION_ITEMS |
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