Master item and Method Group
05/18/00 RML Removed set control value field from properties tab - business_unit.
01/18/99 RML CN800-9.0: View to show Cost Method Group associated with master item
---------------------------------------------------------------------------------------------------
select
a.SETID,
a.INV_ITEM_ID,
a.DESCR,
b.SETID,
a.CM_GROUP,
c.DESCR
FROM PS_MASTER_ITEM_TBL a,
PS_SET_CNTRL_REC b,
PS_CM_GROUP_DEFN c
WHERE
b.SETCNTRLVALUE = a.SETID
and b.RECNAME = 'CM_GROUP_DEFN'
and a.CM_GROUP = c.CM_GROUP
and c.SETID = b.SETID
union select
a.SETID,
a.INV_ITEM_ID,
a.DESCR,
b.SETID,
a.CM_GROUP,
''
FROM PS_MASTER_ITEM_TBL a,
PS_SET_CNTRL_REC b
WHERE
b.SETCNTRLVALUE = a.SETID
and b.RECNAME = 'CM_GROUP_DEFN'
and (a.CM_GROUP = '' or
a.CM_GROUP is null)
--------------------------------------------------------------------------------------------------- |
SETID