1. Tables and Views for Financials
  2. VRM_XLA_CONTRACT_ACCOUNTS_V

VRM_XLA_CONTRACT_ACCOUNTS_V

Details

  • Schema: FUSION

  • Object owner: VRM

  • Object type: VIEW

Columns

Name

DISCOUNT_CLEARING_CCID

CONTRACT_LIABILITY_CCID

CONTRACT_ASSET_CCID

CONTRACT_PRICE_VARIANCE_CCID

EVENT_ID

LINE_NUMBER

LEDGER_ID

REV_WRITE_OFF_ACCT

Query

SQL_Statement

SELECT /*+INDEX (l VRM_XLA_IFRS15_EXTRACT_GT_N1)*/

vlo.DISCOUNT_CLG_DEF_ACCOUNT_CCID DISCOUNT_CLEARING_CCID,

vlo.LIABILITY_DEF_ACCOUNT_CCID CONTRACT_LIABILITY_CCID,

vlo.ASSET_DEF_ACCOUNT_CCID CONTRACT_ASSET_CCID,

vlo.PRICE_VAR_DEF_ACCOUNT_CCID CONTRACT_PRICE_VARIANCE_CCID,

l.EVENT_ID EVENT_ID,

l.LINE_NUMBER LINE_NUMBER,

l.LEDGER_ID LEDGER_ID,

vlo.WRITEOFF_DEF_ACCOUNT_CCID REV_WRITE_OFF_ACCT

FROM VRM_LEDGER_OPTIONS vlo,

VRM_XLA_IFRS15_EXTRACT_GT l

WHERE l.LEVEL_CODE = 'H'

AND vlo.LEDGER_ID = l.LEDGER_ID