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_ADOPTIONS_GRP dependencies on OKC_ARTICLE_VERSIONS

Line 73: FROM OKC_ARTICLE_ADOPTIONS, OKC_ARTICLE_VERSIONS

69: start_date,
70: article_status,
71: local_article_version_id,
72: okc_article_adoptions.adoption_type
73: FROM OKC_ARTICLE_ADOPTIONS, OKC_ARTICLE_VERSIONS
74: WHERE global_article_version_id = cp_global_article_version_id
75: AND article_version_id = global_article_version_id
76: AND global_yn = 'Y'
77: AND local_org_id = cp_local_org_id

Line 94: okc_article_versions av,

90: ad.adoption_status,
91: av.article_version_number,
92: av.article_version_id
93: FROM
94: okc_article_versions av,
95: okc_article_adoptions ad
96: WHERE
97: av.article_id = cp_article_id
98: AND

Line 110: okc_article_versions av1,

106: AND
107: av.start_date = (SELECT
108: max(av1.start_date)
109: FROM
110: okc_article_versions av1,
111: okc_article_adoptions ad1
112: WHERE
113: av1.article_id = av.article_id
114: AND

Line 146: FROM OKC_ARTICLE_VERSIONS A, OKC_ARTICLE_ADOPTIONS AD

142: AD.ADOPTION_STATUS,
143: AD.LOCAL_ARTICLE_VERSION_ID,
144: A.ARTICLE_VERSION_NUMBER,
145: A.ARTICLE_VERSION_ID
146: FROM OKC_ARTICLE_VERSIONS A, OKC_ARTICLE_ADOPTIONS AD
147: WHERE A.ARTICLE_ID = cp_article_id
148: AND AD.GLOBAL_ARTICLE_VERSION_ID = A.ARTICLE_VERSION_ID
149: AND AD.LOCAL_ORG_ID = cp_local_org_id
150: AND AD.ADOPTION_TYPE <> 'AVAILABLE'

Line 160: OKC_ARTICLE_VERSIONS ARVG,

156: CURSOR l_lcz_article_id_csr(cp_global_article_id IN NUMBER,
157: cp_local_org_id IN NUMBER) IS
158: SELECT distinct(ARVL.ARTICLE_ID)
159: FROM OKC_ARTICLE_ADOPTIONS ADP,
160: OKC_ARTICLE_VERSIONS ARVG,
161: OKC_ARTICLE_VERSIONS ARVL
162: WHERE ARVG.ARTICLE_ID = cp_global_article_id
163: AND ADP.GLOBAL_ARTICLE_VERSION_ID = ARVG.ARTICLE_VERSION_ID
164: AND ADP.LOCAL_ORG_ID = cp_local_org_id

Line 161: OKC_ARTICLE_VERSIONS ARVL

157: cp_local_org_id IN NUMBER) IS
158: SELECT distinct(ARVL.ARTICLE_ID)
159: FROM OKC_ARTICLE_ADOPTIONS ADP,
160: OKC_ARTICLE_VERSIONS ARVG,
161: OKC_ARTICLE_VERSIONS ARVL
162: WHERE ARVG.ARTICLE_ID = cp_global_article_id
163: AND ADP.GLOBAL_ARTICLE_VERSION_ID = ARVG.ARTICLE_VERSION_ID
164: AND ADP.LOCAL_ORG_ID = cp_local_org_id
165: AND ADP.ADOPTION_TYPE = 'LOCALIZED'

Line 177: FROM OKC_ARTICLE_VERSIONS AV

173: AV.ADOPTION_TYPE,
174: AV.ARTICLE_STATUS ADOPTION_STATUS,
175: AV.ARTICLE_VERSION_NUMBER,
176: AV.ARTICLE_VERSION_ID
177: FROM OKC_ARTICLE_VERSIONS AV
178: WHERE AV.ARTICLE_ID = cp_lcz_article_id
179: AND AV.ADOPTION_TYPE = 'LOCALIZED'
180: AND AV.START_DATE = ( SELECT MAX(V.START_DATE)
181: FROM OKC_ARTICLE_VERSIONS V

Line 181: FROM OKC_ARTICLE_VERSIONS V

177: FROM OKC_ARTICLE_VERSIONS AV
178: WHERE AV.ARTICLE_ID = cp_lcz_article_id
179: AND AV.ADOPTION_TYPE = 'LOCALIZED'
180: AND AV.START_DATE = ( SELECT MAX(V.START_DATE)
181: FROM OKC_ARTICLE_VERSIONS V
182: WHERE V.ARTICLE_ID = cp_lcz_article_id
183: AND V.ADOPTION_TYPE = 'LOCALIZED');
184:
185: -- Cursor to check uniqueness of adopted article title in local

Line 852: (SELECT 1 FROM OKC_ARTICLE_VERSIONS V

848: WHERE R.SOURCE_ARTICLE_ID = cp_global_article_id
849: AND R.TARGET_ARTICLE_ID = A.ARTICLE_ID
850: AND R.ORG_ID = cp_global_org_id
851: AND EXISTS
852: (SELECT 1 FROM OKC_ARTICLE_VERSIONS V
853: WHERE V.ARTICLE_ID = R.TARGET_ARTICLE_ID
854: AND V.GLOBAL_YN = 'Y'
855: AND V.ARTICLE_STATUS = 'APPROVED'
856: AND NVL(V.END_DATE,SYSDATE + 1) > SYSDATE

Line 859: (SELECT 1 FROM OKC_ARTICLE_VERSIONS V1

855: AND V.ARTICLE_STATUS = 'APPROVED'
856: AND NVL(V.END_DATE,SYSDATE + 1) > SYSDATE
857: )
858: AND EXISTS
859: (SELECT 1 FROM OKC_ARTICLE_VERSIONS V1
860: WHERE V1.ARTICLE_ID = R.SOURCE_ARTICLE_ID
861: AND V1.GLOBAL_YN = 'Y'
862: AND V1.ARTICLE_STATUS = 'APPROVED'
863: AND NVL(V1.END_DATE,SYSDATE + 1) > SYSDATE

Line 1200: TYPE l_article_version_id_list IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;

1196: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
1197: TYPE l_adoption_type_list IS TABLE OF FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
1198: TYPE l_adoption_status_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE INDEX BY BINARY_INTEGER;
1199: TYPE l_adp_record_status_list IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
1200: TYPE l_article_version_id_list IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
1201: TYPE l_article_id_list IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
1202: TYPE l_article_title_list IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
1203: TYPE l_orig_system_ref_code_list IS TABLE of OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER ;
1204:

Line 1227: FROM OKC_ARTICLE_VERSIONS VER, OKC_ARTICLES_ALL ART

1223: -- Modified Cursor Where clause , Bug 3315511
1224: CURSOR l_adoptions_csr (cp_global_org_id IN NUMBER, cp_local_org_id IN NUMBER) IS
1225: SELECT article_version_id , article_title,
1226: art.article_id, art.orig_system_reference_code
1227: FROM OKC_ARTICLE_VERSIONS VER, OKC_ARTICLES_ALL ART
1228: WHERE global_yn = 'Y'
1229: AND org_id = cp_global_org_id
1230: AND VER.article_id = ART.article_id
1231: AND article_status in ('APPROVED', 'ON_HOLD')

Line 1245: FROM OKC_ARTICLE_VERSIONS VER, OKC_ARTICLES_ALL ART

1241: SELECT article_version_id , article_title , art.article_id ,
1242: start_date , end_date,
1243: global_yn , org_id , article_status,
1244: art.orig_system_reference_code
1245: FROM OKC_ARTICLE_VERSIONS VER, OKC_ARTICLES_ALL ART
1246: WHERE VER.article_id = ART.article_id
1247: AND global_yn = 'Y'
1248: AND org_id = cp_global_org_id
1249: AND start_date = ( SELECT max(start_date)

Line 1250: FROM OKC_ARTICLE_VERSIONS VER1,OKC_ARTICLES_ALL ART1

1246: WHERE VER.article_id = ART.article_id
1247: AND global_yn = 'Y'
1248: AND org_id = cp_global_org_id
1249: AND start_date = ( SELECT max(start_date)
1250: FROM OKC_ARTICLE_VERSIONS VER1,OKC_ARTICLES_ALL ART1
1251: WHERE VER1.ARTICLE_ID = ART1.ARTICLE_ID
1252: AND VER1.ARTICLE_ID = VER.ARTICLE_ID )
1253: )
1254: WHERE

Line 1529: (SELECT 1 FROM OKC_ARTICLE_VERSIONS V1, OKC_ARTICLE_ADOPTIONS A1

1525: sysdate
1526: FROM OKC_ARTICLE_RELATNS_ALL R
1527: WHERE R.ORG_ID = l_global_org_id
1528: AND EXISTS
1529: (SELECT 1 FROM OKC_ARTICLE_VERSIONS V1, OKC_ARTICLE_ADOPTIONS A1
1530: WHERE V1.ARTICLE_ID = R.TARGET_ARTICLE_ID
1531: AND A1.GLOBAL_ARTICLE_VERSION_ID = V1.ARTICLE_VERSION_ID
1532: AND V1.GLOBAL_YN = 'Y'
1533: AND A1.ADOPTION_STATUS = 'APPROVED'

Line 1538: (SELECT 1 FROM OKC_ARTICLE_VERSIONS V2, OKC_ARTICLE_ADOPTIONS A2

1534: AND A1.ADOPTION_TYPE = 'ADOPTED'
1535: AND A1.LOCAL_ORG_ID = p_org_id
1536: )
1537: AND EXISTS
1538: (SELECT 1 FROM OKC_ARTICLE_VERSIONS V2, OKC_ARTICLE_ADOPTIONS A2
1539: WHERE V2.ARTICLE_ID = R.SOURCE_ARTICLE_ID
1540: AND A2.GLOBAL_ARTICLE_VERSION_ID = V2.ARTICLE_VERSION_ID
1541: AND V2.GLOBAL_YN = 'Y'
1542: AND A2.ADOPTION_STATUS = 'APPROVED'