VIEW: APPS.INVFV_KANBAN_CARD_ACTIVITIES

Source

View Text - Preformatted

SELECT MKA.KANBAN_ACTIVITY_ID, MKA.REPLENISHMENT_CYCLE_ID, MKA.KANBAN_CARD_ID, MKA.KANBAN_CARD_NUMBER, MKA.INVENTORY_ITEM_ID, '_KF:INV:MSTK:MSI', /* KEYFLEX */ MKA.ORGANIZATION_ID, MP1.ORGANIZATION_CODE, HOU1.NAME, MKA.SUBINVENTORY_NAME, '_LA:MKA.SUPPLY_STATUS:MFG_LOOKUPS:MTL_KANBAN_SUPPLY_STATUS:MEANING', /* LOOKUP */ '_LA:MKA.CARD_STATUS:MFG_LOOKUPS:MTL_KANBAN_CARD_STATUS:MEANING', /* LOOKUP */ '_LA:MKA.KANBAN_CARD_TYPE:MFG_LOOKUPS:MTL_KANBAN_CARD_TYPE:MEANING', /* LOOKUP */ '_LA:MKA.SOURCE_TYPE:MFG_LOOKUPS:MTL_KANBAN_SOURCE_TYPE:MEANING', /* LOOKUP */ MKA.KANBAN_SIZE, MKA.LOCATOR_ID, '_KF:INV:MTLL:MIL1', /* KEYFLEX */ MKA.SUPPLIER_ID, POV.VENDOR_NAME SUPPLIER_NAME, MKA.SUPPLIER_SITE_ID, POS.VENDOR_SITE_CODE SUPPLIER_SITE_CODE, MKA.SOURCE_ORGANIZATION_ID, MP2.ORGANIZATION_CODE, HOU2.NAME, MKA.SOURCE_SUBINVENTORY, MKA.SOURCE_LOCATOR_ID, '_KF:INV:MTLL:MIL2', /* KEYFLEX */ '_LA:MKA.DOCUMENT_TYPE:MFG_LOOKUPS:MTL_KANBAN_DOCUMENT_TYPE:MEANING', /* LOOKUP */ MKA.DOCUMENT_HEADER_ID, NULL,MKA.DOCUMENT_DETAIL_ID, NULL, '_LA:MKA.ERROR_CODE:MFG_LOOKUPS:MTL_KANBAN_ERROR_CODE:MEANING', /* LOOKUP */ MKA.LAST_PRINT_DATE, MKA.CREATED_BY, MKA.CREATION_DATE, MKA.LAST_UPDATED_BY, MKA.LAST_UPDATE_DATE, MKA.WIP_LINE_ID, WIP.LINE_CODE FROM PO_VENDORS POV, PO_VENDOR_SITES_ALL POS, MTL_ITEM_LOCATIONS MIL1, MTL_ITEM_LOCATIONS MIL2, HR_ALL_ORGANIZATION_UNITS HOU1, HR_ALL_ORGANIZATION_UNITS HOU2, MTL_PARAMETERS MP1, MTL_PARAMETERS MP2, MTL_SYSTEM_ITEMS MSI, WIP_LINES WIP, MTL_KANBAN_CARD_ACTIVITY MKA WHERE MP1.ORGANIZATION_ID = MKA.ORGANIZATION_ID AND MP2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID AND HOU1.ORGANIZATION_ID = MKA.ORGANIZATION_ID AND HOU2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID = MKA.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = MKA.ORGANIZATION_ID AND MIL1.INVENTORY_LOCATION_ID (+) = MKA.LOCATOR_ID AND MIL1.ORGANIZATION_ID (+) = MKA.ORGANIZATION_ID AND MIL2.INVENTORY_LOCATION_ID (+) = MKA.SOURCE_LOCATOR_ID AND MIL2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID AND POV.VENDOR_ID (+) = MKA.SUPPLIER_ID AND POS.VENDOR_SITE_ID (+) = MKA.SUPPLIER_SITE_ID AND MKA.DOCUMENT_TYPE IS NULL AND WIP.LINE_ID (+) = MKA.WIP_LINE_ID AND '_SEC:MKA.ORGANIZATION_ID' IS NOT NULL UNION /* where DOCUMENT_TYPE (is PO) = 1 */ SELECT MKA.KANBAN_ACTIVITY_ID, MKA.REPLENISHMENT_CYCLE_ID, MKA.KANBAN_CARD_ID, MKA.KANBAN_CARD_NUMBER, MKA.INVENTORY_ITEM_ID, '_KF:INV:MSTK:MSI', /* KEYFLEX */ MKA.ORGANIZATION_ID, MP1.ORGANIZATION_CODE, HOU1.NAME, MKA.SUBINVENTORY_NAME, '_LA:MKA.SUPPLY_STATUS:MFG_LOOKUPS:MTL_KANBAN_SUPPLY_STATUS:MEANING', /* LOOKUP */ '_LA:MKA.CARD_STATUS:MFG_LOOKUPS:MTL_KANBAN_CARD_STATUS:MEANING', /* LOOKUP */ '_LA:MKA.KANBAN_CARD_TYPE:MFG_LOOKUPS:MTL_KANBAN_CARD_TYPE:MEANING', /* LOOKUP */ '_LA:MKA.SOURCE_TYPE:MFG_LOOKUPS:MTL_KANBAN_SOURCE_TYPE:MEANING', /* LOOKUP */ MKA.KANBAN_SIZE, MKA.LOCATOR_ID, '_KF:INV:MTLL:MIL1', /* KEYFLEX */ MKA.SUPPLIER_ID, POV.VENDOR_NAME SUPPLIER_NAME, MKA.SUPPLIER_SITE_ID, POS.VENDOR_SITE_CODE SUPPLIER_SITE_CODE, MKA.SOURCE_ORGANIZATION_ID, MP2.ORGANIZATION_CODE, HOU2.NAME, MKA.SOURCE_SUBINVENTORY, MKA.SOURCE_LOCATOR_ID, '_KF:INV:MTLL:MIL2', /* KEYFLEX */ '_LA:MKA.DOCUMENT_TYPE:MFG_LOOKUPS:MTL_KANBAN_DOCUMENT_TYPE:MEANING', /* LOOKUP */ MKA.DOCUMENT_HEADER_ID, POH.SEGMENT1, MKA.DOCUMENT_DETAIL_ID, TO_CHAR(POL.LINE_NUM)||'-'||TO_CHAR(PLL.SHIPMENT_NUM)||'-'|| TO_CHAR (POD.DISTRIBUTION_NUM), '_LA:MKA.ERROR_CODE:MFG_LOOKUPS:MTL_KANBAN_ERROR_CODE:MEANING', /* LOOKUP */ MKA.LAST_PRINT_DATE, MKA.CREATED_BY, MKA.CREATION_DATE, MKA.LAST_UPDATED_BY, MKA.LAST_UPDATE_DATE, MKA.WIP_LINE_ID, WIP.LINE_CODE FROM PO_DISTRIBUTIONS_ALL POD, PO_HEADERS_ALL POH, PO_LINES_ALL POL, PO_LINE_LOCATIONS_ALL PLL, PO_VENDORS POV, PO_VENDOR_SITES_ALL POS, HR_ALL_ORGANIZATION_UNITS HOU1, HR_ALL_ORGANIZATION_UNITS HOU2, MTL_ITEM_LOCATIONS MIL1, MTL_ITEM_LOCATIONS MIL2, MTL_PARAMETERS MP1, MTL_PARAMETERS MP2, MTL_SYSTEM_ITEMS MSI, WIP_LINES WIP, MTL_KANBAN_CARD_ACTIVITY MKA WHERE MP1.ORGANIZATION_ID = MKA.ORGANIZATION_ID AND MP2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID AND HOU1.ORGANIZATION_ID = MKA.ORGANIZATION_ID AND HOU2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID = MKA.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = MKA.ORGANIZATION_ID AND MIL1.INVENTORY_LOCATION_ID (+) = MKA.LOCATOR_ID AND MIL1.ORGANIZATION_ID (+) = MKA.ORGANIZATION_ID AND MIL2.INVENTORY_LOCATION_ID (+) = MKA.SOURCE_LOCATOR_ID AND MIL2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID AND POV.VENDOR_ID (+) = MKA.SUPPLIER_ID AND POS.VENDOR_SITE_ID (+) = MKA.SUPPLIER_SITE_ID AND POD.PO_DISTRIBUTION_ID (+) = MKA.DOCUMENT_DETAIL_ID AND POH.PO_HEADER_ID (+) = POD.PO_HEADER_ID AND POL.PO_LINE_ID (+) = POD.PO_LINE_ID AND PLL.LINE_LOCATION_ID (+) = POD.LINE_LOCATION_ID AND MKA.DOCUMENT_TYPE = 1 AND WIP.LINE_ID (+) = MKA.WIP_LINE_ID AND '_SEC:MKA.ORGANIZATION_ID' IS NOT NULL UNION /* where DOCUMENT_TYPE (is Blanket Release) = 2 */ SELECT MKA.KANBAN_ACTIVITY_ID, MKA.REPLENISHMENT_CYCLE_ID, MKA.KANBAN_CARD_ID, MKA.KANBAN_CARD_NUMBER, MKA.INVENTORY_ITEM_ID, '_KF:INV:MSTK:MSI', /* KEYFLEX */ MKA.ORGANIZATION_ID, MP1.ORGANIZATION_CODE, HOU1.NAME, MKA.SUBINVENTORY_NAME, '_LA:MKA.SUPPLY_STATUS:MFG_LOOKUPS:MTL_KANBAN_SUPPLY_STATUS:MEANING' , /* LOOKUP */ '_LA:MKA.CARD_STATUS:MFG_LOOKUPS:MTL_KANBAN_CARD_STATUS:MEANING', /* LOOKUP */ '_LA:MKA.KANBAN_CARD_TYPE:MFG_LOOKUPS:MTL_KANBAN_CARD_TYPE:MEANING', /* LOOKUP */ '_LA:MKA.SOURCE_TYPE:MFG_LOOKUPS:MTL_KANBAN_SOURCE_TYPE:MEANING', /* LOOKUP */ MKA.KANBAN_SIZE, MKA.LOCATOR_ID, '_KF:INV:MTLL:MIL1', /* KEYFLEX */ MKA.SUPPLIER_ID, POV.VENDOR_NAME SUPPLIER_NAME, MKA.SUPPLIER_SITE_ID, POS.VENDOR_SITE_CODE SUPPLIER_SITE_CODE, MKA.SOURCE_ORGANIZATION_ID, MP2.ORGANIZATION_CODE, HOU2.NAME, MKA.SOURCE_SUBINVENTORY, MKA.SOURCE_LOCATOR_ID, '_KF:INV:MTLL:MIL2', /* KEYFLEX */ '_LA:MKA.DOCUMENT_TYPE:MFG_LOOKUPS:MTL_KANBAN_DOCUMENT_TYPE:MEANING' , /* LOOKUP */ MKA.DOCUMENT_HEADER_ID, POH.SEGMENT1, MKA.DOCUMENT_DETAIL_ID, TO_CHAR(POR.RELEASE_NUM)||'-'||TO_CHAR(PLL.SHIPMENT_NUM)||'-'|| TO_CHAR (POD.DISTRIBUTION_NUM), '_LA:MKA.ERROR_CODE:MFG_LOOKUPS:MTL_KANBAN_ERROR_CODE:MEANING', /* LOOKUP */ MKA.LAST_PRINT_DATE, MKA.CREATED_BY, MKA.CREATION_DATE, MKA.LAST_UPDATED_BY, MKA.LAST_UPDATE_DATE, MKA.WIP_LINE_ID, WIP.LINE_CODE FROM PO_DISTRIBUTIONS_ALL POD, PO_HEADERS_ALL POH, PO_RELEASES_ALL POR, PO_LINE_LOCATIONS_ALL PLL, PO_VENDORS POV, PO_VENDOR_SITES_ALL POS, MTL_ITEM_LOCATIONS MIL1, MTL_ITEM_LOCATIONS MIL2, HR_ALL_ORGANIZATION_UNITS HOU1, HR_ALL_ORGANIZATION_UNITS HOU2, MTL_PARAMETERS MP1, MTL_PARAMETERS MP2, MTL_SYSTEM_ITEMS MSI, WIP_LINES WIP, MTL_KANBAN_CARD_ACTIVITY MKA WHERE MP1.ORGANIZATION_ID = MKA.ORGANIZATION_ID AND MP2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID AND HOU1.ORGANIZATION_ID = MKA.ORGANIZATION_ID AND HOU2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID = MKA.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = MKA.ORGANIZATION_ID AND MIL1.INVENTORY_LOCATION_ID (+) = MKA.LOCATOR_ID AND MIL1.ORGANIZATION_ID (+) = MKA.ORGANIZATION_ID AND MIL2.INVENTORY_LOCATION_ID (+) = MKA.SOURCE_LOCATOR_ID AND MIL2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID AND POV.VENDOR_ID (+) = MKA.SUPPLIER_ID AND POS.VENDOR_SITE_ID (+) = MKA.SUPPLIER_SITE_ID AND POD.PO_DISTRIBUTION_ID (+) = MKA.DOCUMENT_DETAIL_ID AND POH.PO_HEADER_ID (+) = POD.PO_HEADER_ID AND POR.PO_RELEASE_ID (+) = POD.PO_RELEASE_ID AND PLL.LINE_LOCATION_ID (+) = POD.LINE_LOCATION_ID AND MKA.DOCUMENT_TYPE = 2 AND WIP.LINE_ID (+) = MKA.WIP_LINE_ID AND '_SEC:MKA.ORGANIZATION_ID' IS NOT NULL UNION /* where DOCUMENT_TYPE (is Internal Requisition) = 3 */ SELECT MKA.KANBAN_ACTIVITY_ID, MKA.REPLENISHMENT_CYCLE_ID, MKA.KANBAN_CARD_ID, MKA.KANBAN_CARD_NUMBER, MKA.INVENTORY_ITEM_ID, '_KF:INV:MSTK:MSI', /* KEYFLEX */ MKA.ORGANIZATION_ID, MP1.ORGANIZATION_CODE, HOU1.NAME, MKA.SUBINVENTORY_NAME, '_LA:MKA.SUPPLY_STATUS:MFG_LOOKUPS:MTL_KANBAN_SUPPLY_STATUS:MEANING' , /* LOOKUP */ '_LA:MKA.CARD_STATUS:MFG_LOOKUPS:MTL_KANBAN_CARD_STATUS:MEANING', /* LOOKUP */ '_LA:MKA.KANBAN_CARD_TYPE:MFG_LOOKUPS:MTL_KANBAN_CARD_TYPE:MEANING', /* LOOKUP */ '_LA:MKA.SOURCE_TYPE:MFG_LOOKUPS:MTL_KANBAN_SOURCE_TYPE:MEANING', /* LOOKUP */ MKA.KANBAN_SIZE, MKA.LOCATOR_ID, '_KF:INV:MTLL:MIL1', /* KEYFLEX */ MKA.SUPPLIER_ID, POV.VENDOR_NAME SUPPLIER_NAME, MKA.SUPPLIER_SITE_ID, POS.VENDOR_SITE_CODE SUPPLIER_SITE_CODE, MKA.SOURCE_ORGANIZATION_ID, MP2.ORGANIZATION_CODE, HOU2.NAME, MKA.SOURCE_SUBINVENTORY, MKA.SOURCE_LOCATOR_ID, '_KF:INV:MTLL:MIL2', /* KEYFLEX */ '_LA:MKA.DOCUMENT_TYPE:MFG_LOOKUPS:MTL_KANBAN_DOCUMENT_TYPE:MEANING' , /* LOOKUP */ MKA.DOCUMENT_HEADER_ID, PRH.SEGMENT1, MKA.DOCUMENT_DETAIL_ID, TO_CHAR (PRL.LINE_NUM), '_LA:MKA.ERROR_CODE:MFG_LOOKUPS:MTL_KANBAN_ERROR_CODE:MEANING', /* LOOKUP */ MKA.LAST_PRINT_DATE, MKA.CREATED_BY, MKA.CREATION_DATE, MKA.LAST_UPDATED_BY, MKA.LAST_UPDATE_DATE, MKA.WIP_LINE_ID, WIP.LINE_CODE FROM PO_REQUISITION_HEADERS_ALL PRH, PO_REQUISITION_LINES_ALL PRL, PO_VENDORS POV, PO_VENDOR_SITES_ALL POS, MTL_ITEM_LOCATIONS MIL1, MTL_ITEM_LOCATIONS MIL2, HR_ALL_ORGANIZATION_UNITS HOU1, HR_ALL_ORGANIZATION_UNITS HOU2, MTL_PARAMETERS MP1, MTL_PARAMETERS MP2, MTL_SYSTEM_ITEMS MSI, WIP_LINES WIP, MTL_KANBAN_CARD_ACTIVITY MKA WHERE MP1.ORGANIZATION_ID = MKA.ORGANIZATION_ID AND MP2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID AND HOU1.ORGANIZATION_ID = MKA.ORGANIZATION_ID AND HOU2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID = MKA.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = MKA.ORGANIZATION_ID AND MIL1.INVENTORY_LOCATION_ID (+) = MKA.LOCATOR_ID AND MIL1.ORGANIZATION_ID (+) = MKA.ORGANIZATION_ID AND MIL2.INVENTORY_LOCATION_ID (+) = MKA.SOURCE_LOCATOR_ID AND MIL2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID AND POV.VENDOR_ID (+) = MKA.SUPPLIER_ID AND POS.VENDOR_SITE_ID (+) = MKA.SUPPLIER_SITE_ID AND PRL.REQUISITION_LINE_ID (+) = MKA.DOCUMENT_DETAIL_ID AND PRH.REQUISITION_HEADER_ID (+) = PRL.REQUISITION_HEADER_ID AND MKA.DOCUMENT_TYPE = 3 AND WIP.LINE_ID (+) = MKA.WIP_LINE_ID AND '_SEC:MKA.ORGANIZATION_ID' IS NOT NULL UNION /* where DOCUMENT_TYPE (is Move Order) = 4 */ SELECT MKA.KANBAN_ACTIVITY_ID, MKA.REPLENISHMENT_CYCLE_ID, MKA.KANBAN_CARD_ID, MKA.KANBAN_CARD_NUMBER, MKA.INVENTORY_ITEM_ID, '_KF:INV:MSTK:MSI', MKA.ORGANIZATION_ID, MP1.ORGANIZATION_CODE, HOU1.NAME, MKA.SUBINVENTORY_NAME, '_LA:MKA.SUPPLY_STATUS:MFG_LOOKUPS:MTL_KANBAN_SUPPLY_STATUS:MEANING' , '_LA:MKA.CARD_STATUS:MFG_LOOKUPS:MTL_KANBAN_CARD_STATUS:MEANING', '_LA:MKA.KANBAN_CARD_TYPE:MFG_LOOKUPS:MTL_KANBAN_CARD_TYPE:MEANING', '_LA:MKA.SOURCE_TYPE:MFG_LOOKUPS:MTL_KANBAN_SOURCE_TYPE:MEANING', MKA.KANBAN_SIZE, MKA.LOCATOR_ID, '_KF:INV:MTLL:MIL1', MKA.SUPPLIER_ID, POV.VENDOR_NAME SUPPLIER_NAME, MKA.SUPPLIER_SITE_ID, POS.VENDOR_SITE_CODE SUPPLIER_SITE_CODE, MKA.SOURCE_ORGANIZATION_ID, MP2.ORGANIZATION_CODE, HOU2.NAME, MKA.SOURCE_SUBINVENTORY, MKA.SOURCE_LOCATOR_ID, '_KF:INV:MTLL:MIL2', /* KEYFLEX */ '_LA:MKA.DOCUMENT_TYPE:MFG_LOOKUPS:MTL_KANBAN_DOCUMENT_TYPE:MEANING' , /* LOOKUP */ MKA.DOCUMENT_HEADER_ID, MTRH.REQUEST_NUMBER, MKA.DOCUMENT_DETAIL_ID, TO_CHAR(MTRL.LINE_NUMBER), '_LA:MKA.ERROR_CODE:MFG_LOOKUPS:MTL_KANBAN_ERROR_CODE:MEANING', /* LOOKUP */ MKA.LAST_PRINT_DATE, MKA.CREATED_BY, MKA.CREATION_DATE, MKA.LAST_UPDATED_BY, MKA.LAST_UPDATE_DATE, MKA.WIP_LINE_ID, WIP.LINE_CODE FROM MTL_TXN_REQUEST_HEADERS MTRH, MTL_TXN_REQUEST_LINES MTRL, PO_VENDORS POV, PO_VENDOR_SITES_ALL POS, MTL_ITEM_LOCATIONS MIL1, MTL_ITEM_LOCATIONS MIL2, HR_ALL_ORGANIZATION_UNITS HOU1, HR_ALL_ORGANIZATION_UNITS HOU2, MTL_PARAMETERS MP1, MTL_PARAMETERS MP2, MTL_SYSTEM_ITEMS MSI, WIP_LINES WIP, MTL_KANBAN_CARD_ACTIVITY MKA WHERE MP1.ORGANIZATION_ID = MKA.ORGANIZATION_ID AND MP2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID AND HOU1.ORGANIZATION_ID = MKA.ORGANIZATION_ID AND HOU2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID = MKA.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = MKA.ORGANIZATION_ID AND MIL1.INVENTORY_LOCATION_ID (+) = MKA.LOCATOR_ID AND MIL1.ORGANIZATION_ID (+) = MKA.ORGANIZATION_ID AND MIL2.INVENTORY_LOCATION_ID (+) = MKA.SOURCE_LOCATOR_ID AND MIL2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID AND POV.VENDOR_ID (+) = MKA.SUPPLIER_ID AND POS.VENDOR_SITE_ID (+) = MKA.SUPPLIER_SITE_ID AND MTRL.LINE_ID (+) = MKA.DOCUMENT_DETAIL_ID AND MTRH.HEADER_ID (+) =MTRL.HEADER_ID AND MKA.DOCUMENT_TYPE = 4 AND WIP.LINE_ID (+) = MKA.WIP_LINE_ID AND '_SEC:MKA.ORGANIZATION_ID' IS NOT NULL UNION /* where DOCUMENT_TYPE (is Discrete Job, Repetitive Schedule, Flow Schedule ) = 5,6,7 */ SELECT MKA.KANBAN_ACTIVITY_ID, MKA.REPLENISHMENT_CYCLE_ID, MKA.KANBAN_CARD_ID, MKA.KANBAN_CARD_NUMBER, MKA.INVENTORY_ITEM_ID, '_KF:INV:MSTK:MSI', MKA.ORGANIZATION_ID, MP1.ORGANIZATION_CODE, HOU1.NAME, MKA.SUBINVENTORY_NAME, '_LA:MKA.SUPPLY_STATUS:MFG_LOOKUPS:MTL_KANBAN_SUPPLY_STATUS:MEANING' , '_LA:MKA.CARD_STATUS:MFG_LOOKUPS:MTL_KANBAN_CARD_STATUS:MEANING', '_LA:MKA.KANBAN_CARD_TYPE:MFG_LOOKUPS:MTL_KANBAN_CARD_TYPE:MEANING', '_LA:MKA.SOURCE_TYPE:MFG_LOOKUPS:MTL_KANBAN_SOURCE_TYPE:MEANING', MKA.KANBAN_SIZE, MKA.LOCATOR_ID, '_KF:INV:MTLL:MIL1', MKA.SUPPLIER_ID, POV.VENDOR_NAME SUPPLIER_NAME, MKA.SUPPLIER_SITE_ID, POS.VENDOR_SITE_CODE SUPPLIER_SITE_CODE, MKA.SOURCE_ORGANIZATION_ID, MP2.ORGANIZATION_CODE, HOU2.NAME, MKA.SOURCE_SUBINVENTORY, MKA.SOURCE_LOCATOR_ID, '_KF:INV:MTLL:MIL2', /* KEYFLEX */ '_LA:MKA.DOCUMENT_TYPE:MFG_LOOKUPS:MTL_KANBAN_DOCUMENT_TYPE:MEANING' , /* LOOKUP */ MKA.DOCUMENT_HEADER_ID, WE.WIP_ENTITY_NAME, MKA.DOCUMENT_DETAIL_ID, NULL, '_LA:MKA.ERROR_CODE:MFG_LOOKUPS:MTL_KANBAN_ERROR_CODE:MEANING', /* LOOKUP */ MKA.LAST_PRINT_DATE, MKA.CREATED_BY, MKA.CREATION_DATE, MKA.LAST_UPDATED_BY, MKA.LAST_UPDATE_DATE, MKA.WIP_LINE_ID, WIP.LINE_CODE FROM WIP_ENTITIES WE, PO_VENDORS POV, PO_VENDOR_SITES_ALL POS, MTL_ITEM_LOCATIONS MIL1, MTL_ITEM_LOCATIONS MIL2, HR_ALL_ORGANIZATION_UNITS HOU1, HR_ALL_ORGANIZATION_UNITS HOU2, MTL_PARAMETERS MP1, MTL_PARAMETERS MP2, MTL_SYSTEM_ITEMS MSI, WIP_LINES WIP, MTL_KANBAN_CARD_ACTIVITY MKA WHERE MP1.ORGANIZATION_ID = MKA.ORGANIZATION_ID AND MP2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID AND HOU1.ORGANIZATION_ID = MKA.ORGANIZATION_ID AND HOU2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID = MKA.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = MKA.ORGANIZATION_ID AND MIL1.INVENTORY_LOCATION_ID (+) = MKA.LOCATOR_ID AND MIL1.ORGANIZATION_ID (+) = MKA.ORGANIZATION_ID AND MIL2.INVENTORY_LOCATION_ID (+) = MKA.SOURCE_LOCATOR_ID AND MIL2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID AND POV.VENDOR_ID (+) = MKA.SUPPLIER_ID AND POS.VENDOR_SITE_ID (+) = MKA.SUPPLIER_SITE_ID AND WE.WIP_ENTITY_ID (+) = MKA.DOCUMENT_HEADER_ID AND MKA.DOCUMENT_TYPE in (5,6,7) AND WIP.LINE_ID (+) = MKA.WIP_LINE_ID AND '_SEC:MKA.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT MKA.KANBAN_ACTIVITY_ID
, MKA.REPLENISHMENT_CYCLE_ID
, MKA.KANBAN_CARD_ID
, MKA.KANBAN_CARD_NUMBER
, MKA.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI'
, /* KEYFLEX */ MKA.ORGANIZATION_ID
, MP1.ORGANIZATION_CODE
, HOU1.NAME
, MKA.SUBINVENTORY_NAME
, '_LA:MKA.SUPPLY_STATUS:MFG_LOOKUPS:MTL_KANBAN_SUPPLY_STATUS:MEANING'
, /* LOOKUP */ '_LA:MKA.CARD_STATUS:MFG_LOOKUPS:MTL_KANBAN_CARD_STATUS:MEANING'
, /* LOOKUP */ '_LA:MKA.KANBAN_CARD_TYPE:MFG_LOOKUPS:MTL_KANBAN_CARD_TYPE:MEANING'
, /* LOOKUP */ '_LA:MKA.SOURCE_TYPE:MFG_LOOKUPS:MTL_KANBAN_SOURCE_TYPE:MEANING'
, /* LOOKUP */ MKA.KANBAN_SIZE
, MKA.LOCATOR_ID
, '_KF:INV:MTLL:MIL1'
, /* KEYFLEX */ MKA.SUPPLIER_ID
, POV.VENDOR_NAME SUPPLIER_NAME
, MKA.SUPPLIER_SITE_ID
, POS.VENDOR_SITE_CODE SUPPLIER_SITE_CODE
, MKA.SOURCE_ORGANIZATION_ID
, MP2.ORGANIZATION_CODE
, HOU2.NAME
, MKA.SOURCE_SUBINVENTORY
, MKA.SOURCE_LOCATOR_ID
, '_KF:INV:MTLL:MIL2'
, /* KEYFLEX */ '_LA:MKA.DOCUMENT_TYPE:MFG_LOOKUPS:MTL_KANBAN_DOCUMENT_TYPE:MEANING'
, /* LOOKUP */ MKA.DOCUMENT_HEADER_ID
, NULL
, MKA.DOCUMENT_DETAIL_ID
, NULL
, '_LA:MKA.ERROR_CODE:MFG_LOOKUPS:MTL_KANBAN_ERROR_CODE:MEANING'
, /* LOOKUP */ MKA.LAST_PRINT_DATE
, MKA.CREATED_BY
, MKA.CREATION_DATE
, MKA.LAST_UPDATED_BY
, MKA.LAST_UPDATE_DATE
, MKA.WIP_LINE_ID
, WIP.LINE_CODE
FROM PO_VENDORS POV
, PO_VENDOR_SITES_ALL POS
, MTL_ITEM_LOCATIONS MIL1
, MTL_ITEM_LOCATIONS MIL2
, HR_ALL_ORGANIZATION_UNITS HOU1
, HR_ALL_ORGANIZATION_UNITS HOU2
, MTL_PARAMETERS MP1
, MTL_PARAMETERS MP2
, MTL_SYSTEM_ITEMS MSI
, WIP_LINES WIP
, MTL_KANBAN_CARD_ACTIVITY MKA
WHERE MP1.ORGANIZATION_ID = MKA.ORGANIZATION_ID
AND MP2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID
AND HOU1.ORGANIZATION_ID = MKA.ORGANIZATION_ID
AND HOU2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MKA.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MKA.ORGANIZATION_ID
AND MIL1.INVENTORY_LOCATION_ID (+) = MKA.LOCATOR_ID
AND MIL1.ORGANIZATION_ID (+) = MKA.ORGANIZATION_ID
AND MIL2.INVENTORY_LOCATION_ID (+) = MKA.SOURCE_LOCATOR_ID
AND MIL2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID
AND POV.VENDOR_ID (+) = MKA.SUPPLIER_ID
AND POS.VENDOR_SITE_ID (+) = MKA.SUPPLIER_SITE_ID
AND MKA.DOCUMENT_TYPE IS NULL
AND WIP.LINE_ID (+) = MKA.WIP_LINE_ID
AND '_SEC:MKA.ORGANIZATION_ID' IS NOT NULL UNION /*
WHERE DOCUMENT_TYPE (IS PO) = 1 */ SELECT MKA.KANBAN_ACTIVITY_ID
, MKA.REPLENISHMENT_CYCLE_ID
, MKA.KANBAN_CARD_ID
, MKA.KANBAN_CARD_NUMBER
, MKA.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI'
, /* KEYFLEX */ MKA.ORGANIZATION_ID
, MP1.ORGANIZATION_CODE
, HOU1.NAME
, MKA.SUBINVENTORY_NAME
, '_LA:MKA.SUPPLY_STATUS:MFG_LOOKUPS:MTL_KANBAN_SUPPLY_STATUS:MEANING'
, /* LOOKUP */ '_LA:MKA.CARD_STATUS:MFG_LOOKUPS:MTL_KANBAN_CARD_STATUS:MEANING'
, /* LOOKUP */ '_LA:MKA.KANBAN_CARD_TYPE:MFG_LOOKUPS:MTL_KANBAN_CARD_TYPE:MEANING'
, /* LOOKUP */ '_LA:MKA.SOURCE_TYPE:MFG_LOOKUPS:MTL_KANBAN_SOURCE_TYPE:MEANING'
, /* LOOKUP */ MKA.KANBAN_SIZE
, MKA.LOCATOR_ID
, '_KF:INV:MTLL:MIL1'
, /* KEYFLEX */ MKA.SUPPLIER_ID
, POV.VENDOR_NAME SUPPLIER_NAME
, MKA.SUPPLIER_SITE_ID
, POS.VENDOR_SITE_CODE SUPPLIER_SITE_CODE
, MKA.SOURCE_ORGANIZATION_ID
, MP2.ORGANIZATION_CODE
, HOU2.NAME
, MKA.SOURCE_SUBINVENTORY
, MKA.SOURCE_LOCATOR_ID
, '_KF:INV:MTLL:MIL2'
, /* KEYFLEX */ '_LA:MKA.DOCUMENT_TYPE:MFG_LOOKUPS:MTL_KANBAN_DOCUMENT_TYPE:MEANING'
, /* LOOKUP */ MKA.DOCUMENT_HEADER_ID
, POH.SEGMENT1
, MKA.DOCUMENT_DETAIL_ID
, TO_CHAR(POL.LINE_NUM)||'-'||TO_CHAR(PLL.SHIPMENT_NUM)||'-'|| TO_CHAR (POD.DISTRIBUTION_NUM)
, '_LA:MKA.ERROR_CODE:MFG_LOOKUPS:MTL_KANBAN_ERROR_CODE:MEANING'
, /* LOOKUP */ MKA.LAST_PRINT_DATE
, MKA.CREATED_BY
, MKA.CREATION_DATE
, MKA.LAST_UPDATED_BY
, MKA.LAST_UPDATE_DATE
, MKA.WIP_LINE_ID
, WIP.LINE_CODE
FROM PO_DISTRIBUTIONS_ALL POD
, PO_HEADERS_ALL POH
, PO_LINES_ALL POL
, PO_LINE_LOCATIONS_ALL PLL
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL POS
, HR_ALL_ORGANIZATION_UNITS HOU1
, HR_ALL_ORGANIZATION_UNITS HOU2
, MTL_ITEM_LOCATIONS MIL1
, MTL_ITEM_LOCATIONS MIL2
, MTL_PARAMETERS MP1
, MTL_PARAMETERS MP2
, MTL_SYSTEM_ITEMS MSI
, WIP_LINES WIP
, MTL_KANBAN_CARD_ACTIVITY MKA
WHERE MP1.ORGANIZATION_ID = MKA.ORGANIZATION_ID
AND MP2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID
AND HOU1.ORGANIZATION_ID = MKA.ORGANIZATION_ID
AND HOU2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MKA.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MKA.ORGANIZATION_ID
AND MIL1.INVENTORY_LOCATION_ID (+) = MKA.LOCATOR_ID
AND MIL1.ORGANIZATION_ID (+) = MKA.ORGANIZATION_ID
AND MIL2.INVENTORY_LOCATION_ID (+) = MKA.SOURCE_LOCATOR_ID
AND MIL2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID
AND POV.VENDOR_ID (+) = MKA.SUPPLIER_ID
AND POS.VENDOR_SITE_ID (+) = MKA.SUPPLIER_SITE_ID
AND POD.PO_DISTRIBUTION_ID (+) = MKA.DOCUMENT_DETAIL_ID
AND POH.PO_HEADER_ID (+) = POD.PO_HEADER_ID
AND POL.PO_LINE_ID (+) = POD.PO_LINE_ID
AND PLL.LINE_LOCATION_ID (+) = POD.LINE_LOCATION_ID
AND MKA.DOCUMENT_TYPE = 1
AND WIP.LINE_ID (+) = MKA.WIP_LINE_ID
AND '_SEC:MKA.ORGANIZATION_ID' IS NOT NULL UNION /*
WHERE DOCUMENT_TYPE (IS BLANKET RELEASE) = 2 */ SELECT MKA.KANBAN_ACTIVITY_ID
, MKA.REPLENISHMENT_CYCLE_ID
, MKA.KANBAN_CARD_ID
, MKA.KANBAN_CARD_NUMBER
, MKA.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI'
, /* KEYFLEX */ MKA.ORGANIZATION_ID
, MP1.ORGANIZATION_CODE
, HOU1.NAME
, MKA.SUBINVENTORY_NAME
, '_LA:MKA.SUPPLY_STATUS:MFG_LOOKUPS:MTL_KANBAN_SUPPLY_STATUS:MEANING'
, /* LOOKUP */ '_LA:MKA.CARD_STATUS:MFG_LOOKUPS:MTL_KANBAN_CARD_STATUS:MEANING'
, /* LOOKUP */ '_LA:MKA.KANBAN_CARD_TYPE:MFG_LOOKUPS:MTL_KANBAN_CARD_TYPE:MEANING'
, /* LOOKUP */ '_LA:MKA.SOURCE_TYPE:MFG_LOOKUPS:MTL_KANBAN_SOURCE_TYPE:MEANING'
, /* LOOKUP */ MKA.KANBAN_SIZE
, MKA.LOCATOR_ID
, '_KF:INV:MTLL:MIL1'
, /* KEYFLEX */ MKA.SUPPLIER_ID
, POV.VENDOR_NAME SUPPLIER_NAME
, MKA.SUPPLIER_SITE_ID
, POS.VENDOR_SITE_CODE SUPPLIER_SITE_CODE
, MKA.SOURCE_ORGANIZATION_ID
, MP2.ORGANIZATION_CODE
, HOU2.NAME
, MKA.SOURCE_SUBINVENTORY
, MKA.SOURCE_LOCATOR_ID
, '_KF:INV:MTLL:MIL2'
, /* KEYFLEX */ '_LA:MKA.DOCUMENT_TYPE:MFG_LOOKUPS:MTL_KANBAN_DOCUMENT_TYPE:MEANING'
, /* LOOKUP */ MKA.DOCUMENT_HEADER_ID
, POH.SEGMENT1
, MKA.DOCUMENT_DETAIL_ID
, TO_CHAR(POR.RELEASE_NUM)||'-'||TO_CHAR(PLL.SHIPMENT_NUM)||'-'|| TO_CHAR (POD.DISTRIBUTION_NUM)
, '_LA:MKA.ERROR_CODE:MFG_LOOKUPS:MTL_KANBAN_ERROR_CODE:MEANING'
, /* LOOKUP */ MKA.LAST_PRINT_DATE
, MKA.CREATED_BY
, MKA.CREATION_DATE
, MKA.LAST_UPDATED_BY
, MKA.LAST_UPDATE_DATE
, MKA.WIP_LINE_ID
, WIP.LINE_CODE
FROM PO_DISTRIBUTIONS_ALL POD
, PO_HEADERS_ALL POH
, PO_RELEASES_ALL POR
, PO_LINE_LOCATIONS_ALL PLL
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL POS
, MTL_ITEM_LOCATIONS MIL1
, MTL_ITEM_LOCATIONS MIL2
, HR_ALL_ORGANIZATION_UNITS HOU1
, HR_ALL_ORGANIZATION_UNITS HOU2
, MTL_PARAMETERS MP1
, MTL_PARAMETERS MP2
, MTL_SYSTEM_ITEMS MSI
, WIP_LINES WIP
, MTL_KANBAN_CARD_ACTIVITY MKA
WHERE MP1.ORGANIZATION_ID = MKA.ORGANIZATION_ID
AND MP2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID
AND HOU1.ORGANIZATION_ID = MKA.ORGANIZATION_ID
AND HOU2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MKA.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MKA.ORGANIZATION_ID
AND MIL1.INVENTORY_LOCATION_ID (+) = MKA.LOCATOR_ID
AND MIL1.ORGANIZATION_ID (+) = MKA.ORGANIZATION_ID
AND MIL2.INVENTORY_LOCATION_ID (+) = MKA.SOURCE_LOCATOR_ID
AND MIL2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID
AND POV.VENDOR_ID (+) = MKA.SUPPLIER_ID
AND POS.VENDOR_SITE_ID (+) = MKA.SUPPLIER_SITE_ID
AND POD.PO_DISTRIBUTION_ID (+) = MKA.DOCUMENT_DETAIL_ID
AND POH.PO_HEADER_ID (+) = POD.PO_HEADER_ID
AND POR.PO_RELEASE_ID (+) = POD.PO_RELEASE_ID
AND PLL.LINE_LOCATION_ID (+) = POD.LINE_LOCATION_ID
AND MKA.DOCUMENT_TYPE = 2
AND WIP.LINE_ID (+) = MKA.WIP_LINE_ID
AND '_SEC:MKA.ORGANIZATION_ID' IS NOT NULL UNION /*
WHERE DOCUMENT_TYPE (IS INTERNAL REQUISITION) = 3 */ SELECT MKA.KANBAN_ACTIVITY_ID
, MKA.REPLENISHMENT_CYCLE_ID
, MKA.KANBAN_CARD_ID
, MKA.KANBAN_CARD_NUMBER
, MKA.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI'
, /* KEYFLEX */ MKA.ORGANIZATION_ID
, MP1.ORGANIZATION_CODE
, HOU1.NAME
, MKA.SUBINVENTORY_NAME
, '_LA:MKA.SUPPLY_STATUS:MFG_LOOKUPS:MTL_KANBAN_SUPPLY_STATUS:MEANING'
, /* LOOKUP */ '_LA:MKA.CARD_STATUS:MFG_LOOKUPS:MTL_KANBAN_CARD_STATUS:MEANING'
, /* LOOKUP */ '_LA:MKA.KANBAN_CARD_TYPE:MFG_LOOKUPS:MTL_KANBAN_CARD_TYPE:MEANING'
, /* LOOKUP */ '_LA:MKA.SOURCE_TYPE:MFG_LOOKUPS:MTL_KANBAN_SOURCE_TYPE:MEANING'
, /* LOOKUP */ MKA.KANBAN_SIZE
, MKA.LOCATOR_ID
, '_KF:INV:MTLL:MIL1'
, /* KEYFLEX */ MKA.SUPPLIER_ID
, POV.VENDOR_NAME SUPPLIER_NAME
, MKA.SUPPLIER_SITE_ID
, POS.VENDOR_SITE_CODE SUPPLIER_SITE_CODE
, MKA.SOURCE_ORGANIZATION_ID
, MP2.ORGANIZATION_CODE
, HOU2.NAME
, MKA.SOURCE_SUBINVENTORY
, MKA.SOURCE_LOCATOR_ID
, '_KF:INV:MTLL:MIL2'
, /* KEYFLEX */ '_LA:MKA.DOCUMENT_TYPE:MFG_LOOKUPS:MTL_KANBAN_DOCUMENT_TYPE:MEANING'
, /* LOOKUP */ MKA.DOCUMENT_HEADER_ID
, PRH.SEGMENT1
, MKA.DOCUMENT_DETAIL_ID
, TO_CHAR (PRL.LINE_NUM)
, '_LA:MKA.ERROR_CODE:MFG_LOOKUPS:MTL_KANBAN_ERROR_CODE:MEANING'
, /* LOOKUP */ MKA.LAST_PRINT_DATE
, MKA.CREATED_BY
, MKA.CREATION_DATE
, MKA.LAST_UPDATED_BY
, MKA.LAST_UPDATE_DATE
, MKA.WIP_LINE_ID
, WIP.LINE_CODE
FROM PO_REQUISITION_HEADERS_ALL PRH
, PO_REQUISITION_LINES_ALL PRL
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL POS
, MTL_ITEM_LOCATIONS MIL1
, MTL_ITEM_LOCATIONS MIL2
, HR_ALL_ORGANIZATION_UNITS HOU1
, HR_ALL_ORGANIZATION_UNITS HOU2
, MTL_PARAMETERS MP1
, MTL_PARAMETERS MP2
, MTL_SYSTEM_ITEMS MSI
, WIP_LINES WIP
, MTL_KANBAN_CARD_ACTIVITY MKA
WHERE MP1.ORGANIZATION_ID = MKA.ORGANIZATION_ID
AND MP2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID
AND HOU1.ORGANIZATION_ID = MKA.ORGANIZATION_ID
AND HOU2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MKA.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MKA.ORGANIZATION_ID
AND MIL1.INVENTORY_LOCATION_ID (+) = MKA.LOCATOR_ID
AND MIL1.ORGANIZATION_ID (+) = MKA.ORGANIZATION_ID
AND MIL2.INVENTORY_LOCATION_ID (+) = MKA.SOURCE_LOCATOR_ID
AND MIL2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID
AND POV.VENDOR_ID (+) = MKA.SUPPLIER_ID
AND POS.VENDOR_SITE_ID (+) = MKA.SUPPLIER_SITE_ID
AND PRL.REQUISITION_LINE_ID (+) = MKA.DOCUMENT_DETAIL_ID
AND PRH.REQUISITION_HEADER_ID (+) = PRL.REQUISITION_HEADER_ID
AND MKA.DOCUMENT_TYPE = 3
AND WIP.LINE_ID (+) = MKA.WIP_LINE_ID
AND '_SEC:MKA.ORGANIZATION_ID' IS NOT NULL UNION /*
WHERE DOCUMENT_TYPE (IS MOVE ORDER) = 4 */ SELECT MKA.KANBAN_ACTIVITY_ID
, MKA.REPLENISHMENT_CYCLE_ID
, MKA.KANBAN_CARD_ID
, MKA.KANBAN_CARD_NUMBER
, MKA.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI'
, MKA.ORGANIZATION_ID
, MP1.ORGANIZATION_CODE
, HOU1.NAME
, MKA.SUBINVENTORY_NAME
, '_LA:MKA.SUPPLY_STATUS:MFG_LOOKUPS:MTL_KANBAN_SUPPLY_STATUS:MEANING'
, '_LA:MKA.CARD_STATUS:MFG_LOOKUPS:MTL_KANBAN_CARD_STATUS:MEANING'
, '_LA:MKA.KANBAN_CARD_TYPE:MFG_LOOKUPS:MTL_KANBAN_CARD_TYPE:MEANING'
, '_LA:MKA.SOURCE_TYPE:MFG_LOOKUPS:MTL_KANBAN_SOURCE_TYPE:MEANING'
, MKA.KANBAN_SIZE
, MKA.LOCATOR_ID
, '_KF:INV:MTLL:MIL1'
, MKA.SUPPLIER_ID
, POV.VENDOR_NAME SUPPLIER_NAME
, MKA.SUPPLIER_SITE_ID
, POS.VENDOR_SITE_CODE SUPPLIER_SITE_CODE
, MKA.SOURCE_ORGANIZATION_ID
, MP2.ORGANIZATION_CODE
, HOU2.NAME
, MKA.SOURCE_SUBINVENTORY
, MKA.SOURCE_LOCATOR_ID
, '_KF:INV:MTLL:MIL2'
, /* KEYFLEX */ '_LA:MKA.DOCUMENT_TYPE:MFG_LOOKUPS:MTL_KANBAN_DOCUMENT_TYPE:MEANING'
, /* LOOKUP */ MKA.DOCUMENT_HEADER_ID
, MTRH.REQUEST_NUMBER
, MKA.DOCUMENT_DETAIL_ID
, TO_CHAR(MTRL.LINE_NUMBER)
, '_LA:MKA.ERROR_CODE:MFG_LOOKUPS:MTL_KANBAN_ERROR_CODE:MEANING'
, /* LOOKUP */ MKA.LAST_PRINT_DATE
, MKA.CREATED_BY
, MKA.CREATION_DATE
, MKA.LAST_UPDATED_BY
, MKA.LAST_UPDATE_DATE
, MKA.WIP_LINE_ID
, WIP.LINE_CODE
FROM MTL_TXN_REQUEST_HEADERS MTRH
, MTL_TXN_REQUEST_LINES MTRL
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL POS
, MTL_ITEM_LOCATIONS MIL1
, MTL_ITEM_LOCATIONS MIL2
, HR_ALL_ORGANIZATION_UNITS HOU1
, HR_ALL_ORGANIZATION_UNITS HOU2
, MTL_PARAMETERS MP1
, MTL_PARAMETERS MP2
, MTL_SYSTEM_ITEMS MSI
, WIP_LINES WIP
, MTL_KANBAN_CARD_ACTIVITY MKA
WHERE MP1.ORGANIZATION_ID = MKA.ORGANIZATION_ID
AND MP2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID
AND HOU1.ORGANIZATION_ID = MKA.ORGANIZATION_ID
AND HOU2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MKA.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MKA.ORGANIZATION_ID
AND MIL1.INVENTORY_LOCATION_ID (+) = MKA.LOCATOR_ID
AND MIL1.ORGANIZATION_ID (+) = MKA.ORGANIZATION_ID
AND MIL2.INVENTORY_LOCATION_ID (+) = MKA.SOURCE_LOCATOR_ID
AND MIL2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID
AND POV.VENDOR_ID (+) = MKA.SUPPLIER_ID
AND POS.VENDOR_SITE_ID (+) = MKA.SUPPLIER_SITE_ID
AND MTRL.LINE_ID (+) = MKA.DOCUMENT_DETAIL_ID
AND MTRH.HEADER_ID (+) =MTRL.HEADER_ID
AND MKA.DOCUMENT_TYPE = 4
AND WIP.LINE_ID (+) = MKA.WIP_LINE_ID
AND '_SEC:MKA.ORGANIZATION_ID' IS NOT NULL UNION /*
WHERE DOCUMENT_TYPE (IS DISCRETE JOB
, REPETITIVE SCHEDULE
, FLOW SCHEDULE ) = 5
, 6
, 7 */ SELECT MKA.KANBAN_ACTIVITY_ID
, MKA.REPLENISHMENT_CYCLE_ID
, MKA.KANBAN_CARD_ID
, MKA.KANBAN_CARD_NUMBER
, MKA.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI'
, MKA.ORGANIZATION_ID
, MP1.ORGANIZATION_CODE
, HOU1.NAME
, MKA.SUBINVENTORY_NAME
, '_LA:MKA.SUPPLY_STATUS:MFG_LOOKUPS:MTL_KANBAN_SUPPLY_STATUS:MEANING'
, '_LA:MKA.CARD_STATUS:MFG_LOOKUPS:MTL_KANBAN_CARD_STATUS:MEANING'
, '_LA:MKA.KANBAN_CARD_TYPE:MFG_LOOKUPS:MTL_KANBAN_CARD_TYPE:MEANING'
, '_LA:MKA.SOURCE_TYPE:MFG_LOOKUPS:MTL_KANBAN_SOURCE_TYPE:MEANING'
, MKA.KANBAN_SIZE
, MKA.LOCATOR_ID
, '_KF:INV:MTLL:MIL1'
, MKA.SUPPLIER_ID
, POV.VENDOR_NAME SUPPLIER_NAME
, MKA.SUPPLIER_SITE_ID
, POS.VENDOR_SITE_CODE SUPPLIER_SITE_CODE
, MKA.SOURCE_ORGANIZATION_ID
, MP2.ORGANIZATION_CODE
, HOU2.NAME
, MKA.SOURCE_SUBINVENTORY
, MKA.SOURCE_LOCATOR_ID
, '_KF:INV:MTLL:MIL2'
, /* KEYFLEX */ '_LA:MKA.DOCUMENT_TYPE:MFG_LOOKUPS:MTL_KANBAN_DOCUMENT_TYPE:MEANING'
, /* LOOKUP */ MKA.DOCUMENT_HEADER_ID
, WE.WIP_ENTITY_NAME
, MKA.DOCUMENT_DETAIL_ID
, NULL
, '_LA:MKA.ERROR_CODE:MFG_LOOKUPS:MTL_KANBAN_ERROR_CODE:MEANING'
, /* LOOKUP */ MKA.LAST_PRINT_DATE
, MKA.CREATED_BY
, MKA.CREATION_DATE
, MKA.LAST_UPDATED_BY
, MKA.LAST_UPDATE_DATE
, MKA.WIP_LINE_ID
, WIP.LINE_CODE
FROM WIP_ENTITIES WE
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL POS
, MTL_ITEM_LOCATIONS MIL1
, MTL_ITEM_LOCATIONS MIL2
, HR_ALL_ORGANIZATION_UNITS HOU1
, HR_ALL_ORGANIZATION_UNITS HOU2
, MTL_PARAMETERS MP1
, MTL_PARAMETERS MP2
, MTL_SYSTEM_ITEMS MSI
, WIP_LINES WIP
, MTL_KANBAN_CARD_ACTIVITY MKA
WHERE MP1.ORGANIZATION_ID = MKA.ORGANIZATION_ID
AND MP2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID
AND HOU1.ORGANIZATION_ID = MKA.ORGANIZATION_ID
AND HOU2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MKA.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MKA.ORGANIZATION_ID
AND MIL1.INVENTORY_LOCATION_ID (+) = MKA.LOCATOR_ID
AND MIL1.ORGANIZATION_ID (+) = MKA.ORGANIZATION_ID
AND MIL2.INVENTORY_LOCATION_ID (+) = MKA.SOURCE_LOCATOR_ID
AND MIL2.ORGANIZATION_ID (+) = MKA.SOURCE_ORGANIZATION_ID
AND POV.VENDOR_ID (+) = MKA.SUPPLIER_ID
AND POS.VENDOR_SITE_ID (+) = MKA.SUPPLIER_SITE_ID
AND WE.WIP_ENTITY_ID (+) = MKA.DOCUMENT_HEADER_ID
AND MKA.DOCUMENT_TYPE IN (5
, 6
, 7)
AND WIP.LINE_ID (+) = MKA.WIP_LINE_ID
AND '_SEC:MKA.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY