VIEW: APPS.OKE_CHG_REQUESTS_V

Source

View Text - Preformatted

SELECT CRQ.ROWID , CRQ.CHG_REQUEST_ID , CRQ.CREATION_DATE , CRQ.CREATED_BY , CRQ.LAST_UPDATE_DATE , CRQ.LAST_UPDATED_BY , CRQ.LAST_UPDATE_LOGIN , CRQ.K_HEADER_ID , CRQ.CHG_REQUEST_NUM , CRQ.CHG_TYPE_CODE , CHG_TYPE.MEANING , CHG_STAT.CHG_STATUS_TYPE_CODE , CRQ.CHG_STATUS_CODE , CHG_STATT.CHG_STATUS_NAME , CRQ.CHG_REASON_CODE , CHG_REAS.MEANING , CRQ.IMPACT_FUNDING_FLAG , CRQ.EFFECTIVE_DATE , CRQ.REQUESTED_BY_PERSON_ID , PERSON.FULL_NAME , CRQ.REQUESTED_DATE , CRQ.RECEIVE_DATE , CRQ.APPROVE_DATE , CRQ.IMPLEMENT_DATE , CRQ.PREV_VERSION , CRQ.NEW_VERSION , CRQ.DESCRIPTION , CRQ.CHG_TEXT , CRQ.LAST_CHG_LOG_ID , CRQ.ATTRIBUTE_CATEGORY , CRQ.ATTRIBUTE1 , CRQ.ATTRIBUTE2 , CRQ.ATTRIBUTE3 , CRQ.ATTRIBUTE4 , CRQ.ATTRIBUTE5 , CRQ.ATTRIBUTE6 , CRQ.ATTRIBUTE7 , CRQ.ATTRIBUTE8 , CRQ.ATTRIBUTE9 , CRQ.ATTRIBUTE10 , CRQ.ATTRIBUTE11 , CRQ.ATTRIBUTE12 , CRQ.ATTRIBUTE13 , CRQ.ATTRIBUTE14 , CRQ.ATTRIBUTE15 FROM OKE_CHG_REQUESTS CRQ , PER_ALL_PEOPLE_F PERSON , OKE_CHG_STATUSES_B CHG_STAT , OKE_CHG_STATUSES_TL CHG_STATT , FND_LOOKUP_VALUES_VL CHG_TYPE , FND_LOOKUP_VALUES_VL CHG_REAS WHERE PERSON.PERSON_ID = CRQ.REQUESTED_BY_PERSON_ID AND TRUNC(CRQ.REQUESTED_DATE) BETWEEN PERSON.EFFECTIVE_START_DATE AND PERSON.EFFECTIVE_END_DATE AND CHG_STAT.CHG_STATUS_CODE = CRQ.CHG_STATUS_CODE AND CHG_STATT.CHG_STATUS_CODE = CHG_STAT.CHG_STATUS_CODE AND CHG_STATT.LANGUAGE = USERENV('LANG') AND CHG_TYPE.LOOKUP_TYPE = 'CHANGE_TYPE' AND CHG_TYPE.LOOKUP_CODE = CRQ.CHG_TYPE_CODE AND CHG_TYPE.VIEW_APPLICATION_ID = 777 AND CHG_REAS.LOOKUP_TYPE = 'CHANGE_REASON' AND CHG_REAS.LOOKUP_CODE = CRQ.CHG_REASON_CODE AND CHG_REAS.VIEW_APPLICATION_ID = 777

View Text - HTML Formatted

SELECT CRQ.ROWID
, CRQ.CHG_REQUEST_ID
, CRQ.CREATION_DATE
, CRQ.CREATED_BY
, CRQ.LAST_UPDATE_DATE
, CRQ.LAST_UPDATED_BY
, CRQ.LAST_UPDATE_LOGIN
, CRQ.K_HEADER_ID
, CRQ.CHG_REQUEST_NUM
, CRQ.CHG_TYPE_CODE
, CHG_TYPE.MEANING
, CHG_STAT.CHG_STATUS_TYPE_CODE
, CRQ.CHG_STATUS_CODE
, CHG_STATT.CHG_STATUS_NAME
, CRQ.CHG_REASON_CODE
, CHG_REAS.MEANING
, CRQ.IMPACT_FUNDING_FLAG
, CRQ.EFFECTIVE_DATE
, CRQ.REQUESTED_BY_PERSON_ID
, PERSON.FULL_NAME
, CRQ.REQUESTED_DATE
, CRQ.RECEIVE_DATE
, CRQ.APPROVE_DATE
, CRQ.IMPLEMENT_DATE
, CRQ.PREV_VERSION
, CRQ.NEW_VERSION
, CRQ.DESCRIPTION
, CRQ.CHG_TEXT
, CRQ.LAST_CHG_LOG_ID
, CRQ.ATTRIBUTE_CATEGORY
, CRQ.ATTRIBUTE1
, CRQ.ATTRIBUTE2
, CRQ.ATTRIBUTE3
, CRQ.ATTRIBUTE4
, CRQ.ATTRIBUTE5
, CRQ.ATTRIBUTE6
, CRQ.ATTRIBUTE7
, CRQ.ATTRIBUTE8
, CRQ.ATTRIBUTE9
, CRQ.ATTRIBUTE10
, CRQ.ATTRIBUTE11
, CRQ.ATTRIBUTE12
, CRQ.ATTRIBUTE13
, CRQ.ATTRIBUTE14
, CRQ.ATTRIBUTE15
FROM OKE_CHG_REQUESTS CRQ
, PER_ALL_PEOPLE_F PERSON
, OKE_CHG_STATUSES_B CHG_STAT
, OKE_CHG_STATUSES_TL CHG_STATT
, FND_LOOKUP_VALUES_VL CHG_TYPE
, FND_LOOKUP_VALUES_VL CHG_REAS
WHERE PERSON.PERSON_ID = CRQ.REQUESTED_BY_PERSON_ID
AND TRUNC(CRQ.REQUESTED_DATE) BETWEEN PERSON.EFFECTIVE_START_DATE
AND PERSON.EFFECTIVE_END_DATE
AND CHG_STAT.CHG_STATUS_CODE = CRQ.CHG_STATUS_CODE
AND CHG_STATT.CHG_STATUS_CODE = CHG_STAT.CHG_STATUS_CODE
AND CHG_STATT.LANGUAGE = USERENV('LANG')
AND CHG_TYPE.LOOKUP_TYPE = 'CHANGE_TYPE'
AND CHG_TYPE.LOOKUP_CODE = CRQ.CHG_TYPE_CODE
AND CHG_TYPE.VIEW_APPLICATION_ID = 777
AND CHG_REAS.LOOKUP_TYPE = 'CHANGE_REASON'
AND CHG_REAS.LOOKUP_CODE = CRQ.CHG_REASON_CODE
AND CHG_REAS.VIEW_APPLICATION_ID = 777