DBA Data[Home] [Help]

APPS.OKL_PAY_INVOICES_DISB_PVT dependencies on OKL_TXD_AR_LN_DTLS_B

Line 143: okl_txd_ar_ln_dtls_b tld,

139: -- 13619067
140: CURSOR l_receipt_amount_csr(cp_customer_trx_id NUMBER) IS
141: select nvl(sum(line_applied),0)
142: from ar_receivable_applications_all raa,
143: okl_txd_ar_ln_dtls_b tld,
144: ra_customer_trx_lines_all ractrl
145: WHERE tld.ID = ractrl.interface_line_attribute14
146: and raa.applied_customer_trx_id=cp_customer_trx_id
147: and raa.applied_customer_trx_id = ractrl.customer_trx_id

Line 1644: ,okl_txd_ar_ln_dtls_b tld

1640: ,okl_bpd_ar_inv_lines_v arl
1641: ,okl_bpd_ar_invoices_v arv
1642: ,okl_trx_ar_invoices_v tai
1643: ,okl_txl_ar_inv_lns_v til
1644: ,okl_txd_ar_ln_dtls_b tld
1645: ,okl_party_payment_hdr pph
1646: WHERE khr.contract_number = NVL(p_contract_number, khr.contract_number)
1647: AND khr.id = kle.dnz_chr_id
1648: AND kle.id = til.kle_id

Line 1719: ,okl_txd_ar_ln_dtls_b tld

1715: ,okl_bpd_ar_inv_lines_v arl
1716: ,okl_bpd_ar_invoices_v arv
1717: ,okl_trx_ar_invoices_v tai
1718: ,okl_txl_ar_inv_lns_v til
1719: ,okl_txd_ar_ln_dtls_b tld
1720: ,okl_party_payment_hdr pph
1721: WHERE khr.contract_number = NVL(p_contract_number, khr.contract_number)
1722: AND khr.id = sub_kle.dnz_chr_id
1723: AND sub_kle.chr_id is null

Line 1809: ,okl_txd_ar_ln_dtls_b tld

1805: ,okl_bpd_ar_inv_lines_v arl
1806: ,okl_bpd_ar_invoices_v arv
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

Line 1890: ,okl_txd_ar_ln_dtls_b tld

1886: ,okl_bpd_ar_inv_lines_v arl
1887: ,okl_bpd_ar_invoices_v arv
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

Line 1983: ,okl_txd_ar_ln_dtls_b tld

1979: ,okl_bpd_ar_invoices_v arv
1980: ,okl_trx_ar_invoices_v tai
1981: ,okl_txl_ar_inv_lns_v til
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)

Line 2062: ,okl_txd_ar_ln_dtls_b tld

2058: ,okl_bpd_ar_invoices_v arv
2059: ,okl_trx_ar_invoices_v tai
2060: ,okl_txl_ar_inv_lns_v til
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)