DBA Data[Home] [Help]

APPS.INVPUPI2 dependencies on MTL_ALL_PRIMARY_UOMS_VV

Line 1179: FROM mtl_all_primary_uoms_vv

1175: IF cr.service_duration_period_code <> l_prev_uom_code THEN
1176: BEGIN
1177: SELECT status
1178: INTO status
1179: FROM mtl_all_primary_uoms_vv
1180: WHERE uom_code = cr.service_duration_period_code
1181: AND uom_class = time_uom_class;
1182: l_serv_dur_per_code_err := 0;
1183: EXCEPTION

Line 1186: --MTL_ALL_PRIMARY_UOMS_VV view contains Stamdard UOM

1182: l_serv_dur_per_code_err := 0;
1183: EXCEPTION
1184: --Fix for bug# 2767335 (details below)
1185: WHEN TOO_MANY_ROWS THEN
1186: --MTL_ALL_PRIMARY_UOMS_VV view contains Stamdard UOM
1187: --conversions and Item Specific UOM conversions.
1188: --Hence for a particular UOM_CODE of an UOM_CLASS
1189: --There can be 2 or more rows in the above view.
1190: --This is a valid case, and hence donot error.