MSC_AP_ITEM_CATEGORIES_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
INVENTORY_ITEM_ID ORGANIZATION_ID ORGANIZATION_CODE ITEM_NAME CATEGORY_SET_ID CATEGORY_ID CATEGORY_NAME CATEGORY_SET_NAME CATEGORY_ACTIVE_STATUS

Query

SQL_Statement

SELECT ITEMCATS.inventory_item_id, ORG.organization_id, org.organization_code, ITEMS.item_number item_name, ITEMCATS.category_set_id, ITEMCATS.category_id, cat.category_name, cat.category_set_name, cat.category_active_status FROM egp_item_cat_assignments ITEMCATS, msc_planned_egp_system_items ITEMS, msc_ap_catalog_categories_v cat, inv_org_parameters ORG WHERE ITEMS.inventory_item_id = itemcats.inventory_item_id AND ITEMS.organization_id = ORG.organization_id AND ITEMCATS.organization_id = ORG.master_organization_id AND cat.category_id = ITEMCATS.category_id AND cat.category_set_id = ITEMCATS.category_set_id