VIEW: APPS.OKS_BILLPRST_USGSUBLINE_V

Source

View Text - Preformatted

SELECT 'Usage' Type, it.NAME Name, cg.source_object_code || ';' || cp.serial_number || ';' || cp.instance_number Description, line.cognomen line_reference, line.start_date start_date, line.end_date end_date, to_number(NULL) extended_price, rline.invoice_text invoice_text, line.dnz_chr_id dnz_chr_id, line.id id, bsl.date_billed_from date_billed_from, bsl.date_billed_to date_billeD_to, bsl.amount Amount_billed, line.cle_id cle_id, bsl.bcl_id bcl_id, hdr.currency_code currency_code, bsl.id bsl_id, hdr.contract_number||' '||contract_number_modifier contract_number, txn.bill_instance_number bill_instance_number from okx_system_items_v it, csi_item_instances cp, okx_counter_groups_v cg, okx_counters_v cou, oks_bill_txn_lines txn, oks_bill_sub_lines bsl, okc_k_items itm, okc_k_headers_b hdr, oks_k_lines_v rline , okc_k_lines_v line WHERE line.lse_id = 13 and rline.cle_id = line.id and itm.cle_id = line.id and line.dnz_chr_id = hdr.id and bsl.cle_id = line.id and cou.id1 = itm.object1_id1 and cg.counter_group_id = cou.counter_group_id and cg.source_object_code = 'CP' and cg.source_object_id = cp.instance_id and it.id1 = cp.inventory_item_id and it.organization_id = hdr.inv_organization_id and txn.bsl_id = bsl.id and txn.bcl_id = bsl.bcl_id

View Text - HTML Formatted

SELECT 'USAGE' TYPE
, IT.NAME NAME
, CG.SOURCE_OBJECT_CODE || ';' || CP.SERIAL_NUMBER || ';' || CP.INSTANCE_NUMBER DESCRIPTION
, LINE.COGNOMEN LINE_REFERENCE
, LINE.START_DATE START_DATE
, LINE.END_DATE END_DATE
, TO_NUMBER(NULL) EXTENDED_PRICE
, RLINE.INVOICE_TEXT INVOICE_TEXT
, LINE.DNZ_CHR_ID DNZ_CHR_ID
, LINE.ID ID
, BSL.DATE_BILLED_FROM DATE_BILLED_FROM
, BSL.DATE_BILLED_TO DATE_BILLED_TO
, BSL.AMOUNT AMOUNT_BILLED
, LINE.CLE_ID CLE_ID
, BSL.BCL_ID BCL_ID
, HDR.CURRENCY_CODE CURRENCY_CODE
, BSL.ID BSL_ID
, HDR.CONTRACT_NUMBER||' '||CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER
, TXN.BILL_INSTANCE_NUMBER BILL_INSTANCE_NUMBER
FROM OKX_SYSTEM_ITEMS_V IT
, CSI_ITEM_INSTANCES CP
, OKX_COUNTER_GROUPS_V CG
, OKX_COUNTERS_V COU
, OKS_BILL_TXN_LINES TXN
, OKS_BILL_SUB_LINES BSL
, OKC_K_ITEMS ITM
, OKC_K_HEADERS_B HDR
, OKS_K_LINES_V RLINE
, OKC_K_LINES_V LINE
WHERE LINE.LSE_ID = 13
AND RLINE.CLE_ID = LINE.ID
AND ITM.CLE_ID = LINE.ID
AND LINE.DNZ_CHR_ID = HDR.ID
AND BSL.CLE_ID = LINE.ID
AND COU.ID1 = ITM.OBJECT1_ID1
AND CG.COUNTER_GROUP_ID = COU.COUNTER_GROUP_ID
AND CG.SOURCE_OBJECT_CODE = 'CP'
AND CG.SOURCE_OBJECT_ID = CP.INSTANCE_ID
AND IT.ID1 = CP.INVENTORY_ITEM_ID
AND IT.ORGANIZATION_ID = HDR.INV_ORGANIZATION_ID
AND TXN.BSL_ID = BSL.ID
AND TXN.BCL_ID = BSL.BCL_ID