View: SO_ORDER_STATUS_V

Product:	OE - Order Entry
Description:
Implementation/DBA Data:	APPS.SO_ORDER_STATUS_V

View Text

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)

Columns