MSC_ITEM_CATEGORIES_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ORGANIZATION_ID INVENTORY_ITEM_ID CATEGORY_SET_ID CATEGORY_NAME DESCRIPTION SUMMARY_FLAG ENABLED_FLAG START_DATE_ACTIVE END_DATE_ACTIVE SR_INSTANCE_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY

Query

SQL_Statement

SELECT eic.ORGANIZATION_ID, eic.INVENTORY_ITEM_ID, eic.CATEGORY_SET_ID, cat.CATEGORY_NAME, cat.DESCRIPTION, cat.SUMMARY_FLAG, cat.ENABLED_FLAG, cat.START_DATE_ACTIVE, cat.END_DATE_ACTIVE, NULL SR_INSTANCE_ID, eic.LAST_UPDATE_DATE, eic.LAST_UPDATED_BY, eic.CREATION_DATE, eic.CREATED_BY FROM EGP_ITEM_CATEGORIES eic, msc_parameters mp, egp_categories_vl cat where cat.CATEGORY_ID = eic.CATEGORY_ID and mp.organization_id = eic.organization_id