EAM Material Issue Request Pick List

SELECT	
 mmtt.inventory_item_id
	,mmtt.revision
	,mmtt.subinventory_code fr_subinv
	,mmtt.locator_id
	,pjm_project.all_proj_idtonum(mrl.project_id) as project_id 
	,(select task_number from mtl_task_v where task_id=mrl.task_id and rownum=1) as task_id
	,mmtt.item_primary_uom_code primary_uom 
	,mmtt.operation_seq_num                                           
	,abs(mmtt.primary_quantity) primary_qty
	,milk.concatenated_segments locator                              
	,mrl.request_number                                              
	,mrl.line_number	                                         
	,mrl.created_by                                                  
	,mrl.date_required	
	,mrl.line_id                                                     
	,msik.concatenated_segments item_name                            
	,msik.description item_description                               
	,fnd.user_name requester                                         
	,'Allocated'  Move_order_Status                                   
	,wewov.wip_entity_name
	,wro.comments, 
	EAM_EAMMIPCK_XMLP_PKG.cf_refformula() CF_ref, 
	EAM_EAMMIPCK_XMLP_PKG.cf_qty_pickedformula() CF_qty_picked, 
	EAM_EAMMIPCK_XMLP_PKG.cf_reasonformula() CF_reason
FROM
      mtl_material_transactions_temp mmtt
     ,mtl_txn_request_lines_v mrl
     ,mtl_item_locations_kfv milk
     ,fnd_user fnd
	,wip_eam_work_orders_v wewov
	,mtl_system_items_kfv msik
	,wip_requirement_operations wro
WHERE
	mmtt.organization_id = :p_org_id
and     mmtt.move_order_line_id = mrl.line_id
and     mmtt.organization_id = milk.organization_id(+)
and     mmtt.locator_id = milk.inventory_location_id(+)
and	nvl(mmtt.primary_quantity,0) > 0
and     mrl.created_by = fnd.user_id
and     wewov.wip_entity_id=mmtt.transaction_source_id
and	wewov.ORGANIZATION_ID = mmtt.ORGANIZATION_ID
and	wewov.status_type in(3,4,5,6)
and	mmtt.inventory_item_id = msik.INVENTORY_ITEM_ID
and	mmtt.organization_id=msik.ORGANIZATION_ID
and	mmtt.organization_id=wro.organization_id
and	mmtt.inventory_item_id=wro.inventory_item_id
and	mmtt.operation_seq_num=wro.operation_seq_num
and             mmtt.transaction_source_id=wro.wip_entity_id
and	mrl.move_order_type=5  
and	mrl.line_status=7      
and	&p_where_clause
order by &p_order_by