DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKC_STATUSES_B

Line 1861: okc_statuses_b chr_sts,

1857: AND cim_fa.object1_id2 ='#'
1858: AND fa.asset_number = oli.asset_number
1859: AND not exists (SELECT '1'
1860: FROM okc_k_headers_b chrb_2,
1861: okc_statuses_b chr_sts,
1862: okc_k_lines_b cleb_2,
1863: okc_statuses_b cle_sts,
1864: okc_k_items cim_2
1865: WHERE chrb_2.id = cleb_2.dnz_chr_id

Line 1863: okc_statuses_b cle_sts,

1859: AND not exists (SELECT '1'
1860: FROM okc_k_headers_b chrb_2,
1861: okc_statuses_b chr_sts,
1862: okc_k_lines_b cleb_2,
1863: okc_statuses_b cle_sts,
1864: okc_k_items cim_2
1865: WHERE chrb_2.id = cleb_2.dnz_chr_id
1866: AND chrb_2.scs_code in ('LEASE','LOAN')
1867: AND chrb_2.sts_code = chr_sts.code