[Home] [Help]
View: JTF_IMP_PISUMMARY2_VL
Product: | JTF - CRM Foundation |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT A.SNAPSHOT_ID SNAPSHOT_ID
, A.BUG_NO BUG_NO
, A.NEW NEW
, A.UPGRADE UPGRADE
, A.OVERWRITE OVERWRITE
, A.NOT_APPLIED NOT_APPLIED
, A.INSTALL_CNT INSTALL_CNT
, A.FILES_CNT FILES_CNT
, B.RELEASE_NAME BUG_RELEASE_NAME
, B.APPLICATION_SHORT_NAME BUG_APP
, B.ABSTRACT BUG_DESC
, C.SNAPSHOT_NAME SNAPSHOT_NAME
, C.SNAPSHOT_TYPE SNAPSHOT_TYPE
, C.APPL_TOP_ID APPL_TOP_ID
, C.APPL_TOP_NAME APPL_TOP_NAME
, C.APPL_TOP_DESC APPL_TOP_DESC FROM JTF_IMP_PISUMMARY A
, FND_UMS_BUGFIXES B
, JTF_IMP_SSUMMARY_VL C
FROM JTF_IMP_SSUMMARY_VL C
WHERE A.BUG_NO = B.BUG_NUMBER(+) AND A.SNAPSHOT_ID = C.SNAPSHOT_ID(+)
Columns
Name |
SNAPSHOT_ID |
BUG_NO |
NEW |
UPGRADE |
OVERWRITE |
NOT_APPLIED |
INSTALL_CNT |
FILES_CNT |
BUG_RELEASE_NAME |
BUG_APP |
BUG_DESC |
SNAPSHOT_NAME |
SNAPSHOT_TYPE |
APPL_TOP_ID |
APPL_TOP_NAME |
APPL_TOP_DESC |