View: OKE_K_HOLDS_V

Product:	OKE - Project Contracts
Description:	Contract hold information view
Implementation/DBA Data:	APPS.OKE_K_HOLDS_V

View Text

SELECT B.ROWID
, A.K_NUMBER_DISP
, B.HOLD_ID
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.K_HEADER_ID
, B.K_LINE_ID
, B.DELIVERABLE_ID
, B.HOLD_TYPE_CODE
, T.HOLD_TYPE_NAME
, B.HOLD_REASON_CODE
, R.HOLD_REASON_NAME
, B.HOLD_STATUS_CODE
, S.HOLD_STATUS_NAME
, B.HOLD_COMMENT
, B.APPLY_DATE
, B.SCHEDULE_REMOVE_DATE
, B.REMOVE_DATE
, B.REMOVE_REASON_CODE
, RR.REMOVE_REASON_NAME
, B.REMOVE_COMMENT
, B.WF_ITEM_TYPE
, B.WF_PROCESS
, B.WF_ITEM_KEY
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
FROM OKE_K_HEADERS A
, OKE_K_HOLDS B
, ( SELECT LOOKUP_CODE HOLD_TYPE_CODE
, MEANING HOLD_TYPE_NAME
FROM FND_LOOKUP_VALUES_VL
WHERE VIEW_APPLICATION_ID = 777
AND LOOKUP_TYPE = 'HOLD_TYPE' ) T
, ( SELECT LOOKUP_CODE HOLD_REASON_CODE
, MEANING HOLD_REASON_NAME
FROM FND_LOOKUP_VALUES_VL
WHERE VIEW_APPLICATION_ID = 777
AND LOOKUP_TYPE = 'APPLY_HOLD_REASON' ) R
, ( SELECT LOOKUP_CODE REMOVE_REASON_CODE
, MEANING REMOVE_REASON_NAME
FROM FND_LOOKUP_VALUES_VL
WHERE VIEW_APPLICATION_ID = 777
AND LOOKUP_TYPE = 'REMOVE_HOLD_REASON' ) RR
, OKE_HOLD_STATUSES_VL S
WHERE A.K_HEADER_ID = B.K_HEADER_ID
AND R.HOLD_REASON_CODE = B.HOLD_REASON_CODE
AND RR.REMOVE_REASON_CODE (+) = B.REMOVE_REASON_CODE
AND T.HOLD_TYPE_CODE = B.HOLD_TYPE_CODE
AND S.HOLD_STATUS_CODE = B.HOLD_STATUS_CODE

Columns