快速编码表

mfg_lookups视图

 

SELECT * FROM mfg_lookups ml WHERE ml.LOOKUP_TYPE = 'WIP_JOB_STATUS';     工单类型

 

select * from mfg_lookups ml where ml.LOOKUP_TYPE = 'MTL_TRANSACTION_ACTION';     事务处理类型

 

SELECT * FROM mfg_lookups ml WHERE ml.LOOKUP_TYPE = 'WIP_SUPPLY';     供应类型

 

----------------------------------------

FND_LOOKUP_VALUES表

 

SELECT * FROM FND_LOOKUP_VALUES LV;

 

SELECT * FROM FND_LOOKUP_VALUES FV WHERE FV.lookup_type = 'ITEM_TYPE' AND FV.LANGUAGE = USERENV ('LANG');