1. Tables and Views for Financials
  2. VRM_REVISION_NET_REV_FORM_V

VRM_REVISION_NET_REV_FORM_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_rev_assign_v RA

GROUP BY prev_revenue_document_line_id,

TRUNC(ACCOUNTING_DATE),

prev_revenue_document_id,

period_set_name