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, -- asset line to_number(null) asset_line_id, null line_task_number, null line_description, null line_asset_category, to_number(null) line_cost, null line_transfer_status, null line_asset_name, 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 nvl(:p_asset_lines,'N')='N' 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(+) union all select null action_, null status_, null message_, null request_id_, null modified_columns_, haouv.name operating_unit, ppa.segment1 project_number, ppa.name project_name, to_number(null) project_asset_id, null asset_reference, null asset_name, null description, null project_asset_type, null asset_number, null product_source, null book, null asset_category, null asset_key, null location, null employee_name, null employee_number, to_date(null) estimated_in_service_date, to_date(null) actual_in_service_date, to_number(null) estimated_asset_units, to_number(null) actual_units, to_number(null) estimated_cost, null parent_asset_number, null depreciate, null amortize_adjustments, null depreciation_expense_account, null capital_hold, null manufacturer_name, null model_number, null serial_number, null tag_number, null asset_attribute_category, null asset_attribute1, null asset_attribute2, null asset_attribute3, null asset_attribute4, null asset_attribute5, null asset_attribute6, null asset_attribute7, null asset_attribute8, null asset_attribute9, null asset_attribute10, null asset_attribute11, null asset_attribute12, null asset_attribute13, null asset_attribute14, null asset_attribute15, to_number(null) assignment_task_id, null assignment_task_number, null rollup, null delete_assignment, null assign_attribute_category, null assign_attribute1, null assign_attribute2, null assign_attribute3, null assign_attribute4, null assign_attribute5, null assign_attribute6, null assign_attribute7, null assign_attribute8, null assign_attribute9, null assign_attribute10, null assign_attribute11, null assign_attribute12, null assign_attribute13, null assign_attribute14, null assign_attribute15, pal.project_asset_line_id asset_line_id, pt.task_number line_task_number, pal.description line_description, fcbk.concatenated_segments line_asset_category, pal.current_asset_cost line_cost, xxen_util.meaning(pal.transfer_status_code,'TRANSFER STATUS',275) line_transfer_status, ppaa.asset_name line_asset_name, to_number(null) upload_row from pa_projects_all ppa, hr_all_organization_units_vl haouv, pa_project_asset_lines_all pal, pa_tasks pt, fa_categories_b_kfv fcbk, pa_project_assets_all ppaa where 1=1 and 2=2 and :p_asset_lines='Y' and ppa.org_id=haouv.organization_id and ppa.project_id=pal.project_id and pal.task_id=pt.task_id(+) and pal.asset_category_id=fcbk.category_id(+) and pal.project_asset_id=ppaa.project_asset_id(+) Asset lines: new Asset Lines and Unassigned Asset Lines Only parameters download the asset lines generated by PRC: Generate Asset Lines, one row per line, and the new Line Asset Name and Line Description columns assign a line to a project asset or change its description, as the Capital Projects form does. New Asset Lines template. 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 Asset Lines: - With the Asset Lines parameter (or the Asset Lines template) the download lists the asset lines of the project generated by PRC: Generate Asset Lines, one row per line, instead of the assets - Line Asset Name assigns the line to a project asset, as Assign Asset in the Capital Projects form does: the asset must be assigned to the line's task (or the task carries a common assignment), be placed in service and not be on capital hold; blank unassigns the line - Transferred lines cannot be changed 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 2=2 :p_asset_lines 1 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create||','||xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C Y US Upload Mode 2 20 1=1 haouv.name=:p_operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') order by hou.name Y US Operating Unit 3 30 1=1 ppa.segment1=:p_project_number LOV custom 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 4 40 :p_asset_lines LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Asset Lines Download the asset lines of the project, one row per line, to assign them to project assets, instead of the assets. 5 50 2=2 pal.project_asset_id=0 LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Unassigned Asset Lines Only D2A659CBCE0C4E7EAA201D93467B7F57 Asset Lines Assign the asset lines of a project to project assets. ENGINATICS 6 LINE_ASSET_CATEGORY 9 LINE_ASSET_NAME 7 LINE_COST 5 LINE_DESCRIPTION Y 4 LINE_TASK_NUMBER 8 LINE_TRANSFER_STATUS 1 OPERATING_UNIT 3 PROJECT_NAME 2 PROJECT_NUMBER Asset Lines Y Y Upload Mode C,U Y S Site 8C6DBD2EE9D9466CB4DF0A108047E17F Default All columns except the descriptive flexfield attributes. ENGINATICS 17 ACTUAL_IN_SERVICE_DATE 19 ACTUAL_UNITS 23 AMORTIZE_ADJUSTMENTS 11 ASSET_CATEGORY 12 ASSET_KEY 5 ASSET_NAME Y 8 ASSET_NUMBER 4 ASSET_REFERENCE 30 ASSIGNMENT_TASK_NUMBER 10 BOOK 25 CAPITAL_HOLD 32 DELETE_ASSIGNMENT 22 DEPRECIATE 24 DEPRECIATION_EXPENSE_ACCOUNT 6 DESCRIPTION 14 EMPLOYEE_NAME 15 EMPLOYEE_NUMBER 18 ESTIMATED_ASSET_UNITS 20 ESTIMATED_COST 16 ESTIMATED_IN_SERVICE_DATE 13 LOCATION 26 MANUFACTURER_NAME 27 MODEL_NUMBER 1 OPERATING_UNIT 21 PARENT_ASSET_NUMBER 9 PRODUCT_SOURCE 7 PROJECT_ASSET_TYPE 3 PROJECT_NAME 2 PROJECT_NUMBER 31 ROLLUP 28 SERIAL_NUMBER 29 TAG_NUMBER S Site Asset Lines Unassigned Asset Lines Only 8C6DBD2EE9D9466CB4DF0A108047E17F 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 varchar2 240 HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') order by hou.name select hou.organization_id id, hou.name value from hr_operating_units hou :$flex$.Operating_Unit Y 7 PROJECT_NUMBER LOV custom varchar2 25 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 Y 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 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 varchar2 PA Product Source 7DB0C1A32DAA46EC981CF86FACF6FD2A 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 varchar2 15 FA Corporate Book 364C1D4B86EA4FBB83EB087842266EE4 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 17 ASSET_CATEGORY LOV custom varchar2 61 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 varchar2 30 FA Asset Key (enabled) F7210CC6040347A98CB7425B870D322B select fak.concatenated_segments value, null description from fa_asset_keywords_kfv fak where fak.enabled_flag='Y' order by fak.concatenated_segments 19 LOCATION LOV varchar2 123 FA Location 52DE5BFC788B4E52AEF5586BD84BADFE 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 20 EMPLOYEE_NAME LOV varchar2 240 PER Current Employee F68ED410EDE0483B8E85686384D76F0A 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 papf.full_name 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 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 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 29 AMORTIZE_ADJUSTMENTS LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 30 DEPRECIATION_EXPENSE_ACCOUNT LOV custom varchar2 311 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 55 DELETE_ASSIGNMENT LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 56 ASSIGN_ATTRIBUTE_CATEGORY LOV custom varchar2 select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 ASSET_LINE_ID Number number Y 73 LINE_TASK_NUMBER Char varchar2 25 Y 74 LINE_DESCRIPTION Char varchar2 80 75 LINE_ASSET_CATEGORY Char varchar2 240 Y 76 LINE_COST Number number Y 77 LINE_TRANSFER_STATUS Char varchar2 80 Y 78 LINE_ASSET_NAME LOV custom varchar2 240 select ppaa.project_asset_id id, ppaa.asset_name value, ppaa.asset_description description from pa_project_asset_lines_all pal, pa_project_assets_all ppaa where pal.project_asset_line_id=:$column$.asset_line_id and pal.project_id=ppaa.project_id and ppaa.date_placed_in_service is not null and (ppaa.project_asset_type is null or ppaa.project_asset_type=decode(pal.line_type,'R','RETIREMENT_ADJUSTMENT','AS-BUILT')) and nvl(ppaa.capital_hold_flag,'N')='N' and ppaa.capital_event_id=pal.capital_event_id and exists (select null from pa_project_asset_assignments paas where paas.project_id=pal.project_id and paas.task_id=nvl(pal.task_id,0) and paas.project_asset_id in (ppaa.project_asset_id,0)) order by value Project asset the asset line is assigned to. Lists the assets assigned to the line's task, placed in service and not on capital hold. Blank unassigns the line. 79 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 U 68 p_project_asset_line_id in Number Y ASSET_LINE_ID U 69 p_line_project_asset_id in Number Y LINE_ASSET_NAME U 70 p_line_description in Char Y LINE_DESCRIPTION Error SQL Order By upload_row, asset_name, assignment_task_number, line_task_number, asset_line_id 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, to_number(null) asset_line_id, null line_task_number, null line_description, null line_asset_category, to_number(null) line_cost, null line_transfer_status, null line_asset_name, 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.asset_line_id is null 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(+) union all 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, to_number(null) project_asset_id, null asset_reference, null asset_name, null description, null project_asset_type, null asset_number, null product_source, null book, null asset_category, null asset_key, null location, null employee_name, null employee_number, to_date(null) estimated_in_service_date, to_date(null) actual_in_service_date, to_number(null) estimated_asset_units, to_number(null) actual_units, to_number(null) estimated_cost, null parent_asset_number, null depreciate, null amortize_adjustments, null depreciation_expense_account, null capital_hold, null manufacturer_name, null model_number, null serial_number, null tag_number, null asset_attribute_category, null asset_attribute1, null asset_attribute2, null asset_attribute3, null asset_attribute4, null asset_attribute5, null asset_attribute6, null asset_attribute7, null asset_attribute8, null asset_attribute9, null asset_attribute10, null asset_attribute11, null asset_attribute12, null asset_attribute13, null asset_attribute14, null asset_attribute15, to_number(null) assignment_task_id, null assignment_task_number, null rollup, null delete_assignment, null assign_attribute_category, null assign_attribute1, null assign_attribute2, null assign_attribute3, null assign_attribute4, null assign_attribute5, null assign_attribute6, null assign_attribute7, null assign_attribute8, null assign_attribute9, null assign_attribute10, null assign_attribute11, null assign_attribute12, null assign_attribute13, null assign_attribute14, null assign_attribute15, pal.project_asset_line_id asset_line_id, pt.task_number line_task_number, pal.description line_description, fcbk.concatenated_segments line_asset_category, pal.current_asset_cost line_cost, xxen_util.meaning(pal.transfer_status_code,'TRANSFER STATUS',275) line_transfer_status, ppaa.asset_name line_asset_name, xu.upload_row from xxen_pa_project_asset_u_5373_u xu, pa_project_asset_lines_all pal, pa_projects_all ppa, hr_all_organization_units_vl haouv, pa_tasks pt, fa_categories_b_kfv fcbk, pa_project_assets_all ppaa where xu.status_code_=xxen_upload.status_success and xu.asset_line_id=pal.project_asset_line_id and pal.project_id=ppa.project_id and ppa.org_id=haouv.organization_id and pal.task_id=pt.task_id(+) and pal.asset_category_id=fcbk.category_id(+) and pal.project_asset_id=ppaa.project_asset_id(+)