DBA Data[Home] [Help]

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 751: FROM okl_bpd_ar_inv_lines_v l

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

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

761: CURSOR l_line_outst_bal_csr (cp_chr_id NUMBER,cp_cle_id NUMBER) IS
762: SELECT l.contract_line_id contract_line_id,
763: l.stream_type_id stream_type_id,
764: SUM (l.amount_due_remaining) amount_due
765: FROM okl_bpd_ar_inv_lines_v l --ansethur 01-MAR-2007 Added for R12 B Billing Architecture
766: -- FROM okl_bpd_leasing_payment_trx_v l --ansethur 01-MAR-2007 commented for R12 B Billing Architecture
767: WHERE l.CONTRACT_ID = cp_chr_id
768: AND l.contract_line_id = cp_cle_id
769: AND NVL (l.amount_due_remaining, 0) <> 0

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

775: cp_cle_id NUMBER) IS
776: SELECT l.contract_line_id contract_line_id,
777: l.stream_type_id stream_type_id,
778: SUM (l.amount_due_remaining) amount_due
779: FROM okl_bpd_ar_inv_lines_v l --ansethur 01-MAR-2007 Added for R12 B Billing Architecture
780: , OKC_K_HEADERS_B CHR
781: WHERE l.contract_id = cp_chr_id
782: AND l.contract_line_id = cp_cle_id
783: AND NVL (l.amount_due_remaining, 0) <> 0

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

792: SELECT l.contract_line_id contract_line_id,
793: l.stream_type_id stream_type_id,
794: SUM (l.amount_due_remaining) amount_due
795: FROM okc_k_items i,
796: okl_bpd_ar_inv_lines_v l --ansethur 01-MAR-2007 Added for R12 B Billing Architecture
797: -- okl_bpd_leasing_payment_trx_v l --ansethur 01-MAR-2007 commented for R12 B Billing Architecture
798: WHERE i.object1_id1 = cp_cle_id
799: AND l.CONTRACT_ID = cp_chr_id
800: AND l.contract_line_id = i.cle_id

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

808: SELECT l.contract_line_id contract_line_id,
809: l.stream_type_id stream_type_id,
810: SUM (l.amount_due_remaining) amount_due
811: FROM okc_k_items i,
812: okl_bpd_ar_inv_lines_v l --ansethur 01-MAR-2007 Added for R12 B Billing Architecture
813: , OKC_K_HEADERS_B CHR
814: WHERE i.object1_id1 = cp_cle_id
815: AND l.contract_id = cp_chr_id
816: AND l.contract_line_id = i.cle_id