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 OKC_K_ARTICLES_B

Line 98: okc_k_articles_b

94: l_article_version_id,
95: l_art_seq_id,
96: l_orig_article_id
97: From
98: okc_k_articles_b
99: Where document_Type = 'TEMPLATE'
100: And document_Id = p_template_id;
101:
102: else -- provision_allowed = N

Line 123: okc_k_articles_b oab

119: l_article_version_id,
120: l_art_seq_id,
121: l_orig_article_id
122: From
123: okc_k_articles_b oab
124: Where document_Type = 'TEMPLATE'
125: And document_Id = p_template_id
126: And Exists (Select 1 From okc_article_versions oav
127: Where oab.sav_sae_id = oav.article_id

Line 706: FROM okc_k_articles_b oab

702: l_article_title,
703: l_display_sequence,
704: l_mandatory_flag,
705: l_orig_article_id
706: FROM okc_k_articles_b oab
707: WHERE document_type = p_doc_type
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

Line 758: FROM okc_k_articles_b oab

754: l_article_title,
755: l_display_sequence,
756: l_mandatory_flag,
757: l_orig_article_id
758: FROM okc_k_articles_b oab
759: WHERE ref_article_id is not null
760: AND ref_article_version_id is not null
761: AND document_id = p_doc_id
762: AND document_type = p_doc_type

Line 809: AND NOT EXISTS ( Select 1 from okc_k_articles_b oab

805: l_orig_article_id
806: FROM okc_terms_deviations_temp otd
807: WHERE otd.source_flag = 'R'
808: AND x_include_exp = 'Y'
809: AND NOT EXISTS ( Select 1 from okc_k_articles_b oab
810: Where oab.document_type = p_doc_type
811: And oab.document_id = p_doc_id
812: And (oab.orig_article_id = otd.article_id
813: OR oab.sav_sae_id = otd.article_id)

Line 862: AND (NOT EXISTS ( Select 1 from okc_k_articles_b oab

858: FROM okc_terms_deviations_temp otd
859: WHERE otd.source_flag = 'T'
860: AND otd.mandatory_flag = 'Y'
861: --Bug 4070733 Added condition to check for ammendement operation code
862: AND (NOT EXISTS ( Select 1 from okc_k_articles_b oab
863: Where oab.document_type = p_doc_type
864: And oab.document_id = p_doc_id
865: And (oab.orig_article_id = otd.article_id
866: --Bug 4077070

Line 915: AND (NOT EXISTS ( Select 1 from okc_k_articles_b oab

911: FROM okc_terms_deviations_temp otd
912: WHERE otd.source_flag = 'T'
913: AND otd.mandatory_flag = 'N'
914: --Bug 4070733 Added condition to check for ammendement operation code
915: AND (NOT EXISTS ( Select 1 from okc_k_articles_b oab
916: Where oab.document_type = p_doc_type
917: And oab.document_id = p_doc_id
918: And (oab.orig_article_id = otd.article_id
919: --Bug 4077070

Line 966: FROM okc_k_articles_b oab

962: l_article_title,
963: l_display_sequence,
964: l_mandatory_flag,
965: l_orig_article_id
966: FROM okc_k_articles_b oab
967: WHERE document_id = p_doc_id
968: AND document_type = p_doc_type
969: AND nvl(summary_amend_operation_code,'NULL') <> 'DELETED'
970: AND EXISTS (Select 1 from okc_article_versions oav

Line 1015: FROM okc_k_articles_b oab

1011: l_article_title,
1012: l_display_sequence,
1013: l_mandatory_flag,
1014: l_orig_article_id
1015: FROM okc_k_articles_b oab
1016: WHERE document_id = p_doc_id
1017: AND document_type = p_doc_type
1018: and nvl(summary_amend_operation_code,'NULL') <> 'DELETED'
1019: AND EXISTS (Select 1 from okc_article_versions oav

Line 1066: FROM okc_k_articles_b oab

1062: l_article_title,
1063: l_display_sequence,
1064: l_mandatory_flag,
1065: l_orig_article_id
1066: FROM okc_k_articles_b oab
1067: WHERE oab.source_flag = 'R'
1068: AND document_id = p_doc_id
1069: AND document_type = p_doc_type
1070: AND nvl(summary_amend_operation_code,'NULL') <> 'DELETED'

Line 1119: FROM okc_k_articles_b oab

1115: l_article_title,
1116: l_display_sequence,
1117: l_mandatory_flag,
1118: l_orig_article_id
1119: FROM okc_k_articles_b oab
1120: WHERE document_id = p_doc_id
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

Line 1175: FROM okc_k_articles_b oab, okc_terms_deviations_temp odt

1171: l_article_title,
1172: l_display_sequence,
1173: l_mandatory_flag,
1174: l_orig_article_id
1175: FROM okc_k_articles_b oab, okc_terms_deviations_temp odt
1176: WHERE oab.document_id = p_doc_id
1177: AND oab.document_type = p_doc_type
1178: AND oab.source_flag = odt.source_flag
1179: AND nvl(oab.summary_amend_operation_code,'NULL') <> 'DELETED'