oracle EBS常用值集

--Äê¶È

select b.FLEX_VALUE, b.FLEX_VALUE_ID, b.DESCRIPTION

from apps.FND_FLEX_VALUE_SETS a, apps.fnd_flex_values_vl b

where A.FLEX_VALUE_SET_ID = B.FLEX_VALUE_SET_ID

AND A.flex_value_set_name = 'PS_Äê¶È';

--ÃŵêÀàÐÍ

SELECT t.lookup_code, t.meaning

FROM FND_LOOKUP_VALUES T

WHERE T.LOOKUP_TYPE = 'CUSTOMER_CATEGORY'

and nguage = 'ZHS';

--Æ·ÅÆ

SELECT ALL fv.FLEX_VALUE, fv.FLEX_VALUE_ID, fvs.description

FROM FND_FLEX_VALUE_SETS fvs, FND_FLEX_VALUES fv

WHERE (fvs.FLEX_VALUE_SET_NAME = 'PS_²úÆ·Æ·ÅÆ' AND fv.ENABLED_FLAG = 'Y' AND

NVL(fv.END_DATE_ACTIVE, SYSDATE + 1) > SYSDATE)

AND (fvs.FLEX_VALUE_SET_ID = fv.FLEX_VALUE_SET_ID)

ORDER BY fv.FLEX_VALUE;

--·Ö¹«Ë¾ID

select ou.attribute2,

from hr.hr_all_organization_units ou

where ou.attribute5 is not null

and ou.attribute2 is not null;

--Ô·Ý

SELECT LOOKUP_CODE, MEANING, DESCRIPTION

FROM FND_LOOKUP_VALUES_VL

WHERE (nvl('', territory_code) = territory_code or territory_code is null)

and (LOOKUP_TYPE LIKE 'ES_MONTH_NAMES')

and (VIEW_APPLICATION_ID = 3)

and (SECURITY_GROUP_ID = 0)

order by LOOKUP_CODE;

--µÈ¼¶

SELECT t.lookup_code, t.meaning

FROM FND_LOOKUP_VALUES T

WHERE T.LOOKUP_TYPE = 'CUX_DK_SHOPLEVEL'

and nguage = 'ZHS';

--aldo ×éÖ¯

SELECT t.lookup_code, t.meaning

FROM FND_LOOKUP_VALUES T

WHERE T.LOOKUP_TYPE = 'CUX_ALDO_ORG' and nguage = 'ZHS';