PO Unit of Measure Listing

Description
Categories: BI Publisher, Procurement
Application: Purchasing
Source: Unit of Measure Listing (XML)
Short Name: POXSURUM_XML
DB package: PO_POXSURUM_XMLP_PKG
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
Dynamic Precision Option
 
LOV Oracle
Active/Inactive
 
LOV Oracle
Title