1. Tables and Views for Financials
  2. FA_ASSET_KEY_ALIASES_VL

FA_ASSET_KEY_ALIASES_VL

Details

  • Schema: FUSION

  • Object owner: FA

  • Object type: VIEW

Columns

Name

ROW_ID

STRUCTURE_INSTANCE_NUMBER

SHORTHAND_ALIAS_CODE

ENABLED_FLAG

START_DATE_ACTIVE

END_DATE_ACTIVE

SEGMENT1

SEGMENT2

SEGMENT3

SEGMENT4

SEGMENT5

SEGMENT6

SEGMENT7

SEGMENT8

SEGMENT9

SEGMENT10

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

NAME

DESCRIPTION

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

Query

SQL_Statement

SELECT ALIASES_B.ROWID ROW_ID,

ALIASES_B.STRUCTURE_INSTANCE_NUMBER, ALIASES_B.SHORTHAND_ALIAS_CODE,

ALIASES_B.ENABLED_FLAG, ALIASES_B.START_DATE_ACTIVE, ALIASES_B.END_DATE_ACTIVE,

ALIASES_B.SEGMENT1, ALIASES_B.SEGMENT2, ALIASES_B.SEGMENT3, ALIASES_B.SEGMENT4, ALIASES_B.SEGMENT5,

ALIASES_B.SEGMENT6, ALIASES_B.SEGMENT7, ALIASES_B.SEGMENT8, ALIASES_B.SEGMENT9, ALIASES_B.SEGMENT10,

ALIASES_B.CREATION_DATE, ALIASES_B.CREATED_BY,

ALIASES_B.LAST_UPDATE_DATE, ALIASES_B.LAST_UPDATED_BY, ALIASES_B.LAST_UPDATE_LOGIN,

ALIASES_B.OBJECT_VERSION_NUMBER,

ALIASES_TL.NAME, ALIASES_TL.DESCRIPTION,

ALIASES_B.ATTRIBUTE_CATEGORY,

ALIASES_B.ATTRIBUTE1, ALIASES_B.ATTRIBUTE2, ALIASES_B.ATTRIBUTE3, ALIASES_B.ATTRIBUTE4, ALIASES_B.ATTRIBUTE5,

ALIASES_B.ATTRIBUTE6, ALIASES_B.ATTRIBUTE7, ALIASES_B.ATTRIBUTE8, ALIASES_B.ATTRIBUTE9, ALIASES_B.ATTRIBUTE10,

ALIASES_B.ATTRIBUTE11, ALIASES_B.ATTRIBUTE12, ALIASES_B.ATTRIBUTE13, ALIASES_B.ATTRIBUTE14, ALIASES_B.ATTRIBUTE15,

ALIASES_B.ATTRIBUTE_DATE1, ALIASES_B.ATTRIBUTE_DATE2, ALIASES_B.ATTRIBUTE_DATE3, ALIASES_B.ATTRIBUTE_DATE4, ALIASES_B.ATTRIBUTE_DATE5,

ALIASES_B.ATTRIBUTE_NUMBER1, ALIASES_B.ATTRIBUTE_NUMBER2, ALIASES_B.ATTRIBUTE_NUMBER3, ALIASES_B.ATTRIBUTE_NUMBER4, ALIASES_B.ATTRIBUTE_NUMBER5

FROM FA_ASSET_KEY_ALIASES_B ALIASES_B, FA_ASSET_KEY_ALIASES_TL ALIASES_TL

WHERE ALIASES_B.STRUCTURE_INSTANCE_NUMBER = ALIASES_TL.STRUCTURE_INSTANCE_NUMBER

AND ALIASES_B.SHORTHAND_ALIAS_CODE = ALIASES_TL.SHORTHAND_ALIAS_CODE

AND ALIASES_TL.LANGUAGE = USERENV('LANG')