[Home] [Help]
View: FND_IMP_PSMASTER_VL
Product: | FND - Application Object Library |
Description: | FND_IMP_PSMASTER_VL |
Implementation/DBA Data: |
APPS.FND_IMP_PSMASTER_VL
|
View Text
SELECT X.BUG_NO
, X.SNAPSHOT_ID
, X.APP_SHORT_NAME
, X.DIRECTORY
, X.FILENAME
, DECODE(FND_IMP_CONV_PKG.COMPARE_RCSID(OLD_VERSION
, NEW_VERSION)
, 1
, 'UPGRADE'
, 2
, 'UPGRADE'
, 3
, 'NOT APPLIED'
, 'UNKNOWN') TYPEID
, X.NEW_VERSION
, X.OLD_VERSION
, X.IS_FLAGGED_FILE
, FND_IMP_CONV_PKG.CHECK_BRANCHING(X.OLD_VERSION
, X.NEW_VERSION) BRANCH_TYPE
, X.PATCH_ID
FROM FND_IMP_PSCOMMON X UNION ALL SELECT Y.BUG_NO
, Y.SNAPSHOT_ID
, Y.APP_SHORT_NAME
, Y.DIRECTORY
, Y.FILENAME
, 'NEW' TYPEID
, Y.NEW_VERSION
, NULL OLD_VERSION
, Y.IS_FLAGGED_FILE
, -1 BRANCH_TYPE
, Y.PATCH_ID
FROM FND_IMP_PSNEW Y
Columns
Name |
BUG_NO |
SNAPSHOT_ID |
APP_SHORT_NAME |
DIRECTORY |
FILENAME |
TYPEID |
NEW_VERSION |
OLD_VERSION |
IS_FLAGGED_FILE |
BRANCH_TYPE |
PATCH_ID |