VIEW: APPS.POA_CM_COMMODITY_LOV_V

Source

View Text - Preformatted

SELECT CATEGORY_ID, CONCATENATED_SEGMENTS, DESCRIPTION FROM MTL_CATEGORIES_KFV WHERE STRUCTURE_ID IN ( SELECT structure_id FROM mtl_default_sets_view WHERE functional_area_id = 2 ) WITH READ ONLY

View Text - HTML Formatted

SELECT CATEGORY_ID
, CONCATENATED_SEGMENTS
, DESCRIPTION
FROM MTL_CATEGORIES_KFV
WHERE STRUCTURE_ID IN ( SELECT STRUCTURE_ID
FROM MTL_DEFAULT_SETS_VIEW
WHERE FUNCTIONAL_AREA_ID = 2 ) WITH READ ONLY