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