CST_XLA_ITEM_CATEGORIES_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name

INVENTORY_ITEM_ID INV_ORG_ID INV_CATEGORY_ID PUR_CATEGORY_ID PLANNING_CATEGORY_ID SERVICE_CATEGORY_ID CST_CATEGORY_ID ENGINEERING_CATEGORY_ID ORDER_ENTRY_CATEGORY_ID PRODUCT_LINE_CATEGORY_ID ASSET_CATEGORY_ID CONTRACTS_CATEGORY_ID PROD_REPO_CATEGORY_ID GDSN_UDEX_CATEGORY_ID PROC_ALLOC_CATEGORY_ID PROC_SEQ_CATEGORY_ID PROC_SUBS_CATEGORY_ID PROC_TECH_CATEGORY_ID PROC_GL_CATEGORY_ID PROC_GL_BUS_CATEGORY_ID PROC_CST_CATEGORY_ID PROC_PL_CATEGORY_ID GDSN_GPC_CATEGORY_ID ITEM_CLASS_CATEGORY_ID SELF_SERVICE_CATEGORY_ID DOO_CATEGORY_ID ORDER_CAPTURE_CATEGORY_ID SUPPLIER_PROD_CATEGORY_ID VAT_CHINA_CATEGORY_ID PRICING_CATEGORY_ID CONFIGURATOR_CATEGORY_ID SFO_CATEGORY_ID SCO_CATEGORY_ID PROD_DEV_CATEGORY_ID

Query

SQL_Statement

SELECT inventory_item_id, inv_org_id, inv_category_id, pur_category_id, planning_category_id, service_category_id, cst_category_id, engineering_category_id, order_entry_category_id, product_line_category_id, asset_category_id, contracts_category_id, prod_repo_category_id, gdsn_udex_category_id, proc_alloc_category_id, proc_seq_category_id, proc_subs_category_id, proc_tech_category_id, proc_gl_category_id, proc_gl_bus_category_id, proc_cst_category_id, proc_pl_category_id, gdsn_gpc_category_id, item_class_category_id, self_service_category_id, doo_category_id, order_capture_category_id, supplier_prod_category_id, vat_china_category_id, pricing_category_id, configurator_category_id, sfo_category_id, sco_category_id, prod_dev_category_id FROM ( SELECT eic.inventory_item_id, eic.organization_id inv_org_id, edcs.functional_area_id, eic.category_id FROM egp_default_category_sets edcs, egp_item_categories eic WHERE eic.category_set_id = edcs.category_set_id ) PIVOT ( MIN(category_id) AS category_id FOR (functional_area_id) IN ( '1' AS inv, '2' AS pur, '3' AS planning, '4' AS service, '5' AS cst, '6' AS engineering, '7' AS order_entry, '8' AS product_line , '9' AS asset, '10' AS contracts, '11' AS prod_repo, '12' AS gdsn_udex, '13' AS proc_alloc, '14' AS proc_seq, '15' AS proc_subs , '16' AS proc_tech, '17' AS proc_gl, '18' AS proc_gl_bus, '19' AS proc_cst, '20' AS proc_pl, '21' AS gdsn_gpc, '22' AS item_class , '23' AS self_service, '24' AS doo, '25' AS order_capture, '26' AS supplier_prod, '28' AS vat_china, '30' AS pricing, '31' AS configurator , '32' AS sfo, '33' AS sco, '34' AS prod_dev ) )