VIEW: APPS.OKS_BILLPRST_SRVSUBLINE_V

Source

View Text - Preformatted

SELECT style.name name, sx.name 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, 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 oks_bill_txn_lines txn, oks_bill_sub_lines bsl, okx_systems_v sx, okc_k_items itm, okc_k_headers_b hdr, okc_k_lines_v line, okc_line_styles_v style , oks_k_lines_v rline WHERE line.lse_id = 11 and style.id = line.lse_id and hdr.id = line.dnz_chr_id and itm.cle_id = line.id and sx.id1 = itm.object1_id1 and bsl.cle_id = line.id and rline.cle_id = line.id and nvl(txn.bsl_id,-999) = decode(txn.bsl_id,NULL,-999,bsl.id) and txn.bcl_id = bsl.bcl_id UNION ALL SELECT style.name name, sx.name 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, 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 oks_bill_txn_lines txn, oks_bill_sub_lines bsl, okx_cust_site_uses_v sx, okc_k_items itm, okc_k_headers_b hdr, okc_k_lines_v line, okc_line_styles_v style , oks_k_lines_v rline Where line.lse_id = 10 and style.id = line.lse_id and hdr.id = line.dnz_chr_id and itm.cle_id = line.id and hdr.authoring_org_id = sx.org_id and sx.id1 = itm.object1_id1 and bsl.cle_id = line.id and rline.cle_id = line.id and nvl(txn.bsl_id,-999) = decode(txn.bsl_id,NULL,-999,bsl.id) and txn.bcl_id = bsl.bcl_id UNION ALL SELECT style.name name, sx.name 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, 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 oks_bill_txn_lines txn, oks_bill_sub_lines bsl, okx_parties_v sx, okc_k_items itm, okc_k_headers_b hdr, okc_k_lines_v line, okc_line_styles_v style , oks_k_lines_v rline Where line.lse_id = 8 and hdr.id = line.dnz_chr_id and itm.cle_id = line.id and sx.id1 = itm.object1_id1 and bsl.cle_id = line.id and rline.cle_id = line.id and style.id = line.lse_id and nvl(txn.bsl_id,-999) = decode(txn.bsl_id,NULL,-999,bsl.id) and txn.bcl_id = bsl.bcl_id UNION ALL SELECT style.name name, sx.name 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, 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 oks_bill_txn_lines txn, oks_bill_sub_lines bsl, okx_system_items_v sx, okc_k_items itm, okc_k_headers_b hdr, okc_k_lines_v line, okc_line_styles_v style , oks_k_lines_v rline Where line.lse_id = 7 and hdr.id = line.dnz_chr_id and itm.cle_id = line.id and sx.id1 = itm.object1_id1 and sx.id2 = itm.object1_id2 and bsl.cle_id = line.id and rline.cle_id = line.id and style.id = line.lse_id and nvl(txn.bsl_id,-999) = decode(txn.bsl_id,NULL,-999,bsl.id) and txn.bcl_id = bsl.bcl_id UNION ALL SELECT style.name name, sx.name 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, 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 oks_bill_txn_lines txn, oks_bill_sub_lines bsl, okx_customer_accounts_v sx, okc_k_items itm, oks_k_lines_v rline, okc_k_lines_v line, okc_k_headers_b hdr, okc_line_styles_v style Where line.lse_id = 35 and style.id = line.lse_id and itm.cle_id = line.id and hdr.id = line.dnz_chr_id and sx.id1 = itm.object1_id1 and bsl.cle_id = line.id and rline.cle_id = line.id and nvl(txn.bsl_id,-999) = decode(txn.bsl_id,NULL,-999,bsl.id) and txn.bcl_id = bsl.bcl_id UNION ALL SELECT style.name name, sx.name 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, 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 oks_bill_txn_lines txn, oks_bill_sub_lines bsl, cs_customer_products cp, okx_system_items_v sx, okc_k_items itm, okc_k_headers_b hdr, oks_k_lines_v rline , okc_k_lines_v line, okc_line_styles_v style Where line.lse_id = 9 and style.id = line.lse_id and itm.cle_id = line.id and hdr.id = line.dnz_chr_id and itm.cle_id = line.id and hdr.inv_organization_id = sx.id2 and sx.id1 = cp.inventory_item_id and cp.customer_product_id = itm.object1_id1 and bsl.cle_id = line.id and rline.cle_id = line.id and nvl(txn.bsl_id,-999) = decode(txn.bsl_id,NULL,-999,bsl.id) and txn.bcl_id = bsl.bcl_id UNION ALL SELECT style.name name, sx.name 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, 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 oks_bill_txn_lines txn, oks_bill_sub_lines bsl, cs_customer_products cp, okx_system_items_v sx, okc_k_items itm, okc_k_headers_b hdr, oks_k_lines_v rline , okc_k_lines_v line, okc_line_styles_v style Where line.lse_id = 25 and style.id = line.lse_id and itm.cle_id = line.id and hdr.id = line.dnz_chr_id and itm.cle_id = line.id and hdr.inv_organization_id = sx.id2 and sx.id1 = cp.inventory_item_id and cp.customer_product_id = itm.object1_id1 and bsl.cle_id = line.id and rline.cle_id = line.id and nvl(txn.bsl_id,-999) = decode(txn.bsl_id,NULL,-999,bsl.id) and txn.bcl_id = bsl.bcl_id

View Text - HTML Formatted

SELECT STYLE.NAME NAME
, SX.NAME 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
, 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 OKS_BILL_TXN_LINES TXN
, OKS_BILL_SUB_LINES BSL
, OKX_SYSTEMS_V SX
, OKC_K_ITEMS ITM
, OKC_K_HEADERS_B HDR
, OKC_K_LINES_V LINE
, OKC_LINE_STYLES_V STYLE
, OKS_K_LINES_V RLINE
WHERE LINE.LSE_ID = 11
AND STYLE.ID = LINE.LSE_ID
AND HDR.ID = LINE.DNZ_CHR_ID
AND ITM.CLE_ID = LINE.ID
AND SX.ID1 = ITM.OBJECT1_ID1
AND BSL.CLE_ID = LINE.ID
AND RLINE.CLE_ID = LINE.ID
AND NVL(TXN.BSL_ID
, -999) = DECODE(TXN.BSL_ID
, NULL
, -999
, BSL.ID)
AND TXN.BCL_ID = BSL.BCL_ID UNION ALL SELECT STYLE.NAME NAME
, SX.NAME 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
, 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 OKS_BILL_TXN_LINES TXN
, OKS_BILL_SUB_LINES BSL
, OKX_CUST_SITE_USES_V SX
, OKC_K_ITEMS ITM
, OKC_K_HEADERS_B HDR
, OKC_K_LINES_V LINE
, OKC_LINE_STYLES_V STYLE
, OKS_K_LINES_V RLINE
WHERE LINE.LSE_ID = 10
AND STYLE.ID = LINE.LSE_ID
AND HDR.ID = LINE.DNZ_CHR_ID
AND ITM.CLE_ID = LINE.ID
AND HDR.AUTHORING_ORG_ID = SX.ORG_ID
AND SX.ID1 = ITM.OBJECT1_ID1
AND BSL.CLE_ID = LINE.ID
AND RLINE.CLE_ID = LINE.ID
AND NVL(TXN.BSL_ID
, -999) = DECODE(TXN.BSL_ID
, NULL
, -999
, BSL.ID)
AND TXN.BCL_ID = BSL.BCL_ID UNION ALL SELECT STYLE.NAME NAME
, SX.NAME 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
, 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 OKS_BILL_TXN_LINES TXN
, OKS_BILL_SUB_LINES BSL
, OKX_PARTIES_V SX
, OKC_K_ITEMS ITM
, OKC_K_HEADERS_B HDR
, OKC_K_LINES_V LINE
, OKC_LINE_STYLES_V STYLE
, OKS_K_LINES_V RLINE
WHERE LINE.LSE_ID = 8
AND HDR.ID = LINE.DNZ_CHR_ID
AND ITM.CLE_ID = LINE.ID
AND SX.ID1 = ITM.OBJECT1_ID1
AND BSL.CLE_ID = LINE.ID
AND RLINE.CLE_ID = LINE.ID
AND STYLE.ID = LINE.LSE_ID
AND NVL(TXN.BSL_ID
, -999) = DECODE(TXN.BSL_ID
, NULL
, -999
, BSL.ID)
AND TXN.BCL_ID = BSL.BCL_ID UNION ALL SELECT STYLE.NAME NAME
, SX.NAME 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
, 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 OKS_BILL_TXN_LINES TXN
, OKS_BILL_SUB_LINES BSL
, OKX_SYSTEM_ITEMS_V SX
, OKC_K_ITEMS ITM
, OKC_K_HEADERS_B HDR
, OKC_K_LINES_V LINE
, OKC_LINE_STYLES_V STYLE
, OKS_K_LINES_V RLINE
WHERE LINE.LSE_ID = 7
AND HDR.ID = LINE.DNZ_CHR_ID
AND ITM.CLE_ID = LINE.ID
AND SX.ID1 = ITM.OBJECT1_ID1
AND SX.ID2 = ITM.OBJECT1_ID2
AND BSL.CLE_ID = LINE.ID
AND RLINE.CLE_ID = LINE.ID
AND STYLE.ID = LINE.LSE_ID
AND NVL(TXN.BSL_ID
, -999) = DECODE(TXN.BSL_ID
, NULL
, -999
, BSL.ID)
AND TXN.BCL_ID = BSL.BCL_ID UNION ALL SELECT STYLE.NAME NAME
, SX.NAME 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
, 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 OKS_BILL_TXN_LINES TXN
, OKS_BILL_SUB_LINES BSL
, OKX_CUSTOMER_ACCOUNTS_V SX
, OKC_K_ITEMS ITM
, OKS_K_LINES_V RLINE
, OKC_K_LINES_V LINE
, OKC_K_HEADERS_B HDR
, OKC_LINE_STYLES_V STYLE
WHERE LINE.LSE_ID = 35
AND STYLE.ID = LINE.LSE_ID
AND ITM.CLE_ID = LINE.ID
AND HDR.ID = LINE.DNZ_CHR_ID
AND SX.ID1 = ITM.OBJECT1_ID1
AND BSL.CLE_ID = LINE.ID
AND RLINE.CLE_ID = LINE.ID
AND NVL(TXN.BSL_ID
, -999) = DECODE(TXN.BSL_ID
, NULL
, -999
, BSL.ID)
AND TXN.BCL_ID = BSL.BCL_ID UNION ALL SELECT STYLE.NAME NAME
, SX.NAME 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
, 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 OKS_BILL_TXN_LINES TXN
, OKS_BILL_SUB_LINES BSL
, CS_CUSTOMER_PRODUCTS CP
, OKX_SYSTEM_ITEMS_V SX
, OKC_K_ITEMS ITM
, OKC_K_HEADERS_B HDR
, OKS_K_LINES_V RLINE
, OKC_K_LINES_V LINE
, OKC_LINE_STYLES_V STYLE
WHERE LINE.LSE_ID = 9
AND STYLE.ID = LINE.LSE_ID
AND ITM.CLE_ID = LINE.ID
AND HDR.ID = LINE.DNZ_CHR_ID
AND ITM.CLE_ID = LINE.ID
AND HDR.INV_ORGANIZATION_ID = SX.ID2
AND SX.ID1 = CP.INVENTORY_ITEM_ID
AND CP.CUSTOMER_PRODUCT_ID = ITM.OBJECT1_ID1
AND BSL.CLE_ID = LINE.ID
AND RLINE.CLE_ID = LINE.ID
AND NVL(TXN.BSL_ID
, -999) = DECODE(TXN.BSL_ID
, NULL
, -999
, BSL.ID)
AND TXN.BCL_ID = BSL.BCL_ID UNION ALL SELECT STYLE.NAME NAME
, SX.NAME 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
, 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 OKS_BILL_TXN_LINES TXN
, OKS_BILL_SUB_LINES BSL
, CS_CUSTOMER_PRODUCTS CP
, OKX_SYSTEM_ITEMS_V SX
, OKC_K_ITEMS ITM
, OKC_K_HEADERS_B HDR
, OKS_K_LINES_V RLINE
, OKC_K_LINES_V LINE
, OKC_LINE_STYLES_V STYLE
WHERE LINE.LSE_ID = 25
AND STYLE.ID = LINE.LSE_ID
AND ITM.CLE_ID = LINE.ID
AND HDR.ID = LINE.DNZ_CHR_ID
AND ITM.CLE_ID = LINE.ID
AND HDR.INV_ORGANIZATION_ID = SX.ID2
AND SX.ID1 = CP.INVENTORY_ITEM_ID
AND CP.CUSTOMER_PRODUCT_ID = ITM.OBJECT1_ID1
AND BSL.CLE_ID = LINE.ID
AND RLINE.CLE_ID = LINE.ID
AND NVL(TXN.BSL_ID
, -999) = DECODE(TXN.BSL_ID
, NULL
, -999
, BSL.ID)
AND TXN.BCL_ID = BSL.BCL_ID