APPS.PO_VAL_LINES2 dependencies on PO_UNITS_OF_MEASURE_VAL_V

Line 1365: -- check to see if x_uom_code is valid in po_units_of_measure_val_v

1361: IF (SQL%ROWCOUNT > 0) THEN
1362: x_result_type := po_validations.c_result_type_failure;
1363: END IF;
1364:
1365: -- check to see if x_uom_code is valid in po_units_of_measure_val_v
1366: FORALL i IN 1 .. p_id_tbl.COUNT
1367: INSERT INTO po_validation_results_gt
1368: (result_set_id,
1369: result_type,

Line 1393: FROM po_units_of_measure_val_v pumv

1389: WHERE p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE')
1390: AND p_item_id_tbl(i) IS NULL
1391: AND p_unit_meas_lookup_code_tbl(i) IS NOT NULL
1392: AND NOT EXISTS(SELECT 1
1393: FROM po_units_of_measure_val_v pumv
1394: WHERE pumv.unit_of_measure = p_unit_meas_lookup_code_tbl(i));
1395:
1396: IF (SQL%ROWCOUNT > 0) THEN
1397: x_result_type := po_validations.c_result_type_failure;

Line 3225: -- We need to validate UOM against po_lines_all and po_units_of_measure_val_v

3221: RAISE;
3222: END ip_category_id_update;
3223:
3224: -----------------------------------------------------------------------------
3225: -- We need to validate UOM against po_lines_all and po_units_of_measure_val_v
3226: -----------------------------------------------------------------------------
3227: PROCEDURE uom_update(
3228: p_id_tbl IN po_tbl_number,
3229: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,

Line 3292: po_units_of_measure_val_v pumv

3288: FROM DUAL
3289: WHERE EXISTS(
3290: SELECT 1
3291: FROM po_lines_all pol,
3292: po_units_of_measure_val_v pumv
3293: WHERE po_header_id = p_po_header_id_tbl(i) AND
3294: po_line_id = p_po_line_id_tbl(i) AND
3295: p_unit_meas_lookup_code_tbl(i) IS NOT NULL AND
3296: p_unit_meas_lookup_code_tbl(i) <> NVL(pol.unit_meas_lookup_code,

Line 3302: po_units_of_measure_val_v pumv

3298: pumv.unit_of_measure <> p_unit_meas_lookup_code_tbl(i))
3299: OR EXISTS(
3300: SELECT 1
3301: FROM po_lines_all pol,
3302: po_units_of_measure_val_v pumv
3303: WHERE p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE') AND
3304: po_header_id = p_po_header_id_tbl(i) AND
3305: po_line_id = p_po_line_id_tbl(i) AND
3306: pol.unit_meas_lookup_code IS NULL AND