DBA Data[Home] [Help]

APPS.OKL_AM_CREATE_QUOTE_PVT dependencies on OKC_K_ITEMS

Line 350: okc_k_items cim_ib,

346: AND chr.sts_code = stl.code
347: AND stl.LANGUAGE = userenv('LANG')
348: AND chr.id IN (SELECT DISTINCT cim_ib.dnz_chr_id chr_id
349: FROM csi_item_instances csi,
350: okc_k_items cim_ib,
351: okc_line_styles_b lse_ib,
352: okc_k_lines_b cle_ib,
353: okc_k_headers_b chr
354: WHERE cle_ib.lse_id = lse_ib.id

Line 416: okc_k_items cim_ib,

412: AND chr.sts_code = stl.code
413: AND stl.LANGUAGE = userenv('LANG')
414: AND chr.id IN (SELECT DISTINCT cle_fin.dnz_chr_id chr_id
415: FROM csi_item_instances csi,
416: okc_k_items cim_ib,
417: okc_line_styles_b lse_ib,
418: okc_k_lines_b cle_ib,
419: okc_line_styles_b lse_inst,
420: okc_k_lines_b cle_inst,

Line 1566: okc_k_items lnk_srv_cim

1562: okc_k_rel_objs krel,
1563: okc_line_styles_b lnk_srv_lse,
1564: okc_statuses_b lnk_srv_sts,
1565: okc_k_lines_b lnk_srv_cleb,
1566: okc_k_items lnk_srv_cim
1567: WHERE oks_chrb.scs_code = 'SERVICE'
1568: AND oks_chrb.id = oks_cov_pd_cleb.dnz_chr_id
1569: AND oks_cov_pd_cleb.lse_id = oks_cov_pd_lse.id
1570: AND oks_cov_pd_lse.lty_code = 'COVER_PROD'