VIEW: APPS.INVBV_KANBAN_CARDS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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