APPS.OKS_MISC_UTIL_WEB dependencies on OKC_K_LINES_B

Line 231: FROM okc_k_lines_b lines

227:
228:
229: CURSOR c_subtotal_amount IS
230: SELECT nvl(sum(lines.price_negotiated),0)
231: FROM okc_k_lines_b lines
232: WHERE lines.dnz_chr_id = p_chr_id
233: AND lines.cle_id IS NULL;
234:
235: CURSOR c_tax_amount IS -- Bug 5490811

Line 330: okc_k_lines_b subline,

326: bcl.bill_action,
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

Line 386: okc_k_lines_b subline,

382: ral.extended_amount lineamt,
383: ral.customer_trx_id,
384: rank() over (partition by ral.customer_trx_line_id order by ratax.customer_trx_line_id) r
385: from
386: okc_k_lines_b subline,
387: okc_k_rel_objs rel,
388: oe_order_lines_all oel,
389: oe_order_headers_all oe,
390: ra_customer_trx_lines_all ral,

Line 485: OKC_K_LINES_B KLINES

481: -
482: (NVL(OKS_BILLED_LINES.BILLED_AMOUNT,0) + NVL(OM_ORIGINATED_BILLED_LINES.BILLED_AMOUNT,0)) unbilled_amount
483:
484: FROM
485: OKC_K_LINES_B KLINES
486: ,OKS_K_LINES_B KSLINES
487:
488: ,
489: (

Line 512: okc_k_lines_b subline,

508: select NVL(SUM(ral.extended_amount), 0) BILLED_AMOUNT
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

Line 552: OKC_K_LINES_B KLINES

548: -
549: (NVL(OKS_BILLED_LINES.BILLED_AMOUNT,0) + NVL(OM_ORIGINATED_BILLED_LINES.BILLED_AMOUNT,0)) unbilled_amount
550:
551: FROM
552: OKC_K_LINES_B KLINES
553: ,OKS_K_LINES_B KSLINES
554: ,
555: (
556: SELECT

Line 582: ,okc_k_lines_b subline

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
583: WHERE
584: subline.id = l_line_id
585: AND subline.lse_id in (9,18,25)
586: AND rel.cle_id = subline.id

Line 671: OKC_K_LINES_B KLINES

667: NVL(KSLINES.CREDIT_AMOUNT, 0) +
668: NVL(KSLINES.SUPPRESSED_CREDIT, 0)
669: )
670: FROM
671: OKC_K_LINES_B KLINES
672: ,OKS_K_LINES_B KSLINES
673: WHERE
674: KLINES.CHR_ID = P_CHR_ID
675: AND KLINES.ID = KSLINES.CLE_ID

Line 683: OKC_K_LINES_B LINE

679: (
680: ( SELECT
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

Line 706: OKC_K_LINES_B SUBLINE,

702: NVL(SUM(RAL.EXTENDED_AMOUNT), 0) BILLED_AMOUNT
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)

Line 778: OKC_K_LINES_B LINE

774: CURSOR C_HEADER_BILLED_AMOUNT (P_CHR_ID IN NUMBER) IS
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

Line 817: OKC_K_LINES_B SUBLINE,

813: BCL.BILL_ACTION,
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)