View: FND_IMP_PSMASTER2_VL

Product:	FND - Application Object Library
Description:	FND_IMP_PSMASTER2_VL
Implementation/DBA Data:	APPS.FND_IMP_PSMASTER2_VL

View Text

SELECT C.BUG_NO
, C.SNAPSHOT_ID
, C.APP_SHORT_NAME
, C.DIRECTORY
, C.FILENAME
, C.TYPEID
, C.NEW_VERSION
, C.OLD_VERSION
, 0 FILES_AFFECTED
, 'NULL' TYPE_AFFECTED
, SUBSTR(C.FILENAME
, INSTR(FILENAME
, '.')+1) FILE_TYPE
, DECODE(SUBSTR(C.FILENAME
, INSTR(FILENAME
, '.')+1)
, 'CLASS'
, 'ORACLE.APPS.' ||LOWER(APP_SHORT_NAME) ||'.' ||REPLACE(DECODE(INSTR(DIRECTORY
, 'JAVA/')
, 1
, SUBSTR(DIRECTORY
, 6)
, DIRECTORY)
, '/'
, '.') ||'.' ||SUBSTR(FILENAME
, 1
, INSTR(FILENAME
, '.')-1)
, NULL) TRANS_NAME
, C.IS_FLAGGED_FILE
, C.BRANCH_TYPE
, C.PATCH_ID
FROM FND_IMP_PSMASTER_VL C

Columns