1. Tables and Views for Financials
  2. FA_FISCAL_YEAR_TYPES_VL

FA_FISCAL_YEAR_TYPES_VL

Details

  • Schema: FUSION

  • Object owner: FA

  • Object type: VIEW

Columns

Name

FISCAL_YEAR_NAME

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE_CATEGORY_CODE

OBJECT_VERSION_NUMBER

DESCRIPTION

Query

SQL_Statement

SELECT

b.FISCAL_YEAR_NAME,

b.CREATION_DATE,

b.CREATED_BY,

b.LAST_UPDATE_DATE,

b.LAST_UPDATED_BY,

b.LAST_UPDATE_LOGIN,

b.ATTRIBUTE1,

b.ATTRIBUTE2,

b.ATTRIBUTE3,

b.ATTRIBUTE4,

b.ATTRIBUTE5,

b.ATTRIBUTE6,

b.ATTRIBUTE7,

b.ATTRIBUTE8,

b.ATTRIBUTE9,

b.ATTRIBUTE10,

b.ATTRIBUTE11,

b.ATTRIBUTE12,

b.ATTRIBUTE13,

b.ATTRIBUTE14,

b.ATTRIBUTE15,

b.ATTRIBUTE_CATEGORY_CODE,

b.OBJECT_VERSION_NUMBER,

t.DESCRIPTION

FROM

FA_FISCAL_YEAR_TYPES_B b,

FA_FISCAL_YEAR_TYPES_TL t

WHERE

b.FISCAL_YEAR_NAME = t.FISCAL_YEAR_NAME AND t.LANGUAGE = USERENV('LANG')