PJS_PPC_REPORTS_VL

Details

• Schema: FUSION

• Object owner: PJS

• Object type: VIEW

Columns

Name

REPORT_ID NAME DESCRIPTION BIP_RTF_LAYOUT TEMPLATE_FLAG SOURCE_REPORT_ID USAGE STATUS OWNER_PERSON_ID PUBLIC_ACCESS GENERATION_TYPE REQUEST_ID ERROR_MESSAGE_NAME CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE OBJECT_VERSION_NUMBER LAST_UPDATE_LOGIN EXTERNAL_SOURCE EXTERNAL_SOURCE_REFERENCE REPORT_TYPE REPORT_NUMBER ADDL_ATTRIBUTE1 ADDL_ATTRIBUTE2 ADDL_ATTRIBUTE3 ADDL_ATTRIBUTE4 ADDL_ATTRIBUTE5 ORIGINAL_ASSOCIATION_ID

Query

SQL_Statement

SELECT PJS_PPC_REPORTS_B.REPORT_ID, PJS_PPC_REPORTS_TL.NAME, PJS_PPC_REPORTS_TL.DESCRIPTION, PJS_PPC_REPORTS_TL.BIP_RTF_LAYOUT, PJS_PPC_REPORTS_B.TEMPLATE_FLAG, PJS_PPC_REPORTS_B.SOURCE_REPORT_ID, PJS_PPC_REPORTS_B.USAGE, PJS_PPC_REPORTS_B.STATUS, PJS_PPC_REPORTS_B.OWNER_PERSON_ID, PJS_PPC_REPORTS_B.PUBLIC_ACCESS, PJS_PPC_REPORTS_B.GENERATION_TYPE, PJS_PPC_REPORTS_B.REQUEST_ID, PJS_PPC_REPORTS_B.ERROR_MESSAGE_NAME, PJS_PPC_REPORTS_B.CREATED_BY, PJS_PPC_REPORTS_B.CREATION_DATE, PJS_PPC_REPORTS_B.LAST_UPDATED_BY, PJS_PPC_REPORTS_B.LAST_UPDATE_DATE, PJS_PPC_REPORTS_B.OBJECT_VERSION_NUMBER, PJS_PPC_REPORTS_B.LAST_UPDATE_LOGIN, PJS_PPC_REPORTS_B.EXTERNAL_SOURCE, PJS_PPC_REPORTS_B.EXTERNAL_SOURCE_REFERENCE, PJS_PPC_REPORTS_B.REPORT_TYPE, PJS_PPC_REPORTS_B.REPORT_NUMBER, PJS_PPC_REPORTS_B.ADDL_ATTRIBUTE1, PJS_PPC_REPORTS_B.ADDL_ATTRIBUTE2, PJS_PPC_REPORTS_B.ADDL_ATTRIBUTE3, PJS_PPC_REPORTS_B.ADDL_ATTRIBUTE4, PJS_PPC_REPORTS_B.ADDL_ATTRIBUTE5, PJS_PPC_REPORTS_B.ORIGINAL_ASSOCIATION_ID FROM PJS_PPC_REPORTS_B, PJS_PPC_REPORTS_TL WHERE PJS_PPC_REPORTS_B.REPORT_ID = PJS_PPC_REPORTS_TL.REPORT_ID AND PJS_PPC_REPORTS_TL.LANGUAGE = USERENV('LANG')