eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CONS_BILL dependencies on OKL_CNSLD_AR_LINES_V

Line 31: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;

27:
28: l_old_cnr_id NUMBER;
29: l_old_lln_id NUMBER;
30: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;
31: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;
32:
33: CURSOR cnr_amt_csr ( p_cnr_id IN NUMBER ) IS
34: SELECT SUM(lsm.amount)
35: FROM okl_cnsld_ar_hdrs_b cnr,

Line 560: -- in okl_cnsld_ar_lines_v.This function is called when the

556: p_msg_name => G_OTHERS);
557: END create_new_invoice;
558:
559: --This function checks for the existence of an consolidated invoice line
560: -- in okl_cnsld_ar_lines_v.This function is called when the
561: -- group_by_assets flag is set to 'Y'
562: PROCEDURE line_exist (p_cnr_id IN NUMBER,
563: p_khr_id IN NUMBER,
564: p_kle_id IN NUMBER,

Line 576: FROM okl_cnsld_ar_lines_v

572: IS
573:
574: CURSOR check_line1 ( p_cnr_id NUMBER, p_khr_id NUMBER, p_ilt_id NUMBER, p_sequence_number NUMBER ) IS
575: SELECT id
576: FROM okl_cnsld_ar_lines_v
577: WHERE cnr_id = p_cnr_id AND
578: khr_id = p_khr_id AND
579: ilt_id = p_ilt_id AND
580: sequence_number = p_sequence_number;

Line 584: FROM okl_cnsld_ar_lines_v

580: sequence_number = p_sequence_number;
581:
582: CURSOR check_line2 (p_cnr_id NUMBER, p_khr_id NUMBER, p_kle_id NUMBER, p_ilt_id NUMBER ) IS
583: SELECT id
584: FROM okl_cnsld_ar_lines_v
585: WHERE cnr_id = p_cnr_id AND
586: khr_id = p_khr_id AND
587: kle_id = p_kle_id AND
588: ilt_id = p_ilt_id AND

Line 593: FROM okl_cnsld_ar_lines_v

589: sequence_number = p_sequence_number;
590:
591: CURSOR check_line3 ( p_cnr_id NUMBER, p_khr_id NUMBER, p_ilt_id NUMBER, p_sequence_number NUMBER ) IS
592: SELECT id
593: FROM okl_cnsld_ar_lines_v
594: WHERE cnr_id = p_cnr_id AND
595: khr_id = p_khr_id AND
596: kle_id IS NULL AND
597: ilt_id = p_ilt_id AND

Line 602: FROM okl_cnsld_ar_lines_v

598: sequence_number = p_sequence_number;
599:
600: CURSOR check_line4 ( p_cnr_id NUMBER, p_ilt_id NUMBER, p_sequence_number NUMBER ) IS
601: SELECT id
602: FROM okl_cnsld_ar_lines_v
603: WHERE cnr_id = p_cnr_id AND
604: ilt_id = p_ilt_id AND
605: sequence_number = p_sequence_number;
606:

Line 636: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=***********> SELECT id FROM okl_cnsld_ar_lines_v');

632: IF p_group_by_assets_yn = 'Y' THEN
633:
634: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
635: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, '====> Using SQL in check_line1 ');
636: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=***********> SELECT id FROM okl_cnsld_ar_lines_v');
637: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=***********> WHERE cnr_id = '||p_cnr_id||' AND ');
638: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=***********> khr_id = '||p_khr_id||' AND ');
639: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=***********> ilt_id = '||p_ilt_id||' AND ');
640: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=***********> sequence_number = '||p_sequence_number||';');

Line 655: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=***********> SELECT id FROM okl_cnsld_ar_lines_v');

651: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, '====> Using SQL in check_line2 ');
652: END IF;
653:
654: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
655: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=***********> SELECT id FROM okl_cnsld_ar_lines_v');
656: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=***********> WHERE cnr_id = '||p_cnr_id||' AND ');
657: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=***********> khr_id = '||p_khr_id||' AND ');
658: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=***********> kle_id = '||p_kle_id||' AND ');
659: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=***********> ilt_id = '||p_ilt_id||' AND ');

Line 673: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=***********> SELECT id FROM okl_cnsld_ar_lines_v');

669: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, '====> Using SQL in check_line3 ');
670: END IF;
671:
672: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
673: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=***********> SELECT id FROM okl_cnsld_ar_lines_v');
674: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=***********> WHERE cnr_id = '||p_cnr_id||' AND ');
675: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=***********> khr_id = '||p_khr_id||' AND ');
676: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=***********> kle_id is null AND ');
677: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=***********> ilt_id = '||p_ilt_id||' AND ');

Line 690: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=***********> SELECT id FROM okl_cnsld_ar_lines_v');

686: END IF;
687: ELSE
688: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
689: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, '====> Using SQL in check_line4 ');
690: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=***********> SELECT id FROM okl_cnsld_ar_lines_v');
691: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=***********> WHERE cnr_id = '||p_cnr_id||' AND ');
692: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=***********> ilt_id = '||p_ilt_id||' AND ');
693: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=***********> sequence_number = '||p_sequence_number||';');
694: END IF;

Line 996: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;

992: l_funct_return VARCHAR2(1);
993:
994: l_cons_inv_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE;
995: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;
996: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;
997: l_legal_entity_id okl_ext_sell_invs_v.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
998:
999: l_update_tbl update_tbl_type;
1000:

Line 1902: FROM okl_cnsld_ar_lines_v

1898: -- Billing performance fix
1899:
1900: CURSOR line_seq_csr(p_cnr_id NUMBER) IS
1901: SELECT *
1902: FROM okl_cnsld_ar_lines_v
1903: WHERE cnr_id = p_cnr_id
1904: ORDER BY sequence_number;
1905:
1906: CURSOR format_id_csr (p_format_name VARCHAR2) IS

Line 2093: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;

2089: -- -----------------------------
2090: l_old_cnr_id NUMBER;
2091: l_old_lln_id NUMBER;
2092: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;
2093: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;
2094:
2095: CURSOR cnr_amt_csr ( p_cnr_id IN NUMBER ) IS
2096: SELECT SUM(lsm.amount)
2097: FROM okl_cnsld_ar_hdrs_b cnr,

Line 2905: FROM okl_cnsld_ar_lines_v

2901: -- Update the amount on the Cons Bill header
2902: l_consbill_amount := 0;
2903: BEGIN
2904: SELECT SUM(amount) INTO l_consbill_amount
2905: FROM okl_cnsld_ar_lines_v
2906: WHERE cnr_id = l_cnr_id;
2907: EXCEPTION
2908: WHEN OTHERS THEN
2909: l_consbill_amount := 0;

Line 3016: FROM okl_cnsld_ar_lines_v lln,

3012: INTO l_xlsv_rec.XTRX_CONS_LINE_NUMBER,
3013: l_xlsv_rec.XTRX_CONTRACT,
3014: -- l_xlsv_rec.XTRX_ASSET,
3015: l_xlsv_rec.XTRX_STREAM_GROUP
3016: FROM okl_cnsld_ar_lines_v lln,
3017: okl_invc_line_types_v ilt,
3018: okc_k_headers_b khr
3019: WHERE lln.id = cnr_update_tbl(cnr_tab_idx).lln_id AND
3020: khr.id = lln.khr_id AND