FLM Purge Kanban

select fkp.organization_id,
       fkp.item_id,
       &P_ASSY_FLEX C_ITEM_FLEX,
       fkp.subinventory_code,
       fkp.locator_id,
       decode(nvl(fkp.locator_id,-1),-1,NULL,null) C_LOC_FLEX,
       fkp.type,
       decode(fkp.type,1,'Kanban Cards Purged',2,'Pull Sequences Purged',
                   3,'Exceptions in Purge') ttype,
       fkp.count, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('item_name', 'INV', 'MSTK', 101, MSI1.ORGANIZATION_ID, MSI1.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') ITEM_NAME, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('locator_name', 'INV', 'MTLL', 101, MIL.ORGANIZATION_ID, MIL.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') LOCATOR_NAME
from   flm_kanban_purge_temp fkp,
       mtl_system_items msi1,
       mtl_item_locations mil
where  fkp.organization_id = msi1.organization_id
  and  fkp.item_id = msi1.inventory_item_id
  and  fkp.organization_id = mil.organization_id(+)
  and  nvl(fkp.locator_id,-1) = nvl(mil.inventory_location_id(+),-1)
  and fkp.group_id = :P_CONC_REQUEST_ID
order by fkp.type