DBA Data[Home] [Help]

APPS.WMS_CATCH_WEIGHT_PVT dependencies on INV_UI_ITEM_LOVS

Line 5095: SELECT (inv_ui_item_lovs.get_conversion_rate(

5091: print_debug('l_code: ' || l_code, 4);
5092: END IF;
5093:
5094: OPEN x_uoms FOR
5095: SELECT (inv_ui_item_lovs.get_conversion_rate(
5096: uom_code,
5097: p_organization_id,
5098: p_inventory_item_id)) uom_code_comp
5099: , unit_of_measure

Line 5112: ORDER BY inv_ui_item_lovs.conversion_order(

5108: WHERE msi.inventory_item_id = p_inventory_item_id
5109: AND msi.organization_id = p_organization_id
5110: AND muom.uom_code = msi.primary_uom_code)
5111: AND uom_code LIKE (l_code)
5112: ORDER BY inv_ui_item_lovs.conversion_order(
5113: inv_ui_item_lovs.get_conversion_rate(
5114: uom_code
5115: , p_organization_id
5116: , p_inventory_item_id)) asc

Line 5113: inv_ui_item_lovs.get_conversion_rate(

5109: AND msi.organization_id = p_organization_id
5110: AND muom.uom_code = msi.primary_uom_code)
5111: AND uom_code LIKE (l_code)
5112: ORDER BY inv_ui_item_lovs.conversion_order(
5113: inv_ui_item_lovs.get_conversion_rate(
5114: uom_code
5115: , p_organization_id
5116: , p_inventory_item_id)) asc
5117: , UPPER(uom_code);