Asset Categories

Select ffv.flex_value AS "Major_Category"
from apps. FND_FLEX_VALUES ffv,
apps. FND_FLEX_VALUE_SETS ffvs
where
ffvs.FLEX_VALUE_SET_NAME LIKE 'XXFA%MAJOR%CATE%' --Major Categoey name
and ffv.flex_value_set_id=ffvs.flex_value_set_id

Select ffv.flex_value AS "Minor_Category"
from apps. FND_FLEX_VALUES ffv,
apps. FND_FLEX_VALUE_SETS ffvs
where
ffvs.FLEX_VALUE_SET_NAME LIKE 'XXFA%MINOR%CATE%' --Minor Categoey name
and ffv.flex_value_set_id=ffvs.flex_value_set_id

--Definied Categories
Select DESCRIPTION, SEGMENT1, SEGMENT2
from apps.FA_CATEGORIES_VL

--Categories in a book
Select fcv.segment1, fcv.segment2, fcb.DEPRN_EXPENSE_ACCT
from
apps. FA_CATEGORY_BOOKS fcb,
apps.FA_CATEGORIES_VL fcv
where book_type_code='XX-CORP' --Book name
and fcb.category_id=fcv.category_id

Oracle Applications Fusion Cloud - Inventory

Oracle Cloud/Fusion Procurement training will help you develop the fundamental skills required to set up and use the Procurement module. This training covers all the tasks, setups, forms and reports used in Procurement and related modules