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_PAY_INVOICES_DISB_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 1760: ,ar_payment_schedules_all aps

1756: ,okl_trx_ar_invoices_v tai
1757: ,okl_txl_ar_inv_lns_v til
1758: ,okl_txd_ar_ln_dtls_b tld
1759: ,okl_party_payment_hdr pph
1760: ,ar_payment_schedules_all aps
1761: WHERE khr.contract_number = NVL(p_contract_number, khr.contract_number)
1762: AND khr.id = kle.dnz_chr_id
1763: AND kle.id = til.kle_id
1764: AND arl.receivables_invoice_id > 0

Line 1839: ,ar_payment_schedules_all aps

1835: ,okl_trx_ar_invoices_v tai
1836: ,okl_txl_ar_inv_lns_v til
1837: ,okl_txd_ar_ln_dtls_b tld
1838: ,okl_party_payment_hdr pph
1839: ,ar_payment_schedules_all aps
1840: WHERE khr.contract_number = NVL(p_contract_number, khr.contract_number)
1841: AND khr.id = sub_kle.dnz_chr_id
1842: AND sub_kle.chr_id is null
1843: --rkuttiya commented for R12 B Billing Architecture

Line 1933: ,ar_payment_schedules_all aps

1929: -- 05/31/07 ansethur added for R12B Billing architecture Passthrough impacts starts
1930: ,okl_txd_ar_ln_dtls_b tld
1931: -- 05/31/07 ansethur added for R12B Billing architecture Passthrough impacts ends
1932: ,okl_party_payment_hdr pph
1933: ,ar_payment_schedules_all aps
1934: WHERE khr.contract_number = NVL(p_contract_number, khr.contract_number)
1935: AND khr.id = kle.dnz_chr_id
1936: AND kle.id = til.kle_id
1937: AND arl.receivables_invoice_id > 0

Line 2012: ,ar_payment_schedules_all aps

2008: -- 05/31/07 ansethur added for R12B Billing architecture Passthrough impacts starts
2009: ,okl_txd_ar_ln_dtls_b tld
2010: -- 05/31/07 ansethur added for R12B Billing architecture Passthrough impacts ends
2011: ,okl_party_payment_hdr pph
2012: ,ar_payment_schedules_all aps
2013: WHERE khr.contract_number = NVL(p_contract_number, khr.contract_number)
2014: AND khr.id = sub_kle.dnz_chr_id
2015: AND sub_kle.chr_id is null
2016: AND sub_kle.id = til.kle_id

Line 2612: AR_PAYMENT_SCHEDULES_ALL PS,

2608: cursor c_princ_tot(p_creditline_id number) is
2609: SELECT
2610: NVL(SUM(NVL(PS.AMOUNT_APPLIED,0)),0)
2611: FROM
2612: AR_PAYMENT_SCHEDULES_ALL PS,
2613: --rkuttiya R12 B Billing Architecture commented
2614: --OKL_CNSLD_AR_STRMS_B ST,
2615: okl_bpd_ar_inv_lines_v ST,
2616: --OKL_STRM_TYPE_TL SM,