View: OKS_BILLPRST_SUBSCRLINE_V

Product:	OKS - Service Contracts
Description:
Implementation/DBA Data:	APPS.OKS_BILLPRST_SUBSCRLINE_V

View Text

SELECT STYLE.NAME TYPE
, INV.NAME NAME
, INV.DESCRIPTION DESCRIPTION
, LINE.COGNOMEN LINE_REFERENCE
, LINE.START_DATE START_DATE
, LINE.END_DATE END_DATE
, LINE.PRICE_NEGOTIATED EXTENDED_PRICE
, RLINE.INVOICE_TEXT INVOICE_TEXT
, LINE.DNZ_CHR_ID DNZ_CHR_ID
, LINE.ID ID
, BCL.DATE_BILLED_FROM DATE_BILLED_FROM
, BCL.DATE_BILLED_TO DATE_BILLED_TO
, BCL.AMOUNT AMOUNT_BILLED
, LINE.CLE_ID CLE_ID
, BCL.ID BCL_ID
, HDR.CURRENCY_CODE CURRENCY_CODE
, TO_NUMBER(NULL) BSL_ID
, HDR.CONTRACT_NUMBER||' '||CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER
FROM OKS_BILL_CONT_LINES BCL
, OKC_K_LINES_V LINE
, OKC_K_HEADERS_B HDR
, OKS_K_LINES_V RLINE
, OKC_LINE_STYLES_V STYLE
, OKC_K_ITEMS ITEM
, OKX_SYSTEM_ITEMS_V INV
WHERE LINE.ID = RLINE.CLE_ID
AND LINE.LSE_ID = 46
AND STYLE.ID = LINE.LSE_ID
AND ITEM.CLE_ID = LINE.ID
AND ITEM.OBJECT1_ID1 = INV.INVENTORY_ITEM_ID
AND BCL.CLE_ID = LINE.ID
AND HDR.ID = LINE.DNZ_CHR_ID
AND HDR.INV_ORGANIZATION_ID = INV.ORGANIZATION_ID

Columns