1. Tables and Views for SCM
  2. MSC_DIM_TASK_V

MSC_DIM_TASK_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

ID

NAME

Query

SQL_Statement

SELECT

mav.attribute_dest_value_id ID,

mav.attribute_value NAME

FROM

fusion.msc_attribute_values mav where mav.attribute_number = 2 and mav.plan_id = -1

UNION ALL

SELECT

mav.attribute_dest_value_id ID,

MSC_COLL_RELEASE_UTILS.GET_MESSAGE_DETAILS

(P_PRD_CODE => 'MSC',

P_MSG_NAME => 'MSC_SP_MPM_NO_TASK',

P_TOKEN_NAME => NULL,

P_TOKEN_VALUE => NULL

) NAME

FROM

fusion.msc_attribute_values mav where mav.attribute_number = 1 and mav.plan_id = -1