View: OKS_CUST_PRODUCTS_V

Product:	OKS - Service Contracts
Description:	This View is Used to Show the Product details in Service Authoring Form. (This is showed at Covered Level For Covered Product)
Implementation/DBA Data:	APPS.OKS_CUST_PRODUCTS_V

View Text

SELECT DISTINCT KLINE.CLE_ID CLE_ID
, KLINE.START_DATE EFFECTIVE_START_DATE
, KLINE.END_DATE EFFECTIVE_END_DATE
, CPROD.NAME PRODUCT_NAME
, CPROD.CURRENT_SERIAL_NUMBER CURRENT_SERIAL_NUMBER
, PSITE.ADDRESS1||PSITE.ADDRESS2||PSITE.ADDRESS3||PSITE.ADDRESS4 ADDRESS
, CPROD.INSTALLATION_DATE INSTALLATION_DATE
, CPROD.QUANTITY QUANTITY
, CPROD.UNIT_OF_MEASURE_CODE UOM_CODE
, CPROD.REFERENCE_NUMBER REFERENCE_NUMBER
, CPROD.ORIGINAL_NET_AMOUNT NET_AMOUNT
FROM OKC_K_LINES_V KLINE
, OKC_K_ITEMS_V KITEM
, OKX_CUSTOMER_PRODUCTS_V CPROD
, OKX_PARTY_SITE_USES_V PSITE
WHERE KLINE.LSE_ID IN (9
, 13)
AND KLINE.ID = KITEM.CLE_ID
AND KITEM.OBJECT1_ID1 = CPROD.ID1
AND KITEM.OBJECT1_ID2 = CPROD.ID2
AND CPROD.ORGANIZATION_ID = SYS_CONTEXT('OKC_CONTEXT'
, 'ORGANIZATION_ID')
AND CPROD.INSTALL_SITE_USE_ID = PSITE.PARTY_SITE_ID(+)

Columns