HRR_TMPL_ANLYT_BOX_LBLS_VL

Details

• Schema: FUSION

• Object owner: HRR

• Object type: VIEW

Columns

Name
ANALYTIC_BOX_LABEL_ID BUSINESS_GROUP_ID ANALYTIC_TYPE_ID BOX_SEQUENCE BOX_LABEL MODULE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN BOXCELL_BACKGROUND_COLOR

Query

SQL_Statement

SELECT ABL.ANALYTIC_BOX_LABEL_ID ANALYTIC_BOX_LABEL_ID, ABL.BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ABL.ANALYTIC_TYPE_ID ANALYTIC_TYPE_ID, ABL.BOX_SEQUENCE BOX_SEQUENCE, ABLTL.BOX_LABEL BOX_LABEL, ABL.MODULE_ID MODULE_ID, ABL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ABL.CREATED_BY CREATED_BY, ABL.CREATION_DATE CREATION_DATE, ABL.LAST_UPDATED_BY LAST_UPDATED_BY, ABL.LAST_UPDATE_DATE LAST_UPDATE_DATE, ABL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ABL.BOXCELL_BACKGROUND_COLOR BOXCELL_BACKGROUND_COLOR FROM HRR_TMPL_ANLYT_BOX_LBLS_B ABL, HRR_TMPL_ANLYT_BOX_LBLS_TL ABLTL WHERE ABL.ANALYTIC_BOX_LABEL_ID = ABLTL.ANALYTIC_BOX_LABEL_ID AND ABL.BUSINESS_GROUP_ID = ABLTL.BUSINESS_GROUP_ID AND ABLTL.LANGUAGE = USERENV('LANG')