APPS.PO_ITEMS_SV dependencies on MTL_UNITS_OF_MEASURE

Line 359: FROM mtl_units_of_measure mum,

355: X_secondary_default_ind,
356: X_grade_control_flag ,
357: X_secondary_unit_of_measure
358: --
359: FROM mtl_units_of_measure mum,
360: mtl_item_categories mic,
361: mtl_system_items msi,
362: mtl_parameters mpa,
363: mtl_units_of_measure mum2 --

Line 363: mtl_units_of_measure mum2 --

359: FROM mtl_units_of_measure mum,
360: mtl_item_categories mic,
361: mtl_system_items msi,
362: mtl_parameters mpa,
363: mtl_units_of_measure mum2 --
364: WHERE mic.inventory_item_id = X_item_id
365: AND mic.category_set_id = X_category_set_id
366: AND mic.organization_id = X_inventory_organization_id
367: AND msi.organization_id = X_inventory_organization_id

Line 437: FROM mtl_units_of_measure mum,

433: X_secondary_default_ind,
434: X_grade_control_flag ,
435: X_secondary_unit_of_measure
436: --
437: FROM mtl_units_of_measure mum,
438: mtl_item_categories mic,
439: mtl_system_items msi,
440: mtl_units_of_measure mum2 --
441: WHERE msi.inventory_item_id = X_item_id

Line 440: mtl_units_of_measure mum2 --

436: --
437: FROM mtl_units_of_measure mum,
438: mtl_item_categories mic,
439: mtl_system_items msi,
440: mtl_units_of_measure mum2 --
441: WHERE msi.inventory_item_id = X_item_id
442: AND mic.inventory_item_id = X_item_id
443: AND mic.category_set_id = X_category_set_id
444: AND mic.organization_id = X_inventory_organization_id

Line 637: FROM mtl_units_of_measure mum, mtl_system_items msi

633: msi.grade_control_flag,
634: decode(msi.tracking_quantity_ind,
635: g_chktype_TRACKING_QTY_IND_S,mum.unit_of_measure,NULL)
636: INTO X_secondary_default_ind, X_grade_control_flag, X_secondary_unit_of_measure
637: FROM mtl_units_of_measure mum, mtl_system_items msi
638: WHERE msi.organization_id = X_inventory_organization_id
639: AND msi.inventory_item_id = X_item_id
640: AND mum.uom_code(+) = msi.secondary_uom_code ;
641: