PO Unit of Measure Listing

➜ Back to Library
Description
Categories: BI Publisher
Application: Purchasing
Source: Unit of Measure Listing (XML)
Short Name: POXSURUM_XML
DB package: PO_POXSURUM_XMLP_PKG
Run PO Unit of Measure Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT   mum1.uom_class        Unit_Class
,        mum1.uom_code         Abbr
,        mum1.unit_of_measure  Unit
,        mum1.description      Description
,        muc.conversion_rate   Rate
,        mum2.uom_code         Abbr1
,        mum2.unit_of_measure  Unit1
,        mum2.description      Description1
,        mum2.disable_date     Date1
FROM     mtl_units_of_measure mum1
,        mtl_units_of_measure mum2
,        mtl_uom_conversions  muc
WHERE    mum1.uom_class     = mum2.uom_class
AND      mum1.uom_class     = muc.uom_class
AND      mum1.uom_code      = muc.uom_code
AND      mum2.base_uom_flag = 'Y'
AND      ((:P_ACTIVE_INACTIVE = 'BOTH')
OR       (decode(:P_active_inactive
                 ,'ACTIVE',(nvl(muc.disable_date,sysdate+1)-sysdate)
               ) >   0
             AND decode(:P_active_inactive
	, 'ACTIVE', (nvl(mum1.disable_date, sysdate+1) - sysdate)
	 ) > 0)
OR 	(decode(:P_active_inactive
                 ,'INACTIVE',(sysdate-nvl(muc.disable_date,sysdate+1))
	) > 0
	OR decode(:P_active_inactive
	, 'INACTIVE',(sysdate-nvl(mum1.disable_date, sysdate+1))
	) >0))
ORDER BY mum1.unit_of_measure
,        mum2.unit_of_measure
Parameter Name SQL text Validation
Title 
 
 Char
Active/Inactive 
 
 LOV Oracle
Dynamic Precision Option 
 
 LOV Oracle
Download
 
Related Blitz Reports
CAC Internal Order Shipment Margin CAC Invoice Price Variance INV Item Templates CAC Open Purchase Orders INV Unit of measure listing CAC Item List Price vs. Item Cost CAC PO Price vs. Costing Method Comparison CAC Intercompany SO Price List vs. Item Cost Comparison CAC WIP Account Value
Blitz Report™

Blitz Report™ provides multiple benefits: