EAM Material Issue Request Pick List

Description
Categories: Administration, BI Publisher
Application: Enterprise Asset Management
Source: Material Issue Request Pick List Report (XML)
Short Name: EAMMIRPKL_XML
DB package: EAM_EAMMIPCK_XMLP_PKG
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
Org_id
 
Number
Sort By
 
LOV Oracle
Requestor
 
LOV Oracle
Material
 
LOV Oracle
Work Order
 
LOV Oracle
Source Locator
 
Source Subinventory
 
LOV Oracle
Date Required To
 
LOV Oracle
Date Required From
 
LOV Oracle
Request Number To
 
LOV Oracle
Request Number From
 
LOV Oracle