View: JTF_IMP_PISUMMARY2_VL

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