ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN A03DF1F1A7EB46D8B980A33508E7C77FY select null action_, null status_, null message_, null modified_columns_, null request_id_, gbar.range_id, gbbo.funding_budget_version_id, gl.name ledger, gbe.name budget_organization, gbar.sequence_number line, xxen_gl_upload.budget_range_account(gbar.range_id,'N') account_low, xxen_gl_upload.budget_range_account(gbar.range_id,'Y') account_high, xxen_util.meaning(gbar.entry_code,'ENTRY_CODE',101) entry_type, gbar.currency_code currency, xxen_util.meaning(gbar.status,'GLBAAR_STATUSES',101) range_status, xxen_util.meaning(gbbo.funds_check_level_code,'FUNDS_CHECK_LEVEL',101) funds_check_level, xxen_util.meaning(gbbo.amount_type,'PTD_YTD',101) amount_type, xxen_util.meaning(gbbo.boundary_code,'BOUNDARY_TYPE',101) boundary, gbv.budget_name funding_budget, xxen_util.display_flexfield_context(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context) range_context, xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE1',gbar.rowid,gbar.attribute1) range_attribute1, xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE2',gbar.rowid,gbar.attribute2) range_attribute2, xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE3',gbar.rowid,gbar.attribute3) range_attribute3, xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE4',gbar.rowid,gbar.attribute4) range_attribute4, xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE5',gbar.rowid,gbar.attribute5) range_attribute5, xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE6',gbar.rowid,gbar.attribute6) range_attribute6, xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE7',gbar.rowid,gbar.attribute7) range_attribute7, xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE8',gbar.rowid,gbar.attribute8) range_attribute8, xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE9',gbar.rowid,gbar.attribute9) range_attribute9, xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE10',gbar.rowid,gbar.attribute10) range_attribute10, xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE11',gbar.rowid,gbar.attribute11) range_attribute11, xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE12',gbar.rowid,gbar.attribute12) range_attribute12, xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE13',gbar.rowid,gbar.attribute13) range_attribute13, xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE14',gbar.rowid,gbar.attribute14) range_attribute14, xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE15',gbar.rowid,gbar.attribute15) range_attribute15, null delete_range, null delete_funding_budget, null assignment_request, null upload_row from gl_ledgers gl, gl_budget_entities gbe, gl_budget_assignment_ranges gbar, gl_budorg_bc_options gbbo, gl_budget_versions gbv where 1=1 and gl.ledger_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='LEDGER') and gl.ledger_id=gbe.ledger_id and gbe.budget_entity_id=gbar.budget_entity_id and gbar.range_id=gbbo.range_id(+) and gbbo.funding_budget_version_id=gbv.budget_version_id(+) Initial version. U A xxen_gl_upload.upload_budget_range xxen_gl_upload.assign_budget_ranges US GL Budget Account Range Upload Creates, updates and deletes the account ranges of GL budget organizations - the Excel equivalent of the Ranges region of the Define Budget Organization form (Budgets > Define > Organization). Each row is one account range (line) of a budget organization. Account Low and Account High are entered with all segments, separated by the segment delimiter of the chart of accounts. As in the form, the account range, Entry Type and Currency of an existing line cannot be changed: delete the line and create a new one. Deleting a line also removes its account assignments and budgetary control options. After the upload, Assign Budget Account Ranges is submitted for every budget organization that has new lines. It assigns the accounts of the new ranges to the budget organization; its request is shown in the Assignment Request column. Funds Check Level, Amount Type, Boundary and Funding Budget are the budgetary control options of a line, available for entered lines in the ledger currency of a ledger with budgetary control enabled. A line with several funding budgets takes one row per funding budget. Enginatics R12 only Upload 1=1 1 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 coalesce(xxen_util.previous_parameter_value(:parameter_id),xxen_util.default_ledger) US Ledger 2 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 Y US Upload Mode 3 30 1=1 gbe.name=:budget_organization LOV custom select gbe.name value, gbe.description from gl_ledgers gl, gl_budget_entities gbe where gl.name=:$flex$.ledger and gl.ledger_id=gbe.ledger_id order by gbe.name US Budget Organization 3D26A0DD4331480B809E3202D8874E6B Budgetary Control Account ranges with their budgetary control options, one row per funding budget. ENGINATICS 5 ACCOUNT_HIGH 4 ACCOUNT_LOW Y 10 AMOUNT_TYPE 15 ASSIGNMENT_REQUEST 11 BOUNDARY 2 BUDGET_ORGANIZATION 7 CURRENCY 14 DELETE_FUNDING_BUDGET 13 DELETE_RANGE 6 ENTRY_TYPE 12 FUNDING_BUDGET 9 FUNDS_CHECK_LEVEL 1 LEDGER 3 LINE 8 RANGE_STATUS Upload Mode C,U S Site ED635952159746B986E8B6E2E972406B Default Account ranges without budgetary control options and descriptive flexfield. ENGINATICS 5 ACCOUNT_HIGH 4 ACCOUNT_LOW Y 10 ASSIGNMENT_REQUEST 2 BUDGET_ORGANIZATION 7 CURRENCY 9 DELETE_RANGE 6 ENTRY_TYPE 1 LEDGER 3 LINE 8 RANGE_STATUS Upload Mode C,U S Site EC45BD0C560F4E8ABBEDE227423E3B7B Descriptive Flexfield Descriptive flexfield of the account ranges. ENGINATICS 5 ACCOUNT_HIGH 4 ACCOUNT_LOW Y 2 BUDGET_ORGANIZATION 1 LEDGER 3 LINE 7 RANGE_ATTRIBUTE1 16 RANGE_ATTRIBUTE10 17 RANGE_ATTRIBUTE11 18 RANGE_ATTRIBUTE12 19 RANGE_ATTRIBUTE13 20 RANGE_ATTRIBUTE14 21 RANGE_ATTRIBUTE15 8 RANGE_ATTRIBUTE2 9 RANGE_ATTRIBUTE3 10 RANGE_ATTRIBUTE4 11 RANGE_ATTRIBUTE5 12 RANGE_ATTRIBUTE6 13 RANGE_ATTRIBUTE7 14 RANGE_ATTRIBUTE8 15 RANGE_ATTRIBUTE9 6 RANGE_CONTEXT Upload Mode C,U S Site ED635952159746B986E8B6E2E972406B 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 REQUEST_ID_ Char varchar2 Y 6 RANGE_ID Char number Y 7 FUNDING_BUDGET_VERSION_ID Char number Y 8 LEDGER LOV varchar2 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 select gl.ledger_id id, gl.name value from gl_ledgers gl where gl.ledger_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='LEDGER') :$flex$.ledger Y 9 BUDGET_ORGANIZATION LOV custom varchar2 select gbe.budget_entity_id id, gbe.name value, gbe.description from gl_ledgers gl, gl_budget_entities gbe where gl.name=:$column$.ledger and gl.ledger_id=gbe.ledger_id and gbe.status_code<>'D' and upper(gbe.name)<>upper(xxen_util.meaning('ALL','LITERAL',101)) and (gbe.security_flag='N' or fnd_data_security.check_function(1.0,'GL_DAS_BUDGET_ORG_M','GL_DAS_BUDGET_ORG',to_char(gbe.budget_entity_id),null,null,null,null,fnd_global.user_name)='T') order by gbe.name :$flex$.budget_organization Y 10 LINE Char number Y 11 ACCOUNT_LOW Char varchar2 Low account of the range, all segments entered and separated by the chart of accounts segment delimiter. Y 12 ACCOUNT_HIGH Char varchar2 High account of the range, all segments entered and separated by the chart of accounts segment delimiter. Y 13 ENTRY_TYPE LOV custom varchar2 select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='ENTRY_CODE' and flvv.view_application_id=101 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.meaning xxen_util.meaning('E','ENTRY_CODE',101) Y 14 CURRENCY LOV custom varchar2 select fcav.currency_code value, fcav.name description from fnd_currencies_active_v fcav where xxen_util.lookup_code(:$column$.entry_type,'ENTRY_CODE',101)='E' or fcav.currency_code in ('STAT',(select gl.currency_code from gl_ledgers gl where gl.name=:$column$.ledger)) order by fcav.currency_code select gl.currency_code from gl_ledgers gl where gl.name=:$column$.ledger Y 15 RANGE_STATUS Char varchar2 Y 16 FUNDS_CHECK_LEVEL LOV custom varchar2 select flvv.lookup_code id, flvv.meaning value, flvv.description from gl_ledgers gl, fnd_lookup_values_vl flvv where gl.name=:$column$.ledger and gl.enable_budgetary_control_flag='Y' and gl.currency_code=:$column$.currency and xxen_util.lookup_code(:$column$.entry_type,'ENTRY_CODE',101)='E' and flvv.lookup_type='FUNDS_CHECK_LEVEL' and flvv.view_application_id=101 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and flvv.lookup_code in ('D','B') order by flvv.meaning 17 AMOUNT_TYPE LOV custom varchar2 select glatv.amount_type id, glatv.show_amount_type value, glatv.description from gl_lookups_amount_types_v glatv where :$column$.funds_check_level is not null order by glatv.show_amount_type 18 BOUNDARY LOV custom varchar2 select glbv.boundary_code id, glbv.show_boundary value, null description from gl_lookups_amount_types_v glatv, gl_lookups_boundaries_v glbv where glatv.show_amount_type=:$column$.amount_type and ( glatv.amount_type='PTD' and glbv.boundary_code='P' or glatv.amount_type='QTD' and glbv.boundary_code in ('P','Q') or glatv.amount_type='YTD' and glbv.boundary_code in ('P','Q','Y') or glatv.amount_type='PJTD' ) order by glbv.show_boundary 19 FUNDING_BUDGET LOV custom varchar2 select gbrjv.budget_version_id id, gbrjv.budget_name value, null description from gl_ledgers gl, gl_budgets_require_journals_v gbrjv where gl.name=:$column$.ledger and gl.ledger_id=gbrjv.ledger_id order by gbrjv.budget_name select gb.budget_name from gl_ledgers gl, gl_budgets gb where :$column$.funds_check_level is not null and gl.name=:$column$.ledger and gl.ledger_id=gb.ledger_id and gb.status='C' and gb.require_budget_journals_flag='Y' 20 RANGE_CONTEXT LOV custom varchar2 select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfv.descriptive_flexfield_name='GL_BUDGET_ASSIGNMENT_RANGES' and fdfv.application_id=101 and fdfv.application_id=fdfcv.application_id and fdfv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 21 RANGE_ATTRIBUTE1 LOV custom varchar2 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_BUDGET_ASSIGNMENT_RANGES', p_context_name => :$column$.range_context, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.range_attribute1, p_attribute2 => :$column$.range_attribute2, p_attribute3 => :$column$.range_attribute3, p_attribute4 => :$column$.range_attribute4, p_attribute5 => :$column$.range_attribute5, p_attribute6 => :$column$.range_attribute6, p_attribute7 => :$column$.range_attribute7, p_attribute8 => :$column$.range_attribute8, p_attribute9 => :$column$.range_attribute9, p_attribute10 => :$column$.range_attribute10, p_attribute11 => :$column$.range_attribute11, p_attribute12 => :$column$.range_attribute12, p_attribute13 => :$column$.range_attribute13, p_attribute14 => :$column$.range_attribute14, p_attribute15 => :$column$.range_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=101 and dff.descriptive_flexfield_name='GL_BUDGET_ASSIGNMENT_RANGES' and dffcu.application_column_name='ATTRIBUTE1' 22 RANGE_ATTRIBUTE2 LOV custom varchar2 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_BUDGET_ASSIGNMENT_RANGES', p_context_name => :$column$.range_context, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.range_attribute1, p_attribute2 => :$column$.range_attribute2, p_attribute3 => :$column$.range_attribute3, p_attribute4 => :$column$.range_attribute4, p_attribute5 => :$column$.range_attribute5, p_attribute6 => :$column$.range_attribute6, p_attribute7 => :$column$.range_attribute7, p_attribute8 => :$column$.range_attribute8, p_attribute9 => :$column$.range_attribute9, p_attribute10 => :$column$.range_attribute10, p_attribute11 => :$column$.range_attribute11, p_attribute12 => :$column$.range_attribute12, p_attribute13 => :$column$.range_attribute13, p_attribute14 => :$column$.range_attribute14, p_attribute15 => :$column$.range_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=101 and dff.descriptive_flexfield_name='GL_BUDGET_ASSIGNMENT_RANGES' and dffcu.application_column_name='ATTRIBUTE2' 23 RANGE_ATTRIBUTE3 LOV custom varchar2 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_BUDGET_ASSIGNMENT_RANGES', p_context_name => :$column$.range_context, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.range_attribute1, p_attribute2 => :$column$.range_attribute2, p_attribute3 => :$column$.range_attribute3, p_attribute4 => :$column$.range_attribute4, p_attribute5 => :$column$.range_attribute5, p_attribute6 => :$column$.range_attribute6, p_attribute7 => :$column$.range_attribute7, p_attribute8 => :$column$.range_attribute8, p_attribute9 => :$column$.range_attribute9, p_attribute10 => :$column$.range_attribute10, p_attribute11 => :$column$.range_attribute11, p_attribute12 => :$column$.range_attribute12, p_attribute13 => :$column$.range_attribute13, p_attribute14 => :$column$.range_attribute14, p_attribute15 => :$column$.range_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=101 and dff.descriptive_flexfield_name='GL_BUDGET_ASSIGNMENT_RANGES' and dffcu.application_column_name='ATTRIBUTE3' 24 RANGE_ATTRIBUTE4 LOV custom varchar2 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_BUDGET_ASSIGNMENT_RANGES', p_context_name => :$column$.range_context, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.range_attribute1, p_attribute2 => :$column$.range_attribute2, p_attribute3 => :$column$.range_attribute3, p_attribute4 => :$column$.range_attribute4, p_attribute5 => :$column$.range_attribute5, p_attribute6 => :$column$.range_attribute6, p_attribute7 => :$column$.range_attribute7, p_attribute8 => :$column$.range_attribute8, p_attribute9 => :$column$.range_attribute9, p_attribute10 => :$column$.range_attribute10, p_attribute11 => :$column$.range_attribute11, p_attribute12 => :$column$.range_attribute12, p_attribute13 => :$column$.range_attribute13, p_attribute14 => :$column$.range_attribute14, p_attribute15 => :$column$.range_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=101 and dff.descriptive_flexfield_name='GL_BUDGET_ASSIGNMENT_RANGES' and dffcu.application_column_name='ATTRIBUTE4' 25 RANGE_ATTRIBUTE5 LOV custom varchar2 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_BUDGET_ASSIGNMENT_RANGES', p_context_name => :$column$.range_context, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.range_attribute1, p_attribute2 => :$column$.range_attribute2, p_attribute3 => :$column$.range_attribute3, p_attribute4 => :$column$.range_attribute4, p_attribute5 => :$column$.range_attribute5, p_attribute6 => :$column$.range_attribute6, p_attribute7 => :$column$.range_attribute7, p_attribute8 => :$column$.range_attribute8, p_attribute9 => :$column$.range_attribute9, p_attribute10 => :$column$.range_attribute10, p_attribute11 => :$column$.range_attribute11, p_attribute12 => :$column$.range_attribute12, p_attribute13 => :$column$.range_attribute13, p_attribute14 => :$column$.range_attribute14, p_attribute15 => :$column$.range_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=101 and dff.descriptive_flexfield_name='GL_BUDGET_ASSIGNMENT_RANGES' and dffcu.application_column_name='ATTRIBUTE5' 26 RANGE_ATTRIBUTE6 LOV custom varchar2 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_BUDGET_ASSIGNMENT_RANGES', p_context_name => :$column$.range_context, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.range_attribute1, p_attribute2 => :$column$.range_attribute2, p_attribute3 => :$column$.range_attribute3, p_attribute4 => :$column$.range_attribute4, p_attribute5 => :$column$.range_attribute5, p_attribute6 => :$column$.range_attribute6, p_attribute7 => :$column$.range_attribute7, p_attribute8 => :$column$.range_attribute8, p_attribute9 => :$column$.range_attribute9, p_attribute10 => :$column$.range_attribute10, p_attribute11 => :$column$.range_attribute11, p_attribute12 => :$column$.range_attribute12, p_attribute13 => :$column$.range_attribute13, p_attribute14 => :$column$.range_attribute14, p_attribute15 => :$column$.range_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=101 and dff.descriptive_flexfield_name='GL_BUDGET_ASSIGNMENT_RANGES' and dffcu.application_column_name='ATTRIBUTE6' 27 RANGE_ATTRIBUTE7 LOV custom varchar2 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_BUDGET_ASSIGNMENT_RANGES', p_context_name => :$column$.range_context, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.range_attribute1, p_attribute2 => :$column$.range_attribute2, p_attribute3 => :$column$.range_attribute3, p_attribute4 => :$column$.range_attribute4, p_attribute5 => :$column$.range_attribute5, p_attribute6 => :$column$.range_attribute6, p_attribute7 => :$column$.range_attribute7, p_attribute8 => :$column$.range_attribute8, p_attribute9 => :$column$.range_attribute9, p_attribute10 => :$column$.range_attribute10, p_attribute11 => :$column$.range_attribute11, p_attribute12 => :$column$.range_attribute12, p_attribute13 => :$column$.range_attribute13, p_attribute14 => :$column$.range_attribute14, p_attribute15 => :$column$.range_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=101 and dff.descriptive_flexfield_name='GL_BUDGET_ASSIGNMENT_RANGES' and dffcu.application_column_name='ATTRIBUTE7' 28 RANGE_ATTRIBUTE8 LOV custom varchar2 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_BUDGET_ASSIGNMENT_RANGES', p_context_name => :$column$.range_context, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.range_attribute1, p_attribute2 => :$column$.range_attribute2, p_attribute3 => :$column$.range_attribute3, p_attribute4 => :$column$.range_attribute4, p_attribute5 => :$column$.range_attribute5, p_attribute6 => :$column$.range_attribute6, p_attribute7 => :$column$.range_attribute7, p_attribute8 => :$column$.range_attribute8, p_attribute9 => :$column$.range_attribute9, p_attribute10 => :$column$.range_attribute10, p_attribute11 => :$column$.range_attribute11, p_attribute12 => :$column$.range_attribute12, p_attribute13 => :$column$.range_attribute13, p_attribute14 => :$column$.range_attribute14, p_attribute15 => :$column$.range_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=101 and dff.descriptive_flexfield_name='GL_BUDGET_ASSIGNMENT_RANGES' and dffcu.application_column_name='ATTRIBUTE8' 29 RANGE_ATTRIBUTE9 LOV custom varchar2 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_BUDGET_ASSIGNMENT_RANGES', p_context_name => :$column$.range_context, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.range_attribute1, p_attribute2 => :$column$.range_attribute2, p_attribute3 => :$column$.range_attribute3, p_attribute4 => :$column$.range_attribute4, p_attribute5 => :$column$.range_attribute5, p_attribute6 => :$column$.range_attribute6, p_attribute7 => :$column$.range_attribute7, p_attribute8 => :$column$.range_attribute8, p_attribute9 => :$column$.range_attribute9, p_attribute10 => :$column$.range_attribute10, p_attribute11 => :$column$.range_attribute11, p_attribute12 => :$column$.range_attribute12, p_attribute13 => :$column$.range_attribute13, p_attribute14 => :$column$.range_attribute14, p_attribute15 => :$column$.range_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=101 and dff.descriptive_flexfield_name='GL_BUDGET_ASSIGNMENT_RANGES' and dffcu.application_column_name='ATTRIBUTE9' 30 RANGE_ATTRIBUTE10 LOV custom varchar2 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_BUDGET_ASSIGNMENT_RANGES', p_context_name => :$column$.range_context, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.range_attribute1, p_attribute2 => :$column$.range_attribute2, p_attribute3 => :$column$.range_attribute3, p_attribute4 => :$column$.range_attribute4, p_attribute5 => :$column$.range_attribute5, p_attribute6 => :$column$.range_attribute6, p_attribute7 => :$column$.range_attribute7, p_attribute8 => :$column$.range_attribute8, p_attribute9 => :$column$.range_attribute9, p_attribute10 => :$column$.range_attribute10, p_attribute11 => :$column$.range_attribute11, p_attribute12 => :$column$.range_attribute12, p_attribute13 => :$column$.range_attribute13, p_attribute14 => :$column$.range_attribute14, p_attribute15 => :$column$.range_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=101 and dff.descriptive_flexfield_name='GL_BUDGET_ASSIGNMENT_RANGES' and dffcu.application_column_name='ATTRIBUTE10' 31 RANGE_ATTRIBUTE11 LOV custom varchar2 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_BUDGET_ASSIGNMENT_RANGES', p_context_name => :$column$.range_context, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.range_attribute1, p_attribute2 => :$column$.range_attribute2, p_attribute3 => :$column$.range_attribute3, p_attribute4 => :$column$.range_attribute4, p_attribute5 => :$column$.range_attribute5, p_attribute6 => :$column$.range_attribute6, p_attribute7 => :$column$.range_attribute7, p_attribute8 => :$column$.range_attribute8, p_attribute9 => :$column$.range_attribute9, p_attribute10 => :$column$.range_attribute10, p_attribute11 => :$column$.range_attribute11, p_attribute12 => :$column$.range_attribute12, p_attribute13 => :$column$.range_attribute13, p_attribute14 => :$column$.range_attribute14, p_attribute15 => :$column$.range_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=101 and dff.descriptive_flexfield_name='GL_BUDGET_ASSIGNMENT_RANGES' and dffcu.application_column_name='ATTRIBUTE11' 32 RANGE_ATTRIBUTE12 LOV custom varchar2 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_BUDGET_ASSIGNMENT_RANGES', p_context_name => :$column$.range_context, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.range_attribute1, p_attribute2 => :$column$.range_attribute2, p_attribute3 => :$column$.range_attribute3, p_attribute4 => :$column$.range_attribute4, p_attribute5 => :$column$.range_attribute5, p_attribute6 => :$column$.range_attribute6, p_attribute7 => :$column$.range_attribute7, p_attribute8 => :$column$.range_attribute8, p_attribute9 => :$column$.range_attribute9, p_attribute10 => :$column$.range_attribute10, p_attribute11 => :$column$.range_attribute11, p_attribute12 => :$column$.range_attribute12, p_attribute13 => :$column$.range_attribute13, p_attribute14 => :$column$.range_attribute14, p_attribute15 => :$column$.range_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=101 and dff.descriptive_flexfield_name='GL_BUDGET_ASSIGNMENT_RANGES' and dffcu.application_column_name='ATTRIBUTE12' 33 RANGE_ATTRIBUTE13 LOV custom varchar2 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_BUDGET_ASSIGNMENT_RANGES', p_context_name => :$column$.range_context, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.range_attribute1, p_attribute2 => :$column$.range_attribute2, p_attribute3 => :$column$.range_attribute3, p_attribute4 => :$column$.range_attribute4, p_attribute5 => :$column$.range_attribute5, p_attribute6 => :$column$.range_attribute6, p_attribute7 => :$column$.range_attribute7, p_attribute8 => :$column$.range_attribute8, p_attribute9 => :$column$.range_attribute9, p_attribute10 => :$column$.range_attribute10, p_attribute11 => :$column$.range_attribute11, p_attribute12 => :$column$.range_attribute12, p_attribute13 => :$column$.range_attribute13, p_attribute14 => :$column$.range_attribute14, p_attribute15 => :$column$.range_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=101 and dff.descriptive_flexfield_name='GL_BUDGET_ASSIGNMENT_RANGES' and dffcu.application_column_name='ATTRIBUTE13' 34 RANGE_ATTRIBUTE14 LOV custom varchar2 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_BUDGET_ASSIGNMENT_RANGES', p_context_name => :$column$.range_context, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.range_attribute1, p_attribute2 => :$column$.range_attribute2, p_attribute3 => :$column$.range_attribute3, p_attribute4 => :$column$.range_attribute4, p_attribute5 => :$column$.range_attribute5, p_attribute6 => :$column$.range_attribute6, p_attribute7 => :$column$.range_attribute7, p_attribute8 => :$column$.range_attribute8, p_attribute9 => :$column$.range_attribute9, p_attribute10 => :$column$.range_attribute10, p_attribute11 => :$column$.range_attribute11, p_attribute12 => :$column$.range_attribute12, p_attribute13 => :$column$.range_attribute13, p_attribute14 => :$column$.range_attribute14, p_attribute15 => :$column$.range_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=101 and dff.descriptive_flexfield_name='GL_BUDGET_ASSIGNMENT_RANGES' and dffcu.application_column_name='ATTRIBUTE14' 35 RANGE_ATTRIBUTE15 LOV custom varchar2 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_BUDGET_ASSIGNMENT_RANGES', p_context_name => :$column$.range_context, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.range_attribute1, p_attribute2 => :$column$.range_attribute2, p_attribute3 => :$column$.range_attribute3, p_attribute4 => :$column$.range_attribute4, p_attribute5 => :$column$.range_attribute5, p_attribute6 => :$column$.range_attribute6, p_attribute7 => :$column$.range_attribute7, p_attribute8 => :$column$.range_attribute8, p_attribute9 => :$column$.range_attribute9, p_attribute10 => :$column$.range_attribute10, p_attribute11 => :$column$.range_attribute11, p_attribute12 => :$column$.range_attribute12, p_attribute13 => :$column$.range_attribute13, p_attribute14 => :$column$.range_attribute14, p_attribute15 => :$column$.range_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=101 and dff.descriptive_flexfield_name='GL_BUDGET_ASSIGNMENT_RANGES' and dffcu.application_column_name='ATTRIBUTE15' 36 DELETE_RANGE LOV custom varchar2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$column$.range_id is not null Deletes the line with its account assignments and budgetary control options. 37 DELETE_FUNDING_BUDGET LOV custom varchar2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$column$.range_id is not null and :$column$.funding_budget is not null Removes the funding budget of the row from the line. 38 ASSIGNMENT_REQUEST Char varchar2 Request of the Assign Budget Account Ranges program submitted for the budget organization after the upload. Y 39 UPLOAD_ROW Char number Y U 20 p_budget_entity_id in Number BUDGET_ORGANIZATION U 30 p_line in Number Y LINE U 40 p_account_low in Char Y ACCOUNT_LOW U 50 p_account_high in Char Y ACCOUNT_HIGH U 60 p_entry_type in Char Y ENTRY_TYPE U 70 p_currency in Char Y CURRENCY U 80 p_funds_check_level in Char Y FUNDS_CHECK_LEVEL U 90 p_amount_type in Char Y AMOUNT_TYPE U 100 p_boundary in Char Y BOUNDARY U 110 p_funding_budget_id in Number Y FUNDING_BUDGET U 120 p_range_context in Char Y RANGE_CONTEXT U 130 p_range_attribute1 in Char Y RANGE_ATTRIBUTE1 U 140 p_range_attribute2 in Char Y RANGE_ATTRIBUTE2 U 150 p_range_attribute3 in Char Y RANGE_ATTRIBUTE3 U 160 p_range_attribute4 in Char Y RANGE_ATTRIBUTE4 U 170 p_range_attribute5 in Char Y RANGE_ATTRIBUTE5 U 180 p_range_attribute6 in Char Y RANGE_ATTRIBUTE6 U 190 p_range_attribute7 in Char Y RANGE_ATTRIBUTE7 U 200 p_range_attribute8 in Char Y RANGE_ATTRIBUTE8 U 210 p_range_attribute9 in Char Y RANGE_ATTRIBUTE9 U 220 p_range_attribute10 in Char Y RANGE_ATTRIBUTE10 U 230 p_range_attribute11 in Char Y RANGE_ATTRIBUTE11 U 240 p_range_attribute12 in Char Y RANGE_ATTRIBUTE12 U 250 p_range_attribute13 in Char Y RANGE_ATTRIBUTE13 U 260 p_range_attribute14 in Char Y RANGE_ATTRIBUTE14 U 270 p_range_attribute15 in Char Y RANGE_ATTRIBUTE15 U 280 p_delete_range in Char Y DELETE_RANGE U 290 p_delete_funding_budget in Char Y DELETE_FUNDING_BUDGET U 300 p_range_id in Number Y RANGE_ID U 310 p_range_id_out out Number RANGE_ID U 315 p_funding_budget_version_id in Number Y FUNDING_BUDGET_VERSION_ID U 320 status_ out Char STATUS_CODE_ U 330 message_ out Char MESSAGE_ P 10 p_ledger_id in Number LEDGER P 20 p_budget_entity_id in Number BUDGET_ORGANIZATION P 30 request_id_ out Number REQUEST_ID_ P 40 status_ out Char STATUS_CODE_ P 50 message_ out Char ASSIGNMENT_REQUEST Error SQL Order By upload_row, ledger, budget_organization, line, funding_budget Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.request_id_, nvl(gbar.range_id,xu.range_id) range_id, nvl(gbbo.funding_budget_version_id,xu.funding_budget_version_id) funding_budget_version_id, nvl(gl.name,xu.ledger) ledger, nvl(gbe.name,xu.budget_organization) budget_organization, nvl(gbar.sequence_number,xu.line) line, nvl(xxen_gl_upload.budget_range_account(gbar.range_id,'N'),xu.account_low) account_low, nvl(xxen_gl_upload.budget_range_account(gbar.range_id,'Y'),xu.account_high) account_high, nvl(xxen_util.meaning(gbar.entry_code,'ENTRY_CODE',101),xu.entry_type) entry_type, nvl(gbar.currency_code,xu.currency) currency, nvl(xxen_util.meaning(gbar.status,'GLBAAR_STATUSES',101),xu.range_status) range_status, nvl(xxen_util.meaning(gbbo.funds_check_level_code,'FUNDS_CHECK_LEVEL',101),xu.funds_check_level) funds_check_level, nvl(xxen_util.meaning(gbbo.amount_type,'PTD_YTD',101),xu.amount_type) amount_type, nvl(xxen_util.meaning(gbbo.boundary_code,'BOUNDARY_TYPE',101),xu.boundary) boundary, nvl(gbv.budget_name,xu.funding_budget) funding_budget, nvl(xxen_util.display_flexfield_context(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context),xu.range_context) range_context, nvl(xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE1',gbar.rowid,gbar.attribute1),xu.range_attribute1) range_attribute1, nvl(xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE2',gbar.rowid,gbar.attribute2),xu.range_attribute2) range_attribute2, nvl(xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE3',gbar.rowid,gbar.attribute3),xu.range_attribute3) range_attribute3, nvl(xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE4',gbar.rowid,gbar.attribute4),xu.range_attribute4) range_attribute4, nvl(xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE5',gbar.rowid,gbar.attribute5),xu.range_attribute5) range_attribute5, nvl(xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE6',gbar.rowid,gbar.attribute6),xu.range_attribute6) range_attribute6, nvl(xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE7',gbar.rowid,gbar.attribute7),xu.range_attribute7) range_attribute7, nvl(xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE8',gbar.rowid,gbar.attribute8),xu.range_attribute8) range_attribute8, nvl(xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE9',gbar.rowid,gbar.attribute9),xu.range_attribute9) range_attribute9, nvl(xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE10',gbar.rowid,gbar.attribute10),xu.range_attribute10) range_attribute10, nvl(xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE11',gbar.rowid,gbar.attribute11),xu.range_attribute11) range_attribute11, nvl(xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE12',gbar.rowid,gbar.attribute12),xu.range_attribute12) range_attribute12, nvl(xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE13',gbar.rowid,gbar.attribute13),xu.range_attribute13) range_attribute13, nvl(xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE14',gbar.rowid,gbar.attribute14),xu.range_attribute14) range_attribute14, nvl(xxen_util.display_flexfield_value(101,'GL_BUDGET_ASSIGNMENT_RANGES',gbar.context,'ATTRIBUTE15',gbar.rowid,gbar.attribute15),xu.range_attribute15) range_attribute15, xu.delete_range, xu.delete_funding_budget, xu.assignment_request, xu.upload_row from ( select xu.*, (select gbrjv.budget_version_id from gl_ledgers gl, gl_budgets_require_journals_v gbrjv where xu.ledger=gl.name and gl.ledger_id=gbrjv.ledger_id and gbrjv.budget_name=xu.funding_budget) new_funding_budget_version_id from xxen_gl_budget_account_1217_u xu where xu.status_code_=xxen_upload.status_success ) xu, gl_budget_assignment_ranges gbar, gl_ledgers gl, gl_budget_entities gbe, gl_budorg_bc_options gbbo, gl_budget_versions gbv where xu.range_id=gbar.range_id(+) and gbar.ledger_id=gl.ledger_id(+) and gbar.budget_entity_id=gbe.budget_entity_id(+) and xu.range_id=gbbo.range_id(+) and xu.new_funding_budget_version_id=gbbo.funding_budget_version_id(+) and gbbo.funding_budget_version_id=gbv.budget_version_id(+)