VIEW: APPS.SO_ORDER_STATUS_V

Source

View Text - Preformatted

SELECT /*+ INDEX(A SO_ACTIONS_U2) INDEX(H SO_HEADERS_U1) INDEX(R SO_RESULTS_U1) */ H.HEADER_ID ORDER_SOURCE_ID , A.ACTION_ID ACTION_ID , A.NAME ACTION , R.NAME RESULT , SL.MEANING ACTION_LEVEL , 'ORDER' ACTION_CODE , 0 DUMMY_ID , DECODE( A.RESULT_COLUMN, 'S1', H.S1_DATE, 'S2', H.S2_DATE, 'S3', H.S3_DATE, 'S4', H.S4_DATE, 'S5', H.S5_DATE, 'S6', H.S6_DATE, 'S7', H.S7_DATE, 'S8', H.S8_DATE, 'S9', H.S9_DATE, 'S10', H.S10_DATE, 'S11', H.S11_DATE, 'S12', H.S12_DATE, 'S13', H.S13_DATE, 'S14', H.S14_DATE, 'S15', H.S15_DATE, 'S16', H.S16_DATE, 'S17', H.S17_DATE, 'S18', H.S18_DATE, 'S19', H.S19_DATE, 'S20', H.S20_DATE, 'S21', H.S21_DATE, 'S22', H.S22_DATE, 'S23', H.S23_DATE, 'S24', H.S24_DATE, 'S25', H.S25_DATE, 'S26', H.S26_DATE, 'S27', H.S27_DATE, 'S28', H.S28_DATE, 'S29', H.S29_DATE, 'S30', H.S30_DATE) ACTION_DATE , R.RESULT_ID RESULT_ID , H.CREATION_DATE , H.CREATED_BY , H.LAST_UPDATE_DATE , H.LAST_UPDATED_BY , H.LAST_UPDATE_LOGIN , H.ROWID ROW_ID FROM SO_ACTIONS A , SO_RESULTS R , SO_HEADERS H , SO_LOOKUPS SL WHERE A.RESULT_TABLE = 'SO_HEADERS' AND SL.LOOKUP_TYPE='SO_ACTION_LEVEL' AND SL.LOOKUP_CODE='SO_HEADERS' AND R.RESULT_ID = DECODE( A.RESULT_COLUMN, 'S1', H.S1, 'S2', H.S2, 'S3', H.S3, 'S4', H.S4, 'S5', H.S5, 'S6', H.S6, 'S7', H.S7, 'S8', H.S8, 'S9', H.S9, 'S10', H.S10, 'S11', H.S11, 'S12', H.S12, 'S13', H.S13, 'S14', H.S14, 'S15', H.S15, 'S16', H.S16, 'S17', H.S17, 'S18', H.S18, 'S19', H.S19, 'S20', H.S20, 'S21', H.S21, 'S22', H.S22, 'S23', H.S23, 'S24', H.S24, 'S25', H.S25, 'S26', H.S26, 'S27', H.S27, 'S28', H.S28, 'S29', H.S29, 'S30', H.S30) UNION SELECT /*+ INDEX(A SO_ACTIONS_U2) INDEX(L SO_LINES_U1) INDEX(R SO_RESULTS_U1) */ L.LINE_ID ORDER_SOURCE_ID , A.ACTION_ID ACTION_ID , A.NAME ACTION , R.NAME RESULT , SL.MEANING ACTION_LEVEL , 'LINE' ACTION_CODE , 0 DUMMY_ID , 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 RESULT_ID , L.CREATION_DATE , L.CREATED_BY , L.LAST_UPDATE_DATE , L.LAST_UPDATED_BY , L.LAST_UPDATE_LOGIN , L.ROWID ROW_ID FROM SO_ACTIONS A , SO_RESULTS R , SO_LINES L , SO_LOOKUPS SL WHERE (A.RESULT_TABLE = 'SO_LINES' OR A.ACTION_ID=1) AND SL.LOOKUP_TYPE='SO_ACTION_LEVEL' AND SL.LOOKUP_CODE='SO_LINES' 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 /*+ INDEX(A SO_ACTIONS_U2) INDEX(H SO_HEADERS_U1) INDEX(R SO_RESULTS_U1) */ H.HEADER_ID ORDER_SOURCE_ID
, A.ACTION_ID ACTION_ID
, A.NAME ACTION
, R.NAME RESULT
, SL.MEANING ACTION_LEVEL
, 'ORDER' ACTION_CODE
, 0 DUMMY_ID
, DECODE( A.RESULT_COLUMN
, 'S1'
, H.S1_DATE
, 'S2'
, H.S2_DATE
, 'S3'
, H.S3_DATE
, 'S4'
, H.S4_DATE
, 'S5'
, H.S5_DATE
, 'S6'
, H.S6_DATE
, 'S7'
, H.S7_DATE
, 'S8'
, H.S8_DATE
, 'S9'
, H.S9_DATE
, 'S10'
, H.S10_DATE
, 'S11'
, H.S11_DATE
, 'S12'
, H.S12_DATE
, 'S13'
, H.S13_DATE
, 'S14'
, H.S14_DATE
, 'S15'
, H.S15_DATE
, 'S16'
, H.S16_DATE
, 'S17'
, H.S17_DATE
, 'S18'
, H.S18_DATE
, 'S19'
, H.S19_DATE
, 'S20'
, H.S20_DATE
, 'S21'
, H.S21_DATE
, 'S22'
, H.S22_DATE
, 'S23'
, H.S23_DATE
, 'S24'
, H.S24_DATE
, 'S25'
, H.S25_DATE
, 'S26'
, H.S26_DATE
, 'S27'
, H.S27_DATE
, 'S28'
, H.S28_DATE
, 'S29'
, H.S29_DATE
, 'S30'
, H.S30_DATE) ACTION_DATE
, R.RESULT_ID RESULT_ID
, H.CREATION_DATE
, H.CREATED_BY
, H.LAST_UPDATE_DATE
, H.LAST_UPDATED_BY
, H.LAST_UPDATE_LOGIN
, H.ROWID ROW_ID
FROM SO_ACTIONS A
, SO_RESULTS R
, SO_HEADERS H
, SO_LOOKUPS SL
WHERE A.RESULT_TABLE = 'SO_HEADERS'
AND SL.LOOKUP_TYPE='SO_ACTION_LEVEL'
AND SL.LOOKUP_CODE='SO_HEADERS'
AND R.RESULT_ID = DECODE( A.RESULT_COLUMN
, 'S1'
, H.S1
, 'S2'
, H.S2
, 'S3'
, H.S3
, 'S4'
, H.S4
, 'S5'
, H.S5
, 'S6'
, H.S6
, 'S7'
, H.S7
, 'S8'
, H.S8
, 'S9'
, H.S9
, 'S10'
, H.S10
, 'S11'
, H.S11
, 'S12'
, H.S12
, 'S13'
, H.S13
, 'S14'
, H.S14
, 'S15'
, H.S15
, 'S16'
, H.S16
, 'S17'
, H.S17
, 'S18'
, H.S18
, 'S19'
, H.S19
, 'S20'
, H.S20
, 'S21'
, H.S21
, 'S22'
, H.S22
, 'S23'
, H.S23
, 'S24'
, H.S24
, 'S25'
, H.S25
, 'S26'
, H.S26
, 'S27'
, H.S27
, 'S28'
, H.S28
, 'S29'
, H.S29
, 'S30'
, H.S30) UNION SELECT /*+ INDEX(A SO_ACTIONS_U2) INDEX(L SO_LINES_U1) INDEX(R SO_RESULTS_U1) */ L.LINE_ID ORDER_SOURCE_ID
, A.ACTION_ID ACTION_ID
, A.NAME ACTION
, R.NAME RESULT
, SL.MEANING ACTION_LEVEL
, 'LINE' ACTION_CODE
, 0 DUMMY_ID
, 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 RESULT_ID
, L.CREATION_DATE
, L.CREATED_BY
, L.LAST_UPDATE_DATE
, L.LAST_UPDATED_BY
, L.LAST_UPDATE_LOGIN
, L.ROWID ROW_ID
FROM SO_ACTIONS A
, SO_RESULTS R
, SO_LINES L
, SO_LOOKUPS SL
WHERE (A.RESULT_TABLE = 'SO_LINES' OR A.ACTION_ID=1)
AND SL.LOOKUP_TYPE='SO_ACTION_LEVEL'
AND SL.LOOKUP_CODE='SO_LINES'
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)