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_ARTWF_PVT dependencies on STANDARD

Line 26: and art.standard_yn = 'Y'

22: from
23: okc_articles_all art,
24: okc_article_versions artv
25: where art.article_id = artv.article_id
26: and art.standard_yn = 'Y'
27: and artv.article_status in ('DRAFT','REJECTED')
28: and art.org_id = cp_org_id
29: and artv.article_version_id = cp_version_id
30: and greatest(nvl(trunc(end_date), trunc(sysdate))+1, trunc(sysdate)) <> trunc(sysdate); -- bug#3517002

Line 63: and art.standard_yn = 'Y'

59: okc_articles_all art,
60: okc_article_versions artv,
61: okc_article_adoptions arta
62: where art.article_id = artv.article_id
63: and art.standard_yn = 'Y'
64: and artv.global_yn = 'Y'
65: and arta.adoption_type = 'AVAILABLE'
66: and (arta.adoption_status = 'REJECTED' or arta.adoption_status is null)
67: and arta.local_org_id = cp_org_id

Line 264: and art.standard_yn = 'Y'

260: okc_articles_all art,
261: okc_article_versions artv,
262: okc_art_interface_all int
263: where art.article_id = artv.article_id
264: and art.standard_yn = 'Y'
265: and artv.article_status in ('PENDING_APPROVAL','APPROVED')
266: and art.article_title = int.article_title
267: and int.process_status in ('W', 'S') -- this process status tells
268: -- that the article has been imported

Line 935: where art.standard_yn = 'Y'

931: okc_lookups_v tm,
932: okc_lookups_v im,
933: okc_lookups_v gm,
934: okc_lookups_v pm
935: where art.standard_yn = 'Y'
936: and art.org_id = cp_org_id
937: and article_version_id = cp_art_ver_id
938: and art.article_id = artv.article_id
939: and tm.lookup_type ='OKC_SUBJECT'

Line 968: where art.standard_yn = 'Y'

964: okc_lookups_v tm,
965: okc_lookups_v im,
966: okc_lookups_v gm,
967: okc_lookups_v pm
968: where art.standard_yn = 'Y'
969: and artv.global_yn = 'Y'
970: and arta.local_org_id = cp_org_id
971: and article_version_id = cp_art_ver_id
972: and art.article_id = artv.article_id

Line 1387: where art.standard_yn = 'Y'

1383: select 'Y'
1384: from
1385: okc_articles_all art,
1386: okc_article_versions artv
1387: where art.standard_yn = 'Y'
1388: and art.article_id = artv.article_id
1389: and artv.article_version_id = p_article_version_id
1390: and art.org_id = p_org_id
1391: union all

Line 1397: where art.standard_yn = 'Y'

1393: from
1394: okc_articles_all art,
1395: okc_article_versions artv,
1396: okc_article_adoptions arta
1397: where art.standard_yn = 'Y'
1398: and artv.global_yn = 'Y'
1399: and art.article_id = artv.article_id
1400: and artv.article_version_id = arta.global_article_version_id
1401: and artv.article_version_id = p_article_version_id

Line 1424: where art.standard_yn = 'Y'

1420: artv.article_status) article_status
1421: from
1422: okc_articles_all art,
1423: okc_article_versions artv
1424: where art.standard_yn = 'Y'
1425: and art.article_id = artv.article_id
1426: and artv.article_version_id = p_article_version_id
1427: and art.org_id = p_org_id
1428: union all

Line 1441: where art.standard_yn = 'Y'

1437: from
1438: okc_articles_all art,
1439: okc_article_versions artv,
1440: okc_article_adoptions arta
1441: where art.standard_yn = 'Y'
1442: and artv.global_yn = 'Y'
1443: and art.article_id = artv.article_id
1444: and artv.article_version_id = arta.global_article_version_id
1445: and artv.article_version_id = p_article_version_id

Line 1468: where art.standard_yn = 'Y'

1464: artv.article_status) article_status
1465: from
1466: okc_articles_all art,
1467: okc_article_versions artv
1468: where art.standard_yn = 'Y'
1469: and art.article_id = artv.article_id
1470: and artv.article_version_id = p_article_version_id
1471: and art.org_id = p_org_id
1472: union all

Line 1485: where art.standard_yn = 'Y'

1481: from
1482: okc_articles_all art,
1483: okc_article_versions artv,
1484: okc_article_adoptions arta
1485: where art.standard_yn = 'Y'
1486: and artv.global_yn = 'Y'
1487: and art.article_id = artv.article_id
1488: and artv.article_version_id = arta.global_article_version_id
1489: and artv.article_version_id = p_article_version_id

Line 1512: art.standard_yn = 'Y'

1508: from
1509: okc_articles_all art,
1510: okc_article_versions artv
1511: where
1512: art.standard_yn = 'Y'
1513: and art.article_id = artv.article_id
1514: and org_id = p_org_id
1515: and article_version_id = p_article_version_id
1516: ) a

Line 1537: art.standard_yn = 'Y'

1533: from
1534: okc_articles_all art,
1535: okc_article_versions artv
1536: where
1537: art.standard_yn = 'Y'
1538: and art.article_id = artv.article_id
1539: and org_id = p_org_id
1540: and article_version_id = p_article_version_id
1541: ) a

Line 1562: art.standard_yn = 'Y'

1558: from
1559: okc_articles_all art,
1560: okc_article_versions artv
1561: where
1562: art.standard_yn = 'Y'
1563: and art.article_id = artv.article_id
1564: and org_id = p_org_id
1565: and article_version_id = p_article_version_id
1566: ) a