Product: | OKE - Project Contracts |
---|---|
Description: | View for Contract holds check - not currently used |
Implementation/DBA Data: | APPS.OKE_HOLD_CHECKS_V |
SELECT EHL.HOLD_ID
, EHL.CREATION_DATE
, EHL.CREATED_BY
, EHL.LAST_UPDATE_DATE
, EHL.LAST_UPDATED_BY
, EHL.LAST_UPDATE_LOGIN
, EHL.K_HEADER_ID
, EHL.K_LINE_ID
, EHL.DELIVERABLE_ID
, EHL.HOLD_TYPE_CODE
, EHL.HOLD_REASON_CODE
, EHL.HOLD_STATUS_CODE
, EHL.HOLD_COMMENT
, EHL.APPLY_DATE
, EHL.SCHEDULE_REMOVE_DATE
, EHL.REMOVE_DATE
, EHL.REMOVE_REASON_CODE
, EHL.REMOVE_COMMENT
, EHL.ATTRIBUTE_CATEGORY
, EHL.ATTRIBUTE1
, EHL.ATTRIBUTE2
, EHL.ATTRIBUTE3
, EHL.ATTRIBUTE4
, EHL.ATTRIBUTE5
, EHL.ATTRIBUTE6
, EHL.ATTRIBUTE7
, EHL.ATTRIBUTE8
, EHL.ATTRIBUTE9
, EHL.ATTRIBUTE10
, EHL.ATTRIBUTE11
, EHL.ATTRIBUTE12
, EHL.ATTRIBUTE13
, EHL.ATTRIBUTE14
, EHL.ATTRIBUTE15
, CHD.CONTRACT_NUMBER
, CLB.LINE_NUMBER
, EDB.DELIVERABLE_NUM
FROM OKE_K_HOLDS EHL
, OKC_K_HEADERS_B CHD
, OKC_K_LINES_B CLB
, OKE_K_DELIVERABLES_B EDB
WHERE CHD.ID = EHL.K_HEADER_ID
AND CLB.ID (+) = EHL.K_LINE_ID
AND EDB.DELIVERABLE_ID (+) = EHL.DELIVERABLE_ID