DBA Data[Home] [Help]

APPS.PO_VAL_LINES2 dependencies on MTL_ITEM_UOMS_VIEW

Line 1259: -- check to see if x_item_unit_of_measure is valid in mtl_item_uoms_view

1255: RAISE;
1256: END item_description;
1257:
1258: -------------------------------------------------------------------------
1259: -- check to see if x_item_unit_of_measure is valid in mtl_item_uoms_view
1260: -------------------------------------------------------------------------
1261: PROCEDURE unit_meas_lookup_code(
1262: p_id_tbl IN po_tbl_number,
1263: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,

Line 1356: FROM mtl_item_uoms_view miuv

1352: AND p_item_id_tbl(i) IS NOT NULL
1353: AND p_unit_meas_lookup_code_tbl(i) IS NOT NULL
1354: AND NOT EXISTS(
1355: SELECT 1
1356: FROM mtl_item_uoms_view miuv
1357: WHERE miuv.inventory_item_id = p_item_id_tbl(i)
1358: AND miuv.organization_id = p_inventory_org_id
1359: AND miuv.unit_of_measure = p_unit_meas_lookup_code_tbl(i));
1360: