ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 92F78F98CED41827E053B86B635877C1 AP Expense Audit Reasons Y select alc.displayed_field value, alc.description from ap_lookup_codes alc where alc.lookup_type='OIE_AUDIT_REASONS' and nvl(alc.enabled_flag,'Y')='Y' and trunc(sysdate) between trunc(nvl(alc.start_date_active,sysdate)) and trunc(nvl(alc.inactive_date,sysdate)) US List of Values for AP Expense Report audit reasons 92F79351A787184BE053B86B63583915 AP Expense Audit Type Y select alc.displayed_field value, alc.description from ap_lookup_codes alc where alc.lookup_type='OIE_AUDIT_TYPES' and nvl(alc.enabled_flag,'Y')='Y' and sysdate between nvl(alc.start_date_active,sysdate) and nvl(alc.inactive_date,sysdate) US 9883748DFB043115E0530100007F3E71 AP Expense Type Y select distinct aerpa.prompt value, nvl(aera.description,aera.report_type) description from hr_all_organization_units_vl haouv, ap_expense_reports_all aera, ap_expense_report_params_all aerpa where (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') and haouv.organization_id=aerpa.org_id and aera.expense_report_id=aerpa.expense_report_id order by description, aerpa.prompt US 92F8670F942A16C7E053B86B63583722 AP Expenses Auditors Y select decode(aud.auditor_id,-1,fnd_message.get_string('SQLAP','OIE_AUD_FALLBACK_AUDITOR'),nvl(ap_web_audit_utils.get_employee_info(fu.employee_id,'full_name','VARCHAR2'),fu.user_name)) value, fu.user_name description from ap_aud_auditors aud, fnd_user fu where fu.user_id=aud.auditor_id US LOV for AP Expense Report Auditors 8E2FF36EDEB879D2E0530100007F1FF2 GL Ledger Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name AR دفاتر الأستاذ المقيدة بمجموعة الوصول ، المحددة بواسطة قيمة الملف الشخصي "مجموعة الوصول إلى بيانات GL" لمسؤولية تسجيل الدخول الحالية D Ledger, die durch das Zugriffsset eingeschränkt sind, definiert durch den Profilwert 'GL Data Access Set' der aktuellen Anmeldeverantwortung E Libros restringidos por el conjunto de acceso, definido por el valor del perfil "Conjunto de acceso a datos GL" de la responsabilidad de inicio de sesión actual F Grands livres limités par un ensemble d'accès, défini par la valeur du profil "GL Data Access Set" de la responsabilité de connexion actuelle I Libri mastri limitati dal set di accesso, definito dal valore del profilo 'GL Data Access Set' della responsabilità di login corrente JA 現在のログイン責任者のプロファイル値'GL Data Access Set'によって定義されたアクセスセットによって制限された元帳 KO 현재 로그인 권한의 프로파일 값 'GL 데이터 액세스 세트'로 정의 된 액세스 세트로 제한되는 원장 PTB Ledgers restritos pelo conjunto de acesso, definido pelo valor do perfil 'GL Data Access Set' da atual responsabilidade de login RU Леджеры, ограниченные набором доступа, определяемые значением профиля "GL Data Access Set" текущей ответственности за вход в систему S Ledgers begränsade av åtkomstuppsättning, definierade av profilvärde 'GL Data Access Set' för det aktuella inloggningsansvaret TR Mevcut oturum açma sorumluluğunun profil değeri 'GL Veri Erişim Kümesi' ile tanımlanan erişim kümesiyle kısıtlanmış defterler US Ledgers restricted by access set, defined by profile value 'GL Data Access Set' of the current login responsibility ZHS 由访问集限制的分类账，由当前登录责任的配置文件值 "GL数据访问集 "定义。 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 8E2FF36EDEEE79D2E0530100007F1FF2 PER Person Full Name Y select ppx.full_name value, xxen_util.meaning(ppx.sex,'SEX',3)||' '||pptv.user_person_type description from per_people_x ppx, per_person_types_v pptv where ppx.person_type_id=pptv.person_type_id order by ppx.full_name US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 92F8670D3B381681E053B86B6358DE15 select gl.name ledger, hou.name operating_unit, ppx.full_name employee_name, xxen_util.meaning(aerha.source,'SOURCE',200) source, decode(ppx.current_npw_flag, 'Y', ppx.npw_number, ppx.employee_number) employee_number, aerha.invoice_num expense_report_number, aerha.description purpose, case when aerha.source in ('Both Pay','CREDIT CARD') then aps.vendor_name end card_provider, trunc(aerha.week_end_date) expense_report_date, aerha.total expense_amount, aerha.default_currency_code currency, gcck.concatenated_segments gl_account, nvl(aerha.report_submitted_date,aerha.creation_date) report_submitted_date, initcap(aerha.receipts_status) original_receipt_status, aerha.receipts_received_date, &image_receipt_columns xxen_util.meaning(case when aerha.audit_code in ('PAPERLESS_AUDIT','RECEIPT_BASED') and nvl(aerha.workflow_approved_flag,'M') in ('N','M') then 'Y' end,'YES_NO',0) requires_audit, xxen_util.meaning(nvl2(aaq.auditor_id,'Y',null),'YES_NO',0) auditor_assigned, ap_web_audit_utils.get_audit_reason(aerha.report_header_id) audit_reason, decode(aaq.auditor_id,-1,fnd_message.get_string('SQLAP','OIE_AUD_FALLBACK_AUDITOR'),xxen_util.user_name(aaq.auditor_id)) auditor, xxen_util.meaning(nvl(aerha.audit_code,'AUDIT'),'OIE_AUDIT_TYPES',200) audit_type, xxen_util.user_name(aerha.last_audited_by) last_audited_by, xxen_util.user_name(aerha.last_updated_by) last_updated_by, ap_web_expense_form.get_num_total_violations(aerha.report_header_id) num_total_violations, ap_web_expense_form.get_num_violation_lines(aerha.report_header_id) num_violation_lines, aerha.report_filing_number, xxen_util.meaning(nvl2(aia.cancelled_date,'CANCELLED',aerha.expense_status_code),'EXPENSE REPORT STATUS',200) expense_status, decode(aerha.workflow_approved_flag,'S','saved','I','implicit save','R','manager rejected','T','returned to preparer','M','manager approved','P','payables approved','A','automatically approved','W','withdrawn','Y','manager and payables approved','submitted') workflow_approved_status, xxen_util.meaning(case when aerha.workflow_approved_flag in ('Y','A','M') then 'Y' end,'YES_NO',0) mgmt_reviewed, xxen_util.meaning(case when aerha.audit_code='AUTO_APPROVE' or aerha.workflow_approved_flag='A' then 'Y' end,'YES_NO',0) auto_approved, (select ppx.full_name from per_people_x ppx where aerha.expense_current_approver_id=ppx.person_id) current_approver, xxen_util.meaning(nvl2(aerha.holding_report_header_id,'Y',null),'YES_NO',0) hold_flag, xxen_util.meaning(case when aerha.workflow_approved_flag in ('Y','A','P') or aerha.audit_code='AUTO_APPROVE' then 'Y' end,'YES_NO',0) ap_reviewed, xxen_util.meaning(nvl2(aia.invoice_num,'Y',null),'YES_NO',0) ap_invoice_created, xxen_util.meaning(aia.payment_status_flag,'INVOICE PAYMENT STATUS',200) payment_status, ( select max(aca.check_date) from ap_invoice_payments_all aipa, ap_checks_all aca where aia.invoice_id=aipa.invoice_id and aipa.check_id=aca.check_id and aca.void_date is null and aca.stopped_date is null ) payment_date, &dff_columns &lines_columns &per_diem_columns aerha.expense_report_id from gl_ledgers gl, hr_operating_units hou, ap_expense_report_headers_all aerha, per_people_x ppx, gl_code_combinations_kfv gcck, ap_aud_queues aaq, ap_suppliers aps, ap_invoices_all aia, (select aerla.* from ap_expense_report_lines_all aerla where '&show_lines'='Y') aerla, ap_expense_report_params_all aerpa, &per_diem_table (select aerda.* from ap_exp_report_dists_all aerda where '&show_lines'='Y') aerda, gl_code_combinations_kfv gcck2, gms_awards_all gaa &proj_tasks_tables where 1=1 and aerha.set_of_books_id=gl.ledger_id and hou.organization_id=aerha.org_id and aerha.employee_id=ppx.person_id(+) and aerha.employee_ccid=gcck.code_combination_id(+) and aerha.vendor_id=aps.vendor_id(+) and aerha.vouchno=aia.invoice_id(+) and aerha.report_header_id=aaq.expense_report_id(+) and aerha.report_header_id=aerla.report_header_id(+) and aerla.web_parameter_id=aerpa.parameter_id(+) and &per_diem_join aerla.report_line_id=aerda.report_line_id(+) and aerda.code_combination_id=gcck2.code_combination_id(+) and aerda.award_id=gaa.award_id(+) &proj_tasks_joins order by report_submitted_date desc, aerha.invoice_num &order_by Added internet expense attribute prompt Y (:Ledger is not null or :Operating_Unit is not null) AR AP Expenses تقرير مصاريف AP التفصيلي يسرد فواتير AP المقابلة مع الحالة وتفاصيل السطر ونوع المصاريف ومبررات المصاريف. بما في ذلك المصاريف المتعلقة بمهمة المشاريع. D AP Expenses Detaillierter AP-Ausgabenbericht, der die entsprechenden AP-Rechnungen mit Status, Zeilendetails, Ausgabentyp und Ausgabenbegründung auflistet. Einschließlich projektaufgabenbezogener Ausgaben. E AP Expenses Informe detallado de gastos AP que enumera las facturas AP correspondientes con el estado, los detalles de la línea, el tipo de gasto y la justificación del gasto. Incluye los gastos relacionados con las tareas de los proyectos. F AP Expenses Rapport détaillé des dépenses AP énumérant les factures AP correspondantes avec le statut, les détails de la ligne, le type de dépense et la justification des dépenses. Incluant les dépenses liées aux tâches des projets. I AP Expenses Rapporto spese AP dettagliato che elenca le fatture AP corrispondenti con stato, dettagli della linea, tipo di spesa e giustificazione della spesa. Comprese le spese relative alle attività dei progetti. JA AP Expenses 詳細なAP経費報告書には、対応するAP請求書のステータス、ラインの詳細、経費の種類、経費の正当性が記載されています。プロジェクト・タスク関連の経費も含まれています。 KO AP Expenses 상태, 라인 세부 정보, 비용 유형 및 비용 이유와 함께 해당 AP 송장을 나열하는 세부 AP 비용 보고서. 프로젝트 작업 관련 비용을 포함합니다. PTB AP Expenses Relatório detalhado de despesas de contas a pagar listando as faturas de contas a pagar correspondentes com status, detalhes da linha, tipo de despesa e justificativa da despesa. Incluindo despesas relacionadas a tarefas de projetos. RU AP Expenses Подробный отчет о расходах AP с перечнем соответствующих счетов AP со статусом, деталями строк, типом расходов и обоснованием расходов. Включая расходы, связанные с задачами проекта. S AP Expenses Detalj AP-utgiftsrapport som visar motsvarande AP-fakturor med status, raddetaljer, kostnadstyp och utgiftsberättigande. Inklusive projektuppgiftsrelaterade utgifter. TR AP Expenses Durum, satır ayrıntıları, gider türü ve harcama gerekçesiyle ilgili AP faturalarını listeleyen ayrıntı AP harcama raporu. Projelerin görevle ilgili giderleri dahil. US AP Expenses Detail AP expense report listing corresponding AP invoices with status, line details, expense type and expense justification. Including projects task related expenses. Please enter ledger or operating unit ZHS AP Expenses 详细的AP费用报告，列出相应的AP发票，包括状态、项目细节、费用类型和费用理由。包括项目任务相关费用。 Enginatics &dff_columns &image_receipt_columns &lines_columns &order_by &per_diem_columns &per_diem_join &per_diem_table &proj_tasks_joins &proj_tasks_tables &show_lines 1=1 1 -10 &image_receipt_columns aerha.image_receipts_status, aerha.image_receipts_received_date, Char 12 select decode(fnd_release.major_version,'11','11','12') from dual US EBS Release Version 2 10 1=1 gl.name=:ledger 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) LOV GL Ledger 8E2FF36EDEB879D2E0530100007F1FF2 Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name coalesce(xxen_util.previous_parameter_value(:parameter_id),xxen_util.default_ledger) US Ledger 3 20 1=1 hou.name=:operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select 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 coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit 4 30 1=1 aerha.expense_status_code=xxen_util.lookup_code(:expense_status_code,'EXPENSE REPORT STATUS',200) LOV custom Y select flv.meaning value, flv.description from fnd_lookup_values flv where flv.lookup_type='EXPENSE REPORT STATUS' and flv.view_application_id=200 and flv.language=userenv('lang') and flv.security_group_id=0 order by flv.meaning US Expense Status 5 40 1=1 nvl(aerha.report_submitted_date,aerha.creation_date)>=:exp_rep_sub_date Date US Report Submitted Date From 6 50 1=1 nvl(aerha.report_submitted_date,aerha.creation_date)<:exp_rep_sub_to+1 Date last_day(:$flex$.Report_Submitted_Date_From) US Report Submitted Date To 7 60 1=1 ppx.full_name=:full_name LOV PER Person Full Name 8E2FF36EDEEE79D2E0530100007F1FF2 Y select ppx.full_name value, xxen_util.meaning(ppx.sex,'SEX',3)||' '||pptv.user_person_type description from per_people_x ppx, per_person_types_v pptv where ppx.person_type_id=pptv.person_type_id order by ppx.full_name US Employee Name 8 70 1=1 aerha.invoice_num=:exp_report_num Char US Expense Report Number 9 80 1=1 decode(aaq.auditor_id,-1,fnd_message.get_string('SQLAP','OIE_AUD_FALLBACK_AUDITOR'),ap_web_policy_utils.get_employee_name(aaq.auditor_id))=:auditor_name LOV AP Expenses Auditors 92F8670F942A16C7E053B86B63583722 Y select decode(aud.auditor_id,-1,fnd_message.get_string('SQLAP','OIE_AUD_FALLBACK_AUDITOR'),nvl(ap_web_audit_utils.get_employee_info(fu.employee_id,'full_name','VARCHAR2'),fu.user_name)) value, fu.user_name description from ap_aud_auditors aud, fnd_user fu where fu.user_id=aud.auditor_id US Auditor Name 10 90 1=1 aerha.report_header_id in (select aaar.report_header_id from ap_aud_audit_reasons aaar where aaar.audit_reason_code=xxen_util.lookup_code(:audit_reason,'OIE_AUDIT_REASONS',200)) LOV AP Expense Audit Reasons 92F78F98CED41827E053B86B635877C1 Y select alc.displayed_field value, alc.description from ap_lookup_codes alc where alc.lookup_type='OIE_AUDIT_REASONS' and nvl(alc.enabled_flag,'Y')='Y' and trunc(sysdate) between trunc(nvl(alc.start_date_active,sysdate)) and trunc(nvl(alc.inactive_date,sysdate)) US Audit Reason 11 100 1=1 ap_web_policy_utils.get_lookup_meaning('OIE_AUDIT_TYPES',nvl(aerha.audit_code,'AUDIT'))=:audit_type LOV AP Expense Audit Type 92F79351A787184BE053B86B63583915 Y select alc.displayed_field value, alc.description from ap_lookup_codes alc where alc.lookup_type='OIE_AUDIT_TYPES' and nvl(alc.enabled_flag,'Y')='Y' and sysdate between nvl(alc.start_date_active,sysdate) and nvl(alc.inactive_date,sysdate) US Audit Type 12 110 1=1 aerha.source=xxen_util.lookup_code(:source,'SOURCE',200) LOV custom Y select flv.meaning value, flv.description from fnd_lookup_values flv where flv.lookup_type='SOURCE' and flv.view_application_id=200 and flv.language=userenv('lang') and flv.security_group_id=0 order by flv.meaning US Source 13 120 1=1 aerpa.prompt=:expense_type LOV AP Expense Type 9883748DFB043115E0530100007F3E71 Y select distinct aerpa.prompt value, nvl(aera.description,aera.report_type) description from hr_all_organization_units_vl haouv, ap_expense_reports_all aera, ap_expense_report_params_all aerpa where (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') and haouv.organization_id=aerpa.org_id and aera.expense_report_id=aerpa.expense_report_id order by description, aerpa.prompt US Prompt 14 &lines_columns aerla.report_header_id, aerla.report_line_id, aerla.distribution_line_number line_number, aerla.item_description, aerpa.web_friendly_prompt prompt, aerla.amount line_amount, aerla.currency_code line_currency, decode(aerla.itemization_parent_id,-1,to_number(null),ap_web_audit_utils.get_allowable_amount(aerla.report_header_id,aerla.distribution_line_number)) allowable_amount, nvl2(aerla.itemization_parent_id,aerla.receipt_currency_amount, decode(ap_web_audit_utils.is_personal_expense(aerla.web_parameter_id),'Y',(select decode(accta.category,'BUSINESS',accta.transaction_amount) from ap_credit_card_trxns_all accta where aerla.credit_card_trx_id=accta.trx_id)) ) line_receipt_amount, xxen_util.yes(aerla.receipt_verified_flag) receipt_verified_flag, xxen_util.yes(aerla.receipt_required_flag) receipt_required_flag, xxen_util.yes(aerla.receipt_missing_flag) receipt_missing_flag, aerla.justification, aerla.start_expense_date, aerla.end_expense_date, (aerla.end_expense_date - aerla.start_expense_date)+1 num_of_days, xxen_util.meaning(nvl2(aerla.credit_card_trx_id,'Y',null),'YES_NO',0) cc_trx, ap_web_audit_utils.get_expense_item_info(aerla.web_parameter_id,'category_code','VARCHAR2') category_code, xxen_util.yes(ap_web_audit_utils.is_personal_expense(aerla.web_parameter_id)) personal_expense, gcck2.concatenated_segments allocation_account, aerda.amount allocation_amount, aerda.receipt_currency_code receipt_currency, aerda.receipt_currency_amount receipt_amount, ppa.segment1 project_number, ppa.name project_name, pt.task_number, pt.task_name, gaa.award_number, gaa.award_short_name, US Prompt 15 &order_by ,aerla.distribution_line_number US Prompt 16 &proj_tasks_joins select decode(fnd_release.major_version,'11', 'and aerla.project_id=ppa.project_id(+) and aerla.task_id=pt.task_id(+)', 'and aerda.project_id=ppa.project_id(+) and aerda.task_id=pt.task_id(+)' ) from dual US Prompt 17 &proj_tasks_tables ,pa_projects_all ppa ,pa_tasks pt US Prompt 18 &show_lines Y US Prompt 19 130 &show_lines Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Show Lines 20 &lines_columns aerla.report_header_id, aerla.report_line_id, aerla.distribution_line_number line_number, aerla.item_description, aerpa.web_friendly_prompt prompt, aerla.amount line_amount, aerla.currency_code line_currency, decode(aerla.itemization_parent_id,-1,to_number(null),ap_web_audit_utils.get_allowable_amount(aerla.report_header_id,aerla.distribution_line_number)) allowable_amount, nvl2(aerla.itemization_parent_id,aerla.receipt_currency_amount, decode(ap_web_audit_utils.is_personal_expense(aerla.web_parameter_id),'Y',(select decode(accta.category,'BUSINESS',accta.transaction_amount) from ap_credit_card_trxns_all accta where aerla.credit_card_trx_id=accta.trx_id)) ) line_receipt_amount, xxen_util.yes(aerla.receipt_verified_flag) receipt_verified_flag, xxen_util.yes(aerla.receipt_required_flag) receipt_required_flag, xxen_util.yes(aerla.receipt_missing_flag) receipt_missing_flag, aerla.justification, aerla.start_expense_date, aerla.end_expense_date, (aerla.end_expense_date - aerla.start_expense_date)+1 num_of_days, xxen_util.meaning(nvl2(aerla.credit_card_trx_id,'Y',null),'YES_NO',0) cc_trx, ap_web_audit_utils.get_expense_item_info(aerla.web_parameter_id,'category_code','VARCHAR2') category_code, xxen_util.yes(ap_web_audit_utils.is_personal_expense(aerla.web_parameter_id)) personal_expense, gcck2.concatenated_segments allocation_account, aerda.amount allocation_amount, aerda.receipt_currency_code receipt_currency, aerda.receipt_currency_amount receipt_amount, ppa.segment1 project_number, ppa.name project_name, pt.task_number, pt.task_name, gaa.award_number, gaa.award_short_name, US Show Lines 21 &order_by ,aerla.distribution_line_number US Show Lines 22 &proj_tasks_joins select decode(fnd_release.major_version,'11', 'and aerla.project_id=ppa.project_id(+) and aerla.task_id=pt.task_id(+)', 'and aerda.project_id=ppa.project_id(+) and aerda.task_id=pt.task_id(+)' ) from dual US Show Lines 23 &proj_tasks_tables ,pa_projects_all ppa ,pa_tasks pt US Show Lines 24 1=1 :show_lines=:show_lines US Show Lines 25 140 &per_diem_columns trunc(opdb.start_date) pdm_date, opdb.amount pdm_amount, opdb.number_of_meals, opdb.meals_amount, xxen_util.yes(opdb.breakfast_flag) breakfast_flag, xxen_util.yes(opdb.lunch_flag) lunch_flag, xxen_util.yes(opdb.dinner_flag) dinner_flag, opdb.accommodation_amount, xxen_util.yes(opdb.accommodation_flag) accommodation_flag, opdb.hotel_name, opdb.night_rate_type, opdb.night_rate_amount, opdb.pdm_rate, opdb.cust_meals_amount, opdb.cust_accommodation_amount, opdb.cust_night_rate_amount, opdb.cust_pdm_rate, LOV custom Y select xxen_util.meaning('Y','YES_NO',0) value, null description from dual where decode(fnd_release.major_version,'11','11','12') = '12' US Show per diem details 26 &per_diem_join aerla.report_line_id=opdb.report_line_id(+) and US Show per diem details 27 &per_diem_table oie_pdm_daily_breakups opdb, US Show per diem details 28 &show_lines Y US Show per diem details 29 150 &dff_columns select xxen_util.dff_columns(p_table_name=>'ap_expense_report_headers_all')|| case when :show_lines='Y' then xxen_util.dff_columns(p_table_name=>'ap_expense_report_lines_all',p_column_name_prefix=>'Line: ') end from dual LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Show DFF Attributes :$flex$.Report_Submitted_Date_From Report Submitted Date From Y Report Submitted Date To :$flex$.ledger Ledger Operating Unit :$flex$.operating_unit Operating Unit Prompt