DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKC_STATUSES_B

Line 1867: okc_statuses_b chr_sts,

1863: AND fa.asset_number = oli.asset_number
1864: AND oli.asset_number = p_asset_number -- Bug #15992711: Add extra condition to fetch the record pertaining to asset number
1865: AND not exists (SELECT '1'
1866: FROM okc_k_headers_b chrb_2,
1867: okc_statuses_b chr_sts,
1868: okc_k_lines_b cleb_2,
1869: okc_statuses_b cle_sts,
1870: okc_k_items cim_2
1871: WHERE chrb_2.id = cleb_2.dnz_chr_id

Line 1869: okc_statuses_b cle_sts,

1865: AND not exists (SELECT '1'
1866: FROM okc_k_headers_b chrb_2,
1867: okc_statuses_b chr_sts,
1868: okc_k_lines_b cleb_2,
1869: okc_statuses_b cle_sts,
1870: okc_k_items cim_2
1871: WHERE chrb_2.id = cleb_2.dnz_chr_id
1872: AND chrb_2.scs_code in ('LEASE','LOAN')
1873: AND chrb_2.sts_code = chr_sts.code