View: OKI_COV_PROD_LINES_V

Product:	OKI - Contracts Intelligence
Description:	Information about the covered product lines in service contracts.
Implementation/DBA Data:	APPS.OKI_COV_PROD_LINES_V

View Text

SELECT CPL.CLE_ID CONTRACT_LINE_ID
, CPL.CHR_ID CONTRACT_ID
, CPL.PARENT_CLE_ID PARENT_LINE_ID
, CPL.SCS_CODE
, CPL.CONTRACT_NUMBER CONTRACT_NUMBER
, CPL.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, CPL.COMPLETE_CONTRACT_NUMBER COMPLETE_CONTRACT_NUMBER
, CPL.LINE_NUMBER LINE_NUMBER
, CPL.START_DATE START_DATE
, CPL.END_DATE END_DATE
, CPL.STS_CODE STS_CODE
, STS.MEANING STATUS_MEANING
, CPL.TRN_CODE TRN_CODE
, TRN.MEANING TERMINATION_MEANING
, CPL.DATE_TERMINATED DATE_TERMINATED
, CPL.DATE_RENEWED DATE_RENEWED
, CPL.NUMBER_OF_ITEMS NUMBER_OF_ITEMS
, CPL.UOM_CODE UOM_CODE
, CPL.UNIT_PRICE
, CPL.UNIT_PRICE_PERCENT
, CPL.PRICE_NEGOTIATED PRICE_NEGOTIATED
, CPL.CURRENCY_CODE CURRENCY_CODE
, CPL.PRICE_NEGOTIATED_RENEWED PRICE_NEGOTIATED_RENEWED
, CPL.CURRENCY_CODE_RENEWED CURRENCY_CODE_RENEWED
, CPL.SOB_PRICE_UNIT
, CPL.SOB_PRICE_NEGOTIATED
, CPL.SOB_PRICE_NEGOTIATED_RENEWED
, CPL.SOB_CURRENCY_CODE
, CPL.BASE_PRICE_UNIT
, CPL.BASE_PRICE_NEGOTIATED
, CPL.BASE_PRICE_NEGOTIATED_RENEWED
, CPL.BASE_CURRENCY_CODE
, CPL.SERVICE_ITEM
, CPL.COVERED_PRODUCT_ID
, SIM.DESCRIPTION
, CPL.COV_PROD_QUANTITY
, CPL.COV_PROD_UOM
, CPL.INSTALLATION_DATE
, CPL.COV_PROD_ORDER_DATE
, CPL.COV_PROD_ORDER_NUMBER
, CPL.COV_PROD_ORDER_LINE
, CPL.COV_PROD_NET_AMOUNT
, CPL.COV_PROD_ORDER_LINE_ID
, CPL.SYSTEM_ID
, CPL.PRODUCT_AGREEMENT_ID
, CPL.COV_PROD_BILL_TO_SITE_ID
, CPL.COV_PROD_SHIP_TO_SITE_ID
, CPL.COV_PROD_INSTALL_SITE_ID
, CPL.COV_PROD_BILL_TO_CONTACT_ID
, CPL.COV_PROD_SHIP_TO_CONTACT_ID
, CPL.CREATION_DATE
, CPL.LAST_UPDATE_DATE
, CPL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CPL.ATTRIBUTE1 ATTRIBUTE1
, CPL.ATTRIBUTE2 ATTRIBUTE2
, CPL.ATTRIBUTE3 ATTRIBUTE3
, CPL.ATTRIBUTE4 ATTRIBUTE4
, CPL.ATTRIBUTE5 ATTRIBUTE5
, CPL.ATTRIBUTE6 ATTRIBUTE6
, CPL.ATTRIBUTE7 ATTRIBUTE7
, CPL.ATTRIBUTE8 ATTRIBUTE8
, CPL.ATTRIBUTE9 ATTRIBUTE9
, CPL.ATTRIBUTE10 ATTRIBUTE10
, CPL.ATTRIBUTE11 ATTRIBUTE11
, CPL.ATTRIBUTE12 ATTRIBUTE12
, CPL.ATTRIBUTE13 ATTRIBUTE13
, CPL.ATTRIBUTE14 ATTRIBUTE14
, CPL.ATTRIBUTE15 ATTRIBUTE15
FROM OKI_COV_PRD_LINES CPL
, FND_LOOKUPS TRN
, OKC_STATUSES_V STS
, MTL_SYSTEM_ITEMS_TL SIM
WHERE STS.CODE = CPL.STS_CODE
AND TRN.LOOKUP_CODE(+) = CPL.TRN_CODE
AND TRN.LOOKUP_TYPE(+) = 'OKC_TERMINATION_REASON'
AND SIM.INVENTORY_ITEM_ID = CPL.CUSTOMER_PRODUCT_ITEM_ID
AND SIM.ORGANIZATION_ID = CPL.INVENTORY_ORGANIZATION_ID
AND SIM.LANGUAGE = USERENV('LANG')
AND OKC_UTIL.GET_K_ACCESS_LEVEL(CPL.CHR_ID
, CPL.SCS_CODE) IN ('R'
, 'U')

Columns