APPS.OKS_MISC_UTIL_WEB dependencies on OKS_BILL_CONT_LINES

Line 298: , oks_bill_cont_lines bcl

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
302: and btl.btn_id = btr.id

Line 331: oks_bill_cont_lines bcl

327: bcl.date_billed_from bill_from_date,
328: bcl.date_billed_to bill_to_date
329: from okc_k_rel_objs rel,
330: okc_k_lines_b subline,
331: oks_bill_cont_lines bcl
332: where subline.cle_id = l_line_id
333: and subline.lse_id in (9,18,25)
334: and subline.cle_id = bcl.cle_id
335: AND bcl.btn_id = - 44

Line 360: , oks_bill_cont_lines bcl

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
364: bsl.cle_id = l_line_id

Line 405: oks_bill_cont_lines bcl

401: and ral.customer_trx_id = ra.customer_trx_id
402: and ratax.link_to_cust_trx_line_id (+) = ral.customer_trx_line_id
403: and ratax.line_type (+) = 'TAX') raTrxLineSelect,
404:
405: oks_bill_cont_lines bcl
406: WHERE raTrxLineSelect.id = bcl.cle_id
407: AND bcl.btn_id = - 44
408: AND bcl.bill_action = 'RI'
409: GROUP BY raTrxLineSelect.id;

Line 495: ,OKS_BILL_CONT_LINES BCL

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
499: AND BCL.bill_action = 'RI'

Line 513: oks_bill_cont_lines bcl

509: from (
510: select /*+ no_merge */ distinct rel.object1_id1
511: from okc_k_rel_objs rel,
512: okc_k_lines_b subline,
513: oks_bill_cont_lines bcl
514: where subline.cle_id = l_line_id
515: and subline.lse_id in (9,18,25)
516: and subline.cle_id = bcl.cle_id
517: AND bcl.btn_id = - 44

Line 562: ,OKS_BILL_CONT_LINES BCL

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
566: AND BCL.bill_action = 'RI'

Line 578: ,oks_bill_cont_lines bcl

574: SELECT
575: NVL(SUM(ral.extended_amount), 0) BILLED_AMOUNT
576: FROM
577: ra_customer_trx_lines_all ral
578: ,oks_bill_cont_lines bcl
579: ,oe_order_headers_all oe
580: ,oe_order_lines_all oel
581: ,okc_k_rel_objs rel
582: ,okc_k_lines_b subline

Line 687: ,OKS_BILL_CONT_LINES BCL

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
691: AND (KSLINES.USAGE_TYPE IS NULL OR KSLINES.USAGE_TYPE = 'NPR') -- Bug 5484219 Filter out non NPR lines

Line 707: OKS_BILL_CONT_LINES BCL

703: FROM (
704: SELECT /*+ NO_MERGE */ DISTINCT REL.OBJECT1_ID1, SUBLINE.CHR_ID
705: FROM OKC_K_REL_OBJS REL,
706: OKC_K_LINES_B SUBLINE,
707: OKS_BILL_CONT_LINES BCL
708: WHERE
709: SUBLINE.DNZ_CHR_ID = P_CHR_ID
710: AND SUBLINE.LSE_ID IN (9,18,25)
711: AND SUBLINE.CLE_ID = BCL.CLE_ID

Line 781: ,OKS_BILL_CONT_LINES BCL

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
785: AND BTR.ID = BCL.BTN_ID

Line 818: OKS_BILL_CONT_LINES BCL

814: BCL.DATE_BILLED_FROM BILL_FROM_DATE,
815: BCL.DATE_BILLED_TO BILL_TO_DATE
816: FROM OKC_K_REL_OBJS REL,
817: OKC_K_LINES_B SUBLINE,
818: OKS_BILL_CONT_LINES BCL
819: WHERE
820: SUBLINE.DNZ_CHR_ID = P_CHR_ID
821: AND SUBLINE.LSE_ID IN (9,18,25)
822: AND SUBLINE.CLE_ID = BCL.CLE_ID