[Home] [Help]
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
Name |
BUG_NO |
SNAPSHOT_ID |
APP_SHORT_NAME |
DIRECTORY |
FILENAME |
TYPEID |
NEW_VERSION |
OLD_VERSION |
FILES_AFFECTED |
TYPE_AFFECTED |
FILE_TYPE |
TRANS_NAME |
IS_FLAGGED_FILE |
BRANCH_TYPE |
PATCH_ID |