GL_HIERVIEW_LEDGER_PERIODS

Details

Schema: FUSION
Object owner: GL
Object type: VIEW

Columns

Name
LEDGER_ID NAME DESCRIPTION OBJECT_TYPE_CODE PERIOD_SET_NAME ACCOUNTED_PERIOD_TYPE CONFIGURATION_ID CURRENCY_CODE ALC_LEDGER_TYPE_CODE BAL_SEG_COLUMN_NAME BAL_SEG_VALUE_SET_ID CHART_OF_ACCOUNTS_ID COMPLETE_FLAG COMPLETION_STATUS_CODE FIRST_LEDGER_PERIOD_NAME IMPLICIT_ACCESS_SET_ID IMPLICIT_LEDGER_SET_ID LATEST_OPENED_PERIOD_NAME LE_LEDGER_TYPE_CODE LEDGER_CATEGORY_CODE MGT_SEG_COLUMN_NAME MGT_SEG_VALUE_SET_ID NET_INCOME_CODE_COMBINATION_ID RES_ENCUMB_CODE_COMBINATION_ID RET_EARN_CODE_COMBINATION_ID ROUNDING_CODE_COMBINATION_ID SHORT_NAME SLA_ACCOUNTING_METHOD_CODE SLA_ACCOUNTING_METHOD_TYPE SLA_DESCRIPTION_LANGUAGE SLA_ENTERED_CUR_BAL_SUS_CCID SLA_LEDGER_CUR_BAL_SUS_CCID TRANSACTION_CALENDAR_ID ALLOW_INTERCOMPANY_POST_FLAG BAL_SEG_VALUE_OPTION_CODE CREATE_JE_FLAG DAILY_TRANSLATION_RATE_TYPE ENABLE_AVERAGE_BALANCES_FLAG ENABLE_JE_APPROVAL_FLAG ENABLE_RECONCILIATION_FLAG ENABLE_SECONDARY_TRACK_FLAG FUTURE_ENTERABLE_PERIODS_LIMIT INTERCO_GAIN_LOSS_CCID MGT_SEG_VALUE_OPTION_CODE PERIOD_AVERAGE_RATE_TYPE PERIOD_END_RATE_TYPE SLA_BAL_BY_LEDGER_CURR_FLAG SLA_LEDGER_CASH_BASIS_FLAG SLA_SEQUENCING_FLAG SUSPENSE_ALLOWED_FLAG PERIOD_NAME ADJUSTMENT_PERIOD_FLAG CONFIRMATION_STATUS END_DATE ENTERED_PERIOD_NAME PERIOD_NUM PERIOD_YEAR QUARTER_NUM QUARTER_START_DATE START_DATE YEAR_START_DATE

Name

LEDGER_ID

NAME

DESCRIPTION

OBJECT_TYPE_CODE

PERIOD_SET_NAME

ACCOUNTED_PERIOD_TYPE

CONFIGURATION_ID

CURRENCY_CODE

ALC_LEDGER_TYPE_CODE

BAL_SEG_COLUMN_NAME

BAL_SEG_VALUE_SET_ID

CHART_OF_ACCOUNTS_ID

COMPLETE_FLAG

COMPLETION_STATUS_CODE

FIRST_LEDGER_PERIOD_NAME

IMPLICIT_ACCESS_SET_ID

IMPLICIT_LEDGER_SET_ID

LATEST_OPENED_PERIOD_NAME

LE_LEDGER_TYPE_CODE

LEDGER_CATEGORY_CODE

MGT_SEG_COLUMN_NAME

MGT_SEG_VALUE_SET_ID

NET_INCOME_CODE_COMBINATION_ID

RES_ENCUMB_CODE_COMBINATION_ID

RET_EARN_CODE_COMBINATION_ID

ROUNDING_CODE_COMBINATION_ID

SHORT_NAME

SLA_ACCOUNTING_METHOD_CODE

SLA_ACCOUNTING_METHOD_TYPE

SLA_DESCRIPTION_LANGUAGE

SLA_ENTERED_CUR_BAL_SUS_CCID

SLA_LEDGER_CUR_BAL_SUS_CCID

TRANSACTION_CALENDAR_ID

ALLOW_INTERCOMPANY_POST_FLAG

BAL_SEG_VALUE_OPTION_CODE

CREATE_JE_FLAG

DAILY_TRANSLATION_RATE_TYPE

ENABLE_AVERAGE_BALANCES_FLAG

ENABLE_JE_APPROVAL_FLAG

ENABLE_RECONCILIATION_FLAG

ENABLE_SECONDARY_TRACK_FLAG

FUTURE_ENTERABLE_PERIODS_LIMIT

INTERCO_GAIN_LOSS_CCID

MGT_SEG_VALUE_OPTION_CODE

PERIOD_AVERAGE_RATE_TYPE

PERIOD_END_RATE_TYPE

SLA_BAL_BY_LEDGER_CURR_FLAG

SLA_LEDGER_CASH_BASIS_FLAG

SLA_SEQUENCING_FLAG

SUSPENSE_ALLOWED_FLAG

PERIOD_NAME

ADJUSTMENT_PERIOD_FLAG

CONFIRMATION_STATUS

END_DATE

ENTERED_PERIOD_NAME

PERIOD_NUM

PERIOD_YEAR

QUARTER_NUM

QUARTER_START_DATE

START_DATE

YEAR_START_DATE

Query

SQL_Statement
SELECT L.LEDGER_ID, L.NAME, L.DESCRIPTION, L.OBJECT_TYPE_CODE, L.PERIOD_SET_NAME, L.ACCOUNTED_PERIOD_TYPE, L.CONFIGURATION_ID, L.CURRENCY_CODE, L.ALC_LEDGER_TYPE_CODE, L.BAL_SEG_COLUMN_NAME, L.BAL_SEG_VALUE_SET_ID, L.CHART_OF_ACCOUNTS_ID, L.COMPLETE_FLAG, L.COMPLETION_STATUS_CODE, L.FIRST_LEDGER_PERIOD_NAME, L.IMPLICIT_ACCESS_SET_ID, L.IMPLICIT_LEDGER_SET_ID, L.LATEST_OPENED_PERIOD_NAME, L.LE_LEDGER_TYPE_CODE, L.LEDGER_CATEGORY_CODE, L.MGT_SEG_COLUMN_NAME, L.MGT_SEG_VALUE_SET_ID, L.NET_INCOME_CODE_COMBINATION_ID, L.RES_ENCUMB_CODE_COMBINATION_ID, L.RET_EARN_CODE_COMBINATION_ID, L.ROUNDING_CODE_COMBINATION_ID, L.SHORT_NAME, L.SLA_ACCOUNTING_METHOD_CODE, L.SLA_ACCOUNTING_METHOD_TYPE, L.SLA_DESCRIPTION_LANGUAGE, L.SLA_ENTERED_CUR_BAL_SUS_CCID, L.SLA_LEDGER_CUR_BAL_SUS_CCID, L.TRANSACTION_CALENDAR_ID, L.ALLOW_INTERCOMPANY_POST_FLAG, L.BAL_SEG_VALUE_OPTION_CODE, L.CREATE_JE_FLAG, L.DAILY_TRANSLATION_RATE_TYPE, L.ENABLE_AVERAGE_BALANCES_FLAG, L.ENABLE_JE_APPROVAL_FLAG, L.ENABLE_RECONCILIATION_FLAG, L.ENABLE_SECONDARY_TRACK_FLAG, L.FUTURE_ENTERABLE_PERIODS_LIMIT, L.INTERCO_GAIN_LOSS_CCID, L.MGT_SEG_VALUE_OPTION_CODE, L.PERIOD_AVERAGE_RATE_TYPE, L.PERIOD_END_RATE_TYPE, L.SLA_BAL_BY_LEDGER_CURR_FLAG, L.SLA_LEDGER_CASH_BASIS_FLAG, L.SLA_SEQUENCING_FLAG, L.SUSPENSE_ALLOWED_FLAG, P.PERIOD_NAME, P.ADJUSTMENT_PERIOD_FLAG, P.CONFIRMATION_STATUS, P.END_DATE, P.ENTERED_PERIOD_NAME, P.PERIOD_NUM, P.PERIOD_YEAR, P.QUARTER_NUM, P.QUARTER_START_DATE, P.START_DATE, P.YEAR_START_DATE FROM GL_LEDGERS L, GL_PERIODS P WHERE L.PERIOD_SET_NAME = P.PERIOD_SET_NAME AND L.ACCOUNTED_PERIOD_TYPE = P.PERIOD_TYPE

SQL_Statement

SELECT L.LEDGER_ID,

L.NAME,

L.DESCRIPTION,

L.OBJECT_TYPE_CODE,

L.PERIOD_SET_NAME,

L.ACCOUNTED_PERIOD_TYPE,

L.CONFIGURATION_ID,

L.CURRENCY_CODE,

L.ALC_LEDGER_TYPE_CODE,

L.BAL_SEG_COLUMN_NAME,

L.BAL_SEG_VALUE_SET_ID,

L.CHART_OF_ACCOUNTS_ID,

L.COMPLETE_FLAG,

L.COMPLETION_STATUS_CODE,

L.FIRST_LEDGER_PERIOD_NAME,

L.IMPLICIT_ACCESS_SET_ID,

L.IMPLICIT_LEDGER_SET_ID,

L.LATEST_OPENED_PERIOD_NAME,

L.LE_LEDGER_TYPE_CODE,

L.LEDGER_CATEGORY_CODE,

L.MGT_SEG_COLUMN_NAME,

L.MGT_SEG_VALUE_SET_ID,

L.NET_INCOME_CODE_COMBINATION_ID,

L.RES_ENCUMB_CODE_COMBINATION_ID,

L.RET_EARN_CODE_COMBINATION_ID,

L.ROUNDING_CODE_COMBINATION_ID,

L.SHORT_NAME,

L.SLA_ACCOUNTING_METHOD_CODE,

L.SLA_ACCOUNTING_METHOD_TYPE,

L.SLA_DESCRIPTION_LANGUAGE,

L.SLA_ENTERED_CUR_BAL_SUS_CCID,

L.SLA_LEDGER_CUR_BAL_SUS_CCID,

L.TRANSACTION_CALENDAR_ID,

L.ALLOW_INTERCOMPANY_POST_FLAG,

L.BAL_SEG_VALUE_OPTION_CODE,

L.CREATE_JE_FLAG,

L.DAILY_TRANSLATION_RATE_TYPE,

L.ENABLE_AVERAGE_BALANCES_FLAG,

L.ENABLE_JE_APPROVAL_FLAG,

L.ENABLE_RECONCILIATION_FLAG,

L.ENABLE_SECONDARY_TRACK_FLAG,

L.FUTURE_ENTERABLE_PERIODS_LIMIT,

L.INTERCO_GAIN_LOSS_CCID,

L.MGT_SEG_VALUE_OPTION_CODE,

L.PERIOD_AVERAGE_RATE_TYPE,

L.PERIOD_END_RATE_TYPE,

L.SLA_BAL_BY_LEDGER_CURR_FLAG,

L.SLA_LEDGER_CASH_BASIS_FLAG,

L.SLA_SEQUENCING_FLAG,

L.SUSPENSE_ALLOWED_FLAG,

P.PERIOD_NAME,

P.ADJUSTMENT_PERIOD_FLAG,

P.CONFIRMATION_STATUS,

P.END_DATE,

P.ENTERED_PERIOD_NAME,

P.PERIOD_NUM,

P.PERIOD_YEAR,

P.QUARTER_NUM,

P.QUARTER_START_DATE,

P.START_DATE,

P.YEAR_START_DATE

FROM GL_LEDGERS L,

GL_PERIODS P

WHERE L.PERIOD_SET_NAME = P.PERIOD_SET_NAME

AND L.ACCOUNTED_PERIOD_TYPE = P.PERIOD_TYPE