1. Tables and Views for Financials
  2. JV_MEASURE_LINE_VL

JV_MEASURE_LINE_VL

Details

  • Schema: FUSION

  • Object owner: JV

  • Object type: VIEW

Columns

Name

LINE_NUMBER

LANGUAGE

EVENT_ID

MEASURE_TYPE_NAME

MEASURE_TYPE_DESCRIPTION

Query

SQL_Statement

SELECT

JM.OPERATIONAL_MEASURE_ID LINE_NUMBER,

JT.LANGUAGE,

JA.EVENT_ID,

JT.MEASURE_TYPE_NAME,

JT.MEASURE_TYPE_DESCRIPTION

FROM

JV_OPERATIONAL_MEASURES JM,

JV_ACCOUNTING_HEADERS JA,

JV_MEASURE_TYPES_TL JT

WHERE

JA.ACCOUNTING_HEADER_ID = JM.ACCOUNTING_HEADER_ID AND

JT.MEASURE_TYPE_ID = JM.MEASURE_TYPE_ID