[Home] [Help]
1807: ,okl_trx_ar_invoices_v tai
1808: ,okl_txl_ar_inv_lns_v til
1809: ,okl_txd_ar_ln_dtls_b tld
1810: ,okl_party_payment_hdr pph
1811: ,ar_payment_schedules_all aps
1812: WHERE khr.contract_number = NVL(p_contract_number, khr.contract_number)
1813: AND khr.id = kle.dnz_chr_id
1814: AND kle.id = til.kle_id
1815: AND arl.receivables_invoice_id > 0
1888: ,okl_trx_ar_invoices_v tai
1889: ,okl_txl_ar_inv_lns_v til
1890: ,okl_txd_ar_ln_dtls_b tld
1891: ,okl_party_payment_hdr pph
1892: ,ar_payment_schedules_all aps
1893: WHERE khr.contract_number = NVL(p_contract_number, khr.contract_number)
1894: AND khr.id = sub_kle.dnz_chr_id
1895: AND sub_kle.chr_id is null
1896: --rkuttiya commented for R12 B Billing Architecture
1982: -- 05/31/07 ansethur added for R12B Billing architecture Passthrough impacts starts
1983: ,okl_txd_ar_ln_dtls_b tld
1984: -- 05/31/07 ansethur added for R12B Billing architecture Passthrough impacts ends
1985: ,okl_party_payment_hdr pph
1986: ,ar_payment_schedules_all aps
1987: WHERE khr.contract_number = NVL(p_contract_number, khr.contract_number)
1988: AND khr.id = kle.dnz_chr_id
1989: AND kle.id = til.kle_id
1990: AND arl.receivables_invoice_id > 0
2061: -- 05/31/07 ansethur added for R12B Billing architecture Passthrough impacts starts
2062: ,okl_txd_ar_ln_dtls_b tld
2063: -- 05/31/07 ansethur added for R12B Billing architecture Passthrough impacts ends
2064: ,okl_party_payment_hdr pph
2065: ,ar_payment_schedules_all aps
2066: WHERE khr.contract_number = NVL(p_contract_number, khr.contract_number)
2067: AND khr.id = sub_kle.dnz_chr_id
2068: AND sub_kle.chr_id is null
2069: AND sub_kle.id = til.kle_id
2661: cursor c_princ_tot(p_creditline_id number) is
2662: SELECT
2663: NVL(SUM(NVL(PS.AMOUNT_APPLIED,0)),0)
2664: FROM
2665: AR_PAYMENT_SCHEDULES_ALL PS,
2666: --rkuttiya R12 B Billing Architecture commented
2667: --OKL_CNSLD_AR_STRMS_B ST,
2668: okl_bpd_ar_inv_lines_v ST,
2669: --OKL_STRM_TYPE_TL SM,