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 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 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