ECC Enterprise Asset Management, Stores Work Order (Maintenance), SQL3

Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: eam-store-wo
Query Procedure: EAM_ECC_STORES_WO_UTIL_PVT.GET_ECC_STORES_WO_DL_INFO
Security Procedure: eam_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
Run ECC Enterprise Asset Management, Stores Work Order (Maintenance), SQL3 and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
select * from (select /*+ leading(eswt,EWR) cardinality(eswt 10) */ eswt.ecc_spec_id ECC_SPEC_ID
		,msitl.language LANGUAGE
		,ewr.WIP_ENTITY_ID WIP_ENTITY_ID
		,eswt.wip_entity_name WIP_ENTITY_NAME
		,eswt.operation_seq_num OPERATION_SEQ_NUM
		,eswt.inventory_item_id INVENTORY_ITEM_ID
		,ewr.ORGANIZATION_ID ORGANIZATION_ID
		,ewr.REQUISITION_NUMBER PR_NUMBER
		,ewr.PO_NUMBER PO_NUMBER
		,ewr.PO_STATUS PO_STATUS
		,poh.comments PO_DESCRIPTION
		,rqh.description PR_DESCRIPTION
		,POS_GET.GET_PERSON_NAME_CACHE(poh.AGENT_ID) as BUYER
		,pv.vendor_name SUPPLIER_PURCHASE
		,msitl.description PO_ITEM_DESCRIPTION
		,msi.concatenated_segments PO_ITEM_NAME
		,wdj.status_type STATUS_TYPE
		,mck.concatenated_segments CATEGORY_NAME
from 	eam_wo_req_po_lite_v ewr, po_headers_all poh, po_requisition_headers_all rqh,
	    mtl_system_items_kfv msi, wip_discrete_jobs wdj, mtl_categories_kfv mck,
  	    mtl_system_items_tl msitl, EAM_ECC_STORES_WO_TEMP eswt, po_vendors pv
where 	ewr.po_header_id = poh.po_header_id(+)
	    and ewr.REQUISITION_HEADER_ID = rqh.REQUISITION_HEADER_ID(+)
	    and ewr.item_id = msi.inventory_item_id (+)
		and ewr.organization_id = msi.organization_id (+)
	    and ewr.wip_entity_id =  wdj.wip_entity_id (+)
	    and ewr.CATEGORY_ID = mck.category_id (+)
  	    and msi.inventory_item_id  =  msitl.inventory_item_id
        and msi.organization_id =  msitl.organization_id
        and ewr.wip_entity_id = eswt.wip_entity_id
        and ewr.organization_id = eswt.organization_id
		and ewr.vendor_id = pv.vendor_id(+)
		and msitl.language in ('US'))
PIVOT 	(max(PO_ITEM_DESCRIPTION) as PO_ITEM_DESCRIPTION
for LANGUAGE in ('US' "US"))
) x
where
2=2