View: MTL_KANBAN_CARD_ACTIVITY_V

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.MTL_KANBAN_CARD_ACTIVITY_V

View Text

SELECT MKA.KANBAN_ACTIVITY_ID
, DECODE(MKA.REPLENISHMENT_CYCLE_ID
, -1
, NULL
, REPLENISHMENT_CYCLE_ID) REPLENISHMENT_CYCLE_ID
, MKA.KANBAN_CARD_ID
, MKA.KANBAN_CARD_NUMBER
, MKA.INVENTORY_ITEM_ID
, MKA.ORGANIZATION_ID
, MKA.SUBINVENTORY_NAME
, MKA.SUPPLY_STATUS
, MLK3.MEANING SUPPLY_STATUS_NAME
, MKA.CARD_STATUS
, MLK2.MEANING CARD_STATUS_NAME
, MKA.KANBAN_CARD_TYPE
, MKA.SOURCE_TYPE
, MKA.LAST_UPDATE_DATE
, MKA.LAST_UPDATED_BY
, MKA.CREATION_DATE
, MKA.CREATED_BY
, MKA.LOCATOR_ID
, MKA.SUPPLIER_ID
, MKA.SUPPLIER_SITE_ID
, MKA.SOURCE_ORGANIZATION_ID
, MKA.SOURCE_SUBINVENTORY
, MKA.SOURCE_LOCATOR_ID
, MKA.WIP_LINE_ID
, MKA.KANBAN_SIZE
, MKA.DOCUMENT_TYPE
, MKA.DOCUMENT_HEADER_ID
, MKA.DOCUMENT_DETAIL_ID
, MKA.ERROR_CODE
, MKA.LAST_UPDATE_LOGIN
, MKA.LAST_PRINT_DATE
, MKA.ATTRIBUTE_CATEGORY
, MKA.ATTRIBUTE1
, MKA.ATTRIBUTE2
, MKA.ATTRIBUTE3
, MKA.ATTRIBUTE4
, MKA.ATTRIBUTE5
, MKA.ATTRIBUTE6
, MKA.ATTRIBUTE7
, MKA.ATTRIBUTE8
, MKA.ATTRIBUTE9
, MKA.ATTRIBUTE10
, MKA.ATTRIBUTE11
, MKA.ATTRIBUTE12
, MKA.ATTRIBUTE13
, MKA.ATTRIBUTE14
, MKA.ATTRIBUTE15
, MKA.REQUEST_ID
, MKA.PROGRAM_APPLICATION_ID
, MKA.PROGRAM_ID
, MKA.PROGRAM_UPDATE_DATE
, MKA.SOURCE_WIP_ENTITY_ID
FROM MTL_KANBAN_CARD_ACTIVITY MKA
, MFG_LOOKUPS MLK3
, MFG_LOOKUPS MLK2
WHERE MLK3.LOOKUP_CODE = MKA.SUPPLY_STATUS
AND MLK3.LOOKUP_TYPE = 'MTL_KANBAN_SUPPLY_STATUS'
AND MLK2.LOOKUP_CODE = MKA.CARD_STATUS
AND MLK2.LOOKUP_TYPE = 'MTL_KANBAN_CARD_STATUS'

Columns