VIEW: APPS.FND_IMP_PISUMMARY2_VL

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)