DBA Data[Home] [Help]

APPS.OKC_ARTICLES_MIGRATE_GRP dependencies on OKC_STD_ARTICLES_TL

Line 439: FROM OKC_STD_ARTICLES_TL ARTL

435: -99) ART_ARTICLE_ID,
436: ARTL.ID ART_SYSTEM_REFERENCE_ID1,
437: ARTL.LANGUAGE ART_ARTICLE_LANGUAGE,
438: ARTL.LANGUAGE ARTV_ARTICLE_LANGUAGE
439: FROM OKC_STD_ARTICLES_TL ARTL
440: WHERE
441: ARTL.LANGUAGE = ARTL.SOURCE_LANG
442: AND NOT EXISTS
443: (SELECT /*+ NO_UNNEST */

Line 456: OKC_STD_ARTICLES_TL ARTL

452: ARTL.ID ART_SYSTEM_REFERENCE_ID1,
453: ARTVL.LANGUAGE ART_ARTICLE_LANGUAGE,
454: ARTVL.LANGUAGE ARTV_ARTICLE_LANGUAGE
455: FROM OKC_STD_ART_VERSIONS_TL ARTVL,
456: OKC_STD_ARTICLES_TL ARTL
457: WHERE ARTL.LANGUAGE = ARTL.SOURCE_LANG
458: AND ARTL.LANGUAGE = cp_base_language
459: AND ARTVL.LANGUAGE = ARTVL.SOURCE_LANG
460: AND ARTVL.LANGUAGE <> cp_base_language

Line 470: 1 FROM OKC_STD_ARTICLES_TL ARTL1

466: AND ORIG_SYSTEM_REFERENCE_CODE in ('OKCMIGORIG', 'OKCMIGNEW')
467: AND ARTICLE_LANGUAGE = ARTVL.LANGUAGE)
468: AND NOT EXISTS
469: (SELECT /*+ NO_UNNEST */
470: 1 FROM OKC_STD_ARTICLES_TL ARTL1
471: WHERE ARTL1.LANGUAGE = ARTVL.LANGUAGE
472: AND ARTL1.SOURCE_LANG = ARTVL.SOURCE_LANG
473: AND ARTVL.SAE_ID = ARTL1.ID);
474: