CMR_B_PERIOD_STATUSES_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
BU_ID PERIOD_SET_NAME LEDGER_ID LEGAL_ENTITY_ID PERIOD_TYPE PERIOD_NAME PERIOD_NUM PERIOD_YEAR START_DATE END_DATE LE_TIME_OFFSET SERVER_START_DATE SERVER_END_DATE

Query

SQL_Statement

SELECT BU.BU_ID, L.PERIOD_SET_NAME, BU.PRIMARY_LEDGER_ID LEDGER_ID, BU.LEGAL_ENTITY_ID, L.ACCOUNTED_PERIOD_TYPE PERIOD_TYPE, P.PERIOD_NAME, P.PERIOD_NUM, P.PERIOD_YEAR, P.START_DATE, P.END_DATE, NVL(XLE_LE_TIMEZONE_GRP.GET_SERVER_DAY_TIME('LEGAL_ENTITY_ID', BU.LEGAL_ENTITY_ID, P.END_DATE), P.END_DATE)-P.END_DATE LE_TIME_OFFSET, NVL(XLE_LE_TIMEZONE_GRP.GET_SERVER_DAY_TIME('LEGAL_ENTITY_ID', BU.LEGAL_ENTITY_ID, P.START_DATE), P.START_DATE) SERVER_START_DATE, NVL(XLE_LE_TIMEZONE_GRP.GET_SERVER_DAY_TIME('LEGAL_ENTITY_ID', BU.LEGAL_ENTITY_ID, P.END_DATE), P.END_DATE) SERVER_END_DATE FROM CMR_BU_PARAMETERS BU, GL_LEDGERS L, GL_PERIODS P WHERE BU.PRIMARY_LEDGER_ID = L.LEDGER_ID AND L.PERIOD_SET_NAME = P.PERIOD_SET_NAME AND L.ACCOUNTED_PERIOD_TYPE = P.PERIOD_TYPE AND P.START_DATE <= SYSDATE AND p.adjustment_period_flag = 'N' AND P.START_DATE >= TRUNC(SYSDATE) - interval '2' YEAR