eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_TERMS_DEVIATIONS_PVT dependencies on STANDARD

Line 712: AND standard_YN = 'N')

708: AND document_id = p_doc_id
709: AND NVL(summary_amend_operation_code,'NULL') <> 'DELETED'
710: AND EXISTS (SELECT 1 FROM okc_articles_all oka
711: WHERE oka.article_id = oab.sav_sae_id
712: AND standard_YN = 'N')
713: AND NOT EXISTS (SELECT 1 from okc_terms_deviations_temp odt
714: WHERE odt.article_id = oab.orig_article_id);
715:
716:

Line 874: ** considers the standard clauses which were removed

870: l_compare_flag := 'N';
871:
872: elsif l_dev_cat.deviation_code = 'MISSING_OPTIONAL_ARTICLE' then
873: /*
874: ** considers the standard clauses which were removed
875: ** from the document but are existing on the template
876: ** Also, considers any new clauses added to the template
877: ** after it has been instantiated on the document (i.e,
878: ** in the latest version of the template

Line 1125: And oaa.standard_yn = 'Y')

1121: AND document_type = p_doc_type
1122: AND nvl(summary_amend_operation_code,'NULL') <> 'DELETED'
1123: AND EXISTS (Select 1 from okc_articles_all oaa
1124: Where oaa.article_id = oab.sav_sae_id
1125: And oaa.standard_yn = 'Y')
1126: AND NOT EXISTS (Select 1 from okc_terms_deviations_temp
1127: Where article_id = nvl(oab.orig_article_id,
1128: oab.sav_sae_id))
1129: -- Fix for bug# 4709359.