CST_XLA_INV_ORG_CST_CATS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name

INVENTORY_ITEM_ID INV_ORG_ID INV_ORG_CST_CATEGORY_ID INV_ORG_CST_CATEGORY_CODE INV_ORG_CST_CATEGORY_NAME INV_ORG_CST_CATEGORY_DESC INV_ORG_CST_CAT_ATTR_CATEGORY INV_ORG_CST_CAT_ATTRIBUTE1 INV_ORG_CST_CAT_ATTRIBUTE2 INV_ORG_CST_CAT_ATTRIBUTE3 INV_ORG_CST_CAT_ATTRIBUTE4 INV_ORG_CST_CAT_ATTRIBUTE5 INV_ORG_CST_CAT_ATTRIBUTE6 INV_ORG_CST_CAT_ATTRIBUTE7 INV_ORG_CST_CAT_ATTRIBUTE8 INV_ORG_CST_CAT_ATTRIBUTE9 INV_ORG_CST_CAT_ATTRIBUTE10 INV_ORG_CST_CAT_ATTRIBUTE11 INV_ORG_CST_CAT_ATTRIBUTE12 INV_ORG_CST_CAT_ATTRIBUTE13 INV_ORG_CST_CAT_ATTRIBUTE14 INV_ORG_CST_CAT_ATTRIBUTE15

Query

SQL_Statement

SELECT inventory_item_id, inv_org_id, inv_org_cst_category_id, inv_org_cst_category_code, inv_org_cst_category_name, inv_org_cst_category_desc, inv_org_cst_cat_attr_category, inv_org_cst_cat_attribute1, inv_org_cst_cat_attribute2, inv_org_cst_cat_attribute3, inv_org_cst_cat_attribute4, inv_org_cst_cat_attribute5, inv_org_cst_cat_attribute6, inv_org_cst_cat_attribute7, inv_org_cst_cat_attribute8, inv_org_cst_cat_attribute9, inv_org_cst_cat_attribute10, inv_org_cst_cat_attribute11, inv_org_cst_cat_attribute12, inv_org_cst_cat_attribute13, inv_org_cst_cat_attribute14, inv_org_cst_cat_attribute15 FROM ( SELECT eic.inventory_item_id inventory_item_id, eic.organization_id inv_org_id, ec.category_id inv_org_cst_category_id, ec.category_code inv_org_cst_category_code, ec.category_name inv_org_cst_category_name, ec.description inv_org_cst_category_desc, ec.attribute_category inv_org_cst_cat_attr_category, ec.attribute1 inv_org_cst_cat_attribute1, ec.attribute2 inv_org_cst_cat_attribute2, ec.attribute3 inv_org_cst_cat_attribute3, ec.attribute4 inv_org_cst_cat_attribute4, ec.attribute5 inv_org_cst_cat_attribute5, ec.attribute6 inv_org_cst_cat_attribute6, ec.attribute7 inv_org_cst_cat_attribute7, ec.attribute8 inv_org_cst_cat_attribute8, ec.attribute9 inv_org_cst_cat_attribute9, ec.attribute10 inv_org_cst_cat_attribute10, ec.attribute11 inv_org_cst_cat_attribute11, ec.attribute12 inv_org_cst_cat_attribute12, ec.attribute13 inv_org_cst_cat_attribute13, ec.attribute14 inv_org_cst_cat_attribute14, ec.attribute15 inv_org_cst_cat_attribute15, ROW_NUMBER() OVER(PARTITION BY eic.inventory_item_id, eic.organization_id, eic.category_set_id ORDER BY eic.item_category_assignment_id DESC) rank FROM egp_categories_vl ec, egp_item_categories eic, egp_default_category_sets edcs, egp_category_sets_b ecs WHERE edcs.functional_area_id = 5 AND edcs.category_set_id = eic.category_set_id AND edcs.category_set_id = ecs.category_set_id AND ec.category_id = eic.category_id ) WHERE rank = 1