DBA Data[Home] [Help]

APPS.PO_VAL_LINES2 dependencies on MTL_ITEM_UOMS_VIEW

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

1264: RAISE;
1265: END item_description;
1266:
1267: -------------------------------------------------------------------------
1268: -- check to see if x_item_unit_of_measure is valid in mtl_item_uoms_view
1269: -------------------------------------------------------------------------
1270: PROCEDURE unit_meas_lookup_code(
1271: p_id_tbl IN po_tbl_number,
1272: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,

Line 1365: FROM mtl_item_uoms_view miuv

1361: AND p_item_id_tbl(i) IS NOT NULL
1362: AND p_unit_meas_lookup_code_tbl(i) IS NOT NULL
1363: AND NOT EXISTS(
1364: SELECT 1
1365: FROM mtl_item_uoms_view miuv
1366: WHERE miuv.inventory_item_id = p_item_id_tbl(i)
1367: AND miuv.organization_id = p_inventory_org_id
1368: AND miuv.unit_of_measure = p_unit_meas_lookup_code_tbl(i));
1369: