--料號主要組織
select a.ORGANIZATION_ID,c.NAME from
MTL_PARAMETERS_VIEW a,HR_ORGANIZATION_INFORMATION b ,HR_ALL_ORGANIZATION_UNITS_TL c
where ORG_INFORMATION_CONTEXT='CLASS' and  ORG_INFORMATION1='INV'
  and a.ORGANIZATION_ID=b.ORGANIZATION_ID
  and a.MASTER_ORGANIZATION_ID=a.ORGANIZATION_ID
  and a.ORGANIZATION_ID=c.ORGANIZATION_ID
  and c.LANGUAGE='ZHT'
 
 
--料號預設分類級
select flx.APPLICATION_ID,flx.ID_FLEX_CODE,flx.ID_FLEX_NAME,
       flxv.ID_FLEX_NUM,flxv.ID_FLEX_STRUCTURE_CODE,flxv.ID_FLEX_STRUCTURE_NAME,
       flx_seg.APPLICATION_COLUMN_NAME ,flx_seg.SEGMENT_NAME ,flx_seg.FLEX_VALUE_SET_ID,
       catset.CATEGORY_SET_ID, catset.CATEGORY_SET_NAME
 from
    FND_ID_FLEXS flx,
    FND_ID_FLEX_STRUCTURES_VL flxv,
    FND_ID_FLEX_SEGMENTS_VL flx_seg ,
    (select CATEGORY_SET_ID,CATEGORY_SET_NAME,
            decode(FUNCTIONAL_AREA_ID,1,'ITEM_CATEGORIES',2,'PO_ITEM_CATEGORY',5,'OPM_COST_CATEGORY','XX') ID_FLEX_STRUCTURE_CODE
       from MTL_DEFAULT_CATEGORY_SETS_FK_V
      where FUNCTIONAL_AREA_ID in (1,2,5)
    ) catset   
where flx.APPLICATION_ID=401 and flx.ID_FLEX_CODE='MCAT'
  and flx.APPLICATION_ID=flxv.APPLICATION_ID
  and flx.ID_FLEX_CODE=flxv.ID_FLEX_CODE
  and flxv.ID_FLEX_STRUCTURE_CODE in ('PO_ITEM_CATEGORY','OPM_COST_CATEGORY','ITEM_CATEGORIES')
  and flxv.ID_FLEX_STRUCTURE_CODE=catset.ID_FLEX_STRUCTURE_CODE
  and flxv.APPLICATION_ID=flx_seg.APPLICATION_ID
  and flxv.ID_FLEX_CODE=flx_seg.ID_FLEX_CODE
  and flxv.ID_FLEX_NUM=flx_seg.ID_FLEX_NUM
arrow
arrow
    全站熱搜

    Nolem 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄