ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 22C50854A7A70C17E0630100007FC09AY 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, to_number(null) upload_row 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' Upload Mode parameter added (Create downloads an empty sheet), Upload Row column added to keep the uploaded row order in the result, and Description defaults from an existing template. U A xxen_gl_upload.add_delete_summary_templates US GL Summary Account Upload Adds and deletes GL summary account templates of a ledger. Each row is one summary template. The segment columns hold the summary type of each segment, as in the Summary Accounts window: D (Detail) creates a summary account for each detail value of the segment, T (Total) one summary account across all values, and the name of a rollup group one summary account for each parent value of that group. Add creates the template and Delete removes it with its summary accounts. Both run the Add/Delete Summary Accounts program, which creates or deletes the summary accounts and maintains their balances from the Earliest Period on. The Request Log column links to its log. An existing template cannot be changed: delete it and add it again. The budgetary control columns (Funds Check Level, Debit or Credit, Amount Type, Boundary, Funding Budget) apply to ledgers with budgetary control and are taken only when a template is added. 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 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 xroa.id from xxen_report_org_access xroa where xroa.access_type='LEDGER') 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 3 20 1=1 :p_upload_mode like '%'||xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 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 F6C766C6F4C3B27EAD88917C9A0FEE4A Default SYSADMIN 3 ADD_OR_DELETE Y 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 1 REQUEST_LOG 2 TEMPLATE_NAME Ledger Vision Operations (USA) Upload Mode C,U S Site SYSADMIN F6C766C6F4C3B27EAD88917C9A0FEE4A ENGINATICS F6C766C6F4C3B27EAD88917C9A0FEE4A F6C766C6F4C3B27EAD88917C9A0FEE4A 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 50 Y Y 11 ADD_OR_DELETE LOV custom varchar2 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 240 select gst.description from gl_summary_templates gst, gl_ledgers gl where gst.template_name=:$column$.template_name and gst.ledger_id=gl.ledger_id and gl.name=:$column$.ledger Y 13 EARLIEST_PERIOD LOV custom varchar2 15 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 30 :$flex$.ledger Y Y 15 GL_SEGMENT1 LOV custom varchar2 25 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 240 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 80 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 240 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 240 select flvv.description value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='PTD_YTD' Y 49 BOUNDARY LOV custom varchar2 80 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 15 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 51 UPLOAD_ROW Number number 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, xu.upload_row 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_) Order By upload_row, template_name 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, xu.upload_row 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'