ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 500D854909091B05E0630100007F6E79Y select null action_, null status_, null message_, null request_id_, null modified_columns_, -- operating unit and project haouv.name operating_unit, ppa.segment1 project_number, ppa.name project_name, -- asset identity ppaa.project_asset_id, ppaa.pm_asset_reference asset_reference, ppaa.asset_name, ppaa.asset_description description, xxen_util.meaning(ppaa.project_asset_type,'PROJECT_ASSET_TYPES',275) project_asset_type, ppaa.asset_number, xxen_util.meaning(ppaa.pm_product_code,'PM_PRODUCT_CODE',275) product_source, -- FA book and KFFs ppaa.book_type_code book, fcbk.concatenated_segments asset_category, fakk.concatenated_segments asset_key, flk.concatenated_segments location, -- employee papf.full_name employee_name, papf.employee_number, -- dates ppaa.estimated_in_service_date, ppaa.date_placed_in_service actual_in_service_date, -- units and cost ppaa.estimated_asset_units, ppaa.asset_units actual_units, ppaa.estimated_cost, -- parent asset fa.asset_number parent_asset_number, -- flags decode(ppaa.depreciate_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) depreciate, decode(ppaa.amortize_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) amortize_adjustments, gcck.concatenated_segments depreciation_expense_account, decode(ppaa.capital_hold_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) capital_hold, -- identification ppaa.manufacturer_name, ppaa.model_number, ppaa.serial_number, ppaa.tag_number, -- asset DFF xxen_util.display_flexfield_context(275,'PA_PROJECT_ASSETS',ppaa.attribute_category) asset_attribute_category, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE1',ppaa.rowid,ppaa.attribute1) asset_attribute1, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE2',ppaa.rowid,ppaa.attribute2) asset_attribute2, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE3',ppaa.rowid,ppaa.attribute3) asset_attribute3, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE4',ppaa.rowid,ppaa.attribute4) asset_attribute4, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE5',ppaa.rowid,ppaa.attribute5) asset_attribute5, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE6',ppaa.rowid,ppaa.attribute6) asset_attribute6, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE7',ppaa.rowid,ppaa.attribute7) asset_attribute7, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE8',ppaa.rowid,ppaa.attribute8) asset_attribute8, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE9',ppaa.rowid,ppaa.attribute9) asset_attribute9, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE10',ppaa.rowid,ppaa.attribute10) asset_attribute10, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE11',ppaa.rowid,ppaa.attribute11) asset_attribute11, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE12',ppaa.rowid,ppaa.attribute12) asset_attribute12, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE13',ppaa.rowid,ppaa.attribute13) asset_attribute13, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE14',ppaa.rowid,ppaa.attribute14) asset_attribute14, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE15',ppaa.rowid,ppaa.attribute15) asset_attribute15, -- assignment pt.task_id assignment_task_id, pt.task_number assignment_task_number, decode(case when pt.task_id is not null and pt.task_id=pt.top_task_id then 'Y' end,'Y',xxen_util.meaning('Y','YES_NO',0)) rollup, null delete_assignment, -- assignment DFF xxen_util.display_flexfield_context(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category) assign_attribute_category, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE1',paas.rowid,paas.attribute1) assign_attribute1, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE2',paas.rowid,paas.attribute2) assign_attribute2, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE3',paas.rowid,paas.attribute3) assign_attribute3, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE4',paas.rowid,paas.attribute4) assign_attribute4, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE5',paas.rowid,paas.attribute5) assign_attribute5, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE6',paas.rowid,paas.attribute6) assign_attribute6, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE7',paas.rowid,paas.attribute7) assign_attribute7, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE8',paas.rowid,paas.attribute8) assign_attribute8, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE9',paas.rowid,paas.attribute9) assign_attribute9, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE10',paas.rowid,paas.attribute10) assign_attribute10, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE11',paas.rowid,paas.attribute11) assign_attribute11, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE12',paas.rowid,paas.attribute12) assign_attribute12, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE13',paas.rowid,paas.attribute13) assign_attribute13, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE14',paas.rowid,paas.attribute14) assign_attribute14, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE15',paas.rowid,paas.attribute15) assign_attribute15, to_number(null) upload_row from pa_projects_all ppa, hr_all_organization_units_vl haouv, pa_project_assets_all ppaa, pa_project_asset_assignments paas, pa_tasks pt, fa_categories_b_kfv fcbk, fa_asset_keywords_kfv fakk, fa_locations_kfv flk, fa_additions_v fa, gl_code_combinations_kfv gcck, per_all_people_f papf where 1=1 and ppa.org_id=haouv.organization_id and ppa.project_id=ppaa.project_id and ppaa.project_asset_type in ('AS-BUILT','ESTIMATED') and ppaa.project_asset_id=paas.project_asset_id(+) and paas.project_id(+)<>0 and paas.task_id=pt.task_id(+) and ppaa.asset_category_id=fcbk.category_id(+) and ppaa.asset_key_ccid=fakk.code_combination_id(+) and ppaa.location_id=flk.location_id(+) and ppaa.parent_asset_id=fa.asset_id(+) and ppaa.depreciation_expense_ccid=gcck.code_combination_id(+) and ppaa.assigned_to_person_id=papf.person_id(+) and trunc(sysdate) between papf.effective_start_date(+) and papf.effective_end_date(+) Product Source: corrected lookup type PM_PRODUCT_CODES to PM_PRODUCT_CODE (the populated type) in the LOV, main SQL and Success SQL displays. U A xxen_pa_upload.upload_project_asset US PA Project Asset Upload PA Project Asset Upload ====================== Create, update, or delete project assets and their task assignments for Oracle Projects capital projects, using the public API pa_project_assets_pub. Supported Actions: - Create / Update project asset (ESTIMATED or AS-BUILT types only — RETIREMENT_ADJUSTMENT is excluded) - Add / Delete asset-to-task assignment (top-task rollup or leaf-task) Row Structure (bundled parent-child): - One row per (asset, assignment) pair - Leave Assignment Task Number blank on a row to create/update just the asset header with no assignment - For multiple assignments on the same asset, repeat the asset columns on subsequent rows with different Task Numbers Report Parameters: - Upload Mode: 'Create' or 'Create, Update' - Operating Unit: filters Project LOV - Project Number: the capital project (pa_projects_all.segment1) to which uploaded assets belong Notes: - Capitalization and Reversal are NOT supported via this upload — use the Capital Assets form for those workflow actions - The Depreciation Expense Account KFF is resolved against the chart of accounts of the project's ledger - Asset-to-task assignments do not support an update API — to modify an existing assignment DFF, delete and re-add 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 Y US Upload Mode 2 20 1=1 haouv.name=:p_operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Y US Operating Unit 3 30 1=1 ppa.segment1=:p_project_number LOV custom Y select ppa.segment1 value, ppa.name description from pa_projects_all ppa, pa_project_types_all ppta, hr_all_organization_units_vl haouv where ppa.project_type=ppta.project_type and ppa.org_id=ppta.org_id and ppta.project_type_class_code='CAPITAL' and nvl(ppa.template_flag,'N')='N' and ppa.org_id=haouv.organization_id and xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' order by value Y US Project Number 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 REQUEST_ID_ Char varchar2 Y 5 MODIFIED_COLUMNS_ Char varchar2 Y 6 OPERATING_UNIT LOV custom varchar2 240 Y select haouv.organization_id id, haouv.name value, null description from hr_all_organization_units_vl haouv, hr_organization_information hoi where haouv.organization_id=hoi.organization_id and hoi.org_information_context='CLASS' and hoi.org_information1='OPERATING_UNIT' and hoi.org_information2='Y' order by value :$flex$.Operating_Unit Y 7 PROJECT_NUMBER LOV custom varchar2 25 Y select ppa.project_id id, ppa.segment1 value, ppa.name description from pa_projects_all ppa, pa_project_types_all ppta, hr_all_organization_units_vl haouv where ppa.project_type=ppta.project_type and ppa.org_id=ppta.org_id and ppta.project_type_class_code='CAPITAL' and nvl(ppa.template_flag,'N')='N' and ppa.org_id=haouv.organization_id and haouv.name=:$column$.operating_unit order by value :$flex$.Project_Number Y 8 PROJECT_NAME Char varchar2 30 select ppa.name from pa_projects_all ppa where ppa.segment1=:$column$.project_number Y 9 PROJECT_ASSET_ID Number number Y 10 ASSET_REFERENCE Char varchar2 240 :$column$.asset_name 11 ASSET_NAME Char varchar2 240 Y 12 DESCRIPTION LOV custom varchar2 80 select fl.meaning value, null description from fa_lookups fl where fl.lookup_type='ASSET DESCRIPTION' and nvl(fl.end_date_active,sysdate)>=sysdate order by value Y 13 PROJECT_ASSET_TYPE LOV custom varchar2 Y select pl.lookup_code id, pl.meaning value, pl.description from pa_lookups pl where pl.lookup_type='PROJECT_ASSET_TYPES' and pl.lookup_code in ('AS-BUILT','ESTIMATED') order by value xxen_util.meaning('ESTIMATED','PROJECT_ASSET_TYPES',275) Y 14 ASSET_NUMBER Char varchar2 15 15 PRODUCT_SOURCE LOV custom varchar2 Y select pl.lookup_code id, pl.meaning value, pl.description from pa_lookups pl where pl.lookup_type='PM_PRODUCT_CODE' order by value 16 BOOK LOV custom varchar2 15 Y select 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 value 17 ASSET_CATEGORY LOV custom varchar2 61 Y Y select distinct 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=nvl(:$column$.book,fcb.book_type_code) and fcbk.enabled_flag='Y' order by value 18 ASSET_KEY LOV custom varchar2 30 Y Y select fakk.concatenated_segments value, null description from fa_asset_keywords_kfv fakk where fakk.enabled_flag='Y' order by value 19 LOCATION LOV custom varchar2 123 Y Y select flk.concatenated_segments value, null description from fa_locations_kfv flk where flk.enabled_flag='Y' order by value 20 EMPLOYEE_NAME LOV custom varchar2 240 Y Y select papf.person_id id, papf.full_name value, papf.employee_number description from per_all_people_f papf where papf.current_employee_flag='Y' and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date order by value 21 EMPLOYEE_NUMBER Char varchar2 30 select papf.employee_number from per_all_people_f papf where papf.full_name=:$column$.employee_name and papf.current_employee_flag='Y' and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date Y 22 ESTIMATED_IN_SERVICE_DATE Date date 23 ACTUAL_IN_SERVICE_DATE Date date 24 ESTIMATED_ASSET_UNITS Number number 25 ACTUAL_UNITS Number number 26 ESTIMATED_COST Number number 27 PARENT_ASSET_NUMBER LOV custom varchar2 15 Y Y select fa.asset_id id, fa.asset_number value, fa.description from fa_additions_v fa, fa_books fb where fa.asset_id=fb.asset_id and fa.asset_type<>'GROUP' and fb.date_ineffective is null and fb.book_type_code=:$column$.book order by value 28 DEPRECIATE LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 29 AMORTIZE_ADJUSTMENTS LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 30 DEPRECIATION_EXPENSE_ACCOUNT LOV custom varchar2 311 Y Y select gcck.concatenated_segments value, gcck.description from gl_code_combinations_kfv gcck, gl_ledgers gl, hr_operating_units hou where gcck.chart_of_accounts_id=gl.chart_of_accounts_id and gl.ledger_id=hou.set_of_books_id and hou.name=:$column$.operating_unit and gcck.enabled_flag='Y' and gcck.gl_account_type='E' order by value 31 CAPITAL_HOLD LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 32 MANUFACTURER_NAME Char varchar2 30 33 MODEL_NUMBER Char varchar2 40 34 SERIAL_NUMBER Char varchar2 35 35 TAG_NUMBER Char varchar2 15 36 ASSET_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=fdfv.application_id and fdfcv.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfcv.enabled_flag='Y' and fdfv.application_id=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSETS' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 37 ASSET_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSETS', p_context_name=>:$column$.asset_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.asset_attribute1, p_attribute2=>:$column$.asset_attribute2, p_attribute3=>:$column$.asset_attribute3, p_attribute4=>:$column$.asset_attribute4, p_attribute5=>:$column$.asset_attribute5, p_attribute6=>:$column$.asset_attribute6, p_attribute7=>:$column$.asset_attribute7, p_attribute8=>:$column$.asset_attribute8, p_attribute9=>:$column$.asset_attribute9, p_attribute10=>:$column$.asset_attribute10, p_attribute11=>:$column$.asset_attribute11, p_attribute12=>:$column$.asset_attribute12, p_attribute13=>:$column$.asset_attribute13, p_attribute14=>:$column$.asset_attribute14, p_attribute15=>:$column$.asset_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSETS' and fdfcuv.application_column_name='ATTRIBUTE1' 38 ASSET_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSETS', p_context_name=>:$column$.asset_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.asset_attribute1, p_attribute2=>:$column$.asset_attribute2, p_attribute3=>:$column$.asset_attribute3, p_attribute4=>:$column$.asset_attribute4, p_attribute5=>:$column$.asset_attribute5, p_attribute6=>:$column$.asset_attribute6, p_attribute7=>:$column$.asset_attribute7, p_attribute8=>:$column$.asset_attribute8, p_attribute9=>:$column$.asset_attribute9, p_attribute10=>:$column$.asset_attribute10, p_attribute11=>:$column$.asset_attribute11, p_attribute12=>:$column$.asset_attribute12, p_attribute13=>:$column$.asset_attribute13, p_attribute14=>:$column$.asset_attribute14, p_attribute15=>:$column$.asset_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSETS' and fdfcuv.application_column_name='ATTRIBUTE2' 39 ASSET_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSETS', p_context_name=>:$column$.asset_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.asset_attribute1, p_attribute2=>:$column$.asset_attribute2, p_attribute3=>:$column$.asset_attribute3, p_attribute4=>:$column$.asset_attribute4, p_attribute5=>:$column$.asset_attribute5, p_attribute6=>:$column$.asset_attribute6, p_attribute7=>:$column$.asset_attribute7, p_attribute8=>:$column$.asset_attribute8, p_attribute9=>:$column$.asset_attribute9, p_attribute10=>:$column$.asset_attribute10, p_attribute11=>:$column$.asset_attribute11, p_attribute12=>:$column$.asset_attribute12, p_attribute13=>:$column$.asset_attribute13, p_attribute14=>:$column$.asset_attribute14, p_attribute15=>:$column$.asset_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSETS' and fdfcuv.application_column_name='ATTRIBUTE3' 40 ASSET_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSETS', p_context_name=>:$column$.asset_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.asset_attribute1, p_attribute2=>:$column$.asset_attribute2, p_attribute3=>:$column$.asset_attribute3, p_attribute4=>:$column$.asset_attribute4, p_attribute5=>:$column$.asset_attribute5, p_attribute6=>:$column$.asset_attribute6, p_attribute7=>:$column$.asset_attribute7, p_attribute8=>:$column$.asset_attribute8, p_attribute9=>:$column$.asset_attribute9, p_attribute10=>:$column$.asset_attribute10, p_attribute11=>:$column$.asset_attribute11, p_attribute12=>:$column$.asset_attribute12, p_attribute13=>:$column$.asset_attribute13, p_attribute14=>:$column$.asset_attribute14, p_attribute15=>:$column$.asset_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSETS' and fdfcuv.application_column_name='ATTRIBUTE4' 41 ASSET_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSETS', p_context_name=>:$column$.asset_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.asset_attribute1, p_attribute2=>:$column$.asset_attribute2, p_attribute3=>:$column$.asset_attribute3, p_attribute4=>:$column$.asset_attribute4, p_attribute5=>:$column$.asset_attribute5, p_attribute6=>:$column$.asset_attribute6, p_attribute7=>:$column$.asset_attribute7, p_attribute8=>:$column$.asset_attribute8, p_attribute9=>:$column$.asset_attribute9, p_attribute10=>:$column$.asset_attribute10, p_attribute11=>:$column$.asset_attribute11, p_attribute12=>:$column$.asset_attribute12, p_attribute13=>:$column$.asset_attribute13, p_attribute14=>:$column$.asset_attribute14, p_attribute15=>:$column$.asset_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSETS' and fdfcuv.application_column_name='ATTRIBUTE5' 42 ASSET_ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSETS', p_context_name=>:$column$.asset_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.asset_attribute1, p_attribute2=>:$column$.asset_attribute2, p_attribute3=>:$column$.asset_attribute3, p_attribute4=>:$column$.asset_attribute4, p_attribute5=>:$column$.asset_attribute5, p_attribute6=>:$column$.asset_attribute6, p_attribute7=>:$column$.asset_attribute7, p_attribute8=>:$column$.asset_attribute8, p_attribute9=>:$column$.asset_attribute9, p_attribute10=>:$column$.asset_attribute10, p_attribute11=>:$column$.asset_attribute11, p_attribute12=>:$column$.asset_attribute12, p_attribute13=>:$column$.asset_attribute13, p_attribute14=>:$column$.asset_attribute14, p_attribute15=>:$column$.asset_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSETS' and fdfcuv.application_column_name='ATTRIBUTE6' 43 ASSET_ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSETS', p_context_name=>:$column$.asset_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.asset_attribute1, p_attribute2=>:$column$.asset_attribute2, p_attribute3=>:$column$.asset_attribute3, p_attribute4=>:$column$.asset_attribute4, p_attribute5=>:$column$.asset_attribute5, p_attribute6=>:$column$.asset_attribute6, p_attribute7=>:$column$.asset_attribute7, p_attribute8=>:$column$.asset_attribute8, p_attribute9=>:$column$.asset_attribute9, p_attribute10=>:$column$.asset_attribute10, p_attribute11=>:$column$.asset_attribute11, p_attribute12=>:$column$.asset_attribute12, p_attribute13=>:$column$.asset_attribute13, p_attribute14=>:$column$.asset_attribute14, p_attribute15=>:$column$.asset_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSETS' and fdfcuv.application_column_name='ATTRIBUTE7' 44 ASSET_ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSETS', p_context_name=>:$column$.asset_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.asset_attribute1, p_attribute2=>:$column$.asset_attribute2, p_attribute3=>:$column$.asset_attribute3, p_attribute4=>:$column$.asset_attribute4, p_attribute5=>:$column$.asset_attribute5, p_attribute6=>:$column$.asset_attribute6, p_attribute7=>:$column$.asset_attribute7, p_attribute8=>:$column$.asset_attribute8, p_attribute9=>:$column$.asset_attribute9, p_attribute10=>:$column$.asset_attribute10, p_attribute11=>:$column$.asset_attribute11, p_attribute12=>:$column$.asset_attribute12, p_attribute13=>:$column$.asset_attribute13, p_attribute14=>:$column$.asset_attribute14, p_attribute15=>:$column$.asset_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSETS' and fdfcuv.application_column_name='ATTRIBUTE8' 45 ASSET_ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSETS', p_context_name=>:$column$.asset_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.asset_attribute1, p_attribute2=>:$column$.asset_attribute2, p_attribute3=>:$column$.asset_attribute3, p_attribute4=>:$column$.asset_attribute4, p_attribute5=>:$column$.asset_attribute5, p_attribute6=>:$column$.asset_attribute6, p_attribute7=>:$column$.asset_attribute7, p_attribute8=>:$column$.asset_attribute8, p_attribute9=>:$column$.asset_attribute9, p_attribute10=>:$column$.asset_attribute10, p_attribute11=>:$column$.asset_attribute11, p_attribute12=>:$column$.asset_attribute12, p_attribute13=>:$column$.asset_attribute13, p_attribute14=>:$column$.asset_attribute14, p_attribute15=>:$column$.asset_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSETS' and fdfcuv.application_column_name='ATTRIBUTE9' 46 ASSET_ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSETS', p_context_name=>:$column$.asset_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.asset_attribute1, p_attribute2=>:$column$.asset_attribute2, p_attribute3=>:$column$.asset_attribute3, p_attribute4=>:$column$.asset_attribute4, p_attribute5=>:$column$.asset_attribute5, p_attribute6=>:$column$.asset_attribute6, p_attribute7=>:$column$.asset_attribute7, p_attribute8=>:$column$.asset_attribute8, p_attribute9=>:$column$.asset_attribute9, p_attribute10=>:$column$.asset_attribute10, p_attribute11=>:$column$.asset_attribute11, p_attribute12=>:$column$.asset_attribute12, p_attribute13=>:$column$.asset_attribute13, p_attribute14=>:$column$.asset_attribute14, p_attribute15=>:$column$.asset_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSETS' and fdfcuv.application_column_name='ATTRIBUTE10' 47 ASSET_ATTRIBUTE11 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSETS', p_context_name=>:$column$.asset_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.asset_attribute1, p_attribute2=>:$column$.asset_attribute2, p_attribute3=>:$column$.asset_attribute3, p_attribute4=>:$column$.asset_attribute4, p_attribute5=>:$column$.asset_attribute5, p_attribute6=>:$column$.asset_attribute6, p_attribute7=>:$column$.asset_attribute7, p_attribute8=>:$column$.asset_attribute8, p_attribute9=>:$column$.asset_attribute9, p_attribute10=>:$column$.asset_attribute10, p_attribute11=>:$column$.asset_attribute11, p_attribute12=>:$column$.asset_attribute12, p_attribute13=>:$column$.asset_attribute13, p_attribute14=>:$column$.asset_attribute14, p_attribute15=>:$column$.asset_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSETS' and fdfcuv.application_column_name='ATTRIBUTE11' 48 ASSET_ATTRIBUTE12 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSETS', p_context_name=>:$column$.asset_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.asset_attribute1, p_attribute2=>:$column$.asset_attribute2, p_attribute3=>:$column$.asset_attribute3, p_attribute4=>:$column$.asset_attribute4, p_attribute5=>:$column$.asset_attribute5, p_attribute6=>:$column$.asset_attribute6, p_attribute7=>:$column$.asset_attribute7, p_attribute8=>:$column$.asset_attribute8, p_attribute9=>:$column$.asset_attribute9, p_attribute10=>:$column$.asset_attribute10, p_attribute11=>:$column$.asset_attribute11, p_attribute12=>:$column$.asset_attribute12, p_attribute13=>:$column$.asset_attribute13, p_attribute14=>:$column$.asset_attribute14, p_attribute15=>:$column$.asset_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSETS' and fdfcuv.application_column_name='ATTRIBUTE12' 49 ASSET_ATTRIBUTE13 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSETS', p_context_name=>:$column$.asset_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.asset_attribute1, p_attribute2=>:$column$.asset_attribute2, p_attribute3=>:$column$.asset_attribute3, p_attribute4=>:$column$.asset_attribute4, p_attribute5=>:$column$.asset_attribute5, p_attribute6=>:$column$.asset_attribute6, p_attribute7=>:$column$.asset_attribute7, p_attribute8=>:$column$.asset_attribute8, p_attribute9=>:$column$.asset_attribute9, p_attribute10=>:$column$.asset_attribute10, p_attribute11=>:$column$.asset_attribute11, p_attribute12=>:$column$.asset_attribute12, p_attribute13=>:$column$.asset_attribute13, p_attribute14=>:$column$.asset_attribute14, p_attribute15=>:$column$.asset_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSETS' and fdfcuv.application_column_name='ATTRIBUTE13' 50 ASSET_ATTRIBUTE14 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSETS', p_context_name=>:$column$.asset_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.asset_attribute1, p_attribute2=>:$column$.asset_attribute2, p_attribute3=>:$column$.asset_attribute3, p_attribute4=>:$column$.asset_attribute4, p_attribute5=>:$column$.asset_attribute5, p_attribute6=>:$column$.asset_attribute6, p_attribute7=>:$column$.asset_attribute7, p_attribute8=>:$column$.asset_attribute8, p_attribute9=>:$column$.asset_attribute9, p_attribute10=>:$column$.asset_attribute10, p_attribute11=>:$column$.asset_attribute11, p_attribute12=>:$column$.asset_attribute12, p_attribute13=>:$column$.asset_attribute13, p_attribute14=>:$column$.asset_attribute14, p_attribute15=>:$column$.asset_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSETS' and fdfcuv.application_column_name='ATTRIBUTE14' 51 ASSET_ATTRIBUTE15 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSETS', p_context_name=>:$column$.asset_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.asset_attribute1, p_attribute2=>:$column$.asset_attribute2, p_attribute3=>:$column$.asset_attribute3, p_attribute4=>:$column$.asset_attribute4, p_attribute5=>:$column$.asset_attribute5, p_attribute6=>:$column$.asset_attribute6, p_attribute7=>:$column$.asset_attribute7, p_attribute8=>:$column$.asset_attribute8, p_attribute9=>:$column$.asset_attribute9, p_attribute10=>:$column$.asset_attribute10, p_attribute11=>:$column$.asset_attribute11, p_attribute12=>:$column$.asset_attribute12, p_attribute13=>:$column$.asset_attribute13, p_attribute14=>:$column$.asset_attribute14, p_attribute15=>:$column$.asset_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSETS' and fdfcuv.application_column_name='ATTRIBUTE15' 52 ASSIGNMENT_TASK_ID Number number Y 53 ASSIGNMENT_TASK_NUMBER LOV custom varchar2 25 Y select pt.task_id id, pt.task_number value, pt.task_name description from pa_tasks pt, pa_projects_all ppa where pt.project_id=ppa.project_id and ppa.segment1=:$flex$.Project_Number order by value 54 ROLLUP LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 55 DELETE_ASSIGNMENT LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 56 ASSIGN_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=fdfv.application_id and fdfcv.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfcv.enabled_flag='Y' and fdfv.application_id=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSET_ASSIGNMENTS' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 57 ASSIGN_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSET_ASSIGNMENTS', p_context_name=>:$column$.assign_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.assign_attribute1, p_attribute2=>:$column$.assign_attribute2, p_attribute3=>:$column$.assign_attribute3, p_attribute4=>:$column$.assign_attribute4, p_attribute5=>:$column$.assign_attribute5, p_attribute6=>:$column$.assign_attribute6, p_attribute7=>:$column$.assign_attribute7, p_attribute8=>:$column$.assign_attribute8, p_attribute9=>:$column$.assign_attribute9, p_attribute10=>:$column$.assign_attribute10, p_attribute11=>:$column$.assign_attribute11, p_attribute12=>:$column$.assign_attribute12, p_attribute13=>:$column$.assign_attribute13, p_attribute14=>:$column$.assign_attribute14, p_attribute15=>:$column$.assign_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSET_ASSIGNMENTS' and fdfcuv.application_column_name='ATTRIBUTE1' 58 ASSIGN_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSET_ASSIGNMENTS', p_context_name=>:$column$.assign_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.assign_attribute1, p_attribute2=>:$column$.assign_attribute2, p_attribute3=>:$column$.assign_attribute3, p_attribute4=>:$column$.assign_attribute4, p_attribute5=>:$column$.assign_attribute5, p_attribute6=>:$column$.assign_attribute6, p_attribute7=>:$column$.assign_attribute7, p_attribute8=>:$column$.assign_attribute8, p_attribute9=>:$column$.assign_attribute9, p_attribute10=>:$column$.assign_attribute10, p_attribute11=>:$column$.assign_attribute11, p_attribute12=>:$column$.assign_attribute12, p_attribute13=>:$column$.assign_attribute13, p_attribute14=>:$column$.assign_attribute14, p_attribute15=>:$column$.assign_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSET_ASSIGNMENTS' and fdfcuv.application_column_name='ATTRIBUTE2' 59 ASSIGN_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSET_ASSIGNMENTS', p_context_name=>:$column$.assign_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.assign_attribute1, p_attribute2=>:$column$.assign_attribute2, p_attribute3=>:$column$.assign_attribute3, p_attribute4=>:$column$.assign_attribute4, p_attribute5=>:$column$.assign_attribute5, p_attribute6=>:$column$.assign_attribute6, p_attribute7=>:$column$.assign_attribute7, p_attribute8=>:$column$.assign_attribute8, p_attribute9=>:$column$.assign_attribute9, p_attribute10=>:$column$.assign_attribute10, p_attribute11=>:$column$.assign_attribute11, p_attribute12=>:$column$.assign_attribute12, p_attribute13=>:$column$.assign_attribute13, p_attribute14=>:$column$.assign_attribute14, p_attribute15=>:$column$.assign_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSET_ASSIGNMENTS' and fdfcuv.application_column_name='ATTRIBUTE3' 60 ASSIGN_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSET_ASSIGNMENTS', p_context_name=>:$column$.assign_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.assign_attribute1, p_attribute2=>:$column$.assign_attribute2, p_attribute3=>:$column$.assign_attribute3, p_attribute4=>:$column$.assign_attribute4, p_attribute5=>:$column$.assign_attribute5, p_attribute6=>:$column$.assign_attribute6, p_attribute7=>:$column$.assign_attribute7, p_attribute8=>:$column$.assign_attribute8, p_attribute9=>:$column$.assign_attribute9, p_attribute10=>:$column$.assign_attribute10, p_attribute11=>:$column$.assign_attribute11, p_attribute12=>:$column$.assign_attribute12, p_attribute13=>:$column$.assign_attribute13, p_attribute14=>:$column$.assign_attribute14, p_attribute15=>:$column$.assign_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSET_ASSIGNMENTS' and fdfcuv.application_column_name='ATTRIBUTE4' 61 ASSIGN_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSET_ASSIGNMENTS', p_context_name=>:$column$.assign_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.assign_attribute1, p_attribute2=>:$column$.assign_attribute2, p_attribute3=>:$column$.assign_attribute3, p_attribute4=>:$column$.assign_attribute4, p_attribute5=>:$column$.assign_attribute5, p_attribute6=>:$column$.assign_attribute6, p_attribute7=>:$column$.assign_attribute7, p_attribute8=>:$column$.assign_attribute8, p_attribute9=>:$column$.assign_attribute9, p_attribute10=>:$column$.assign_attribute10, p_attribute11=>:$column$.assign_attribute11, p_attribute12=>:$column$.assign_attribute12, p_attribute13=>:$column$.assign_attribute13, p_attribute14=>:$column$.assign_attribute14, p_attribute15=>:$column$.assign_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSET_ASSIGNMENTS' and fdfcuv.application_column_name='ATTRIBUTE5' 62 ASSIGN_ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSET_ASSIGNMENTS', p_context_name=>:$column$.assign_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.assign_attribute1, p_attribute2=>:$column$.assign_attribute2, p_attribute3=>:$column$.assign_attribute3, p_attribute4=>:$column$.assign_attribute4, p_attribute5=>:$column$.assign_attribute5, p_attribute6=>:$column$.assign_attribute6, p_attribute7=>:$column$.assign_attribute7, p_attribute8=>:$column$.assign_attribute8, p_attribute9=>:$column$.assign_attribute9, p_attribute10=>:$column$.assign_attribute10, p_attribute11=>:$column$.assign_attribute11, p_attribute12=>:$column$.assign_attribute12, p_attribute13=>:$column$.assign_attribute13, p_attribute14=>:$column$.assign_attribute14, p_attribute15=>:$column$.assign_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSET_ASSIGNMENTS' and fdfcuv.application_column_name='ATTRIBUTE6' 63 ASSIGN_ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSET_ASSIGNMENTS', p_context_name=>:$column$.assign_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.assign_attribute1, p_attribute2=>:$column$.assign_attribute2, p_attribute3=>:$column$.assign_attribute3, p_attribute4=>:$column$.assign_attribute4, p_attribute5=>:$column$.assign_attribute5, p_attribute6=>:$column$.assign_attribute6, p_attribute7=>:$column$.assign_attribute7, p_attribute8=>:$column$.assign_attribute8, p_attribute9=>:$column$.assign_attribute9, p_attribute10=>:$column$.assign_attribute10, p_attribute11=>:$column$.assign_attribute11, p_attribute12=>:$column$.assign_attribute12, p_attribute13=>:$column$.assign_attribute13, p_attribute14=>:$column$.assign_attribute14, p_attribute15=>:$column$.assign_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSET_ASSIGNMENTS' and fdfcuv.application_column_name='ATTRIBUTE7' 64 ASSIGN_ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSET_ASSIGNMENTS', p_context_name=>:$column$.assign_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.assign_attribute1, p_attribute2=>:$column$.assign_attribute2, p_attribute3=>:$column$.assign_attribute3, p_attribute4=>:$column$.assign_attribute4, p_attribute5=>:$column$.assign_attribute5, p_attribute6=>:$column$.assign_attribute6, p_attribute7=>:$column$.assign_attribute7, p_attribute8=>:$column$.assign_attribute8, p_attribute9=>:$column$.assign_attribute9, p_attribute10=>:$column$.assign_attribute10, p_attribute11=>:$column$.assign_attribute11, p_attribute12=>:$column$.assign_attribute12, p_attribute13=>:$column$.assign_attribute13, p_attribute14=>:$column$.assign_attribute14, p_attribute15=>:$column$.assign_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSET_ASSIGNMENTS' and fdfcuv.application_column_name='ATTRIBUTE8' 65 ASSIGN_ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSET_ASSIGNMENTS', p_context_name=>:$column$.assign_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.assign_attribute1, p_attribute2=>:$column$.assign_attribute2, p_attribute3=>:$column$.assign_attribute3, p_attribute4=>:$column$.assign_attribute4, p_attribute5=>:$column$.assign_attribute5, p_attribute6=>:$column$.assign_attribute6, p_attribute7=>:$column$.assign_attribute7, p_attribute8=>:$column$.assign_attribute8, p_attribute9=>:$column$.assign_attribute9, p_attribute10=>:$column$.assign_attribute10, p_attribute11=>:$column$.assign_attribute11, p_attribute12=>:$column$.assign_attribute12, p_attribute13=>:$column$.assign_attribute13, p_attribute14=>:$column$.assign_attribute14, p_attribute15=>:$column$.assign_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSET_ASSIGNMENTS' and fdfcuv.application_column_name='ATTRIBUTE9' 66 ASSIGN_ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSET_ASSIGNMENTS', p_context_name=>:$column$.assign_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.assign_attribute1, p_attribute2=>:$column$.assign_attribute2, p_attribute3=>:$column$.assign_attribute3, p_attribute4=>:$column$.assign_attribute4, p_attribute5=>:$column$.assign_attribute5, p_attribute6=>:$column$.assign_attribute6, p_attribute7=>:$column$.assign_attribute7, p_attribute8=>:$column$.assign_attribute8, p_attribute9=>:$column$.assign_attribute9, p_attribute10=>:$column$.assign_attribute10, p_attribute11=>:$column$.assign_attribute11, p_attribute12=>:$column$.assign_attribute12, p_attribute13=>:$column$.assign_attribute13, p_attribute14=>:$column$.assign_attribute14, p_attribute15=>:$column$.assign_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSET_ASSIGNMENTS' and fdfcuv.application_column_name='ATTRIBUTE10' 67 ASSIGN_ATTRIBUTE11 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSET_ASSIGNMENTS', p_context_name=>:$column$.assign_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.assign_attribute1, p_attribute2=>:$column$.assign_attribute2, p_attribute3=>:$column$.assign_attribute3, p_attribute4=>:$column$.assign_attribute4, p_attribute5=>:$column$.assign_attribute5, p_attribute6=>:$column$.assign_attribute6, p_attribute7=>:$column$.assign_attribute7, p_attribute8=>:$column$.assign_attribute8, p_attribute9=>:$column$.assign_attribute9, p_attribute10=>:$column$.assign_attribute10, p_attribute11=>:$column$.assign_attribute11, p_attribute12=>:$column$.assign_attribute12, p_attribute13=>:$column$.assign_attribute13, p_attribute14=>:$column$.assign_attribute14, p_attribute15=>:$column$.assign_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSET_ASSIGNMENTS' and fdfcuv.application_column_name='ATTRIBUTE11' 68 ASSIGN_ATTRIBUTE12 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSET_ASSIGNMENTS', p_context_name=>:$column$.assign_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.assign_attribute1, p_attribute2=>:$column$.assign_attribute2, p_attribute3=>:$column$.assign_attribute3, p_attribute4=>:$column$.assign_attribute4, p_attribute5=>:$column$.assign_attribute5, p_attribute6=>:$column$.assign_attribute6, p_attribute7=>:$column$.assign_attribute7, p_attribute8=>:$column$.assign_attribute8, p_attribute9=>:$column$.assign_attribute9, p_attribute10=>:$column$.assign_attribute10, p_attribute11=>:$column$.assign_attribute11, p_attribute12=>:$column$.assign_attribute12, p_attribute13=>:$column$.assign_attribute13, p_attribute14=>:$column$.assign_attribute14, p_attribute15=>:$column$.assign_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSET_ASSIGNMENTS' and fdfcuv.application_column_name='ATTRIBUTE12' 69 ASSIGN_ATTRIBUTE13 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSET_ASSIGNMENTS', p_context_name=>:$column$.assign_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.assign_attribute1, p_attribute2=>:$column$.assign_attribute2, p_attribute3=>:$column$.assign_attribute3, p_attribute4=>:$column$.assign_attribute4, p_attribute5=>:$column$.assign_attribute5, p_attribute6=>:$column$.assign_attribute6, p_attribute7=>:$column$.assign_attribute7, p_attribute8=>:$column$.assign_attribute8, p_attribute9=>:$column$.assign_attribute9, p_attribute10=>:$column$.assign_attribute10, p_attribute11=>:$column$.assign_attribute11, p_attribute12=>:$column$.assign_attribute12, p_attribute13=>:$column$.assign_attribute13, p_attribute14=>:$column$.assign_attribute14, p_attribute15=>:$column$.assign_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSET_ASSIGNMENTS' and fdfcuv.application_column_name='ATTRIBUTE13' 70 ASSIGN_ATTRIBUTE14 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSET_ASSIGNMENTS', p_context_name=>:$column$.assign_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.assign_attribute1, p_attribute2=>:$column$.assign_attribute2, p_attribute3=>:$column$.assign_attribute3, p_attribute4=>:$column$.assign_attribute4, p_attribute5=>:$column$.assign_attribute5, p_attribute6=>:$column$.assign_attribute6, p_attribute7=>:$column$.assign_attribute7, p_attribute8=>:$column$.assign_attribute8, p_attribute9=>:$column$.assign_attribute9, p_attribute10=>:$column$.assign_attribute10, p_attribute11=>:$column$.assign_attribute11, p_attribute12=>:$column$.assign_attribute12, p_attribute13=>:$column$.assign_attribute13, p_attribute14=>:$column$.assign_attribute14, p_attribute15=>:$column$.assign_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSET_ASSIGNMENTS' and fdfcuv.application_column_name='ATTRIBUTE14' 71 ASSIGN_ATTRIBUTE15 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>275, p_descriptive_flexfield_name=>'PA_PROJECT_ASSET_ASSIGNMENTS', p_context_name=>:$column$.assign_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.assign_attribute1, p_attribute2=>:$column$.assign_attribute2, p_attribute3=>:$column$.assign_attribute3, p_attribute4=>:$column$.assign_attribute4, p_attribute5=>:$column$.assign_attribute5, p_attribute6=>:$column$.assign_attribute6, p_attribute7=>:$column$.assign_attribute7, p_attribute8=>:$column$.assign_attribute8, p_attribute9=>:$column$.assign_attribute9, p_attribute10=>:$column$.assign_attribute10, p_attribute11=>:$column$.assign_attribute11, p_attribute12=>:$column$.assign_attribute12, p_attribute13=>:$column$.assign_attribute13, p_attribute14=>:$column$.assign_attribute14, p_attribute15=>:$column$.assign_attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=275 and fdfv.descriptive_flexfield_name='PA_PROJECT_ASSET_ASSIGNMENTS' and fdfcuv.application_column_name='ATTRIBUTE15' 72 UPLOAD_ROW Number number Y U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 4 p_org_id in Number OPERATING_UNIT U 5 p_pa_project_id in Number PROJECT_NUMBER U 6 p_pm_product_code in Char Y U 7 p_project_asset_id in/out Number PROJECT_ASSET_ID U 8 p_pm_asset_reference in Char Y ASSET_REFERENCE U 9 p_pa_asset_name in Char ASSET_NAME U 10 p_asset_description in Char DESCRIPTION U 11 p_project_asset_type in Char PROJECT_ASSET_TYPE U 12 p_asset_number in Char Y ASSET_NUMBER U 13 p_pm_product_source in Char Y PRODUCT_SOURCE U 14 p_book_type_code in Char Y BOOK U 15 p_asset_category in Char Y ASSET_CATEGORY U 16 p_asset_key in Char Y ASSET_KEY U 17 p_location in Char Y LOCATION U 18 p_assigned_to_person_id in Number Y EMPLOYEE_NAME U 19 p_estimated_in_service_date in Date Y ESTIMATED_IN_SERVICE_DATE U 20 p_date_placed_in_service in Date Y ACTUAL_IN_SERVICE_DATE U 21 p_estimated_asset_units in Number Y ESTIMATED_ASSET_UNITS U 22 p_asset_units in Number Y ACTUAL_UNITS U 23 p_estimated_cost in Number Y ESTIMATED_COST U 24 p_parent_asset_id in Number Y PARENT_ASSET_NUMBER U 25 p_depreciate_flag in Char Y DEPRECIATE U 26 p_amortize_flag in Char Y AMORTIZE_ADJUSTMENTS U 27 p_capital_hold_flag in Char Y CAPITAL_HOLD U 28 p_depr_expense_account in Char Y DEPRECIATION_EXPENSE_ACCOUNT U 29 p_manufacturer_name in Char Y MANUFACTURER_NAME U 30 p_model_number in Char Y MODEL_NUMBER U 31 p_serial_number in Char Y SERIAL_NUMBER U 32 p_tag_number in Char Y TAG_NUMBER U 33 p_asset_attribute_category in Char Y ASSET_ATTRIBUTE_CATEGORY U 34 p_asset_attribute1 in Char Y ASSET_ATTRIBUTE1 U 35 p_asset_attribute2 in Char Y ASSET_ATTRIBUTE2 U 36 p_asset_attribute3 in Char Y ASSET_ATTRIBUTE3 U 37 p_asset_attribute4 in Char Y ASSET_ATTRIBUTE4 U 38 p_asset_attribute5 in Char Y ASSET_ATTRIBUTE5 U 39 p_asset_attribute6 in Char Y ASSET_ATTRIBUTE6 U 40 p_asset_attribute7 in Char Y ASSET_ATTRIBUTE7 U 41 p_asset_attribute8 in Char Y ASSET_ATTRIBUTE8 U 42 p_asset_attribute9 in Char Y ASSET_ATTRIBUTE9 U 43 p_asset_attribute10 in Char Y ASSET_ATTRIBUTE10 U 44 p_asset_attribute11 in Char Y ASSET_ATTRIBUTE11 U 45 p_asset_attribute12 in Char Y ASSET_ATTRIBUTE12 U 46 p_asset_attribute13 in Char Y ASSET_ATTRIBUTE13 U 47 p_asset_attribute14 in Char Y ASSET_ATTRIBUTE14 U 48 p_asset_attribute15 in Char Y ASSET_ATTRIBUTE15 U 49 p_assignment_task_id in Number Y ASSIGNMENT_TASK_NUMBER U 50 p_rollup in Char Y ROLLUP U 51 p_delete_assignment in Char Y DELETE_ASSIGNMENT U 52 p_assign_attribute_category in Char Y ASSIGN_ATTRIBUTE_CATEGORY U 53 p_assign_attribute1 in Char Y ASSIGN_ATTRIBUTE1 U 54 p_assign_attribute2 in Char Y ASSIGN_ATTRIBUTE2 U 55 p_assign_attribute3 in Char Y ASSIGN_ATTRIBUTE3 U 56 p_assign_attribute4 in Char Y ASSIGN_ATTRIBUTE4 U 57 p_assign_attribute5 in Char Y ASSIGN_ATTRIBUTE5 U 58 p_assign_attribute6 in Char Y ASSIGN_ATTRIBUTE6 U 59 p_assign_attribute7 in Char Y ASSIGN_ATTRIBUTE7 U 60 p_assign_attribute8 in Char Y ASSIGN_ATTRIBUTE8 U 61 p_assign_attribute9 in Char Y ASSIGN_ATTRIBUTE9 U 62 p_assign_attribute10 in Char Y ASSIGN_ATTRIBUTE10 U 63 p_assign_attribute11 in Char Y ASSIGN_ATTRIBUTE11 U 64 p_assign_attribute12 in Char Y ASSIGN_ATTRIBUTE12 U 65 p_assign_attribute13 in Char Y ASSIGN_ATTRIBUTE13 U 66 p_assign_attribute14 in Char Y ASSIGN_ATTRIBUTE14 U 67 p_assign_attribute15 in Char Y ASSIGN_ATTRIBUTE15 Error SQL Order By upload_row, asset_name, assignment_task_number Success SQL select xu.action_, xu.status_, xu.message_, xu.request_id_, xu.modified_columns_, haouv.name operating_unit, ppa.segment1 project_number, ppa.name project_name, ppaa.project_asset_id, ppaa.pm_asset_reference asset_reference, ppaa.asset_name, ppaa.asset_description description, xxen_util.meaning(ppaa.project_asset_type,'PROJECT_ASSET_TYPES',275) project_asset_type, ppaa.asset_number, xxen_util.meaning(ppaa.pm_product_code,'PM_PRODUCT_CODE',275) product_source, ppaa.book_type_code book, fcbk.concatenated_segments asset_category, fakk.concatenated_segments asset_key, flk.concatenated_segments location, papf.full_name employee_name, papf.employee_number, ppaa.estimated_in_service_date, ppaa.date_placed_in_service actual_in_service_date, ppaa.estimated_asset_units, ppaa.asset_units actual_units, ppaa.estimated_cost, fa.asset_number parent_asset_number, decode(ppaa.depreciate_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) depreciate, decode(ppaa.amortize_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) amortize_adjustments, gcck.concatenated_segments depreciation_expense_account, decode(ppaa.capital_hold_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) capital_hold, ppaa.manufacturer_name, ppaa.model_number, ppaa.serial_number, ppaa.tag_number, xxen_util.display_flexfield_context(275,'PA_PROJECT_ASSETS',ppaa.attribute_category) asset_attribute_category, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE1',ppaa.rowid,ppaa.attribute1) asset_attribute1, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE2',ppaa.rowid,ppaa.attribute2) asset_attribute2, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE3',ppaa.rowid,ppaa.attribute3) asset_attribute3, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE4',ppaa.rowid,ppaa.attribute4) asset_attribute4, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE5',ppaa.rowid,ppaa.attribute5) asset_attribute5, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE6',ppaa.rowid,ppaa.attribute6) asset_attribute6, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE7',ppaa.rowid,ppaa.attribute7) asset_attribute7, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE8',ppaa.rowid,ppaa.attribute8) asset_attribute8, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE9',ppaa.rowid,ppaa.attribute9) asset_attribute9, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE10',ppaa.rowid,ppaa.attribute10) asset_attribute10, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE11',ppaa.rowid,ppaa.attribute11) asset_attribute11, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE12',ppaa.rowid,ppaa.attribute12) asset_attribute12, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE13',ppaa.rowid,ppaa.attribute13) asset_attribute13, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE14',ppaa.rowid,ppaa.attribute14) asset_attribute14, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSETS',ppaa.attribute_category,'ATTRIBUTE15',ppaa.rowid,ppaa.attribute15) asset_attribute15, pt.task_id assignment_task_id, pt.task_number assignment_task_number, decode(case when pt.task_id is not null and pt.task_id=pt.top_task_id then 'Y' end,'Y',xxen_util.meaning('Y','YES_NO',0)) rollup, xu.delete_assignment, xxen_util.display_flexfield_context(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category) assign_attribute_category, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE1',paas.rowid,paas.attribute1) assign_attribute1, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE2',paas.rowid,paas.attribute2) assign_attribute2, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE3',paas.rowid,paas.attribute3) assign_attribute3, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE4',paas.rowid,paas.attribute4) assign_attribute4, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE5',paas.rowid,paas.attribute5) assign_attribute5, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE6',paas.rowid,paas.attribute6) assign_attribute6, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE7',paas.rowid,paas.attribute7) assign_attribute7, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE8',paas.rowid,paas.attribute8) assign_attribute8, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE9',paas.rowid,paas.attribute9) assign_attribute9, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE10',paas.rowid,paas.attribute10) assign_attribute10, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE11',paas.rowid,paas.attribute11) assign_attribute11, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE12',paas.rowid,paas.attribute12) assign_attribute12, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE13',paas.rowid,paas.attribute13) assign_attribute13, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE14',paas.rowid,paas.attribute14) assign_attribute14, xxen_util.display_flexfield_value(275,'PA_PROJECT_ASSET_ASSIGNMENTS',paas.attribute_category,'ATTRIBUTE15',paas.rowid,paas.attribute15) assign_attribute15, xu.upload_row from xxen_pa_project_asset_u_5373_u xu, pa_projects_all ppa, hr_all_organization_units_vl haouv, pa_project_assets_all ppaa, pa_project_asset_assignments paas, pa_tasks pt, fa_categories_b_kfv fcbk, fa_asset_keywords_kfv fakk, fa_locations_kfv flk, fa_additions_v fa, gl_code_combinations_kfv gcck, per_all_people_f papf where xu.status_code_=xxen_upload.status_success and xu.project_number=ppa.segment1 and ppa.org_id=haouv.organization_id and ppa.project_id=ppaa.project_id and ppaa.asset_name=xu.asset_name and ppaa.project_asset_id=paas.project_asset_id(+) and paas.project_id(+)<>0 and paas.task_id=pt.task_id(+) and (xu.assignment_task_number is null or pt.task_number=xu.assignment_task_number) and ppaa.asset_category_id=fcbk.category_id(+) and ppaa.asset_key_ccid=fakk.code_combination_id(+) and ppaa.location_id=flk.location_id(+) and ppaa.parent_asset_id=fa.asset_id(+) and ppaa.depreciation_expense_ccid=gcck.code_combination_id(+) and ppaa.assigned_to_person_id=papf.person_id(+) and trunc(sysdate) between papf.effective_start_date(+) and papf.effective_end_date(+)