GL_ACCOUNT_ALIASES

Details

Schema: FUSION
Object owner: GL
Object type: VIEW

Columns

Name
ROW_ID CHART_OF_ACCOUNTS_ID SHORTHAND_ALIAS_CODE ENABLED_FLAG START_DATE_ACTIVE END_DATE_ACTIVE SEGMENT1 SEGMENT2 SEGMENT3 SEGMENT4 SEGMENT5 SEGMENT6 SEGMENT7 SEGMENT8 SEGMENT9 SEGMENT10 SEGMENT11 SEGMENT12 SEGMENT13 SEGMENT14 SEGMENT15 SEGMENT16 SEGMENT17 SEGMENT18 SEGMENT19 SEGMENT20 SEGMENT21 SEGMENT22 SEGMENT23 SEGMENT24 SEGMENT25 SEGMENT26 SEGMENT27 SEGMENT28 SEGMENT29 SEGMENT30 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 SEGMENT_ATTRIBUTE1 SEGMENT_ATTRIBUTE2 SEGMENT_ATTRIBUTE3 SEGMENT_ATTRIBUTE4 SEGMENT_ATTRIBUTE5 SEGMENT_ATTRIBUTE6 SEGMENT_ATTRIBUTE7 SEGMENT_ATTRIBUTE8 SEGMENT_ATTRIBUTE9 SEGMENT_ATTRIBUTE10 SEGMENT_ATTRIBUTE11 SEGMENT_ATTRIBUTE12 SEGMENT_ATTRIBUTE13 SEGMENT_ATTRIBUTE14 SEGMENT_ATTRIBUTE15 SEGMENT_ATTRIBUTE16 SEGMENT_ATTRIBUTE17 SEGMENT_ATTRIBUTE18 SEGMENT_ATTRIBUTE19 SEGMENT_ATTRIBUTE20 SEGMENT_ATTRIBUTE21 SEGMENT_ATTRIBUTE22 SEGMENT_ATTRIBUTE23 SEGMENT_ATTRIBUTE24 SEGMENT_ATTRIBUTE25 SEGMENT_ATTRIBUTE26 SEGMENT_ATTRIBUTE27 SEGMENT_ATTRIBUTE28 SEGMENT_ATTRIBUTE29 SEGMENT_ATTRIBUTE30 SEGMENT_ATTRIBUTE31 SEGMENT_ATTRIBUTE32 SEGMENT_ATTRIBUTE33 SEGMENT_ATTRIBUTE34 SEGMENT_ATTRIBUTE35 SEGMENT_ATTRIBUTE36 SEGMENT_ATTRIBUTE37 SEGMENT_ATTRIBUTE38 SEGMENT_ATTRIBUTE39 SEGMENT_ATTRIBUTE40 SEGMENT_ATTRIBUTE41 SEGMENT_ATTRIBUTE42 LEDGER_SEGMENT

Name

ROW_ID

CHART_OF_ACCOUNTS_ID

SHORTHAND_ALIAS_CODE

ENABLED_FLAG

START_DATE_ACTIVE

END_DATE_ACTIVE

SEGMENT1

SEGMENT2

SEGMENT3

SEGMENT4

SEGMENT5

SEGMENT6

SEGMENT7

SEGMENT8

SEGMENT9

SEGMENT10

SEGMENT11

SEGMENT12

SEGMENT13

SEGMENT14

SEGMENT15

SEGMENT16

SEGMENT17

SEGMENT18

SEGMENT19

SEGMENT20

SEGMENT21

SEGMENT22

SEGMENT23

SEGMENT24

SEGMENT25

SEGMENT26

SEGMENT27

SEGMENT28

SEGMENT29

SEGMENT30

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

SEGMENT_ATTRIBUTE1

SEGMENT_ATTRIBUTE2

SEGMENT_ATTRIBUTE3

SEGMENT_ATTRIBUTE4

SEGMENT_ATTRIBUTE5

SEGMENT_ATTRIBUTE6

SEGMENT_ATTRIBUTE7

SEGMENT_ATTRIBUTE8

SEGMENT_ATTRIBUTE9

SEGMENT_ATTRIBUTE10

SEGMENT_ATTRIBUTE11

SEGMENT_ATTRIBUTE12

SEGMENT_ATTRIBUTE13

SEGMENT_ATTRIBUTE14

SEGMENT_ATTRIBUTE15

SEGMENT_ATTRIBUTE16

SEGMENT_ATTRIBUTE17

SEGMENT_ATTRIBUTE18

SEGMENT_ATTRIBUTE19

SEGMENT_ATTRIBUTE20

SEGMENT_ATTRIBUTE21

SEGMENT_ATTRIBUTE22

SEGMENT_ATTRIBUTE23

SEGMENT_ATTRIBUTE24

SEGMENT_ATTRIBUTE25

SEGMENT_ATTRIBUTE26

SEGMENT_ATTRIBUTE27

SEGMENT_ATTRIBUTE28

SEGMENT_ATTRIBUTE29

SEGMENT_ATTRIBUTE30

SEGMENT_ATTRIBUTE31

SEGMENT_ATTRIBUTE32

SEGMENT_ATTRIBUTE33

SEGMENT_ATTRIBUTE34

SEGMENT_ATTRIBUTE35

SEGMENT_ATTRIBUTE36

SEGMENT_ATTRIBUTE37

SEGMENT_ATTRIBUTE38

SEGMENT_ATTRIBUTE39

SEGMENT_ATTRIBUTE40

SEGMENT_ATTRIBUTE41

SEGMENT_ATTRIBUTE42

LEDGER_SEGMENT

Query

SQL_Statement
SELECT ALIASES_B.ROWID ROW_ID, ALIASES_B.CHART_OF_ACCOUNTS_ID, 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.SEGMENT11, ALIASES_B.SEGMENT12, ALIASES_B.SEGMENT13, ALIASES_B.SEGMENT14, ALIASES_B.SEGMENT15, ALIASES_B.SEGMENT16, ALIASES_B.SEGMENT17, ALIASES_B.SEGMENT18, ALIASES_B.SEGMENT19, ALIASES_B.SEGMENT20, ALIASES_B.SEGMENT21, ALIASES_B.SEGMENT22, ALIASES_B.SEGMENT23, ALIASES_B.SEGMENT24, ALIASES_B.SEGMENT25, ALIASES_B.SEGMENT26, ALIASES_B.SEGMENT27, ALIASES_B.SEGMENT28, ALIASES_B.SEGMENT29, ALIASES_B.SEGMENT30, 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, ALIASES_B.SEGMENT_ATTRIBUTE1, ALIASES_B.SEGMENT_ATTRIBUTE2, ALIASES_B.SEGMENT_ATTRIBUTE3, ALIASES_B.SEGMENT_ATTRIBUTE4, ALIASES_B.SEGMENT_ATTRIBUTE5, ALIASES_B.SEGMENT_ATTRIBUTE6, ALIASES_B.SEGMENT_ATTRIBUTE7, ALIASES_B.SEGMENT_ATTRIBUTE8, ALIASES_B.SEGMENT_ATTRIBUTE9, ALIASES_B.SEGMENT_ATTRIBUTE10, ALIASES_B.SEGMENT_ATTRIBUTE11, ALIASES_B.SEGMENT_ATTRIBUTE12, ALIASES_B.SEGMENT_ATTRIBUTE13, ALIASES_B.SEGMENT_ATTRIBUTE14, ALIASES_B.SEGMENT_ATTRIBUTE15, ALIASES_B.SEGMENT_ATTRIBUTE16, ALIASES_B.SEGMENT_ATTRIBUTE17, ALIASES_B.SEGMENT_ATTRIBUTE18, ALIASES_B.SEGMENT_ATTRIBUTE19, ALIASES_B.SEGMENT_ATTRIBUTE20, ALIASES_B.SEGMENT_ATTRIBUTE21, ALIASES_B.SEGMENT_ATTRIBUTE22, ALIASES_B.SEGMENT_ATTRIBUTE23, ALIASES_B.SEGMENT_ATTRIBUTE24, ALIASES_B.SEGMENT_ATTRIBUTE25, ALIASES_B.SEGMENT_ATTRIBUTE26, ALIASES_B.SEGMENT_ATTRIBUTE27, ALIASES_B.SEGMENT_ATTRIBUTE28, ALIASES_B.SEGMENT_ATTRIBUTE29, ALIASES_B.SEGMENT_ATTRIBUTE30, ALIASES_B.SEGMENT_ATTRIBUTE31, ALIASES_B.SEGMENT_ATTRIBUTE32, ALIASES_B.SEGMENT_ATTRIBUTE33, ALIASES_B.SEGMENT_ATTRIBUTE34, ALIASES_B.SEGMENT_ATTRIBUTE35, ALIASES_B.SEGMENT_ATTRIBUTE36, ALIASES_B.SEGMENT_ATTRIBUTE37, ALIASES_B.SEGMENT_ATTRIBUTE38, ALIASES_B.SEGMENT_ATTRIBUTE39, ALIASES_B.SEGMENT_ATTRIBUTE40, ALIASES_B.SEGMENT_ATTRIBUTE41, ALIASES_B.SEGMENT_ATTRIBUTE42, ALIASES_B.LEDGER_SEGMENT FROM GL_ACCOUNT_ALIASES_B ALIASES_B, GL_ACCOUNT_ALIASES_TL ALIASES_TL WHERE ALIASES_B.CHART_OF_ACCOUNTS_ID = ALIASES_TL.CHART_OF_ACCOUNTS_ID AND ALIASES_B.SHORTHAND_ALIAS_CODE = ALIASES_TL.SHORTHAND_ALIAS_CODE AND ALIASES_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT ALIASES_B.ROWID ROW_ID,

ALIASES_B.CHART_OF_ACCOUNTS_ID, 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.SEGMENT11, ALIASES_B.SEGMENT12, ALIASES_B.SEGMENT13, ALIASES_B.SEGMENT14, ALIASES_B.SEGMENT15,

ALIASES_B.SEGMENT16, ALIASES_B.SEGMENT17, ALIASES_B.SEGMENT18, ALIASES_B.SEGMENT19, ALIASES_B.SEGMENT20,

ALIASES_B.SEGMENT21, ALIASES_B.SEGMENT22, ALIASES_B.SEGMENT23, ALIASES_B.SEGMENT24, ALIASES_B.SEGMENT25,

ALIASES_B.SEGMENT26, ALIASES_B.SEGMENT27, ALIASES_B.SEGMENT28, ALIASES_B.SEGMENT29, ALIASES_B.SEGMENT30,

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,

ALIASES_B.SEGMENT_ATTRIBUTE1, ALIASES_B.SEGMENT_ATTRIBUTE2, ALIASES_B.SEGMENT_ATTRIBUTE3, ALIASES_B.SEGMENT_ATTRIBUTE4, ALIASES_B.SEGMENT_ATTRIBUTE5,

ALIASES_B.SEGMENT_ATTRIBUTE6, ALIASES_B.SEGMENT_ATTRIBUTE7, ALIASES_B.SEGMENT_ATTRIBUTE8, ALIASES_B.SEGMENT_ATTRIBUTE9, ALIASES_B.SEGMENT_ATTRIBUTE10,

ALIASES_B.SEGMENT_ATTRIBUTE11, ALIASES_B.SEGMENT_ATTRIBUTE12, ALIASES_B.SEGMENT_ATTRIBUTE13, ALIASES_B.SEGMENT_ATTRIBUTE14, ALIASES_B.SEGMENT_ATTRIBUTE15,

ALIASES_B.SEGMENT_ATTRIBUTE16, ALIASES_B.SEGMENT_ATTRIBUTE17, ALIASES_B.SEGMENT_ATTRIBUTE18, ALIASES_B.SEGMENT_ATTRIBUTE19, ALIASES_B.SEGMENT_ATTRIBUTE20,

ALIASES_B.SEGMENT_ATTRIBUTE21, ALIASES_B.SEGMENT_ATTRIBUTE22, ALIASES_B.SEGMENT_ATTRIBUTE23, ALIASES_B.SEGMENT_ATTRIBUTE24, ALIASES_B.SEGMENT_ATTRIBUTE25,

ALIASES_B.SEGMENT_ATTRIBUTE26, ALIASES_B.SEGMENT_ATTRIBUTE27, ALIASES_B.SEGMENT_ATTRIBUTE28, ALIASES_B.SEGMENT_ATTRIBUTE29, ALIASES_B.SEGMENT_ATTRIBUTE30,

ALIASES_B.SEGMENT_ATTRIBUTE31, ALIASES_B.SEGMENT_ATTRIBUTE32, ALIASES_B.SEGMENT_ATTRIBUTE33, ALIASES_B.SEGMENT_ATTRIBUTE34, ALIASES_B.SEGMENT_ATTRIBUTE35,

ALIASES_B.SEGMENT_ATTRIBUTE36, ALIASES_B.SEGMENT_ATTRIBUTE37, ALIASES_B.SEGMENT_ATTRIBUTE38, ALIASES_B.SEGMENT_ATTRIBUTE39, ALIASES_B.SEGMENT_ATTRIBUTE40,

ALIASES_B.SEGMENT_ATTRIBUTE41, ALIASES_B.SEGMENT_ATTRIBUTE42, ALIASES_B.LEDGER_SEGMENT

FROM GL_ACCOUNT_ALIASES_B ALIASES_B, GL_ACCOUNT_ALIASES_TL ALIASES_TL

WHERE ALIASES_B.CHART_OF_ACCOUNTS_ID = ALIASES_TL.CHART_OF_ACCOUNTS_ID

AND ALIASES_B.SHORTHAND_ALIAS_CODE = ALIASES_TL.SHORTHAND_ALIAS_CODE

AND ALIASES_TL.LANGUAGE = USERENV('LANG')