Product: | OKE - Project Contracts |
---|---|
Description: | View for contract change requests |
Implementation/DBA Data: | APPS.OKE_CHG_REQUESTS_V |
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 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