VIEW: APPS.BIS_GL_COMPANIES_V

Source

View Text - Preformatted

SELECT fv.flex_value ID, fv.description VALUE, fm.structure_num chart_of_accounts_id, fv.flex_value flex_value, fv.description description, TO_CHAR(sob.set_of_books_id) set_of_books_id FROM gl_sets_of_books sob, bis_flex_mappings_v fm, fnd_flex_values_vl fv WHERE fm.structure_num = sob.chart_of_accounts_id AND fm.level_short_name = 'GL COMPANY' AND fm.application_id = 101 AND fm.id_flex_code = 'GL#' AND fv.flex_value_set_id = fm.value_set_id AND fv.enabled_flag = 'Y' AND fv.summary_flag = 'N' AND trunc(sysdate) between nvl(fv.start_date_active, trunc(sysdate)) and nvl(fv.end_date_active, trunc(sysdate))

View Text - HTML Formatted

SELECT FV.FLEX_VALUE ID
, FV.DESCRIPTION VALUE
, FM.STRUCTURE_NUM CHART_OF_ACCOUNTS_ID
, FV.FLEX_VALUE FLEX_VALUE
, FV.DESCRIPTION DESCRIPTION
, TO_CHAR(SOB.SET_OF_BOOKS_ID) SET_OF_BOOKS_ID
FROM GL_SETS_OF_BOOKS SOB
, BIS_FLEX_MAPPINGS_V FM
, FND_FLEX_VALUES_VL FV
WHERE FM.STRUCTURE_NUM = SOB.CHART_OF_ACCOUNTS_ID
AND FM.LEVEL_SHORT_NAME = 'GL COMPANY'
AND FM.APPLICATION_ID = 101
AND FM.ID_FLEX_CODE = 'GL#'
AND FV.FLEX_VALUE_SET_ID = FM.VALUE_SET_ID
AND FV.ENABLED_FLAG = 'Y'
AND FV.SUMMARY_FLAG = 'N'
AND TRUNC(SYSDATE) BETWEEN NVL(FV.START_DATE_ACTIVE
, TRUNC(SYSDATE))
AND NVL(FV.END_DATE_ACTIVE
, TRUNC(SYSDATE))