VIEW: APPS.FND_IMP_PSMASTER2_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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