1. Tables and Views for SCM
  2. MSS_FS_PROD_LINE_ATTRIBUTES_V

MSS_FS_PROD_LINE_ATTRIBUTES_V

Details

  • Schema: FUSION

  • Object owner: MSS

  • Object type: VIEW

Columns

Name

PLAN_ID

PRODUCTION_LINE_ID

ATTRIBUTES

Query

SQL_Statement

select

pLineAttr.PLAN_ID,

pLineAttr.PRODUCTION_LINE_ID,

('[' || (rtrim((xmlcast(xmlagg(xmlelement(e, pLineAttr.ATTRIBUTE_ID || ',') order by pLineAttr.ATTRIBUTE_ID) as clob)), ',')) || ']') as ATTRIBUTES

from (

select distinct

wo.PLAN_ID,

wo.PRODUCTION_LINE_ID,

opAv.ATTRIBUTE_ID

from MSS_WO_OP_ATTRIBUTE_VALUES opAv

join MSS_WORK_ORDERS wo

on opAv.PLAN_ID = wo.PLAN_ID and opAv.WORK_ORDER_ID = wo.WORK_ORDER_ID

where

wo.PRODUCTION_LINE_ID is not null) pLineAttr

group by

pLineAttr.PLAN_ID, pLineAttr.PRODUCTION_LINE_ID