DBA Data[Home] [Help]

APPS.QA_PLAN_ELEMENT_API dependencies on MTL_ITEM_UOMS_VIEW

Line 2047: FROM mtl_item_uoms_view

2043: x_uom_code IN VARCHAR2) RETURN BOOLEAN IS
2044:
2045: CURSOR c IS
2046: SELECT 1
2047: FROM mtl_item_uoms_view
2048: WHERE inventory_item_id = x_item_id AND
2049: organization_id = x_org_id AND
2050: uom_code = x_uom_code;
2051:

Line 3256: FROM mtl_item_uoms_view

3252:
3253: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);
3254:
3255: sql_string := 'SELECT uom_code, description
3256: FROM mtl_item_uoms_view
3257: WHERE inventory_item_id = :1
3258: AND organization_id = :2
3259: AND uom_code like :3
3260: ORDER BY uom_code';