APPS.PO_WF_PO_NOTIFICATION dependencies on MTL_UNITS_OF_MEASURE

Line 266: TYPE uom_tbl_type IS TABLE OF MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;

262: TYPE shipment_num_tbl_type IS TABLE OF PO_LINE_LOCATIONS.shipment_num%TYPE;
263: TYPE item_num_tbl_type IS TABLE OF MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
264: TYPE item_revision_tbl_type IS TABLE OF PO_LINES.item_revision%TYPE;
265: TYPE item_desc_tbl_type IS TABLE OF PO_LINES.item_description%TYPE;
266: TYPE uom_tbl_type IS TABLE OF MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;
267: TYPE quantity_tbl_type IS TABLE OF PO_LINES.quantity%TYPE;
268: TYPE unit_price_tbl_type IS TABLE OF PO_LINES.unit_price%TYPE;
269: TYPE amount_tbl_type IS TABLE OF PO_LINES.amount%TYPE;
270: TYPE location_tbl_type IS TABLE OF HR_LOCATIONS.location_code%TYPE;

Line 322: mtl_units_of_measure muom, -- bug 2401933.add

318: pol.unit_price,
319: nvl(pol.amount, pol.quantity * pol.unit_price)
320: FROM po_lines pol,
321: mtl_system_items_kfv msi,
322: mtl_units_of_measure muom, -- bug 2401933.add
323: financials_system_parameters fsp
324: WHERE pol.po_header_id = v_document_id
325: AND pol.item_id = msi.inventory_item_id(+)
326: AND NVL(msi.organization_id, fsp.inventory_organization_id) =

Line 391: mtl_units_of_measure muom, -- Bug 2401933.add

387: mtl_system_items_kfv msi,
388: hr_locations_all hrl,
389: hz_locations hz,
390: org_organization_definitions ood,
391: mtl_units_of_measure muom, -- Bug 2401933.add
392: financials_system_parameters fsp
393: where PLL.PO_RELEASE_ID = v_document_id
394: and PLL.po_line_id = POL.po_line_id
395: and PLL.ship_to_location_id = HRL.location_id (+)