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_AM_CALC_QUOTE_STREAM_PVT dependencies on OKL_BPD_AR_INV_LINES_V

Line 731: -- Changed the cursors to select data from the view(okl_bpd_ar_inv_lines_v)

727: x_operand_total OUT NOCOPY NUMBER,
728: x_return_status OUT NOCOPY VARCHAR2) IS
729:
730: --ansethur 01-MAR-2007 Added for R12 B Billing Architecture Start Changes
731: -- Changed the cursors to select data from the view(okl_bpd_ar_inv_lines_v)
732: -- provided for the Enhanced Billing architecture
733: -- Select all CONTRACT invoices which have not been fully paid
734: /*
735: CURSOR l_contract_outst_bal_csr (cp_chr_id NUMBER) IS

Line 739: FROM okl_bpd_ar_inv_lines_v l --ansethur 01-MAR-2007 Added for R12 B Billing Architecture

735: CURSOR l_contract_outst_bal_csr (cp_chr_id NUMBER) IS
736: SELECT l.contract_line_id contract_line_id,
737: l.stream_type_id stream_type_id,
738: SUM (l.amount_due_remaining) amount_due
739: FROM okl_bpd_ar_inv_lines_v l --ansethur 01-MAR-2007 Added for R12 B Billing Architecture
740: -- FROM okl_bpd_leasing_payment_trx_v l --ansethur 01-MAR-2007 commented for R12 B Billing Architecture
741: WHERE l.CONTRACT_ID = cp_chr_id
742: AND NVL (l.amount_due_remaining, 0) <> 0
743: GROUP BY l.contract_line_id,

Line 754: FROM okl_bpd_ar_inv_lines_v l

750: cp_chr_id NUMBER) IS
751: SELECT l.contract_line_id contract_line_id,
752: l.stream_type_id stream_type_id,
753: SUM (l.amount_due_remaining) amount_due
754: FROM okl_bpd_ar_inv_lines_v l
755: , OKC_K_HEADERS_B CHR
756: WHERE l.contract_id = cp_chr_id
757: AND NVL (l.amount_due_remaining, 0) <> 0
758: AND CHR.ID = l.contract_id

Line 770: FROM okl_bpd_ar_inv_lines_v l

766: cp_chr_id NUMBER) IS
767: SELECT l.contract_line_id contract_line_id,
768: l.stream_type_id stream_type_id,
769: SUM (l.amount_due_remaining) amount_due
770: FROM okl_bpd_ar_inv_lines_v l
771: , OKC_K_HEADERS_B CHR
772: ,okc_k_lines_b cle,
773: okc_statuses_b sts
774: WHERE l.contract_id = cp_chr_id

Line 792: FROM okl_bpd_ar_inv_lines_v l

788: cp_chr_id NUMBER) IS
789: SELECT l.contract_line_id contract_line_id,
790: l.stream_type_id stream_type_id,
791: SUM (l.amount_due_remaining) amount_due
792: FROM okl_bpd_ar_inv_lines_v l
793: , OKC_K_HEADERS_all_B CHR
794: ,okc_k_lines_b cle
795: WHERE l.contract_id = cp_chr_id
796: and l.contract_line_id = cle.id(+)

Line 812: FROM okl_bpd_ar_inv_lines_v l --ansethur 01-MAR-2007 Added for R12 B Billing Architecture

808: CURSOR l_line_outst_bal_csr (cp_chr_id NUMBER,cp_cle_id NUMBER) IS
809: SELECT l.contract_line_id contract_line_id,
810: l.stream_type_id stream_type_id,
811: SUM (l.amount_due_remaining) amount_due
812: FROM okl_bpd_ar_inv_lines_v l --ansethur 01-MAR-2007 Added for R12 B Billing Architecture
813: -- FROM okl_bpd_leasing_payment_trx_v l --ansethur 01-MAR-2007 commented for R12 B Billing Architecture
814: WHERE l.CONTRACT_ID = cp_chr_id
815: AND l.contract_line_id = cp_cle_id
816: AND NVL (l.amount_due_remaining, 0) <> 0

Line 826: FROM okl_bpd_ar_inv_lines_v l --ansethur 01-MAR-2007 Added for R12 B Billing Architecture

822: cp_cle_id NUMBER) IS
823: SELECT l.contract_line_id contract_line_id,
824: l.stream_type_id stream_type_id,
825: SUM (l.amount_due_remaining) amount_due
826: FROM okl_bpd_ar_inv_lines_v l --ansethur 01-MAR-2007 Added for R12 B Billing Architecture
827: , OKC_K_HEADERS_B CHR
828: WHERE l.contract_id = cp_chr_id
829: AND l.contract_line_id = cp_cle_id
830: AND NVL (l.amount_due_remaining, 0) <> 0

Line 845: okl_bpd_ar_inv_lines_v l --ansethur 01-MAR-2007 Added for R12 B Billing Architecture

841: SELECT l.contract_line_id contract_line_id,
842: l.stream_type_id stream_type_id,
843: SUM (l.amount_due_remaining) amount_due
844: FROM okc_k_items i,
845: okl_bpd_ar_inv_lines_v l --ansethur 01-MAR-2007 Added for R12 B Billing Architecture
846: -- okl_bpd_leasing_payment_trx_v l --ansethur 01-MAR-2007 commented for R12 B Billing Architecture
847: WHERE i.object1_id1 = cp_cle_id
848: AND l.CONTRACT_ID = cp_chr_id
849: AND l.contract_line_id = i.cle_id

Line 861: okl_bpd_ar_inv_lines_v l --ansethur 01-MAR-2007 Added for R12 B Billing Architecture

857: SELECT l.contract_line_id contract_line_id,
858: l.stream_type_id stream_type_id,
859: SUM (l.amount_due_remaining) amount_due
860: FROM okc_k_items i,
861: okl_bpd_ar_inv_lines_v l --ansethur 01-MAR-2007 Added for R12 B Billing Architecture
862: , OKC_K_HEADERS_B CHR
863: WHERE i.object1_id1 = cp_cle_id
864: AND l.contract_id = cp_chr_id
865: AND l.contract_line_id = i.cle_id