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