AR_SYSTEM_PARAM_H_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name
CASH_BASIS_SET_OF_BOOKS_ID CODE_COMBINATION_ID_GAIN CODE_COMBINATION_ID_LOSS SET_OF_BOOKS_ID EVENT_ID ADOPTION_PERIOD ADOPTION_PERIOD_START_DATE

Query

SQL_Statement

SELECT sys.CASH_BASIS_SET_OF_BOOKS_ID , sys.CODE_COMBINATION_ID_GAIN CODE_COMBINATION_ID_GAIN, NVL(sys.CODE_COMBINATION_ID_LOSS, sys.CODE_COMBINATION_ID_GAIN) as CODE_COMBINATION_ID_LOSS , sys.set_of_books_id , xle.event_id, vlo.ADOPTION_PERIOD ADOPTION_PERIOD, gps.START_DATE ADOPTION_PERIOD_START_DATE FROM ar_system_parameters_all sys, ar_xla_lines_extract xle, VRM_LEDGER_OPTIONS vlo, GL_PERIOD_STATUSES gps WHERE sys.org_id = xle.org_id AND xle.level_flag = 'H' AND vlo.LEDGER_ID(+) = sys.SET_OF_BOOKS_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