OKC_ART_LOCAL_GLOBAL_V
Details
-
Schema: FUSION
-
Object owner: OKC
-
Object type: VIEW
Columns
Name |
---|
ARTICLE_ID OBJECT_VERSION_NUMBER ARTICLE_TITLE ORG_ID ARTICLE_NUMBER STANDARD_YN ARTICLE_INTENT ARTICLE_LANGUAGE ARTICLE_TYPE ORIG_SYSTEM_REFERENCE_CODE ORIG_SYSTEM_REFERENCE_ID1 ORIG_SYSTEM_REFERENCE_ID2 LOCAL_ARTICLE_ID LOCAL_ARTICLE_VERSION_ID LOCAL_ORG GLOBAL_ARTICLE_ID GLOBAL_ARTICLE_VERSION_ID RECORD_TYPE |
Query
SQL_Statement |
---|
SELECT ARTICLE_ID, OBJECT_VERSION_NUMBER, ARTICLE_TITLE, ORG_ID, ARTICLE_NUMBER, STANDARD_YN, ARTICLE_INTENT, ARTICLE_LANGUAGE, ARTICLE_TYPE, ORIG_SYSTEM_REFERENCE_CODE, ORIG_SYSTEM_REFERENCE_ID1, ORIG_SYSTEM_REFERENCE_ID2, NULL local_article_id, NULL local_article_version_id, NULL local_org, NULL global_Article_id, NULL global_article_version_id, 'ORIG' record_type FROM okc_articles_all UNION SELECT art.ARTICLE_ID, art.OBJECT_VERSION_NUMBER, art.ARTICLE_TITLE, art.ORG_ID, art.ARTICLE_NUMBER, art.STANDARD_YN, art.ARTICLE_INTENT, art.ARTICLE_LANGUAGE, art.ARTICLE_TYPE, art.ORIG_SYSTEM_REFERENCE_CODE, art.ORIG_SYSTEM_REFERENCE_ID1, art.ORIG_SYSTEM_REFERENCE_ID2, ver2.article_id local_article_id, ver2.article_version_id local_article_version_id, adp2.local_org_id local_org, gver2.article_id global_Article_id, gver2.article_version_id global_article_version_id, 'LOCAL' record_type FROM okc_articles_all art , okc_article_versions ver2, okc_article_adoptions adp2, okc_article_versions gver2 WHERE ver2.article_version_id = adp2.local_article_version_id AND adp2.global_article_version_id = gver2.article_version_id AND adp2.adoption_type = 'LOCALIZED' AND art.article_id =ver2.article_id |