View: MTL_KANBAN_CARDS_V

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

View Text

SELECT MKC.KANBAN_CARD_ID
, MKC.KANBAN_CARD_NUMBER
, MKC.PULL_SEQUENCE_ID
, MKC.INVENTORY_ITEM_ID
, MKC.ORGANIZATION_ID
, MKC.SUBINVENTORY_NAME
, MSS.LOCATOR_TYPE SUB_LOCATOR_TYPE
, MKC.SUPPLY_STATUS
, MLK3.MEANING SUPPLY_STATUS_NAME
, MKC.CARD_STATUS
, MLK2.MEANING CARD_STATUS_NAME
, MKC.KANBAN_CARD_TYPE
, MKC.SOURCE_TYPE
, MLK1.MEANING SOURCE_TYPE_MEANING
, MKC.LAST_UPDATE_DATE
, MKC.LAST_UPDATED_BY
, MKC.CREATION_DATE
, MKC.CREATED_BY
, MKC.LOCATOR_ID
, MKC.SUPPLIER_ID
, NULL SUPPLIER_NAME
, MKC.SUPPLIER_SITE_ID
, MKC.SOURCE_ORGANIZATION_ID
, TO_CHAR(MSI.LOCATION_CONTROL_CODE) SOURCE_LOCATION_CONTROL_CODE
, TO_CHAR(MSI.RESTRICT_SUBINVENTORIES_CODE) SOURCE_ORG_RESTRICT_SUB
, TO_CHAR(MSI.RESTRICT_LOCATORS_CODE) SOURCE_ORG_RESTRICT_LOC
, TO_CHAR(MTP.STOCK_LOCATOR_CONTROL_CODE) SOURCE_ORG_LOCATOR_CONTROL
, TO_CHAR(MTP.NEGATIVE_INV_RECEIPT_CODE) SOURCE_ORG_NEGATIVE_CONTROL
, MTP.ORGANIZATION_CODE SOURCE_ORG_CODE
, HOU.NAME SOURCE_ORG_NAME
, MKC.SOURCE_SUBINVENTORY
, TO_CHAR(MSS2.LOCATOR_TYPE) SOURCE_SUB_LOCATOR_TYPE
, MKC.SOURCE_LOCATOR_ID
, MKC.WIP_LINE_ID
, NULL WIP_LINE_CODE
, MKC.KANBAN_SIZE
, MKC.CURRENT_REPLNSH_CYCLE_ID
, MKC.ERROR_CODE
, MKC.LAST_UPDATE_LOGIN
, MKC.LAST_PRINT_DATE
, MKC.ATTRIBUTE_CATEGORY
, MKC.ATTRIBUTE1
, MKC.ATTRIBUTE2
, MKC.ATTRIBUTE3
, MKC.ATTRIBUTE4
, MKC.ATTRIBUTE5
, MKC.ATTRIBUTE6
, MKC.ATTRIBUTE7
, MKC.ATTRIBUTE8
, MKC.ATTRIBUTE9
, MKC.ATTRIBUTE10
, MKC.ATTRIBUTE11
, MKC.ATTRIBUTE12
, MKC.ATTRIBUTE13
, MKC.ATTRIBUTE14
, MKC.ATTRIBUTE15
, MKC.REQUEST_ID
, MKC.PROGRAM_APPLICATION_ID
, MKC.PROGRAM_ID
, MKC.PROGRAM_UPDATE_DATE
, MKC.MAX_REPLENISHMENTS
, MKC.REPLENISHMENT_COUNT
, MKC.DISABLE_DATE
FROM MTL_SYSTEM_ITEMS MSI
, MTL_SECONDARY_INVENTORIES MSS2
, HR_ORGANIZATION_UNITS HOU
, MTL_PARAMETERS MTP
, MTL_SECONDARY_INVENTORIES MSS
, MFG_LOOKUPS MLK3
, MFG_LOOKUPS MLK2
, MFG_LOOKUPS MLK1
, MTL_KANBAN_CARDS MKC
WHERE MLK3.LOOKUP_CODE = MKC.SUPPLY_STATUS
AND MLK3.LOOKUP_TYPE = 'MTL_KANBAN_SUPPLY_STATUS'
AND MLK2.LOOKUP_CODE = MKC.CARD_STATUS
AND MLK2.LOOKUP_TYPE = 'MTL_KANBAN_CARD_STATUS'
AND MLK1.LOOKUP_CODE IN (1
, 3)
AND MLK1.LOOKUP_TYPE = 'MTL_KANBAN_SOURCE_TYPE'
AND MTP.ORGANIZATION_ID = MKC.SOURCE_ORGANIZATION_ID
AND MKC.SOURCE_TYPE IN (1
, 3)
AND MKC.SOURCE_TYPE = MLK1.LOOKUP_CODE
AND MKC.SOURCE_ORGANIZATION_ID IS NOT NULL
AND MSS.SECONDARY_INVENTORY_NAME = MKC.SUBINVENTORY_NAME
AND MSS.ORGANIZATION_ID = MKC.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = MKC.SOURCE_ORGANIZATION_ID
AND MSS2.SECONDARY_INVENTORY_NAME = MKC.SOURCE_SUBINVENTORY
AND MSS2.ORGANIZATION_ID = MKC.SOURCE_ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = MKC.SOURCE_ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MKC.INVENTORY_ITEM_ID
AND (MSS.SUBINVENTORY_TYPE = 1 OR MSS.SUBINVENTORY_TYPE IS NULL) UNION ALL SELECT MKC.KANBAN_CARD_ID
, MKC.KANBAN_CARD_NUMBER
, MKC.PULL_SEQUENCE_ID
, MKC.INVENTORY_ITEM_ID
, MKC.ORGANIZATION_ID
, MKC.SUBINVENTORY_NAME
, MSS.LOCATOR_TYPE SUB_LOCATOR_TYPE
, MKC.SUPPLY_STATUS
, MLK3.MEANING SUPPLY_STATUS_NAME
, MKC.CARD_STATUS
, MLK2.MEANING CARD_STATUS_NAME
, MKC.KANBAN_CARD_TYPE
, MKC.SOURCE_TYPE
, MLK1.MEANING SOURCE_TYPE_MEANING
, MKC.LAST_UPDATE_DATE
, MKC.LAST_UPDATED_BY
, MKC.CREATION_DATE
, MKC.CREATED_BY
, MKC.LOCATOR_ID
, MKC.SUPPLIER_ID
, NULL SUPPLIER_NAME
, MKC.SUPPLIER_SITE_ID
, MKC.SOURCE_ORGANIZATION_ID
, NULL SOURCE_LOCATION_CONTROL_CODE
, NULL SOURCE_ORG_RESTRICT_SUB
, NULL SOURCE_ORG_RESTRICT_LOC
, NULL SOURCE_ORG_LOCATOR_CONTROL
, NULL SOURCE_ORG_NEGATIVE_CONTROL
, NULL SOURCE_ORG_CODE
, NULL SOURCE_ORG_NAME
, MKC.SOURCE_SUBINVENTORY
, NULL SOURCE_SUB_LOCATOR_TYPE
, MKC.SOURCE_LOCATOR_ID
, MKC.WIP_LINE_ID
, NULL WIP_LINE_CODE
, MKC.KANBAN_SIZE
, MKC.CURRENT_REPLNSH_CYCLE_ID
, MKC.ERROR_CODE
, MKC.LAST_UPDATE_LOGIN
, MKC.LAST_PRINT_DATE
, MKC.ATTRIBUTE_CATEGORY
, MKC.ATTRIBUTE1
, MKC.ATTRIBUTE2
, MKC.ATTRIBUTE3
, MKC.ATTRIBUTE4
, MKC.ATTRIBUTE5
, MKC.ATTRIBUTE6
, MKC.ATTRIBUTE7
, MKC.ATTRIBUTE8
, MKC.ATTRIBUTE9
, MKC.ATTRIBUTE10
, MKC.ATTRIBUTE11
, MKC.ATTRIBUTE12
, MKC.ATTRIBUTE13
, MKC.ATTRIBUTE14
, MKC.ATTRIBUTE15
, MKC.REQUEST_ID
, MKC.PROGRAM_APPLICATION_ID
, MKC.PROGRAM_ID
, MKC.PROGRAM_UPDATE_DATE
, MKC.MAX_REPLENISHMENTS
, MKC.REPLENISHMENT_COUNT
, MKC.DISABLE_DATE
FROM MTL_SECONDARY_INVENTORIES MSS
, MFG_LOOKUPS MLK3
, MFG_LOOKUPS MLK2
, MFG_LOOKUPS MLK1
, MTL_KANBAN_CARDS MKC
WHERE MLK3.LOOKUP_CODE = MKC.SUPPLY_STATUS
AND MLK3.LOOKUP_TYPE = 'MTL_KANBAN_SUPPLY_STATUS'
AND MLK2.LOOKUP_CODE = MKC.CARD_STATUS
AND MLK2.LOOKUP_TYPE = 'MTL_KANBAN_CARD_STATUS'
AND MLK1.LOOKUP_CODE IN (1
, 3)
AND MLK1.LOOKUP_TYPE = 'MTL_KANBAN_SOURCE_TYPE'
AND MKC.SOURCE_TYPE IN (1
, 3)
AND MKC.SOURCE_TYPE = MLK1.LOOKUP_CODE
AND MKC.SOURCE_ORGANIZATION_ID IS NULL
AND MSS.SECONDARY_INVENTORY_NAME = MKC.SUBINVENTORY_NAME
AND MSS.ORGANIZATION_ID = MKC.ORGANIZATION_ID
AND (MSS.SUBINVENTORY_TYPE = 1 OR MSS.SUBINVENTORY_TYPE IS NULL) UNION ALL SELECT MKC.KANBAN_CARD_ID
, MKC.KANBAN_CARD_NUMBER
, MKC.PULL_SEQUENCE_ID
, MKC.INVENTORY_ITEM_ID
, MKC.ORGANIZATION_ID
, MKC.SUBINVENTORY_NAME
, MSS.LOCATOR_TYPE SUB_LOCATOR_TYPE
, MKC.SUPPLY_STATUS
, MLK3.MEANING SUPPLY_STATUS_NAME
, MKC.CARD_STATUS
, MLK2.MEANING CARD_STATUS_NAME
, MKC.KANBAN_CARD_TYPE
, MKC.SOURCE_TYPE
, MLK1.MEANING SOURCE_TYPE_MEANING
, MKC.LAST_UPDATE_DATE
, MKC.LAST_UPDATED_BY
, MKC.CREATION_DATE
, MKC.CREATED_BY
, MKC.LOCATOR_ID
, MKC.SUPPLIER_ID
, POV.VENDOR_NAME SUPPLIER_NAME
, MKC.SUPPLIER_SITE_ID
, MKC.SOURCE_ORGANIZATION_ID
, NULL SOURCE_LOCATION_CONTROL_CODE
, NULL SOURCE_ORG_RESTRICT_SUB
, NULL SOURCE_ORG_RESTRICT_LOC
, NULL SOURCE_ORG_LOCATOR_CONTROL
, NULL SOURCE_ORG_NEGATIVE_CONTROL
, NULL SOURCE_ORG_CODE
, NULL SOURCE_ORG_NAME
, MKC.SOURCE_SUBINVENTORY
, NULL SOURCE_SUB_LOCATOR_TYPE
, MKC.SOURCE_LOCATOR_ID
, MKC.WIP_LINE_ID
, NULL WIP_LINE_CODE
, MKC.KANBAN_SIZE
, MKC.CURRENT_REPLNSH_CYCLE_ID
, MKC.ERROR_CODE
, MKC.LAST_UPDATE_LOGIN
, MKC.LAST_PRINT_DATE
, MKC.ATTRIBUTE_CATEGORY
, MKC.ATTRIBUTE1
, MKC.ATTRIBUTE2
, MKC.ATTRIBUTE3
, MKC.ATTRIBUTE4
, MKC.ATTRIBUTE5
, MKC.ATTRIBUTE6
, MKC.ATTRIBUTE7
, MKC.ATTRIBUTE8
, MKC.ATTRIBUTE9
, MKC.ATTRIBUTE10
, MKC.ATTRIBUTE11
, MKC.ATTRIBUTE12
, MKC.ATTRIBUTE13
, MKC.ATTRIBUTE14
, MKC.ATTRIBUTE15
, MKC.REQUEST_ID
, MKC.PROGRAM_APPLICATION_ID
, MKC.PROGRAM_ID
, MKC.PROGRAM_UPDATE_DATE
, MKC.MAX_REPLENISHMENTS
, MKC.REPLENISHMENT_COUNT
, MKC.DISABLE_DATE
FROM PO_VENDORS POV
, MTL_SECONDARY_INVENTORIES MSS
, MFG_LOOKUPS MLK3
, MFG_LOOKUPS MLK2
, MFG_LOOKUPS MLK1
, MTL_KANBAN_CARDS MKC
WHERE MLK3.LOOKUP_CODE = MKC.SUPPLY_STATUS
AND MLK3.LOOKUP_TYPE = 'MTL_KANBAN_SUPPLY_STATUS'
AND MLK2.LOOKUP_CODE = MKC.CARD_STATUS
AND MLK2.LOOKUP_TYPE = 'MTL_KANBAN_CARD_STATUS'
AND MLK1.LOOKUP_CODE = 2
AND MLK1.LOOKUP_TYPE = 'MTL_KANBAN_SOURCE_TYPE'
AND MSS.SECONDARY_INVENTORY_NAME = MKC.SUBINVENTORY_NAME
AND MSS.ORGANIZATION_ID = MKC.ORGANIZATION_ID
AND MKC.SUPPLIER_ID = POV.VENDOR_ID
AND MKC.SUPPLIER_ID IS NOT NULL
AND MKC.SOURCE_TYPE = 2
AND MKC.SOURCE_TYPE = MLK1.LOOKUP_CODE
AND (MSS.SUBINVENTORY_TYPE = 1 OR MSS.SUBINVENTORY_TYPE IS NULL) UNION ALL SELECT MKC.KANBAN_CARD_ID
, MKC.KANBAN_CARD_NUMBER
, MKC.PULL_SEQUENCE_ID
, MKC.INVENTORY_ITEM_ID
, MKC.ORGANIZATION_ID
, MKC.SUBINVENTORY_NAME
, MSS.LOCATOR_TYPE SUB_LOCATOR_TYPE
, MKC.SUPPLY_STATUS
, MLK3.MEANING SUPPLY_STATUS_NAME
, MKC.CARD_STATUS
, MLK2.MEANING CARD_STATUS_NAME
, MKC.KANBAN_CARD_TYPE
, MKC.SOURCE_TYPE
, MLK1.MEANING SOURCE_TYPE_MEANING
, MKC.LAST_UPDATE_DATE
, MKC.LAST_UPDATED_BY
, MKC.CREATION_DATE
, MKC.CREATED_BY
, MKC.LOCATOR_ID
, MKC.SUPPLIER_ID
, NULL SUPPLIER_NAME
, MKC.SUPPLIER_SITE_ID
, MKC.SOURCE_ORGANIZATION_ID
, NULL SOURCE_LOCATION_CONTROL_CODE
, NULL SOURCE_ORG_RESTRICT_SUB
, NULL SOURCE_ORG_RESTRICT_LOC
, NULL SOURCE_ORG_LOCATOR_CONTROL
, NULL SOURCE_ORG_NEGATIVE_CONTROL
, NULL SOURCE_ORG_CODE
, NULL SOURCE_ORG_NAME
, MKC.SOURCE_SUBINVENTORY
, NULL SOURCE_SUB_LOCATOR_TYPE
, MKC.SOURCE_LOCATOR_ID
, MKC.WIP_LINE_ID
, NULL WIP_LINE_CODE
, MKC.KANBAN_SIZE
, MKC.CURRENT_REPLNSH_CYCLE_ID
, MKC.ERROR_CODE
, MKC.LAST_UPDATE_LOGIN
, MKC.LAST_PRINT_DATE
, MKC.ATTRIBUTE_CATEGORY
, MKC.ATTRIBUTE1
, MKC.ATTRIBUTE2
, MKC.ATTRIBUTE3
, MKC.ATTRIBUTE4
, MKC.ATTRIBUTE5
, MKC.ATTRIBUTE6
, MKC.ATTRIBUTE7
, MKC.ATTRIBUTE8
, MKC.ATTRIBUTE9
, MKC.ATTRIBUTE10
, MKC.ATTRIBUTE11
, MKC.ATTRIBUTE12
, MKC.ATTRIBUTE13
, MKC.ATTRIBUTE14
, MKC.ATTRIBUTE15
, MKC.REQUEST_ID
, MKC.PROGRAM_APPLICATION_ID
, MKC.PROGRAM_ID
, MKC.PROGRAM_UPDATE_DATE
, MKC.MAX_REPLENISHMENTS
, MKC.REPLENISHMENT_COUNT
, MKC.DISABLE_DATE
FROM MTL_SECONDARY_INVENTORIES MSS
, MFG_LOOKUPS MLK3
, MFG_LOOKUPS MLK2
, MFG_LOOKUPS MLK1
, MTL_KANBAN_CARDS MKC
WHERE MLK3.LOOKUP_CODE = MKC.SUPPLY_STATUS
AND MLK3.LOOKUP_TYPE = 'MTL_KANBAN_SUPPLY_STATUS'
AND MLK2.LOOKUP_CODE = MKC.CARD_STATUS
AND MLK2.LOOKUP_TYPE = 'MTL_KANBAN_CARD_STATUS'
AND MLK1.LOOKUP_CODE = 2
AND MLK1.LOOKUP_TYPE = 'MTL_KANBAN_SOURCE_TYPE'
AND MKC.SOURCE_TYPE = 2
AND MKC.SOURCE_TYPE = MLK1.LOOKUP_CODE
AND MSS.SECONDARY_INVENTORY_NAME = MKC.SUBINVENTORY_NAME
AND MSS.ORGANIZATION_ID = MKC.ORGANIZATION_ID
AND MKC.SUPPLIER_ID IS NULL
AND (MSS.SUBINVENTORY_TYPE = 1 OR MSS.SUBINVENTORY_TYPE IS NULL) UNION ALL SELECT MKC.KANBAN_CARD_ID
, MKC.KANBAN_CARD_NUMBER
, MKC.PULL_SEQUENCE_ID
, MKC.INVENTORY_ITEM_ID
, MKC.ORGANIZATION_ID
, MKC.SUBINVENTORY_NAME
, MSS.LOCATOR_TYPE SUB_LOCATOR_TYPE
, MKC.SUPPLY_STATUS
, MLK3.MEANING SUPPLY_STATUS_NAME
, MKC.CARD_STATUS
, MLK2.MEANING CARD_STATUS_NAME
, MKC.KANBAN_CARD_TYPE
, MKC.SOURCE_TYPE
, MLK1.MEANING SOURCE_TYPE_MEANING
, MKC.LAST_UPDATE_DATE
, MKC.LAST_UPDATED_BY
, MKC.CREATION_DATE
, MKC.CREATED_BY
, MKC.LOCATOR_ID
, MKC.SUPPLIER_ID
, NULL SUPPLIER_NAME
, MKC.SUPPLIER_SITE_ID
, MKC.SOURCE_ORGANIZATION_ID
, NULL SOURCE_LOCATION_CONTROL_CODE
, NULL SOURCE_ORG_RESTRICT_SUB
, NULL SOURCE_ORG_RESTRICT_LOC
, NULL SOURCE_ORG_LOCATOR_CONTROL
, NULL SOURCE_ORG_NEGATIVE_CONTROL
, NULL SOURCE_ORG_CODE
, NULL SOURCE_ORG_NAME
, MKC.SOURCE_SUBINVENTORY
, NULL SOURCE_SUB_LOCATOR_TYPE
, MKC.SOURCE_LOCATOR_ID
, MKC.WIP_LINE_ID
, WIP.LINE_CODE
, MKC.KANBAN_SIZE
, MKC.CURRENT_REPLNSH_CYCLE_ID
, MKC.ERROR_CODE
, MKC.LAST_UPDATE_LOGIN
, MKC.LAST_PRINT_DATE
, MKC.ATTRIBUTE_CATEGORY
, MKC.ATTRIBUTE1
, MKC.ATTRIBUTE2
, MKC.ATTRIBUTE3
, MKC.ATTRIBUTE4
, MKC.ATTRIBUTE5
, MKC.ATTRIBUTE6
, MKC.ATTRIBUTE7
, MKC.ATTRIBUTE8
, MKC.ATTRIBUTE9
, MKC.ATTRIBUTE10
, MKC.ATTRIBUTE11
, MKC.ATTRIBUTE12
, MKC.ATTRIBUTE13
, MKC.ATTRIBUTE14
, MKC.ATTRIBUTE15
, MKC.REQUEST_ID
, MKC.PROGRAM_APPLICATION_ID
, MKC.PROGRAM_ID
, MKC.PROGRAM_UPDATE_DATE
, MKC.MAX_REPLENISHMENTS
, MKC.REPLENISHMENT_COUNT
, MKC.DISABLE_DATE
FROM WIP_LINES WIP
, MTL_SECONDARY_INVENTORIES MSS
, MFG_LOOKUPS MLK3
, MFG_LOOKUPS MLK2
, MFG_LOOKUPS MLK1
, MTL_KANBAN_CARDS MKC
WHERE MLK3.LOOKUP_CODE = MKC.SUPPLY_STATUS
AND MLK3.LOOKUP_TYPE = 'MTL_KANBAN_SUPPLY_STATUS'
AND MLK2.LOOKUP_CODE = MKC.CARD_STATUS
AND MLK2.LOOKUP_TYPE = 'MTL_KANBAN_CARD_STATUS'
AND MLK1.LOOKUP_CODE = 4
AND MLK1.LOOKUP_TYPE = 'MTL_KANBAN_SOURCE_TYPE'
AND MSS.SECONDARY_INVENTORY_NAME = MKC.SUBINVENTORY_NAME
AND MSS.ORGANIZATION_ID = MKC.ORGANIZATION_ID
AND MKC.WIP_LINE_ID = WIP.LINE_ID
AND MKC.WIP_LINE_ID IS NOT NULL
AND MKC.SOURCE_TYPE = 4
AND MKC.SOURCE_TYPE = MLK1.LOOKUP_CODE
AND (MSS.SUBINVENTORY_TYPE = 1 OR MSS.SUBINVENTORY_TYPE IS NULL) UNION ALL SELECT MKC.KANBAN_CARD_ID
, MKC.KANBAN_CARD_NUMBER
, MKC.PULL_SEQUENCE_ID
, MKC.INVENTORY_ITEM_ID
, MKC.ORGANIZATION_ID
, MKC.SUBINVENTORY_NAME
, MSS.LOCATOR_TYPE SUB_LOCATOR_TYPE
, MKC.SUPPLY_STATUS
, MLK3.MEANING SUPPLY_STATUS_NAME
, MKC.CARD_STATUS
, MLK2.MEANING CARD_STATUS_NAME
, MKC.KANBAN_CARD_TYPE
, MKC.SOURCE_TYPE
, MLK1.MEANING SOURCE_TYPE_MEANING
, MKC.LAST_UPDATE_DATE
, MKC.LAST_UPDATED_BY
, MKC.CREATION_DATE
, MKC.CREATED_BY
, MKC.LOCATOR_ID
, MKC.SUPPLIER_ID
, NULL SUPPLIER_NAME
, MKC.SUPPLIER_SITE_ID
, MKC.SOURCE_ORGANIZATION_ID
, NULL SOURCE_LOCATION_CONTROL_CODE
, NULL SOURCE_ORG_RESTRICT_SUB
, NULL SOURCE_ORG_RESTRICT_LOC
, NULL SOURCE_ORG_LOCATOR_CONTROL
, NULL SOURCE_ORG_NEGATIVE_CONTROL
, NULL SOURCE_ORG_CODE
, NULL SOURCE_ORG_NAME
, MKC.SOURCE_SUBINVENTORY
, NULL SOURCE_SUB_LOCATOR_TYPE
, MKC.SOURCE_LOCATOR_ID
, MKC.WIP_LINE_ID
, NULL WIP_LINE_CODE
, MKC.KANBAN_SIZE
, MKC.CURRENT_REPLNSH_CYCLE_ID
, MKC.ERROR_CODE
, MKC.LAST_UPDATE_LOGIN
, MKC.LAST_PRINT_DATE
, MKC.ATTRIBUTE_CATEGORY
, MKC.ATTRIBUTE1
, MKC.ATTRIBUTE2
, MKC.ATTRIBUTE3
, MKC.ATTRIBUTE4
, MKC.ATTRIBUTE5
, MKC.ATTRIBUTE6
, MKC.ATTRIBUTE7
, MKC.ATTRIBUTE8
, MKC.ATTRIBUTE9
, MKC.ATTRIBUTE10
, MKC.ATTRIBUTE11
, MKC.ATTRIBUTE12
, MKC.ATTRIBUTE13
, MKC.ATTRIBUTE14
, MKC.ATTRIBUTE15
, MKC.REQUEST_ID
, MKC.PROGRAM_APPLICATION_ID
, MKC.PROGRAM_ID
, MKC.PROGRAM_UPDATE_DATE
, MKC.MAX_REPLENISHMENTS
, MKC.REPLENISHMENT_COUNT
, MKC.DISABLE_DATE
FROM MTL_SECONDARY_INVENTORIES MSS
, MFG_LOOKUPS MLK3
, MFG_LOOKUPS MLK2
, MFG_LOOKUPS MLK1
, MTL_KANBAN_CARDS MKC
WHERE MLK3.LOOKUP_CODE = MKC.SUPPLY_STATUS
AND MLK3.LOOKUP_TYPE = 'MTL_KANBAN_SUPPLY_STATUS'
AND MLK2.LOOKUP_CODE = MKC.CARD_STATUS
AND MLK2.LOOKUP_TYPE = 'MTL_KANBAN_CARD_STATUS'
AND MLK1.LOOKUP_CODE = 4
AND MLK1.LOOKUP_TYPE = 'MTL_KANBAN_SOURCE_TYPE'
AND MSS.SECONDARY_INVENTORY_NAME = MKC.SUBINVENTORY_NAME
AND MSS.ORGANIZATION_ID = MKC.ORGANIZATION_ID
AND MKC.SOURCE_TYPE = 4
AND MKC.SOURCE_TYPE = MLK1.LOOKUP_CODE
AND MKC.WIP_LINE_ID IS NULL
AND (MSS.SUBINVENTORY_TYPE = 1 OR MSS.SUBINVENTORY_TYPE IS NULL)

Columns