1. Tables and Views for Financials
  2. VRM_XLA_REV_CONT_EVENTS_V

VRM_XLA_REV_CONT_EVENTS_V

Details

  • Schema: FUSION

  • Object owner: VRM

  • Object type: VIEW

Columns

Name

EVENT_ID

EVENT_TYPE_CODE

TRANSFER_TO_GL_FLAG

Query

SQL_Statement

SELECT /*+INDEX (l VRM_XLA_IFRS15_EXTRACT_GT_N1)*/

l.EVENT_ID,

l.EVENT_TYPE_CODE,

dists.TRANSFER_TO_GL_FLAG

FROM VRM_XLA_IFRS15_EXTRACT_GT l,

VRM_PERF_OBLIGATION_LIN_DISTS dists

WHERE l.LEVEL_CODE = 'L'

AND dists.PERF_OBLIGATION_LINE_DIST_ID = l.PERF_OBLIGATION_LINE_DIST_ID

group by l.EVENT_ID,

l.EVENT_TYPE_CODE,

dists.TRANSFER_TO_GL_FLAG