ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN D71DF542242C4EDD8D527C660C4B7C82Y select null action_, null status_, null message_, null modified_columns_, 'Update' operation, xma.book_type_code book, xma.invoice_number, xma.ap_distribution_line_number distribution_line, to_number(null) invoice_line, (select falu.meaning from fa_lookups falu where falu.lookup_type='QUEUE NAME' and falu.lookup_code=xma.queue_name) queue, xma.description, (select falu.meaning from fa_lookups falu where falu.lookup_type='ASSET TYPE' and falu.lookup_code=xma.asset_type) asset_type, (select fcbk.concatenated_segments from fa_categories_b_kfv fcbk where fcbk.category_id=xma.asset_category_id) category, xma.asset_number, xma.tag_number, xma.serial_number, xma.fixed_assets_units units, xma.fixed_assets_cost cost, xma.date_placed_in_service, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id=xma.expense_code_combination_id) expense_account, (select flk.concatenated_segments from fa_locations_kfv flk where flk.location_id=xma.location_id) location, (select papf.employee_number from per_all_people_f papf where papf.person_id=xma.assigned_to and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date) employee_number, (select falu.meaning from fa_lookups falu where falu.lookup_type='YESNO' and falu.lookup_code=xma.depreciate_flag) depreciate, to_char(null) merge_group, to_char(null) primary_line, to_char(null) sum_units, (select fab.asset_number from fa_additions_b fab where fab.asset_id=xma.add_to_asset_id) add_to_asset_number, (select falu.meaning from fa_lookups falu where falu.lookup_type='YESNO' and falu.lookup_code=xma.amortize_flag) amortize, coalesce(xxen_util.display_flexfield_context(140,'FA_ADDITIONS',xma.attribute_category_code),(select fdfcv.descriptive_flex_context_name from fa_categories_b_kfv fcbk, fnd_descr_flex_contexts_vl fdfcv where fcbk.category_id=xma.asset_category_id and fcbk.concatenated_segments=fdfcv.descriptive_flex_context_code and fdfcv.application_id=140 and fdfcv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcv.enabled_flag='Y')) attribute_category, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE1',null,xma.attribute1) attribute1, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE2',null,xma.attribute2) attribute2, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE3',null,xma.attribute3) attribute3, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE4',null,xma.attribute4) attribute4, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE5',null,xma.attribute5) attribute5, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE6',null,xma.attribute6) attribute6, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE7',null,xma.attribute7) attribute7, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE8',null,xma.attribute8) attribute8, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE9',null,xma.attribute9) attribute9, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE10',null,xma.attribute10) attribute10, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE11',null,xma.attribute11) attribute11, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE12',null,xma.attribute12) attribute12, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE13',null,xma.attribute13) attribute13, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE14',null,xma.attribute14) attribute14, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE15',null,xma.attribute15) attribute15, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE16',null,xma.attribute16) attribute16, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE17',null,xma.attribute17) attribute17, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE18',null,xma.attribute18) attribute18, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE19',null,xma.attribute19) attribute19, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE20',null,xma.attribute20) attribute20, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE21',null,xma.attribute21) attribute21, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE22',null,xma.attribute22) attribute22, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE23',null,xma.attribute23) attribute23, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE24',null,xma.attribute24) attribute24, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE25',null,xma.attribute25) attribute25, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE26',null,xma.attribute26) attribute26, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE27',null,xma.attribute27) attribute27, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE28',null,xma.attribute28) attribute28, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE29',null,xma.attribute29) attribute29, xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE30',null,xma.attribute30) attribute30, (select pv.vendor_name from po_vendors pv where xma.po_vendor_id=pv.vendor_id) supplier, (select pv.segment1 from po_vendors pv where xma.po_vendor_id=pv.vendor_id) supplier_number, xma.po_number, (select ppa.segment1 from pa_projects_all ppa where xma.project_id=ppa.project_id) project, (select pt.task_number from pa_tasks pt where xma.task_id=pt.task_id) task, xma.creation_date, xxen_util.user_name(xma.created_by) created_by, xma.mass_addition_id, xma.mass_addition_id upload_row from fa_mass_additions xma where xma.posting_status not in ('POSTED','MERGED','SPLIT') and 1=1 Added parameters Queue, Invoice Date, Creation Date and Supplier, read-only columns Supplier, Supplier Number, PO Number, Project, Task, Creation Date and Created By, and templates Mass Additions Queue Review and Mass Additions On Hold. The Queue list also accepts the current queue of the line, so a downloaded New or Cost Adjustment line re-uploads unchanged. U A xxen_fa_upload_11i.create_update_mass_addition xxen_fa_upload_11i.validate_mass_addition(:$column$.operation,:$column$.book,:$column$.mass_addition_id,:$column$.invoice_number,:$column$.distribution_line,:$column$.invoice_line,:$column$.queue,:$column$.description,:$column$.asset_type,:$column$.category,:$column$.units,:$column$.cost,:$column$.date_placed_in_service,:$column$.expense_account,:$column$.location,:$column$.employee_number,:$column$.depreciate,:$column$.merge_group,:$column$.add_to_asset_number,:$column$.amortize) US FA Mass Additions Upload 11i Maintains Oracle Assets Prepare Mass Additions queue lines. Use the Operation column to choose what each row does: Update (change fields and/or Queue), Create (add a new mass addition line), Merge, Split, Unsplit, Add to Asset or Undo Add to Asset. Queue (Post, On Hold, Delete, On-Review) sets the posting status of the line on an Update. Merge combines the lines that share a Merge Group label into the one row marked Primary Line = Yes; that line is kept as the asset and accumulates the cost of the other lines (and their units when Sum Units = Yes), and is set to On Hold. The Attribute columns are the asset descriptive flexfield. Its context is the asset category, as in Oracle Assets, so the context column follows Category and only the attributes of that category can be entered. After uploading, run the standard Post Mass Additions program to create the assets, exactly as today. Existing lines are matched on Book plus Invoice Number, Distribution Line and Invoice Line. Supplier, PO Number, Project, Task, Creation Date and Created By show the source of a line and are not uploaded. 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 2 20 1=1 xma.book_type_code=:book LOV custom Y select fbc.book_type_code id, fbc.book_type_code value, fbc.book_type_name description from fa_book_controls fbc where fbc.book_class='CORPORATE' and nvl(fbc.date_ineffective,sysdate+1)>sysdate order by fbc.book_type_code Y US Book 3 30 1=1 xma.queue_name in (select falu.lookup_code from fa_lookups falu where falu.lookup_type='QUEUE NAME' and falu.meaning=:queue) LOV custom Y select falu.meaning value, null description from fa_lookups falu where falu.lookup_type='QUEUE NAME' and falu.lookup_code not in ('POSTED','MERGED','SPLIT') order by falu.meaning US Queue 4 40 1=1 xma.invoice_date>=:invoice_date_from Date US Invoice Date From 5 50 1=1 xma.invoice_date<:invoice_date_to+1 Date :$flex$.invoice_date_from US Invoice Date To 6 60 1=1 xma.creation_date>=:creation_date_from Date US Creation Date From 7 70 1=1 xma.creation_date<:creation_date_to+1 Date :$flex$.creation_date_from US Creation Date To 8 80 1=1 xma.po_vendor_id in (select pv.vendor_id from po_vendors pv where pv.vendor_name=:supplier) LOV AP Supplier B9847D20A0E4742FE0538931640A6379 Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id US Supplier D6B5D98BB8BC43B6A50C50079855C515 Default All columns except the descriptive flexfield attributes. ENGINATICS 23 ADD_TO_ASSET_NUMBER 24 AMORTIZE 10 ASSET_NUMBER 8 ASSET_TYPE 2 BOOK 9 CATEGORY 14 COST 15 DATE_PLACED_IN_SERVICE 19 DEPRECIATE 7 DESCRIPTION 4 DISTRIBUTION_LINE Y 18 EMPLOYEE_NUMBER 16 EXPENSE_ACCOUNT 5 INVOICE_LINE 3 INVOICE_NUMBER 17 LOCATION 20 MERGE_GROUP 1 OPERATION 21 PRIMARY_LINE 6 QUEUE 12 SERIAL_NUMBER 22 SUM_UNITS 11 TAG_NUMBER 13 UNITS S Site AD4F5B6C7E8A4F9B1C2D3E4F5A6B7C84 Mass Additions On Hold Mass addition lines on hold, oldest first, with supplier, PO and project of the source invoice, to release them to Post or delete them before the period close. SYSADMIN 14 ASSET_TYPE 2 BOOK 13 CATEGORY 16 COST 21 CREATED_BY 20 CREATION_DATE 1 17 DATE_PLACED_IN_SERVICE 12 DESCRIPTION 5 DISTRIBUTION_LINE 18 EXPENSE_ACCOUNT 6 INVOICE_LINE 4 INVOICE_NUMBER 19 LOCATION 1 OPERATION 9 PO_NUMBER 10 PROJECT 3 QUEUE 7 SUPPLIER 8 SUPPLIER_NUMBER 11 TASK 15 UNITS Queue On Hold Upload Mode C,U S Site 8B2D3F4A5C6E4D7F9A0B1C2D3E4F5A62 Mass Additions Queue Review Mass addition lines still to be prepared or posted before the assets period close, by book and queue, with supplier, PO and project of the source invoice. Change the Queue to Post or On Hold and upload. SYSADMIN 14 ASSET_TYPE 2 BOOK 1 13 CATEGORY 16 COST 21 CREATED_BY 20 CREATION_DATE 17 DATE_PLACED_IN_SERVICE 12 DESCRIPTION 5 DISTRIBUTION_LINE 4 18 EXPENSE_ACCOUNT 6 INVOICE_LINE 5 4 INVOICE_NUMBER 3 19 LOCATION 1 OPERATION 9 PO_NUMBER 10 PROJECT 3 QUEUE 2 7 SUPPLIER 8 SUPPLIER_NUMBER 11 TASK 15 UNITS BOOK ROW 1 COST VALUE 1 SUM QUEUE COLUMN 1 Upload Mode C,U S Site D6B5D98BB8BC43B6A50C50079855C515 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 OPERATION LOV custom varchar2 Y select 'Update' id, 'Update' value, null description from dual union all select 'Create', 'Create', null from dual union all select 'Merge', 'Merge', null from dual union all select 'Split', 'Split', null from dual union all select 'Unsplit', 'Unsplit', null from dual union all select 'Add to Asset', 'Add to Asset', null from dual union all select 'Undo Add to Asset', 'Undo Add to Asset', null from dual Update What to do with this row: Update (change fields and/or Queue), Create (add a new line), Merge, Split, Unsplit, Add to Asset, or Undo Add to Asset. Y 6 BOOK LOV custom varchar2 15 Y select fbc.book_type_code id, fbc.book_type_code value, fbc.book_type_name description from fa_book_controls fbc where fbc.book_class='CORPORATE' and nvl(fbc.date_ineffective,sysdate+1)>sysdate order by fbc.book_type_code :$flex$.Book The Fixed Assets corporate depreciation book the line belongs to. Y 7 INVOICE_NUMBER Char varchar2 50 Source AP invoice number. With Distribution Line and Invoice Line it identifies the existing queue line to update, merge or split. 8 DISTRIBUTION_LINE Number number AP distribution line number - part of the key that identifies the existing line. 9 INVOICE_LINE Number number AP invoice line number - part of the key that identifies the existing line. 10 QUEUE LOV custom varchar2 80 Y select falu.lookup_code id, falu.meaning value, null description from fa_lookups falu where falu.lookup_type='QUEUE NAME' and (falu.lookup_code in ('POST','ON HOLD','DELETE','ON-REVIEW') and nvl(falu.end_date_active,sysdate)>=sysdate or falu.lookup_code=(select xma.queue_name from fa_mass_additions xma where xma.mass_addition_id=:$column$.mass_addition_id)) order by falu.meaning Posting status to set on the line: Post (release to Post Mass Additions), On Hold (keep pending review), Delete (discard), On-Review. 11 DESCRIPTION Char varchar2 80 12 ASSET_TYPE LOV custom varchar2 80 Y select falu.lookup_code id, falu.meaning value, null description from fa_lookups falu where falu.lookup_type='ASSET TYPE' and falu.lookup_code in ('CAPITALIZED','CIP','EXPENSED') order by falu.meaning Capitalized, CIP (construction in process) or Expensed. 13 CATEGORY LOV custom varchar2 61 Y select fcbk.concatenated_segments id, fcbk.concatenated_segments value, null description from fa_categories_b_kfv fcbk, fa_category_books fcb where fcbk.category_id=fcb.category_id and fcb.book_type_code=:$column$.book and fcbk.enabled_flag='Y' order by fcbk.concatenated_segments Asset category; determines the default depreciation method, life and accounts. 14 ASSET_NUMBER Char varchar2 15 15 TAG_NUMBER Char varchar2 15 Asset tag number. It must not be used by an existing asset or by another pending mass addition line. 16 SERIAL_NUMBER Char varchar2 35 17 UNITS Number number 18 COST Number number 19 DATE_PLACED_IN_SERVICE Date date 20 EXPENSE_ACCOUNT LOV custom varchar2 311 Y Y select gcck.concatenated_segments id, gcck.concatenated_segments value, null description from gl_code_combinations_kfv gcck where gcck.chart_of_accounts_id=(select gl.chart_of_accounts_id from fa_book_controls fbc, xxen_gl_ledgers_v gl where fbc.book_type_code=:$column$.book and fbc.set_of_books_id=gl.set_of_books_id) and gcck.enabled_flag='Y' order by gcck.concatenated_segments GL depreciation expense account for the distribution (from this Book chart of accounts). 21 LOCATION LOV custom varchar2 123 Y Y select flk.concatenated_segments id, flk.concatenated_segments value, null description from fa_locations_kfv flk where flk.enabled_flag='Y' order by flk.concatenated_segments 22 EMPLOYEE_NUMBER Char varchar2 30 23 DEPRECIATE LOV custom varchar2 Y select falu.lookup_code id, falu.meaning value, null description from fa_lookups falu where falu.lookup_type='YESNO' order by falu.meaning 24 MERGE_GROUP Char varchar2 For a Merge, give every line you want combined the same label, and mark exactly one of them Primary Line = Yes. To sum units, put the Primary Line row above the lines merging into it. 25 PRIMARY_LINE LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Mark Yes on the one line in the Merge Group that is kept as the resulting asset; the others fold into it. 26 SUM_UNITS LOV custom varchar2 Y select 'YES' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual union all select 'NO' id, xxen_util.meaning('N','YES_NO',0) value, null description from dual On the Primary Line: Yes adds the merged lines' units to this asset; No (default) keeps this line's units and sums only cost. 27 ADD_TO_ASSET_NUMBER Char varchar2 15 For Operation = Add to Asset: the existing asset this line cost is added to as an adjustment, instead of creating a new asset. 28 AMORTIZE LOV custom varchar2 Y select falu.lookup_code id, falu.meaning value, null description from fa_lookups falu where falu.lookup_type='YESNO' order by falu.meaning For Add to Asset: Yes amortizes the cost adjustment; No expenses it in the current period. 29 ATTRIBUTE_CATEGORY LOV custom varchar2 80 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=140 and fdfcv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name select fdfcv.descriptive_flex_context_name from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=140 and fdfcv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcv.descriptive_flex_context_code=:$column$.category and fdfcv.enabled_flag='Y' Context of the asset descriptive flexfield. Oracle Assets uses the asset category as context, so it follows the Category column. Y 30 ATTRIBUTE1 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE1' 31 ATTRIBUTE2 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE2' 32 ATTRIBUTE3 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE3' 33 ATTRIBUTE4 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE4' 34 ATTRIBUTE5 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE5' 35 ATTRIBUTE6 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE6' 36 ATTRIBUTE7 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE7' 37 ATTRIBUTE8 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE8' 38 ATTRIBUTE9 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE9' 39 ATTRIBUTE10 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE10' 40 ATTRIBUTE11 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE11' 41 ATTRIBUTE12 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE12' 42 ATTRIBUTE13 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE13' 43 ATTRIBUTE14 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE14' 44 ATTRIBUTE15 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE15' 45 ATTRIBUTE16 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE16', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE16' 46 ATTRIBUTE17 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE17', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE17' 47 ATTRIBUTE18 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE18', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE18' 48 ATTRIBUTE19 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE19', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE19' 49 ATTRIBUTE20 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE20', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE20' 50 ATTRIBUTE21 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE21', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE21' 51 ATTRIBUTE22 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE22', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE22' 52 ATTRIBUTE23 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE23', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE23' 53 ATTRIBUTE24 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE24', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE24' 54 ATTRIBUTE25 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE25', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE25' 55 ATTRIBUTE26 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE26', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE26' 56 ATTRIBUTE27 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE27', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE27' 57 ATTRIBUTE28 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE28', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE28' 58 ATTRIBUTE29 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE29', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE29' 59 ATTRIBUTE30 LOV custom varchar2 150 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=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE30', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) 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 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 fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE30' 60 SUPPLIER Char varchar2 Supplier of the source invoice Y 61 SUPPLIER_NUMBER Char varchar2 Y 62 PO_NUMBER Char varchar2 Purchase order of the source invoice Y 63 PROJECT Char varchar2 Project of a line interfaced from Oracle Projects Y 64 TASK Char varchar2 Y 65 CREATION_DATE Date date Y 66 CREATED_BY Char varchar2 Y 67 MASS_ADDITION_ID Number number Y 68 UPLOAD_ROW Number number Y U 1 status_ out Char STATUS_CODE_ U 2 message_ out Char MESSAGE_ U 3 p_operation in Char OPERATION U 4 p_book_type_code in Char BOOK U 5 p_mass_addition_id in Number MASS_ADDITION_ID U 6 p_invoice_number in Char INVOICE_NUMBER U 7 p_distribution_line in Number DISTRIBUTION_LINE U 8 p_invoice_line in Number INVOICE_LINE U 9 p_queue in Char QUEUE U 10 p_description in Char DESCRIPTION U 11 p_asset_number in Char ASSET_NUMBER U 12 p_tag_number in Char TAG_NUMBER U 13 p_serial_number in Char SERIAL_NUMBER U 14 p_asset_type in Char ASSET_TYPE U 15 p_category in Char CATEGORY U 16 p_units in Number UNITS U 17 p_cost in Number COST U 18 p_date_placed_in_service in Date DATE_PLACED_IN_SERVICE U 19 p_expense_account in Char EXPENSE_ACCOUNT U 20 p_location in Char LOCATION U 21 p_employee_number in Char EMPLOYEE_NUMBER U 22 p_depreciate in Char DEPRECIATE U 23 p_merge_group in Char MERGE_GROUP U 24 p_primary_line in Char PRIMARY_LINE U 25 p_sum_units in Char SUM_UNITS U 26 p_add_to_asset_number in Char ADD_TO_ASSET_NUMBER U 27 p_amortize in Char AMORTIZE U 28 p_attribute1 in Char ATTRIBUTE1 U 29 p_attribute2 in Char ATTRIBUTE2 U 30 p_attribute3 in Char ATTRIBUTE3 U 31 p_attribute4 in Char ATTRIBUTE4 U 32 p_attribute5 in Char ATTRIBUTE5 U 33 p_attribute6 in Char ATTRIBUTE6 U 34 p_attribute7 in Char ATTRIBUTE7 U 35 p_attribute8 in Char ATTRIBUTE8 U 36 p_attribute9 in Char ATTRIBUTE9 U 37 p_attribute10 in Char ATTRIBUTE10 U 38 p_attribute11 in Char ATTRIBUTE11 U 39 p_attribute12 in Char ATTRIBUTE12 U 40 p_attribute13 in Char ATTRIBUTE13 U 41 p_attribute14 in Char ATTRIBUTE14 U 42 p_attribute15 in Char ATTRIBUTE15 U 43 p_attribute16 in Char ATTRIBUTE16 U 44 p_attribute17 in Char ATTRIBUTE17 U 45 p_attribute18 in Char ATTRIBUTE18 U 46 p_attribute19 in Char ATTRIBUTE19 U 47 p_attribute20 in Char ATTRIBUTE20 U 48 p_attribute21 in Char ATTRIBUTE21 U 49 p_attribute22 in Char ATTRIBUTE22 U 50 p_attribute23 in Char ATTRIBUTE23 U 51 p_attribute24 in Char ATTRIBUTE24 U 52 p_attribute25 in Char ATTRIBUTE25 U 53 p_attribute26 in Char ATTRIBUTE26 U 54 p_attribute27 in Char ATTRIBUTE27 U 55 p_attribute28 in Char ATTRIBUTE28 U 56 p_attribute29 in Char ATTRIBUTE29 U 57 p_attribute30 in Char ATTRIBUTE30 U 58 p_mass_addition_id_out out Number MASS_ADDITION_ID Error SQL Order By upload_row Success SQL select xu.action_, xxen_upload.status_meaning(xu.status_code_) status_, xu.message_, xu.modified_columns_, xu.operation, nvl(xma.book_type_code,xu.book) book, nvl(xma.invoice_number,xu.invoice_number) invoice_number, nvl(xma.ap_distribution_line_number,xu.distribution_line) distribution_line, nvl(to_number(null),xu.invoice_line) invoice_line, nvl((select falu.meaning from fa_lookups falu where falu.lookup_type='QUEUE NAME' and falu.lookup_code=xma.queue_name),xu.queue) queue, nvl(xma.description,xu.description) description, nvl((select falu.meaning from fa_lookups falu where falu.lookup_type='ASSET TYPE' and falu.lookup_code=xma.asset_type),xu.asset_type) asset_type, nvl((select fcbk.concatenated_segments from fa_categories_b_kfv fcbk where fcbk.category_id=xma.asset_category_id),xu.category) category, nvl(xma.asset_number,xu.asset_number) asset_number, nvl(xma.tag_number,xu.tag_number) tag_number, nvl(xma.serial_number,xu.serial_number) serial_number, nvl(xma.fixed_assets_units,xu.units) units, nvl(xma.fixed_assets_cost,xu.cost) cost, nvl(xma.date_placed_in_service,xu.date_placed_in_service) date_placed_in_service, nvl((select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id=xma.expense_code_combination_id),xu.expense_account) expense_account, nvl((select flk.concatenated_segments from fa_locations_kfv flk where flk.location_id=xma.location_id),xu.location) location, nvl((select papf.employee_number from per_all_people_f papf where papf.person_id=xma.assigned_to and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date),xu.employee_number) employee_number, nvl((select falu.meaning from fa_lookups falu where falu.lookup_type='YESNO' and falu.lookup_code=xma.depreciate_flag),xu.depreciate) depreciate, xu.merge_group, xu.primary_line, xu.sum_units, nvl((select fab.asset_number from fa_additions_b fab where fab.asset_id=xma.add_to_asset_id),xu.add_to_asset_number) add_to_asset_number, nvl((select falu.meaning from fa_lookups falu where falu.lookup_type='YESNO' and falu.lookup_code=xma.amortize_flag),xu.amortize) amortize, coalesce(xxen_util.display_flexfield_context(140,'FA_ADDITIONS',xma.attribute_category_code),(select fdfcv.descriptive_flex_context_name from fa_categories_b_kfv fcbk, fnd_descr_flex_contexts_vl fdfcv where fcbk.category_id=xma.asset_category_id and fcbk.concatenated_segments=fdfcv.descriptive_flex_context_code and fdfcv.application_id=140 and fdfcv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcv.enabled_flag='Y'),xu.attribute_category) attribute_category, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE1',null,xma.attribute1),xu.attribute1) attribute1, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE2',null,xma.attribute2),xu.attribute2) attribute2, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE3',null,xma.attribute3),xu.attribute3) attribute3, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE4',null,xma.attribute4),xu.attribute4) attribute4, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE5',null,xma.attribute5),xu.attribute5) attribute5, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE6',null,xma.attribute6),xu.attribute6) attribute6, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE7',null,xma.attribute7),xu.attribute7) attribute7, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE8',null,xma.attribute8),xu.attribute8) attribute8, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE9',null,xma.attribute9),xu.attribute9) attribute9, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE10',null,xma.attribute10),xu.attribute10) attribute10, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE11',null,xma.attribute11),xu.attribute11) attribute11, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE12',null,xma.attribute12),xu.attribute12) attribute12, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE13',null,xma.attribute13),xu.attribute13) attribute13, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE14',null,xma.attribute14),xu.attribute14) attribute14, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE15',null,xma.attribute15),xu.attribute15) attribute15, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE16',null,xma.attribute16),xu.attribute16) attribute16, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE17',null,xma.attribute17),xu.attribute17) attribute17, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE18',null,xma.attribute18),xu.attribute18) attribute18, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE19',null,xma.attribute19),xu.attribute19) attribute19, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE20',null,xma.attribute20),xu.attribute20) attribute20, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE21',null,xma.attribute21),xu.attribute21) attribute21, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE22',null,xma.attribute22),xu.attribute22) attribute22, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE23',null,xma.attribute23),xu.attribute23) attribute23, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE24',null,xma.attribute24),xu.attribute24) attribute24, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE25',null,xma.attribute25),xu.attribute25) attribute25, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE26',null,xma.attribute26),xu.attribute26) attribute26, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE27',null,xma.attribute27),xu.attribute27) attribute27, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE28',null,xma.attribute28),xu.attribute28) attribute28, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE29',null,xma.attribute29),xu.attribute29) attribute29, nvl(xxen_util.display_flexfield_value(140,'FA_ADDITIONS',xma.attribute_category_code,'ATTRIBUTE30',null,xma.attribute30),xu.attribute30) attribute30, nvl((select pv.vendor_name from po_vendors pv where xma.po_vendor_id=pv.vendor_id),xu.supplier) supplier, nvl((select pv.segment1 from po_vendors pv where xma.po_vendor_id=pv.vendor_id),xu.supplier_number) supplier_number, nvl(xma.po_number,xu.po_number) po_number, nvl((select ppa.segment1 from pa_projects_all ppa where xma.project_id=ppa.project_id),xu.project) project, nvl((select pt.task_number from pa_tasks pt where xma.task_id=pt.task_id),xu.task) task, nvl(xma.creation_date,xu.creation_date) creation_date, nvl(xxen_util.user_name(xma.created_by),xu.created_by) created_by, nvl(xma.mass_addition_id,xu.mass_addition_id) mass_addition_id, xu.upload_row from xxen_fa_mass_additions_0466_u xu, fa_mass_additions xma where xu.status_code_=xxen_upload.status_success and xu.mass_addition_id=xma.mass_addition_id(+)