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 INV Item Templates CAC Calculate Average Item Costs INV Inventory Item Upload CAC Open Purchase Orders COPY OF: INV Inventory Item Upload INV Unit of measure listing CAC Item List Price vs. Item Cost CAC PO Price vs. Costing Method Comparison
Blitz Report™

Blitz Report™ provides multiple benefits: