DBA Data[Home] [Help]

APPS.OKS_MISC_UTIL_WEB dependencies on OKS_BILL_SUB_LINES

Line 361: , oks_bill_sub_lines bsl

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
364: bsl.cle_id = l_line_id
365: AND btl.BSL_ID = bsl.id

Line 559: OKS_BILL_SUB_LINES BSL

555: (
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