ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB879D2E0530100007F1FF2 GL Ledger Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and 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(+)) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name AR دفاتر الأستاذ المقيدة بمجموعة الوصول ، المحددة بواسطة قيمة الملف الشخصي "مجموعة الوصول إلى بيانات GL" لمسؤولية تسجيل الدخول الحالية D Ledger, die durch das Zugriffsset eingeschränkt sind, definiert durch den Profilwert 'GL Data Access Set' der aktuellen Anmeldeverantwortung E Libros restringidos por el conjunto de acceso, definido por el valor del perfil "Conjunto de acceso a datos GL" de la responsabilidad de inicio de sesión actual F Grands livres limités par un ensemble d'accès, défini par la valeur du profil "GL Data Access Set" de la responsabilité de connexion actuelle I Libri mastri limitati dal set di accesso, definito dal valore del profilo 'GL Data Access Set' della responsabilità di login corrente JA 現在のログイン責任者のプロファイル値'GL Data Access Set'によって定義されたアクセスセットによって制限された元帳 KO 현재 로그인 권한의 프로파일 값 'GL 데이터 액세스 세트'로 정의 된 액세스 세트로 제한되는 원장 PTB Ledgers restritos pelo conjunto de acesso, definido pelo valor do perfil 'GL Data Access Set' da atual responsabilidade de login RU Леджеры, ограниченные набором доступа, определяемые значением профиля "GL Data Access Set" текущей ответственности за вход в систему S Ledgers begränsade av åtkomstuppsättning, definierade av profilvärde 'GL Data Access Set' för det aktuella inloggningsansvaret TR Mevcut oturum açma sorumluluğunun profil değeri 'GL Veri Erişim Kümesi' ile tanımlanan erişim kümesiyle kısıtlanmış defterler US Ledgers restricted by access set, defined by profile value 'GL Data Access Set' of the current login responsibility ZHS 由访问集限制的分类账，由当前登录责任的配置文件值 "GL数据访问集 "定义。 22C50854A7A70C17E0630100007FC09A select to_char(null) action_, to_char(null) status_, to_char(null) message_, null modified_columns_, to_char(null) summary_row_id, to_char(null) summary_bc_row_id, to_number(null) template_id_, to_char(null) request_id_, to_char(null) request_log, gst.template_name, to_char(null) add_or_delete, gst.description, gst.start_actuals_period_name earliest_period, gl.name ledger, gst.segment1_type gl_segment1, gst.segment2_type gl_segment2, gst.segment3_type gl_segment3, gst.segment4_type gl_segment4, gst.segment5_type gl_segment5, gst.segment6_type gl_segment6, gst.segment7_type gl_segment7, gst.segment8_type gl_segment8, gst.segment9_type gl_segment9, gst.segment10_type gl_segment10, gst.segment11_type gl_segment11, gst.segment12_type gl_segment12, gst.segment13_type gl_segment13, gst.segment14_type gl_segment14, gst.segment15_type gl_segment15, gst.segment16_type gl_segment16, gst.segment17_type gl_segment17, gst.segment18_type gl_segment18, gst.segment19_type gl_segment19, gst.segment20_type gl_segment20, gst.segment21_type gl_segment21, gst.segment22_type gl_segment22, gst.segment23_type gl_segment23, gst.segment24_type gl_segment24, gst.segment25_type gl_segment25, gst.segment26_type gl_segment26, gst.segment27_type gl_segment27, gst.segment28_type gl_segment28, gst.segment29_type gl_segment29, gst.segment30_type gl_segment30, gst.concatenated_description, flvv1.meaning funds_check_level, flvv2.description debit_or_credit, flvv3.description amount_type, flvv4.meaning boundary, gbrjv.budget_name funding_budget from gl_summary_templates gst, gl_summary_bc_options gsbo, fnd_lookup_values_vl flvv1, fnd_lookup_values_vl flvv2, fnd_lookup_values_vl flvv3, fnd_lookup_values_vl flvv4, gl_budgets_require_journals_v gbrjv, gl_ledgers gl where 1=1 and gst.status='F' and gl.ledger_id=gst.ledger_id and gst.template_id=gsbo.template_id(+) and gsbo.funding_budget_version_id=gbrjv.budget_version_id(+) and gl.ledger_id=gbrjv.ledger_id(+) and gsbo.funds_check_level_code=flvv1.lookup_code(+) and flvv1.lookup_type(+)='FUNDS_CHECK_LEVEL' and gsbo.dr_cr_code=flvv2.lookup_code(+) and flvv2.lookup_type(+)='DR_CR' and gsbo.amount_type=flvv3.lookup_code(+) and flvv3.lookup_type(+)='PTD_YTD' and gsbo.boundary_code=flvv4.lookup_code(+) and flvv4.lookup_type(+)='BOUNDARY_TYPE' Y U A xxen_gl_upload.add_delete_summary_templates xxen_gl_upload.validate_account_segments( p_action=>:$column$.action_, p_ledger=>:$flex$.ledger, gl_segment1=>:$column$.gl_segment1, gl_segment2=>:$column$.gl_segment2, gl_segment3=>:$column$.gl_segment3, gl_segment4=>:$column$.gl_segment4, gl_segment5=>:$column$.gl_segment5, gl_segment6=>:$column$.gl_segment6, gl_segment7=>:$column$.gl_segment7, gl_segment8=>:$column$.gl_segment8, gl_segment9=>:$column$.gl_segment9, gl_segment10=>:$column$.gl_segment10, p_cross_validation=>'N' ) US GL Summary Account Upload This upload can be used to import Summary Account Templates. Enginatics R12 only Upload 1=1 1 -40 1=1 :segment_delimiter=:segment_delimiter Char select fifsv.concatenated_segment_delimiter from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where gl.name=:$flex$.ledger and fifsv.id_flex_num=gl.chart_of_accounts_id and fifsv.application_id=101 and fifsv.id_flex_code='GL#' US Segment Delimiter 2 10 1=1 gl.name=:ledger LOV GL Ledger 8E2FF36EDEB879D2E0530100007F1FF2 Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and 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(+)) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name Y US Ledger :$flex$.ledger Ledger Segment Delimiter Default SYSADMIN 3 ADD_OR_DELETE 19 AMOUNT_TYPE 20 BOUNDARY 16 CONCATENATED_DESCRIPTION 18 DEBIT_OR_CREDIT 4 DESCRIPTION 5 EARLIEST_PERIOD 21 FUNDING_BUDGET 17 FUNDS_CHECK_LEVEL 6 GL_SEGMENT1 15 GL_SEGMENT10 7 GL_SEGMENT2 8 GL_SEGMENT3 9 GL_SEGMENT4 10 GL_SEGMENT5 11 GL_SEGMENT6 12 GL_SEGMENT7 13 GL_SEGMENT8 14 GL_SEGMENT9 -3.0004 PERIOD_NAME 1 REQUEST_LOG -.0002 REQUEST_OUTPUT 2 TEMPLATE_NAME Ledger Vision Operations (USA) S Site SYSADMIN Default ENGINATICS Default 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 SUMMARY_ROW_ID Char varchar2 Y 6 SUMMARY_BC_ROW_ID Char varchar2 Y 7 TEMPLATE_ID_ Number number Y 8 REQUEST_ID_ Char varchar2 Y 9 REQUEST_LOG Char varchar2 10 TEMPLATE_NAME Char varchar2 Y Y 11 ADD_OR_DELETE LOV custom varchar2 Y select 'A' id, 'Add' value, null description from dual union all select 'D' id, 'Delete' value, null description from dual Add Y 12 DESCRIPTION Char varchar2 Y 13 EARLIEST_PERIOD LOV custom varchar2 Y select gps.period_name value, null description from gl_period_statuses gps, gl_ledgers gl where gps.application_id=101 and gps.ledger_id=gl.ledger_id and gl.name=:$flex$.ledger order by gps.start_date desc Y Y 14 LEDGER Char varchar2 :$flex$.ledger Y Y 15 GL_SEGMENT1 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT1' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 16 GL_SEGMENT2 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT2' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 17 GL_SEGMENT3 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT3' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 18 GL_SEGMENT4 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT4' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 19 GL_SEGMENT5 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT5' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 20 GL_SEGMENT6 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT6' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 21 GL_SEGMENT7 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT7' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 22 GL_SEGMENT8 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT8' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 23 GL_SEGMENT9 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT9' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 24 GL_SEGMENT10 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT10' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 25 GL_SEGMENT11 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT11' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 26 GL_SEGMENT12 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT12' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 27 GL_SEGMENT13 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT13' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 28 GL_SEGMENT14 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT14' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 29 GL_SEGMENT15 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT15' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 30 GL_SEGMENT16 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT16' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 31 GL_SEGMENT17 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT17' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 32 GL_SEGMENT18 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT18' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 33 GL_SEGMENT19 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT19' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 34 GL_SEGMENT20 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT20' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 35 GL_SEGMENT21 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT21' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 36 GL_SEGMENT22 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT22' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 37 GL_SEGMENT23 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT23' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 38 GL_SEGMENT24 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT24' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 39 GL_SEGMENT25 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT25' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 40 GL_SEGMENT26 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT26' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 41 GL_SEGMENT27 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT27' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 42 GL_SEGMENT28 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT28' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 43 GL_SEGMENT29 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT29' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 44 GL_SEGMENT30 LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvv.flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_name='GL_ROLLUP_GROUP_VALUE_SET' union select ffh.hierarchy_name value, ffh.description from fnd_id_flex_segments fifs, gl_ledgers gl, fnd_flex_hierarchies_vl ffh where fifs.id_flex_code='GL#' and gl.name=:$column$.ledger and fifs.application_column_name='SEGMENT30' and gl.chart_of_accounts_id=fifs.id_flex_num and ffh.flex_value_set_id=fifs.flex_value_set_id order by value Y 45 CONCATENATED_DESCRIPTION Char varchar2 select rtrim(case when :$column$.gl_segment1 is not null then :$column$.gl_segment1||:$flex$.segment_delimiter end|| case when :$column$.gl_segment2 is not null then :$column$.gl_segment2||:$flex$.segment_delimiter end|| case when :$column$.gl_segment3 is not null then :$column$.gl_segment3||:$flex$.segment_delimiter end|| case when :$column$.gl_segment4 is not null then :$column$.gl_segment4||:$flex$.segment_delimiter end|| case when :$column$.gl_segment5 is not null then :$column$.gl_segment5||:$flex$.segment_delimiter end|| case when :$column$.gl_segment6 is not null then :$column$.gl_segment6||:$flex$.segment_delimiter end|| case when :$column$.gl_segment7 is not null then :$column$.gl_segment7||:$flex$.segment_delimiter end|| case when :$column$.gl_segment8 is not null then :$column$.gl_segment8||:$flex$.segment_delimiter end|| case when :$column$.gl_segment9 is not null then :$column$.gl_segment9||:$flex$.segment_delimiter end|| case when :$column$.gl_segment10 is not null then :$column$.gl_segment10||:$flex$.segment_delimiter end|| case when :$column$.gl_segment11 is not null then :$column$.gl_segment11||:$flex$.segment_delimiter end|| case when :$column$.gl_segment12 is not null then :$column$.gl_segment12||:$flex$.segment_delimiter end|| case when :$column$.gl_segment13 is not null then :$column$.gl_segment13||:$flex$.segment_delimiter end|| case when :$column$.gl_segment14 is not null then :$column$.gl_segment14||:$flex$.segment_delimiter end|| case when :$column$.gl_segment15 is not null then :$column$.gl_segment15||:$flex$.segment_delimiter end|| case when :$column$.gl_segment16 is not null then :$column$.gl_segment16||:$flex$.segment_delimiter end|| case when :$column$.gl_segment17 is not null then :$column$.gl_segment17||:$flex$.segment_delimiter end|| case when :$column$.gl_segment18 is not null then :$column$.gl_segment18||:$flex$.segment_delimiter end|| case when :$column$.gl_segment19 is not null then :$column$.gl_segment19||:$flex$.segment_delimiter end|| case when :$column$.gl_segment20 is not null then :$column$.gl_segment20||:$flex$.segment_delimiter end|| case when :$column$.gl_segment21 is not null then :$column$.gl_segment21||:$flex$.segment_delimiter end|| case when :$column$.gl_segment22 is not null then :$column$.gl_segment22||:$flex$.segment_delimiter end|| case when :$column$.gl_segment23 is not null then :$column$.gl_segment23||:$flex$.segment_delimiter end|| case when :$column$.gl_segment24 is not null then :$column$.gl_segment24||:$flex$.segment_delimiter end|| case when :$column$.gl_segment25 is not null then :$column$.gl_segment25||:$flex$.segment_delimiter end|| case when :$column$.gl_segment26 is not null then :$column$.gl_segment26||:$flex$.segment_delimiter end|| case when :$column$.gl_segment27 is not null then :$column$.gl_segment27||:$flex$.segment_delimiter end|| case when :$column$.gl_segment28 is not null then :$column$.gl_segment28||:$flex$.segment_delimiter end|| case when :$column$.gl_segment29 is not null then :$column$.gl_segment29||:$flex$.segment_delimiter end|| case when :$column$.gl_segment30 is not null then :$column$.gl_segment30||:$flex$.segment_delimiter end, :$flex$.segment_delimiter) from dual Y Y 46 FUNDS_CHECK_LEVEL LOV custom varchar2 Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='FUNDS_CHECK_LEVEL' Y 47 DEBIT_OR_CREDIT LOV custom varchar2 Y select flvv.description value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='DR_CR' Y 48 AMOUNT_TYPE LOV custom varchar2 Y select flvv.description value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='PTD_YTD' Y 49 BOUNDARY LOV custom varchar2 Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='BOUNDARY_TYPE' Y 50 FUNDING_BUDGET LOV custom varchar2 Y select gbrjv.budget_name value, null description from gl_budgets_require_journals_v gbrjv, gl_ledgers gl where gl.ledger_id=gbrjv.ledger_id and gl.name=:$flex$.ledger Y U 2 p_template_name in Char TEMPLATE_NAME U 3 p_period_name in Char EARLIEST_PERIOD U 4 p_description in Char DESCRIPTION U 5 p_ledger in Char LEDGER U 6 p_add_or_delete in Char ADD_OR_DELETE U 7 p_concatenated_description in Char CONCATENATED_DESCRIPTION U 8 p_segment1_type in Char GL_SEGMENT1 U 9 p_segment2_type in Char GL_SEGMENT2 U 10 p_segment3_type in Char GL_SEGMENT3 U 11 p_segment4_type in Char GL_SEGMENT4 U 12 p_segment5_type in Char GL_SEGMENT5 U 13 p_segment6_type in Char GL_SEGMENT6 U 14 p_segment7_type in Char GL_SEGMENT7 U 15 p_segment8_type in Char GL_SEGMENT8 U 16 p_segment9_type in Char GL_SEGMENT9 U 17 p_segment10_type in Char GL_SEGMENT10 U 18 p_segment11_type in Char GL_SEGMENT11 U 19 p_segment12_type in Char GL_SEGMENT12 U 20 p_segment13_type in Char GL_SEGMENT13 U 21 p_segment14_type in Char GL_SEGMENT14 U 22 p_segment15_type in Char GL_SEGMENT15 U 23 p_segment16_type in Char GL_SEGMENT16 U 24 p_segment17_type in Char GL_SEGMENT17 U 25 p_segment18_type in Char GL_SEGMENT18 U 26 p_segment19_type in Char GL_SEGMENT19 U 27 p_segment20_type in Char GL_SEGMENT20 U 28 p_segment21_type in Char GL_SEGMENT21 U 29 p_segment22_type in Char GL_SEGMENT22 U 30 p_segment23_type in Char GL_SEGMENT23 U 31 p_segment24_type in Char GL_SEGMENT24 U 32 p_segment25_type in Char GL_SEGMENT25 U 33 p_segment26_type in Char GL_SEGMENT26 U 34 p_segment27_type in Char GL_SEGMENT27 U 35 p_segment28_type in Char GL_SEGMENT28 U 36 p_segment29_type in Char GL_SEGMENT29 U 37 p_segment30_type in Char GL_SEGMENT30 U 38 p_context in Char U 39 p_attribute1 in Char U 40 p_attribute2 in Char U 41 p_attribute3 in Char U 42 p_attribute4 in Char U 43 p_attribute5 in Char U 44 p_attribute6 in Char U 45 p_attribute7 in Char U 46 p_attribute8 in Char U 47 p_funds_check_level in Char FUNDS_CHECK_LEVEL U 48 p_debit_or_credit in Char DEBIT_OR_CREDIT U 49 p_amount_type in Char AMOUNT_TYPE U 50 p_boundary in Char BOUNDARY U 51 p_funding_budget in Char FUNDING_BUDGET U 52 p_summary_row_id in/out Char SUMMARY_ROW_ID U 53 p_summary_bc_row_id out Char SUMMARY_BC_ROW_ID U 54 request_id_ out Char REQUEST_ID_ U 55 template_id out Number TEMPLATE_ID_ U 56 status_ out Char STATUS_CODE_ U 57 message_ out Char MESSAGE_ Error SQL select xxen_upload.action_meaning(xu.action_code_) action_, xxen_upload.status_meaning(xxen_upload.status_error) status_, xu.message_, xu.modified_columns_, xu.summary_row_id, xu.summary_bc_row_id, xu.template_id_, xu.request_id_, case when xu.request_id_ is not null then 'HYPERLINK("'||xxen_util.concurrent_request_file_url('L',xu.request_id_)||'")' end request_log, xu.template_name, xu.add_or_delete, xu.description, xu.earliest_period, xu.ledger, xu.gl_segment1, xu.gl_segment2, xu.gl_segment3, xu.gl_segment4, xu.gl_segment5, xu.gl_segment6, xu.gl_segment7, xu.gl_segment8, xu.gl_segment9, xu.gl_segment10, xu.gl_segment11, xu.gl_segment12, xu.gl_segment13, xu.gl_segment14, xu.gl_segment15, xu.gl_segment16, xu.gl_segment17, xu.gl_segment18, xu.gl_segment19, xu.gl_segment20, xu.gl_segment21, xu.gl_segment22, xu.gl_segment23, xu.gl_segment24, xu.gl_segment25, xu.gl_segment26, xu.gl_segment27, xu.gl_segment28, xu.gl_segment29, xu.gl_segment30, xu.concatenated_description, xu.funds_check_level, xu.debit_or_credit, xu.amount_type, xu.boundary, xu.funding_budget from xxen_gl_summary_account_8144_u xu where xu.status_code_=xxen_upload.status_error or exists(select 1 from gl_summary_templates gst where gst.status<>'F' and gst.template_id=xu.template_id_) Success SQL select xxen_upload.action_meaning(xu.action_code_) action_, xxen_upload.status_meaning(xxen_upload.status_success) status_, xu.message_, xu.modified_columns_, to_char(null) summary_row_id, to_char(null) summary_bc_row_id, gst.template_id, xu.request_id_, case when xu.request_id_ is not null then 'HYPERLINK("'||xxen_util.concurrent_request_file_url('L',xu.request_id_)||'")' end request_log, nvl(gst.template_name,xu.template_name), null add_or_delete, nvl(gst.description,xu.description), nvl(gst.start_actuals_period_name,xu.earliest_period) earliest_period, nvl(gl.name,xu.ledger) ledger, nvl(gst.segment1_type,xu.gl_segment1) gl_segment1, nvl(gst.segment2_type,xu.gl_segment2) gl_segment2, nvl(gst.segment3_type,xu.gl_segment3) gl_segment3, nvl(gst.segment4_type,xu.gl_segment4) gl_segment4, nvl(gst.segment5_type,xu.gl_segment5) gl_segment5, nvl(gst.segment6_type,xu.gl_segment6) gl_segment6, nvl(gst.segment7_type,xu.gl_segment7) gl_segment7, nvl(gst.segment8_type,xu.gl_segment8) gl_segment8, nvl(gst.segment9_type,xu.gl_segment9) gl_segment9, nvl(gst.segment10_type,xu.gl_segment10) gl_segment10, nvl(gst.segment11_type,xu.gl_segment11) gl_segment11, nvl(gst.segment12_type,xu.gl_segment12) gl_segment12, nvl(gst.segment13_type,xu.gl_segment13) gl_segment13, nvl(gst.segment14_type,xu.gl_segment14) gl_segment14, nvl(gst.segment15_type,xu.gl_segment15) gl_segment15, nvl(gst.segment16_type,xu.gl_segment16) gl_segment16, nvl(gst.segment17_type,xu.gl_segment17) gl_segment17, nvl(gst.segment18_type,xu.gl_segment18) gl_segment18, nvl(gst.segment19_type,xu.gl_segment19) gl_segment19, nvl(gst.segment20_type,xu.gl_segment20) gl_segment20, nvl(gst.segment21_type,xu.gl_segment21) gl_segment21, nvl(gst.segment22_type,xu.gl_segment22) gl_segment22, nvl(gst.segment23_type,xu.gl_segment23) gl_segment23, nvl(gst.segment24_type,xu.gl_segment24) gl_segment24, nvl(gst.segment25_type,xu.gl_segment25) gl_segment25, nvl(gst.segment26_type,xu.gl_segment26) gl_segment26, nvl(gst.segment27_type,xu.gl_segment27) gl_segment27, nvl(gst.segment28_type,xu.gl_segment28) gl_segment28, nvl(gst.segment29_type,xu.gl_segment29) gl_segment29, nvl(gst.segment30_type,xu.gl_segment30) gl_segment30, nvl(gst.concatenated_description,xu.concatenated_description) concatenated_description, nvl(flvv1.meaning,xu.funds_check_level) funds_check_level, nvl(flvv2.description,xu.debit_or_credit) debit_or_credit, nvl(flvv3.description,xu.amount_type) amount_type, nvl(flvv4.meaning,xu.boundary) boundary, nvl(gbrjv.budget_name,xu.funding_budget) funding_budget from xxen_gl_summary_account_8144_u xu, gl_summary_templates gst, gl_summary_bc_options gsbo, fnd_lookup_values_vl flvv1, fnd_lookup_values_vl flvv2, fnd_lookup_values_vl flvv3, fnd_lookup_values_vl flvv4, gl_budgets_require_journals_v gbrjv, gl_ledgers gl where xu.template_id_=gst.template_id(+) and xu.status_code_=xxen_upload.status_success and gst.status(+)='F' and gl.ledger_id(+)=gst.ledger_id and gst.template_id=gsbo.template_id(+) and gsbo.funding_budget_version_id=gbrjv.budget_version_id(+) and gl.ledger_id=gbrjv.ledger_id(+) and gsbo.funds_check_level_code=flvv1.lookup_code(+) and flvv1.lookup_type(+)='FUNDS_CHECK_LEVEL' and gsbo.dr_cr_code=flvv2.lookup_code(+) and flvv2.lookup_type(+)='DR_CR' and gsbo.amount_type=flvv3.lookup_code(+) and flvv3.lookup_type(+)='PTD_YTD' and gsbo.boundary_code=flvv4.lookup_code(+) and flvv4.lookup_type(+)='BOUNDARY_TYPE' Default value :$column$.gl_segment1 GL_SEGMENT1 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment10 GL_SEGMENT10 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment11 GL_SEGMENT11 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment12 GL_SEGMENT12 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment13 GL_SEGMENT13 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment14 GL_SEGMENT14 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment15 GL_SEGMENT15 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment16 GL_SEGMENT16 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment17 GL_SEGMENT17 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment18 GL_SEGMENT18 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment19 GL_SEGMENT19 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment2 GL_SEGMENT2 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment20 GL_SEGMENT20 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment21 GL_SEGMENT21 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment22 GL_SEGMENT22 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment23 GL_SEGMENT23 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment24 GL_SEGMENT24 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment25 GL_SEGMENT25 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment26 GL_SEGMENT26 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment27 GL_SEGMENT27 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment28 GL_SEGMENT28 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment29 GL_SEGMENT29 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment3 GL_SEGMENT3 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment30 GL_SEGMENT30 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment4 GL_SEGMENT4 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment5 GL_SEGMENT5 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment6 GL_SEGMENT6 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment7 GL_SEGMENT7 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment8 GL_SEGMENT8 CONCATENATED_DESCRIPTION Default value :$column$.gl_segment9 GL_SEGMENT9 CONCATENATED_DESCRIPTION Default value :$flex$.segment_delimiter Segment Delimiter|1=1| CONCATENATED_DESCRIPTION LOV query :$flex$.ledger Ledger|1=1| EARLIEST_PERIOD LOV query :$flex$.ledger Ledger|1=1| FUNDING_BUDGET LOV query :$column$.ledger LEDGER GL_SEGMENT1 LOV query :$column$.ledger LEDGER GL_SEGMENT10 LOV query :$column$.ledger LEDGER GL_SEGMENT11 LOV query :$column$.ledger LEDGER GL_SEGMENT12 LOV query :$column$.ledger LEDGER GL_SEGMENT13 LOV query :$column$.ledger LEDGER GL_SEGMENT14 LOV query :$column$.ledger LEDGER GL_SEGMENT15 LOV query :$column$.ledger LEDGER GL_SEGMENT16 LOV query :$column$.ledger LEDGER GL_SEGMENT17 LOV query :$column$.ledger LEDGER GL_SEGMENT18 LOV query :$column$.ledger LEDGER GL_SEGMENT19 LOV query :$column$.ledger LEDGER GL_SEGMENT2 LOV query :$column$.ledger LEDGER GL_SEGMENT20 LOV query :$column$.ledger LEDGER GL_SEGMENT21 LOV query :$column$.ledger LEDGER GL_SEGMENT22 LOV query :$column$.ledger LEDGER GL_SEGMENT23 LOV query :$column$.ledger LEDGER GL_SEGMENT24 LOV query :$column$.ledger LEDGER GL_SEGMENT25 LOV query :$column$.ledger LEDGER GL_SEGMENT26 LOV query :$column$.ledger LEDGER GL_SEGMENT27 LOV query :$column$.ledger LEDGER GL_SEGMENT28 LOV query :$column$.ledger LEDGER GL_SEGMENT29 LOV query :$column$.ledger LEDGER GL_SEGMENT3 LOV query :$column$.ledger LEDGER GL_SEGMENT30 LOV query :$column$.ledger LEDGER GL_SEGMENT4 LOV query :$column$.ledger LEDGER GL_SEGMENT5 LOV query :$column$.ledger LEDGER GL_SEGMENT6 LOV query :$column$.ledger LEDGER GL_SEGMENT7 LOV query :$column$.ledger LEDGER GL_SEGMENT8 LOV query :$column$.ledger LEDGER GL_SEGMENT9 Default value :$flex$.ledger Ledger|1=1| LEDGER Excel validation :$column$.action_ ACTION_ Excel validation :$column$.gl_segment1 GL_SEGMENT1 Excel validation :$column$.gl_segment10 GL_SEGMENT10 Excel validation :$column$.gl_segment2 GL_SEGMENT2 Excel validation :$column$.gl_segment3 GL_SEGMENT3 Excel validation :$column$.gl_segment4 GL_SEGMENT4 Excel validation :$column$.gl_segment5 GL_SEGMENT5 Excel validation :$column$.gl_segment6 GL_SEGMENT6 Excel validation :$column$.gl_segment7 GL_SEGMENT7 Excel validation :$column$.gl_segment8 GL_SEGMENT8 Excel validation :$column$.gl_segment9 GL_SEGMENT9 Excel validation :$flex$.ledger Ledger|1=1|