DBA Data[Home] [Help]

APPS.PO_UOM_SV2 dependencies on MTL_SYSTEM_ITEMS

Line 113: FROM mtl_system_items msi

109: SELECT nvl(msi.unit_of_issue, NULL),
110: nvl(msi.rounding_factor, NULL)
111: INTO x_unit_of_issue,
112: x_rounding_factor
113: FROM mtl_system_items msi
114: WHERE msi.inventory_item_id = x_item_id
115: AND msi.organization_id = x_source_org_id;
116:
117: if ((x_unit_of_issue is null) or

Line 177: mtl_system_items msi,

173: pri.unit_of_measure,
174: msi.unit_of_issue,
175: msi.rounding_factor
176: from po_requisitions_interface pri,
177: mtl_system_items msi,
178: mtl_units_of_measure uoms,
179: mtl_units_of_measure uomd
180: where msi.inventory_item_id = pri.item_id
181: AND msi.organization_id = pri.source_organization_id