HRA_ANLYT_BOX_LBLS

Details

Schema: FUSION
Object owner: HRA
Object type: VIEW

Columns

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

Name

ANALYTIC_BOX_LABEL_ID

BUSINESS_GROUP_ID

ANALYTIC_BOX_DEFN_ID

BOX_LABEL

BOX_SEQUENCE

MODULE_ID

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement
SELECT HRA_ANLYT_BOX_LBLS_B.ANALYTIC_BOX_LABEL_ID ANALYTIC_BOX_LABEL_ID, HRA_ANLYT_BOX_LBLS_B.BUSINESS_GROUP_ID BUSINESS_GROUP_ID, HRA_ANLYT_BOX_LBLS_B.ANALYTIC_BOX_DEFN_ID ANALYTIC_BOX_DEFN_ID, HRA_ANLYT_BOX_LBLS_TL.BOX_LABEL BOX_LABEL, HRA_ANLYT_BOX_LBLS_B.BOX_SEQUENCE BOX_SEQUENCE, HRA_ANLYT_BOX_LBLS_B.MODULE_ID MODULE_ID, HRA_ANLYT_BOX_LBLS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, HRA_ANLYT_BOX_LBLS_B.CREATED_BY CREATED_BY, HRA_ANLYT_BOX_LBLS_B.CREATION_DATE CREATION_DATE, HRA_ANLYT_BOX_LBLS_B.LAST_UPDATED_BY LAST_UPDATED_BY, HRA_ANLYT_BOX_LBLS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, HRA_ANLYT_BOX_LBLS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM HRA_ANLYT_BOX_LBLS_B, HRA_ANLYT_BOX_LBLS_TL WHERE HRA_ANLYT_BOX_LBLS_B.ANALYTIC_BOX_LABEL_ID = HRA_ANLYT_BOX_LBLS_TL.ANALYTIC_BOX_LABEL_ID AND HRA_ANLYT_BOX_LBLS_B.BUSINESS_GROUP_ID = HRA_ANLYT_BOX_LBLS_TL.BUSINESS_GROUP_ID AND HRA_ANLYT_BOX_LBLS_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

HRA_ANLYT_BOX_LBLS_B.ANALYTIC_BOX_LABEL_ID ANALYTIC_BOX_LABEL_ID,

HRA_ANLYT_BOX_LBLS_B.BUSINESS_GROUP_ID BUSINESS_GROUP_ID,

HRA_ANLYT_BOX_LBLS_B.ANALYTIC_BOX_DEFN_ID ANALYTIC_BOX_DEFN_ID,

HRA_ANLYT_BOX_LBLS_TL.BOX_LABEL BOX_LABEL,

HRA_ANLYT_BOX_LBLS_B.BOX_SEQUENCE BOX_SEQUENCE,

HRA_ANLYT_BOX_LBLS_B.MODULE_ID MODULE_ID,

HRA_ANLYT_BOX_LBLS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

HRA_ANLYT_BOX_LBLS_B.CREATED_BY CREATED_BY,

HRA_ANLYT_BOX_LBLS_B.CREATION_DATE CREATION_DATE,

HRA_ANLYT_BOX_LBLS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

HRA_ANLYT_BOX_LBLS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

HRA_ANLYT_BOX_LBLS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN

FROM

HRA_ANLYT_BOX_LBLS_B,

HRA_ANLYT_BOX_LBLS_TL

WHERE

HRA_ANLYT_BOX_LBLS_B.ANALYTIC_BOX_LABEL_ID = HRA_ANLYT_BOX_LBLS_TL.ANALYTIC_BOX_LABEL_ID AND HRA_ANLYT_BOX_LBLS_B.BUSINESS_GROUP_ID = HRA_ANLYT_BOX_LBLS_TL.BUSINESS_GROUP_ID AND HRA_ANLYT_BOX_LBLS_TL.LANGUAGE = USERENV('LANG')