DBA Data[Home] [Help]

APPS.QA_PLAN_ELEMENT_API dependencies on MTL_ITEM_UOMS_VIEW

Line 2066: FROM mtl_item_uoms_view

2062: x_uom_code IN VARCHAR2) RETURN BOOLEAN IS
2063:
2064: CURSOR c IS
2065: SELECT 1
2066: FROM mtl_item_uoms_view
2067: WHERE inventory_item_id = x_item_id AND
2068: organization_id = x_org_id AND
2069: uom_code = x_uom_code;
2070:

Line 3348: FROM mtl_item_uoms_view

3344:
3345: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);
3346:
3347: sql_string := 'SELECT uom_code, description
3348: FROM mtl_item_uoms_view
3349: WHERE inventory_item_id = :1
3350: AND organization_id = :2
3351: AND uom_code like :3
3352: ORDER BY uom_code';