Product: | OKI - Contracts Intelligence (Obsolete) |
---|---|
Description: | Information about expired contract lines. |
Implementation/DBA Data: | Not implemented in this database |
SELECT ELE.CLE_ID CONTRACT_LINE_ID
, ELE.CHR_ID CONTRACT_ID
, ELE.CONTRACT_NUMBER
, ELE.CONTRACT_NUMBER_MODIFIER
, ELE.COMPLETE_CONTRACT_NUMBER
, ELE.SCS_CODE
, ELE.LINE_NUMBER
, ELE.START_DATE
, ELE.END_DATE
, ELE.STS_CODE
, STS.MEANING STATUS_MEANING
, ELE.TRN_CODE
, TRN.MEANING TERMINATION_MEANING
, ELE.DATE_TERMINATED
, ELE.DATE_RENEWED
, ELE.END_PERIOD_NUM
, ELE.END_PERIOD_NAME
, ELE.END_QUARTER
, ELE.END_YEAR
, ELE.UNIT_PRICE
, ELE.UNIT_PRICE_PERCENT
, ELE.PRICE_NEGOTIATED
, ELE.CURRENCY_CODE
, ELE.PRICE_NEGOTIATED_RENEWED
, ELE.CURRENCY_CODE_RENEWED
, ELE.SOB_PRICE_UNIT
, ELE.SOB_PRICE_NEGOTIATED
, ELE.SOB_PRICE_NEGOTIATED_RENEWED
, ELE.SOB_CURRENCY_CODE
, ELE.BASE_PRICE_UNIT
, ELE.BASE_PRICE_NEGOTIATED
, ELE.BASE_PRICE_NEGOTIATED_RENEWED
, ELE.BASE_CURRENCY_CODE
, ELE.AUTHORING_ORG_ID
, ELE.ORGANIZATION_NAME
, ELE.INVENTORY_ORGANIZATION_ID
, ELE.CREATION_DATE
, ELE.LAST_UPDATE_DATE
, ELE.ATTRIBUTE_CATEGORY
, ELE.ATTRIBUTE1
, ELE.ATTRIBUTE2
, ELE.ATTRIBUTE3
, ELE.ATTRIBUTE4
, ELE.ATTRIBUTE5
, ELE.ATTRIBUTE6
, ELE.ATTRIBUTE7
, ELE.ATTRIBUTE8
, ELE.ATTRIBUTE9
, ELE.ATTRIBUTE10
, ELE.ATTRIBUTE11
, ELE.ATTRIBUTE12
, ELE.ATTRIBUTE13
, ELE.ATTRIBUTE14
, ELE.ATTRIBUTE15
FROM OKI_EXPIRED_LINES ELE
, FND_LOOKUPS TRN
, OKC_STATUSES_V STS
WHERE STS.CODE = ELE.STS_CODE
AND TRN.LOOKUP_CODE(+) = ELE.TRN_CODE
AND TRN.LOOKUP_TYPE(+) = 'OKC_TERMINATION_REASON'
AND OKC_UTIL.GET_K_ACCESS_LEVEL(ELE.CHR_ID
, ELE.SCS_CODE) IN ('R'
, 'U')