VIEW: APPS.MTL_KANBAN_CARD_ACTIVITY_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'