VIEW: APPS.INVFV_KANBAN_CARDS

Source

View Text - Preformatted

SELECT MKC.KANBAN_CARD_ID, MKC.KANBAN_CARD_NUMBER, MKC.PULL_SEQUENCE_ID, MKC.INVENTORY_ITEM_ID, '_KF:INV:MSTK:MSI', /* KEYFLEX */ MKC.ORGANIZATION_ID, MP1.ORGANIZATION_CODE, HOU1.NAME, 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, '_KF:INV:MTLL:MIL1', /* KEYFLEX */ MKC.SUPPLIER_ID, NULL, MKC.SUPPLIER_SITE_ID, NULL, MKC.SOURCE_ORGANIZATION_ID, MP2.ORGANIZATION_CODE, HOU2.NAME, MKC.SOURCE_SUBINVENTORY, MKC.SOURCE_LOCATOR_ID, '_KF:INV:MTLL:MIL2', /* KEYFLEX */ '_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, WIP.LINE_CODE FROM MTL_PARAMETERS MP1, MTL_PARAMETERS MP2, HR_ALL_ORGANIZATION_UNITS HOU1, HR_ALL_ORGANIZATION_UNITS HOU2, MTL_ITEM_LOCATIONS MIL1, MTL_ITEM_LOCATIONS MIL2, MTL_SYSTEM_ITEMS MSI, WIP_LINES WIP, MTL_KANBAN_CARDS MKC WHERE MKC.SOURCE_TYPE in (1,3) AND MSI.INVENTORY_ITEM_ID = MKC.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = MKC.ORGANIZATION_ID AND MIL1.INVENTORY_LOCATION_ID (+) = MKC.LOCATOR_ID AND MIL1.ORGANIZATION_ID (+) = MKC.ORGANIZATION_ID AND MIL2.INVENTORY_LOCATION_ID (+) = MKC.SOURCE_LOCATOR_ID AND MIL2.ORGANIZATION_ID (+) = MKC.SOURCE_ORGANIZATION_ID AND MP1.ORGANIZATION_ID = MKC.ORGANIZATION_ID AND MP2.ORGANIZATION_ID (+) = MKC.SOURCE_ORGANIZATION_ID AND HOU1.ORGANIZATION_ID = MKC.ORGANIZATION_ID AND HOU2.ORGANIZATION_ID (+) = MKC.SOURCE_ORGANIZATION_ID AND WIP.LINE_ID (+) = MKC.WIP_LINE_ID AND '_SEC:MKC.ORGANIZATION_ID' IS NOT NULL UNION SELECT MKC.KANBAN_CARD_ID, MKC.KANBAN_CARD_NUMBER, MKC.PULL_SEQUENCE_ID, MKC.INVENTORY_ITEM_ID, '_KF:INV:MSTK:MSI', /* KEYFLEX */ MKC.ORGANIZATION_ID, MP1.ORGANIZATION_CODE, HOU1.NAME, 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, '_KF:INV:MTLL:MIL1', /* KEYFLEX */ MKC.SUPPLIER_ID, POV.VENDOR_NAME SUPPLIER_NAME, MKC.SUPPLIER_SITE_ID, POS.VENDOR_SITE_CODE SUPPLIER_SITE_CODE, MKC.SOURCE_ORGANIZATION_ID, NULL SOURCE_ORGANIZATION_CODE, NULL SOURCE_ORGANIZATION_NAME, MKC.SOURCE_SUBINVENTORY, MKC.SOURCE_LOCATOR_ID, '_KF:_EX:TO_CHAR(NULL)', /* KEYFLEX */ '_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, WIP.LINE_CODE FROM PO_VENDORS POV, PO_VENDOR_SITES_ALL POS, MTL_PARAMETERS MP1, HR_ALL_ORGANIZATION_UNITS HOU1, MTL_ITEM_LOCATIONS MIL1, MTL_SYSTEM_ITEMS MSI, WIP_LINES WIP, MTL_KANBAN_CARDS MKC WHERE MKC.SOURCE_TYPE in (2,4) AND MSI.INVENTORY_ITEM_ID = MKC.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = MKC.ORGANIZATION_ID AND MP1.ORGANIZATION_ID = MKC.ORGANIZATION_ID AND HOU1.ORGANIZATION_ID = MKC.ORGANIZATION_ID AND MIL1.INVENTORY_LOCATION_ID (+) = MKC.LOCATOR_ID AND MIL1.ORGANIZATION_ID (+) = MKC.ORGANIZATION_ID AND POV.VENDOR_ID (+) = MKC.SUPPLIER_ID AND POS.VENDOR_SITE_ID (+) = MKC.SUPPLIER_SITE_ID AND WIP.LINE_ID (+) = MKC.WIP_LINE_ID AND '_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
, '_KF:INV:MSTK:MSI'
, /* KEYFLEX */ MKC.ORGANIZATION_ID
, MP1.ORGANIZATION_CODE
, HOU1.NAME
, 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
, '_KF:INV:MTLL:MIL1'
, /* KEYFLEX */ MKC.SUPPLIER_ID
, NULL
, MKC.SUPPLIER_SITE_ID
, NULL
, MKC.SOURCE_ORGANIZATION_ID
, MP2.ORGANIZATION_CODE
, HOU2.NAME
, MKC.SOURCE_SUBINVENTORY
, MKC.SOURCE_LOCATOR_ID
, '_KF:INV:MTLL:MIL2'
, /* KEYFLEX */ '_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
, WIP.LINE_CODE
FROM MTL_PARAMETERS MP1
, MTL_PARAMETERS MP2
, HR_ALL_ORGANIZATION_UNITS HOU1
, HR_ALL_ORGANIZATION_UNITS HOU2
, MTL_ITEM_LOCATIONS MIL1
, MTL_ITEM_LOCATIONS MIL2
, MTL_SYSTEM_ITEMS MSI
, WIP_LINES WIP
, MTL_KANBAN_CARDS MKC
WHERE MKC.SOURCE_TYPE IN (1
, 3)
AND MSI.INVENTORY_ITEM_ID = MKC.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MKC.ORGANIZATION_ID
AND MIL1.INVENTORY_LOCATION_ID (+) = MKC.LOCATOR_ID
AND MIL1.ORGANIZATION_ID (+) = MKC.ORGANIZATION_ID
AND MIL2.INVENTORY_LOCATION_ID (+) = MKC.SOURCE_LOCATOR_ID
AND MIL2.ORGANIZATION_ID (+) = MKC.SOURCE_ORGANIZATION_ID
AND MP1.ORGANIZATION_ID = MKC.ORGANIZATION_ID
AND MP2.ORGANIZATION_ID (+) = MKC.SOURCE_ORGANIZATION_ID
AND HOU1.ORGANIZATION_ID = MKC.ORGANIZATION_ID
AND HOU2.ORGANIZATION_ID (+) = MKC.SOURCE_ORGANIZATION_ID
AND WIP.LINE_ID (+) = MKC.WIP_LINE_ID
AND '_SEC:MKC.ORGANIZATION_ID' IS NOT NULL UNION SELECT MKC.KANBAN_CARD_ID
, MKC.KANBAN_CARD_NUMBER
, MKC.PULL_SEQUENCE_ID
, MKC.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI'
, /* KEYFLEX */ MKC.ORGANIZATION_ID
, MP1.ORGANIZATION_CODE
, HOU1.NAME
, 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
, '_KF:INV:MTLL:MIL1'
, /* KEYFLEX */ MKC.SUPPLIER_ID
, POV.VENDOR_NAME SUPPLIER_NAME
, MKC.SUPPLIER_SITE_ID
, POS.VENDOR_SITE_CODE SUPPLIER_SITE_CODE
, MKC.SOURCE_ORGANIZATION_ID
, NULL SOURCE_ORGANIZATION_CODE
, NULL SOURCE_ORGANIZATION_NAME
, MKC.SOURCE_SUBINVENTORY
, MKC.SOURCE_LOCATOR_ID
, '_KF:_EX:TO_CHAR(NULL)'
, /* KEYFLEX */ '_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
, WIP.LINE_CODE
FROM PO_VENDORS POV
, PO_VENDOR_SITES_ALL POS
, MTL_PARAMETERS MP1
, HR_ALL_ORGANIZATION_UNITS HOU1
, MTL_ITEM_LOCATIONS MIL1
, MTL_SYSTEM_ITEMS MSI
, WIP_LINES WIP
, MTL_KANBAN_CARDS MKC
WHERE MKC.SOURCE_TYPE IN (2
, 4)
AND MSI.INVENTORY_ITEM_ID = MKC.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MKC.ORGANIZATION_ID
AND MP1.ORGANIZATION_ID = MKC.ORGANIZATION_ID
AND HOU1.ORGANIZATION_ID = MKC.ORGANIZATION_ID
AND MIL1.INVENTORY_LOCATION_ID (+) = MKC.LOCATOR_ID
AND MIL1.ORGANIZATION_ID (+) = MKC.ORGANIZATION_ID
AND POV.VENDOR_ID (+) = MKC.SUPPLIER_ID
AND POS.VENDOR_SITE_ID (+) = MKC.SUPPLIER_SITE_ID
AND WIP.LINE_ID (+) = MKC.WIP_LINE_ID
AND '_SEC:MKC.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY