VIEW: APPS.SO_ORDER_LINE_STATUS

Source

View Text - Preformatted

SELECT L.LINE_ID LINE_ID , A.NAME ACTION , R.NAME RESULT , DECODE(A.RESULT_COLUMN, 'S1', L.S1_DATE, 'S2', L.S2_DATE, 'S3', L.S3_DATE, 'S4', L.S4_DATE, 'S5', L.S5_DATE, 'S6', L.S6_DATE, 'S7', L.S7_DATE, 'S8', L.S8_DATE, 'S9', L.S9_DATE, 'S10', L.S10_DATE, 'S11', L.S11_DATE, 'S12', L.S12_DATE, 'S13', L.S13_DATE, 'S14', L.S14_DATE, 'S15', L.S15_DATE, 'S16', L.S16_DATE, 'S17', L.S17_DATE, 'S18', L.S18_DATE, 'S19', L.S19_DATE, 'S20', L.S20_DATE, 'S21', L.S21_DATE, 'S22', L.S22_DATE, 'S23', L.S23_DATE, 'S24', L.S24_DATE, 'S25', L.S25_DATE, 'S26', L.S26_DATE, 'S27', L.S27_DATE, 'S28', L.S28_DATE, 'S29', L.S29_DATE, 'S30', L.S30_DATE) ACTION_DATE , R.RESULT_ID from so_lines L, so_results R, so_actions A WHERE (A.RESULT_TABLE = 'SO_LINES' OR A.ACTION_ID=1) AND R.RESULT_ID = DECODE(A.RESULT_COLUMN, 'S1', L.S1, 'S2' , L.S2 , 'S3' , L.S3 , 'S4' , L.S4 , 'S5' , L.S5 , 'S6' , L.S6 , 'S7' , L.S7 , 'S8' , L.S8 , 'S9' , L.S9 , 'S10' , L.S10 , 'S11' , L.S11 , 'S12' , L.S12 , 'S13' , L.S13 , 'S14' , L.S14 , 'S15' , L.S15 , 'S16' , L.S16 , 'S17' , L.S17 , 'S18' , L.S18 , 'S19' , L.S19 , 'S20' , L.S20 , 'S21' , L.S21 , 'S22' , L.S22 , 'S23' , L.S23 , 'S24' , L.S24 , 'S25' , L.S25 , 'S26' , L.S26 , 'S27' , L.S27 , 'S28' , L.S28 , 'S29' , L.S29 , 'S30' , L.S30)

View Text - HTML Formatted

SELECT L.LINE_ID LINE_ID
, A.NAME ACTION
, R.NAME RESULT
, DECODE(A.RESULT_COLUMN
, 'S1'
, L.S1_DATE
, 'S2'
, L.S2_DATE
, 'S3'
, L.S3_DATE
, 'S4'
, L.S4_DATE
, 'S5'
, L.S5_DATE
, 'S6'
, L.S6_DATE
, 'S7'
, L.S7_DATE
, 'S8'
, L.S8_DATE
, 'S9'
, L.S9_DATE
, 'S10'
, L.S10_DATE
, 'S11'
, L.S11_DATE
, 'S12'
, L.S12_DATE
, 'S13'
, L.S13_DATE
, 'S14'
, L.S14_DATE
, 'S15'
, L.S15_DATE
, 'S16'
, L.S16_DATE
, 'S17'
, L.S17_DATE
, 'S18'
, L.S18_DATE
, 'S19'
, L.S19_DATE
, 'S20'
, L.S20_DATE
, 'S21'
, L.S21_DATE
, 'S22'
, L.S22_DATE
, 'S23'
, L.S23_DATE
, 'S24'
, L.S24_DATE
, 'S25'
, L.S25_DATE
, 'S26'
, L.S26_DATE
, 'S27'
, L.S27_DATE
, 'S28'
, L.S28_DATE
, 'S29'
, L.S29_DATE
, 'S30'
, L.S30_DATE) ACTION_DATE
, R.RESULT_ID
FROM SO_LINES L
, SO_RESULTS R
, SO_ACTIONS A
WHERE (A.RESULT_TABLE = 'SO_LINES' OR A.ACTION_ID=1)
AND R.RESULT_ID = DECODE(A.RESULT_COLUMN
, 'S1'
, L.S1
, 'S2'
, L.S2
, 'S3'
, L.S3
, 'S4'
, L.S4
, 'S5'
, L.S5
, 'S6'
, L.S6
, 'S7'
, L.S7
, 'S8'
, L.S8
, 'S9'
, L.S9
, 'S10'
, L.S10
, 'S11'
, L.S11
, 'S12'
, L.S12
, 'S13'
, L.S13
, 'S14'
, L.S14
, 'S15'
, L.S15
, 'S16'
, L.S16
, 'S17'
, L.S17
, 'S18'
, L.S18
, 'S19'
, L.S19
, 'S20'
, L.S20
, 'S21'
, L.S21
, 'S22'
, L.S22
, 'S23'
, L.S23
, 'S24'
, L.S24
, 'S25'
, L.S25
, 'S26'
, L.S26
, 'S27'
, L.S27
, 'S28'
, L.S28
, 'S29'
, L.S29
, 'S30'
, L.S30)