[Home] [Help]
View: JTF_IMP_PSMASTER_VL
Product: | JTF - CRM Foundation |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT X.*
, DECODE(JTF_IMP_CONV_PKG.COMPARE_RCSID(OLD_VERSION
, NEW_VERSION)
, 1
, 'UPGRADE'
, 2
, 'OVERWRITE'
, 3
, 'NOT APPLIED'
, 'UNKNOWN') TYPEID
FROM JTF_IMP_PSCOMMON X UNION ALL SELECT Y.*
, NULL OLD_VERSION
, 'NEW' TYPEID
FROM JTF_IMP_PSNEW Y
FROM JTF_IMP_PSCOMMON X
Columns
Name |
BUG_NO |
SNAPSHOT_ID |
APP_SHORT_NAME |
DIRECTORY |
FILENAME |
NEW_VERSION |
OLD_VERSION |
TYPEID |