PTGP_OBI_REP_VW

(SQL View)
Index Back

SELECT PTOBI_REPORT_ID , PTOBI_REPORT_NAME FROM PS_PTOBI_RPT_DEFN WHERE PTOBI_REPORT_ID IN ( SELECT DISTINCT(PTOBI_REPORT_ID) FROM PS_PTOBI_VERSION WHERE PTOBI_OBJTYPE = 'UNSUPPORTED')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTOBI_REPORT_ID Number(30,0) DECIMAL(30) NOT NULL OBIEE Report ID
2 PTOBI_REPORT_NAME Character(254) VARCHAR2(254) NOT NULL Report Name