JV_MEASURE_LINE

Details

Schema: FUSION
Object owner: JV
Object type: VIEW

Columns

Name
LINE_NUMBER OPERATIONAL_MEASURE_ID MEASURE_PRIMARY_SEG_VALUE MEASURE_REFERENCE MEASURE_DATE MEASURE_LINE_TYPE_CODE MEASURE_VALUE MEASURE_VALUE_ATTR_CATEGORY MEASURE_VALUE_ATTR_CHAR1 MEASURE_VALUE_ATTR_CHAR2 MEASURE_VALUE_ATTR_CHAR3 MEASURE_VALUE_ATTR_CHAR4 MEASURE_VALUE_ATTR_CHAR5 MEASURE_VALUE_ATTR_CHAR6 MEASURE_VALUE_ATTR_CHAR7 MEASURE_VALUE_ATTR_CHAR8 MEASURE_VALUE_ATTR_CHAR9 MEASURE_VALUE_ATTR_CHAR10 MEASURE_VALUE_ATTR_DATE1 MEASURE_VALUE_ATTR_DATE2 MEASURE_VALUE_ATTR_DATE3 MEASURE_VALUE_ATTR_DATE4 MEASURE_VALUE_ATTR_DATE5 MEASURE_VALUE_ATTR_NUMBER1 MEASURE_VALUE_ATTR_NUMBER2 MEASURE_VALUE_ATTR_NUMBER3 MEASURE_VALUE_ATTR_NUMBER4 MEASURE_VALUE_ATTR_NUMBER5 CURRENCY_CODE MEASURE_TYPE_SHORT_NAME MEASURE_TYPE_ATTR_CATEGORY MEASURE_TYPE_ATTR_CHAR1 MEASURE_TYPE_ATTR_CHAR2 MEASURE_TYPE_ATTR_CHAR3 MEASURE_TYPE_ATTR_CHAR4 MEASURE_TYPE_ATTR_CHAR5 MEASURE_TYPE_ATTR_CHAR6 MEASURE_TYPE_ATTR_CHAR7 MEASURE_TYPE_ATTR_CHAR8 MEASURE_TYPE_ATTR_CHAR9 MEASURE_TYPE_ATTR_CHAR10 MEASURE_TYPE_ATTR_DATE1 MEASURE_TYPE_ATTR_DATE2 MEASURE_TYPE_ATTR_DATE3 MEASURE_TYPE_ATTR_DATE4 MEASURE_TYPE_ATTR_DATE5 MEASURE_TYPE_ATTR_NUMBER1 MEASURE_TYPE_ATTR_NUMBER2 MEASURE_TYPE_ATTR_NUMBER3 MEASURE_TYPE_ATTR_NUMBER4 MEASURE_TYPE_ATTR_NUMBER5 UNIT_OF_MEASURE_CODE MEASURE_VALUE_TYPE_CODE EVENT_ID

Name

LINE_NUMBER

OPERATIONAL_MEASURE_ID

MEASURE_PRIMARY_SEG_VALUE

MEASURE_REFERENCE

MEASURE_DATE

MEASURE_LINE_TYPE_CODE

MEASURE_VALUE

MEASURE_VALUE_ATTR_CATEGORY

MEASURE_VALUE_ATTR_CHAR1

MEASURE_VALUE_ATTR_CHAR2

MEASURE_VALUE_ATTR_CHAR3

MEASURE_VALUE_ATTR_CHAR4

MEASURE_VALUE_ATTR_CHAR5

MEASURE_VALUE_ATTR_CHAR6

MEASURE_VALUE_ATTR_CHAR7

MEASURE_VALUE_ATTR_CHAR8

MEASURE_VALUE_ATTR_CHAR9

MEASURE_VALUE_ATTR_CHAR10

MEASURE_VALUE_ATTR_DATE1

MEASURE_VALUE_ATTR_DATE2

MEASURE_VALUE_ATTR_DATE3

MEASURE_VALUE_ATTR_DATE4

MEASURE_VALUE_ATTR_DATE5

MEASURE_VALUE_ATTR_NUMBER1

MEASURE_VALUE_ATTR_NUMBER2

MEASURE_VALUE_ATTR_NUMBER3

MEASURE_VALUE_ATTR_NUMBER4

MEASURE_VALUE_ATTR_NUMBER5

CURRENCY_CODE

MEASURE_TYPE_SHORT_NAME

MEASURE_TYPE_ATTR_CATEGORY

MEASURE_TYPE_ATTR_CHAR1

MEASURE_TYPE_ATTR_CHAR2

MEASURE_TYPE_ATTR_CHAR3

MEASURE_TYPE_ATTR_CHAR4

MEASURE_TYPE_ATTR_CHAR5

MEASURE_TYPE_ATTR_CHAR6

MEASURE_TYPE_ATTR_CHAR7

MEASURE_TYPE_ATTR_CHAR8

MEASURE_TYPE_ATTR_CHAR9

MEASURE_TYPE_ATTR_CHAR10

MEASURE_TYPE_ATTR_DATE1

MEASURE_TYPE_ATTR_DATE2

MEASURE_TYPE_ATTR_DATE3

MEASURE_TYPE_ATTR_DATE4

MEASURE_TYPE_ATTR_DATE5

MEASURE_TYPE_ATTR_NUMBER1

MEASURE_TYPE_ATTR_NUMBER2

MEASURE_TYPE_ATTR_NUMBER3

MEASURE_TYPE_ATTR_NUMBER4

MEASURE_TYPE_ATTR_NUMBER5

UNIT_OF_MEASURE_CODE

MEASURE_VALUE_TYPE_CODE

EVENT_ID

Query

SQL_Statement
SELECT JM.OPERATIONAL_MEASURE_ID LINE_NUMBER, JM.OPERATIONAL_MEASURE_ID OPERATIONAL_MEASURE_ID, JM.PRIMARY_SEGMENT_VALUE MEASURE_PRIMARY_SEG_VALUE, JM.MEASURE_REFERENCE MEASURE_REFERENCE, JM.MEASURE_DATE MEASURE_DATE, JM.MEASURE_LINE_TYPE_CODE MEASURE_LINE_TYPE_CODE, JM.MEASURE_VALUE MEASURE_VALUE, JM.ATTRIBUTE_CATEGORY MEASURE_VALUE_ATTR_CATEGORY, JM.ATTRIBUTE_CHAR1 MEASURE_VALUE_ATTR_CHAR1, JM.ATTRIBUTE_CHAR2 MEASURE_VALUE_ATTR_CHAR2, JM.ATTRIBUTE_CHAR3 MEASURE_VALUE_ATTR_CHAR3, JM.ATTRIBUTE_CHAR4 MEASURE_VALUE_ATTR_CHAR4, JM.ATTRIBUTE_CHAR5 MEASURE_VALUE_ATTR_CHAR5, JM.ATTRIBUTE_CHAR6 MEASURE_VALUE_ATTR_CHAR6, JM.ATTRIBUTE_CHAR7 MEASURE_VALUE_ATTR_CHAR7, JM.ATTRIBUTE_CHAR8 MEASURE_VALUE_ATTR_CHAR8, JM.ATTRIBUTE_CHAR9 MEASURE_VALUE_ATTR_CHAR9, JM.ATTRIBUTE_CHAR10 MEASURE_VALUE_ATTR_CHAR10, JM.ATTRIBUTE_DATE1 MEASURE_VALUE_ATTR_DATE1, JM.ATTRIBUTE_DATE2 MEASURE_VALUE_ATTR_DATE2, JM.ATTRIBUTE_DATE3 MEASURE_VALUE_ATTR_DATE3, JM.ATTRIBUTE_DATE4 MEASURE_VALUE_ATTR_DATE4, JM.ATTRIBUTE_DATE5 MEASURE_VALUE_ATTR_DATE5, JM.ATTRIBUTE_NUMBER1 MEASURE_VALUE_ATTR_NUMBER1, JM.ATTRIBUTE_NUMBER2 MEASURE_VALUE_ATTR_NUMBER2, JM.ATTRIBUTE_NUMBER3 MEASURE_VALUE_ATTR_NUMBER3, JM.ATTRIBUTE_NUMBER4 MEASURE_VALUE_ATTR_NUMBER4, JM.ATTRIBUTE_NUMBER5 MEASURE_VALUE_ATTR_NUMBER5, 'STAT' CURRENCY_CODE, JT.MEASURE_TYPE_SHORT_NAME MEASURE_TYPE_SHORT_NAME, JT.ATTRIBUTE_CATEGORY MEASURE_TYPE_ATTR_CATEGORY, JT.ATTRIBUTE_CHAR1 MEASURE_TYPE_ATTR_CHAR1, JT.ATTRIBUTE_CHAR2 MEASURE_TYPE_ATTR_CHAR2, JT.ATTRIBUTE_CHAR3 MEASURE_TYPE_ATTR_CHAR3, JT.ATTRIBUTE_CHAR4 MEASURE_TYPE_ATTR_CHAR4, JT.ATTRIBUTE_CHAR5 MEASURE_TYPE_ATTR_CHAR5, JT.ATTRIBUTE_CHAR6 MEASURE_TYPE_ATTR_CHAR6, JT.ATTRIBUTE_CHAR7 MEASURE_TYPE_ATTR_CHAR7, JT.ATTRIBUTE_CHAR8 MEASURE_TYPE_ATTR_CHAR8, JT.ATTRIBUTE_CHAR9 MEASURE_TYPE_ATTR_CHAR9, JT.ATTRIBUTE_CHAR10 MEASURE_TYPE_ATTR_CHAR10, JT.ATTRIBUTE_DATE1 MEASURE_TYPE_ATTR_DATE1, JT.ATTRIBUTE_DATE2 MEASURE_TYPE_ATTR_DATE2, JT.ATTRIBUTE_DATE3 MEASURE_TYPE_ATTR_DATE3, JT.ATTRIBUTE_DATE4 MEASURE_TYPE_ATTR_DATE4, JT.ATTRIBUTE_DATE5 MEASURE_TYPE_ATTR_DATE5, JT.ATTRIBUTE_NUMBER1 MEASURE_TYPE_ATTR_NUMBER1, JT.ATTRIBUTE_NUMBER2 MEASURE_TYPE_ATTR_NUMBER2, JT.ATTRIBUTE_NUMBER3 MEASURE_TYPE_ATTR_NUMBER3, JT.ATTRIBUTE_NUMBER4 MEASURE_TYPE_ATTR_NUMBER4, JT.ATTRIBUTE_NUMBER5 MEASURE_TYPE_ATTR_NUMBER5, JT.UNIT_OF_MEASURE_CODE UNIT_OF_MEASURE_CODE, JT.MEASURE_VALUE_TYPE_CODE MEASURE_VALUE_TYPE_CODE, JA.EVENT_ID EVENT_ID FROM JV_OPERATIONAL_MEASURES JM, JV_MEASURE_TYPES_B JT, JV_ACCOUNTING_HEADERS JA WHERE JT.MEASURE_TYPE_ID = JM.MEASURE_TYPE_ID AND JA.ACCOUNTING_HEADER_ID = JM.ACCOUNTING_HEADER_ID

SQL_Statement

SELECT

JM.OPERATIONAL_MEASURE_ID LINE_NUMBER,

JM.OPERATIONAL_MEASURE_ID OPERATIONAL_MEASURE_ID,

JM.PRIMARY_SEGMENT_VALUE MEASURE_PRIMARY_SEG_VALUE,

JM.MEASURE_REFERENCE MEASURE_REFERENCE,

JM.MEASURE_DATE MEASURE_DATE,

JM.MEASURE_LINE_TYPE_CODE MEASURE_LINE_TYPE_CODE,

JM.MEASURE_VALUE MEASURE_VALUE,

JM.ATTRIBUTE_CATEGORY MEASURE_VALUE_ATTR_CATEGORY,

JM.ATTRIBUTE_CHAR1 MEASURE_VALUE_ATTR_CHAR1,

JM.ATTRIBUTE_CHAR2 MEASURE_VALUE_ATTR_CHAR2,

JM.ATTRIBUTE_CHAR3 MEASURE_VALUE_ATTR_CHAR3,

JM.ATTRIBUTE_CHAR4 MEASURE_VALUE_ATTR_CHAR4,

JM.ATTRIBUTE_CHAR5 MEASURE_VALUE_ATTR_CHAR5,

JM.ATTRIBUTE_CHAR6 MEASURE_VALUE_ATTR_CHAR6,

JM.ATTRIBUTE_CHAR7 MEASURE_VALUE_ATTR_CHAR7,

JM.ATTRIBUTE_CHAR8 MEASURE_VALUE_ATTR_CHAR8,

JM.ATTRIBUTE_CHAR9 MEASURE_VALUE_ATTR_CHAR9,

JM.ATTRIBUTE_CHAR10 MEASURE_VALUE_ATTR_CHAR10,

JM.ATTRIBUTE_DATE1 MEASURE_VALUE_ATTR_DATE1,

JM.ATTRIBUTE_DATE2 MEASURE_VALUE_ATTR_DATE2,

JM.ATTRIBUTE_DATE3 MEASURE_VALUE_ATTR_DATE3,

JM.ATTRIBUTE_DATE4 MEASURE_VALUE_ATTR_DATE4,

JM.ATTRIBUTE_DATE5 MEASURE_VALUE_ATTR_DATE5,

JM.ATTRIBUTE_NUMBER1 MEASURE_VALUE_ATTR_NUMBER1,

JM.ATTRIBUTE_NUMBER2 MEASURE_VALUE_ATTR_NUMBER2,

JM.ATTRIBUTE_NUMBER3 MEASURE_VALUE_ATTR_NUMBER3,

JM.ATTRIBUTE_NUMBER4 MEASURE_VALUE_ATTR_NUMBER4,

JM.ATTRIBUTE_NUMBER5 MEASURE_VALUE_ATTR_NUMBER5,

'STAT' CURRENCY_CODE,

JT.MEASURE_TYPE_SHORT_NAME MEASURE_TYPE_SHORT_NAME,

JT.ATTRIBUTE_CATEGORY MEASURE_TYPE_ATTR_CATEGORY,

JT.ATTRIBUTE_CHAR1 MEASURE_TYPE_ATTR_CHAR1,

JT.ATTRIBUTE_CHAR2 MEASURE_TYPE_ATTR_CHAR2,

JT.ATTRIBUTE_CHAR3 MEASURE_TYPE_ATTR_CHAR3,

JT.ATTRIBUTE_CHAR4 MEASURE_TYPE_ATTR_CHAR4,

JT.ATTRIBUTE_CHAR5 MEASURE_TYPE_ATTR_CHAR5,

JT.ATTRIBUTE_CHAR6 MEASURE_TYPE_ATTR_CHAR6,

JT.ATTRIBUTE_CHAR7 MEASURE_TYPE_ATTR_CHAR7,

JT.ATTRIBUTE_CHAR8 MEASURE_TYPE_ATTR_CHAR8,

JT.ATTRIBUTE_CHAR9 MEASURE_TYPE_ATTR_CHAR9,

JT.ATTRIBUTE_CHAR10 MEASURE_TYPE_ATTR_CHAR10,

JT.ATTRIBUTE_DATE1 MEASURE_TYPE_ATTR_DATE1,

JT.ATTRIBUTE_DATE2 MEASURE_TYPE_ATTR_DATE2,

JT.ATTRIBUTE_DATE3 MEASURE_TYPE_ATTR_DATE3,

JT.ATTRIBUTE_DATE4 MEASURE_TYPE_ATTR_DATE4,

JT.ATTRIBUTE_DATE5 MEASURE_TYPE_ATTR_DATE5,

JT.ATTRIBUTE_NUMBER1 MEASURE_TYPE_ATTR_NUMBER1,

JT.ATTRIBUTE_NUMBER2 MEASURE_TYPE_ATTR_NUMBER2,

JT.ATTRIBUTE_NUMBER3 MEASURE_TYPE_ATTR_NUMBER3,

JT.ATTRIBUTE_NUMBER4 MEASURE_TYPE_ATTR_NUMBER4,

JT.ATTRIBUTE_NUMBER5 MEASURE_TYPE_ATTR_NUMBER5,

JT.UNIT_OF_MEASURE_CODE UNIT_OF_MEASURE_CODE,

JT.MEASURE_VALUE_TYPE_CODE MEASURE_VALUE_TYPE_CODE,

JA.EVENT_ID EVENT_ID

FROM

JV_OPERATIONAL_MEASURES JM,

JV_MEASURE_TYPES_B JT,

JV_ACCOUNTING_HEADERS JA

WHERE

JT.MEASURE_TYPE_ID = JM.MEASURE_TYPE_ID AND

JA.ACCOUNTING_HEADER_ID = JM.ACCOUNTING_HEADER_ID