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.PO_EDA_DATATEMPLATE_PKG dependencies on OKC_ARTICLE_VERSIONS

Line 215: SELECT Count(DISTINCT art.article_title) AS articles FROM okc_k_articles_b kartb, okc_article_versions ver, okc_articles_all art

211:
212: l_clause_exists varchar2(10);
213: cursor csr_check_clauses is
214: SELECT 'true' FROM (
215: SELECT Count(DISTINCT art.article_title) AS articles FROM okc_k_articles_b kartb, okc_article_versions ver, okc_articles_all art
216: WHERE kartb.article_version_id = ver.article_version_id
217: AND kartb.sav_Sae_id = art.article_id
218: AND ver.article_id = art.article_id
219: AND kartb.document_id in

Line 738: FROM okc_k_articles_b kartb, okc_articles_all art, okc_article_versions ver

734: FUNCTION get_miscclausetext(p_scn_id NUMBER) RETURN CLOB AS
735:
736: CURSOR c2 IS
737: SELECT article_text
738: FROM okc_k_articles_b kartb, okc_articles_all art, okc_article_versions ver
739: WHERE kartb.document_type = DOCUMENTTYPE
740: AND kartb.document_id = decode(ISMOD,'N',DOCUMENTID,DRAFTID)
741: AND kartb.sav_sae_id = art.article_id
742: AND kartb.article_version_id = ver.article_version_id

Line 764: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver

760:
761: CURSOR c2 IS
762:
763: SELECT ARTICLE_TEXT
764: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver
765: WHERE kartb.sav_sae_id = art.article_id
766: AND art.article_id = ver.article_id
767: AND document_id = Decode(isMod,'N',DOCUMENTID,'Y',DRAFTID,DOCUMENTID)
768: AND kartb.document_type = DOCUMENTTYPE

Line 1116: FROM okc_k_articles_b kartb, okc_articles_all art, okc_article_versions ver

1112:
1113:
1114: CURSOR c_misctext_base IS
1115: SELECT (SELECT heading FROM okc_sections_b WHERE id = kartb.scn_id) Section,get_miscclausetxt(scn_id,'N') MiscellaneousText
1116: FROM okc_k_articles_b kartb, okc_articles_all art, okc_article_versions ver
1117: WHERE kartb.document_id = DOCUMENTID
1118: AND kartb.sav_sae_id = art.article_id
1119: AND kartb.article_version_id = ver.article_version_id
1120: AND art.article_id = ver.article_id

Line 1128: FROM okc_k_articles_b kartb, okc_articles_all art, okc_article_versions ver

1124: ORDER BY scn_id;
1125:
1126: CURSOR c_misctext_mod IS
1127: SELECT (SELECT heading FROM okc_sections_b WHERE id = kartb.scn_id) Section,get_miscclausetxt(scn_id,'Y') MiscellaneousText
1128: FROM okc_k_articles_b kartb, okc_articles_all art, okc_article_versions ver
1129: WHERE kartb.document_id = DRAFTID
1130: AND kartb.sav_sae_id = art.article_id
1131: AND kartb.article_version_id = ver.article_version_id
1132: AND art.article_id = ver.article_id

Line 2279: FROM okc_article_versions ver, okc_k_articles_b kartb

2275: FUNCTION get_miscclausetxt(p_scn_id NUMBER,isMod VARCHAR2) RETURN CLOB AS
2276:
2277: CURSOR c2 IS
2278: SELECT article_text
2279: FROM okc_article_versions ver, okc_k_articles_b kartb
2280: WHERE kartb.article_version_id = ver.article_version_id
2281: AND kartb.sav_sae_id = ver.article_id
2282: AND scn_id = p_scn_id
2283: AND kartb.document_id = Decode(isMod,'N',DOCUMENTID,DRAFTID);

Line 2732: l_sql := 'SELECT article_text FROM okc_article_versions WHERE INSERT_BY_REFERENCE <> ''Y'' AND article_version_id=' ||

2728: FUNCTION getArticleText(p_article_version_id NUMBER, p_article_id NUMBER) RETURN CLOB AS
2729: l_sql VARCHAR2(4000);
2730: l_ret CLOB;
2731: BEGIN
2732: l_sql := 'SELECT article_text FROM okc_article_versions WHERE INSERT_BY_REFERENCE <> ''Y'' AND article_version_id=' ||
2733: p_article_version_id || ' AND article_id = ' || p_article_id ;
2734: EXECUTE IMMEDIATE l_sql INTO l_ret;
2735: RETURN l_ret;
2736:

Line 2870: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn

2866: Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',
2867: 'DFARS','http://www.acq.osd.mil/dpap/dars/index.html',
2868: ' '),
2869: nvl(ver.REFERENCE_SOURCE,' ')) RegulationURL
2870: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn
2871: WHERE
2872: poh.draft_id = p_draftid AND poh.change_status IS NOT NULL
2873: AND kartb.sav_sae_id = art.article_id
2874: AND kartb.article_version_id = ver.article_version_id

Line 2887: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn

2883: Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',
2884: 'DFARS','http://www.acq.osd.mil/dpap/dars/index.html',
2885: ' '),
2886: nvl(ver.REFERENCE_SOURCE,' ')) RegulationURL
2887: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn
2888: WHERE
2889: poh.po_header_id = p_docid AND poh.draft_id = -1 AND poh.change_status is NULL
2890: AND kartb.sav_sae_id = art.article_id
2891: AND kartb.article_version_id = ver.article_version_id

Line 2905: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn

2901: Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',
2902: 'DFARS','http://www.acq.osd.mil/dpap/dars/index.html',
2903: ' '),
2904: nvl(ver.REFERENCE_SOURCE,' ')) RegulationURL
2905: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn
2906: WHERE
2907: poh.po_header_id = p_docid AND poh.draft_id = -1 AND poh.change_status is NULL
2908: AND kartb.sav_sae_id = art.article_id
2909: AND kartb.article_version_id = ver.article_version_id

Line 2922: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn

2918: Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',
2919: 'DFARS','http://www.acq.osd.mil/dpap/dars/index.html',
2920: ' '),
2921: nvl(ver.REFERENCE_SOURCE,' ')) RegulationURL
2922: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn
2923: WHERE
2924: poh.draft_id = p_draftid AND poh.change_status IS NOT NULL
2925: AND kartb.sav_sae_id = art.article_id
2926: AND kartb.article_version_id = ver.article_version_id

Line 2956: from okc_k_articles_b kartborig, okc_k_articles_b kartbmod, okc_articles_all artorig, okc_articles_all artmod, okc_article_versions verorig,

2952: decode(artmod.ARTICLE_NUMBER, artorig.ARTICLE_NUMBER, NULL, ' Clause Number Changed.') CHANGE2,
2953: decode(artmod.ARTICLE_TITLE, artorig.ARTICLE_TITLE, NULL, ' Clause Title Changed.') CHANGE3,
2954: decode(vermod.START_DATE, verorig.START_DATE, NULL, ' Clause Effective Date Changed.') CHANGE4,
2955: decode(dbms_lob.compare(vermod.article_text,verorig.article_text),0,NULL,' Clause Text Changed.') CHANGE5
2956: from okc_k_articles_b kartborig, okc_k_articles_b kartbmod, okc_articles_all artorig, okc_articles_all artmod, okc_article_versions verorig,
2957: okc_article_versions vermod
2958: where kartbmod.id = p_kartid
2959: and kartbmod.orig_system_reference_id1 = kartborig.id
2960: and artmod.article_id = vermod.article_id

Line 2957: okc_article_versions vermod

2953: decode(artmod.ARTICLE_TITLE, artorig.ARTICLE_TITLE, NULL, ' Clause Title Changed.') CHANGE3,
2954: decode(vermod.START_DATE, verorig.START_DATE, NULL, ' Clause Effective Date Changed.') CHANGE4,
2955: decode(dbms_lob.compare(vermod.article_text,verorig.article_text),0,NULL,' Clause Text Changed.') CHANGE5
2956: from okc_k_articles_b kartborig, okc_k_articles_b kartbmod, okc_articles_all artorig, okc_articles_all artmod, okc_article_versions verorig,
2957: okc_article_versions vermod
2958: where kartbmod.id = p_kartid
2959: and kartbmod.orig_system_reference_id1 = kartborig.id
2960: and artmod.article_id = vermod.article_id
2961: and artorig.article_id = verorig.article_id

Line 3009: SELECT article_text INTO l_clause_text FROM okc_article_versions WHERE article_id = l_article_id AND ARTICLE_VERSION_ID=l_article_ver_id;

3005:
3006: BEGIN
3007:
3008: SELECT sav_sae_id,article_version_id INTO l_article_id,l_article_ver_id FROM okc_k_articles_b WHERE id = p_kart_id;
3009: SELECT article_text INTO l_clause_text FROM okc_article_versions WHERE article_id = l_article_id AND ARTICLE_VERSION_ID=l_article_ver_id;
3010:
3011: l_var_seq_num :=1;
3012: dbms_lob.createtemporary(l_output_xml, true);
3013: dbms_lob.open(l_output_xml, dbms_lob.lob_readwrite);