View: OKS_PROD_DETAILS_V

Product:	OKS - Service Contracts
Description:	Service contracts product details view.
Implementation/DBA Data:	APPS.OKS_PROD_DETAILS_V

View Text

SELECT L.DNZ_CHR_ID CONTRACT_ID
, L.CLE_ID LINE_ID
, L.ID COVD_LINE_ID
, L.LINE_NUMBER COVD_LINE_NUMBER
, L.LSE_ID COVD_LINE_LSE_ID
, LS.NAME COVRED_LEVEL
, NULL COVERED_SYSTEM
, (SELECT CP.CURRENT_SERIAL_NUMBER
FROM CS_CUSTOMER_PRODUCTS_ALL CP
WHERE CP.CUSTOMER_PRODUCT_ID = IT.OBJECT1_ID1) COVERED_SERIAL_NO
, SX.DESCRIPTION COVD_DESCRIPTION
, IT.OBJECT1_ID1 OBJECT_ID
, IT.NUMBER_OF_ITEMS QUANTITY
, IT.UOM_CODE QTY_UOM
, L.PRICE_NEGOTIATED PRICE
FROM OKC_K_HEADERS_B K
, OKC_K_LINES_B L
, OKC_LINE_STYLES_TL LS
, OKC_K_ITEMS IT
, OKX_SYSTEM_ITEMS_V SX
, CS_CUSTOMER_PRODUCTS CP
WHERE L.LSE_ID IN (9
, 18
, 25)
AND L.LSE_ID = LS.ID
AND LS.LANGUAGE = USERENV('LANG')
AND L.DNZ_CHR_ID = IT.DNZ_CHR_ID
AND L.ID = IT.CLE_ID
AND L.CLE_ID IS NOT NULL
AND L.DNZ_CHR_ID = K.ID
AND K.INV_ORGANIZATION_ID = SX.ID2
AND SX.ID1 = CP.INVENTORY_ITEM_ID
AND CP.CUSTOMER_PRODUCT_ID = IT.OBJECT1_ID1 UNION SELECT L.DNZ_CHR_ID CONTRACT_ID
, L.CLE_ID LINE_ID
, L.ID COVD_LINE_ID
, L.LINE_NUMBER COVD_LINE_NUMBER
, L.LSE_ID COVD_LINE_LSE_ID
, LS.NAME COVERED_LEVEL
, NULL COVERED_SYSTEM
, NULL COVERED_SERIAL_NO
, SX.DESCRIPTION COVD_DESCRIPTION
, IT.OBJECT1_ID1 OBJECT_ID
, IT.NUMBER_OF_ITEMS QUANTITY
, IT.UOM_CODE QTY_UOM
, L.PRICE_NEGOTIATED PRICE
FROM OKC_K_LINES_B L
, OKC_LINE_STYLES_TL LS
, OKC_K_ITEMS IT
, OKX_CUSTOMER_ACCOUNTS_V SX
WHERE L.LSE_ID IN (35)
AND L.LSE_ID = LS.ID
AND LS.LANGUAGE = USERENV('LANG')
AND L.DNZ_CHR_ID = IT.DNZ_CHR_ID
AND L.ID = IT.CLE_ID
AND L.CLE_ID IS NOT NULL
AND SX.ID1 = IT.OBJECT1_ID1 UNION SELECT L.DNZ_CHR_ID CONTRACT_ID
, L.CLE_ID LINE_ID
, L.ID COVD_LINE_ID
, L.LINE_NUMBER COVD_LINE_NUMBER
, L.LSE_ID COVD_LINE_LSE_ID
, LS.NAME COVERED_LEVEL
, NULL COVERED_SYSTEM
, NULL COVERED_SERIAL_NO
, SX.DESCRIPTION COVD_DESCRIPTION
, IT.OBJECT1_ID1 OBJECT_ID
, IT.NUMBER_OF_ITEMS QUANTITY
, IT.UOM_CODE QTY_UOM
, L.PRICE_NEGOTIATED PRICE
FROM OKC_K_HEADERS_B K
, OKC_K_LINES_B L
, OKC_LINE_STYLES_TL LS
, OKC_K_ITEMS IT
, OKX_SYSTEM_ITEMS_V SX
WHERE L.LSE_ID IN (7)
AND L.LSE_ID = LS.ID
AND LS.LANGUAGE = USERENV('LANG')
AND L.DNZ_CHR_ID = IT.DNZ_CHR_ID
AND L.ID = IT.CLE_ID
AND L.CLE_ID IS NOT NULL
AND L.DNZ_CHR_ID = K.ID
AND K.INV_ORGANIZATION_ID = SX.ID2
AND SX.ID1 = IT.OBJECT1_ID1
AND SX.ID2 = IT.OBJECT1_ID2 UNION SELECT L.DNZ_CHR_ID CONTRACT_ID
, L.CLE_ID LINE_ID
, L.ID COVD_LINE_ID
, L.LINE_NUMBER COVD_LINE_NUMBER
, L.LSE_ID COVD_LINE_LSE_ID
, LS.NAME COVERED_LEVEL
, NULL COVERED_SYSTEM
, NULL COVERED_SERIAL_NO
, SX.DESCRIPTION COVD_DESCRIPTION
, IT.OBJECT1_ID1 OBJECT_ID
, IT.NUMBER_OF_ITEMS QUANTITY
, IT.UOM_CODE QTY_UOM
, L.PRICE_NEGOTIATED PRICE
FROM OKC_K_LINES_B L
, OKC_LINE_STYLES_TL LS
, OKC_K_ITEMS IT
, OKX_PARTIES_V SX
WHERE L.LSE_ID IN (8)
AND L.LSE_ID = LS.ID
AND LS.LANGUAGE = USERENV('LANG')
AND L.DNZ_CHR_ID = IT.DNZ_CHR_ID
AND L.ID = IT.CLE_ID
AND L.CLE_ID IS NOT NULL
AND SX.ID1 = IT.OBJECT1_ID1 UNION SELECT L.DNZ_CHR_ID CONTRACT_ID
, L.CLE_ID LINE_ID
, L.ID COVD_LINE_ID
, L.LINE_NUMBER COVD_LINE_NUMBER
, L.LSE_ID COVD_LINE_LSE_ID
, LS.NAME COVERED_LEVEL
, NULL COVERED_SYSTEM
, NULL COVERED_SERIAL_NO
, SX.DESCRIPTION COVD_DESCRIPTION
, IT.OBJECT1_ID1 OBJECT_ID
, IT.NUMBER_OF_ITEMS QUANTITY
, IT.UOM_CODE QTY_UOM
, L.PRICE_NEGOTIATED PRICE
FROM OKC_K_HEADERS_B K
, OKC_K_LINES_B L
, OKC_LINE_STYLES_TL LS
, OKC_K_ITEMS IT
, OKX_CUST_SITE_USES_V SX
WHERE L.LSE_ID IN (10)
AND L.LSE_ID = LS.ID
AND LS.LANGUAGE = USERENV('LANG')
AND L.DNZ_CHR_ID = IT.DNZ_CHR_ID
AND L.ID = IT.CLE_ID
AND L.CLE_ID IS NOT NULL
AND L.DNZ_CHR_ID = K.ID
AND K.AUTHORING_ORG_ID = SX.ORG_ID
AND SX.ID1 = IT.OBJECT1_ID1 UNION SELECT L.DNZ_CHR_ID CONTRACT_ID
, L.CLE_ID LINE_ID
, L.ID COVD_LINE_ID
, L.LINE_NUMBER COVD_LINE_NUMBER
, L.LSE_ID COVD_LINE_LSE_ID
, LS.NAME COVERED_LEVEL
, SX.NAME COVERED_SYSTEM
, NULL COVERED_SERIAL_NO
, SX.DESCRIPTION COVD_DESCRIPTION
, IT.OBJECT1_ID1 OBJECT_ID
, IT.NUMBER_OF_ITEMS QUANTITY
, IT.UOM_CODE QTY_UOM
, L.PRICE_NEGOTIATED PRICE
FROM OKC_K_HEADERS_B K
, OKC_K_LINES_B L
, OKC_LINE_STYLES_TL LS
, OKC_K_ITEMS IT
, OKX_SYSTEMS_V SX
WHERE L.LSE_ID IN (11)
AND L.LSE_ID = LS.ID
AND LS.LANGUAGE = USERENV('LANG')
AND L.DNZ_CHR_ID = IT.DNZ_CHR_ID
AND L.ID = IT.CLE_ID
AND L.CLE_ID IS NOT NULL
AND L.DNZ_CHR_ID = K.ID
AND K.AUTHORING_ORG_ID = SX.ORG_ID
AND SX.ID1 = IT.OBJECT1_ID1

Columns