APPS.OKI_DBI_LOAD_CLEB_PVT dependencies on OKC_K_LINES_B

Line 2144: WHERE cle_id not in (SELECT /*+ index_ffs(okc OKC_K_LINES_B_U1) parallel_index(okc OKC_K_LINES_B_U1) */

2140: (cle_id)
2141: SELECT /*+ index_ffs(f OKI_DBI_CLE_B_U1) parallel_index(f OKI_DBI_CLE_B_U1) */
2142: f.cle_id
2143: FROM oki_dbi_cle_b f
2144: WHERE cle_id not in (SELECT /*+ index_ffs(okc OKC_K_LINES_B_U1) parallel_index(okc OKC_K_LINES_B_U1) */
2145: id
2146: FROM okc_k_lines_b okc );
2147:
2148: l_count := SQL%ROWCOUNT;

Line 2146: FROM okc_k_lines_b okc );

2142: f.cle_id
2143: FROM oki_dbi_cle_b f
2144: WHERE cle_id not in (SELECT /*+ index_ffs(okc OKC_K_LINES_B_U1) parallel_index(okc OKC_K_LINES_B_U1) */
2145: id
2146: FROM okc_k_lines_b okc );
2147:
2148: l_count := SQL%ROWCOUNT;
2149: g_del_count := l_count;
2150: rlog('Number of lines identified for delete: ' ||

Line 2824: , okc_k_lines_b sl

2820: , NVL(sl.term_cancel_source, h.HDR_TERM_CANCEL_SOURCE) SL_TERM_CANCEL_SOURCE
2821: FROM
2822: oki_dbi_chr_inc h
2823: , oki_dbi_curr_conv cur
2824: , okc_k_lines_b sl
2825: , okc_k_lines_b l
2826: , ( select /*+ no_merge */ cii.instance_id
2827: , qpl.meaning agreement_type_code
2828: , oat.name agreement_name

Line 2825: , okc_k_lines_b l

2821: FROM
2822: oki_dbi_chr_inc h
2823: , oki_dbi_curr_conv cur
2824: , okc_k_lines_b sl
2825: , okc_k_lines_b l
2826: , ( select /*+ no_merge */ cii.instance_id
2827: , qpl.meaning agreement_type_code
2828: , oat.name agreement_name
2829: from oe_agreements_tl oat,

Line 5214: , okc_k_lines_b sl

5210: , NVL(sl.term_cancel_source, h.HDR_TERM_CANCEL_SOURCE ) SL_TERM_CANCEL_SOURCE /* ER 6684955 */
5211: FROM
5212: oki_dbi_chr_inc h
5213: , oki_dbi_curr_conv cur
5214: , okc_k_lines_b sl
5215: , okc_k_items itm
5216: , okc_k_lines_b l
5217: , ( select /*+ no_merge */ oab.agreement_id
5218: , qpl.meaning agreement_type_code

Line 5216: , okc_k_lines_b l

5212: oki_dbi_chr_inc h
5213: , oki_dbi_curr_conv cur
5214: , okc_k_lines_b sl
5215: , okc_k_items itm
5216: , okc_k_lines_b l
5217: , ( select /*+ no_merge */ oab.agreement_id
5218: , qpl.meaning agreement_type_code
5219: , oat.name agreement_name
5220: from oe_agreements_tl oat,