1. Tables and Views for Project Management
  2. PJS_PPC_REPORT_STRUCTURE_VL

PJS_PPC_REPORT_STRUCTURE_VL

Details

  • Schema: FUSION

  • Object owner: PJS

  • Object type: VIEW

Columns

Name

OBJECT_ID

REPORT_ID

OBJECT_NAME

OBJECT_DESCRIPTION

TABLE_COL_HDR_COL_1

TABLE_COL_HDR_COL_2

TABLE_COL_HDR_COL_3

TABLE_COL_HDR_COL_4

TABLE_COL_HDR_COL_5

TABLE_COL_HDR_COL_6

ITEM_VALUE

TABLE_COL_VALUE_COL_1

TABLE_COL_VALUE_COL_2

TABLE_COL_VALUE_COL_3

TABLE_COL_VALUE_COL_4

TABLE_COL_VALUE_COL_5

TABLE_COL_VALUE_COL_6

OBJECT_PARENT_ID

OBJECT_LEVEL

OBJECT_DISPLAY_SEQ

OBJECT_TYPE

OBJECT_ICON

OBJECT_LABEL_POSITION

OBJECT_NEW_LINE_IN_GROUP

OBJECT_HIDDEN_FLAG

OBJECT_REFERENCE_ID

TABLE_GRAPH_TYPE

TABLE_DEF_SORT_ORDER_COL_NO

TABLE_DEFAULT_SORT_ORDER

TABLE_COL_TYPE_COL_1

TABLE_COL_TYPE_COL_2

TABLE_COL_TYPE_COL_3

TABLE_COL_TYPE_COL_4

TABLE_COL_TYPE_COL_5

TABLE_COL_TYPE_COL_6

ITEM_OR_TABLE_SQL_QUERY

ITEM_OR_TABLE_REST_URL

ITEM_SHORT_CODE

ITEM_CALC_FORMULA

ITEM_LOV_LOOKUP_TYPE

ITEM_DATA_TYPE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

OBJECT_VERSION_NUMBER

LAST_UPDATE_LOGIN

ADDL_ATTRIBUTE1

ADDL_ATTRIBUTE2

ADDL_ATTRIBUTE3

ADDL_ATTRIBUTE4

ADDL_ATTRIBUTE5

Query

SQL_Statement

SELECT

PJS_PPC_REPORT_STRUCTURE_B.OBJECT_ID,

PJS_PPC_REPORT_STRUCTURE_B.REPORT_ID,

PJS_PPC_REPORT_STRUCTURE_TL.OBJECT_NAME,

PJS_PPC_REPORT_STRUCTURE_TL.OBJECT_DESCRIPTION,

PJS_PPC_REPORT_STRUCTURE_TL.TABLE_COL_HDR_COL_1,

PJS_PPC_REPORT_STRUCTURE_TL.TABLE_COL_HDR_COL_2,

PJS_PPC_REPORT_STRUCTURE_TL.TABLE_COL_HDR_COL_3,

PJS_PPC_REPORT_STRUCTURE_TL.TABLE_COL_HDR_COL_4,

PJS_PPC_REPORT_STRUCTURE_TL.TABLE_COL_HDR_COL_5,

PJS_PPC_REPORT_STRUCTURE_TL.TABLE_COL_HDR_COL_6,

PJS_PPC_REPORT_STRUCTURE_TL.ITEM_VALUE,

PJS_PPC_REPORT_STRUCTURE_TL.TABLE_COL_VALUE_COL_1,

PJS_PPC_REPORT_STRUCTURE_TL.TABLE_COL_VALUE_COL_2,

PJS_PPC_REPORT_STRUCTURE_TL.TABLE_COL_VALUE_COL_3,

PJS_PPC_REPORT_STRUCTURE_TL.TABLE_COL_VALUE_COL_4,

PJS_PPC_REPORT_STRUCTURE_TL.TABLE_COL_VALUE_COL_5,

PJS_PPC_REPORT_STRUCTURE_TL.TABLE_COL_VALUE_COL_6,

PJS_PPC_REPORT_STRUCTURE_B.OBJECT_PARENT_ID,

PJS_PPC_REPORT_STRUCTURE_B.OBJECT_LEVEL,

PJS_PPC_REPORT_STRUCTURE_B.OBJECT_DISPLAY_SEQ,

PJS_PPC_REPORT_STRUCTURE_B.OBJECT_TYPE,

PJS_PPC_REPORT_STRUCTURE_B.OBJECT_ICON,

PJS_PPC_REPORT_STRUCTURE_B.OBJECT_LABEL_POSITION,

PJS_PPC_REPORT_STRUCTURE_B.OBJECT_NEW_LINE_IN_GROUP,

PJS_PPC_REPORT_STRUCTURE_B.OBJECT_HIDDEN_FLAG,

PJS_PPC_REPORT_STRUCTURE_B.OBJECT_REFERENCE_ID,

PJS_PPC_REPORT_STRUCTURE_B.TABLE_GRAPH_TYPE,

PJS_PPC_REPORT_STRUCTURE_B.TABLE_DEF_SORT_ORDER_COL_NO,

PJS_PPC_REPORT_STRUCTURE_B.TABLE_DEFAULT_SORT_ORDER,

PJS_PPC_REPORT_STRUCTURE_B.TABLE_COL_TYPE_COL_1,

PJS_PPC_REPORT_STRUCTURE_B.TABLE_COL_TYPE_COL_2,

PJS_PPC_REPORT_STRUCTURE_B.TABLE_COL_TYPE_COL_3,

PJS_PPC_REPORT_STRUCTURE_B.TABLE_COL_TYPE_COL_4,

PJS_PPC_REPORT_STRUCTURE_B.TABLE_COL_TYPE_COL_5,

PJS_PPC_REPORT_STRUCTURE_B.TABLE_COL_TYPE_COL_6,

PJS_PPC_REPORT_STRUCTURE_B.ITEM_OR_TABLE_SQL_QUERY,

PJS_PPC_REPORT_STRUCTURE_B.ITEM_OR_TABLE_REST_URL,

PJS_PPC_REPORT_STRUCTURE_B.ITEM_SHORT_CODE,

PJS_PPC_REPORT_STRUCTURE_B.ITEM_CALC_FORMULA,

PJS_PPC_REPORT_STRUCTURE_B.ITEM_LOV_LOOKUP_TYPE,

PJS_PPC_REPORT_STRUCTURE_B.ITEM_DATA_TYPE,

PJS_PPC_REPORT_STRUCTURE_B.CREATED_BY,

PJS_PPC_REPORT_STRUCTURE_B.CREATION_DATE,

PJS_PPC_REPORT_STRUCTURE_B.LAST_UPDATED_BY,

PJS_PPC_REPORT_STRUCTURE_B.LAST_UPDATE_DATE,

PJS_PPC_REPORT_STRUCTURE_B.OBJECT_VERSION_NUMBER,

PJS_PPC_REPORT_STRUCTURE_B.LAST_UPDATE_LOGIN,

PJS_PPC_REPORT_STRUCTURE_B.ADDL_ATTRIBUTE1,

PJS_PPC_REPORT_STRUCTURE_B.ADDL_ATTRIBUTE2,

PJS_PPC_REPORT_STRUCTURE_B.ADDL_ATTRIBUTE3,

PJS_PPC_REPORT_STRUCTURE_B.ADDL_ATTRIBUTE4,

PJS_PPC_REPORT_STRUCTURE_B.ADDL_ATTRIBUTE5

FROM

PJS_PPC_REPORT_STRUCTURE_B,

PJS_PPC_REPORT_STRUCTURE_TL

WHERE

PJS_PPC_REPORT_STRUCTURE_B.OBJECT_ID = PJS_PPC_REPORT_STRUCTURE_TL.OBJECT_ID

AND PJS_PPC_REPORT_STRUCTURE_TL.LANGUAGE = USERENV('LANG')