機械翻訳について

MSC_AP_CATEGORY_SETS_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: MSC

• オブジェクト・タイプ: VIEW

列

名前
SR_CATEGORY_SET_ID CATEGORY_SET_NAME DESCRIPTION CONTROL_LEVEL DEFAULT_FLAG START_DATE END_DATE LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY

問合せ

SQL_Statement

SELECT ecs.CATEGORY_SET_ID SR_CATEGORY_SET_ID, ecs.CATEGORY_SET_NAME, ecs.DESCRIPTION, ecs.CONTROL_LEVEL, DECODE( eds.Category_Set_ID, NULL, 2, 1) Default_Flag, trunc(ecs.START_DATE) START_DATE, trunc(ecs.END_DATE) END_DATE, ecs.LAST_UPDATE_DATE, ecs.LAST_UPDATED_BY, ecs.CREATION_DATE, ecs.CREATED_BY FROM egp_category_sets_vl ecs, EGP_DEFAULT_CATEGORY_SETS eds WHERE eds.Category_Set_ID(+) = ecs.Category_Set_ID AND MULT_ITEM_CAT_ASSIGN_FLAG != 'Y' AND CONTROL_LEVEL IN (1) AND CATALOG_CONTENT_CODE = 'LEAF_ITEMS' AND eds.FUNCTIONAL_AREA_ID(+) = 3