Usage of S flags in SO_HEADERS :
s1 (Entry status)
1=Booked
15=Entered
s2 (Credit review)
2=Pass
3=Fail
s4 (Cancel status)
11=Complete cancel
s6 (Complete status)
10=Closed
18=Eligible
Usage of S flags in SO_LINES:
s1 (Entry status)
1=Booked
15=Entered
s2 (Pick release status)
4=Released
5=Partial
18=Eligible
s3 (Backorder release)
4=Released
5=Partial
18=Eligible
s4 (Ship confirm)
5=Partial
6=Confirmed
7=Backorder complete
22=Backorder partial
18=Eligible
s5 (Receiveable interface)
5=Partial
14=Interfaced
18=Eligible
s6 (Complete status)
18=Eligible
10=Closed
s8 (Inventory interface)
13=Interface error
14=Interfaced
18=Eligible
s9 (Cancel line)
5=Partial
11=Complete
s27 (Manufacturing release)
19=Work Order complete
20=Work Order partial
21=Work Order open
23=Configuration Created
18=Eligible
s28 (Demand interface)
5=Partial
14=Interfaced
18=Eligible
s30 (RMA approval)
2=Pass
3=Fail
Return to : Oracle
Database, SQL, Application, Programming Tips