1. Tables and Views for Financials
  2. VRM_REVISION_NET_REV_SCHED_V

VRM_REVISION_NET_REV_SCHED_V

Details

  • Schema: FUSION

  • Object owner: VRM

  • Object type: VIEW

Columns

Name

PREV_REVENUE_DOCUMENT_LINE_ID

PREV_REVENUE_DOCUMENT_ID

ACCOUNTING_DATE

AMOUNT

NET_UNIT_PRICE

PERIOD_SET_NAME

Query

SQL_Statement

SELECT prev_revenue_document_line_id ,

prev_revenue_document_id ,

TRUNC(accounting_date) accounting_date ,

SUM(amount) amount ,

SUM(DECODE(revenue_reversal_method, 'UNIT', 0, 'LIFO', 0, amount) ) / DECODE(SUM(DECODE(revenue_reversal_method, '', quantity, 0) ), 0, 1, SUM(DECODE(revenue_reversal_method, '', quantity, 0) ) ) net_unit_price ,

period_set_name

FROM vrm_revision_net_sched_amts_v RA

GROUP BY prev_revenue_document_line_id,

TRUNC(accounting_date),

prev_revenue_document_id,

period_set_name