Move order header different status and their meaning

select lookup_code, substr(meaning, 1, 60) “Meaning”
from mfg_lookups
where lookup_type = ‘MTL_TXN_REQUEST_STATUS’
order by lookup_code

1 = Incomplete
2 = Pending Approval
3 = Approved
4 = Not Approved
5 = Closed
6 = Cancelled
7 = Pre-Approved
8 = Partially Approved
9 = Cancelled by Source

Advertisements