ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual US 35E2628E80D6D0E7E0630100007F0DC7 GL Calendar Y select gps.period_set_name value, gps.description from gl_period_sets gps order by gps.period_set_name US 8E2FF36EDEE379D2E0530100007F1FF2 GL Chart of Accounts Y select fifsv.id_flex_structure_name value, fifsv.id_flex_structure_code description from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))) order by fifsv.id_flex_structure_name AR مخطط حسابات جميع دفاتر الأستاذ التي يمكن الوصول إليها من خلال تعيين مجموعة الوصول إلى دفتر الأستاذ D Kontenplan aller Ledger, die über die Ledger-Zugriffs-Set-Zuordnung zugänglich sind E Plan de cuentas de todos los libros de contabilidad accesibles mediante la asignación de conjuntos de acceso a los libros de contabilidad F Plan comptable de tous les grands livres accessibles par affectation d'un ensemble d'accès aux grands livres I Piano dei conti di tutti i registri accessibili tramite l'assegnazione del set di accesso ai registri JA 元帳アクセスセットの割り当てでアクセス可能なすべての元帳の勘定科目一覧表 KO 원장 액세스 세트 할당으로 액세스 할 수있는 모든 원장의 계정과 목표 PTB Plano de contas de todos os ledgers acessíveis por atribuição de conjunto de acesso ao ledger RU План счетов всех бухгалтерских книг, доступных по назначению наборов доступа к бухгалтерским книгам S Kontoplan för alla reskontrar som är tillgängliga genom tilldelning av reservertillgång TR Defter erişim seti ataması ile erişilebilen tüm defterlerin hesap planı US Chart of accounts of all ledgers accessible by ledger access set assignment ZHS 通过分类账访问集分配可进入的所有分类账的账目表。 35E2628E80D7D0E7E0630100007F0DC7 GL Period Type Y select gpt.period_type id, gpt.user_period_type value, gpt.description from gl_period_types gpt order by gpt.user_period_type US 9C4B7E12D5A34F6C8B0E1A7F3D25C640Y select x.action_, x.status_, x.message_, x.modified_columns_, x.row_type, x.calendar, x.calendar_description, x.enable_security, x.period_prefix, x.period_type, x.period_year, x.quarter, x.period_num, x.start_date, x.end_date, x.period_name, x.adjustment_period, x.period_description, x.delete_period, x.periods_per_year, x.year_type_in_name, x.journal_source, x.journal_source_key, x.import_journal_references, x.require_journal_approval, x.import_using_key, x.freeze_journals, x.effective_date_rule, x.journal_category, x.journal_category_key, x.encumbrance_type, x.enabled, x.chart_of_accounts, x.account_segment_value, x.unit_of_measure, x.delete_stat_uom, x.description, x.period_type_context, x.period_type_attribute1, x.period_type_attribute2, x.period_type_attribute3, x.period_type_attribute4, x.period_type_attribute5, x.period_context, x.period_attribute1, x.period_attribute2, x.period_attribute3, x.period_attribute4, x.period_attribute5, x.period_attribute6, x.period_attribute7, x.period_attribute8, x.source_context, x.source_attribute1, x.source_attribute2, x.source_attribute3, x.source_attribute4, x.source_attribute5, x.category_context, x.category_attribute1, x.category_attribute2, x.category_attribute3, x.category_attribute4, x.category_attribute5, x.ledger_set, x.short_name, x.default_ledger, x.ledger, x.delete_assignment, x.data_access_set, x.access_set_type, x.all_segment_values, x.segment_value, x.retained_earnings_account, x.suspense_allowed, x.rounding_account, x.cta_account, x.reserve_encumbrance_account, x.net_income_account, x.enable_average_balances, x.translate_eod, x.translate_qatd, x.translate_yatd, x.enable_budgetary_control, x.require_budget_journals, x.enable_journal_approval, x.enable_automatic_tax, x.consolidation_ledger, x.future_enterable_periods, x.transaction_calendar, x.daily_rate_type, x.period_average_rate_type, x.period_end_rate_type, x.enable_reconciliation, x.net_closing_balance, x.criteria_set, x.reversal_method, x.reversal_period, x.reversal_date, x.autoreverse, x.autopost_reversal, x.autopost_set, x.submit_all_priorities, x.number_of_priorities, x.effective_days_before, x.effective_days_after, x.posting_priority, x.balance_type, x.delete_option, x.row_type_sort, row_number() over (order by x.row_type_sort, x.calendar, x.period_type, x.period_year, x.period_num, x.journal_source, x.journal_category, x.encumbrance_type, x.data_access_set, x.criteria_set, x.autopost_set, x.posting_priority, x.ledger, x.chart_of_accounts, x.account_segment_value) upload_row from ( select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'Period Type' row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, gpt.user_period_type period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, gpt.number_per_fiscal_year periods_per_year, decode(gpt.year_type_in_name,'C','Calendar','F','Fiscal') year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, gpt.description, xxen_util.display_flexfield_context(101,'GL_PERIOD_TYPES',gpt.context) period_type_context, xxen_util.display_flexfield_value(101,'GL_PERIOD_TYPES',gpt.context,'ATTRIBUTE1',gpt.rowid,gpt.attribute1) period_type_attribute1, xxen_util.display_flexfield_value(101,'GL_PERIOD_TYPES',gpt.context,'ATTRIBUTE2',gpt.rowid,gpt.attribute2) period_type_attribute2, xxen_util.display_flexfield_value(101,'GL_PERIOD_TYPES',gpt.context,'ATTRIBUTE3',gpt.rowid,gpt.attribute3) period_type_attribute3, xxen_util.display_flexfield_value(101,'GL_PERIOD_TYPES',gpt.context,'ATTRIBUTE4',gpt.rowid,gpt.attribute4) period_type_attribute4, xxen_util.display_flexfield_value(101,'GL_PERIOD_TYPES',gpt.context,'ATTRIBUTE5',gpt.rowid,gpt.attribute5) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 1 row_type_sort from gl_period_types gpt where 1=1 union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'Calendar Period' row_type, gps.period_set_name calendar, gps.description calendar_description, xxen_util.meaning(gps.security_flag,'YES_NO',0) enable_security, gp.entered_period_name period_prefix, gpt.user_period_type period_type, gp.period_year, gp.quarter_num quarter, gp.period_num, gp.start_date, gp.end_date, gp.period_name, xxen_util.meaning(gp.adjustment_period_flag,'YES_NO',0) adjustment_period, gp.description period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, to_char(null) description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, xxen_util.display_flexfield_context(101,'GL_PERIODS',gp.context) period_context, xxen_util.display_flexfield_value(101,'GL_PERIODS',gp.context,'ATTRIBUTE1',gp.rowid,gp.attribute1) period_attribute1, xxen_util.display_flexfield_value(101,'GL_PERIODS',gp.context,'ATTRIBUTE2',gp.rowid,gp.attribute2) period_attribute2, xxen_util.display_flexfield_value(101,'GL_PERIODS',gp.context,'ATTRIBUTE3',gp.rowid,gp.attribute3) period_attribute3, xxen_util.display_flexfield_value(101,'GL_PERIODS',gp.context,'ATTRIBUTE4',gp.rowid,gp.attribute4) period_attribute4, xxen_util.display_flexfield_value(101,'GL_PERIODS',gp.context,'ATTRIBUTE5',gp.rowid,gp.attribute5) period_attribute5, xxen_util.display_flexfield_value(101,'GL_PERIODS',gp.context,'ATTRIBUTE6',gp.rowid,gp.attribute6) period_attribute6, xxen_util.display_flexfield_value(101,'GL_PERIODS',gp.context,'ATTRIBUTE7',gp.rowid,gp.attribute7) period_attribute7, xxen_util.display_flexfield_value(101,'GL_PERIODS',gp.context,'ATTRIBUTE8',gp.rowid,gp.attribute8) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 2 row_type_sort from gl_period_sets gps, gl_periods gp, gl_period_types gpt where 2=2 and gps.period_set_name=gp.period_set_name and gp.period_type=gpt.period_type union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'Journal Source' row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, gjsv.user_je_source_name journal_source, gjsv.je_source_key journal_source_key, xxen_util.meaning(gjsv.journal_reference_flag,'YES_NO',0) import_journal_references, xxen_util.meaning(gjsv.journal_approval_flag,'YES_NO',0) require_journal_approval, xxen_util.meaning(gjsv.import_using_key_flag,'YES_NO',0) import_using_key, xxen_util.meaning(gjsv.override_edits_flag,'YES_NO',0) freeze_journals, decode(gjsv.effective_date_rule_code,'L','Leave Alone','R','Roll Date','F','Fail') effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, gjsv.description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, xxen_util.display_flexfield_context(101,'GL_JE_SOURCES',gjsv.context) source_context, xxen_util.display_flexfield_value(101,'GL_JE_SOURCES',gjsv.context,'ATTRIBUTE1',gjsv.row_id,gjsv.attribute1) source_attribute1, xxen_util.display_flexfield_value(101,'GL_JE_SOURCES',gjsv.context,'ATTRIBUTE2',gjsv.row_id,gjsv.attribute2) source_attribute2, xxen_util.display_flexfield_value(101,'GL_JE_SOURCES',gjsv.context,'ATTRIBUTE3',gjsv.row_id,gjsv.attribute3) source_attribute3, xxen_util.display_flexfield_value(101,'GL_JE_SOURCES',gjsv.context,'ATTRIBUTE4',gjsv.row_id,gjsv.attribute4) source_attribute4, xxen_util.display_flexfield_value(101,'GL_JE_SOURCES',gjsv.context,'ATTRIBUTE5',gjsv.row_id,gjsv.attribute5) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 3 row_type_sort from gl_je_sources_vl gjsv where 3=3 union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'Journal Category' row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, gjcv.user_je_category_name journal_category, gjcv.je_category_key journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, gjcv.description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, xxen_util.display_flexfield_context(101,'GL_JE_CATEGORIES',gjcv.context) category_context, xxen_util.display_flexfield_value(101,'GL_JE_CATEGORIES',gjcv.context,'ATTRIBUTE1',gjcv.row_id,gjcv.attribute1) category_attribute1, xxen_util.display_flexfield_value(101,'GL_JE_CATEGORIES',gjcv.context,'ATTRIBUTE2',gjcv.row_id,gjcv.attribute2) category_attribute2, xxen_util.display_flexfield_value(101,'GL_JE_CATEGORIES',gjcv.context,'ATTRIBUTE3',gjcv.row_id,gjcv.attribute3) category_attribute3, xxen_util.display_flexfield_value(101,'GL_JE_CATEGORIES',gjcv.context,'ATTRIBUTE4',gjcv.row_id,gjcv.attribute4) category_attribute4, xxen_util.display_flexfield_value(101,'GL_JE_CATEGORIES',gjcv.context,'ATTRIBUTE5',gjcv.row_id,gjcv.attribute5) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 4 row_type_sort from gl_je_categories_vl gjcv where 4=4 union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'Encumbrance Type' row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, get.encumbrance_type, xxen_util.meaning(get.enabled_flag,'YES_NO',0) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, get.description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 5 row_type_sort from gl_encumbrance_types get where 5=5 union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'Statistical Unit of Measure' row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, fifsv.id_flex_structure_name chart_of_accounts, gsau.account_segment_value, gsau.unit_of_measure, to_char(null) delete_stat_uom, to_char(null) description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 6 row_type_sort from gl_stat_account_uom gsau, fnd_id_flex_structures_vl fifsv where 6=6 and gsau.chart_of_accounts_id=fifsv.id_flex_num and fifsv.application_id=101 and fifsv.id_flex_code='GL#' union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'Ledger Set' row_type, gl.period_set_name calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, gpt.user_period_type period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, fifsv.id_flex_structure_name chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, gl.description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, gl.name ledger_set, gl.short_name, gld.name default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 7 row_type_sort from gl_ledgers gl, fnd_id_flex_structures_vl fifsv, gl_period_types gpt, gl_access_sets gas, gl_ledgers gld where gl.object_type_code='S' and fifsv.id_flex_num=gl.chart_of_accounts_id and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and gpt.period_type=gl.accounted_period_type and gas.name(+)=gl.name and gas.automatically_created_flag(+)='Y' and gld.ledger_id(+)=gas.default_ledger_id and 7=7 union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'Ledger Set Assignment' row_type, gls.period_set_name calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, gpt.user_period_type period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, fifsv.id_flex_structure_name chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, gl.description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, gls.name ledger_set, to_char(null) short_name, to_char(null) default_ledger, gl.name ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 8 row_type_sort from gl_ledger_set_norm_assign glsna, gl_ledgers gls, gl_ledgers gl, fnd_id_flex_structures_vl fifsv, gl_period_types gpt where glsna.ledger_set_id=gls.ledger_id and glsna.ledger_id=gl.ledger_id and gls.object_type_code='S' and nvl(glsna.status_code,'X')<>'D' and fifsv.id_flex_num=gls.chart_of_accounts_id and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and gpt.period_type=gls.accounted_period_type and 8=8 union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'Data Access Set' row_type, gas.period_set_name calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, gpt.user_period_type period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, xxen_util.meaning(gas.enabled_flag,'YES_NO',0) enabled, fifsv.id_flex_structure_name chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, gas.description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, gld.name default_ledger, to_char(null) ledger, to_char(null) delete_assignment, gas.name data_access_set, decode(gas.security_segment_code,'F','Full Ledger','B','Balancing Segment Value','M','Management Segment Value') access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 9 row_type_sort from gl_access_sets gas, fnd_id_flex_structures_vl fifsv, gl_period_types gpt, gl_ledgers gld where gas.automatically_created_flag='N' and fifsv.id_flex_num=gas.chart_of_accounts_id and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and gpt.period_type=gas.accounted_period_type and gld.ledger_id(+)=gas.default_ledger_id and 9=9 union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'Data Access Set Assignment' row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, fifsv.id_flex_structure_name chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, to_char(null) description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, gl.name ledger, to_char(null) delete_assignment, gas.name data_access_set, to_char(null) access_set_type, xxen_util.meaning(nvl(gasna.all_segment_value_flag,'N'),'YES_NO',0) all_segment_values, gasna.segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 10 row_type_sort from gl_access_set_norm_assign gasna, gl_access_sets gas, gl_ledgers gl, fnd_id_flex_structures_vl fifsv where gasna.access_set_id=gas.access_set_id and gasna.ledger_id=gl.ledger_id and gas.automatically_created_flag='N' and nvl(gasna.status_code,'X')<>'D' and fifsv.id_flex_num=gas.chart_of_accounts_id and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and 10=10 union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'Ledger' row_type, gl.period_set_name calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, gpt.user_period_type period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, fifsv.id_flex_structure_name chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, gl.description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, gl.short_name, to_char(null) default_ledger, gl.name ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, gcck_ret.concatenated_segments retained_earnings_account, xxen_util.meaning(gl.suspense_allowed_flag,'YES_NO',0) suspense_allowed, gcck_rnd.concatenated_segments rounding_account, gcck_cta.concatenated_segments cta_account, gcck_res.concatenated_segments reserve_encumbrance_account, gcck_ni.concatenated_segments net_income_account, xxen_util.meaning(gl.enable_average_balances_flag,'YES_NO',0) enable_average_balances, xxen_util.meaning(gl.translate_eod_flag,'YES_NO',0) translate_eod, xxen_util.meaning(gl.translate_qatd_flag,'YES_NO',0) translate_qatd, xxen_util.meaning(gl.translate_yatd_flag,'YES_NO',0) translate_yatd, xxen_util.meaning(gl.enable_budgetary_control_flag,'YES_NO',0) enable_budgetary_control, xxen_util.meaning(gl.require_budget_journals_flag,'YES_NO',0) require_budget_journals, xxen_util.meaning(gl.enable_je_approval_flag,'YES_NO',0) enable_journal_approval, xxen_util.meaning(gl.enable_automatic_tax_flag,'YES_NO',0) enable_automatic_tax, xxen_util.meaning(gl.consolidation_ledger_flag,'YES_NO',0) consolidation_ledger, gl.future_enterable_periods_limit future_enterable_periods, gtc.name transaction_calendar, gl.daily_translation_rate_type daily_rate_type, gl.period_average_rate_type, gl.period_end_rate_type, xxen_util.meaning(gl.enable_reconciliation_flag,'YES_NO',0) enable_reconciliation, xxen_util.meaning(gl.net_closing_bal_flag,'YES_NO',0) net_closing_balance, gacs.criteria_set_name criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 11 row_type_sort from gl_ledgers gl, fnd_id_flex_structures_vl fifsv, gl_period_types gpt, gl_code_combinations_kfv gcck_ret, gl_code_combinations_kfv gcck_rnd, gl_code_combinations_kfv gcck_cta, gl_code_combinations_kfv gcck_res, gl_code_combinations_kfv gcck_ni, gl_transaction_calendar gtc, gl_autorev_criteria_sets gacs where gl.object_type_code='L' and fifsv.id_flex_num=gl.chart_of_accounts_id and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and gpt.period_type=gl.accounted_period_type and gcck_ret.code_combination_id(+)=gl.ret_earn_code_combination_id and gcck_rnd.code_combination_id(+)=gl.rounding_code_combination_id and gcck_cta.code_combination_id(+)=gl.cum_trans_code_combination_id and gcck_res.code_combination_id(+)=gl.res_encumb_code_combination_id and gcck_ni.code_combination_id(+)=gl.net_income_code_combination_id and gtc.transaction_calendar_id(+)=gl.transaction_calendar_id and gacs.criteria_set_id(+)=gl.criteria_set_id and 11=11 union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'AutoReverse Criteria Set' row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, gacs.criteria_set_desc description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, gacs.criteria_set_name criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 12 row_type_sort from gl_autorev_criteria_sets gacs where 12=12 union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'AutoReverse Option' row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, gjcv.user_je_category_name journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, to_char(null) description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, gacs.criteria_set_name criteria_set, xxen_util.meaning(gao.method_code,'REVERSAL_OPTION_CODE',101) reversal_method, decode(gao.reversal_period_code,'NO_DEFAULT','No Default','SAME_PERIOD','Same Period','NEXT_PERIOD','Next Period','NEXT_NON_ADJ_PERIOD','Next Non Adjusting Period') reversal_period, xxen_util.meaning(gao.reversal_date_code,'AUTOREVERSE_DATE_RULE',0) reversal_date, xxen_util.meaning(gao.autoreverse_flag,'YES_NO',0) autoreverse, xxen_util.meaning(gao.autopost_reversal_flag,'YES_NO',0) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 13 row_type_sort from gl_autoreverse_options gao, gl_autorev_criteria_sets gacs, gl_je_categories_vl gjcv where gao.criteria_set_id=gacs.criteria_set_id and gao.je_category_name=gjcv.je_category_name and 13=13 union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'AutoPost Set' row_type, gaps.period_set_name calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, gpt.user_period_type period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, xxen_util.meaning(gaps.enabled_flag,'YES_NO',0) enabled, fifsv.id_flex_structure_name chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, gaps.description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, gaps.autopost_set_name autopost_set, xxen_util.meaning(gaps.submit_all_priorities_flag,'YES_NO',0) submit_all_priorities, gaps.num_of_priority_options number_of_priorities, gaps.effective_days_before, gaps.effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 14 row_type_sort from gl_automatic_posting_sets gaps, fnd_id_flex_structures_vl fifsv, gl_period_types gpt where fifsv.id_flex_num=gaps.chart_of_accounts_id and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and gpt.period_type=gaps.accounted_period_type and 14=14 union all select to_char(null) action_, to_char(null) status_, to_char(null) message_, to_char(null) modified_columns_, 'AutoPost Option' row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, gapo.period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, decode(gapo.je_source_name,'ALL','ALL',gjsv.user_je_source_name) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, decode(gapo.je_category_name,'ALL','ALL',gjcv.user_je_category_name) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, to_char(null) description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, decode(gapo.ledger_id,-1234567890,'ALL',gl.name) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, gaps.autopost_set_name autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, gapo.posting_priority, (select flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='BATCH_TYPE_ALL' and flvv.security_group_id=0 and flvv.lookup_code=gapo.actual_flag) balance_type, to_char(null) delete_option, 15 row_type_sort from gl_automatic_posting_options gapo, gl_automatic_posting_sets gaps, gl_ledgers gl, gl_je_sources_vl gjsv, gl_je_categories_vl gjcv where gapo.autopost_set_id=gaps.autopost_set_id and gl.ledger_id(+)=gapo.ledger_id and gjsv.je_source_name(+)=gapo.je_source_name and gjcv.je_category_name(+)=gapo.je_category_name and 15=15 ) x Added one template per row type so that a download only shows the columns of the entity being loaded, with the row type fixed and the parameters that do not apply to it excluded. U A xxen_gl_upload.upload_gl_setup xxen_gl_upload.validate_gl_setup_excel_row (p_row_type=>:$column$.row_type ,p_calendar=>:$column$.calendar ,p_period_type=>:$column$.period_type ,p_period_year=>:$column$.period_year ,p_quarter=>:$column$.quarter ,p_period_num=>:$column$.period_num ,p_start_date=>:$column$.start_date ,p_end_date=>:$column$.end_date ,p_period_name=>:$column$.period_name ,p_period_prefix=>:$column$.period_prefix ,p_delete_period=>:$column$.delete_period ,p_journal_source=>:$column$.journal_source ,p_journal_category=>:$column$.journal_category ,p_encumbrance_type=>:$column$.encumbrance_type ,p_chart_of_accounts=>:$column$.chart_of_accounts ,p_account_segment_value=>:$column$.account_segment_value ,p_unit_of_measure=>:$column$.unit_of_measure ,p_delete_stat_uom=>:$column$.delete_stat_uom ,p_periods_per_year=>:$column$.periods_per_year ,p_year_type_in_name=>:$column$.year_type_in_name ) US GL Setup Upload Create and update the General Ledger setup entities that the GL Setup menu maintains, replicating the Calendars (GLXSTCAL), Period Types (GLXSTPTY), Journal Sources (GLXSTSRC), Journal Categories (GLXSTCAT), Encumbrance Types (GLXSTENC) and Statistical Units of Measure (GLXSTUOM) forms. Each row is one of six entity types, chosen in the Row Type column. Only the columns belonging to that entity are read; all other columns are ignored. - Period Type: creates or updates a period type. Periods Per Year and Year Type In Name are required to create one and cannot be changed afterwards. - Calendar Period: creates or updates one period of a calendar. The calendar itself is created together with its first period, so a new calendar name can be entered. Enter either a Period Name or a Period Prefix; a prefix is expanded to prefix-YY. Periods that have already been used can only have their description and flexfield changed. Set Delete Period to Yes to remove an unused period. - Journal Source: creates or updates a journal source, including Import Journal References, Require Journal Approval, Import Using Key, Freeze Journals and the Effective Date Rule. - Journal Category: creates or updates a journal category. Creating one also seeds its document sequence category and its autoreverse options for every ledger. - Encumbrance Type: creates or updates an encumbrance type and its Enabled flag. - Statistical Unit of Measure: assigns a unit of measure to a natural account segment value of a chart of accounts. Set Delete Stat UOM to Yes to remove the assignment. An entity is created when it does not yet exist and updated otherwise; the Upload Mode parameter only decides whether existing records are downloaded for review. Rows that change nothing report No change and are not written. Only Calendar Periods and Statistical Units of Measure can be deleted. Period types, journal sources, journal categories and encumbrance types are never deleted; disable an encumbrance type instead of removing it. After a Calendar Period upload the calendar is checked for gaps and overlaps between its periods, which are reported as a warning. Run the Calendar Validation Report for full details. Enginatics Upload 10=10 11=11 12=12 13=13 14=14 15=15 1=1 2=2 3=3 4=4 5=5 6=6 7=7 8=8 9=9 1 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C,U Y US Upload Mode 2 10=10 :p_upload_mode like '%' || xxen_upload.action_update US Upload Mode 3 11=11 :p_upload_mode like '%' || xxen_upload.action_update US Upload Mode 4 12=12 :p_upload_mode like '%' || xxen_upload.action_update US Upload Mode 5 13=13 :p_upload_mode like '%' || xxen_upload.action_update US Upload Mode 6 14=14 :p_upload_mode like '%' || xxen_upload.action_update US Upload Mode 7 15=15 :p_upload_mode like '%' || xxen_upload.action_update US Upload Mode 8 2=2 :p_upload_mode like '%' || xxen_upload.action_update US Upload Mode 9 3=3 :p_upload_mode like '%' || xxen_upload.action_update US Upload Mode 10 4=4 :p_upload_mode like '%' || xxen_upload.action_update US Upload Mode 11 5=5 :p_upload_mode like '%' || xxen_upload.action_update US Upload Mode 12 6=6 :p_upload_mode like '%' || xxen_upload.action_update US Upload Mode 13 7=7 :p_upload_mode like '%' || xxen_upload.action_update US Upload Mode 14 8=8 :p_upload_mode like '%' || xxen_upload.action_update US Upload Mode 15 9=9 :p_upload_mode like '%' || xxen_upload.action_update US Upload Mode 16 20 1=1 'Period Type'=:row_type LOV custom Y select 'Period Type' value, null description from dual union all select 'Calendar Period' value, null description from dual union all select 'Journal Source' value, null description from dual union all select 'Journal Category' value, null description from dual union all select 'Encumbrance Type' value, null description from dual union all select 'Statistical Unit of Measure' value, null description from dual union all select 'Ledger Set' value, null description from dual union all select 'Ledger Set Assignment' value, null description from dual union all select 'Data Access Set' value, null description from dual union all select 'Data Access Set Assignment' value, null description from dual union all select 'Ledger' value, null description from dual union all select 'AutoReverse Criteria Set' value, null description from dual union all select 'AutoReverse Option' value, null description from dual union all select 'AutoPost Set' value, null description from dual union all select 'AutoPost Option' value, null description from dual US Row Type 17 10=10 'Data Access Set Assignment'=:row_type US Row Type 18 11=11 'Ledger'=:row_type US Row Type 19 12=12 'AutoReverse Criteria Set'=:row_type US Row Type 20 13=13 'AutoReverse Option'=:row_type US Row Type 21 14=14 'AutoPost Set'=:row_type US Row Type 22 15=15 'AutoPost Option'=:row_type US Row Type 23 2=2 'Calendar Period'=:row_type US Row Type 24 3=3 'Journal Source'=:row_type US Row Type 25 4=4 'Journal Category'=:row_type US Row Type 26 5=5 'Encumbrance Type'=:row_type US Row Type 27 6=6 'Statistical Unit of Measure'=:row_type US Row Type 28 7=7 'Ledger Set'=:row_type US Row Type 29 8=8 'Ledger Set Assignment'=:row_type US Row Type 30 9=9 'Data Access Set'=:row_type US Row Type 31 30 2=2 gps.period_set_name=:calendar LOV GL Calendar 35E2628E80D6D0E7E0630100007F0DC7 Y select gps.period_set_name value, gps.description from gl_period_sets gps order by gps.period_set_name US Calendar 32 40 1=1 gpt.period_type=:period_type LOV GL Period Type 35E2628E80D7D0E7E0630100007F0DC7 Y select gpt.period_type id, gpt.user_period_type value, gpt.description from gl_period_types gpt order by gpt.user_period_type US Period Type 33 2=2 gpt.period_type=:period_type US Period Type 34 50 6=6 fifsv.id_flex_structure_name=:chart_of_accounts LOV GL Chart of Accounts 8E2FF36EDEE379D2E0530100007F1FF2 Y select fifsv.id_flex_structure_name value, fifsv.id_flex_structure_code description from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))) order by fifsv.id_flex_structure_name US Chart of Accounts 35 10=10 fifsv.id_flex_structure_name=:chart_of_accounts US Chart of Accounts 36 11=11 fifsv.id_flex_structure_name=:chart_of_accounts US Chart of Accounts 37 14=14 fifsv.id_flex_structure_name=:chart_of_accounts US Chart of Accounts 38 7=7 fifsv.id_flex_structure_name=:chart_of_accounts US Chart of Accounts 39 8=8 fifsv.id_flex_structure_name=:chart_of_accounts US Chart of Accounts 40 9=9 fifsv.id_flex_structure_name=:chart_of_accounts US Chart of Accounts 35786D16D9D545CCBEF165E59F791B88 AutoPost Option The posting priorities of an AutoPost set: ledger, balance type, period, journal source and journal category. SYSADMIN 2 AUTOPOST_SET 5 BALANCE_TYPE 9 DELETE_OPTION 8 JOURNAL_CATEGORY 7 JOURNAL_SOURCE 4 LEDGER 6 PERIOD_NAME 3 POSTING_PRIORITY 1 ROW_TYPE Y AutoPost Option Row Type AutoPost Option S Site Calendar Chart of Accounts Period Type E973A5CE31EC4106AB299353091F5712 AutoPost Set AutoPost sets: priorities, effective days before and after, and whether all priorities are submitted. SYSADMIN 2 AUTOPOST_SET 5 CALENDAR 4 CHART_OF_ACCOUNTS 12 DELETE_OPTION 3 DESCRIPTION 11 EFFECTIVE_DAYS_AFTER 10 EFFECTIVE_DAYS_BEFORE 7 ENABLED 9 NUMBER_OF_PRIORITIES 6 PERIOD_TYPE 1 ROW_TYPE Y AutoPost Set 8 SUBMIT_ALL_PRIORITIES Row Type AutoPost Set S Site Calendar Period Type 14F1DB63168146B4A2EC22200ABA8BF7 AutoReverse Criteria Set Journal reversal criteria sets. Creating one adds a reversal option for every journal category. SYSADMIN 2 CRITERIA_SET 3 DESCRIPTION 1 ROW_TYPE Y AutoReverse Criteria Set Row Type AutoReverse Criteria Set S Site Calendar Chart of Accounts Period Type 3FFF3CC7759145F4868A946AE6EE73E1 AutoReverse Option The reversal option of each journal category in a criteria set: method, period, date, autoreverse and autopost reversal. SYSADMIN 8 AUTOPOST_REVERSAL 7 AUTOREVERSE 2 CRITERIA_SET 3 JOURNAL_CATEGORY 6 REVERSAL_DATE 4 REVERSAL_METHOD 5 REVERSAL_PERIOD 1 ROW_TYPE Y AutoReverse Option Row Type AutoReverse Option S Site Calendar Chart of Accounts Period Type 7D93B786282A40C6BF531D93A6D9C8F5 Calendar Period Accounting calendar periods: year, quarter, period number, start and end dates, adjusting periods and the period descriptive flexfield. SYSADMIN 13 ADJUSTMENT_PERIOD 2 CALENDAR 3 CALENDAR_DESCRIPTION 15 DELETE_PERIOD 4 ENABLE_SECURITY 12 END_DATE 17 PERIOD_ATTRIBUTE1 18 PERIOD_ATTRIBUTE2 19 PERIOD_ATTRIBUTE3 20 PERIOD_ATTRIBUTE4 21 PERIOD_ATTRIBUTE5 22 PERIOD_ATTRIBUTE6 23 PERIOD_ATTRIBUTE7 24 PERIOD_ATTRIBUTE8 16 PERIOD_CONTEXT 14 PERIOD_DESCRIPTION 10 PERIOD_NAME 9 PERIOD_NUM 5 PERIOD_PREFIX 6 PERIOD_TYPE 7 PERIOD_YEAR 8 QUARTER 1 ROW_TYPE Y Calendar Period 11 START_DATE Row Type Calendar Period S Site Chart of Accounts E52ADB0559774B528145039498202CE8 Data Access Set Data access sets: full ledger, balancing or management segment security, chart of accounts, calendar, period type and default ledger. SYSADMIN 3 ACCESS_SET_TYPE 6 CALENDAR 5 CHART_OF_ACCOUNTS 2 DATA_ACCESS_SET 8 DEFAULT_LEDGER 4 DESCRIPTION 9 ENABLED 7 PERIOD_TYPE 1 ROW_TYPE Y Data Access Set Row Type Data Access Set S Site Calendar Period Type CA544C462C1A4CB8975A78DB0A5F963C Data Access Set Assignment The ledgers a data access set grants, with all segment values or a single segment value. SYSADMIN 4 ALL_SEGMENT_VALUES 7 CHART_OF_ACCOUNTS 2 DATA_ACCESS_SET 6 DELETE_ASSIGNMENT 3 LEDGER 1 ROW_TYPE Y Data Access Set Assignment 5 SEGMENT_VALUE Row Type Data Access Set Assignment S Site Calendar Period Type 53116BAA5D794E8199E48C920D93F949 Encumbrance Type Encumbrance types and whether they are enabled. SYSADMIN 3 DESCRIPTION 4 ENABLED 2 ENCUMBRANCE_TYPE 1 ROW_TYPE Y Encumbrance Type Row Type Encumbrance Type S Site Calendar Chart of Accounts Period Type 4AE60CE5D1314E7A97377F38A5490039 Journal Category Journal categories: category key, description and the category descriptive flexfield. SYSADMIN 6 CATEGORY_ATTRIBUTE1 7 CATEGORY_ATTRIBUTE2 8 CATEGORY_ATTRIBUTE3 9 CATEGORY_ATTRIBUTE4 10 CATEGORY_ATTRIBUTE5 5 CATEGORY_CONTEXT 4 DESCRIPTION 2 JOURNAL_CATEGORY 3 JOURNAL_CATEGORY_KEY 1 ROW_TYPE Y Journal Category Row Type Journal Category S Site Calendar Chart of Accounts Period Type AE938450A739418DA0DFC677411B654E Journal Source Journal sources: import references, journal approval, import using key, freeze journals, effective date rule and the source descriptive flexfield. SYSADMIN 4 DESCRIPTION 9 EFFECTIVE_DATE_RULE 8 FREEZE_JOURNALS 5 IMPORT_JOURNAL_REFERENCES 7 IMPORT_USING_KEY 2 JOURNAL_SOURCE 3 JOURNAL_SOURCE_KEY 6 REQUIRE_JOURNAL_APPROVAL 1 ROW_TYPE Y Journal Source 11 SOURCE_ATTRIBUTE1 12 SOURCE_ATTRIBUTE2 13 SOURCE_ATTRIBUTE3 14 SOURCE_ATTRIBUTE4 15 SOURCE_ATTRIBUTE5 10 SOURCE_CONTEXT Row Type Journal Source S Site Calendar Chart of Accounts Period Type 8CA85321D3DC4BEC96F71092A64155B4 Ledger Ledger options: accounts, average balances, budgetary control, journal approval, rate types, reconciliation and reversal criteria set. Ledgers are created in the Accounting Setup Manager. SYSADMIN 6 CALENDAR 5 CHART_OF_ACCOUNTS 22 CONSOLIDATION_LEDGER 30 CRITERIA_SET 11 CTA_ACCOUNT 25 DAILY_RATE_TYPE 4 DESCRIPTION 21 ENABLE_AUTOMATIC_TAX 14 ENABLE_AVERAGE_BALANCES 18 ENABLE_BUDGETARY_CONTROL 20 ENABLE_JOURNAL_APPROVAL 28 ENABLE_RECONCILIATION 23 FUTURE_ENTERABLE_PERIODS 2 LEDGER 29 NET_CLOSING_BALANCE 13 NET_INCOME_ACCOUNT 26 PERIOD_AVERAGE_RATE_TYPE 27 PERIOD_END_RATE_TYPE 7 PERIOD_TYPE 19 REQUIRE_BUDGET_JOURNALS 12 RESERVE_ENCUMBRANCE_ACCOUNT 8 RETAINED_EARNINGS_ACCOUNT 10 ROUNDING_ACCOUNT 1 ROW_TYPE Y Ledger 3 SHORT_NAME 9 SUSPENSE_ALLOWED 24 TRANSACTION_CALENDAR 15 TRANSLATE_EOD 16 TRANSLATE_QATD 17 TRANSLATE_YATD Row Type Ledger S Site Calendar Period Type 2D1788089EBC4BC0BE9547ED8E83E26F Ledger Set Ledger sets: short name, chart of accounts, calendar, period type and default ledger. SYSADMIN 6 CALENDAR 5 CHART_OF_ACCOUNTS 8 DEFAULT_LEDGER 4 DESCRIPTION 2 LEDGER_SET 7 PERIOD_TYPE 1 ROW_TYPE Y Ledger Set 3 SHORT_NAME Row Type Ledger Set S Site Calendar Period Type 01FD0B87C48344F49655D8B7B4083100 Ledger Set Assignment The ledgers and ledger sets that make up a ledger set. SYSADMIN 6 CALENDAR 5 CHART_OF_ACCOUNTS 4 DELETE_ASSIGNMENT 8 DESCRIPTION 3 LEDGER 2 LEDGER_SET 7 PERIOD_TYPE 1 ROW_TYPE Y Ledger Set Assignment Row Type Ledger Set Assignment S Site Calendar Period Type 91462F23E6F74E7D88AC2EBCD6F114E4 Period Type Accounting period types: periods per year, whether the year is in the period name, and the period type descriptive flexfield. SYSADMIN 5 DESCRIPTION 3 PERIODS_PER_YEAR 2 PERIOD_TYPE 7 PERIOD_TYPE_ATTRIBUTE1 8 PERIOD_TYPE_ATTRIBUTE2 9 PERIOD_TYPE_ATTRIBUTE3 10 PERIOD_TYPE_ATTRIBUTE4 11 PERIOD_TYPE_ATTRIBUTE5 6 PERIOD_TYPE_CONTEXT 1 ROW_TYPE Y Period Type 4 YEAR_TYPE_IN_NAME Row Type Period Type S Site Calendar Chart of Accounts D1035323AA5549E18FF0575B3474456F Statistical Unit of Measure The statistical unit of measure held against an account segment value. SYSADMIN 3 ACCOUNT_SEGMENT_VALUE 2 CHART_OF_ACCOUNTS 5 DELETE_STAT_UOM 1 ROW_TYPE Y Statistical Unit of Measure 4 UNIT_OF_MEASURE Row Type Statistical Unit of Measure S Site Calendar Period Type 7D93B786282A40C6BF531D93A6D9C8F5 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 ROW_TYPE LOV custom varchar2 30 Y select 'Period Type' value, null description from dual union all select 'Calendar Period' value, null description from dual union all select 'Journal Source' value, null description from dual union all select 'Journal Category' value, null description from dual union all select 'Encumbrance Type' value, null description from dual union all select 'Statistical Unit of Measure' value, null description from dual union all select 'Ledger Set' value, null description from dual union all select 'Ledger Set Assignment' value, null description from dual union all select 'Data Access Set' value, null description from dual union all select 'Data Access Set Assignment' value, null description from dual union all select 'Ledger' value, null description from dual union all select 'AutoReverse Criteria Set' value, null description from dual union all select 'AutoReverse Option' value, null description from dual union all select 'AutoPost Set' value, null description from dual union all select 'AutoPost Option' value, null description from dual :$flex$.Row_Type The entity this row maintains. Every row is exactly one Period Type, Calendar Period, Journal Source, Journal Category, Encumbrance Type or Statistical Unit of Measure. Only the columns of the selected entity are used. Y 6 CALENDAR LOV custom varchar2 15 select gps.period_set_name value, gps.description from gl_period_sets gps order by gps.period_set_name :$flex$.Calendar Calendar Period rows. The calendar is created together with its first period, so a new calendar name can be entered here. 7 CALENDAR_DESCRIPTION Char varchar2 240 Calendar Period rows. Description of the calendar, not of the individual period. 8 ENABLE_SECURITY LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description select xxen_util.meaning('N','YES_NO',0) from dual where :$column$.row_type='Calendar Period' Calendar Period rows. Enables period based security on the calendar. 9 PERIOD_PREFIX Char varchar2 15 Calendar Period rows. Up to 12 characters, no spaces or quotes. When Period Name is left empty the period name is built as prefix-YY, taking the two digit year from the start date for calendar year types and from the period year for fiscal year types. 10 PERIOD_TYPE LOV custom varchar2 15 select gpt.user_period_type value, gpt.description from gl_period_types gpt order by gpt.user_period_type select gpt.user_period_type from gl_period_types gpt where gpt.period_type=:$flex$.Period_Type Period Type and Calendar Period rows. A Calendar Period row requires an existing period type; a Period Type row creates it. 11 PERIOD_YEAR Number number Calendar Period rows. 12 QUARTER Number number Calendar Period rows. 1 to 4. 13 PERIOD_NUM Number number Calendar Period rows. Cannot be greater than the periods per year of the period type. 14 START_DATE Date date Calendar Period rows. 15 END_DATE Date date Calendar Period rows. 16 PERIOD_NAME Char varchar2 15 Calendar Period rows. Either Period Name or Period Prefix is required. No spaces or quotes. 17 ADJUSTMENT_PERIOD LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description select xxen_util.meaning('N','YES_NO',0) from dual where :$column$.row_type='Calendar Period' Calendar Period rows. Adjusting periods are exempt from the period date overlap check. 18 PERIOD_DESCRIPTION Char varchar2 240 Calendar Period rows. 19 DELETE_PERIOD LOV custom varchar2 Y select xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$column$.calendar is not null and :$column$.period_name is not null Calendar Period rows. Deletes the period identified by Calendar and Period Name. Only periods that have never been used can be deleted. 20 PERIODS_PER_YEAR Number number Period Type rows. Required to create a period type and cannot be changed afterwards. 21 YEAR_TYPE_IN_NAME LOV custom varchar2 Y select 'C' id, 'Calendar' value, null description from dual union all select 'F' id, 'Fiscal' value, null description from dual select 'Calendar' from dual where :$column$.row_type='Period Type' Period Type rows. Decides whether the two digit year appended to a period prefix is taken from the period start date (Calendar) or from the period year (Fiscal). Cannot be changed on an existing period type. 22 JOURNAL_SOURCE Char varchar2 25 Journal Source rows. 23 JOURNAL_SOURCE_KEY Char varchar2 25 Journal Source rows. Defaults to the journal source name when a new source is created. 24 IMPORT_JOURNAL_REFERENCES LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description select xxen_util.meaning('Y','YES_NO',0) from dual where :$column$.row_type='Journal Source' Journal Source rows. 25 REQUIRE_JOURNAL_APPROVAL LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description select xxen_util.meaning('N','YES_NO',0) from dual where :$column$.row_type='Journal Source' Journal Source rows. 26 IMPORT_USING_KEY LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description select xxen_util.meaning('N','YES_NO',0) from dual where :$column$.row_type='Journal Source' Journal Source rows. 27 FREEZE_JOURNALS LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description select xxen_util.meaning('N','YES_NO',0) from dual where :$column$.row_type='Journal Source' Journal Source rows. 28 EFFECTIVE_DATE_RULE LOV custom varchar2 Y select 'L' id, 'Leave Alone' value, null description from dual union all select 'R' id, 'Roll Date' value, null description from dual union all select 'F' id, 'Fail' value, null description from dual select 'Roll Date' from dual where :$column$.row_type='Journal Source' Journal Source rows. Decides how journal import treats an effective date that is not in an open or future enterable period. 29 JOURNAL_CATEGORY Char varchar2 25 Journal Category rows. 30 JOURNAL_CATEGORY_KEY Char varchar2 25 Journal Category rows. Defaults to the journal category name when a new category is created. 31 ENCUMBRANCE_TYPE Char varchar2 30 Encumbrance Type rows. 32 ENABLED LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description select xxen_util.meaning('Y','YES_NO',0) from dual where :$column$.row_type='Encumbrance Type' Encumbrance Type rows. 33 CHART_OF_ACCOUNTS LOV varchar2 30 GL Chart of Accounts 8E2FF36EDEE379D2E0530100007F1FF2 Y select fifsv.id_flex_structure_name value, fifsv.id_flex_structure_code description from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))) order by fifsv.id_flex_structure_name :$flex$.Chart_of_Accounts Statistical Unit of Measure rows. 34 ACCOUNT_SEGMENT_VALUE LOV custom varchar2 25 Y select ffvv.flex_value value, ffvv.description from fnd_id_flex_structures_vl fifsv, fnd_segment_attribute_values fsav, fnd_id_flex_segments fifs, fnd_flex_values_vl ffvv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_structure_name=:$column$.chart_of_accounts and fsav.application_id=101 and fsav.id_flex_code='GL#' and fsav.id_flex_num=fifsv.id_flex_num and fsav.segment_attribute_type='GL_ACCOUNT' and fsav.attribute_value='Y' and fifs.application_id=101 and fifs.id_flex_code='GL#' and fifs.id_flex_num=fifsv.id_flex_num and fifs.application_column_name=fsav.application_column_name and ffvv.flex_value_set_id=fifs.flex_value_set_id and ffvv.enabled_flag='Y' order by ffvv.flex_value Statistical Unit of Measure rows. The natural account segment values of the chart of accounts, resolved through the GL Account flexfield qualifier. 35 UNIT_OF_MEASURE Char varchar2 25 Statistical Unit of Measure rows. Free text, as in the Statistical Units of Measure form. 36 DELETE_STAT_UOM LOV custom varchar2 Y select xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$column$.chart_of_accounts is not null and :$column$.account_segment_value is not null Statistical Unit of Measure rows. Deletes the statistical unit of measure of the account segment value. 37 DESCRIPTION Char varchar2 240 Period Type, Journal Source, Journal Category and Encumbrance Type rows. Calendar Period rows use Calendar Description and Period Description instead. 38 PERIOD_TYPE_CONTEXT LOV custom varchar2 Y select fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=101 and fdfcv.descriptive_flexfield_name='GL_PERIOD_TYPES' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' and fdfcv.enabled_flag='Y' order by fdfcv.descriptive_flex_context_name Period Type rows. Descriptive flexfield context. 39 PERIOD_TYPE_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>101, p_descriptive_flexfield_name=>'GL_PERIOD_TYPES', p_context_name=>:$column$.period_type_context, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.period_type_attribute1, p_attribute2=>:$column$.period_type_attribute2, p_attribute3=>:$column$.period_type_attribute3, p_attribute4=>:$column$.period_type_attribute4, p_attribute5=>:$column$.period_type_attribute5)) lov order by value select 'Period Type rows.'||chr(10)||listagg(x.prompt,chr(10)) within group (order by x.descriptive_flex_context_code) from ( select distinct fdfcuv.descriptive_flex_context_code, decode(fdfcuv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcuv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv where fdfcuv.application_id=101 and fdfcuv.descriptive_flexfield_name='GL_PERIOD_TYPES' and fdfcuv.application_column_name='ATTRIBUTE1' and fdfcuv.enabled_flag='Y' ) x 40 PERIOD_TYPE_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>101, p_descriptive_flexfield_name=>'GL_PERIOD_TYPES', p_context_name=>:$column$.period_type_context, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.period_type_attribute1, p_attribute2=>:$column$.period_type_attribute2, p_attribute3=>:$column$.period_type_attribute3, p_attribute4=>:$column$.period_type_attribute4, p_attribute5=>:$column$.period_type_attribute5)) lov order by value select 'Period Type rows.'||chr(10)||listagg(x.prompt,chr(10)) within group (order by x.descriptive_flex_context_code) from ( select distinct fdfcuv.descriptive_flex_context_code, decode(fdfcuv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcuv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv where fdfcuv.application_id=101 and fdfcuv.descriptive_flexfield_name='GL_PERIOD_TYPES' and fdfcuv.application_column_name='ATTRIBUTE2' and fdfcuv.enabled_flag='Y' ) x 41 PERIOD_TYPE_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>101, p_descriptive_flexfield_name=>'GL_PERIOD_TYPES', p_context_name=>:$column$.period_type_context, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.period_type_attribute1, p_attribute2=>:$column$.period_type_attribute2, p_attribute3=>:$column$.period_type_attribute3, p_attribute4=>:$column$.period_type_attribute4, p_attribute5=>:$column$.period_type_attribute5)) lov order by value select 'Period Type rows.'||chr(10)||listagg(x.prompt,chr(10)) within group (order by x.descriptive_flex_context_code) from ( select distinct fdfcuv.descriptive_flex_context_code, decode(fdfcuv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcuv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv where fdfcuv.application_id=101 and fdfcuv.descriptive_flexfield_name='GL_PERIOD_TYPES' and fdfcuv.application_column_name='ATTRIBUTE3' and fdfcuv.enabled_flag='Y' ) x 42 PERIOD_TYPE_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>101, p_descriptive_flexfield_name=>'GL_PERIOD_TYPES', p_context_name=>:$column$.period_type_context, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.period_type_attribute1, p_attribute2=>:$column$.period_type_attribute2, p_attribute3=>:$column$.period_type_attribute3, p_attribute4=>:$column$.period_type_attribute4, p_attribute5=>:$column$.period_type_attribute5)) lov order by value select 'Period Type rows.'||chr(10)||listagg(x.prompt,chr(10)) within group (order by x.descriptive_flex_context_code) from ( select distinct fdfcuv.descriptive_flex_context_code, decode(fdfcuv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcuv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv where fdfcuv.application_id=101 and fdfcuv.descriptive_flexfield_name='GL_PERIOD_TYPES' and fdfcuv.application_column_name='ATTRIBUTE4' and fdfcuv.enabled_flag='Y' ) x 43 PERIOD_TYPE_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>101, p_descriptive_flexfield_name=>'GL_PERIOD_TYPES', p_context_name=>:$column$.period_type_context, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.period_type_attribute1, p_attribute2=>:$column$.period_type_attribute2, p_attribute3=>:$column$.period_type_attribute3, p_attribute4=>:$column$.period_type_attribute4, p_attribute5=>:$column$.period_type_attribute5)) lov order by value select 'Period Type rows.'||chr(10)||listagg(x.prompt,chr(10)) within group (order by x.descriptive_flex_context_code) from ( select distinct fdfcuv.descriptive_flex_context_code, decode(fdfcuv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcuv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv where fdfcuv.application_id=101 and fdfcuv.descriptive_flexfield_name='GL_PERIOD_TYPES' and fdfcuv.application_column_name='ATTRIBUTE5' and fdfcuv.enabled_flag='Y' ) x 44 PERIOD_CONTEXT LOV custom varchar2 Y select fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=101 and fdfcv.descriptive_flexfield_name='GL_PERIODS' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' and fdfcv.enabled_flag='Y' order by fdfcv.descriptive_flex_context_name Calendar Period rows. Descriptive flexfield context. 45 PERIOD_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>101, p_descriptive_flexfield_name=>'GL_PERIODS', p_context_name=>:$column$.period_context, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.period_attribute1, p_attribute2=>:$column$.period_attribute2, p_attribute3=>:$column$.period_attribute3, p_attribute4=>:$column$.period_attribute4, p_attribute5=>:$column$.period_attribute5, p_attribute6=>:$column$.period_attribute6, p_attribute7=>:$column$.period_attribute7, p_attribute8=>:$column$.period_attribute8)) lov order by value select 'Calendar Period rows.'||chr(10)||listagg(x.prompt,chr(10)) within group (order by x.descriptive_flex_context_code) from ( select distinct fdfcuv.descriptive_flex_context_code, decode(fdfcuv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcuv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv where fdfcuv.application_id=101 and fdfcuv.descriptive_flexfield_name='GL_PERIODS' and fdfcuv.application_column_name='ATTRIBUTE1' and fdfcuv.enabled_flag='Y' ) x 46 PERIOD_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>101, p_descriptive_flexfield_name=>'GL_PERIODS', p_context_name=>:$column$.period_context, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.period_attribute1, p_attribute2=>:$column$.period_attribute2, p_attribute3=>:$column$.period_attribute3, p_attribute4=>:$column$.period_attribute4, p_attribute5=>:$column$.period_attribute5, p_attribute6=>:$column$.period_attribute6, p_attribute7=>:$column$.period_attribute7, p_attribute8=>:$column$.period_attribute8)) lov order by value select 'Calendar Period rows.'||chr(10)||listagg(x.prompt,chr(10)) within group (order by x.descriptive_flex_context_code) from ( select distinct fdfcuv.descriptive_flex_context_code, decode(fdfcuv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcuv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv where fdfcuv.application_id=101 and fdfcuv.descriptive_flexfield_name='GL_PERIODS' and fdfcuv.application_column_name='ATTRIBUTE2' and fdfcuv.enabled_flag='Y' ) x 47 PERIOD_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>101, p_descriptive_flexfield_name=>'GL_PERIODS', p_context_name=>:$column$.period_context, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.period_attribute1, p_attribute2=>:$column$.period_attribute2, p_attribute3=>:$column$.period_attribute3, p_attribute4=>:$column$.period_attribute4, p_attribute5=>:$column$.period_attribute5, p_attribute6=>:$column$.period_attribute6, p_attribute7=>:$column$.period_attribute7, p_attribute8=>:$column$.period_attribute8)) lov order by value select 'Calendar Period rows.'||chr(10)||listagg(x.prompt,chr(10)) within group (order by x.descriptive_flex_context_code) from ( select distinct fdfcuv.descriptive_flex_context_code, decode(fdfcuv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcuv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv where fdfcuv.application_id=101 and fdfcuv.descriptive_flexfield_name='GL_PERIODS' and fdfcuv.application_column_name='ATTRIBUTE3' and fdfcuv.enabled_flag='Y' ) x 48 PERIOD_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>101, p_descriptive_flexfield_name=>'GL_PERIODS', p_context_name=>:$column$.period_context, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.period_attribute1, p_attribute2=>:$column$.period_attribute2, p_attribute3=>:$column$.period_attribute3, p_attribute4=>:$column$.period_attribute4, p_attribute5=>:$column$.period_attribute5, p_attribute6=>:$column$.period_attribute6, p_attribute7=>:$column$.period_attribute7, p_attribute8=>:$column$.period_attribute8)) lov order by value select 'Calendar Period rows.'||chr(10)||listagg(x.prompt,chr(10)) within group (order by x.descriptive_flex_context_code) from ( select distinct fdfcuv.descriptive_flex_context_code, decode(fdfcuv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcuv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv where fdfcuv.application_id=101 and fdfcuv.descriptive_flexfield_name='GL_PERIODS' and fdfcuv.application_column_name='ATTRIBUTE4' and fdfcuv.enabled_flag='Y' ) x 49 PERIOD_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>101, p_descriptive_flexfield_name=>'GL_PERIODS', p_context_name=>:$column$.period_context, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.period_attribute1, p_attribute2=>:$column$.period_attribute2, p_attribute3=>:$column$.period_attribute3, p_attribute4=>:$column$.period_attribute4, p_attribute5=>:$column$.period_attribute5, p_attribute6=>:$column$.period_attribute6, p_attribute7=>:$column$.period_attribute7, p_attribute8=>:$column$.period_attribute8)) lov order by value select 'Calendar Period rows.'||chr(10)||listagg(x.prompt,chr(10)) within group (order by x.descriptive_flex_context_code) from ( select distinct fdfcuv.descriptive_flex_context_code, decode(fdfcuv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcuv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv where fdfcuv.application_id=101 and fdfcuv.descriptive_flexfield_name='GL_PERIODS' and fdfcuv.application_column_name='ATTRIBUTE5' and fdfcuv.enabled_flag='Y' ) x 50 PERIOD_ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>101, p_descriptive_flexfield_name=>'GL_PERIODS', p_context_name=>:$column$.period_context, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.period_attribute1, p_attribute2=>:$column$.period_attribute2, p_attribute3=>:$column$.period_attribute3, p_attribute4=>:$column$.period_attribute4, p_attribute5=>:$column$.period_attribute5, p_attribute6=>:$column$.period_attribute6, p_attribute7=>:$column$.period_attribute7, p_attribute8=>:$column$.period_attribute8)) lov order by value select 'Calendar Period rows.'||chr(10)||listagg(x.prompt,chr(10)) within group (order by x.descriptive_flex_context_code) from ( select distinct fdfcuv.descriptive_flex_context_code, decode(fdfcuv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcuv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv where fdfcuv.application_id=101 and fdfcuv.descriptive_flexfield_name='GL_PERIODS' and fdfcuv.application_column_name='ATTRIBUTE6' and fdfcuv.enabled_flag='Y' ) x 51 PERIOD_ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>101, p_descriptive_flexfield_name=>'GL_PERIODS', p_context_name=>:$column$.period_context, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.period_attribute1, p_attribute2=>:$column$.period_attribute2, p_attribute3=>:$column$.period_attribute3, p_attribute4=>:$column$.period_attribute4, p_attribute5=>:$column$.period_attribute5, p_attribute6=>:$column$.period_attribute6, p_attribute7=>:$column$.period_attribute7, p_attribute8=>:$column$.period_attribute8)) lov order by value select 'Calendar Period rows.'||chr(10)||listagg(x.prompt,chr(10)) within group (order by x.descriptive_flex_context_code) from ( select distinct fdfcuv.descriptive_flex_context_code, decode(fdfcuv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcuv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv where fdfcuv.application_id=101 and fdfcuv.descriptive_flexfield_name='GL_PERIODS' and fdfcuv.application_column_name='ATTRIBUTE7' and fdfcuv.enabled_flag='Y' ) x 52 PERIOD_ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>101, p_descriptive_flexfield_name=>'GL_PERIODS', p_context_name=>:$column$.period_context, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.period_attribute1, p_attribute2=>:$column$.period_attribute2, p_attribute3=>:$column$.period_attribute3, p_attribute4=>:$column$.period_attribute4, p_attribute5=>:$column$.period_attribute5, p_attribute6=>:$column$.period_attribute6, p_attribute7=>:$column$.period_attribute7, p_attribute8=>:$column$.period_attribute8)) lov order by value select 'Calendar Period rows.'||chr(10)||listagg(x.prompt,chr(10)) within group (order by x.descriptive_flex_context_code) from ( select distinct fdfcuv.descriptive_flex_context_code, decode(fdfcuv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcuv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv where fdfcuv.application_id=101 and fdfcuv.descriptive_flexfield_name='GL_PERIODS' and fdfcuv.application_column_name='ATTRIBUTE8' and fdfcuv.enabled_flag='Y' ) x 53 SOURCE_CONTEXT LOV custom varchar2 Y select fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=101 and fdfcv.descriptive_flexfield_name='GL_JE_SOURCES' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' and fdfcv.enabled_flag='Y' order by fdfcv.descriptive_flex_context_name Journal Source rows. Descriptive flexfield context. 54 SOURCE_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>101, p_descriptive_flexfield_name=>'GL_JE_SOURCES', p_context_name=>:$column$.source_context, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.source_attribute1, p_attribute2=>:$column$.source_attribute2, p_attribute3=>:$column$.source_attribute3, p_attribute4=>:$column$.source_attribute4, p_attribute5=>:$column$.source_attribute5)) lov order by value select 'Journal Source rows.'||chr(10)||listagg(x.prompt,chr(10)) within group (order by x.descriptive_flex_context_code) from ( select distinct fdfcuv.descriptive_flex_context_code, decode(fdfcuv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcuv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv where fdfcuv.application_id=101 and fdfcuv.descriptive_flexfield_name='GL_JE_SOURCES' and fdfcuv.application_column_name='ATTRIBUTE1' and fdfcuv.enabled_flag='Y' ) x 55 SOURCE_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>101, p_descriptive_flexfield_name=>'GL_JE_SOURCES', p_context_name=>:$column$.source_context, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.source_attribute1, p_attribute2=>:$column$.source_attribute2, p_attribute3=>:$column$.source_attribute3, p_attribute4=>:$column$.source_attribute4, p_attribute5=>:$column$.source_attribute5)) lov order by value select 'Journal Source rows.'||chr(10)||listagg(x.prompt,chr(10)) within group (order by x.descriptive_flex_context_code) from ( select distinct fdfcuv.descriptive_flex_context_code, decode(fdfcuv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcuv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv where fdfcuv.application_id=101 and fdfcuv.descriptive_flexfield_name='GL_JE_SOURCES' and fdfcuv.application_column_name='ATTRIBUTE2' and fdfcuv.enabled_flag='Y' ) x 56 SOURCE_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>101, p_descriptive_flexfield_name=>'GL_JE_SOURCES', p_context_name=>:$column$.source_context, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.source_attribute1, p_attribute2=>:$column$.source_attribute2, p_attribute3=>:$column$.source_attribute3, p_attribute4=>:$column$.source_attribute4, p_attribute5=>:$column$.source_attribute5)) lov order by value select 'Journal Source rows.'||chr(10)||listagg(x.prompt,chr(10)) within group (order by x.descriptive_flex_context_code) from ( select distinct fdfcuv.descriptive_flex_context_code, decode(fdfcuv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcuv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv where fdfcuv.application_id=101 and fdfcuv.descriptive_flexfield_name='GL_JE_SOURCES' and fdfcuv.application_column_name='ATTRIBUTE3' and fdfcuv.enabled_flag='Y' ) x 57 SOURCE_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>101, p_descriptive_flexfield_name=>'GL_JE_SOURCES', p_context_name=>:$column$.source_context, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.source_attribute1, p_attribute2=>:$column$.source_attribute2, p_attribute3=>:$column$.source_attribute3, p_attribute4=>:$column$.source_attribute4, p_attribute5=>:$column$.source_attribute5)) lov order by value select 'Journal Source rows.'||chr(10)||listagg(x.prompt,chr(10)) within group (order by x.descriptive_flex_context_code) from ( select distinct fdfcuv.descriptive_flex_context_code, decode(fdfcuv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcuv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv where fdfcuv.application_id=101 and fdfcuv.descriptive_flexfield_name='GL_JE_SOURCES' and fdfcuv.application_column_name='ATTRIBUTE4' and fdfcuv.enabled_flag='Y' ) x 58 SOURCE_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>101, p_descriptive_flexfield_name=>'GL_JE_SOURCES', p_context_name=>:$column$.source_context, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.source_attribute1, p_attribute2=>:$column$.source_attribute2, p_attribute3=>:$column$.source_attribute3, p_attribute4=>:$column$.source_attribute4, p_attribute5=>:$column$.source_attribute5)) lov order by value select 'Journal Source rows.'||chr(10)||listagg(x.prompt,chr(10)) within group (order by x.descriptive_flex_context_code) from ( select distinct fdfcuv.descriptive_flex_context_code, decode(fdfcuv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcuv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv where fdfcuv.application_id=101 and fdfcuv.descriptive_flexfield_name='GL_JE_SOURCES' and fdfcuv.application_column_name='ATTRIBUTE5' and fdfcuv.enabled_flag='Y' ) x 59 CATEGORY_CONTEXT LOV custom varchar2 Y select fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=101 and fdfcv.descriptive_flexfield_name='GL_JE_CATEGORIES' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' and fdfcv.enabled_flag='Y' order by fdfcv.descriptive_flex_context_name Journal Category rows. Descriptive flexfield context. 60 CATEGORY_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>101, p_descriptive_flexfield_name=>'GL_JE_CATEGORIES', p_context_name=>:$column$.category_context, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.category_attribute1, p_attribute2=>:$column$.category_attribute2, p_attribute3=>:$column$.category_attribute3, p_attribute4=>:$column$.category_attribute4, p_attribute5=>:$column$.category_attribute5)) lov order by value select 'Journal Category rows.'||chr(10)||listagg(x.prompt,chr(10)) within group (order by x.descriptive_flex_context_code) from ( select distinct fdfcuv.descriptive_flex_context_code, decode(fdfcuv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcuv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv where fdfcuv.application_id=101 and fdfcuv.descriptive_flexfield_name='GL_JE_CATEGORIES' and fdfcuv.application_column_name='ATTRIBUTE1' and fdfcuv.enabled_flag='Y' ) x 61 CATEGORY_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>101, p_descriptive_flexfield_name=>'GL_JE_CATEGORIES', p_context_name=>:$column$.category_context, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.category_attribute1, p_attribute2=>:$column$.category_attribute2, p_attribute3=>:$column$.category_attribute3, p_attribute4=>:$column$.category_attribute4, p_attribute5=>:$column$.category_attribute5)) lov order by value select 'Journal Category rows.'||chr(10)||listagg(x.prompt,chr(10)) within group (order by x.descriptive_flex_context_code) from ( select distinct fdfcuv.descriptive_flex_context_code, decode(fdfcuv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcuv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv where fdfcuv.application_id=101 and fdfcuv.descriptive_flexfield_name='GL_JE_CATEGORIES' and fdfcuv.application_column_name='ATTRIBUTE2' and fdfcuv.enabled_flag='Y' ) x 62 CATEGORY_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>101, p_descriptive_flexfield_name=>'GL_JE_CATEGORIES', p_context_name=>:$column$.category_context, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.category_attribute1, p_attribute2=>:$column$.category_attribute2, p_attribute3=>:$column$.category_attribute3, p_attribute4=>:$column$.category_attribute4, p_attribute5=>:$column$.category_attribute5)) lov order by value select 'Journal Category rows.'||chr(10)||listagg(x.prompt,chr(10)) within group (order by x.descriptive_flex_context_code) from ( select distinct fdfcuv.descriptive_flex_context_code, decode(fdfcuv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcuv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv where fdfcuv.application_id=101 and fdfcuv.descriptive_flexfield_name='GL_JE_CATEGORIES' and fdfcuv.application_column_name='ATTRIBUTE3' and fdfcuv.enabled_flag='Y' ) x 63 CATEGORY_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>101, p_descriptive_flexfield_name=>'GL_JE_CATEGORIES', p_context_name=>:$column$.category_context, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.category_attribute1, p_attribute2=>:$column$.category_attribute2, p_attribute3=>:$column$.category_attribute3, p_attribute4=>:$column$.category_attribute4, p_attribute5=>:$column$.category_attribute5)) lov order by value select 'Journal Category rows.'||chr(10)||listagg(x.prompt,chr(10)) within group (order by x.descriptive_flex_context_code) from ( select distinct fdfcuv.descriptive_flex_context_code, decode(fdfcuv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcuv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv where fdfcuv.application_id=101 and fdfcuv.descriptive_flexfield_name='GL_JE_CATEGORIES' and fdfcuv.application_column_name='ATTRIBUTE4' and fdfcuv.enabled_flag='Y' ) x 64 CATEGORY_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>101, p_descriptive_flexfield_name=>'GL_JE_CATEGORIES', p_context_name=>:$column$.category_context, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.category_attribute1, p_attribute2=>:$column$.category_attribute2, p_attribute3=>:$column$.category_attribute3, p_attribute4=>:$column$.category_attribute4, p_attribute5=>:$column$.category_attribute5)) lov order by value select 'Journal Category rows.'||chr(10)||listagg(x.prompt,chr(10)) within group (order by x.descriptive_flex_context_code) from ( select distinct fdfcuv.descriptive_flex_context_code, decode(fdfcuv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcuv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv where fdfcuv.application_id=101 and fdfcuv.descriptive_flexfield_name='GL_JE_CATEGORIES' and fdfcuv.application_column_name='ATTRIBUTE5' and fdfcuv.enabled_flag='Y' ) x 65 LEDGER_SET Char varchar2 66 SHORT_NAME Char varchar2 67 DEFAULT_LEDGER LOV custom varchar2 Y select gl.name value, gl.description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv, gl_period_types gpt where gl.object_type_code='L' and gl.automatically_created_flag='N' and nvl(gl.complete_flag,'Y')='Y' and fifsv.id_flex_num=gl.chart_of_accounts_id and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_structure_name=:$column$.chart_of_accounts and gpt.period_type=gl.accounted_period_type and gpt.user_period_type=:$column$.period_type and gl.period_set_name=:$column$.calendar order by gl.name 68 LEDGER LOV custom varchar2 Y select gl.name value, gl.description from gl_ledgers gl where gl.automatically_created_flag='N' and nvl(gl.complete_flag,'Y')='Y' and gl.name<>nvl(:$column$.ledger_set,chr(1)) and ( not exists (select null from gl_ledgers gls where gls.name=:$column$.ledger_set and gls.object_type_code='S') or exists (select null from gl_ledgers gls where gls.name=:$column$.ledger_set and gls.object_type_code='S' and gl.chart_of_accounts_id=gls.chart_of_accounts_id and gl.period_set_name=gls.period_set_name and gl.accounted_period_type=gls.accounted_period_type) ) order by gl.name 69 DELETE_ASSIGNMENT LOV custom varchar2 Y select xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$column$.ledger is not null and (:$column$.ledger_set is not null or :$column$.data_access_set is not null) 70 DATA_ACCESS_SET Char varchar2 71 ACCESS_SET_TYPE LOV custom varchar2 Y select 'F' id, 'Full Ledger' value, null description from dual union all select 'B' id, 'Balancing Segment Value' value, null description from dual union all select 'M' id, 'Management Segment Value' value, null description from dual 72 ALL_SEGMENT_VALUES LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 73 SEGMENT_VALUE LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from gl_access_sets gas, fnd_flex_values_vl ffvv where gas.name=:$column$.data_access_set and gas.automatically_created_flag='N' and ffvv.flex_value_set_id=gas.secured_seg_value_set_id and ffvv.enabled_flag='Y' order by ffvv.flex_value 74 RETAINED_EARNINGS_ACCOUNT LOV custom varchar2 Y select gcck.concatenated_segments value, gcck.description from gl_code_combinations_kfv gcck, gl_ledgers gl where gl.name=:$column$.ledger and gl.object_type_code='L' and gcck.chart_of_accounts_id=gl.chart_of_accounts_id and gcck.enabled_flag='Y' order by gcck.concatenated_segments 75 SUSPENSE_ALLOWED LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 76 ROUNDING_ACCOUNT LOV custom varchar2 Y select gcck.concatenated_segments value, gcck.description from gl_code_combinations_kfv gcck, gl_ledgers gl where gl.name=:$column$.ledger and gl.object_type_code='L' and gcck.chart_of_accounts_id=gl.chart_of_accounts_id and gcck.enabled_flag='Y' order by gcck.concatenated_segments 77 CTA_ACCOUNT LOV custom varchar2 Y select gcck.concatenated_segments value, gcck.description from gl_code_combinations_kfv gcck, gl_ledgers gl where gl.name=:$column$.ledger and gl.object_type_code='L' and gcck.chart_of_accounts_id=gl.chart_of_accounts_id and gcck.enabled_flag='Y' order by gcck.concatenated_segments 78 RESERVE_ENCUMBRANCE_ACCOUNT LOV custom varchar2 Y select gcck.concatenated_segments value, gcck.description from gl_code_combinations_kfv gcck, gl_ledgers gl where gl.name=:$column$.ledger and gl.object_type_code='L' and gcck.chart_of_accounts_id=gl.chart_of_accounts_id and gcck.enabled_flag='Y' order by gcck.concatenated_segments 79 NET_INCOME_ACCOUNT LOV custom varchar2 Y select gcck.concatenated_segments value, gcck.description from gl_code_combinations_kfv gcck, gl_ledgers gl where gl.name=:$column$.ledger and gl.object_type_code='L' and gcck.chart_of_accounts_id=gl.chart_of_accounts_id and gcck.enabled_flag='Y' order by gcck.concatenated_segments 80 ENABLE_AVERAGE_BALANCES LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 81 TRANSLATE_EOD LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 82 TRANSLATE_QATD LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 83 TRANSLATE_YATD LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 84 ENABLE_BUDGETARY_CONTROL LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 85 REQUIRE_BUDGET_JOURNALS LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 86 ENABLE_JOURNAL_APPROVAL LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 87 ENABLE_AUTOMATIC_TAX LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 88 CONSOLIDATION_LEDGER LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 89 FUTURE_ENTERABLE_PERIODS Number number 90 TRANSACTION_CALENDAR LOV custom varchar2 Y select gtc.name value, gtc.description from gl_transaction_calendar gtc order by gtc.name 91 DAILY_RATE_TYPE LOV custom varchar2 Y select gdct.user_conversion_type value, gdct.description from gl_daily_conversion_types gdct order by gdct.user_conversion_type 92 PERIOD_AVERAGE_RATE_TYPE LOV custom varchar2 Y select gdct.user_conversion_type value, gdct.description from gl_daily_conversion_types gdct order by gdct.user_conversion_type 93 PERIOD_END_RATE_TYPE LOV custom varchar2 Y select gdct.user_conversion_type value, gdct.description from gl_daily_conversion_types gdct order by gdct.user_conversion_type 94 ENABLE_RECONCILIATION LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 95 NET_CLOSING_BALANCE LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 96 CRITERIA_SET Char varchar2 97 REVERSAL_METHOD LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='REVERSAL_OPTION_CODE' and flvv.view_application_id=101 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.lookup_code 98 REVERSAL_PERIOD LOV custom varchar2 Y select 'NO_DEFAULT' id, 'No Default' value, null description from dual union all select 'SAME_PERIOD' id, 'Same Period' value, null description from dual union all select 'NEXT_PERIOD' id, 'Next Period' value, null description from dual union all select 'NEXT_NON_ADJ_PERIOD' id, 'Next Non Adjusting Period' value, null description from dual 99 REVERSAL_DATE LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='AUTOREVERSE_DATE_RULE' and flvv.security_group_id=0 and flvv.enabled_flag='Y' and ( :$column$.reversal_period='Same Period' and flvv.lookup_code in ('NEXT_DAY','LAST_DAY') or :$column$.reversal_period in ('Next Period','Next Non Adjusting Period') and flvv.lookup_code in ('FIRST_DAY','LAST_DAY') ) order by flvv.lookup_code 100 AUTOREVERSE LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 101 AUTOPOST_REVERSAL LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 102 AUTOPOST_SET Char varchar2 103 SUBMIT_ALL_PRIORITIES LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 104 NUMBER_OF_PRIORITIES Number number 105 EFFECTIVE_DAYS_BEFORE Number number 106 EFFECTIVE_DAYS_AFTER Number number 107 POSTING_PRIORITY Number number 108 BALANCE_TYPE LOV custom varchar2 Y select flvv.lookup_code id, flvv.description value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='BATCH_TYPE_ALL' and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.lookup_code 109 DELETE_OPTION LOV custom varchar2 Y select xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$column$.autopost_set is not null 110 ROW_TYPE_SORT Number number Y 111 UPLOAD_ROW Number number Y U 1 p_row_type in Char ROW_TYPE U 2 p_calendar in Char CALENDAR U 3 p_calendar_description in Char CALENDAR_DESCRIPTION U 4 p_enable_security in Char ENABLE_SECURITY U 5 p_period_prefix in Char PERIOD_PREFIX U 6 p_period_type in Char PERIOD_TYPE U 7 p_period_year in Number PERIOD_YEAR U 8 p_quarter in Number QUARTER U 9 p_period_num in Number PERIOD_NUM U 10 p_start_date in Date START_DATE U 11 p_end_date in Date END_DATE U 12 p_period_name in Char PERIOD_NAME U 13 p_adjustment_period in Char ADJUSTMENT_PERIOD U 14 p_period_description in Char PERIOD_DESCRIPTION U 15 p_delete_period in Char DELETE_PERIOD U 16 p_periods_per_year in Number PERIODS_PER_YEAR U 17 p_year_type_in_name in Char YEAR_TYPE_IN_NAME U 18 p_journal_source in Char JOURNAL_SOURCE U 19 p_journal_source_key in Char JOURNAL_SOURCE_KEY U 20 p_import_journal_references in Char IMPORT_JOURNAL_REFERENCES U 21 p_require_journal_approval in Char REQUIRE_JOURNAL_APPROVAL U 22 p_import_using_key in Char IMPORT_USING_KEY U 23 p_freeze_journals in Char FREEZE_JOURNALS U 24 p_effective_date_rule in Char EFFECTIVE_DATE_RULE U 25 p_journal_category in Char JOURNAL_CATEGORY U 26 p_journal_category_key in Char JOURNAL_CATEGORY_KEY U 27 p_encumbrance_type in Char ENCUMBRANCE_TYPE U 28 p_enabled in Char ENABLED U 29 p_chart_of_accounts in Char CHART_OF_ACCOUNTS U 30 p_account_segment_value in Char ACCOUNT_SEGMENT_VALUE U 31 p_unit_of_measure in Char UNIT_OF_MEASURE U 32 p_delete_stat_uom in Char DELETE_STAT_UOM U 33 p_description in Char DESCRIPTION U 34 p_period_type_context in Char PERIOD_TYPE_CONTEXT U 35 p_period_type_attribute1 in Char PERIOD_TYPE_ATTRIBUTE1 U 36 p_period_type_attribute2 in Char PERIOD_TYPE_ATTRIBUTE2 U 37 p_period_type_attribute3 in Char PERIOD_TYPE_ATTRIBUTE3 U 38 p_period_type_attribute4 in Char PERIOD_TYPE_ATTRIBUTE4 U 39 p_period_type_attribute5 in Char PERIOD_TYPE_ATTRIBUTE5 U 40 p_period_context in Char PERIOD_CONTEXT U 41 p_period_attribute1 in Char PERIOD_ATTRIBUTE1 U 42 p_period_attribute2 in Char PERIOD_ATTRIBUTE2 U 43 p_period_attribute3 in Char PERIOD_ATTRIBUTE3 U 44 p_period_attribute4 in Char PERIOD_ATTRIBUTE4 U 45 p_period_attribute5 in Char PERIOD_ATTRIBUTE5 U 46 p_period_attribute6 in Char PERIOD_ATTRIBUTE6 U 47 p_period_attribute7 in Char PERIOD_ATTRIBUTE7 U 48 p_period_attribute8 in Char PERIOD_ATTRIBUTE8 U 49 p_source_context in Char SOURCE_CONTEXT U 50 p_source_attribute1 in Char SOURCE_ATTRIBUTE1 U 51 p_source_attribute2 in Char SOURCE_ATTRIBUTE2 U 52 p_source_attribute3 in Char SOURCE_ATTRIBUTE3 U 53 p_source_attribute4 in Char SOURCE_ATTRIBUTE4 U 54 p_source_attribute5 in Char SOURCE_ATTRIBUTE5 U 55 p_category_context in Char CATEGORY_CONTEXT U 56 p_category_attribute1 in Char CATEGORY_ATTRIBUTE1 U 57 p_category_attribute2 in Char CATEGORY_ATTRIBUTE2 U 58 p_category_attribute3 in Char CATEGORY_ATTRIBUTE3 U 59 p_category_attribute4 in Char CATEGORY_ATTRIBUTE4 U 60 p_category_attribute5 in Char CATEGORY_ATTRIBUTE5 U 61 p_ledger_set in Char LEDGER_SET U 62 p_short_name in Char SHORT_NAME U 63 p_default_ledger in Char DEFAULT_LEDGER U 64 p_ledger in Char LEDGER U 65 p_delete_assignment in Char DELETE_ASSIGNMENT U 66 p_data_access_set in Char DATA_ACCESS_SET U 67 p_access_set_type in Char ACCESS_SET_TYPE U 68 p_all_segment_values in Char ALL_SEGMENT_VALUES U 69 p_segment_value in Char SEGMENT_VALUE U 70 p_retained_earnings_account in Char RETAINED_EARNINGS_ACCOUNT U 71 p_suspense_allowed in Char SUSPENSE_ALLOWED U 72 p_rounding_account in Char ROUNDING_ACCOUNT U 73 p_cta_account in Char CTA_ACCOUNT U 74 p_reserve_encumbrance_account in Char RESERVE_ENCUMBRANCE_ACCOUNT U 75 p_net_income_account in Char NET_INCOME_ACCOUNT U 76 p_enable_average_balances in Char ENABLE_AVERAGE_BALANCES U 77 p_translate_eod in Char TRANSLATE_EOD U 78 p_translate_qatd in Char TRANSLATE_QATD U 79 p_translate_yatd in Char TRANSLATE_YATD U 80 p_enable_budgetary_control in Char ENABLE_BUDGETARY_CONTROL U 81 p_require_budget_journals in Char REQUIRE_BUDGET_JOURNALS U 82 p_enable_journal_approval in Char ENABLE_JOURNAL_APPROVAL U 83 p_enable_automatic_tax in Char ENABLE_AUTOMATIC_TAX U 84 p_consolidation_ledger in Char CONSOLIDATION_LEDGER U 85 p_future_enterable_periods in Number FUTURE_ENTERABLE_PERIODS U 86 p_transaction_calendar in Char TRANSACTION_CALENDAR U 87 p_daily_rate_type in Char DAILY_RATE_TYPE U 88 p_period_average_rate_type in Char PERIOD_AVERAGE_RATE_TYPE U 89 p_period_end_rate_type in Char PERIOD_END_RATE_TYPE U 90 p_enable_reconciliation in Char ENABLE_RECONCILIATION U 91 p_net_closing_balance in Char NET_CLOSING_BALANCE U 92 p_criteria_set in Char CRITERIA_SET U 93 p_reversal_method in Char REVERSAL_METHOD U 94 p_reversal_period in Char REVERSAL_PERIOD U 95 p_reversal_date in Char REVERSAL_DATE U 96 p_autoreverse in Char AUTOREVERSE U 97 p_autopost_reversal in Char AUTOPOST_REVERSAL U 98 p_autopost_set in Char AUTOPOST_SET U 99 p_submit_all_priorities in Char SUBMIT_ALL_PRIORITIES U 100 p_number_of_priorities in Number NUMBER_OF_PRIORITIES U 101 p_effective_days_before in Number EFFECTIVE_DAYS_BEFORE U 102 p_effective_days_after in Number EFFECTIVE_DAYS_AFTER U 103 p_posting_priority in Number POSTING_PRIORITY U 104 p_balance_type in Char BALANCE_TYPE U 105 p_delete_option in Char DELETE_OPTION U 106 status_ out Char STATUS_CODE_ U 107 message_ out Char MESSAGE_ Error SQL Order By upload_row, row_type_sort, calendar, period_type, period_year, period_num, journal_source, journal_category, encumbrance_type, chart_of_accounts, account_segment_value Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, nvl(gpt.user_period_type,xu.period_type) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, nvl(gpt.number_per_fiscal_year,xu.periods_per_year) periods_per_year, nvl(decode(gpt.year_type_in_name,'C','Calendar','F','Fiscal'),xu.year_type_in_name) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, nvl(gpt.description,xu.description) description, nvl(xxen_util.display_flexfield_context(101,'GL_PERIOD_TYPES',gpt.context),xu.period_type_context) period_type_context, nvl(xxen_util.display_flexfield_value(101,'GL_PERIOD_TYPES',gpt.context,'ATTRIBUTE1',gpt.rowid,gpt.attribute1),xu.period_type_attribute1) period_type_attribute1, nvl(xxen_util.display_flexfield_value(101,'GL_PERIOD_TYPES',gpt.context,'ATTRIBUTE2',gpt.rowid,gpt.attribute2),xu.period_type_attribute2) period_type_attribute2, nvl(xxen_util.display_flexfield_value(101,'GL_PERIOD_TYPES',gpt.context,'ATTRIBUTE3',gpt.rowid,gpt.attribute3),xu.period_type_attribute3) period_type_attribute3, nvl(xxen_util.display_flexfield_value(101,'GL_PERIOD_TYPES',gpt.context,'ATTRIBUTE4',gpt.rowid,gpt.attribute4),xu.period_type_attribute4) period_type_attribute4, nvl(xxen_util.display_flexfield_value(101,'GL_PERIOD_TYPES',gpt.context,'ATTRIBUTE5',gpt.rowid,gpt.attribute5),xu.period_type_attribute5) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 1 row_type_sort, xu.upload_row from ( select xu.* from xxen_gl_setup_upload_5335_u xu where xu.status_code_=xxen_upload.status_success and xu.row_type='Period Type' ) xu, gl_period_types gpt where gpt.user_period_type(+)=xu.period_type union all select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.row_type, nvl(gps.period_set_name,xu.calendar) calendar, nvl(gps.description,xu.calendar_description) calendar_description, nvl(xxen_util.meaning(gps.security_flag,'YES_NO',0),xu.enable_security) enable_security, nvl(gp.entered_period_name,xu.period_prefix) period_prefix, nvl(gpt.user_period_type,xu.period_type) period_type, nvl(gp.period_year,xu.period_year) period_year, nvl(gp.quarter_num,xu.quarter) quarter, nvl(gp.period_num,xu.period_num) period_num, nvl(gp.start_date,xu.start_date) start_date, nvl(gp.end_date,xu.end_date) end_date, nvl(gp.period_name,xu.period_name) period_name, nvl(xxen_util.meaning(gp.adjustment_period_flag,'YES_NO',0),xu.adjustment_period) adjustment_period, nvl(gp.description,xu.period_description) period_description, xu.delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, to_char(null) description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, nvl(xxen_util.display_flexfield_context(101,'GL_PERIODS',gp.context),xu.period_context) period_context, nvl(xxen_util.display_flexfield_value(101,'GL_PERIODS',gp.context,'ATTRIBUTE1',gp.rowid,gp.attribute1),xu.period_attribute1) period_attribute1, nvl(xxen_util.display_flexfield_value(101,'GL_PERIODS',gp.context,'ATTRIBUTE2',gp.rowid,gp.attribute2),xu.period_attribute2) period_attribute2, nvl(xxen_util.display_flexfield_value(101,'GL_PERIODS',gp.context,'ATTRIBUTE3',gp.rowid,gp.attribute3),xu.period_attribute3) period_attribute3, nvl(xxen_util.display_flexfield_value(101,'GL_PERIODS',gp.context,'ATTRIBUTE4',gp.rowid,gp.attribute4),xu.period_attribute4) period_attribute4, nvl(xxen_util.display_flexfield_value(101,'GL_PERIODS',gp.context,'ATTRIBUTE5',gp.rowid,gp.attribute5),xu.period_attribute5) period_attribute5, nvl(xxen_util.display_flexfield_value(101,'GL_PERIODS',gp.context,'ATTRIBUTE6',gp.rowid,gp.attribute6),xu.period_attribute6) period_attribute6, nvl(xxen_util.display_flexfield_value(101,'GL_PERIODS',gp.context,'ATTRIBUTE7',gp.rowid,gp.attribute7),xu.period_attribute7) period_attribute7, nvl(xxen_util.display_flexfield_value(101,'GL_PERIODS',gp.context,'ATTRIBUTE8',gp.rowid,gp.attribute8),xu.period_attribute8) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 2 row_type_sort, xu.upload_row from ( select xu.*, (select gpt0.period_type from gl_period_types gpt0 where gpt0.user_period_type=xu.period_type) period_type_code from xxen_gl_setup_upload_5335_u xu where xu.status_code_=xxen_upload.status_success and xu.row_type='Calendar Period' ) xu, --the outer joined tables may reference only one other table before 12c, so the period type is resolved in the inline view gl_period_sets gps, gl_periods gp, gl_period_types gpt where gps.period_set_name(+)=xu.calendar and gp.period_set_name(+)=xu.calendar and gp.period_type(+)=xu.period_type_code and gp.period_year(+)=xu.period_year and gp.period_num(+)=xu.period_num and gp.period_type=gpt.period_type(+) union all select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, nvl(gjsv.user_je_source_name,xu.journal_source) journal_source, nvl(gjsv.je_source_key,xu.journal_source_key) journal_source_key, nvl(xxen_util.meaning(gjsv.journal_reference_flag,'YES_NO',0),xu.import_journal_references) import_journal_references, nvl(xxen_util.meaning(gjsv.journal_approval_flag,'YES_NO',0),xu.require_journal_approval) require_journal_approval, nvl(xxen_util.meaning(gjsv.import_using_key_flag,'YES_NO',0),xu.import_using_key) import_using_key, nvl(xxen_util.meaning(gjsv.override_edits_flag,'YES_NO',0),xu.freeze_journals) freeze_journals, nvl(decode(gjsv.effective_date_rule_code,'L','Leave Alone','R','Roll Date','F','Fail'),xu.effective_date_rule) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, nvl(gjsv.description,xu.description) description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, nvl(xxen_util.display_flexfield_context(101,'GL_JE_SOURCES',gjsv.context),xu.source_context) source_context, nvl(xxen_util.display_flexfield_value(101,'GL_JE_SOURCES',gjsv.context,'ATTRIBUTE1',gjsv.row_id,gjsv.attribute1),xu.source_attribute1) source_attribute1, nvl(xxen_util.display_flexfield_value(101,'GL_JE_SOURCES',gjsv.context,'ATTRIBUTE2',gjsv.row_id,gjsv.attribute2),xu.source_attribute2) source_attribute2, nvl(xxen_util.display_flexfield_value(101,'GL_JE_SOURCES',gjsv.context,'ATTRIBUTE3',gjsv.row_id,gjsv.attribute3),xu.source_attribute3) source_attribute3, nvl(xxen_util.display_flexfield_value(101,'GL_JE_SOURCES',gjsv.context,'ATTRIBUTE4',gjsv.row_id,gjsv.attribute4),xu.source_attribute4) source_attribute4, nvl(xxen_util.display_flexfield_value(101,'GL_JE_SOURCES',gjsv.context,'ATTRIBUTE5',gjsv.row_id,gjsv.attribute5),xu.source_attribute5) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 3 row_type_sort, xu.upload_row from ( select xu.* from xxen_gl_setup_upload_5335_u xu where xu.status_code_=xxen_upload.status_success and xu.row_type='Journal Source' ) xu, gl_je_sources_vl gjsv where gjsv.user_je_source_name(+)=xu.journal_source union all select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, nvl(gjcv.user_je_category_name,xu.journal_category) journal_category, nvl(gjcv.je_category_key,xu.journal_category_key) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, nvl(gjcv.description,xu.description) description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, nvl(xxen_util.display_flexfield_context(101,'GL_JE_CATEGORIES',gjcv.context),xu.category_context) category_context, nvl(xxen_util.display_flexfield_value(101,'GL_JE_CATEGORIES',gjcv.context,'ATTRIBUTE1',gjcv.row_id,gjcv.attribute1),xu.category_attribute1) category_attribute1, nvl(xxen_util.display_flexfield_value(101,'GL_JE_CATEGORIES',gjcv.context,'ATTRIBUTE2',gjcv.row_id,gjcv.attribute2),xu.category_attribute2) category_attribute2, nvl(xxen_util.display_flexfield_value(101,'GL_JE_CATEGORIES',gjcv.context,'ATTRIBUTE3',gjcv.row_id,gjcv.attribute3),xu.category_attribute3) category_attribute3, nvl(xxen_util.display_flexfield_value(101,'GL_JE_CATEGORIES',gjcv.context,'ATTRIBUTE4',gjcv.row_id,gjcv.attribute4),xu.category_attribute4) category_attribute4, nvl(xxen_util.display_flexfield_value(101,'GL_JE_CATEGORIES',gjcv.context,'ATTRIBUTE5',gjcv.row_id,gjcv.attribute5),xu.category_attribute5) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 4 row_type_sort, xu.upload_row from ( select xu.* from xxen_gl_setup_upload_5335_u xu where xu.status_code_=xxen_upload.status_success and xu.row_type='Journal Category' ) xu, gl_je_categories_vl gjcv where gjcv.user_je_category_name(+)=xu.journal_category union all select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, nvl(get.encumbrance_type,xu.encumbrance_type) encumbrance_type, nvl(xxen_util.meaning(get.enabled_flag,'YES_NO',0),xu.enabled) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, nvl(get.description,xu.description) description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 5 row_type_sort, xu.upload_row from ( select xu.* from xxen_gl_setup_upload_5335_u xu where xu.status_code_=xxen_upload.status_success and xu.row_type='Encumbrance Type' ) xu, gl_encumbrance_types get where get.encumbrance_type(+)=xu.encumbrance_type union all select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, nvl(fifsv.id_flex_structure_name,xu.chart_of_accounts) chart_of_accounts, nvl(gsau.account_segment_value,xu.account_segment_value) account_segment_value, nvl(gsau.unit_of_measure,xu.unit_of_measure) unit_of_measure, xu.delete_stat_uom, to_char(null) description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 6 row_type_sort, xu.upload_row from ( select xu.*, (select fifsv0.id_flex_num from fnd_id_flex_structures_vl fifsv0 where fifsv0.application_id=101 and fifsv0.id_flex_code='GL#' and fifsv0.id_flex_structure_name=xu.chart_of_accounts) chart_of_accounts_id from xxen_gl_setup_upload_5335_u xu where xu.status_code_=xxen_upload.status_success and xu.row_type='Statistical Unit of Measure' ) xu, --the outer joined tables may reference only one other table before 12c, so the chart of accounts is resolved in the inline view gl_stat_account_uom gsau, fnd_id_flex_structures_vl fifsv where gsau.chart_of_accounts_id(+)=xu.chart_of_accounts_id and gsau.account_segment_value(+)=xu.account_segment_value and fifsv.id_flex_num(+)=gsau.chart_of_accounts_id and fifsv.application_id(+)=101 and fifsv.id_flex_code(+)='GL#' union all select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.row_type, nvl(gl.period_set_name,xu.calendar) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, nvl((select gpt.user_period_type from gl_period_types gpt where gpt.period_type=gl.accounted_period_type),xu.period_type) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, nvl((select fifsv.id_flex_structure_name from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num=gl.chart_of_accounts_id),xu.chart_of_accounts) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, nvl(gl.description,xu.description) description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, nvl(gl.name,xu.ledger_set) ledger_set, nvl(gl.short_name,xu.short_name) short_name, nvl((select gld.name from gl_ledgers gld, gl_access_sets gas where gas.name=gl.name and gas.automatically_created_flag='Y' and gld.ledger_id=gas.default_ledger_id),xu.default_ledger) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 7 row_type_sort, xu.upload_row from xxen_gl_setup_upload_5335_u xu, gl_ledgers gl where xu.status_code_=xxen_upload.status_success and xu.row_type='Ledger Set' and gl.name(+)=xu.ledger_set and gl.object_type_code(+)='S' union all select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, (select fifsv.id_flex_structure_name from fnd_id_flex_structures_vl fifsv, gl_ledgers gls where gls.name=xu.ledger_set and gls.object_type_code='S' and fifsv.id_flex_num=gls.chart_of_accounts_id and fifsv.application_id=101 and fifsv.id_flex_code='GL#') chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, to_char(null) description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, nvl((select gls.name from gl_ledgers gls where gls.name=xu.ledger_set and gls.object_type_code='S'),xu.ledger_set) ledger_set, to_char(null) short_name, to_char(null) default_ledger, nvl((select gl.name from gl_ledgers gl where gl.name=xu.ledger),xu.ledger) ledger, xu.delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 8 row_type_sort, xu.upload_row from xxen_gl_setup_upload_5335_u xu where xu.status_code_=xxen_upload.status_success and xu.row_type='Ledger Set Assignment' union all select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.row_type, nvl((select gas.period_set_name from gl_access_sets gas where gas.name=xu.data_access_set and gas.automatically_created_flag='N'),xu.calendar) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, nvl((select gpt.user_period_type from gl_access_sets gas, gl_period_types gpt where gas.name=xu.data_access_set and gas.automatically_created_flag='N' and gpt.period_type=gas.accounted_period_type),xu.period_type) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, nvl((select xxen_util.meaning(gas.enabled_flag,'YES_NO',0) from gl_access_sets gas where gas.name=xu.data_access_set and gas.automatically_created_flag='N'),xu.enabled) enabled, nvl((select fifsv.id_flex_structure_name from gl_access_sets gas, fnd_id_flex_structures_vl fifsv where gas.name=xu.data_access_set and gas.automatically_created_flag='N' and fifsv.id_flex_num=gas.chart_of_accounts_id and fifsv.application_id=101 and fifsv.id_flex_code='GL#'),xu.chart_of_accounts) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, nvl((select gas.description from gl_access_sets gas where gas.name=xu.data_access_set and gas.automatically_created_flag='N'),xu.description) description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, nvl((select gld.name from gl_access_sets gas, gl_ledgers gld where gas.name=xu.data_access_set and gas.automatically_created_flag='N' and gld.ledger_id=gas.default_ledger_id),xu.default_ledger) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, nvl((select gas.name from gl_access_sets gas where gas.name=xu.data_access_set and gas.automatically_created_flag='N'),xu.data_access_set) data_access_set, nvl((select decode(gas.security_segment_code,'F','Full Ledger','B','Balancing Segment Value','M','Management Segment Value') from gl_access_sets gas where gas.name=xu.data_access_set and gas.automatically_created_flag='N'),xu.access_set_type) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 9 row_type_sort, xu.upload_row from xxen_gl_setup_upload_5335_u xu where xu.status_code_=xxen_upload.status_success and xu.row_type='Data Access Set' union all select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, to_char(null) description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, nvl((select gl.name from gl_ledgers gl where gl.name=xu.ledger and gl.object_type_code='L'),xu.ledger) ledger, xu.delete_assignment, nvl((select gas.name from gl_access_sets gas where gas.name=xu.data_access_set and gas.automatically_created_flag='N'),xu.data_access_set) data_access_set, to_char(null) access_set_type, nvl((select xxen_util.meaning(nvl(gasna.all_segment_value_flag,'N'),'YES_NO',0) from gl_access_set_norm_assign gasna where gasna.access_set_id=(select gas.access_set_id from gl_access_sets gas where gas.name=xu.data_access_set and gas.automatically_created_flag='N') and gasna.ledger_id=(select gl.ledger_id from gl_ledgers gl where gl.name=xu.ledger and gl.object_type_code='L') and nvl(gasna.status_code,'X')<>'D'),xu.all_segment_values) all_segment_values, nvl((select gasna.segment_value from gl_access_set_norm_assign gasna where gasna.access_set_id=(select gas.access_set_id from gl_access_sets gas where gas.name=xu.data_access_set and gas.automatically_created_flag='N') and gasna.ledger_id=(select gl.ledger_id from gl_ledgers gl where gl.name=xu.ledger and gl.object_type_code='L') and nvl(gasna.status_code,'X')<>'D' and gasna.segment_value=xu.segment_value),xu.segment_value) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 10 row_type_sort, xu.upload_row from xxen_gl_setup_upload_5335_u xu where xu.status_code_=xxen_upload.status_success and xu.row_type='Data Access Set Assignment' union all select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.row_type, nvl((select gl.period_set_name from gl_ledgers gl where gl.name=xu.ledger and gl.object_type_code='L'),xu.calendar) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, nvl((select gpt.user_period_type from gl_ledgers gl, gl_period_types gpt where gl.name=xu.ledger and gl.object_type_code='L' and gpt.period_type=gl.accounted_period_type),xu.period_type) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, nvl((select fifsv.id_flex_structure_name from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where gl.name=xu.ledger and gl.object_type_code='L' and fifsv.id_flex_num=gl.chart_of_accounts_id and fifsv.application_id=101 and fifsv.id_flex_code='GL#'),xu.chart_of_accounts) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, nvl((select gl.description from gl_ledgers gl where gl.name=xu.ledger and gl.object_type_code='L'),xu.description) description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, nvl((select gl.short_name from gl_ledgers gl where gl.name=xu.ledger and gl.object_type_code='L'),xu.short_name) short_name, to_char(null) default_ledger, nvl((select gl.name from gl_ledgers gl where gl.name=xu.ledger and gl.object_type_code='L'),xu.ledger) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, nvl((select gcck.concatenated_segments from gl_ledgers gl, gl_code_combinations_kfv gcck where gl.name=xu.ledger and gl.object_type_code='L' and gcck.code_combination_id=gl.ret_earn_code_combination_id),xu.retained_earnings_account) retained_earnings_account, nvl((select xxen_util.meaning(gl.suspense_allowed_flag,'YES_NO',0) from gl_ledgers gl where gl.name=xu.ledger and gl.object_type_code='L'),xu.suspense_allowed) suspense_allowed, nvl((select gcck.concatenated_segments from gl_ledgers gl, gl_code_combinations_kfv gcck where gl.name=xu.ledger and gl.object_type_code='L' and gcck.code_combination_id=gl.rounding_code_combination_id),xu.rounding_account) rounding_account, nvl((select gcck.concatenated_segments from gl_ledgers gl, gl_code_combinations_kfv gcck where gl.name=xu.ledger and gl.object_type_code='L' and gcck.code_combination_id=gl.cum_trans_code_combination_id),xu.cta_account) cta_account, nvl((select gcck.concatenated_segments from gl_ledgers gl, gl_code_combinations_kfv gcck where gl.name=xu.ledger and gl.object_type_code='L' and gcck.code_combination_id=gl.res_encumb_code_combination_id),xu.reserve_encumbrance_account) reserve_encumbrance_account, nvl((select gcck.concatenated_segments from gl_ledgers gl, gl_code_combinations_kfv gcck where gl.name=xu.ledger and gl.object_type_code='L' and gcck.code_combination_id=gl.net_income_code_combination_id),xu.net_income_account) net_income_account, nvl((select xxen_util.meaning(gl.enable_average_balances_flag,'YES_NO',0) from gl_ledgers gl where gl.name=xu.ledger and gl.object_type_code='L'),xu.enable_average_balances) enable_average_balances, nvl((select xxen_util.meaning(gl.translate_eod_flag,'YES_NO',0) from gl_ledgers gl where gl.name=xu.ledger and gl.object_type_code='L'),xu.translate_eod) translate_eod, nvl((select xxen_util.meaning(gl.translate_qatd_flag,'YES_NO',0) from gl_ledgers gl where gl.name=xu.ledger and gl.object_type_code='L'),xu.translate_qatd) translate_qatd, nvl((select xxen_util.meaning(gl.translate_yatd_flag,'YES_NO',0) from gl_ledgers gl where gl.name=xu.ledger and gl.object_type_code='L'),xu.translate_yatd) translate_yatd, nvl((select xxen_util.meaning(gl.enable_budgetary_control_flag,'YES_NO',0) from gl_ledgers gl where gl.name=xu.ledger and gl.object_type_code='L'),xu.enable_budgetary_control) enable_budgetary_control, nvl((select xxen_util.meaning(gl.require_budget_journals_flag,'YES_NO',0) from gl_ledgers gl where gl.name=xu.ledger and gl.object_type_code='L'),xu.require_budget_journals) require_budget_journals, nvl((select xxen_util.meaning(gl.enable_je_approval_flag,'YES_NO',0) from gl_ledgers gl where gl.name=xu.ledger and gl.object_type_code='L'),xu.enable_journal_approval) enable_journal_approval, nvl((select xxen_util.meaning(gl.enable_automatic_tax_flag,'YES_NO',0) from gl_ledgers gl where gl.name=xu.ledger and gl.object_type_code='L'),xu.enable_automatic_tax) enable_automatic_tax, nvl((select xxen_util.meaning(gl.consolidation_ledger_flag,'YES_NO',0) from gl_ledgers gl where gl.name=xu.ledger and gl.object_type_code='L'),xu.consolidation_ledger) consolidation_ledger, nvl((select gl.future_enterable_periods_limit from gl_ledgers gl where gl.name=xu.ledger and gl.object_type_code='L'),xu.future_enterable_periods) future_enterable_periods, nvl((select gtc.name from gl_ledgers gl, gl_transaction_calendar gtc where gl.name=xu.ledger and gl.object_type_code='L' and gtc.transaction_calendar_id=gl.transaction_calendar_id),xu.transaction_calendar) transaction_calendar, nvl((select gl.daily_translation_rate_type from gl_ledgers gl where gl.name=xu.ledger and gl.object_type_code='L'),xu.daily_rate_type) daily_rate_type, nvl((select gl.period_average_rate_type from gl_ledgers gl where gl.name=xu.ledger and gl.object_type_code='L'),xu.period_average_rate_type) period_average_rate_type, nvl((select gl.period_end_rate_type from gl_ledgers gl where gl.name=xu.ledger and gl.object_type_code='L'),xu.period_end_rate_type) period_end_rate_type, nvl((select xxen_util.meaning(gl.enable_reconciliation_flag,'YES_NO',0) from gl_ledgers gl where gl.name=xu.ledger and gl.object_type_code='L'),xu.enable_reconciliation) enable_reconciliation, nvl((select xxen_util.meaning(gl.net_closing_bal_flag,'YES_NO',0) from gl_ledgers gl where gl.name=xu.ledger and gl.object_type_code='L'),xu.net_closing_balance) net_closing_balance, nvl((select gacs.criteria_set_name from gl_ledgers gl, gl_autorev_criteria_sets gacs where gl.name=xu.ledger and gl.object_type_code='L' and gacs.criteria_set_id=gl.criteria_set_id),xu.criteria_set) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 11 row_type_sort, xu.upload_row from xxen_gl_setup_upload_5335_u xu where xu.status_code_=xxen_upload.status_success and xu.row_type='Ledger' union all select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, nvl((select gacs.criteria_set_desc from gl_autorev_criteria_sets gacs where gacs.criteria_set_name=xu.criteria_set),xu.description) description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, nvl((select gacs.criteria_set_name from gl_autorev_criteria_sets gacs where gacs.criteria_set_name=xu.criteria_set),xu.criteria_set) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, xu.delete_option, 12 row_type_sort, xu.upload_row from xxen_gl_setup_upload_5335_u xu where xu.status_code_=xxen_upload.status_success and xu.row_type='AutoReverse Criteria Set' union all select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, nvl((select gjcv.user_je_category_name from gl_je_categories_vl gjcv where gjcv.user_je_category_name=xu.journal_category),xu.journal_category) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, to_char(null) description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, nvl((select gacs.criteria_set_name from gl_autorev_criteria_sets gacs where gacs.criteria_set_name=xu.criteria_set),xu.criteria_set) criteria_set, nvl((select xxen_util.meaning(gao.method_code,'REVERSAL_OPTION_CODE',101) from gl_autoreverse_options gao where gao.criteria_set_id=(select gacs.criteria_set_id from gl_autorev_criteria_sets gacs where gacs.criteria_set_name=xu.criteria_set) and gao.je_category_name=(select gjcv.je_category_name from gl_je_categories_vl gjcv where gjcv.user_je_category_name=xu.journal_category)),xu.reversal_method) reversal_method, nvl((select decode(gao.reversal_period_code,'NO_DEFAULT','No Default','SAME_PERIOD','Same Period','NEXT_PERIOD','Next Period','NEXT_NON_ADJ_PERIOD','Next Non Adjusting Period') from gl_autoreverse_options gao where gao.criteria_set_id=(select gacs.criteria_set_id from gl_autorev_criteria_sets gacs where gacs.criteria_set_name=xu.criteria_set) and gao.je_category_name=(select gjcv.je_category_name from gl_je_categories_vl gjcv where gjcv.user_je_category_name=xu.journal_category)),xu.reversal_period) reversal_period, nvl((select xxen_util.meaning(gao.reversal_date_code,'AUTOREVERSE_DATE_RULE',0) from gl_autoreverse_options gao where gao.criteria_set_id=(select gacs.criteria_set_id from gl_autorev_criteria_sets gacs where gacs.criteria_set_name=xu.criteria_set) and gao.je_category_name=(select gjcv.je_category_name from gl_je_categories_vl gjcv where gjcv.user_je_category_name=xu.journal_category)),xu.reversal_date) reversal_date, nvl((select xxen_util.meaning(gao.autoreverse_flag,'YES_NO',0) from gl_autoreverse_options gao where gao.criteria_set_id=(select gacs.criteria_set_id from gl_autorev_criteria_sets gacs where gacs.criteria_set_name=xu.criteria_set) and gao.je_category_name=(select gjcv.je_category_name from gl_je_categories_vl gjcv where gjcv.user_je_category_name=xu.journal_category)),xu.autoreverse) autoreverse, nvl((select xxen_util.meaning(gao.autopost_reversal_flag,'YES_NO',0) from gl_autoreverse_options gao where gao.criteria_set_id=(select gacs.criteria_set_id from gl_autorev_criteria_sets gacs where gacs.criteria_set_name=xu.criteria_set) and gao.je_category_name=(select gjcv.je_category_name from gl_je_categories_vl gjcv where gjcv.user_je_category_name=xu.journal_category)),xu.autopost_reversal) autopost_reversal, to_char(null) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, to_char(null) delete_option, 13 row_type_sort, xu.upload_row from xxen_gl_setup_upload_5335_u xu where xu.status_code_=xxen_upload.status_success and xu.row_type='AutoReverse Option' union all select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.row_type, nvl((select gaps.period_set_name from gl_automatic_posting_sets gaps where gaps.autopost_set_name=xu.autopost_set),xu.calendar) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, nvl((select gpt.user_period_type from gl_automatic_posting_sets gaps, gl_period_types gpt where gaps.autopost_set_name=xu.autopost_set and gpt.period_type=gaps.accounted_period_type),xu.period_type) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, to_char(null) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, to_char(null) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, to_char(null) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, nvl((select xxen_util.meaning(gaps.enabled_flag,'YES_NO',0) from gl_automatic_posting_sets gaps where gaps.autopost_set_name=xu.autopost_set),xu.enabled) enabled, nvl((select fifsv.id_flex_structure_name from gl_automatic_posting_sets gaps, fnd_id_flex_structures_vl fifsv where gaps.autopost_set_name=xu.autopost_set and fifsv.id_flex_num=gaps.chart_of_accounts_id and fifsv.application_id=101 and fifsv.id_flex_code='GL#'),xu.chart_of_accounts) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, nvl((select gaps.description from gl_automatic_posting_sets gaps where gaps.autopost_set_name=xu.autopost_set),xu.description) description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, to_char(null) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, nvl((select gaps.autopost_set_name from gl_automatic_posting_sets gaps where gaps.autopost_set_name=xu.autopost_set),xu.autopost_set) autopost_set, nvl((select xxen_util.meaning(gaps.submit_all_priorities_flag,'YES_NO',0) from gl_automatic_posting_sets gaps where gaps.autopost_set_name=xu.autopost_set),xu.submit_all_priorities) submit_all_priorities, nvl((select gaps.num_of_priority_options from gl_automatic_posting_sets gaps where gaps.autopost_set_name=xu.autopost_set),xu.number_of_priorities) number_of_priorities, nvl((select gaps.effective_days_before from gl_automatic_posting_sets gaps where gaps.autopost_set_name=xu.autopost_set),xu.effective_days_before) effective_days_before, nvl((select gaps.effective_days_after from gl_automatic_posting_sets gaps where gaps.autopost_set_name=xu.autopost_set),xu.effective_days_after) effective_days_after, to_number(null) posting_priority, to_char(null) balance_type, xu.delete_option, 14 row_type_sort, xu.upload_row from xxen_gl_setup_upload_5335_u xu where xu.status_code_=xxen_upload.status_success and xu.row_type='AutoPost Set' union all select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.row_type, to_char(null) calendar, to_char(null) calendar_description, to_char(null) enable_security, to_char(null) period_prefix, to_char(null) period_type, to_number(null) period_year, to_number(null) quarter, to_number(null) period_num, to_date(null) start_date, to_date(null) end_date, nvl((select gapo.period_name from gl_automatic_posting_options gapo where gapo.autopost_set_id=(select gaps.autopost_set_id from gl_automatic_posting_sets gaps where gaps.autopost_set_name=xu.autopost_set) and gapo.posting_priority=xu.posting_priority),xu.period_name) period_name, to_char(null) adjustment_period, to_char(null) period_description, to_char(null) delete_period, to_number(null) periods_per_year, to_char(null) year_type_in_name, nvl((select decode(gapo.je_source_name,'ALL','ALL',(select gjsv.user_je_source_name from gl_je_sources_vl gjsv where gjsv.je_source_name=gapo.je_source_name)) from gl_automatic_posting_options gapo where gapo.autopost_set_id=(select gaps.autopost_set_id from gl_automatic_posting_sets gaps where gaps.autopost_set_name=xu.autopost_set) and gapo.posting_priority=xu.posting_priority),xu.journal_source) journal_source, to_char(null) journal_source_key, to_char(null) import_journal_references, to_char(null) require_journal_approval, to_char(null) import_using_key, to_char(null) freeze_journals, to_char(null) effective_date_rule, nvl((select decode(gapo.je_category_name,'ALL','ALL',(select gjcv.user_je_category_name from gl_je_categories_vl gjcv where gjcv.je_category_name=gapo.je_category_name)) from gl_automatic_posting_options gapo where gapo.autopost_set_id=(select gaps.autopost_set_id from gl_automatic_posting_sets gaps where gaps.autopost_set_name=xu.autopost_set) and gapo.posting_priority=xu.posting_priority),xu.journal_category) journal_category, to_char(null) journal_category_key, to_char(null) encumbrance_type, to_char(null) enabled, to_char(null) chart_of_accounts, to_char(null) account_segment_value, to_char(null) unit_of_measure, to_char(null) delete_stat_uom, to_char(null) description, to_char(null) period_type_context, to_char(null) period_type_attribute1, to_char(null) period_type_attribute2, to_char(null) period_type_attribute3, to_char(null) period_type_attribute4, to_char(null) period_type_attribute5, to_char(null) period_context, to_char(null) period_attribute1, to_char(null) period_attribute2, to_char(null) period_attribute3, to_char(null) period_attribute4, to_char(null) period_attribute5, to_char(null) period_attribute6, to_char(null) period_attribute7, to_char(null) period_attribute8, to_char(null) source_context, to_char(null) source_attribute1, to_char(null) source_attribute2, to_char(null) source_attribute3, to_char(null) source_attribute4, to_char(null) source_attribute5, to_char(null) category_context, to_char(null) category_attribute1, to_char(null) category_attribute2, to_char(null) category_attribute3, to_char(null) category_attribute4, to_char(null) category_attribute5, to_char(null) ledger_set, to_char(null) short_name, to_char(null) default_ledger, nvl((select decode(gapo.ledger_id,-1234567890,'ALL',(select gl.name from gl_ledgers gl where gl.ledger_id=gapo.ledger_id)) from gl_automatic_posting_options gapo where gapo.autopost_set_id=(select gaps.autopost_set_id from gl_automatic_posting_sets gaps where gaps.autopost_set_name=xu.autopost_set) and gapo.posting_priority=xu.posting_priority),xu.ledger) ledger, to_char(null) delete_assignment, to_char(null) data_access_set, to_char(null) access_set_type, to_char(null) all_segment_values, to_char(null) segment_value, to_char(null) retained_earnings_account, to_char(null) suspense_allowed, to_char(null) rounding_account, to_char(null) cta_account, to_char(null) reserve_encumbrance_account, to_char(null) net_income_account, to_char(null) enable_average_balances, to_char(null) translate_eod, to_char(null) translate_qatd, to_char(null) translate_yatd, to_char(null) enable_budgetary_control, to_char(null) require_budget_journals, to_char(null) enable_journal_approval, to_char(null) enable_automatic_tax, to_char(null) consolidation_ledger, to_number(null) future_enterable_periods, to_char(null) transaction_calendar, to_char(null) daily_rate_type, to_char(null) period_average_rate_type, to_char(null) period_end_rate_type, to_char(null) enable_reconciliation, to_char(null) net_closing_balance, to_char(null) criteria_set, to_char(null) reversal_method, to_char(null) reversal_period, to_char(null) reversal_date, to_char(null) autoreverse, to_char(null) autopost_reversal, nvl((select gaps.autopost_set_name from gl_automatic_posting_sets gaps where gaps.autopost_set_name=xu.autopost_set),xu.autopost_set) autopost_set, to_char(null) submit_all_priorities, to_number(null) number_of_priorities, to_number(null) effective_days_before, to_number(null) effective_days_after, nvl((select gapo.posting_priority from gl_automatic_posting_options gapo where gapo.autopost_set_id=(select gaps.autopost_set_id from gl_automatic_posting_sets gaps where gaps.autopost_set_name=xu.autopost_set) and gapo.posting_priority=xu.posting_priority),xu.posting_priority) posting_priority, nvl((select (select flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='BATCH_TYPE_ALL' and flvv.security_group_id=0 and flvv.lookup_code=gapo.actual_flag) from gl_automatic_posting_options gapo where gapo.autopost_set_id=(select gaps.autopost_set_id from gl_automatic_posting_sets gaps where gaps.autopost_set_name=xu.autopost_set) and gapo.posting_priority=xu.posting_priority),xu.balance_type) balance_type, xu.delete_option, 15 row_type_sort, xu.upload_row from xxen_gl_setup_upload_5335_u xu where xu.status_code_=xxen_upload.status_success and xu.row_type='AutoPost Option'