VIEW: APPS.INVBV_KANBAN_CARD_ACTIVITIES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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