APPS.OKC_CODE_HOOK dependencies on OKC_ARTICLES_ALL

Line 403: FROM okc_k_articles_b,okc_articles_all

399: SubStr(article_number,InStr(article_number,'.')+1,InStr(article_number,' ')-InStr(article_number,'.')))),SubStr(article_number,InStr(article_number,'.')+1, InStr(article_number,'-')-InStr(article_number,'.')-1)) col2,
400: Decode(InStr(article_number,' '),0,Decode(InStr(article_number,'-'),0,0,SubStr(article_number,InStr(article_number,'-')+1)),
401: Decode(InStr(article_number,'-'),0,0,SubStr(article_number,InStr(article_number,'-')+1, InStr(article_number,' ')-InStr(article_number,'-')-1))) col3,
402: Decode(InStr(article_number,' '),0,' ',SubStr(article_number,InStr(article_number,' ')+1)) col4
403: FROM okc_k_articles_b,okc_articles_all
404: WHERE document_type=p_doc_type AND
405: document_id=p_doc_id AND
406: sav_sae_id=article_id
407: ORDER BY scn_id,To_Number(col1),To_Number(col2),To_Number(col3),col4);

Line 412: FROM okc_k_articles_b,okc_articles_all

408:
409:
410: cursor c_sort_aplhanumeric is
411: SELECT id,scn_id
412: FROM okc_k_articles_b,okc_articles_all
413: WHERE document_type=p_doc_type AND
414: document_id=p_doc_id AND
415: sav_sae_id=article_id
416: ORDER BY scn_id,article_number;