VIEW: APPS.OKS_BILLPRST_SUBSCRLINE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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