PO Unit of Measure Listing
Description
Categories: BI Publisher
Application: Purchasing
Source: Unit of Measure Listing (XML)
Short Name: POXSURUM_XML
DB package: PO_POXSURUM_XMLP_PKG
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 |