--料號主要組織
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'
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
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
全站熱搜
留言列表
Oracle (6)
