Oracle Certification, Database Administration, SQL, Application, Programming Reference Books
Usage of S flags in SO_HEADERS and SO_LINES

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