VIEW: APPS.OKI_SOLD_ITEM_LINES_V

Source

View Text - Preformatted

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.duration ,sil.period ,sil.sts_code ,sts.meaning status_meaning ,sil.ste_code ,ste.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 ,itm.name ,sil.item_id ,itm.description ,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,FND_LOOKUPS STE,OKC_STATUSES_V STS,OKX_SYSTEM_ITEMS_V ITM WHERE sts.code = sil.sts_code and ste.lookup_code = sil.ste_code and ste.lookup_type = 'OKC_STATUS_TYPE' and trn.lookup_code(+) = sil.trn_code and trn.lookup_type(+) = 'OKC_TERMINATION_REASON' and itm.id1 = sil.item_id and itm.id2 = sil.inventory_organization_id and okc_util.get_k_access_level(sil.chr_id, sil.scs_code) in ('R','U')

View Text - HTML Formatted

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.DURATION
, SIL.PERIOD
, SIL.STS_CODE
, STS.MEANING STATUS_MEANING
, SIL.STE_CODE
, STE.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
, ITM.NAME
, SIL.ITEM_ID
, ITM.DESCRIPTION
, 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
, FND_LOOKUPS STE
, OKC_STATUSES_V STS
, OKX_SYSTEM_ITEMS_V ITM
WHERE STS.CODE = SIL.STS_CODE
AND STE.LOOKUP_CODE = SIL.STE_CODE
AND STE.LOOKUP_TYPE = 'OKC_STATUS_TYPE'
AND TRN.LOOKUP_CODE(+) = SIL.TRN_CODE
AND TRN.LOOKUP_TYPE(+) = 'OKC_TERMINATION_REASON'
AND ITM.ID1 = SIL.ITEM_ID
AND ITM.ID2 = SIL.INVENTORY_ORGANIZATION_ID
AND OKC_UTIL.GET_K_ACCESS_LEVEL(SIL.CHR_ID
, SIL.SCS_CODE) IN ('R'
, 'U')