eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MTL_KANBAN_CARDS_V

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 , 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 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 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 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 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 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 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)

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
, 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
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
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
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
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
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
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)