1. Tables and Views for SCM
  2. ACA_INFOTILES_VL

ACA_INFOTILES_VL

Details

  • Schema: FUSION

  • Object owner: ACA

  • Object type: VIEW

Columns

Name

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

INFOTILE_NAME

INFOTILE_TYPE

INFOTILE_DISPLAY_ORDER

INFOTILE_ENTITY

INFOTILE_BUSINESSOBJECT

DELETE_FLAG

INFOTILE_TITLE

Query

SQL_Statement

SELECT

ACA_INFOTILES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

ACA_INFOTILES_B.CREATED_BY CREATED_BY,

ACA_INFOTILES_B.CREATION_DATE CREATION_DATE,

ACA_INFOTILES_B.LAST_UPDATED_BY LAST_UPDATED_BY,

ACA_INFOTILES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

ACA_INFOTILES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

ACA_INFOTILES_B.INFOTILE_NAME INFOTILE_NAME,

ACA_INFOTILES_B.INFOTILE_TYPE INFOTILE_TYPE,

ACA_INFOTILES_B.INFOTILE_DISPLAY_ORDER INFOTILE_DISPLAY_ORDER,

ACA_INFOTILES_B.INFOTILE_ENTITY INFOTILE_ENTITY,

ACA_INFOTILES_B.INFOTILE_BUSINESSOBJECT INFOTILE_BUSINESSOBJECT,

ACA_INFOTILES_B.DELETE_FLAG DELETE_FLAG,

ACA_INFOTILES_TL.INFOTILE_TITLE INFOTILE_TITLE

FROM

ACA_INFOTILES_B,

ACA_INFOTILES_TL

WHERE

ACA_INFOTILES_B.INFOTILE_NAME = ACA_INFOTILES_TL.INFOTILE_NAME AND ACA_INFOTILES_TL.LANGUAGE = USERENV('LANG')