VIEW: APPS.FND_IMP_PSMASTER_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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