View: OKC_SAE_INCMPT_V

Product:	OKC - Contracts Core
Description:	View for incompatible standard articles
Implementation/DBA Data:	APPS.OKC_SAE_INCMPT_V

View Text

SELECT A.ARTICLE_TITLE FOR_NAME
, B.ROWID
, B.SOURCE_ARTICLE_ID SAE_ID
, B.TARGET_ARTICLE_ID SAE_ID_FOR
, B.OBJECT_VERSION_NUMBER
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM OKC_ARTICLE_RELATNS_ALL B
, OKC_ARTICLES_ALL A
WHERE A.ARTICLE_ID=B.SOURCE_ARTICLE_ID
AND B.ORG_ID = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)
AND RELATIONSHIP_TYPE ='INCOMPATIBLE'

Columns