1. Tables and Views for Project Management
  2. PJS_PPC_CATALOG_VL

PJS_PPC_CATALOG_VL

Details

  • Schema: FUSION

  • Object owner: PJS

  • Object type: VIEW

Columns

Name

OBJECT_ID

OBJECT_NAME

OBJECT_DESCRIPTION

OBJECT_TYPE

OBJECT_PARENT_ID

OBJECT_LEVEL

OBJECT_USAGE

OBJECT_ORIGIN

OBJECT_ICON

OBJECT_LABEL_POSITION

OBJECT_GROUP_OWNER_PERSON_ID

OBJECT_GROUP_PUBLIC_ACCESS

OBJECT_SEQ_IN_GROUP

OBJECT_NEW_LINE_IN_GROUP

OBJECT_HIDDEN_FLAG

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

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_OR_TABLE_SQL_QUERY

ITEM_OR_TABLE_REST_URL

ITEM_SHORT_CODE

ITEM_CALC_FORMULA

ITEM_LOV_LOOKUP_TYPE

ITEM_DATA_TYPE

EXTERNAL_SOURCE

EXTERNAL_SOURCE_REFERENCE

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

OBJECT_REFERENCE_ID

MEASURE_ID

Query

SQL_Statement

SELECT

PJS_PPC_CATALOG_B.OBJECT_ID,

PJS_PPC_CATALOG_TL.OBJECT_NAME,

PJS_PPC_CATALOG_TL.OBJECT_DESCRIPTION,

PJS_PPC_CATALOG_B.OBJECT_TYPE,

PJS_PPC_CATALOG_B.OBJECT_PARENT_ID,

PJS_PPC_CATALOG_B.OBJECT_LEVEL,

PJS_PPC_CATALOG_B.OBJECT_USAGE,

PJS_PPC_CATALOG_B.OBJECT_ORIGIN,

PJS_PPC_CATALOG_B.OBJECT_ICON,

PJS_PPC_CATALOG_B.OBJECT_LABEL_POSITION,

PJS_PPC_CATALOG_B.OBJECT_GROUP_OWNER_PERSON_ID,

PJS_PPC_CATALOG_B.OBJECT_GROUP_PUBLIC_ACCESS,

PJS_PPC_CATALOG_B.OBJECT_SEQ_IN_GROUP,

PJS_PPC_CATALOG_B.OBJECT_NEW_LINE_IN_GROUP,

PJS_PPC_CATALOG_B.OBJECT_HIDDEN_FLAG,

PJS_PPC_CATALOG_B.TABLE_GRAPH_TYPE,

PJS_PPC_CATALOG_B.TABLE_DEF_SORT_ORDER_COL_NO,

PJS_PPC_CATALOG_B.TABLE_DEFAULT_SORT_ORDER,

PJS_PPC_CATALOG_B.TABLE_COL_TYPE_COL_1,

PJS_PPC_CATALOG_B.TABLE_COL_TYPE_COL_2,

PJS_PPC_CATALOG_B.TABLE_COL_TYPE_COL_3,

PJS_PPC_CATALOG_B.TABLE_COL_TYPE_COL_4,

PJS_PPC_CATALOG_B.TABLE_COL_TYPE_COL_5,

PJS_PPC_CATALOG_B.TABLE_COL_TYPE_COL_6,

PJS_PPC_CATALOG_TL.TABLE_COL_HDR_COL_1,

PJS_PPC_CATALOG_TL.TABLE_COL_HDR_COL_2,

PJS_PPC_CATALOG_TL.TABLE_COL_HDR_COL_3,

PJS_PPC_CATALOG_TL.TABLE_COL_HDR_COL_4,

PJS_PPC_CATALOG_TL.TABLE_COL_HDR_COL_5,

PJS_PPC_CATALOG_TL.TABLE_COL_HDR_COL_6,

PJS_PPC_CATALOG_B.ITEM_OR_TABLE_SQL_QUERY,

PJS_PPC_CATALOG_B.ITEM_OR_TABLE_REST_URL,

PJS_PPC_CATALOG_B.ITEM_SHORT_CODE,

PJS_PPC_CATALOG_B.ITEM_CALC_FORMULA,

PJS_PPC_CATALOG_B.ITEM_LOV_LOOKUP_TYPE,

PJS_PPC_CATALOG_B.ITEM_DATA_TYPE,

PJS_PPC_CATALOG_B.EXTERNAL_SOURCE,

PJS_PPC_CATALOG_B.EXTERNAL_SOURCE_REFERENCE,

PJS_PPC_CATALOG_B.CREATED_BY,

PJS_PPC_CATALOG_B.CREATION_DATE,

PJS_PPC_CATALOG_B.LAST_UPDATED_BY,

PJS_PPC_CATALOG_B.LAST_UPDATE_DATE,

PJS_PPC_CATALOG_B.OBJECT_VERSION_NUMBER,

PJS_PPC_CATALOG_B.LAST_UPDATE_LOGIN,

PJS_PPC_CATALOG_B.ADDL_ATTRIBUTE1,

PJS_PPC_CATALOG_B.ADDL_ATTRIBUTE2,

PJS_PPC_CATALOG_B.ADDL_ATTRIBUTE3,

PJS_PPC_CATALOG_B.ADDL_ATTRIBUTE4,

PJS_PPC_CATALOG_B.ADDL_ATTRIBUTE5,

PJS_PPC_CATALOG_B.OBJECT_REFERENCE_ID,

PJS_PPC_CATALOG_B.MEASURE_ID

FROM

PJS_PPC_CATALOG_B,

PJS_PPC_CATALOG_TL

WHERE

PJS_PPC_CATALOG_B.OBJECT_ID = PJS_PPC_CATALOG_TL.OBJECT_ID

AND PJS_PPC_CATALOG_TL.LANGUAGE = USERENV('LANG')