1. Tables and Views for Financials
  2. VRM_REVISION_NET_REV_ASSIGN_V

VRM_REVISION_NET_REV_ASSIGN_V

Details

  • Schema: FUSION

  • Object owner: VRM

  • Object type: VIEW

Columns

Name

REVENUE_DOCUMENT_LINE_ID

PREV_REVENUE_DOCUMENT_LINE_ID

PREV_REVENUE_DOCUMENT_ID

ACCOUNTING_DATE

AMOUNT

QUANTITY

REVENUE_REVERSAL_METHOD

PERIOD_SET_NAME

Query

SQL_Statement

SELECT vra.REVENUE_ADJUSTMENT_ID revenue_document_line_id,

vra.FROM_REV_DOC_LINE_ID prev_revenue_document_line_id,

vra.REVENUE_DOCUMENT_ID prev_revenue_document_id,

CMA.ACCOUNTING_DATE ,

DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND(cma.AMOUNT, FC.PRECISION), ROUND(cma.AMOUNT / FC.MINIMUM_ACCOUNTABLE_UNIT ) * FC.MINIMUM_ACCOUNTABLE_UNIT ) amount, /* amount */

NVL(doc_line.QUANTITY, 0) quantity,

Nvl(doc_line.revenue_reversal_method, 'PRORATE'),

SOB.PERIOD_SET_NAME

FROM

VRM_REVENUE_ADJUSTMENTS_ALL vra,

vrm_revision_line_amounts cma,

VRM_REVENUE_DOCUMENTS_ALL vrd,

fnd_currencies fc,

gl_sets_of_books sob,

vrm_source_doc_lines doc_line

WHERE vra.type = 'RETURN'

AND vra.document_line_id = cma.document_line_id

AND vra.revenue_document_id = vrd.revenue_document_id

AND vrd.CURRENCY_CODE = fc.CURRENCY_CODE

AND vrd.set_of_books_id = sob.set_of_books_id

AND vra.document_line_id = doc_line.document_line_id

UNION

SELECT TO_NUMBER('') revenue_document_line_id,

original_line.revenue_document_line_id prev_revenue_document_line_id,

original_line.revenue_document_id prev_revenue_document_id,

RA.ACCOUNTING_DATE,

DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND(AMOUNT, FC.PRECISION), ROUND(AMOUNT / FC.MINIMUM_ACCOUNTABLE_UNIT ) * FC.MINIMUM_ACCOUNTABLE_UNIT ) amount,

/* amount */

RA.QUANTITY,

NULL revenue_reversal_method,

PERIOD_SET_NAME

FROM vrm_actual_rev_assignments_v RA,

VRM_REVENUE_DOC_LINES_ALL original_line,

FND_CURRENCIES FC,

VRM_REVENUE_DOCUMENTS_ALL CT

WHERE ACCOUNT_CLASS = 'REV'

AND original_line.revenue_document_line_id = RA.revenue_document_line_id

AND original_line.revenue_document_id = CT.revenue_document_id

AND CT.CURRENCY_CODE = FC.currency_code