EAM Material Issue Request Pick List

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Material issue request pick list report
Application: Enterprise Asset Management
Source: Material Issue Request Pick List Report (XML)
Short Name: EAMMIRPKL_XML
DB package: EAM_EAMMIPCK_XMLP_PKG
Run EAM Material Issue Request Pick List and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Parameter Name SQL text Validation
Request Number From 
 
 LOV Oracle
Request Number To 
 
 LOV Oracle
Date Required From 
 
 LOV Oracle
Date Required To 
 
 LOV Oracle
Source Subinventory 
 
 LOV Oracle
Source Locator 
 
 Char
Work Order 
 
 LOV Oracle
Material 
 
 LOV Oracle
Requestor 
 
 LOV Oracle
Sort By 
 
 LOV Oracle
Download
Blitz Report™

Blitz Report™ provides multiple benefits: