APPS.OKS_MISC_UTIL_WEB dependencies on OKS_BILL_TXN_LINES

Line 297: , oks_bill_txn_lines btl

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
301: and btr.ID = bcl.BTN_ID

Line 359: oks_bill_txn_lines btl

355: CURSOR sub_line_billed_amount_curr (l_line_id IN NUMBER) IS
356: SELECT
357: NVL(SUM(btl.trx_amount), 0) + NVL(SUM(btl.trx_line_tax_amount), 0) trx_amount
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

Line 494: ,oks_bill_txn_lines btl

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
498: BCL.cle_id = l_line_id

Line 560: ,oks_bill_txn_lines btl

556: SELECT
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

Line 686: ,OKS_BILL_TXN_LINES BTL

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
690: AND LINE.ID = KSLINES.CLE_ID

Line 780: ,OKS_BILL_TXN_LINES BTL

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
784: AND LINE.ID = BCL.CLE_ID