[Home] [Help]
View: OKS_PRODUCTS_V
Product: | OKS - Service Contracts |
Description: | View is Used for Contracts Quote Printing |
Implementation/DBA Data: |
APPS.OKS_PRODUCTS_V
|
View Text
SELECT L.START_DATE
, L.END_DATE
, L.DNZ_CHR_ID CONTRACT_ID
, L.CLE_ID LINE_ID
, L.ID PRODUCT_LINE_ID
, L.LSE_ID
, LS.NAME
, IT.OBJECT1_ID1
, IT.NUMBER_OF_ITEMS
, IT.UOM_CODE
, L.PRICE_NEGOTIATED
FROM OKC_K_HEADERS_V K
, OKC_K_LINES_V L
, OKC_LINE_STYLES_V LS
, OKC_K_ITEMS_V IT
WHERE K.ID = L.DNZ_CHR_ID
AND L.LSE_ID IN (11
, 25
, 35)
AND L.LSE_ID = LS.ID
AND L.ID = IT.CLE_ID
Columns
Name |
START_DATE |
END_DATE |
CONTRACT_ID |
LINE_ID |
PRODUCT_LINE_ID |
PRODUCT_LINE_LSE_ID |
COVERED_LEVEL |
OBJECT_ID |
QUANTITY |
QTY_UOM |
PRICE |