1. Tables and Views for Financials
  2. VRM_REVENUE_OPTIONS_V

VRM_REVENUE_OPTIONS_V

Details

  • Schema: FUSION

  • Object owner: VRM

  • Object type: VIEW

Columns

Name

REV_OPT_ORG_ID

CLEARING_ACCOUNT

ACT_DATE_IN_CLOSED_PERIOD

CREATE_CLEARING_OPTION

CARVE_OUT_CLEARING_ACCOUNT

UNBILLED_REVENUE_ACCOUNT

EVENT_ID

LINE_NUMBER

LEDGER_ID

Query

SQL_Statement

SELECT

vroa.ORG_ID REV_OPT_ORG_ID,

vroa.CLEARING_ACCOUNT,

vroa.ACT_DATE_IN_CLOSED_PERIOD,

vroa.CREATE_CLEARING_OPTION,

vroa.REV_CLEARING_DEFAULT_ACCOUNT CARVE_OUT_CLEARING_ACCOUNT,

vroa.MEA_CLEARING_DEFAULT_ACCOUNT UNBILLED_REVENUE_ACCOUNT,

l.EVENT_ID,

l.LINE_NUMBER,

l.LEDGER_ID

FROM

VRM_REVENUE_OPTIONS_ALL vroa,

vrm_xla_lines_extract_gt l

WHERE l.ORG_ID = vroa.ORG_ID