Product: | INV - Inventory |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.INVBV_KANBAN_CARDS |
SELECT MKC.KANBAN_CARD_ID
, MKC.KANBAN_CARD_NUMBER
, MKC.PULL_SEQUENCE_ID
, MKC.INVENTORY_ITEM_ID
, MKC.ORGANIZATION_ID
, MKC.SUBINVENTORY_NAME
, '_LA:MKC.SUPPLY_STATUS:MFG_LOOKUPS:MTL_KANBAN_SUPPLY_STATUS:MEANING'
, /* LOOKUP */ '_LA:MKC.CARD_STATUS:MFG_LOOKUPS:MTL_KANBAN_CARD_STATUS:MEANING'
, /* LOOKUP */ '_LA:MKC.KANBAN_CARD_TYPE:MFG_LOOKUPS:MTL_KANBAN_CARD_TYPE:MEANING'
, /* LOOKUP */ '_LA:MKC.SOURCE_TYPE:MFG_LOOKUPS:MTL_KANBAN_SOURCE_TYPE:MEANING'
, /* LOOKUP */ MKC.KANBAN_SIZE
, MKC.LOCATOR_ID
, MKC.SUPPLIER_ID
, MKC.SUPPLIER_SITE_ID
, MKC.SOURCE_ORGANIZATION_ID
, MKC.SOURCE_SUBINVENTORY
, MKC.SOURCE_LOCATOR_ID
, '_LA:MKC.ERROR_CODE:MFG_LOOKUPS:MTL_KANBAN_ERROR_CODE:MEANING'
, /* LOOKUP */ MKC.LAST_PRINT_DATE
, MKC.CREATED_BY
, MKC.CREATION_DATE
, MKC.LAST_UPDATED_BY
, MKC.LAST_UPDATE_DATE
, MKC.WIP_LINE_ID
FROM MTL_KANBAN_CARDS MKC
WHERE '_SEC:MKC.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY