ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 66516ABF6FBE4DD9B522949144D13666Y select null action_, null status_, null message_, null modified_columns_, hou.name operating_unit, xxen_util.meaning(rad.type,'AUTOGL_TYPE',222) type, xxen_util.display_flexfield_context(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category) type_attribute_category, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE1',rad.rowid,rad.attribute1) type_attribute1, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE2',rad.rowid,rad.attribute2) type_attribute2, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE3',rad.rowid,rad.attribute3) type_attribute3, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE4',rad.rowid,rad.attribute4) type_attribute4, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE5',rad.rowid,rad.attribute5) type_attribute5, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE6',rad.rowid,rad.attribute6) type_attribute6, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE7',rad.rowid,rad.attribute7) type_attribute7, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE8',rad.rowid,rad.attribute8) type_attribute8, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE9',rad.rowid,rad.attribute9) type_attribute9, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE10',rad.rowid,rad.attribute10) type_attribute10, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE11',rad.rowid,rad.attribute11) type_attribute11, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE12',rad.rowid,rad.attribute12) type_attribute12, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE13',rad.rowid,rad.attribute13) type_attribute13, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE14',rad.rowid,rad.attribute14) type_attribute14, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE15',rad.rowid,rad.attribute15) type_attribute15, fifsv.segment_name segment, xxen_util.meaning(rads.table_name,'AUTOGL_TABLES',222) table_name, rads.constant, (select min(ffvv.description) from fnd_flex_values_vl ffvv where fifsv.flex_value_set_id=ffvv.flex_value_set_id and rads.constant=ffvv.flex_value) description, xxen_util.display_flexfield_context(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category) seg_attribute_category, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE1',rads.rowid,rads.attribute1) seg_attribute1, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE2',rads.rowid,rads.attribute2) seg_attribute2, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE3',rads.rowid,rads.attribute3) seg_attribute3, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE4',rads.rowid,rads.attribute4) seg_attribute4, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE5',rads.rowid,rads.attribute5) seg_attribute5, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE6',rads.rowid,rads.attribute6) seg_attribute6, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE7',rads.rowid,rads.attribute7) seg_attribute7, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE8',rads.rowid,rads.attribute8) seg_attribute8, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE9',rads.rowid,rads.attribute9) seg_attribute9, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE10',rads.rowid,rads.attribute10) seg_attribute10, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE11',rads.rowid,rads.attribute11) seg_attribute11, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE12',rads.rowid,rads.attribute12) seg_attribute12, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE13',rads.rowid,rads.attribute13) seg_attribute13, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE14',rads.rowid,rads.attribute14) seg_attribute14, xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE15',rads.rowid,rads.attribute15) seg_attribute15, rad.gl_default_id, rads.segment_num, null upload_row from ra_account_defaults_all rad, hr_operating_units hou, ar_system_parameters_all aspa, gl_ledgers gl, ra_account_default_segments rads, fnd_id_flex_segments_vl fifsv where 1=1 and rad.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat) and rad.org_id=hou.organization_id and rad.org_id=aspa.org_id and aspa.set_of_books_id=gl.ledger_id and rad.gl_default_id=rads.gl_default_id and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and rads.segment=fifsv.application_column_name Initial version: creates and updates the AutoAccounting definitions of the Automatic Accounting form (RAXSUAGL). Each type is saved atomically with the segment completeness and dependent segment checks. U A xxen_ar_upload.upload_autoaccounting xxen_ar_upload.validate_autoaccounting(:$column$.table_name,:$column$.constant) US AR AutoAccounting Upload Creates and updates the Receivables AutoAccounting definitions - the Excel equivalent of the Automatic Accounting form (Setup > Transactions > AutoAccounting). Each row is one segment of the chart of accounts of an AutoAccounting type, with the operating unit and type repeated on every row. Enter either a Table Name, from which AutoAccounting takes the segment value, or a Constant. Each type is saved as a whole: after the upload, every enabled segment of the chart of accounts must have a table name or constant, and a dependent segment must use the table name of its parent segment or a constant valid for the parent constant. Otherwise none of the type's rows are saved. To define a new type, enter one row per segment. The type's descriptive flexfield values are taken from its first row. Changing the balancing segment of the Revenue or Receivable type also changes the balancing segment of the Tax, Freight, Unbilled Receivable, Unearned Revenue and AutoInvoice Clearing types, as in the form. Enginatics Upload 1=1 1 10 1=1 :p_upload_mode like '%'||xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create||','||xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C,U Y US Upload Mode Create downloads an empty template. Create, Update also downloads the existing AutoAccounting definitions. 2 20 1=1 hou.name=:operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit Downloads only the AutoAccounting definitions of this operating unit. Also the default Operating Unit of new rows. 3 30 1=1 rad.type=xxen_util.lookup_code(:type,'AUTOGL_TYPE',222) LOV custom Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='AUTOGL_TYPE' and flvv.view_application_id=222 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and flvv.lookup_code not in ('CHARGES','ROUND') order by flvv.meaning US Type Downloads only this AutoAccounting type. Also the default Type of new rows. 074BC9528C8D490AA379764EB171B38E Default Table name or constant of each segment of the AutoAccounting types, without the descriptive flexfields. ENGINATICS 5 CONSTANT 6 DESCRIPTION 1 OPERATING_UNIT 3 SEGMENT 4 TABLE_NAME Y 2 TYPE Upload Mode C,U S Site 45A2C0B57C0944F4B9E8749A09B6D547 Descriptive Flexfields Descriptive flexfields of the AutoAccounting types and their segments. ENGINATICS 1 OPERATING_UNIT 3 SEGMENT 21 SEG_ATTRIBUTE1 30 SEG_ATTRIBUTE10 31 SEG_ATTRIBUTE11 32 SEG_ATTRIBUTE12 33 SEG_ATTRIBUTE13 34 SEG_ATTRIBUTE14 35 SEG_ATTRIBUTE15 22 SEG_ATTRIBUTE2 23 SEG_ATTRIBUTE3 24 SEG_ATTRIBUTE4 25 SEG_ATTRIBUTE5 26 SEG_ATTRIBUTE6 27 SEG_ATTRIBUTE7 28 SEG_ATTRIBUTE8 29 SEG_ATTRIBUTE9 20 SEG_ATTRIBUTE_CATEGORY 2 TYPE 5 TYPE_ATTRIBUTE1 14 TYPE_ATTRIBUTE10 15 TYPE_ATTRIBUTE11 16 TYPE_ATTRIBUTE12 17 TYPE_ATTRIBUTE13 18 TYPE_ATTRIBUTE14 19 TYPE_ATTRIBUTE15 6 TYPE_ATTRIBUTE2 7 TYPE_ATTRIBUTE3 8 TYPE_ATTRIBUTE4 9 TYPE_ATTRIBUTE5 10 TYPE_ATTRIBUTE6 11 TYPE_ATTRIBUTE7 12 TYPE_ATTRIBUTE8 13 TYPE_ATTRIBUTE9 4 TYPE_ATTRIBUTE_CATEGORY Y Upload Mode C,U S Site F323E50918284EBF820596691FFC2BD7 New AutoAccounting Type Empty sheet to define a new AutoAccounting type: enter one row per segment of the chart of accounts. ENGINATICS 5 CONSTANT 6 DESCRIPTION 1 OPERATING_UNIT 3 SEGMENT 4 TABLE_NAME Y 2 TYPE Upload Mode C Y S Site 074BC9528C8D490AA379764EB171B38E 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 OPERATING_UNIT LOV varchar2 HR Operating Unit for Upload F263DDA3FBF60F8FE0530100007F75CD Y select hou.organization_id id, hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.operating_unit is null or hou.name=:$flex$.operating_unit) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name :$flex$.operating_unit Y Y 6 TYPE LOV custom varchar2 Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='AUTOGL_TYPE' and flvv.view_application_id=222 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and flvv.lookup_code not in ('CHARGES','ROUND') order by flvv.meaning :$flex$.type Y Y 7 TYPE_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=222 and fdfcv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULTS' and fdfcv.global_flag='N' and fdfcv.enabled_flag='Y' order by fdfcv.descriptive_flex_context_name 8 TYPE_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULTS', p_context_name=>:$column$.type_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.type_attribute1, p_attribute2=>:$column$.type_attribute2, p_attribute3=>:$column$.type_attribute3, p_attribute4=>:$column$.type_attribute4, p_attribute5=>:$column$.type_attribute5, p_attribute6=>:$column$.type_attribute6, p_attribute7=>:$column$.type_attribute7, p_attribute8=>:$column$.type_attribute8, p_attribute9=>:$column$.type_attribute9, p_attribute10=>:$column$.type_attribute10, p_attribute11=>:$column$.type_attribute11, p_attribute12=>:$column$.type_attribute12, p_attribute13=>:$column$.type_attribute13, p_attribute14=>:$column$.type_attribute14, p_attribute15=>:$column$.type_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE1' 9 TYPE_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULTS', p_context_name=>:$column$.type_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.type_attribute1, p_attribute2=>:$column$.type_attribute2, p_attribute3=>:$column$.type_attribute3, p_attribute4=>:$column$.type_attribute4, p_attribute5=>:$column$.type_attribute5, p_attribute6=>:$column$.type_attribute6, p_attribute7=>:$column$.type_attribute7, p_attribute8=>:$column$.type_attribute8, p_attribute9=>:$column$.type_attribute9, p_attribute10=>:$column$.type_attribute10, p_attribute11=>:$column$.type_attribute11, p_attribute12=>:$column$.type_attribute12, p_attribute13=>:$column$.type_attribute13, p_attribute14=>:$column$.type_attribute14, p_attribute15=>:$column$.type_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE2' 10 TYPE_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULTS', p_context_name=>:$column$.type_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.type_attribute1, p_attribute2=>:$column$.type_attribute2, p_attribute3=>:$column$.type_attribute3, p_attribute4=>:$column$.type_attribute4, p_attribute5=>:$column$.type_attribute5, p_attribute6=>:$column$.type_attribute6, p_attribute7=>:$column$.type_attribute7, p_attribute8=>:$column$.type_attribute8, p_attribute9=>:$column$.type_attribute9, p_attribute10=>:$column$.type_attribute10, p_attribute11=>:$column$.type_attribute11, p_attribute12=>:$column$.type_attribute12, p_attribute13=>:$column$.type_attribute13, p_attribute14=>:$column$.type_attribute14, p_attribute15=>:$column$.type_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE3' 11 TYPE_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULTS', p_context_name=>:$column$.type_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.type_attribute1, p_attribute2=>:$column$.type_attribute2, p_attribute3=>:$column$.type_attribute3, p_attribute4=>:$column$.type_attribute4, p_attribute5=>:$column$.type_attribute5, p_attribute6=>:$column$.type_attribute6, p_attribute7=>:$column$.type_attribute7, p_attribute8=>:$column$.type_attribute8, p_attribute9=>:$column$.type_attribute9, p_attribute10=>:$column$.type_attribute10, p_attribute11=>:$column$.type_attribute11, p_attribute12=>:$column$.type_attribute12, p_attribute13=>:$column$.type_attribute13, p_attribute14=>:$column$.type_attribute14, p_attribute15=>:$column$.type_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE4' 12 TYPE_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULTS', p_context_name=>:$column$.type_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.type_attribute1, p_attribute2=>:$column$.type_attribute2, p_attribute3=>:$column$.type_attribute3, p_attribute4=>:$column$.type_attribute4, p_attribute5=>:$column$.type_attribute5, p_attribute6=>:$column$.type_attribute6, p_attribute7=>:$column$.type_attribute7, p_attribute8=>:$column$.type_attribute8, p_attribute9=>:$column$.type_attribute9, p_attribute10=>:$column$.type_attribute10, p_attribute11=>:$column$.type_attribute11, p_attribute12=>:$column$.type_attribute12, p_attribute13=>:$column$.type_attribute13, p_attribute14=>:$column$.type_attribute14, p_attribute15=>:$column$.type_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE5' 13 TYPE_ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULTS', p_context_name=>:$column$.type_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.type_attribute1, p_attribute2=>:$column$.type_attribute2, p_attribute3=>:$column$.type_attribute3, p_attribute4=>:$column$.type_attribute4, p_attribute5=>:$column$.type_attribute5, p_attribute6=>:$column$.type_attribute6, p_attribute7=>:$column$.type_attribute7, p_attribute8=>:$column$.type_attribute8, p_attribute9=>:$column$.type_attribute9, p_attribute10=>:$column$.type_attribute10, p_attribute11=>:$column$.type_attribute11, p_attribute12=>:$column$.type_attribute12, p_attribute13=>:$column$.type_attribute13, p_attribute14=>:$column$.type_attribute14, p_attribute15=>:$column$.type_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE6' 14 TYPE_ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULTS', p_context_name=>:$column$.type_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.type_attribute1, p_attribute2=>:$column$.type_attribute2, p_attribute3=>:$column$.type_attribute3, p_attribute4=>:$column$.type_attribute4, p_attribute5=>:$column$.type_attribute5, p_attribute6=>:$column$.type_attribute6, p_attribute7=>:$column$.type_attribute7, p_attribute8=>:$column$.type_attribute8, p_attribute9=>:$column$.type_attribute9, p_attribute10=>:$column$.type_attribute10, p_attribute11=>:$column$.type_attribute11, p_attribute12=>:$column$.type_attribute12, p_attribute13=>:$column$.type_attribute13, p_attribute14=>:$column$.type_attribute14, p_attribute15=>:$column$.type_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE7' 15 TYPE_ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULTS', p_context_name=>:$column$.type_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.type_attribute1, p_attribute2=>:$column$.type_attribute2, p_attribute3=>:$column$.type_attribute3, p_attribute4=>:$column$.type_attribute4, p_attribute5=>:$column$.type_attribute5, p_attribute6=>:$column$.type_attribute6, p_attribute7=>:$column$.type_attribute7, p_attribute8=>:$column$.type_attribute8, p_attribute9=>:$column$.type_attribute9, p_attribute10=>:$column$.type_attribute10, p_attribute11=>:$column$.type_attribute11, p_attribute12=>:$column$.type_attribute12, p_attribute13=>:$column$.type_attribute13, p_attribute14=>:$column$.type_attribute14, p_attribute15=>:$column$.type_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE8' 16 TYPE_ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULTS', p_context_name=>:$column$.type_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.type_attribute1, p_attribute2=>:$column$.type_attribute2, p_attribute3=>:$column$.type_attribute3, p_attribute4=>:$column$.type_attribute4, p_attribute5=>:$column$.type_attribute5, p_attribute6=>:$column$.type_attribute6, p_attribute7=>:$column$.type_attribute7, p_attribute8=>:$column$.type_attribute8, p_attribute9=>:$column$.type_attribute9, p_attribute10=>:$column$.type_attribute10, p_attribute11=>:$column$.type_attribute11, p_attribute12=>:$column$.type_attribute12, p_attribute13=>:$column$.type_attribute13, p_attribute14=>:$column$.type_attribute14, p_attribute15=>:$column$.type_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE9' 17 TYPE_ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULTS', p_context_name=>:$column$.type_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.type_attribute1, p_attribute2=>:$column$.type_attribute2, p_attribute3=>:$column$.type_attribute3, p_attribute4=>:$column$.type_attribute4, p_attribute5=>:$column$.type_attribute5, p_attribute6=>:$column$.type_attribute6, p_attribute7=>:$column$.type_attribute7, p_attribute8=>:$column$.type_attribute8, p_attribute9=>:$column$.type_attribute9, p_attribute10=>:$column$.type_attribute10, p_attribute11=>:$column$.type_attribute11, p_attribute12=>:$column$.type_attribute12, p_attribute13=>:$column$.type_attribute13, p_attribute14=>:$column$.type_attribute14, p_attribute15=>:$column$.type_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE10' 18 TYPE_ATTRIBUTE11 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULTS', p_context_name=>:$column$.type_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.type_attribute1, p_attribute2=>:$column$.type_attribute2, p_attribute3=>:$column$.type_attribute3, p_attribute4=>:$column$.type_attribute4, p_attribute5=>:$column$.type_attribute5, p_attribute6=>:$column$.type_attribute6, p_attribute7=>:$column$.type_attribute7, p_attribute8=>:$column$.type_attribute8, p_attribute9=>:$column$.type_attribute9, p_attribute10=>:$column$.type_attribute10, p_attribute11=>:$column$.type_attribute11, p_attribute12=>:$column$.type_attribute12, p_attribute13=>:$column$.type_attribute13, p_attribute14=>:$column$.type_attribute14, p_attribute15=>:$column$.type_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE11' 19 TYPE_ATTRIBUTE12 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULTS', p_context_name=>:$column$.type_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.type_attribute1, p_attribute2=>:$column$.type_attribute2, p_attribute3=>:$column$.type_attribute3, p_attribute4=>:$column$.type_attribute4, p_attribute5=>:$column$.type_attribute5, p_attribute6=>:$column$.type_attribute6, p_attribute7=>:$column$.type_attribute7, p_attribute8=>:$column$.type_attribute8, p_attribute9=>:$column$.type_attribute9, p_attribute10=>:$column$.type_attribute10, p_attribute11=>:$column$.type_attribute11, p_attribute12=>:$column$.type_attribute12, p_attribute13=>:$column$.type_attribute13, p_attribute14=>:$column$.type_attribute14, p_attribute15=>:$column$.type_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE12' 20 TYPE_ATTRIBUTE13 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULTS', p_context_name=>:$column$.type_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.type_attribute1, p_attribute2=>:$column$.type_attribute2, p_attribute3=>:$column$.type_attribute3, p_attribute4=>:$column$.type_attribute4, p_attribute5=>:$column$.type_attribute5, p_attribute6=>:$column$.type_attribute6, p_attribute7=>:$column$.type_attribute7, p_attribute8=>:$column$.type_attribute8, p_attribute9=>:$column$.type_attribute9, p_attribute10=>:$column$.type_attribute10, p_attribute11=>:$column$.type_attribute11, p_attribute12=>:$column$.type_attribute12, p_attribute13=>:$column$.type_attribute13, p_attribute14=>:$column$.type_attribute14, p_attribute15=>:$column$.type_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE13' 21 TYPE_ATTRIBUTE14 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULTS', p_context_name=>:$column$.type_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.type_attribute1, p_attribute2=>:$column$.type_attribute2, p_attribute3=>:$column$.type_attribute3, p_attribute4=>:$column$.type_attribute4, p_attribute5=>:$column$.type_attribute5, p_attribute6=>:$column$.type_attribute6, p_attribute7=>:$column$.type_attribute7, p_attribute8=>:$column$.type_attribute8, p_attribute9=>:$column$.type_attribute9, p_attribute10=>:$column$.type_attribute10, p_attribute11=>:$column$.type_attribute11, p_attribute12=>:$column$.type_attribute12, p_attribute13=>:$column$.type_attribute13, p_attribute14=>:$column$.type_attribute14, p_attribute15=>:$column$.type_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE14' 22 TYPE_ATTRIBUTE15 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULTS', p_context_name=>:$column$.type_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.type_attribute1, p_attribute2=>:$column$.type_attribute2, p_attribute3=>:$column$.type_attribute3, p_attribute4=>:$column$.type_attribute4, p_attribute5=>:$column$.type_attribute5, p_attribute6=>:$column$.type_attribute6, p_attribute7=>:$column$.type_attribute7, p_attribute8=>:$column$.type_attribute8, p_attribute9=>:$column$.type_attribute9, p_attribute10=>:$column$.type_attribute10, p_attribute11=>:$column$.type_attribute11, p_attribute12=>:$column$.type_attribute12, p_attribute13=>:$column$.type_attribute13, p_attribute14=>:$column$.type_attribute14, p_attribute15=>:$column$.type_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE15' 23 SEGMENT LOV custom varchar2 Y select fifsv.segment_name value, fifsv.form_left_prompt description from hr_operating_units hou, ar_system_parameters_all aspa, gl_ledgers gl, fnd_id_flex_segments_vl fifsv where hou.name=:$column$.operating_unit and hou.organization_id=aspa.org_id and aspa.set_of_books_id=gl.ledger_id and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.enabled_flag='Y' order by fifsv.segment_num Y Y 24 TABLE_NAME LOV custom varchar2 Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='AUTOGL_TABLES' and flvv.view_application_id=222 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and xxen_util.lookup_code(:$column$.type,'AUTOGL_TYPE',222)||'-'||flvv.lookup_code not in ( 'REC-RA_STD_TRX_LINES','REC-RA_TAXES','REC-AR_RECEIPT_METHOD_ACCOUNTS', 'REV-RA_TAXES','REV-AR_RECEIPT_METHOD_ACCOUNTS', 'FREIGHT-RA_TAXES','FREIGHT-AR_RECEIPT_METHOD_ACCOUNTS', 'SUSPENSE-RA_TAXES','SUSPENSE-AR_RECEIPT_METHOD_ACCOUNTS', 'UNBILL-RA_TAXES','UNBILL-AR_RECEIPT_METHOD_ACCOUNTS', 'UNEARN-RA_TAXES','UNEARN-AR_RECEIPT_METHOD_ACCOUNTS', 'TAX-AR_RECEIPT_METHOD_ACCOUNTS', 'BR_REC-RA_SALESREPS','BR_REC-RA_STD_TRX_LINES','BR_REC-RA_TAXES','BR_REC-AR_RECEIPT_METHOD_ACCOUNTS', 'BR_UNPAID_REC-RA_SALESREPS','BR_UNPAID_REC-RA_STD_TRX_LINES','BR_UNPAID_REC-RA_TAXES','BR_UNPAID_REC-AR_RECEIPT_METHOD_ACCOUNTS', 'BR_REMITTANCE-RA_SALESREPS','BR_REMITTANCE-RA_STD_TRX_LINES','BR_REMITTANCE-RA_TAXES', 'BR_FACTOR-RA_SALESREPS','BR_FACTOR-RA_STD_TRX_LINES','BR_FACTOR-RA_TAXES' ) order by flvv.meaning select xxen_util.meaning(rads.table_name,'AUTOGL_TABLES',222) from hr_operating_units hou, ar_system_parameters_all aspa, gl_ledgers gl, fnd_id_flex_segments_vl fifsv, fnd_segment_attribute_values fsav, ra_account_defaults_all rad, ra_account_default_segments rads where xxen_util.lookup_code(:$column$.type,'AUTOGL_TYPE',222) in ('TAX','FREIGHT','UNBILL','UNEARN','SUSPENSE') and hou.name=:$column$.operating_unit and hou.organization_id=aspa.org_id and aspa.set_of_books_id=gl.ledger_id and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.segment_name=:$column$.segment and fifsv.application_id=fsav.application_id and fifsv.id_flex_code=fsav.id_flex_code and fifsv.id_flex_num=fsav.id_flex_num and fifsv.application_column_name=fsav.application_column_name and fsav.segment_attribute_type='GL_BALANCING' and fsav.attribute_value='Y' and hou.organization_id=rad.org_id and rad.type='REV' and rad.gl_default_id=rads.gl_default_id and fifsv.application_column_name=rads.segment 25 CONSTANT LOV custom varchar2 Y select ffvv.flex_value value, min(ffvv.description) description from hr_operating_units hou, ar_system_parameters_all aspa, gl_ledgers gl, fnd_id_flex_segments_vl fifsv, fnd_flex_values_vl ffvv where hou.name=:$column$.operating_unit and hou.organization_id=aspa.org_id and aspa.set_of_books_id=gl.ledger_id and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.segment_name=:$column$.segment and fifsv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' group by ffvv.flex_value order by ffvv.flex_value select rads.constant from hr_operating_units hou, ar_system_parameters_all aspa, gl_ledgers gl, fnd_id_flex_segments_vl fifsv, fnd_segment_attribute_values fsav, ra_account_defaults_all rad, ra_account_default_segments rads where xxen_util.lookup_code(:$column$.type,'AUTOGL_TYPE',222) in ('TAX','FREIGHT','UNBILL','UNEARN','SUSPENSE') and hou.name=:$column$.operating_unit and hou.organization_id=aspa.org_id and aspa.set_of_books_id=gl.ledger_id and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.segment_name=:$column$.segment and fifsv.application_id=fsav.application_id and fifsv.id_flex_code=fsav.id_flex_code and fifsv.id_flex_num=fsav.id_flex_num and fifsv.application_column_name=fsav.application_column_name and fsav.segment_attribute_type='GL_BALANCING' and fsav.attribute_value='Y' and hou.organization_id=rad.org_id and rad.type='REV' and rad.gl_default_id=rads.gl_default_id and fifsv.application_column_name=rads.segment 26 DESCRIPTION Char varchar2 select min(ffvv.description) from hr_operating_units hou, ar_system_parameters_all aspa, gl_ledgers gl, fnd_id_flex_segments_vl fifsv, fnd_flex_values_vl ffvv where hou.name=:$column$.operating_unit and hou.organization_id=aspa.org_id and aspa.set_of_books_id=gl.ledger_id and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.segment_name=:$column$.segment and fifsv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.flex_value=:$column$.constant Y 27 SEG_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=222 and fdfcv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULT_SEGMENTS' and fdfcv.global_flag='N' and fdfcv.enabled_flag='Y' order by fdfcv.descriptive_flex_context_name 28 SEG_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULT_SEGMENTS', p_context_name=>:$column$.seg_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.seg_attribute1, p_attribute2=>:$column$.seg_attribute2, p_attribute3=>:$column$.seg_attribute3, p_attribute4=>:$column$.seg_attribute4, p_attribute5=>:$column$.seg_attribute5, p_attribute6=>:$column$.seg_attribute6, p_attribute7=>:$column$.seg_attribute7, p_attribute8=>:$column$.seg_attribute8, p_attribute9=>:$column$.seg_attribute9, p_attribute10=>:$column$.seg_attribute10, p_attribute11=>:$column$.seg_attribute11, p_attribute12=>:$column$.seg_attribute12, p_attribute13=>:$column$.seg_attribute13, p_attribute14=>:$column$.seg_attribute14, p_attribute15=>:$column$.seg_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULT_SEGMENTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE1' 29 SEG_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULT_SEGMENTS', p_context_name=>:$column$.seg_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.seg_attribute1, p_attribute2=>:$column$.seg_attribute2, p_attribute3=>:$column$.seg_attribute3, p_attribute4=>:$column$.seg_attribute4, p_attribute5=>:$column$.seg_attribute5, p_attribute6=>:$column$.seg_attribute6, p_attribute7=>:$column$.seg_attribute7, p_attribute8=>:$column$.seg_attribute8, p_attribute9=>:$column$.seg_attribute9, p_attribute10=>:$column$.seg_attribute10, p_attribute11=>:$column$.seg_attribute11, p_attribute12=>:$column$.seg_attribute12, p_attribute13=>:$column$.seg_attribute13, p_attribute14=>:$column$.seg_attribute14, p_attribute15=>:$column$.seg_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULT_SEGMENTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE2' 30 SEG_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULT_SEGMENTS', p_context_name=>:$column$.seg_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.seg_attribute1, p_attribute2=>:$column$.seg_attribute2, p_attribute3=>:$column$.seg_attribute3, p_attribute4=>:$column$.seg_attribute4, p_attribute5=>:$column$.seg_attribute5, p_attribute6=>:$column$.seg_attribute6, p_attribute7=>:$column$.seg_attribute7, p_attribute8=>:$column$.seg_attribute8, p_attribute9=>:$column$.seg_attribute9, p_attribute10=>:$column$.seg_attribute10, p_attribute11=>:$column$.seg_attribute11, p_attribute12=>:$column$.seg_attribute12, p_attribute13=>:$column$.seg_attribute13, p_attribute14=>:$column$.seg_attribute14, p_attribute15=>:$column$.seg_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULT_SEGMENTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE3' 31 SEG_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULT_SEGMENTS', p_context_name=>:$column$.seg_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.seg_attribute1, p_attribute2=>:$column$.seg_attribute2, p_attribute3=>:$column$.seg_attribute3, p_attribute4=>:$column$.seg_attribute4, p_attribute5=>:$column$.seg_attribute5, p_attribute6=>:$column$.seg_attribute6, p_attribute7=>:$column$.seg_attribute7, p_attribute8=>:$column$.seg_attribute8, p_attribute9=>:$column$.seg_attribute9, p_attribute10=>:$column$.seg_attribute10, p_attribute11=>:$column$.seg_attribute11, p_attribute12=>:$column$.seg_attribute12, p_attribute13=>:$column$.seg_attribute13, p_attribute14=>:$column$.seg_attribute14, p_attribute15=>:$column$.seg_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULT_SEGMENTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE4' 32 SEG_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULT_SEGMENTS', p_context_name=>:$column$.seg_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.seg_attribute1, p_attribute2=>:$column$.seg_attribute2, p_attribute3=>:$column$.seg_attribute3, p_attribute4=>:$column$.seg_attribute4, p_attribute5=>:$column$.seg_attribute5, p_attribute6=>:$column$.seg_attribute6, p_attribute7=>:$column$.seg_attribute7, p_attribute8=>:$column$.seg_attribute8, p_attribute9=>:$column$.seg_attribute9, p_attribute10=>:$column$.seg_attribute10, p_attribute11=>:$column$.seg_attribute11, p_attribute12=>:$column$.seg_attribute12, p_attribute13=>:$column$.seg_attribute13, p_attribute14=>:$column$.seg_attribute14, p_attribute15=>:$column$.seg_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULT_SEGMENTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE5' 33 SEG_ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULT_SEGMENTS', p_context_name=>:$column$.seg_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.seg_attribute1, p_attribute2=>:$column$.seg_attribute2, p_attribute3=>:$column$.seg_attribute3, p_attribute4=>:$column$.seg_attribute4, p_attribute5=>:$column$.seg_attribute5, p_attribute6=>:$column$.seg_attribute6, p_attribute7=>:$column$.seg_attribute7, p_attribute8=>:$column$.seg_attribute8, p_attribute9=>:$column$.seg_attribute9, p_attribute10=>:$column$.seg_attribute10, p_attribute11=>:$column$.seg_attribute11, p_attribute12=>:$column$.seg_attribute12, p_attribute13=>:$column$.seg_attribute13, p_attribute14=>:$column$.seg_attribute14, p_attribute15=>:$column$.seg_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULT_SEGMENTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE6' 34 SEG_ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULT_SEGMENTS', p_context_name=>:$column$.seg_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.seg_attribute1, p_attribute2=>:$column$.seg_attribute2, p_attribute3=>:$column$.seg_attribute3, p_attribute4=>:$column$.seg_attribute4, p_attribute5=>:$column$.seg_attribute5, p_attribute6=>:$column$.seg_attribute6, p_attribute7=>:$column$.seg_attribute7, p_attribute8=>:$column$.seg_attribute8, p_attribute9=>:$column$.seg_attribute9, p_attribute10=>:$column$.seg_attribute10, p_attribute11=>:$column$.seg_attribute11, p_attribute12=>:$column$.seg_attribute12, p_attribute13=>:$column$.seg_attribute13, p_attribute14=>:$column$.seg_attribute14, p_attribute15=>:$column$.seg_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULT_SEGMENTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE7' 35 SEG_ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULT_SEGMENTS', p_context_name=>:$column$.seg_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.seg_attribute1, p_attribute2=>:$column$.seg_attribute2, p_attribute3=>:$column$.seg_attribute3, p_attribute4=>:$column$.seg_attribute4, p_attribute5=>:$column$.seg_attribute5, p_attribute6=>:$column$.seg_attribute6, p_attribute7=>:$column$.seg_attribute7, p_attribute8=>:$column$.seg_attribute8, p_attribute9=>:$column$.seg_attribute9, p_attribute10=>:$column$.seg_attribute10, p_attribute11=>:$column$.seg_attribute11, p_attribute12=>:$column$.seg_attribute12, p_attribute13=>:$column$.seg_attribute13, p_attribute14=>:$column$.seg_attribute14, p_attribute15=>:$column$.seg_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULT_SEGMENTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE8' 36 SEG_ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULT_SEGMENTS', p_context_name=>:$column$.seg_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.seg_attribute1, p_attribute2=>:$column$.seg_attribute2, p_attribute3=>:$column$.seg_attribute3, p_attribute4=>:$column$.seg_attribute4, p_attribute5=>:$column$.seg_attribute5, p_attribute6=>:$column$.seg_attribute6, p_attribute7=>:$column$.seg_attribute7, p_attribute8=>:$column$.seg_attribute8, p_attribute9=>:$column$.seg_attribute9, p_attribute10=>:$column$.seg_attribute10, p_attribute11=>:$column$.seg_attribute11, p_attribute12=>:$column$.seg_attribute12, p_attribute13=>:$column$.seg_attribute13, p_attribute14=>:$column$.seg_attribute14, p_attribute15=>:$column$.seg_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULT_SEGMENTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE9' 37 SEG_ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULT_SEGMENTS', p_context_name=>:$column$.seg_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.seg_attribute1, p_attribute2=>:$column$.seg_attribute2, p_attribute3=>:$column$.seg_attribute3, p_attribute4=>:$column$.seg_attribute4, p_attribute5=>:$column$.seg_attribute5, p_attribute6=>:$column$.seg_attribute6, p_attribute7=>:$column$.seg_attribute7, p_attribute8=>:$column$.seg_attribute8, p_attribute9=>:$column$.seg_attribute9, p_attribute10=>:$column$.seg_attribute10, p_attribute11=>:$column$.seg_attribute11, p_attribute12=>:$column$.seg_attribute12, p_attribute13=>:$column$.seg_attribute13, p_attribute14=>:$column$.seg_attribute14, p_attribute15=>:$column$.seg_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULT_SEGMENTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE10' 38 SEG_ATTRIBUTE11 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULT_SEGMENTS', p_context_name=>:$column$.seg_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.seg_attribute1, p_attribute2=>:$column$.seg_attribute2, p_attribute3=>:$column$.seg_attribute3, p_attribute4=>:$column$.seg_attribute4, p_attribute5=>:$column$.seg_attribute5, p_attribute6=>:$column$.seg_attribute6, p_attribute7=>:$column$.seg_attribute7, p_attribute8=>:$column$.seg_attribute8, p_attribute9=>:$column$.seg_attribute9, p_attribute10=>:$column$.seg_attribute10, p_attribute11=>:$column$.seg_attribute11, p_attribute12=>:$column$.seg_attribute12, p_attribute13=>:$column$.seg_attribute13, p_attribute14=>:$column$.seg_attribute14, p_attribute15=>:$column$.seg_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULT_SEGMENTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE11' 39 SEG_ATTRIBUTE12 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULT_SEGMENTS', p_context_name=>:$column$.seg_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.seg_attribute1, p_attribute2=>:$column$.seg_attribute2, p_attribute3=>:$column$.seg_attribute3, p_attribute4=>:$column$.seg_attribute4, p_attribute5=>:$column$.seg_attribute5, p_attribute6=>:$column$.seg_attribute6, p_attribute7=>:$column$.seg_attribute7, p_attribute8=>:$column$.seg_attribute8, p_attribute9=>:$column$.seg_attribute9, p_attribute10=>:$column$.seg_attribute10, p_attribute11=>:$column$.seg_attribute11, p_attribute12=>:$column$.seg_attribute12, p_attribute13=>:$column$.seg_attribute13, p_attribute14=>:$column$.seg_attribute14, p_attribute15=>:$column$.seg_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULT_SEGMENTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE12' 40 SEG_ATTRIBUTE13 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULT_SEGMENTS', p_context_name=>:$column$.seg_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.seg_attribute1, p_attribute2=>:$column$.seg_attribute2, p_attribute3=>:$column$.seg_attribute3, p_attribute4=>:$column$.seg_attribute4, p_attribute5=>:$column$.seg_attribute5, p_attribute6=>:$column$.seg_attribute6, p_attribute7=>:$column$.seg_attribute7, p_attribute8=>:$column$.seg_attribute8, p_attribute9=>:$column$.seg_attribute9, p_attribute10=>:$column$.seg_attribute10, p_attribute11=>:$column$.seg_attribute11, p_attribute12=>:$column$.seg_attribute12, p_attribute13=>:$column$.seg_attribute13, p_attribute14=>:$column$.seg_attribute14, p_attribute15=>:$column$.seg_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULT_SEGMENTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE13' 41 SEG_ATTRIBUTE14 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULT_SEGMENTS', p_context_name=>:$column$.seg_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.seg_attribute1, p_attribute2=>:$column$.seg_attribute2, p_attribute3=>:$column$.seg_attribute3, p_attribute4=>:$column$.seg_attribute4, p_attribute5=>:$column$.seg_attribute5, p_attribute6=>:$column$.seg_attribute6, p_attribute7=>:$column$.seg_attribute7, p_attribute8=>:$column$.seg_attribute8, p_attribute9=>:$column$.seg_attribute9, p_attribute10=>:$column$.seg_attribute10, p_attribute11=>:$column$.seg_attribute11, p_attribute12=>:$column$.seg_attribute12, p_attribute13=>:$column$.seg_attribute13, p_attribute14=>:$column$.seg_attribute14, p_attribute15=>:$column$.seg_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULT_SEGMENTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE14' 42 SEG_ATTRIBUTE15 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>222, p_descriptive_flexfield_name=>'RA_ACCOUNT_DEFAULT_SEGMENTS', p_context_name=>:$column$.seg_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.seg_attribute1, p_attribute2=>:$column$.seg_attribute2, p_attribute3=>:$column$.seg_attribute3, p_attribute4=>:$column$.seg_attribute4, p_attribute5=>:$column$.seg_attribute5, p_attribute6=>:$column$.seg_attribute6, p_attribute7=>:$column$.seg_attribute7, p_attribute8=>:$column$.seg_attribute8, p_attribute9=>:$column$.seg_attribute9, p_attribute10=>:$column$.seg_attribute10, p_attribute11=>:$column$.seg_attribute11, p_attribute12=>:$column$.seg_attribute12, p_attribute13=>:$column$.seg_attribute13, p_attribute14=>:$column$.seg_attribute14, p_attribute15=>:$column$.seg_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_ACCOUNT_DEFAULT_SEGMENTS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE15' 43 GL_DEFAULT_ID Number number Y 44 SEGMENT_NUM Number number Y 45 UPLOAD_ROW Char varchar2 Y Error SQL Order By upload_row, operating_unit, type, segment_num Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, nvl(hou.name,xu.operating_unit) operating_unit, nvl(xxen_util.meaning(rad.type,'AUTOGL_TYPE',222),xu.type) type, case when rad.rowid is null then xu.type_attribute_category else xxen_util.display_flexfield_context(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category) end type_attribute_category, case when rad.rowid is null then xu.type_attribute1 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE1',rad.rowid,rad.attribute1) end type_attribute1, case when rad.rowid is null then xu.type_attribute2 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE2',rad.rowid,rad.attribute2) end type_attribute2, case when rad.rowid is null then xu.type_attribute3 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE3',rad.rowid,rad.attribute3) end type_attribute3, case when rad.rowid is null then xu.type_attribute4 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE4',rad.rowid,rad.attribute4) end type_attribute4, case when rad.rowid is null then xu.type_attribute5 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE5',rad.rowid,rad.attribute5) end type_attribute5, case when rad.rowid is null then xu.type_attribute6 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE6',rad.rowid,rad.attribute6) end type_attribute6, case when rad.rowid is null then xu.type_attribute7 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE7',rad.rowid,rad.attribute7) end type_attribute7, case when rad.rowid is null then xu.type_attribute8 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE8',rad.rowid,rad.attribute8) end type_attribute8, case when rad.rowid is null then xu.type_attribute9 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE9',rad.rowid,rad.attribute9) end type_attribute9, case when rad.rowid is null then xu.type_attribute10 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE10',rad.rowid,rad.attribute10) end type_attribute10, case when rad.rowid is null then xu.type_attribute11 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE11',rad.rowid,rad.attribute11) end type_attribute11, case when rad.rowid is null then xu.type_attribute12 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE12',rad.rowid,rad.attribute12) end type_attribute12, case when rad.rowid is null then xu.type_attribute13 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE13',rad.rowid,rad.attribute13) end type_attribute13, case when rad.rowid is null then xu.type_attribute14 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE14',rad.rowid,rad.attribute14) end type_attribute14, case when rad.rowid is null then xu.type_attribute15 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULTS',rad.attribute_category,'ATTRIBUTE15',rad.rowid,rad.attribute15) end type_attribute15, nvl((select fifsv.segment_name from fnd_id_flex_segments_vl fifsv where gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and rads.segment=fifsv.application_column_name),xu.segment) segment, case when rads.rowid is null then xu.table_name else xxen_util.meaning(rads.table_name,'AUTOGL_TABLES',222) end table_name, case when rads.rowid is null then xu.constant else rads.constant end constant, case when rads.rowid is null then xu.description else (select min(ffvv.description) from fnd_id_flex_segments_vl fifsv, fnd_flex_values_vl ffvv where gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and rads.segment=fifsv.application_column_name and fifsv.flex_value_set_id=ffvv.flex_value_set_id and rads.constant=ffvv.flex_value) end description, case when rads.rowid is null then xu.seg_attribute_category else xxen_util.display_flexfield_context(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category) end seg_attribute_category, case when rads.rowid is null then xu.seg_attribute1 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE1',rads.rowid,rads.attribute1) end seg_attribute1, case when rads.rowid is null then xu.seg_attribute2 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE2',rads.rowid,rads.attribute2) end seg_attribute2, case when rads.rowid is null then xu.seg_attribute3 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE3',rads.rowid,rads.attribute3) end seg_attribute3, case when rads.rowid is null then xu.seg_attribute4 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE4',rads.rowid,rads.attribute4) end seg_attribute4, case when rads.rowid is null then xu.seg_attribute5 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE5',rads.rowid,rads.attribute5) end seg_attribute5, case when rads.rowid is null then xu.seg_attribute6 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE6',rads.rowid,rads.attribute6) end seg_attribute6, case when rads.rowid is null then xu.seg_attribute7 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE7',rads.rowid,rads.attribute7) end seg_attribute7, case when rads.rowid is null then xu.seg_attribute8 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE8',rads.rowid,rads.attribute8) end seg_attribute8, case when rads.rowid is null then xu.seg_attribute9 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE9',rads.rowid,rads.attribute9) end seg_attribute9, case when rads.rowid is null then xu.seg_attribute10 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE10',rads.rowid,rads.attribute10) end seg_attribute10, case when rads.rowid is null then xu.seg_attribute11 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE11',rads.rowid,rads.attribute11) end seg_attribute11, case when rads.rowid is null then xu.seg_attribute12 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE12',rads.rowid,rads.attribute12) end seg_attribute12, case when rads.rowid is null then xu.seg_attribute13 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE13',rads.rowid,rads.attribute13) end seg_attribute13, case when rads.rowid is null then xu.seg_attribute14 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE14',rads.rowid,rads.attribute14) end seg_attribute14, case when rads.rowid is null then xu.seg_attribute15 else xxen_util.display_flexfield_value(222,'RA_ACCOUNT_DEFAULT_SEGMENTS',rads.attribute_category,'ATTRIBUTE15',rads.rowid,rads.attribute15) end seg_attribute15, xu.gl_default_id, nvl(rads.segment_num,xu.segment_num) segment_num, xu.upload_row from ( select x.*, ( select fifsv.application_column_name from ra_account_defaults_all rad, ar_system_parameters_all aspa, gl_ledgers gl, fnd_id_flex_segments_vl fifsv where x.gl_default_id=rad.gl_default_id and rad.org_id=aspa.org_id and aspa.set_of_books_id=gl.ledger_id and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.application_id=101 and fifsv.id_flex_code='GL#' and x.segment=fifsv.segment_name ) segment_column from xxen_ar_autoaccounting_3556_u x ) xu, --before 12c an outer joined table may reference at most one other table, so the segment column is resolved inside the view ra_account_defaults_all rad, hr_operating_units hou, ar_system_parameters_all aspa, gl_ledgers gl, ra_account_default_segments rads where xu.status_code_=xxen_upload.status_success and xu.gl_default_id=rad.gl_default_id(+) and rad.org_id=hou.organization_id(+) and rad.org_id=aspa.org_id(+) and aspa.set_of_books_id=gl.ledger_id(+) and xu.gl_default_id=rads.gl_default_id(+) and xu.segment_column=rads.segment(+)