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