VIEW: APPS.FLM_KANBAN_CONFLICT_RES_V

Source

View Text - Preformatted

SELECT MKPS1.ROWID, MKPS1.pull_sequence_id, MKPS1.inventory_item_id, MSI.concatenated_segments, MSI.description, MKPS1.subinventory_name || MRP_GET_LOCATION.location(MKPS1.locator_id, MKPS1.organization_id), MKPS1.source_subinventory, MRP_GET_LOCATION.location(MKPS1.source_locator_id, MKPS1.source_organization_id), MKPS1.source_type, MKPS1.source_organization_id, MKPS1.wip_line_id, MKPS1.supplier_id, MKPS1.supplier_site_id, MKPS1.number_of_cards, MKPS1.kanban_size, MKPS2.source_subinventory, MRP_GET_LOCATION.location(MKPS2.source_locator_id, MKPS2.source_organization_id), MKPS2.number_of_cards, MKPS2.kanban_size, MKPS2.source_type, MKPS2.source_organization_id, MKPS2.wip_line_id, MKPS2.supplier_id, MKPS2.supplier_site_id FROM mtl_kanban_pull_sequences MKPS1, mtl_kanban_pull_sequences MKPS2, mtl_system_items_kfv MSI WHERE MSI.inventory_item_id = MKPS2.inventory_item_id AND MSI.organization_id = MKPS2.organization_id AND MKPS2.organization_id = MKPS1.organization_id AND MKPS2.inventory_item_id = MKPS1.inventory_item_id AND MKPS2.subinventory_name = MKPS1.subinventory_name AND nvl(MKPS1.locator_id, -1) = nvl(MKPS2.locator_id, -1) AND MKPS2.kanban_plan_id = -1 AND MKPS1.kanban_plan_id > 0

View Text - HTML Formatted

SELECT MKPS1.ROWID
, MKPS1.PULL_SEQUENCE_ID
, MKPS1.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION
, MKPS1.SUBINVENTORY_NAME || MRP_GET_LOCATION.LOCATION(MKPS1.LOCATOR_ID
, MKPS1.ORGANIZATION_ID)
, MKPS1.SOURCE_SUBINVENTORY
, MRP_GET_LOCATION.LOCATION(MKPS1.SOURCE_LOCATOR_ID
, MKPS1.SOURCE_ORGANIZATION_ID)
, MKPS1.SOURCE_TYPE
, MKPS1.SOURCE_ORGANIZATION_ID
, MKPS1.WIP_LINE_ID
, MKPS1.SUPPLIER_ID
, MKPS1.SUPPLIER_SITE_ID
, MKPS1.NUMBER_OF_CARDS
, MKPS1.KANBAN_SIZE
, MKPS2.SOURCE_SUBINVENTORY
, MRP_GET_LOCATION.LOCATION(MKPS2.SOURCE_LOCATOR_ID
, MKPS2.SOURCE_ORGANIZATION_ID)
, MKPS2.NUMBER_OF_CARDS
, MKPS2.KANBAN_SIZE
, MKPS2.SOURCE_TYPE
, MKPS2.SOURCE_ORGANIZATION_ID
, MKPS2.WIP_LINE_ID
, MKPS2.SUPPLIER_ID
, MKPS2.SUPPLIER_SITE_ID
FROM MTL_KANBAN_PULL_SEQUENCES MKPS1
, MTL_KANBAN_PULL_SEQUENCES MKPS2
, MTL_SYSTEM_ITEMS_KFV MSI
WHERE MSI.INVENTORY_ITEM_ID = MKPS2.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MKPS2.ORGANIZATION_ID
AND MKPS2.ORGANIZATION_ID = MKPS1.ORGANIZATION_ID
AND MKPS2.INVENTORY_ITEM_ID = MKPS1.INVENTORY_ITEM_ID
AND MKPS2.SUBINVENTORY_NAME = MKPS1.SUBINVENTORY_NAME
AND NVL(MKPS1.LOCATOR_ID
, -1) = NVL(MKPS2.LOCATOR_ID
, -1)
AND MKPS2.KANBAN_PLAN_ID = -1
AND MKPS1.KANBAN_PLAN_ID > 0