ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 470AFB13A1804A1A91860A140B407BF7Y select null action_, null status_, null message_, null modified_columns_, haouv.name operating_unit, ppx.full_name employee_name, nvl(ppx.employee_number,ppx.npw_number) employee_number, aerha.week_end_date report_date, aerha.invoice_num, aerha.default_currency_code currency, aerha.total amount, aerha.description, (select alc.displayed_field from ap_lookup_codes alc where alc.lookup_type='HOLD CODE' and aerha.hold_lookup_code=alc.lookup_code) hold, xxen_util.meaning(aerha.expense_check_address_flag,'HOME_OFFICE',3) send_to, gcck_h.concatenated_segments gl_account, aera.report_type template, gdct.user_conversion_type exchange_rate_type, aerha.default_exchange_date exchange_date, aerha.default_exchange_rate exchange_rate, aag_h.name withholding_tax_group, xxen_util.yes(case when aerha.vouchno<>0 then 'Y' end) exported, aerha.reject_code export_rejection, xxen_util.display_flexfield_context(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category) header_attribute_category, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE1',aerha.rowid,aerha.attribute1) header_attribute1, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE2',aerha.rowid,aerha.attribute2) header_attribute2, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE3',aerha.rowid,aerha.attribute3) header_attribute3, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE4',aerha.rowid,aerha.attribute4) header_attribute4, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE5',aerha.rowid,aerha.attribute5) header_attribute5, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE6',aerha.rowid,aerha.attribute6) header_attribute6, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE7',aerha.rowid,aerha.attribute7) header_attribute7, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE8',aerha.rowid,aerha.attribute8) header_attribute8, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE9',aerha.rowid,aerha.attribute9) header_attribute9, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE10',aerha.rowid,aerha.attribute10) header_attribute10, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE11',aerha.rowid,aerha.attribute11) header_attribute11, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE12',aerha.rowid,aerha.attribute12) header_attribute12, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE13',aerha.rowid,aerha.attribute13) header_attribute13, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE14',aerha.rowid,aerha.attribute14) header_attribute14, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE15',aerha.rowid,aerha.attribute15) header_attribute15, aerla.distribution_line_number line_number, aerla.item_description item, aerla.amount line_amount, gcck_l.concatenated_segments line_gl_account, aerla.vat_code tax_code, aag_l.name line_withholding_tax_group, aerla.merchant_name, aerla.merchant_document_number, aerla.merchant_tax_reg_number, aerla.merchant_taxpayer_id, aerla.start_expense_date receipt_date, ftv.territory_short_name country_of_supply, aerla.merchant_reference reference, aerla.receipt_currency_code receipt_currency, aerla.receipt_conversion_rate receipt_exchange_rate, aerla.receipt_currency_amount receipt_amount, aerla.justification, xxen_util.yes(aerla.receipt_verified_flag) receipt_verified, xxen_util.yes(aerla.receipt_required_flag) receipt_required, xxen_util.yes(aerla.receipt_missing_flag) receipt_missing, ppa.segment1 project, pt.task_number task, aerla.expenditure_type, haouv_exp.name expenditure_organization, aerla.expenditure_item_date, xxen_util.display_flexfield_context(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category) line_attribute_category, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE1',aerla.rowid,aerla.attribute1) line_attribute1, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE2',aerla.rowid,aerla.attribute2) line_attribute2, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE3',aerla.rowid,aerla.attribute3) line_attribute3, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE4',aerla.rowid,aerla.attribute4) line_attribute4, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE5',aerla.rowid,aerla.attribute5) line_attribute5, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE6',aerla.rowid,aerla.attribute6) line_attribute6, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE7',aerla.rowid,aerla.attribute7) line_attribute7, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE8',aerla.rowid,aerla.attribute8) line_attribute8, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE9',aerla.rowid,aerla.attribute9) line_attribute9, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE10',aerla.rowid,aerla.attribute10) line_attribute10, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE11',aerla.rowid,aerla.attribute11) line_attribute11, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE12',aerla.rowid,aerla.attribute12) line_attribute12, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE13',aerla.rowid,aerla.attribute13) line_attribute13, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE14',aerla.rowid,aerla.attribute14) line_attribute14, xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE15',aerla.rowid,aerla.attribute15) line_attribute15, null delete_line, :p_submit_export submit_export, aerha.report_header_id, aerla.report_line_id, null upload_row from ap_expense_report_headers_all aerha, hr_all_organization_units_vl haouv, per_people_x ppx, gl_code_combinations_kfv gcck_h, ap_expense_reports_all aera, gl_daily_conversion_types gdct, ap_awt_groups aag_h, ap_expense_report_lines_all aerla, gl_code_combinations_kfv gcck_l, ap_awt_groups aag_l, fnd_territories_vl ftv, pa_projects_all ppa, pa_tasks pt, hr_all_organization_units_vl haouv_exp where 1=1 and aerha.source='XpenseXpress' and aerha.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat) and aerha.org_id=haouv.organization_id and aerha.employee_id=ppx.person_id(+) and aerha.employee_ccid=gcck_h.code_combination_id(+) and aerha.expense_report_id=aera.expense_report_id(+) and aerha.default_exchange_rate_type=gdct.conversion_type(+) and aerha.awt_group_id=aag_h.group_id(+) and aerha.report_header_id=aerla.report_header_id(+) and nvl(aerla.itemization_parent_id(+),0)<>-1 and aerla.code_combination_id=gcck_l.code_combination_id(+) and aerla.awt_group_id=aag_l.group_id(+) and aerla.country_of_supply=ftv.territory_code(+) and aerla.project_id=ppa.project_id(+) and aerla.task_id=pt.task_id(+) and aerla.expenditure_organization_id=haouv_exp.organization_id(+) Initial version: create and update expense reports and lines, delete lines, as in the Payables Expense Reports form, and transfer them to Payables with Expense Report Export. U A xxen_ap_upload.upload_expense_report US AP Expense Report Upload Creates and updates expense reports - the Excel equivalent of the Payables Expense Reports form (Invoices > Entry > Expense Reports) - and transfers them to Payables invoices with Expense Report Export. Each row is one expense report line, with the expense report header columns repeated on every line. The header values are taken from the first row of each expense report. An expense report is identified by Employee and Invoice Num. Each expense report is processed as a whole: when any of its rows fails validation, none of its rows are saved. The Amount must equal the total of the lines; leave it unchanged to set it to the total of the lines. The account of a line defaults from the GL Account of the expense report, overlaid with the account segments of the expense item, as in the form. Set Delete Line to Yes to delete a line. With Submit Expense Report Export set to Yes, Expense Report Export runs for the operating units of the uploaded expense reports and creates the Payables invoices. As in Payables, it transfers every expense report pending export in the operating unit, also those not in the upload file. Rows of an expense report that it did not transfer (rejected, or on hold) show the reason as an error, and the expense report can be corrected and uploaded again. An exported expense report cannot be changed. Enginatics R12 only Upload 1=1 :p_submit_export 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,U Y US Upload Mode 2 20 :p_submit_export LOV Oracle Yes_No select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y Y US Submit Expense Report Export Runs Expense Report Export for the uploaded expense reports, which creates the Payables invoices. 3 30 1=1 haouv.name=: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 coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit 4 40 1=1 ppx.full_name=:employee_name LOV custom select distinct ppx.full_name value, nvl(ppx.employee_number,ppx.npw_number) description from ap_expense_report_headers_all aerha, per_people_x ppx where aerha.source='XpenseXpress' and aerha.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat) and aerha.employee_id=ppx.person_id order by ppx.full_name US Employee Name 5 50 1=1 aerha.invoice_num=:invoice_num Char US Invoice Num 6 60 1=1 aerha.week_end_date>=:report_date_from Date US Report Date From 7 70 1=1 aerha.week_end_date<:report_date_to+1 Date US Report Date To 8 80 1=1 aerha.vouchno=0 LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Not Exported Only BFB158995E7544DCBD5291B970E2EEBD Default All columns except the descriptive flexfield attributes. ENGINATICS 7 AMOUNT 30 COUNTRY_OF_SUPPLY 6 CURRENCY Y 44 DELETE_LINE 8 DESCRIPTION 2 EMPLOYEE_NAME 3 EMPLOYEE_NUMBER 14 EXCHANGE_DATE 15 EXCHANGE_RATE 13 EXCHANGE_RATE_TYPE 43 EXPENDITURE_ITEM_DATE 42 EXPENDITURE_ORGANIZATION 41 EXPENDITURE_TYPE 17 EXPORTED 18 EXPORT_REJECTION 11 GL_ACCOUNT 9 HOLD 5 INVOICE_NUM 20 ITEM 35 JUSTIFICATION 21 LINE_AMOUNT 22 LINE_GL_ACCOUNT 19 LINE_NUMBER 24 LINE_WITHHOLDING_TAX_GROUP 26 MERCHANT_DOCUMENT_NUMBER 25 MERCHANT_NAME 28 MERCHANT_TAXPAYER_ID 27 MERCHANT_TAX_REG_NUMBER 1 OPERATING_UNIT 39 PROJECT 34 RECEIPT_AMOUNT 32 RECEIPT_CURRENCY 29 RECEIPT_DATE 33 RECEIPT_EXCHANGE_RATE 38 RECEIPT_MISSING 37 RECEIPT_REQUIRED 36 RECEIPT_VERIFIED 31 REFERENCE 4 REPORT_DATE 10 SEND_TO 40 TASK 23 TAX_CODE 12 TEMPLATE 16 WITHHOLDING_TAX_GROUP Upload Mode C,U S Site 4A78BB20710D4A04A0703358F1320873 New Expense Reports Enters new expense reports, one row per expense line, with the columns of the Expense Reports window. The line account defaults from the employee and the expense item. ENGINATICS 6 CURRENCY Y 7 DESCRIPTION 2 EMPLOYEE_NAME 3 EMPLOYEE_NUMBER 20 EXPENDITURE_ORGANIZATION 19 EXPENDITURE_TYPE 5 INVOICE_NUM 9 ITEM 16 JUSTIFICATION 10 LINE_AMOUNT 11 LINE_GL_ACCOUNT 12 MERCHANT_NAME 1 OPERATING_UNIT 17 PROJECT 14 RECEIPT_CURRENCY 13 RECEIPT_DATE 15 RECEIPT_EXCHANGE_RATE 4 REPORT_DATE 18 TASK 8 TEMPLATE Upload Mode C Y S Site Employee Name Invoice Num Not Exported Only Report Date From Report Date To BFB158995E7544DCBD5291B970E2EEBD 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 OPERATING_UNIT LOV varchar2 240 HR Operating Unit for Upload F263DDA3FBF60F8FE0530100007F75CD select hou.organization_id id, hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.operating_unit is null or hou.name=:$flex$.operating_unit) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name :$flex$.operating_unit Y Y 6 EMPLOYEE_NAME LOV custom varchar2 240 select pex.full_name value, pex.employee_num description from hr_operating_units hou, financials_system_params_all fspa, per_employees_x pex where hou.name=:$column$.operating_unit and hou.organization_id=fspa.org_id and fspa.business_group_id=pex.business_group_id order by pex.full_name The employee the expense report is for. Together with Invoice Num, it identifies the expense report. Y Y 7 EMPLOYEE_NUMBER LOV custom varchar2 30 select pex.employee_num value, pex.full_name description from hr_operating_units hou, financials_system_params_all fspa, per_employees_x pex where hou.name=:$column$.operating_unit and hou.organization_id=fspa.org_id and fspa.business_group_id=pex.business_group_id and (:$column$.employee_name is null or pex.full_name=:$column$.employee_name) order by pex.employee_num select pex.employee_num from hr_operating_units hou, financials_system_params_all fspa, per_employees_x pex where hou.name=:$column$.operating_unit and hou.organization_id=fspa.org_id and fspa.business_group_id=pex.business_group_id and pex.full_name=:$column$.employee_name Identifies the employee when several employees share the same name. Y 8 REPORT_DATE Date date Expense report date. Defaults the receipt date of the lines. Y 9 INVOICE_NUM Char varchar2 50 Invoice number of the expense report, unique per employee. Y 10 CURRENCY LOV varchar2 15 FND Currency 8E2FF36EDE9079D2E0530100007F1FF2 select fcv.currency_code id, fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' order by fcv.currency_code select aspa.invoice_currency_code from hr_operating_units hou, ap_system_parameters_all aspa where hou.name=:$column$.operating_unit and hou.organization_id=aspa.org_id Y 11 AMOUNT Number number Control total of the expense report. Leave it unchanged to set it to the total of the lines. An entered amount must equal the total of the lines. 12 DESCRIPTION Char varchar2 240 13 HOLD LOV custom varchar2 80 select alc.displayed_field value, ahc.description from ap_lookup_codes alc, ap_hold_codes ahc where alc.lookup_type='HOLD CODE' and alc.lookup_code=ahc.hold_lookup_code and ahc.hold_type='INVOICE HOLD REASON' and ahc.hold_lookup_code<>'INVALID PO' and nvl(ahc.inactive_date,sysdate+1)>=sysdate order by alc.displayed_field Expense Report Export does not transfer an expense report on hold. 14 SEND_TO LOV custom varchar2 80 select hl.meaning value, null description from hr_lookups hl where hl.lookup_type='HOME_OFFICE' and hl.lookup_code in ('H','O') order by hl.lookup_code Defaults from the employee. 15 GL_ACCOUNT LOV custom varchar2 2000 Y select gcck.concatenated_segments value, xxen_util.segments_description(gcck.code_combination_id) description from hr_operating_units hou, gl_ledgers gl, gl_code_combinations_kfv gcck where hou.name=:$column$.operating_unit and to_number(hou.set_of_books_id)=gl.ledger_id and gl.chart_of_accounts_id=gcck.chart_of_accounts_id and gcck.enabled_flag='Y' and gcck.summary_flag='N' and gcck.detail_posting_allowed='Y' and trunc(sysdate) between nvl(gcck.start_date_active,trunc(sysdate)) and nvl(gcck.end_date_active,trunc(sysdate)) order by value select gcck.concatenated_segments from hr_operating_units hou, financials_system_params_all fspa, per_employees_x pex, gl_code_combinations_kfv gcck where hou.name=:$column$.operating_unit and hou.organization_id=fspa.org_id and fspa.business_group_id=pex.business_group_id and pex.employee_num=:$column$.employee_number and pex.default_code_combination_id=gcck.code_combination_id Defaults from the employee's default expense account. The account of each line defaults from it, overlaid with the account segments of the expense item. 16 TEMPLATE LOV custom varchar2 25 select aera.report_type value, aera.description from hr_operating_units hou, ap_expense_reports_all aera where hou.name=:$column$.operating_unit and hou.organization_id=aera.org_id and nvl(aera.inactive_date,sysdate+1)>sysdate order by aera.report_type select aera.report_type from hr_operating_units hou, ap_expense_reports_all aera where hou.name=:$column$.operating_unit and hou.organization_id=aera.org_id and nvl(aera.inactive_date,sysdate+1)>sysdate and 1=(select count(*) from ap_expense_reports_all aera2 where aera2.org_id=hou.organization_id and nvl(aera2.inactive_date,sysdate+1)>sysdate) Expense report template, which determines the expense items of the lines. Y 17 EXCHANGE_RATE_TYPE LOV varchar2 30 GL Currency Conversion Type 91D3167A335F1204E053BB6B63585EE3 select gdct.conversion_type id, gdct.user_conversion_type value, gdct.description from gl_daily_conversion_types gdct order by gdct.user_conversion_type select gdct.user_conversion_type from ap_system_parameters_all aspa, gl_daily_conversion_types gdct where aspa.org_id=(select hou.organization_id from hr_operating_units hou where hou.name=:$column$.operating_unit) and aspa.base_currency_code<>:$column$.currency and aspa.default_exchange_rate_type=gdct.conversion_type Required for a foreign currency expense report. 18 EXCHANGE_DATE Date date Defaults to the report date for a foreign currency expense report. 19 EXCHANGE_RATE Number number Required for the User rate type, derived from the daily rates otherwise. 20 WITHHOLDING_TAX_GROUP LOV custom varchar2 25 select aag.name value, aag.description from ap_awt_groups aag where nvl(aag.inactive_date,sysdate+1)>sysdate order by aag.name Defaults from the employee supplier. 21 EXPORTED Char varchar2 80 Yes when Expense Report Export has transferred the expense report to Payables. An exported expense report cannot be changed. Y 22 EXPORT_REJECTION Char varchar2 240 The reason why Expense Report Export rejected the expense report. Y 23 HEADER_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 fdfv.descriptive_flexfield_name='AP_EXPENSE_REPORT_HEADERS' and fdfv.application_id=200 and fdfv.application_id=fdfcv.application_id and fdfv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 24 HEADER_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_HEADERS', p_context_name => :$column$.header_attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_HEADERS' and dffcu.application_column_name='ATTRIBUTE1' 25 HEADER_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_HEADERS', p_context_name => :$column$.header_attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_HEADERS' and dffcu.application_column_name='ATTRIBUTE2' 26 HEADER_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_HEADERS', p_context_name => :$column$.header_attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_HEADERS' and dffcu.application_column_name='ATTRIBUTE3' 27 HEADER_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_HEADERS', p_context_name => :$column$.header_attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_HEADERS' and dffcu.application_column_name='ATTRIBUTE4' 28 HEADER_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_HEADERS', p_context_name => :$column$.header_attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_HEADERS' and dffcu.application_column_name='ATTRIBUTE5' 29 HEADER_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_HEADERS', p_context_name => :$column$.header_attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_HEADERS' and dffcu.application_column_name='ATTRIBUTE6' 30 HEADER_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_HEADERS', p_context_name => :$column$.header_attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_HEADERS' and dffcu.application_column_name='ATTRIBUTE7' 31 HEADER_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_HEADERS', p_context_name => :$column$.header_attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_HEADERS' and dffcu.application_column_name='ATTRIBUTE8' 32 HEADER_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_HEADERS', p_context_name => :$column$.header_attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_HEADERS' and dffcu.application_column_name='ATTRIBUTE9' 33 HEADER_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_HEADERS', p_context_name => :$column$.header_attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_HEADERS' and dffcu.application_column_name='ATTRIBUTE10' 34 HEADER_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_HEADERS', p_context_name => :$column$.header_attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_HEADERS' and dffcu.application_column_name='ATTRIBUTE11' 35 HEADER_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_HEADERS', p_context_name => :$column$.header_attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_HEADERS' and dffcu.application_column_name='ATTRIBUTE12' 36 HEADER_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_HEADERS', p_context_name => :$column$.header_attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_HEADERS' and dffcu.application_column_name='ATTRIBUTE13' 37 HEADER_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_HEADERS', p_context_name => :$column$.header_attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_HEADERS' and dffcu.application_column_name='ATTRIBUTE14' 38 HEADER_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_HEADERS', p_context_name => :$column$.header_attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_HEADERS' and dffcu.application_column_name='ATTRIBUTE15' 39 LINE_NUMBER Number number Identifies the line within the expense report. Leave it blank on a new line to add it as the next line number. 40 ITEM LOV custom varchar2 80 select aerpa.prompt value, alc.displayed_field description from hr_operating_units hou, ap_expense_reports_all aera, ap_expense_report_params_all aerpa, ap_lookup_codes alc where hou.name=:$column$.operating_unit and hou.organization_id=aera.org_id and aera.report_type=:$column$.template and aera.expense_report_id=aerpa.expense_report_id and trunc(sysdate)<=nvl(aerpa.end_date,trunc(sysdate)) and alc.lookup_type='INVOICE DISTRIBUTION TYPE' and aerpa.line_type_lookup_code=alc.lookup_code order by aerpa.prompt Expense item of the template. 41 LINE_AMOUNT Number number 42 LINE_GL_ACCOUNT LOV custom varchar2 2000 Y select gcck.concatenated_segments value, xxen_util.segments_description(gcck.code_combination_id) description from hr_operating_units hou, gl_ledgers gl, gl_code_combinations_kfv gcck where hou.name=:$column$.operating_unit and to_number(hou.set_of_books_id)=gl.ledger_id and gl.chart_of_accounts_id=gcck.chart_of_accounts_id and gcck.enabled_flag='Y' and gcck.summary_flag='N' and gcck.detail_posting_allowed='Y' and trunc(sysdate) between nvl(gcck.start_date_active,trunc(sysdate)) and nvl(gcck.end_date_active,trunc(sysdate)) order by value select xxen_ap_upload.expense_line_account(:$column$.operating_unit,:$column$.template,:$column$.item,:$column$.gl_account) from dual Defaults from the GL Account of the expense report, overlaid with the account segments of the expense item. 43 TAX_CODE LOV custom varchar2 30 select distinct zwcv.lookup_code value, zwcv.description from hr_operating_units hou, zx_webexp_classifications_v zwcv where hou.name=:$column$.operating_unit and zwcv.org_id in (hou.organization_id,-99) and zwcv.enabled_flag='Y' and sysdate between zwcv.start_date_active and nvl(zwcv.end_date_active,sysdate) order by zwcv.lookup_code Tax classification of the line. Defaults from the expense item. 44 LINE_WITHHOLDING_TAX_GROUP LOV custom varchar2 25 select aag.name value, aag.description from ap_awt_groups aag where nvl(aag.inactive_date,sysdate+1)>sysdate order by aag.name Defaults from the Withholding Tax Group of the expense report. 45 MERCHANT_NAME Char varchar2 80 46 MERCHANT_DOCUMENT_NUMBER Char varchar2 80 47 MERCHANT_TAX_REG_NUMBER Char varchar2 80 48 MERCHANT_TAXPAYER_ID Char varchar2 80 49 RECEIPT_DATE Date date Defaults to the report date. 50 COUNTRY_OF_SUPPLY LOV varchar2 80 Country 8E2FF36EDE8379D2E0530100007F1FF2 select ftv.territory_code id, ftv.territory_short_name value, ftv.territory_code||': '||ftv.description description from fnd_territories_vl ftv order by ftv.territory_short_name 51 REFERENCE Char varchar2 240 52 RECEIPT_CURRENCY LOV varchar2 15 FND Currency 8E2FF36EDE9079D2E0530100007F1FF2 select fcv.currency_code id, fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' order by fcv.currency_code Defaults to the currency of the expense report. 53 RECEIPT_EXCHANGE_RATE Number number Rate from the receipt currency to the currency of the expense report. Required when the currencies differ. 54 RECEIPT_AMOUNT Number number Line amount in the receipt currency, derived from the amount and the receipt exchange rate. Y 55 JUSTIFICATION Char varchar2 240 56 RECEIPT_VERIFIED LOV varchar2 80 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 57 RECEIPT_REQUIRED LOV varchar2 80 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 58 RECEIPT_MISSING LOV varchar2 80 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 59 PROJECT LOV varchar2 25 PO Project DEC9ED99A17F5BE8E0530100007FC601 select ppev.project_id id, ppev.project_number value, ppev.project_name description from pa_projects_expend_v ppev Project, Task, Expenditure Type and Expenditure Organization are entered together for a project related line. 60 TASK LOV custom varchar2 25 select ptev.task_number value, ptev.task_name description from pa_projects_expend_v ppev, pa_tasks_expend_v ptev where ppev.project_number=:$column$.project and ppev.project_id=ptev.project_id order by ptev.wbs_sort_order 61 EXPENDITURE_TYPE LOV custom varchar2 30 select petev.expenditure_type value, petev.description from pa_expenditure_types_expend_v petev where petev.system_linkage_function='ER' and sysdate between petev.expnd_typ_start_date_active and nvl(petev.expnd_typ_end_date_active,sysdate) and sysdate between petev.sys_link_start_date_active and nvl(petev.sys_link_end_date_active,sysdate) order by petev.expenditure_type 62 EXPENDITURE_ORGANIZATION LOV custom varchar2 240 select distinct poev.name value, null description from hr_operating_units hou, financials_system_params_all fspa, pa_organizations_expend_v poev where hou.name=:$column$.operating_unit and hou.organization_id=fspa.org_id and fspa.business_group_id=poev.business_group_id and poev.active_flag='Y' and sysdate between poev.date_from and nvl(poev.date_to,sysdate+1) order by poev.name 63 EXPENDITURE_ITEM_DATE Date date Defaults to the receipt date for a project related line. 64 LINE_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 fdfv.descriptive_flexfield_name='AP_EXPENSE_REPORT_LINES' and fdfv.application_id=200 and fdfv.application_id=fdfcv.application_id and fdfv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 65 LINE_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_LINES' and dffcu.application_column_name='ATTRIBUTE1' 66 LINE_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_LINES' and dffcu.application_column_name='ATTRIBUTE2' 67 LINE_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_LINES' and dffcu.application_column_name='ATTRIBUTE3' 68 LINE_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_LINES' and dffcu.application_column_name='ATTRIBUTE4' 69 LINE_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_LINES' and dffcu.application_column_name='ATTRIBUTE5' 70 LINE_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_LINES' and dffcu.application_column_name='ATTRIBUTE6' 71 LINE_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_LINES' and dffcu.application_column_name='ATTRIBUTE7' 72 LINE_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_LINES' and dffcu.application_column_name='ATTRIBUTE8' 73 LINE_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_LINES' and dffcu.application_column_name='ATTRIBUTE9' 74 LINE_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_LINES' and dffcu.application_column_name='ATTRIBUTE10' 75 LINE_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_LINES' and dffcu.application_column_name='ATTRIBUTE11' 76 LINE_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_LINES' and dffcu.application_column_name='ATTRIBUTE12' 77 LINE_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_LINES' and dffcu.application_column_name='ATTRIBUTE13' 78 LINE_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_LINES' and dffcu.application_column_name='ATTRIBUTE14' 79 LINE_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 => 200, p_descriptive_flexfield_name => 'AP_EXPENSE_REPORT_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_EXPENSE_REPORT_LINES' and dffcu.application_column_name='ATTRIBUTE15' 80 DELETE_LINE LOV custom varchar2 80 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$column$.report_header_id is not null and :$column$.line_number is not null Deletes the line from the expense report. 81 SUBMIT_EXPORT Char varchar2 1 :$flex$.submit_expense_report_export Y 82 REPORT_HEADER_ID Number number Y 83 REPORT_LINE_ID Number number Y 84 UPLOAD_ROW Char varchar2 Y Error SQL Order By upload_row, operating_unit, employee_name, invoice_num, line_number Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, nvl(haouv.name,xu.operating_unit) operating_unit, nvl(ppx.full_name,xu.employee_name) employee_name, nvl(nvl(ppx.employee_number,ppx.npw_number),xu.employee_number) employee_number, nvl(aerha.week_end_date,xu.report_date) report_date, nvl(aerha.invoice_num,xu.invoice_num) invoice_num, nvl(aerha.default_currency_code,xu.currency) currency, nvl(aerha.total,xu.amount) amount, nvl(aerha.description,xu.description) description, nvl((select alc.displayed_field from ap_lookup_codes alc where alc.lookup_type='HOLD CODE' and aerha.hold_lookup_code=alc.lookup_code),xu.hold) hold, nvl(xxen_util.meaning(aerha.expense_check_address_flag,'HOME_OFFICE',3),xu.send_to) send_to, nvl(gcck_h.concatenated_segments,xu.gl_account) gl_account, nvl(aera.report_type,xu.template) template, nvl(gdct.user_conversion_type,xu.exchange_rate_type) exchange_rate_type, nvl(aerha.default_exchange_date,xu.exchange_date) exchange_date, nvl(aerha.default_exchange_rate,xu.exchange_rate) exchange_rate, nvl(aag_h.name,xu.withholding_tax_group) withholding_tax_group, nvl(xxen_util.yes(case when aerha.vouchno<>0 then 'Y' end),xu.exported) exported, nvl(aerha.reject_code,xu.export_rejection) export_rejection, nvl(xxen_util.display_flexfield_context(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category),xu.header_attribute_category) header_attribute_category, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE1',aerha.rowid,aerha.attribute1),xu.header_attribute1) header_attribute1, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE2',aerha.rowid,aerha.attribute2),xu.header_attribute2) header_attribute2, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE3',aerha.rowid,aerha.attribute3),xu.header_attribute3) header_attribute3, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE4',aerha.rowid,aerha.attribute4),xu.header_attribute4) header_attribute4, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE5',aerha.rowid,aerha.attribute5),xu.header_attribute5) header_attribute5, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE6',aerha.rowid,aerha.attribute6),xu.header_attribute6) header_attribute6, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE7',aerha.rowid,aerha.attribute7),xu.header_attribute7) header_attribute7, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE8',aerha.rowid,aerha.attribute8),xu.header_attribute8) header_attribute8, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE9',aerha.rowid,aerha.attribute9),xu.header_attribute9) header_attribute9, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE10',aerha.rowid,aerha.attribute10),xu.header_attribute10) header_attribute10, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE11',aerha.rowid,aerha.attribute11),xu.header_attribute11) header_attribute11, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE12',aerha.rowid,aerha.attribute12),xu.header_attribute12) header_attribute12, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE13',aerha.rowid,aerha.attribute13),xu.header_attribute13) header_attribute13, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE14',aerha.rowid,aerha.attribute14),xu.header_attribute14) header_attribute14, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_HEADERS',aerha.attribute_category,'ATTRIBUTE15',aerha.rowid,aerha.attribute15),xu.header_attribute15) header_attribute15, nvl(aerla.distribution_line_number,xu.line_number) line_number, nvl(aerla.item_description,xu.item) item, nvl(aerla.amount,xu.line_amount) line_amount, nvl(gcck_l.concatenated_segments,xu.line_gl_account) line_gl_account, nvl(aerla.vat_code,xu.tax_code) tax_code, nvl(aag_l.name,xu.line_withholding_tax_group) line_withholding_tax_group, nvl(aerla.merchant_name,xu.merchant_name) merchant_name, nvl(aerla.merchant_document_number,xu.merchant_document_number) merchant_document_number, nvl(aerla.merchant_tax_reg_number,xu.merchant_tax_reg_number) merchant_tax_reg_number, nvl(aerla.merchant_taxpayer_id,xu.merchant_taxpayer_id) merchant_taxpayer_id, nvl(aerla.start_expense_date,xu.receipt_date) receipt_date, nvl(ftv.territory_short_name,xu.country_of_supply) country_of_supply, nvl(aerla.merchant_reference,xu.reference) reference, nvl(aerla.receipt_currency_code,xu.receipt_currency) receipt_currency, nvl(aerla.receipt_conversion_rate,xu.receipt_exchange_rate) receipt_exchange_rate, nvl(aerla.receipt_currency_amount,xu.receipt_amount) receipt_amount, nvl(aerla.justification,xu.justification) justification, nvl(xxen_util.yes(aerla.receipt_verified_flag),xu.receipt_verified) receipt_verified, nvl(xxen_util.yes(aerla.receipt_required_flag),xu.receipt_required) receipt_required, nvl(xxen_util.yes(aerla.receipt_missing_flag),xu.receipt_missing) receipt_missing, nvl(ppa.segment1,xu.project) project, nvl(pt.task_number,xu.task) task, nvl(aerla.expenditure_type,xu.expenditure_type) expenditure_type, nvl(haouv_exp.name,xu.expenditure_organization) expenditure_organization, nvl(aerla.expenditure_item_date,xu.expenditure_item_date) expenditure_item_date, nvl(xxen_util.display_flexfield_context(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category),xu.line_attribute_category) line_attribute_category, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE1',aerla.rowid,aerla.attribute1),xu.line_attribute1) line_attribute1, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE2',aerla.rowid,aerla.attribute2),xu.line_attribute2) line_attribute2, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE3',aerla.rowid,aerla.attribute3),xu.line_attribute3) line_attribute3, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE4',aerla.rowid,aerla.attribute4),xu.line_attribute4) line_attribute4, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE5',aerla.rowid,aerla.attribute5),xu.line_attribute5) line_attribute5, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE6',aerla.rowid,aerla.attribute6),xu.line_attribute6) line_attribute6, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE7',aerla.rowid,aerla.attribute7),xu.line_attribute7) line_attribute7, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE8',aerla.rowid,aerla.attribute8),xu.line_attribute8) line_attribute8, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE9',aerla.rowid,aerla.attribute9),xu.line_attribute9) line_attribute9, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE10',aerla.rowid,aerla.attribute10),xu.line_attribute10) line_attribute10, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE11',aerla.rowid,aerla.attribute11),xu.line_attribute11) line_attribute11, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE12',aerla.rowid,aerla.attribute12),xu.line_attribute12) line_attribute12, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE13',aerla.rowid,aerla.attribute13),xu.line_attribute13) line_attribute13, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE14',aerla.rowid,aerla.attribute14),xu.line_attribute14) line_attribute14, nvl(xxen_util.display_flexfield_value(200,'AP_EXPENSE_REPORT_LINES',aerla.attribute_category,'ATTRIBUTE15',aerla.rowid,aerla.attribute15),xu.line_attribute15) line_attribute15, xu.delete_line, xu.submit_export, xu.report_header_id, xu.report_line_id, xu.upload_row from xxen_ap_expense_report_8009_u xu, ap_expense_report_headers_all aerha, hr_all_organization_units_vl haouv, per_people_x ppx, gl_code_combinations_kfv gcck_h, ap_expense_reports_all aera, gl_daily_conversion_types gdct, ap_awt_groups aag_h, ap_expense_report_lines_all aerla, gl_code_combinations_kfv gcck_l, ap_awt_groups aag_l, fnd_territories_vl ftv, pa_projects_all ppa, pa_tasks pt, hr_all_organization_units_vl haouv_exp where xu.status_code_=xxen_upload.status_success and xu.report_header_id=aerha.report_header_id(+) and xu.report_line_id=aerla.report_line_id(+) and aerha.org_id=haouv.organization_id(+) and aerha.employee_id=ppx.person_id(+) and aerha.employee_ccid=gcck_h.code_combination_id(+) and aerha.expense_report_id=aera.expense_report_id(+) and aerha.default_exchange_rate_type=gdct.conversion_type(+) and aerha.awt_group_id=aag_h.group_id(+) and aerha.report_header_id=aerla.report_header_id(+) and nvl(aerla.itemization_parent_id(+),0)<>-1 and aerla.code_combination_id=gcck_l.code_combination_id(+) and aerla.awt_group_id=aag_l.group_id(+) and aerla.country_of_supply=ftv.territory_code(+) and aerla.project_id=ppa.project_id(+) and aerla.task_id=pt.task_id(+) and aerla.expenditure_organization_id=haouv_exp.organization_id(+)