DBA Data[Home] [Help]

APPS.OKL_BILLING_UTIL_PVT dependencies on OKC_GOVERNANCES

Line 1714: okc_governances gv,

1710: FROM ra_customer_trx_lines_all ractrl
1711: WHERE ractrl.interface_line_attribute6 IN
1712: (select chr.contract_number
1713: from okc_k_headers_b chr,
1714: okc_governances gv,
1715: okc_k_headers_b crchr
1716: where crchr.id = p_cr_contract_id
1717: and crchr.sts_code = 'ACTIVE'
1718: and crchr.scs_code = 'CREDITLINE_CONTRACT'

Line 1725: okc_governances mla_g1,

1721: and chr.scs_code = 'LEASE'
1722: UNION
1723: select chr.contract_number
1724: from okc_k_headers_b mla_chr,
1725: okc_governances mla_g1,
1726: okc_k_headers_b chr
1727: where mla_chr.id = mla_g1.chr_id_referred
1728: and mla_chr.scs_code = 'MASTER_LEASE'
1729: and mla_chr.id IN

Line 1733: okc_governances cl_gl

1729: and mla_chr.id IN
1730: (
1731: select cl_gl.dnz_chr_id
1732: from okc_k_headers_b cl_chr,
1733: okc_governances cl_gl
1734: where cl_chr.id = p_cr_contract_id
1735: and cl_chr.sts_code = 'ACTIVE'
1736: and cl_chr.scs_code = 'CREDITLINE_CONTRACT'
1737: and cl_chr.id = cl_gl.chr_id_referred