mtl_serial_numbers.current_status 取值SQL
mtl_serial_numbers
current_status 取值
ALTER SESSION SET NLS_LANGUAGE='SIMPLIFIED CHINESE';
select fl.lookup_type
,fl.lookup_code
,fl.meaning
,fl.description
,fl.enabled_flag
,fl.start_date_active
,fl.end_date_active
from fnd_lookup_values_vl fl
where fl.lookup_type = 'SERIAL_NUM_STATUS'
LOOKUP_TYPE | LOOKUP_CODE | MEANING | DESCRIPTION | ENABLED_FLAG | START_DATE_ACTIVE | END_DATE_ACTIVE | |
1 | SERIAL_NUM_STATUS | 4 | 从库存发放 | Y | |||
2 | SERIAL_NUM_STATUS | 8 | 在 WIP 中 | 在在制品中 | Y | 2003-7-14 | |
3 | SERIAL_NUM_STATUS | 7 | 在接收中 | Y | 2003-7-14 | ||
4 | SERIAL_NUM_STATUS | 5 | 在途驻留 | Y | |||
5 | SERIAL_NUM_STATUS | 1 | 已定义但尚未使用 | Y | |||
6 | SERIAL_NUM_STATUS | 3 | 驻留在库存中 | Y |
--刘轶鹤