1. Tables and Views for Financials
  2. VRM_LEDGER_OPTIONS_V

VRM_LEDGER_OPTIONS_V

Details

  • Schema: FUSION

  • Object owner: VRM

  • Object type: VIEW

Columns

Name

IFRS_LEDGER_ID

CLEARING_ACCOUNT_CCID

ADOPTION_START_DATE

DOCUMENT_TYPE_ID

DOCUMENT_TYPE_CODE

DOCUMENT_TYPE_NAME

Query

SQL_Statement

SELECT nvl(vlo.IFRS_LEDGER_ID, vlo.LEDGER_ID) IFRS_LEDGER_ID,

vnas.CONTRACT_CLG_DEF_ACCOUNT_CCID CLEARING_ACCOUNT_CCID,

gps.START_DATE ADOPTION_START_DATE,

vnas.DOCUMENT_TYPE_ID DOCUMENT_TYPE_ID,

vsdt.DOCUMENT_TYPE_CODE DOCUMENT_TYPE_CODE,

vsdt.NAME DOCUMENT_TYPE_NAME

FROM VRM_LEDGER_OPTIONS vlo,

VRM_NEW_APP_SOURCES vnas,

GL_PERIOD_STATUSES gps,

VRM_SOURCE_DOC_TYPES_VL vsdt

WHERE vlo.LEDGER_ID = vnas.LEDGER_ID

AND gps.APPLICATION_ID(+) = 10455

AND gps.LEDGER_ID(+) = nvl(vlo.IFRS_LEDGER_ID, vlo.LEDGER_ID)

AND gps.PERIOD_NAME(+) = vlo.ADOPTION_PERIOD

AND vsdt.DOCUMENT_TYPE_ID = vnas.DOCUMENT_TYPE_ID