[Home] [Help]
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 B
, OKC_ARTICLES_ALL A
WHERE A.ARTICLE_ID=B.SOURCE_ARTICLE_ID
AND RELATIONSHIP_TYPE ='INCOMPATIBLE'
Columns
Name |
FOR_NAME |
ROW_ID |
SAE_ID |
SAE_ID_FOR |
OBJECT_VERSION_NUMBER |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |