DBA Data[Home] [Help]

APPS.OKC_ART_BLK_PVT dependencies on OKC_ARTICLE_VARIABLES

Line 532: OKC_ARTICLE_VARIABLES AAV,

528: SELECT TMP.article_id, TMP.article_version_id, nvl(TMP.display_name, TMP.article_title),
529: BVT.variable_name
530: FROM OKC_BUS_VARIABLES_TL BVT,
531: OKC_BUS_VARIABLES_B BVB,
532: OKC_ARTICLE_VARIABLES AAV,
533: OKC_ART_BLK_TEMP TMP
534: WHERE TMP.id = cp_id
535: AND TMP.adopt_asis_yn = 'N' --check not done for adopt as is clauses
536: AND AAV.article_version_id = TMP.article_version_id

Line 550: OKC_ARTICLE_VARIABLES AAV,

546: nvl(FVS.flex_value_set_id, -99)
547: FROM OKC_BUS_VARIABLES_TL BVT,
548: FND_FLEX_VALUE_SETS FVS,
549: OKC_BUS_VARIABLES_B BVB,
550: OKC_ARTICLE_VARIABLES AAV,
551: OKC_ART_BLK_TEMP TMP
552: WHERE TMP.id = cp_id
553: AND TMP.adopt_asis_yn = 'N' --check not done for adopt as is clauses
554: AND AAV.article_version_id = TMP.article_version_id