APPS.OKS_MISC_UTIL_WEB dependencies on OKS_BILL_TRANSACTIONS

Line 296: oks_bill_transactions btr

292: CURSOR line_billed_amount_curr (l_line_id IN NUMBER) IS
293: SELECT
294: NVL(SUM(btl.trx_amount), 0) + NVL(SUM(btl.trx_line_tax_amount), 0) trx_amount
295: FROM
296: oks_bill_transactions btr
297: , oks_bill_txn_lines btl
298: , oks_bill_cont_lines bcl
299: WHERE
300: bcl.cle_id = l_line_id

Line 362: , oks_bill_transactions btr

358: FROM
359: oks_bill_txn_lines btl
360: , oks_bill_cont_lines bcl
361: , oks_bill_sub_lines bsl
362: , oks_bill_transactions btr
363: WHERE
364: bsl.cle_id = l_line_id
365: AND btl.BSL_ID = bsl.id
366: AND btl.btn_id = btr.id

Line 493: oks_bill_transactions btr

489: (
490: SELECT
491: NVL(SUM(btl.trx_amount), 0) BILLED_AMOUNT
492: FROM
493: oks_bill_transactions btr
494: ,oks_bill_txn_lines btl
495: ,OKS_BILL_CONT_LINES BCL
496:
497: WHERE

Line 561: ,oks_bill_transactions btr

557: NVL(SUM(btl.trx_amount), 0) BILLED_AMOUNT
558: FROM
559: OKS_BILL_SUB_LINES BSL
560: ,oks_bill_txn_lines btl
561: ,oks_bill_transactions btr
562: ,OKS_BILL_CONT_LINES BCL
563: WHERE
564: BSL.cle_id = l_line_id
565: AND BCL.id = BSL.bcl_id

Line 685: ,OKS_BILL_TRANSACTIONS BTR

681: NVL(SUM(BTL.TRX_AMOUNT),0) BILLED_AMOUNT
682: FROM
683: OKC_K_LINES_B LINE
684: ,OKS_K_LINES_B KSLINES
685: ,OKS_BILL_TRANSACTIONS BTR
686: ,OKS_BILL_TXN_LINES BTL
687: ,OKS_BILL_CONT_LINES BCL
688: WHERE
689: LINE.CHR_ID = P_CHR_ID

Line 779: ,OKS_BILL_TRANSACTIONS BTR

775: SELECT
776: NVL(SUM(BTL.TRX_AMOUNT), 0) + NVL(SUM(BTL.TRX_LINE_TAX_AMOUNT), 0) TRX_AMOUNT
777: FROM
778: OKC_K_LINES_B LINE
779: ,OKS_BILL_TRANSACTIONS BTR
780: ,OKS_BILL_TXN_LINES BTL
781: ,OKS_BILL_CONT_LINES BCL
782: WHERE
783: LINE.CHR_ID = P_CHR_ID