VIEW: APPS.CS_REPAIR_HISTORY_V

Source

View Text - Preformatted

SELECT /*+ INDEX(LK CS_LOOKUPS_U1) */ HISTORY.ROWID ROW_ID , HISTORY.REPAIR_HISTORY_ID , HISTORY.REPAIR_LINE_ID , HISTORY.LAST_UPDATE_DATE , HISTORY.LAST_UPDATED_BY , HISTORY.CREATION_DATE , HISTORY.CREATED_BY , HISTORY.LAST_UPDATE_LOGIN , HISTORY.REQUEST_ID , HISTORY.TRANSACTION_DATE , HISTORY.STATUS , HISTORY.ATTRIBUTE1 , HISTORY.ATTRIBUTE2 , HISTORY.ATTRIBUTE3 , HISTORY.ATTRIBUTE4 , HISTORY.ATTRIBUTE5 , HISTORY.ATTRIBUTE6 , HISTORY.ATTRIBUTE7 , HISTORY.ATTRIBUTE8 , HISTORY.ATTRIBUTE9 , HISTORY.ATTRIBUTE10 , HISTORY.ATTRIBUTE11 , HISTORY.ATTRIBUTE12 , HISTORY.ATTRIBUTE13 , HISTORY.ATTRIBUTE14 , HISTORY.ATTRIBUTE15 , HISTORY.CONTEXT , LK.MEANING DESCRIPTION , USERS.USER_NAME FROM CS_LOOKUPS LK ,FND_USER USERS ,CS_REPAIR_HISTORY HISTORY WHERE LK.LOOKUP_TYPE = 'REPAIR_STATUS' AND LK.LOOKUP_CODE(+) = HISTORY.STATUS AND USERS.USER_ID (+) = HISTORY.LAST_UPDATED_BY

View Text - HTML Formatted

SELECT /*+ INDEX(LK CS_LOOKUPS_U1) */ HISTORY.ROWID ROW_ID
, HISTORY.REPAIR_HISTORY_ID
, HISTORY.REPAIR_LINE_ID
, HISTORY.LAST_UPDATE_DATE
, HISTORY.LAST_UPDATED_BY
, HISTORY.CREATION_DATE
, HISTORY.CREATED_BY
, HISTORY.LAST_UPDATE_LOGIN
, HISTORY.REQUEST_ID
, HISTORY.TRANSACTION_DATE
, HISTORY.STATUS
, HISTORY.ATTRIBUTE1
, HISTORY.ATTRIBUTE2
, HISTORY.ATTRIBUTE3
, HISTORY.ATTRIBUTE4
, HISTORY.ATTRIBUTE5
, HISTORY.ATTRIBUTE6
, HISTORY.ATTRIBUTE7
, HISTORY.ATTRIBUTE8
, HISTORY.ATTRIBUTE9
, HISTORY.ATTRIBUTE10
, HISTORY.ATTRIBUTE11
, HISTORY.ATTRIBUTE12
, HISTORY.ATTRIBUTE13
, HISTORY.ATTRIBUTE14
, HISTORY.ATTRIBUTE15
, HISTORY.CONTEXT
, LK.MEANING DESCRIPTION
, USERS.USER_NAME
FROM CS_LOOKUPS LK
, FND_USER USERS
, CS_REPAIR_HISTORY HISTORY
WHERE LK.LOOKUP_TYPE = 'REPAIR_STATUS'
AND LK.LOOKUP_CODE(+) = HISTORY.STATUS
AND USERS.USER_ID (+) = HISTORY.LAST_UPDATED_BY