View: FND_IMP_PISUMMARY2_VL

Product:	FND - Application Object Library
Description:	FND_IMP_PISUMMARY2_VL
Implementation/DBA Data:	APPS.FND_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
, A.PATCH_ID
FROM FND_IMP_PISUMMARY A
, (SELECT RELEASE_NAME
, APPLICATION_SHORT_NAME
, ABSTRACT
, PATCH_ID
FROM AD_PM_PATCHES A
, FND_UMS_BUGFIXES U
WHERE A.BASELINE = U.BASELINE
AND A.BUG_NUMBER = U.BUG_NUMBER) B
, FND_IMP_SSUMMARY_VL C
WHERE DECODE(SIGN(A.PATCH_ID)
, -1
, 0 -A.PATCH_ID
, A.PATCH_ID) = B.PATCH_ID(+)
AND A.SNAPSHOT_ID = C.SNAPSHOT_ID(+)

Columns