DBA Data[Home] [Help]

APPS.PO_UNIT_OF_MEASURES_SV1 dependencies on PO_UNITS_OF_MEASURE_VAL_V

Line 25: /* check to see if x_uom_code is valid in po_units_of_measure_val_v */

21: RETURN FALSE; /* validation fails*/
22: /* must either specify uom_code or unit_of_measure */
23: END IF;
24:
25: /* check to see if x_uom_code is valid in po_units_of_measure_val_v */
26: x_progress := '020';
27:
28: SELECT count(*)
29: INTO x_temp

Line 30: FROM po_units_of_measure_val_v

26: x_progress := '020';
27:
28: SELECT count(*)
29: INTO x_temp
30: FROM po_units_of_measure_val_v
31: WHERE (uom_code = x_uom_code
32: OR
33: X_uom_code IS NULL)
34: AND (unit_of_measure = X_unit_of_measure

Line 107: FROM po_units_of_measure_val_v

103: based on the x_uom_code which is provided from input para. */
104:
105: SELECT unit_of_measure
106: INTO X_unit_of_measure_v
107: FROM po_units_of_measure_val_v
108: WHERE uom_code = X_uom_code;
109:
110: RETURN X_unit_of_measure_v;
111: