ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDF3079D2E0530100007F1FF2 AP Invoice Number Y Y select aia.invoice_num value, aps.vendor_name||' ('||aia.invoice_date||')' description from ap_invoices_all aia, ap_suppliers aps where (:$flex$.operating_unit is null or aia.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or aia.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and aia.vendor_id=aps.vendor_id order by aia.invoice_date desc US B20C1D394FC36EDDE0530100007F5621 AP Invoice Type Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type(+)='INVOICE TYPE' and flvv.view_application_id(+)=200 and flvv.security_group_id(+)=0 order by flvv.meaning US C23FDB3DBE0DC71FE0530100007FACC7 AP Period Y select gps.period_name value, xxen_util.meaning(gps.closing_status,'CLOSING_STATUS',222)||': '||gps.start_date||' - '||gps.end_date description from gl_period_statuses gps where gps.ledger_id= ( select asp.set_of_books_id from ap_system_parameters asp, gl_ledgers gl, hr_operating_units hou where asp.set_of_books_id=gl.ledger_id and asp.set_of_books_id=hou.set_of_books_id and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,hou.name)='Y') and rownum=1 ) and gps.start_date<=sysdate+400 and gps.application_id=200 order by gps.start_date desc US Past AP period, dependent on Ledger and/or Operating Unit B9847D20A0E4742FE0538931640A6379 AP Supplier Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id US 8E2FF36EDF0279D2E0530100007F1FF2 AP Supplier Site Y select distinct assa.vendor_site_code value, assa.address_line1||', '||assa.city||', '||nvl(ftv.territory_short_name,assa.country) description from hr_all_organization_units_vl haouv, ap_suppliers aps, ap_supplier_sites_all assa, fnd_territories_vl ftv where (:$flex$.ap_supplier is null or xxen_util.contains(:$flex$.ap_supplier,aps.vendor_name)='Y') and (:$flex$.ap_supplier_number is null or xxen_util.contains(:$flex$.ap_supplier_number,aps.segment1)='Y') and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') and haouv.organization_id=assa.org_id and aps.vendor_id=assa.vendor_id and assa.country=ftv.territory_code(+) order by assa.vendor_site_code US 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）限制的操作单元。 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 382972533FD5AC4EE0633D74000A9B93 select ap_inv.ledger, ap_inv.operating_unit, ap_inv.supplier, ap_inv.supplier_number, ap_inv.supplier_site, ap_inv.invoice_num, ap_inv.doc_sequence_value document_number, ap_inv.invoice_status, ap_inv.batch_name, ap_inv.invoice_creation_date, ap_inv.invoice_received_date, ap_inv.invoice_date, ap_inv.invoice_gl_date, ap_inv.due_date, ap_inv.days_due, ap_inv.invoice_type, ap_inv.invoice_source, ap_inv.invoice_description, ap_inv.has_attachment, ap_inv.invoice_currency_code, ap_inv.payment_currency_code, decode(ap_inv.first_invoice,'Y',ap_inv.invoice_amount) invoice_amount, decode(ap_inv.first_invoice,'Y',ap_invoices_utility_pkg.get_item_total(ap_inv.invoice_id, ap_inv.org_id)) items_total, decode(ap_inv.first_invoice,'Y',ap_invoices_utility_pkg.get_retained_total(ap_inv.invoice_id, ap_inv.org_id)) retainage_total, decode(ap_inv.first_invoice,'Y',ap_invoices_utility_pkg.get_prepaid_amount(ap_inv.invoice_id)) prepayments_applied_total, decode(ap_inv.first_invoice,'Y',ap_invoices_utility_pkg.get_amount_withheld(ap_inv.invoice_id)) witholding_total, decode(ap_inv.first_invoice,'Y', nvl(ap_invoices_utility_pkg.get_item_total(ap_inv.invoice_id, ap_inv.org_id),0) + nvl(ap_invoices_utility_pkg.get_retained_total(ap_inv.invoice_id, ap_inv.org_id),0) - nvl(abs(ap_invoices_utility_pkg.get_prepaid_amount(ap_inv.invoice_id)),0) - nvl(ap_invoices_utility_pkg.get_amount_withheld(ap_inv.invoice_id),0) ) invoice_subtotal, decode(ap_inv.first_invoice,'Y',ap_inv.total_tax_amount) tax_total, decode(ap_inv.first_invoice,'Y',ap_inv.self_assessed_tax_amount) self_assessed_tax_amount, decode(ap_inv.first_invoice,'Y',ap_invoices_utility_pkg.get_freight_total(ap_inv.invoice_id, ap_inv.org_id)) freight_total, decode(ap_inv.first_invoice,'Y',ap_invoices_utility_pkg.get_misc_total(ap_inv.invoice_id, ap_inv.org_id)) miscellaneous_total, decode(ap_inv.first_invoice,'Y', nvl(ap_invoices_utility_pkg.get_item_total(ap_inv.invoice_id, ap_inv.org_id),0) + nvl(ap_invoices_utility_pkg.get_retained_total(ap_inv.invoice_id, ap_inv.org_id),0) - nvl(abs(ap_invoices_utility_pkg.get_prepaid_amount(ap_inv.invoice_id)),0) - nvl(ap_invoices_utility_pkg.get_amount_withheld(ap_inv.invoice_id),0) + nvl(ap_inv.total_tax_amount,0) + nvl(ap_invoices_utility_pkg.get_freight_total(ap_inv.invoice_id, ap_inv.org_id),0) + nvl(ap_invoices_utility_pkg.get_misc_total(ap_inv.invoice_id, ap_inv.org_id),0) ) invoice_total, decode(ap_inv.first_invoice,'Y',ap_inv.amount_applicable_to_discount) amount_applicable_to_discount, decode(ap_inv.first_invoice,'Y',ap_inv.discount_amount_taken) discount_amount_taken, decode(ap_inv.first_invoice,'Y',ap_inv.approved_amount) approved_amount, decode(ap_inv.first_invoice,'Y',ap_inv.pay_curr_invoice_amount) payment_curr_invoice_amount, decode(ap_inv.first_invoice,'Y',ap_inv.amount_paid) amount_paid, ap_inv.base_currency, decode(ap_inv.first_invoice,'Y',ap_inv.invoice_amount_base) invoice_amount_base, decode(ap_inv.first_invoice,'Y',ap_inv.tax_amount_base) tax_amount_base, decode(ap_inv.first_invoice,'Y',ap_inv.amt_applicable_to_disc_base) amt_applicable_to_disc_base, decode(ap_inv.first_invoice,'Y',ap_inv.discount_amount_taken_base) discount_amount_taken_base, decode(ap_inv.first_invoice,'Y',ap_inv.approved_amount_base) approved_amount_base, decode(ap_inv.first_invoice,'Y',ap_inv.amount_paid_base) amount_paid_base, ap_inv.payment_num, ap_inv.payment_date, decode(ap_inv.first_psched,'Y',ap_inv.gross_amount) payment_num_gross_amount, decode(ap_inv.first_psched,'Y',ap_inv.amount_remaining) payment_num_amount_remaining, ap_inv.unit_registration_number, ap_inv.supplier_registration_number, &gst_columns &aging_bucket_cols2 ap_inv.payment_cross_rate, ap_inv.payment_cross_rate_date, ap_inv.discount_date, ap_inv.future_pay_due_date, ap_inv.payment_method, ap_inv.payment_priority, ap_inv.invoice_payment_status, ap_inv.schedule_payment_status, ap_inv.second_discount_date, ap_inv.third_discount_date, decode(ap_inv.first_psched,'Y',ap_inv.discount_amount_available) discount_amount_available, decode(ap_inv.first_psched,'Y',ap_inv.second_disc_amt_available) second_disc_amt_available, decode(ap_inv.first_psched,'Y',ap_inv.third_disc_amt_available) third_disc_amt_available, decode(ap_inv.first_psched,'Y',ap_inv.discount_amount_remaining) discount_amount_remaining, decode(ap_inv.first_psched,'Y',ap_inv.inv_curr_gross_amount) inv_curr_gross_amount, ap_inv.bank_name, ap_inv.iban, ap_inv.invoice_terms, ap_inv.terms_date, ap_inv.invoice_cancelled_date, ap_inv.invoice_cancelled_by, decode(ap_inv.first_invoice,'Y',ap_inv.invoice_cancelled_amount) invoice_cancelled_amount, decode(ap_inv.first_invoice,'Y',ap_inv.invoice_temp_cancelled_amount) invoice_temp_cancelled_amount, ap_inv.auto_tax_calculation_method, ap_inv.invoice_pay_group, ap_inv.invoice_exclusive_payment_flag, ap_inv.dispute_reason, ap_inv.supplier_site_payment_hold, ap_inv.scheduled_payment_hold, ap_inv.scheduled_payment_hold_reason, ap_holds.holds invoice_holds, ap_holds.hold_dates invoice_hold_dates, ap_holds.holds_held_by invoice_holds_held_by, ap_holds.hold_po_references invoice_hold_purchase_orders, ap_holds.hold_receipt_references invoice_hold_receipts, &invoice_detail_columns &dff_columns2 ap_inv.accts_pay_account, ap_inv.accts_pay_account_descripton, ap_inv.recurring_pmt_number, ap_inv.recurring_pmt_period_type, ap_inv.recurring_number_of_periods, ap_inv.recurring_pmt_description, ap_inv.supplier_taxpayer_id, ap_inv.supplier_tax_registration, ap_inv.supplier_inactive_on, ap_inv.customer_num, ap_inv.one_time_supplier, ap_inv.supplier_credit_status, ap_inv.credit_limit, ap_inv.supplier_withholding_status, ap_inv.withholding_start_date, ap_inv.supplier_vat_code, ap_inv.supplier_site_alt, ap_inv.purchasing_site, ap_inv.rfq_site, ap_inv.pay_site, ap_inv.tax_reporting_site, ap_inv.p_card_site, ap_inv.attention_ar, ap_inv.address_line1, ap_inv.address_line2, ap_inv.address_line3, ap_inv.address_line4, ap_inv.city, ap_inv.state, ap_inv.zip, ap_inv.county, ap_inv.province, ap_inv.country, ap_inv.area_code, ap_inv.phone, ap_inv.fax_area_code, ap_inv.fax, ap_inv.supplier_notif_method, ap_inv.email_address, ap_inv.remittance_email, &gcc_dist_segment_columns &attachment_columns ap_inv.created_by, ap_inv.creation_date, ap_inv.last_updated_by, ap_inv.last_update_date, ap_inv.line_created_by, ap_inv.line_creation_date, ap_inv.line_last_updated_by, ap_inv.line_last_update_date, ap_inv.dist_created_by, ap_inv.dist_creation_date, ap_inv.dist_last_updated_by, ap_inv.dist_last_update_date, ap_inv.invoice_id from ( select gl.name ledger, haouv.name operating_unit, nvl(aps.vendor_name,hp.party_name) supplier, nvl(aps.segment1,hp.party_number) supplier_number, nvl(assa.vendor_site_code,hps.party_site_number) supplier_site, aia.invoice_num, xxen_util.ap_invoice_status(aia.invoice_id,aia.invoice_amount,aia.payment_status_flag,aia.invoice_type_lookup_code,aia.validation_request_id) invoice_status, aba.batch_name, xxen_util.client_time(aia.creation_date) invoice_creation_date, xxen_util.client_time(aia.invoice_received_date) invoice_received_date, aia.invoice_date, aia.gl_date invoice_gl_date, apsa.due_date, ceil(sysdate-apsa.due_date) days_due, xxen_util.meaning(aia.invoice_type_lookup_code,'INVOICE TYPE',200) invoice_type, aia.source invoice_source, aia.description invoice_description, (select xxen_util.meaning('Y','YES_NO',0) from fnd_attached_documents fad where to_char(aia.invoice_id)=fad.pk1_value and fad.entity_name='AP_INVOICES' and rownum=1) has_attachment, aia.invoice_currency_code, aia.payment_currency_code, aia.invoice_amount, aia.total_tax_amount, aia.self_assessed_tax_amount, aia.amount_applicable_to_discount, aia.discount_amount_taken, aia.approved_amount, aia.pay_curr_invoice_amount, aia.amount_paid, gl.currency_code base_currency, decode(aia.invoice_currency_code,gl.currency_code,aia.invoice_amount,aia.base_amount) invoice_amount_base, aia.total_tax_amount*nvl(aia.exchange_rate,1) tax_amount_base, aia.amount_applicable_to_discount*nvl(aia.exchange_rate,1) amt_applicable_to_disc_base, aia.discount_amount_taken/aia.payment_cross_rate*nvl(aia.exchange_rate,1) discount_amount_taken_base, aia.approved_amount*nvl(aia.exchange_rate,1) approved_amount_base, aia.amount_paid/aia.payment_cross_rate*nvl(aia.exchange_rate,1) amount_paid_base, aia.dispute_reason, aia.doc_sequence_value, apsa.payment_priority, apsa.payment_num, ( select max(aca.check_date) from ap_invoice_payments_all aipa, ap_checks_all aca where apsa.invoice_id=aipa.invoice_id and apsa.payment_num=aipa.payment_num and aipa.check_id=aca.check_id and aca.void_date is null and aca.stopped_date is null ) payment_date, apsa.gross_amount, apsa.amount_remaining/aia.payment_cross_rate*nvl(aia.exchange_rate,1) amount_remaining, &aging_bucket_cols1 &gst_header &gst_lines &gst_distributions :p_trx_date_from trx_date_from, :p_trx_date_to trx_date_to, aia.payment_cross_rate, aia.payment_cross_rate_date, apsa.discount_date, apsa.future_pay_due_date, case when assa.hold_all_payments_flag='Y' and aia.cancelled_date is null and aia.payment_status_flag<>'Y' then xxen_util.meaning('Y','YES_NO',0) end supplier_site_payment_hold, decode(apsa.hold_flag,'Y',xxen_util.meaning(apsa.hold_flag,'YES_NO',0)) scheduled_payment_hold, decode(apsa.hold_flag,'Y',apsa.iby_hold_reason) scheduled_payment_hold_reason, nvl(xxen_util.meaning(apsa.payment_method_code,'PAYMENT METHOD',200),apsa.payment_method_code) payment_method, xxen_util.meaning(aia.payment_status_flag,'INVOICE PAYMENT STATUS',200) invoice_payment_status, xxen_util.meaning(apsa.payment_status_flag,'INVOICE PAYMENT STATUS',200) schedule_payment_status, apsa.second_discount_date, apsa.third_discount_date, apsa.discount_amount_available, apsa.second_disc_amt_available, apsa.third_disc_amt_available, apsa.discount_amount_remaining, apsa.inv_curr_gross_amount, cbv.bank_name, ieba.masked_iban iban, at.name invoice_terms, aia.terms_date, aia.cancelled_date invoice_cancelled_date, aia.cancelled_amount invoice_cancelled_amount, xxen_util.user_name(aia.cancelled_by) invoice_cancelled_by, aia.temp_cancelled_amount invoice_temp_cancelled_amount, xxen_util.meaning(aia.auto_tax_calc_flag,'AP_TAX_CALCULATION_METHOD',200) auto_tax_calculation_method, aia.pay_group_lookup_code invoice_pay_group, xxen_util.meaning(aia.exclusive_payment_flag,'YES_NO',0) invoice_exclusive_payment_flag, xxen_util.concatenated_segments(aia.accts_pay_code_combination_id) accts_pay_account, xxen_util.segments_description(aia.accts_pay_code_combination_id) accts_pay_account_descripton, aila.line_number, xxen_util.meaning(aila.line_type_lookup_code,'INVOICE LINE TYPE',200) line_type, xxen_util.meaning(aila.line_source,'LINE SOURCE',200) line_source, decode(aila.discarded_flag,'Y','Y') line_discarded, replace(aila.description,'~','-') line_description, aila.amount line_amount, nvl(aila.base_amount,aila.amount) line_base_amount, aila.accounting_date line_accounting_date, decode(aila.deferred_acctg_flag,'Y',xxen_util.meaning(aila.deferred_acctg_flag,'YES_NO',0)) deferred_option, aila.def_acctg_start_date deferred_start_date, aila.def_acctg_end_date deferred_end_date, aila.tax_regime_code, aila.tax, aila.tax_jurisdiction_code, aila.tax_rate_code, aila.tax_rate, case when aila.line_type_lookup_code='ITEM' then (select distinct hl.location_code from hr_locations hl where hl.location_id=aila.ship_to_location_id) end warehouse_code, aida.distribution_line_number dist_line_number, xxen_util.meaning(aida.line_type_lookup_code,'INVOICE DISTRIBUTION TYPE',200) distribution_type, aida.period_name, aida.accounting_date dist_accounting_date, case when '&show_aida'='Y' then aida.quantity_invoiced else aila.quantity_invoiced end quantity_invoiced, case when '&show_aida'='Y' then aida.unit_price else aila.unit_price end unit_price, aida.amount dist_amount, nvl(aida.base_amount,aida.amount) dist_base_amount, aida.invoice_price_variance dist_invoice_price_variance, aida.base_invoice_price_variance dist_base_inv_price_variance, aida.dist_code_combination_id, xxen_util.concatenated_segments(aida.dist_code_combination_id) expense_account, xxen_util.concatenated_segments(aida.price_var_code_combination_id) price_variance_account, xxen_util.segments_description(aida.dist_code_combination_id) expense_account_descripton, xxen_util.segments_description(aida.price_var_code_combination_id) price_variance_account_desc, xxen_util.meaning(aida.dist_match_type,'MATCH_STATUS',200) dist_match_type, decode(aida.match_status_flag,'A','Validated','T','Tested','S','Stopped','Never Validated') dist_match_status, (select pha.segment1 from po_headers_all pha where nvl((select pda.po_header_id from po_distributions_all pda where nvl(aida.po_distribution_id,aila.po_distribution_id)=pda.po_distribution_id),aia.quick_po_header_id)=pha.po_header_id) po_number, nvl((select max(rt.transaction_date) from rcv_transactions rt where rt.transaction_id = nvl(aida.rcv_transaction_id,aila.rcv_transaction_id) and rt.transaction_type in ('RECEIVE','DELIVER')), (select max(rt.transaction_date) from rcv_transactions rt where rt.po_line_id = aila.po_line_id and rt.po_line_location_id = aila.po_line_location_id and rt.transaction_type in ('RECEIVE','DELIVER')) ) receipt_date, (select listagg(x.receipt_num,',') within group (order by x.receipt_num) receipt_num from (select distinct rsh.receipt_num from rcv_transactions rt, rcv_shipment_lines rsl, rcv_shipment_headers rsh where rt.transaction_id= nvl(aida.rcv_transaction_id,aila.rcv_transaction_id) and rsl.shipment_line_id=rt.shipment_line_id and rt.transaction_type in ('RECEIVE','DELIVER') and rsh.shipment_header_id=rt.shipment_header_id ) x )receipt_number, xxen_util.meaning(aida.assets_tracking_flag,'YES_NO',0) dist_asset_tracking_flag, aida.assets_addition_flag dist_assets_addition_flag, replace(aida.description,'~','-') dist_description, aida.expenditure_item_date pa_expenditure_item_date, aida.expenditure_type pa_expenditure_type, coalesce(haouv1.name,haouv3.name,haouv2.name) expenditure_organization, nvl(xxen_util.meaning(aida.pa_addition_flag,'PA_ADDITION_FLAG',275),aida.pa_addition_flag) pa_addition_flag, aida.project_accounting_context, ppa.segment1 project_number, ppa.name project_name, ppa.description project_description, ppa.project_type, ppa.project_status_code, ppa.start_date project_start_date, ppa.completion_date project_completion_date, pt.task_number, pt.task_name, pt.description task_description, pt.service_type_code, pt.start_date task_start_date, pt.completion_date task_completion_date, arpa.recurring_pay_num recurring_pmt_number, arpa.rec_pay_period_type recurring_pmt_period_type, arpa.num_of_periods recurring_number_of_periods, arpa.description recurring_pmt_description, aps.num_1099 supplier_taxpayer_id, aps.vat_registration_num supplier_tax_registration, aps.end_date_active supplier_inactive_on, aps.customer_num, xxen_util.meaning(aps.one_time_flag,'YES_NO',0) one_time_supplier, aps.credit_status_lookup_code supplier_credit_status, aps.credit_limit, aps.withholding_status_lookup_code supplier_withholding_status, aps.withholding_start_date, aps.vat_code supplier_vat_code, assa.vendor_site_code_alt supplier_site_alt, xxen_util.meaning(assa.purchasing_site_flag,'YES_NO',0) purchasing_site, xxen_util.meaning(assa.rfq_only_site_flag,'YES_NO',0) rfq_site, xxen_util.meaning(assa.pay_site_flag,'YES_NO',0) pay_site, xxen_util.meaning(assa.tax_reporting_site_flag,'YES_NO',0) tax_reporting_site, xxen_util.meaning(assa.pcard_site_flag,'YES_NO',0) p_card_site, xxen_util.meaning(assa.attention_ar_flag,'YES_NO',0) attention_ar, nvl(assa.address_line1,hl.address1) address_line1, nvl(assa.address_line2,hl.address2) address_line2, nvl(assa.address_line3,hl.address3) address_line3, nvl(assa.address_line4,hl.address4) address_line4, nvl(assa.city,hl.city) city, nvl(assa.state,hl.state) state, nvl(assa.zip,hl.postal_code) zip, nvl(assa.county,hl.county) county, nvl(assa.province,hl.province) province, nvl(assa.country,hl.country) country, assa.area_code, assa.phone, assa.fax_area_code, assa.fax, assa.supplier_notif_method, assa.email_address, assa.remittance_email, &dff_columns xxen_util.user_name(aia.created_by) created_by, xxen_util.client_time(aia.creation_date) creation_date, xxen_util.user_name(aia.last_updated_by) last_updated_by, xxen_util.client_time(aia.last_update_date) last_update_date, xxen_util.user_name(aila.created_by) line_created_by, xxen_util.client_time(aila.creation_date) line_creation_date, xxen_util.user_name(aila.last_updated_by) line_last_updated_by, xxen_util.client_time(aila.last_update_date) line_last_update_date, xxen_util.user_name(aida.created_by) dist_created_by, xxen_util.client_time(aida.creation_date) dist_creation_date, xxen_util.user_name(aida.last_updated_by) dist_last_updated_by, xxen_util.client_time(aida.last_update_date) dist_last_update_date, aia.invoice_id, aia.org_id, (select jprl.registration_number from jai_party_regs jpr, jai_party_reg_lines jprl, jai_tax_lines_v jtlv where jpr.party_reg_id=jprl.party_reg_id and jpr.party_type_code='IO' and jprl.registration_type_code='GST' and jtlv.trx_id=aia.invoice_id and jpr.party_id=jtlv.organization_id and jpr.party_site_id=jtlv.location_id and jprl.effective_to is null and rownum=1 ) unit_registration_number, (select jprl.registration_number from jai_party_regs jpr, jai_party_reg_lines jprl where jpr.party_reg_id=jprl.party_reg_id and jpr.party_type_code='THIRD_PARTY_SITE' and jprl.registration_type_code='GST' and jpr.party_id=aia.vendor_id and jpr.party_site_id=aia.vendor_site_id and jprl.effective_to is null and regime_id in (select jr.regime_id from jai_regimes jr where jr.regime_code like '%GST India') and rownum=1 ) supplier_registration_number, decode(row_number() over (partition by apsa.invoice_id order by nvl(apsa.payment_num,1),aila.line_number,aida.accounting_date,aida.distribution_line_number),1,'Y') first_invoice, decode(row_number() over (partition by apsa.invoice_id,apsa.payment_num order by aila.line_number,aida.accounting_date,aida.distribution_line_number),1,'Y') first_psched, decode(row_number() over (partition by apsa.invoice_id,aila.line_number order by aida.accounting_date,aida.distribution_line_number),1,'Y') first_line from gl_ledgers gl, hr_all_organization_units_vl haouv, hr_all_organization_units_vl haouv1, hr_all_organization_units_vl haouv2, hr_all_organization_units_vl haouv3, ap_invoices_all aia, ap_batches_all aba, ap_payment_schedules_all apsa, iby_ext_bank_accounts ieba, ce_banks_v cbv, ap_suppliers aps, ap_supplier_sites_all assa, hz_parties hp, hz_party_sites hps, hz_locations hl, (select aila.* from ap_invoice_lines_all aila where '&show_aila'='Y') aila, (select aida2.* from ap_invoice_distributions_all aida2, gl_code_combinations gcc where '&show_aida'='Y' and 2=2 and aida2.dist_code_combination_id=gcc.code_combination_id) aida, ap_recurring_payments_all arpa, ap_terms at, pa_projects_all ppa, pa_tasks pt where 1=1 and aia.set_of_books_id=gl.ledger_id and aia.org_id=haouv.organization_id(+) and aia.expenditure_organization_id=haouv1.organization_id(+) and aila.expenditure_organization_id=haouv2.organization_id(+) and aida.expenditure_organization_id=haouv3.organization_id(+) and aia.batch_id=aba.batch_id(+) and aia.invoice_id=apsa.invoice_id and apsa.external_bank_account_id=ieba.ext_bank_account_id(+) and ieba.bank_id=cbv.bank_party_id(+) and aia.vendor_id=aps.vendor_id(+) and aia.vendor_site_id=assa.vendor_site_id(+) and aia.party_id=hp.party_id(+) and aia.party_site_id=hps.party_site_id(+) and hps.location_id=hl.location_id(+) and decode(apsa.payment_num,1,apsa.invoice_id)=aila.invoice_id(+) and aila.invoice_id=aida.invoice_id(+)and aila.line_number=aida.invoice_line_number(+) and aida.project_id=ppa.project_id(+)and aida.task_id=pt.task_id(+)and aia.recurring_payment_id=arpa.recurring_payment_id(+) and aia.terms_id=at.term_id(+) and ( :p_has_dist_criteria is null or aia.invoice_id in --need this to apply dist level restrictions in case report is run at header or line level ( select aida2.invoice_id from ap_invoice_distributions_all aida2, gl_code_combinations gcc where 2=2 and nvl(aila.line_number,aida2.invoice_line_number)=aida2.invoice_line_number and nvl(aida.distribution_line_number,aida2.distribution_line_number)=aida2.distribution_line_number and aida2.dist_code_combination_id=gcc.code_combination_id ) ) ) ap_inv, ( select distinct x.invoice_id, listagg(x.hold_name,', ') within group (order by x.hold_name) over (partition by x.invoice_id) holds, case count(distinct fnd_date.date_to_displaydate(x.hold_date)) over (partition by x.invoice_id) when 1 then to_char(fnd_date.date_to_displaydate(x.hold_date)) else listagg(to_char(fnd_date.date_to_displaydate(x.hold_date)),', ') within group (order by x.hold_name) over (partition by x.invoice_id) end hold_dates, case count(distinct x.held_by_user_name) over (partition by x.invoice_id) when 1 then x.held_by_user_name else listagg(x.held_by_user_name,', ') within group (order by x.hold_name) over (partition by x.invoice_id) end holds_held_by, x.po_ref hold_po_references, x.receipt_ref hold_receipt_references from ( select distinct aha.invoice_id, alc.displayed_field hold_name, first_value(aha.hold_date) over (partition by aha.invoice_id,aha.hold_lookup_code order by aha.hold_date) hold_date, first_value(decode(aha.held_by,5,xxen_util.meaning('SYSTEM','NLS TRANSLATION',200),xxen_util.user_name(aha.held_by))) over (partition by aha.invoice_id,aha.hold_lookup_code order by aha.hold_date) held_by_user_name, po.po_ref, rcv.receipt_ref from ap_holds_all aha, ap_lookup_codes alc, (select distinct x.invoice_id, listagg(x.po_ref,',') within group (order by x.po_ref) over (partition by x.invoice_id) po_ref from (select distinct aha.invoice_id, nvl(pha.clm_document_number,pha.segment1)||'('||nvl(to_char(pra.release_num),' ')||')('||nvl(pla.line_num_display, to_char(pla.line_num))||')('||plla.shipment_num||')' po_ref from ap_holds_all aha, po_line_locations_all plla, po_lines_all pla, po_headers_all pha, po_releases_all pra where aha.release_lookup_code is null and plla.line_location_id=aha.line_location_id and pla.po_line_id=plla.po_line_id and pha.po_header_id=plla.po_header_id and pra.po_release_id (+)=plla.po_release_id ) x ) po, (select distinct x.invoice_id, listagg(x.receipt_ref,',') within group (order by x.receipt_ref) over (partition by x.invoice_id) receipt_ref from (select distinct aha.invoice_id, rsh.receipt_num||'('||rsl.line_num||')' receipt_ref from ap_holds_all aha, rcv_transactions rt, rcv_shipment_lines rsl, rcv_shipment_headers rsh where aha.release_lookup_code is null and rt.transaction_id=aha.rcv_transaction_id and rsl.shipment_line_id=rt.shipment_line_id and rsh.shipment_header_id=rt.shipment_header_id ) x ) rcv where aha.release_lookup_code is null and aha.hold_lookup_code=alc.lookup_code and alc.lookup_type='HOLD CODE' and aha.invoice_id=po.invoice_id(+) and aha.invoice_id=rcv.invoice_id(+) ) x ) ap_holds, (select fad.attached_document_id attachment_id, fad.entity_name, fad.pk1_value entity_id, fad.seq_num, fdd.user_name type, fdct.user_name category, fdt.title, fdt.description, case fd.datatype_id when 1 then (select fdst.short_text from fnd_documents_short_text fdst where fdst.media_id = fd.media_id) when 5 then fd.url when 6 then (select fl.file_name from fnd_lobs fl where fl.file_id = fd.media_id) else null end content, case when fd.datatype_id = 6 then fd.media_id else null end file_id from fnd_attached_documents fad, fnd_documents fd, fnd_documents_tl fdt, fnd_document_datatypes fdd, fnd_document_categories_tl fdct where fad.document_id = fd.document_id and fd.document_id = fdt.document_id and fdt.language = userenv('lang') and fd.datatype_id = fdd.datatype_id and fdd.language = userenv('lang') and fd.category_id = fdct.category_id and fdct.language = userenv('lang') and fd.datatype_id in (1,5,6) ) attchmt, gl_code_combinations_kfv gcck where ap_inv.invoice_id=ap_holds.invoice_id(+) and decode(:p_show_attachments,'Y','AP_INVOICES',null)=attchmt.entity_name(+) and decode(:p_show_attachments,'Y',to_char(ap_inv.invoice_id),null)=attchmt.entity_id(+) and ap_inv.dist_code_combination_id=gcck.code_combination_id(+) order by ap_inv.operating_unit, ap_inv.supplier, ap_inv.supplier_number, ap_inv.invoice_date, ap_inv.invoice_gl_date, ap_inv.invoice_num, ap_inv.payment_num, ap_inv.line_number, ap_inv.dist_accounting_date, ap_inv.dist_line_number, attchmt.seq_num Y SQLAP #,##0.000;[Red]-#,##0.000 55DEB4D48B1D727FE0530100007F0ADE (:Ledger is not null or :Operating_Unit is not null) Y US APL: AP Invoices and Lines Detail Invoice Aging report with line item details and amounts Parameter explanation: - Invoice on Hold (LOV: Yes/No) Default Value = Null (Hold Status not considered as per current behaviour) Yes - Only Invoices that currently have an unreleased hold will be retrieved No - Only Invoices that do not currently have an unreleased hold will be retrieved - Hold Name (LOV: AP Hold Names) Default Value Null If specified - only Invoices that currently have an unreleased hold of the specified name will be retrieved Hold column explanation: - Holds - a list of the current unreleased holds against the invoice - Hold Dates - the Hold Date - Holds Held By - the name of user who applied the holds - Hold PO References - Identifies the matching POs for PO Matching Holds in the format: PO Number(Release number)(Line Number)(Shipment Number) - Hold Receipt References - Identifies the matching Receipts for Receipt Matching Holds in the format: Receipt Number(Line Number) Please enter a Ledger or Operating Unit &aging_bucket_cols1 &aging_bucket_cols2 &attachment_columns &dff_columns &dff_columns2 &gcc_dist_segment_columns &gst_columns &gst_distributions &gst_header &gst_lines &invoice_detail_columns &show_aida &show_aila 1=1 2=2 :p_has_dist_criteria :p_show_attachments :p_trx_date_from :p_trx_date_to 1 -30 :p_trx_date_from Date select nvl(:$flex$.accounting_date_from,nvl(:$flex$.payment_date_from,nvl(:$flex$.invoice_date_from, nvl((select gps.start_date from gl_period_statuses gps,gl_ledgers gl where gps.period_name=:$flex$.invoice_date_period and gps.set_of_books_id=gl.ledger_id and gl.name=:$flex$.ledger and gps.application_id=200), nvl((select gps.start_date from gl_period_statuses gps,gl_ledgers gl where gps.period_name=:$flex$.accounting_period and gps.set_of_books_id=gl.ledger_id and gl.name=:$flex$.ledger and gps.application_id=200), (select gps.start_date from gl_period_statuses gps,gl_ledgers gl where gps.period_name=:$flex$.payment_period and gps.set_of_books_id=gl.ledger_id and gl.name=:$flex$.ledger and gps.application_id=200)) ) ) ) ) from dual US RCV Trx Date From 2 -20 :p_trx_date_to Date select nvl(:$flex$.accounting_date_to+1,nvl(:$flex$.payment_date_to+1,nvl(:$flex$.invoice_date_to+1, nvl((select gps.end_date+1 from gl_period_statuses gps,gl_ledgers gl where gps.period_name=:$flex$.invoice_date_period and gps.set_of_books_id=gl.ledger_id and gl.name=:$flex$.ledger and gps.application_id=200), nvl((select gps.end_date+1 from gl_period_statuses gps,gl_ledgers gl where gps.period_name=:$flex$.accounting_period and gps.set_of_books_id=gl.ledger_id and gl.name=:$flex$.ledger and gps.application_id=200), (select gps.end_date+1 from gl_period_statuses gps,gl_ledgers gl where gps.period_name=:$flex$.payment_period and gps.set_of_books_id=gl.ledger_id and gl.name=:$flex$.ledger and gps.application_id=200)) ) ) ) ) from dual US RCV Trx Date To 3 -10 :p_has_dist_criteria Char select 'Y' from dual where :$flex$.accounting_period is not null or :$flex$.accounting_date_from is not null or :$flex$.accounting_date_to is not null or :$flex$.expense_account_from is not null or :$flex$.expense_account_to is not null US Distribution Selection Criteria 4 10 1=1 gl.name=:ledger and haouv.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) F Grand livre US Ledger 5 &gcc_dist_segment_columns select distinct 'gcck.'||lower(fifsv.application_column_name)||' "'||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length)||'",'||chr(10)|| 'xxen_util.segment_description(gcck.'||lower(fifsv.application_column_name)||', '''||fifsv.application_column_name||''', gcck.chart_of_accounts_id'|| ( select ', gcck.'||lower(fifs.application_column_name) from fnd_id_flex_segments fifs where fifsv.application_id=fifs.application_id and fifsv.id_flex_code=fifs.id_flex_code and fifsv.id_flex_num=fifs.id_flex_num and fifsv.enabled_flag=fifs.enabled_flag and fifs.flex_value_set_id=(select ffvs.parent_flex_value_set_id from fnd_flex_value_sets ffvs where fifsv.flex_value_set_id=ffvs.flex_value_set_id) )||') "'||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length-5)||' desc",' text, min(fifsv.id_flex_num) over (partition by fifsv.application_column_name, fifsv.form_left_prompt) min_id_flex_num, min(fifsv.segment_num) over (partition by fifsv.application_column_name, fifsv.form_left_prompt) min_segment_num from (select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where gl.ledger_id in(select asp.set_of_books_id from ap_system_parameters asp) and (:ledger is null or xxen_util.contains(:ledger,gl.name)='Y') and rownum=1 ) and fifsv.enabled_flag='Y' order by min_id_flex_num, min_segment_num F Grand livre US Ledger 6 20 1=1 haouv.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 F Unité d'exploitation US Operating Unit 7 30 &aging_bucket_cols1 select 'case when ceil(sysdate-apsa.due_date) between ' || to_char(aap.days_start) || ' and ' || to_char(aap.days_to) || ' and apsa.amount_remaining != 0 then apsa.amount_remaining/aia.payment_cross_rate*nvl(aia.exchange_rate,1) end bucket' || to_char(aap.period_sequence_num) || ',' from (select aapl.period_sequence_num, aapl.days_start, aapl.days_to, substr(aapl.report_heading1 || nvl2(aapl.report_heading1,nvl2(aapl.report_heading2,' ',null),null) || aapl.report_heading2,1,xxen_report.max_column_length) title from ap_aging_periods aap, ap_aging_period_lines aapl where aap.aging_period_id = aapl.aging_period_id and aap.period_name = :p_aging_bucket_name order by aapl.period_sequence_num ) aap union select ' case when ceil(sysdate-apsa.due_date)<=0 and apsa.amount_remaining != 0 then apsa.amount_remaining/aia.payment_cross_rate*nvl(aia.exchange_rate,1) end current_bucket, case when ceil(sysdate-apsa.due_date) between 1 and 30 and apsa.amount_remaining != 0 then apsa.amount_remaining/aia.payment_cross_rate*nvl(aia.exchange_rate,1) end between_1_30, case when ceil(sysdate-apsa.due_date) between 31 and 60 and apsa.amount_remaining != 0 then apsa.amount_remaining/aia.payment_cross_rate*nvl(aia.exchange_rate,1) end between_31_60, case when ceil(sysdate-apsa.due_date) between 61 and 90 and apsa.amount_remaining != 0 then apsa.amount_remaining/aia.payment_cross_rate*nvl(aia.exchange_rate,1) end between_61_90, case when ceil(sysdate-apsa.due_date) between 91 and 120 and apsa.amount_remaining != 0 then apsa.amount_remaining/aia.payment_cross_rate*nvl(aia.exchange_rate,1) end between_91_120, case when ceil(sysdate-apsa.due_date) between 121 and 150 and apsa.amount_remaining != 0 then apsa.amount_remaining/aia.payment_cross_rate*nvl(aia.exchange_rate,1) end between_121_150, case when ceil(sysdate-apsa.due_date) between 151 and 180 and apsa.amount_remaining != 0 then apsa.amount_remaining/aia.payment_cross_rate*nvl(aia.exchange_rate,1) end between_151_180, case when ceil(sysdate-apsa.due_date) >=181 and apsa.amount_remaining != 0 then apsa.amount_remaining/aia.payment_cross_rate*nvl(aia.exchange_rate,1) end greater_than_180,' from dual where not exists (select null from ap_aging_periods aap where aap.period_name = :p_aging_bucket_name and nvl(aap.status,'A') = 'A') LOV custom Y select x.value, x.description from ( select aap.period_name value, aap.description description from ap_aging_periods aap where nvl(aap.status,'A') = 'A' union select '*Default*' value, null description from dual ) x order by x.value *Default* Y F Nom du seau de vieillissement US Aging Bucket Name 8 &aging_bucket_cols2 select 'case ap_inv.first_psched when ''Y'' then ap_inv.bucket' || to_char(aap.period_sequence_num) || ' end "' || aap.title || '",' from (select aapl.period_sequence_num, aapl.days_start, aapl.days_to, substr(aapl.report_heading1 || nvl2(aapl.report_heading1,nvl2(aapl.report_heading2,' ',null),null) || aapl.report_heading2,1,xxen_report.max_column_length) title from ap_aging_periods aap, ap_aging_period_lines aapl where aap.aging_period_id = aapl.aging_period_id and aap.period_name = :p_aging_bucket_name order by aapl.period_sequence_num ) aap union select 'case ap_inv.first_psched when ''Y'' then ap_inv.current_bucket end "Current", case ap_inv.first_psched when ''Y'' then ap_inv.between_1_30 end between_1_30, case ap_inv.first_psched when ''Y'' then ap_inv.between_31_60 end between_31_60, case ap_inv.first_psched when ''Y'' then ap_inv.between_61_90 end between_61_90, case ap_inv.first_psched when ''Y'' then ap_inv.between_91_120 end between_91_120, case ap_inv.first_psched when ''Y'' then ap_inv.between_121_150 end between_121_150, case ap_inv.first_psched when ''Y'' then ap_inv.between_151_180 end between_151_180, case ap_inv.first_psched when ''Y'' then ap_inv.greater_than_180 end greater_than_180,' from dual where not exists (select null from ap_aging_periods aap where aap.period_name = :p_aging_bucket_name and nvl(aap.status,'A') = 'A') F Nom du seau de vieillissement US Aging Bucket Name 9 40 1=1 :display_level=:display_level LOV custom Y select 'Headers' value, 'Show Invoice Headers and Payment Schedules only' description from dual union all select 'Lines' value, 'Show Invoice Headers and Lines only' description from dual union all select 'Lines and Distributions' value, 'Show Invoice Headers, Lines and Distributions' description from dual Lines and Distributions Headers Y US Display Level 10 &gst_columns decode(ap_inv.first_invoice,'Y',ap_inv.discount) discount, decode(ap_inv.first_invoice,'Y',ap_inv.cgst_tax_rate) cgst_tax_rate , decode(ap_inv.first_invoice,'Y',ap_inv.sgst_tax_rate) sgst_tax_rate, decode(ap_inv.first_invoice,'Y',ap_inv.igst_tax_rate) igst_tax_rate, decode(ap_inv.first_invoice,'Y',ap_inv.cgst_amount) cgst_amount, decode(ap_inv.first_invoice,'Y',ap_inv.sgst_amount) sgst_amount, decode(ap_inv.first_invoice,'Y',ap_inv.igst_amount) igst_amount, decode(ap_inv.first_invoice,'Y',ap_inv.igst_imports) igst_imports, decode(ap_inv.first_invoice,'Y',ap_inv.customs_amount) customs_amount, decode(ap_inv.first_invoice,'Y',ap_inv.anty_duty_amount) anty_duty_amount, decode(ap_inv.first_invoice,'Y',ap_inv.others_amount) others_amount, Headers US Display Level 11 &gst_columns ap_inv.discount , ap_inv.cgst_tax_rate, ap_inv.sgst_tax_rate, ap_inv.igst_tax_rate, ap_inv.cgst_amount, ap_inv.sgst_amount, ap_inv.igst_amount, ap_inv.igst_imports, ap_inv.customs_amount, ap_inv.anty_duty_amount, ap_inv.others_amount, Lines US Display Level 12 &gst_columns ap_inv.discount , ap_inv.cgst_tax_rate, ap_inv.sgst_tax_rate, ap_inv.igst_tax_rate, ap_inv.cgst_amount, ap_inv.sgst_amount, ap_inv.igst_amount, ap_inv.igst_imports, ap_inv.customs_amount, ap_inv.anty_duty_amount, ap_inv.others_amount, Lines and Distributions US Display Level 13 &gst_distributions (select sum(jtlv.rounded_tax_amt_fun_curr) from jai_tax_lines_v jtlv, rcv_transactions rt where rt.transaction_id=aida.rcv_transaction_id and jtlv.application_id=707 and jtlv.trx_id=rt.shipment_header_id and jtlv.trx_line_id=rt.shipment_line_id and jtlv.trx_loc_line_id=rt.transaction_id and jtlv.tax_type_code like '%DISCOUNT%') discount, (select max(jtlv.tax_rate_code) from jai_tax_lines_v jtlv where jtlv.trx_id=aila.invoice_id and jtlv.trx_line_id=aila.line_number and jtlv.application_id=200 and tax_type_code like 'CGST_%%') cgst_tax_rate, (select max(jtlv.tax_rate_code) from jai_tax_lines_v jtlv where jtlv.trx_id=aila.invoice_id and jtlv.trx_line_id=aila.line_number and jtlv.application_id=200 and tax_type_code like 'SGST_%') sgst_tax_rate, (select max(jtlv.tax_rate_code) from jai_tax_lines_v jtlv where jtlv.trx_id=aila.invoice_id and jtlv.trx_line_id=aila.line_number and jtlv.application_id=200 and tax_type_code like 'IGST_%') igst_tax_rate, case when nvl((select sum(jtlv.rounded_tax_amt_trx_curr) from jai_tax_lines_v jtlv where jtlv.trx_id=aila.invoice_id and jtlv.trx_line_id=aila.line_number and jtlv.application_id=200 and tax_type_code like 'CGST_%'),0)=0 then (select sum(jtlv.rounded_tax_amt_fun_curr) from (select distinct jtlv.tax_line_id,jtlv.rounded_tax_amt_fun_curr from jai_tax_lines_v jtlv, rcv_transactions rt, ap_invoice_distributions_all aida where rt.transaction_id=aida.rcv_transaction_id and jtlv.application_id=707 and rt.transaction_date >= nvl(:p_trx_date_from,rt.transaction_date) and rt.transaction_date < nvl(:p_trx_date_to,rt.transaction_date+1) and jtlv.trx_id=rt.shipment_header_id and jtlv.trx_line_id=rt.shipment_line_id and jtlv.trx_loc_line_id=rt.transaction_id and jtlv.trx_type='RECEIVE' and jtlv.entity_code = 'RCV_TRANSACTION' and jtlv.tax_type_code like 'CGST_%')jtlv) else (select sum(jtlv.rounded_tax_amt_trx_curr) from jai_tax_lines_v jtlv where jtlv.trx_id=aila.invoice_id and jtlv.trx_line_id=aila.line_number and jtlv.application_id=200 and tax_type_code like 'CGST_%') end cgst_amount, case when nvl((select sum(jtlv.rounded_tax_amt_trx_curr) from jai_tax_lines_v jtlv where jtlv.trx_id=aila.invoice_id and jtlv.trx_line_id=aila.line_number and jtlv.application_id=200 and tax_type_code like 'SGST_%'),0)=0 then (select sum(jtlv.rounded_tax_amt_fun_curr) from (select distinct jtlv.tax_line_id,jtlv.rounded_tax_amt_fun_curr from jai_tax_lines_v jtlv, rcv_transactions rt, ap_invoice_distributions_all aida where rt.transaction_id=aida.rcv_transaction_id and jtlv.application_id=707 and rt.transaction_date >= nvl(:p_trx_date_from,rt.transaction_date) and rt.transaction_date < nvl(:p_trx_date_to,rt.transaction_date+1) and jtlv.trx_id=rt.shipment_header_id and jtlv.trx_line_id=rt.shipment_line_id and jtlv.trx_loc_line_id=rt.transaction_id and jtlv.trx_type='RECEIVE' and jtlv.entity_code = 'RCV_TRANSACTION' and jtlv.tax_type_code like 'SGST_%')jtlv) else (select sum(jtlv.rounded_tax_amt_trx_curr) from jai_tax_lines_v jtlv where jtlv.trx_id=aila.invoice_id and jtlv.trx_line_id=aila.line_number and jtlv.application_id=200 and tax_type_code like 'SGST_%') end sgst_amount, case when nvl((select sum(jtlv.rounded_tax_amt_trx_curr) from jai_tax_lines_v jtlv where jtlv.trx_id=aila.invoice_id and jtlv.trx_line_id=aila.line_number and jtlv.application_id=200 and tax_type_code like 'IGST_%'),0)=0 then (select sum(jtlv.rounded_tax_amt_fun_curr) from (select distinct jtlv.tax_line_id,jtlv.rounded_tax_amt_fun_curr from jai_tax_lines_v jtlv, rcv_transactions rt, ap_invoice_distributions_all aida where rt.transaction_id=aida.rcv_transaction_id and jtlv.application_id=707 and rt.transaction_date >= nvl(:p_trx_date_from,rt.transaction_date) and rt.transaction_date < nvl(:p_trx_date_to,rt.transaction_date+1) and jtlv.trx_id=rt.shipment_header_id and jtlv.trx_line_id=rt.shipment_line_id and jtlv.trx_loc_line_id=rt.transaction_id and jtlv.trx_type='RECEIVE' and jtlv.entity_code = 'RCV_TRANSACTION' and jtlv.tax_type_code like 'IGST_%')jtlv) else (select sum(jtlv.rounded_tax_amt_trx_curr) from jai_tax_lines_v jtlv where jtlv.trx_id=aila.invoice_id and jtlv.trx_line_id=aila.line_number and jtlv.application_id=200 and tax_type_code like 'IGST_%') end igst_amount, case when aia.invoice_currency_code<>'INR' then (select sum(jtlv.rounded_tax_amt_fun_curr) from jai_tax_lines_v jtlv, rcv_transactions rt where rt.transaction_id=aida.rcv_transaction_id and jtlv.application_id=707 and rt.transaction_date >= nvl(:p_trx_date_from,rt.transaction_date) and rt.transaction_date < nvl(:p_trx_date_to,rt.transaction_date+1) and jtlv.trx_id=rt.shipment_header_id and jtlv.trx_line_id=rt.shipment_line_id and jtlv.trx_loc_line_id=rt.transaction_id and jtlv.trx_type='RECEIVE' and jtlv.tax_type_code like 'IGST%PUR%%') end igst_imports, (select sum(jtlv.rounded_tax_amt_fun_curr) from jai_tax_lines_v jtlv, rcv_transactions rt where rt.transaction_id=aida.rcv_transaction_id and jtlv.application_id=707 and jtlv.trx_id=rt.shipment_header_id and jtlv.trx_line_id=rt.shipment_line_id and jtlv.trx_loc_line_id=rt.transaction_id and jtlv.trx_type='RECEIVE' and jtlv.tax_type_code='CUSTOMS') customs_amount, (select sum(jtlv.rounded_tax_amt_fun_curr) from jai_tax_lines_v jtlv, rcv_transactions rt where rt.transaction_id=aida.rcv_transaction_id and jtlv.application_id=200 and jtlv.trx_id=rt.po_header_id and jtlv.trx_line_id=rt.po_line_id and jtlv.trx_loc_line_id=rt.po_line_location_id and jtlv.tax_type_id in (select jtt.tax_type_id from jai_tax_types jtt where jtt.tax_type_code='PUR_ANTI_DUMPING_DUTY')) anty_duty_amount, (select sum(jtlv.rounded_tax_amt_fun_curr) from jai_tax_lines_v jtlv, rcv_transactions rt where rt.transaction_id=aida.rcv_transaction_id and jtlv.application_id=707 and jtlv.trx_id=rt.shipment_header_id and jtlv.trx_line_id=rt.shipment_line_id and jtlv.trx_loc_line_id=rt.transaction_id and jtlv.trx_type='RECEIVE' and jtlv.tax_type_code not like '%DISCOUNT%' and jtlv.tax_type_code not like '%FREIGHT%' and jtlv.tax_type_code not like '%GST%' and jtlv.tax_type_code not like '%CUSTOM%') others_amount, Lines and Distributions US Display Level 14 &gst_header (select sum(jtlv.rounded_tax_amt_fun_curr) from (select distinct jtlv.tax_line_id,jtlv.rounded_tax_amt_fun_curr from jai_tax_lines_v jtlv, rcv_transactions rt, ap_invoice_distributions_all aida where aida.invoice_id=aia.invoice_id and rt.transaction_id=aida.rcv_transaction_id and jtlv.application_id=707 and jtlv.trx_id=rt.shipment_header_id and jtlv.trx_line_id=rt.shipment_line_id and jtlv.trx_loc_line_id=rt.transaction_id and jtlv.tax_type_code like '%DISCOUNT%')jtlv) discount, (select max(jtlv.tax_rate_code) from jai_tax_lines_v jtlv where jtlv.trx_id=aia.invoice_id and jtlv.application_id=200 and jtlv.tax_type_code like 'CGST_%%') cgst_tax_rate, (select max(jtlv.tax_rate_code) from jai_tax_lines_v jtlv where jtlv.trx_id=aia.invoice_id and jtlv.application_id=200 and jtlv.tax_type_code like 'SGST_%') sgst_tax_rate, (select max(jtlv.tax_rate_code) from jai_tax_lines_v jtlv where jtlv.trx_id=aia.invoice_id and jtlv.application_id=200 and jtlv.tax_type_code like 'IGST_%') igst_tax_rate, case when nvl((select sum(jtlv.rounded_tax_amt_trx_curr) from jai_tax_lines_v jtlv where jtlv.trx_id=aia.invoice_id and jtlv.application_id=200 and jtlv.tax_type_code like 'CGST_%'),0)=0 then (select sum(jtlv.rounded_tax_amt_fun_curr) from (select distinct jtlv.tax_line_id,jtlv.rounded_tax_amt_fun_curr from jai_tax_lines_v jtlv, rcv_transactions rt, ap_invoice_distributions_all aida where aia.invoice_id=aida.invoice_id and rt.transaction_id=aida.rcv_transaction_id and jtlv.application_id=707 and rt.transaction_date >= nvl(:p_trx_date_from,rt.transaction_date) and rt.transaction_date < nvl(:p_trx_date_to,rt.transaction_date+1) and jtlv.trx_id=rt.shipment_header_id and jtlv.trx_line_id=rt.shipment_line_id and jtlv.trx_loc_line_id=rt.transaction_id and jtlv.trx_type='RECEIVE' and jtlv.entity_code = 'RCV_TRANSACTION' and jtlv.tax_type_code like 'CGST_%')jtlv) else (select sum(jtlv.rounded_tax_amt_trx_curr) from jai_tax_lines_v jtlv where jtlv.trx_id=aia.invoice_id and jtlv.application_id=200 and jtlv.tax_type_code like 'CGST_%') end cgst_amount, case when nvl((select sum(jtlv.rounded_tax_amt_trx_curr) from jai_tax_lines_v jtlv where jtlv.trx_id=aia.invoice_id and jtlv.application_id=200 and jtlv.tax_type_code like 'SGST_%'),0)=0 then (select sum(jtlv.rounded_tax_amt_fun_curr) from (select distinct jtlv.tax_line_id,jtlv.rounded_tax_amt_fun_curr from jai_tax_lines_v jtlv, rcv_transactions rt, ap_invoice_distributions_all aida where aia.invoice_id=aida.invoice_id and rt.transaction_id=aida.rcv_transaction_id and jtlv.application_id=707 and rt.transaction_date >= nvl(:p_trx_date_from,rt.transaction_date) and rt.transaction_date < nvl(:p_trx_date_to,rt.transaction_date+1) and jtlv.trx_id=rt.shipment_header_id and jtlv.trx_line_id=rt.shipment_line_id and jtlv.trx_loc_line_id=rt.transaction_id and jtlv.trx_type='RECEIVE' and jtlv.entity_code = 'RCV_TRANSACTION' and jtlv.tax_type_code like 'SGST_%')jtlv) else (select sum(jtlv.rounded_tax_amt_trx_curr) from jai_tax_lines_v jtlv where jtlv.trx_id=aia.invoice_id and jtlv.application_id=200 and jtlv.tax_type_code like 'SGST_%') end sgst_amount, case when nvl((select sum(jtlv.rounded_tax_amt_trx_curr) from jai_tax_lines_v jtlv where jtlv.trx_id=aia.invoice_id and jtlv.application_id=200 and jtlv.tax_type_code like 'IGST_%'),0)=0 then (select sum(jtlv.rounded_tax_amt_fun_curr) from (select distinct jtlv.tax_line_id,jtlv.rounded_tax_amt_fun_curr from jai_tax_lines_v jtlv, rcv_transactions rt, ap_invoice_distributions_all aida where aia.invoice_id=aida.invoice_id and rt.transaction_id=aida.rcv_transaction_id and jtlv.application_id=707 and jtlv.trx_id=rt.shipment_header_id and jtlv.trx_line_id=rt.shipment_line_id and rt.transaction_date >= nvl(:p_trx_date_from,rt.transaction_date) and rt.transaction_date < nvl(:p_trx_date_to,rt.transaction_date+1) and jtlv.trx_loc_line_id=rt.transaction_id and jtlv.trx_type='RECEIVE' and jtlv.entity_code = 'RCV_TRANSACTION' and jtlv.tax_type_code like 'IGST_%')jtlv) else (select sum(jtlv.rounded_tax_amt_trx_curr) from jai_tax_lines_v jtlv where jtlv.trx_id=aia.invoice_id and jtlv.application_id=200 and jtlv.tax_type_code like 'IGST_%') end igst_amount, case when aia.invoice_currency_code<>'INR' then (select sum(jtlv.rounded_tax_amt_fun_curr) from (select distinct jtlv.tax_line_id,jtlv.rounded_tax_amt_fun_curr from jai_tax_lines_v jtlv, rcv_transactions rt, ap_invoice_distributions_all aida where aia.invoice_id=aida.invoice_id and rt.transaction_id=aida.rcv_transaction_id and jtlv.application_id=707 and jtlv.trx_id=rt.shipment_header_id and rt.transaction_date >= nvl(:p_trx_date_from,rt.transaction_date) and rt.transaction_date < nvl(:p_trx_date_to,rt.transaction_date+1) and jtlv.trx_line_id=rt.shipment_line_id and jtlv.trx_loc_line_id=rt.transaction_id and jtlv.trx_type='RECEIVE' and jtlv.tax_type_code like 'IGST%PUR%%')jtlv) end igst_imports, (select sum(jtlv.rounded_tax_amt_fun_curr) from (select distinct jtlv.tax_line_id,jtlv.rounded_tax_amt_fun_curr from jai_tax_lines_v jtlv, rcv_transactions rt, ap_invoice_distributions_all aida where aia.invoice_id=aida.invoice_id and rt.transaction_id=aida.rcv_transaction_id and jtlv.application_id=707 and jtlv.trx_id=rt.shipment_header_id and jtlv.trx_line_id=rt.shipment_line_id and jtlv.trx_loc_line_id=rt.transaction_id and jtlv.trx_type='RECEIVE' and jtlv.tax_type_code='CUSTOMS')jtlv) customs_amount, (select sum(jtlv.rounded_tax_amt_fun_curr) from (select distinct jtlv.tax_line_id,jtlv.rounded_tax_amt_fun_curr from jai_tax_lines_v jtlv, rcv_transactions rt, ap_invoice_distributions_all aida where aia.invoice_id=aida.invoice_id and rt.transaction_id=aida.rcv_transaction_id and jtlv.application_id=200 and jtlv.trx_id=rt.po_header_id and jtlv.trx_line_id=rt.po_line_id and jtlv.trx_loc_line_id=rt.po_line_location_id and jtlv.tax_type_id in (select jtt.tax_type_id from jai_tax_types jtt where jtt.tax_type_code='PUR_ANTI_DUMPING_DUTY'))jtlv) anty_duty_amount, (select sum(jtlv.rounded_tax_amt_fun_curr) from (select distinct jtlv.tax_line_id,jtlv.rounded_tax_amt_fun_curr from jai_tax_lines_v jtlv, rcv_transactions rt, ap_invoice_distributions_all aida where aia.invoice_id=aida.invoice_id and rt.transaction_id=aida.rcv_transaction_id and jtlv.application_id=707 and jtlv.trx_id=rt.shipment_header_id and jtlv.trx_line_id=rt.shipment_line_id and jtlv.trx_loc_line_id=rt.transaction_id and jtlv.trx_type='RECEIVE' and jtlv.tax_type_code not like '%DISCOUNT%' and jtlv.tax_type_code not like '%FREIGHT%' and jtlv.tax_type_code not like '%GST%' and jtlv.tax_type_code not like '%CUSTOM%')jtlv) others_amount, Headers US Display Level 15 &gst_lines (select sum(jtlv.rounded_tax_amt_fun_curr) from jai_tax_lines_v jtlv, rcv_transactions rt, ap_invoice_distributions_all aida where aida.invoice_id=aila.invoice_id and aida.invoice_line_number=aila.line_number and rt.transaction_id=aida.rcv_transaction_id and jtlv.application_id=707 and jtlv.trx_id=rt.shipment_header_id and jtlv.trx_line_id=rt.shipment_line_id and jtlv.trx_loc_line_id=rt.transaction_id and jtlv.tax_type_code like '%DISCOUNT%') discount, (select max(jtlv.tax_rate_code) from jai_tax_lines_v jtlv where jtlv.trx_id=aila.invoice_id and jtlv.trx_line_id=aila.line_number and jtlv.application_id=200 and tax_type_code like 'CGST_%%') cgst_tax_rate, (select max(jtlv.tax_rate_code) from jai_tax_lines_v jtlv where jtlv.trx_id=aila.invoice_id and jtlv.trx_line_id=aila.line_number and jtlv.application_id=200 and tax_type_code like 'SGST_%') sgst_tax_rate, (select max(jtlv.tax_rate_code) from jai_tax_lines_v jtlv where jtlv.trx_id=aila.invoice_id and jtlv.trx_line_id=aila.line_number and jtlv.application_id=200 and tax_type_code like 'IGST_%') igst_tax_rate, case when nvl((select sum(jtlv.rounded_tax_amt_trx_curr) from jai_tax_lines_v jtlv where jtlv.trx_id=aila.invoice_id and jtlv.trx_line_id=aila.line_number and jtlv.application_id=200 and tax_type_code like 'CGST_%'),0)=0 then (select sum(jtlv.rounded_tax_amt_fun_curr) from (select distinct jtlv.tax_line_id,jtlv.rounded_tax_amt_fun_curr from jai_tax_lines_v jtlv, rcv_transactions rt, ap_invoice_distributions_all aida where aida.invoice_id=aila.invoice_id and aida.invoice_line_number=aila.line_number and rt.transaction_id=aida.rcv_transaction_id and jtlv.application_id=707 and rt.transaction_date >= nvl(:p_trx_date_from,rt.transaction_date) and rt.transaction_date < nvl(:p_trx_date_to,rt.transaction_date+1) and jtlv.trx_id=rt.shipment_header_id and jtlv.trx_line_id=rt.shipment_line_id and jtlv.trx_loc_line_id=rt.transaction_id and jtlv.trx_type='RECEIVE' and jtlv.entity_code = 'RCV_TRANSACTION' and jtlv.tax_type_code like 'CGST_%')jtlv) else (select sum(jtlv.rounded_tax_amt_trx_curr) from jai_tax_lines_v jtlv where jtlv.trx_id=aila.invoice_id and jtlv.trx_line_id=aila.line_number and jtlv.application_id=200 and tax_type_code like 'CGST_%') end cgst_amount, case when nvl((select sum(jtlv.rounded_tax_amt_trx_curr) from jai_tax_lines_v jtlv where jtlv.trx_id=aila.invoice_id and jtlv.trx_line_id=aila.line_number and jtlv.application_id=200 and tax_type_code like 'SGST_%'),0)=0 then (select sum(jtlv.rounded_tax_amt_fun_curr) from (select distinct jtlv.tax_line_id,jtlv.rounded_tax_amt_fun_curr from jai_tax_lines_v jtlv, rcv_transactions rt, ap_invoice_distributions_all aida where aida.invoice_id=aila.invoice_id and aida.invoice_line_number=aila.line_number and rt.transaction_id=aida.rcv_transaction_id and jtlv.application_id=707 and rt.transaction_date >= nvl(:p_trx_date_from,rt.transaction_date) and rt.transaction_date < nvl(:p_trx_date_to,rt.transaction_date+1) and jtlv.trx_id=rt.shipment_header_id and jtlv.trx_line_id=rt.shipment_line_id and jtlv.trx_loc_line_id=rt.transaction_id and jtlv.trx_type='RECEIVE' and jtlv.entity_code = 'RCV_TRANSACTION' and jtlv.tax_type_code like 'SGST_%')jtlv) else (select sum(jtlv.rounded_tax_amt_trx_curr) from jai_tax_lines_v jtlv where jtlv.trx_id=aila.invoice_id and jtlv.trx_line_id=aila.line_number and jtlv.application_id=200 and tax_type_code like 'SGST_%') end sgst_amount, case when nvl((select sum(jtlv.rounded_tax_amt_trx_curr) from jai_tax_lines_v jtlv where jtlv.trx_id=aila.invoice_id and jtlv.trx_line_id=aila.line_number and jtlv.application_id=200 and tax_type_code like 'IGST_%'),0)=0 then (select sum(jtlv.rounded_tax_amt_fun_curr) from (select distinct jtlv.tax_line_id,jtlv.rounded_tax_amt_fun_curr from jai_tax_lines_v jtlv, rcv_transactions rt, ap_invoice_distributions_all aida where aida.invoice_id=aila.invoice_id and aida.invoice_line_number=aila.line_number and rt.transaction_id=aida.rcv_transaction_id and jtlv.application_id=707 and rt.transaction_date >= nvl(:p_trx_date_from,rt.transaction_date) and rt.transaction_date < nvl(:p_trx_date_to,rt.transaction_date+1) and jtlv.trx_id=rt.shipment_header_id and jtlv.trx_line_id=rt.shipment_line_id and jtlv.trx_loc_line_id=rt.transaction_id and jtlv.trx_type='RECEIVE' and jtlv.entity_code = 'RCV_TRANSACTION' and jtlv.tax_type_code like 'IGST_%')jtlv) else (select sum(jtlv.rounded_tax_amt_trx_curr) from jai_tax_lines_v jtlv where jtlv.trx_id=aila.invoice_id and jtlv.trx_line_id=aila.line_number and jtlv.application_id=200 and tax_type_code like 'IGST_%') end igst_amount, case when aia.invoice_currency_code<>'INR' then (select sum(jtlv.rounded_tax_amt_fun_curr) from jai_tax_lines_v jtlv, rcv_transactions rt, ap_invoice_distributions_all aida where aida.invoice_id=aila.invoice_id and aida.invoice_line_number=aila.line_number and rt.transaction_id=aida.rcv_transaction_id and jtlv.application_id=707 and rt.transaction_date >= nvl(:p_trx_date_from,rt.transaction_date) and rt.transaction_date < nvl(:p_trx_date_to,rt.transaction_date+1) and jtlv.trx_id=rt.shipment_header_id and jtlv.trx_line_id=rt.shipment_line_id and jtlv.trx_loc_line_id=rt.transaction_id and jtlv.trx_type='RECEIVE' and jtlv.tax_type_code like 'IGST%PUR%%') end igst_imports, (select sum(jtlv.rounded_tax_amt_fun_curr) from jai_tax_lines_v jtlv, rcv_transactions rt, ap_invoice_distributions_all aida where aida.invoice_id=aila.invoice_id and aida.invoice_line_number=aila.line_number and rt.transaction_id=aida.rcv_transaction_id and jtlv.application_id=707 and jtlv.trx_id=rt.shipment_header_id and jtlv.trx_line_id=rt.shipment_line_id and jtlv.trx_loc_line_id=rt.transaction_id and jtlv.trx_type='RECEIVE' and jtlv.tax_type_code='CUSTOMS') customs_amount, (select sum(jtlv.rounded_tax_amt_fun_curr) from jai_tax_lines_v jtlv, rcv_transactions rt, ap_invoice_distributions_all aida where aida.invoice_id=aila.invoice_id and aida.invoice_line_number=aila.line_number and rt.transaction_id=aida.rcv_transaction_id and jtlv.application_id=200 and jtlv.trx_id=rt.po_header_id and jtlv.trx_line_id=rt.po_line_id and jtlv.trx_loc_line_id=rt.po_line_location_id and jtlv.tax_type_id in (select jtt.tax_type_id from jai_tax_types jtt where jtt.tax_type_code='PUR_ANTI_DUMPING_DUTY')) anty_duty_amount, (select sum(jtlv.rounded_tax_amt_fun_curr) from jai_tax_lines_v jtlv, rcv_transactions rt, ap_invoice_distributions_all aida where aida.invoice_id=aila.invoice_id and aida.invoice_line_number=aila.line_number and rt.transaction_id=aida.rcv_transaction_id and jtlv.application_id=707 and jtlv.trx_id=rt.shipment_header_id and jtlv.trx_line_id=rt.shipment_line_id and jtlv.trx_loc_line_id=rt.transaction_id and jtlv.trx_type='RECEIVE' and jtlv.tax_type_code not like '%DISCOUNT%' and jtlv.tax_type_code not like '%FREIGHT%' and jtlv.tax_type_code not like '%GST%' and jtlv.tax_type_code not like '%CUSTOM%') others_amount, Lines US Display Level 16 &invoice_detail_columns ap_inv.line_number, ap_inv.line_type, ap_inv.line_source, ap_inv.line_discarded, ap_inv.line_description, case ap_inv.first_line when 'Y' then ap_inv.line_amount end line_amount, case ap_inv.first_line when 'Y' then ap_inv.line_base_amount end line_base_amount, ap_inv.line_accounting_date, ap_inv.deferred_option, ap_inv.deferred_start_date, ap_inv.deferred_end_date, ap_inv.tax_regime_code, ap_inv.tax, ap_inv.tax_jurisdiction_code, ap_inv.tax_rate_code, ap_inv.tax_rate, ap_inv.po_number, ap_inv.receipt_date, ap_inv.receipt_number, case ap_inv.first_line when 'Y' then ap_inv.quantity_invoiced end quantity_invoiced, ap_inv.unit_price, ap_inv.warehouse_code, Lines F Niveau d'affichage US Display Level 17 &invoice_detail_columns ap_inv.line_number, ap_inv.line_type, ap_inv.line_source, ap_inv.line_discarded, ap_inv.line_description, case ap_inv.first_line when 'Y' then ap_inv.line_amount end line_amount, case ap_inv.first_line when 'Y' then ap_inv.line_base_amount end line_base_amount, ap_inv.line_accounting_date, ap_inv.deferred_option, ap_inv.deferred_start_date, ap_inv.deferred_end_date, ap_inv.tax_regime_code, ap_inv.tax, ap_inv.tax_jurisdiction_code, ap_inv.tax_rate_code, ap_inv.tax_rate, ap_inv.po_number, ap_inv.receipt_date, ap_inv.receipt_number, ap_inv.warehouse_code, ap_inv.dist_line_number, ap_inv.distribution_type, ap_inv.period_name, ap_inv.dist_accounting_date, ap_inv.dist_creation_date, ap_inv.dist_last_update_date, ap_inv.quantity_invoiced, ap_inv.unit_price, ap_inv.dist_amount, ap_inv.dist_base_amount, ap_inv.dist_invoice_price_variance, ap_inv.dist_base_inv_price_variance, ap_inv.expense_account, ap_inv.price_variance_account, ap_inv.expense_account_descripton, ap_inv.price_variance_account_desc, ap_inv.dist_match_type, ap_inv.dist_match_status, ap_inv.po_number, ap_inv.dist_asset_tracking_flag, ap_inv.dist_assets_addition_flag, ap_inv.dist_description, ap_inv.pa_expenditure_item_date, ap_inv.pa_expenditure_type, ap_inv.expenditure_organization, ap_inv.pa_addition_flag, ap_inv.project_accounting_context, ap_inv.project_number, ap_inv.project_name, ap_inv.project_description, ap_inv.project_type, ap_inv.project_status_code, ap_inv.project_start_date, ap_inv.project_completion_date, ap_inv.task_number, ap_inv.task_name, ap_inv.task_description, ap_inv.service_type_code, ap_inv.task_start_date, ap_inv.task_completion_date, Lines and Distributions F Niveau d'affichage US Display Level 18 &show_aida Y Lines and Distributions US Display Level 19 &show_aila Y Lines% F Niveau d'affichage US Display Level 20 50 1=1 aps.vendor_name=:supplier_name LOV AP Supplier B9847D20A0E4742FE0538931640A6379 Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id F Fournisseur US Supplier 21 60 1=1 assa.vendor_site_code=:vendor_site_code LOV AP Supplier Site 8E2FF36EDF0279D2E0530100007F1FF2 Y select distinct assa.vendor_site_code value, assa.address_line1||', '||assa.city||', '||nvl(ftv.territory_short_name,assa.country) description from hr_all_organization_units_vl haouv, ap_suppliers aps, ap_supplier_sites_all assa, fnd_territories_vl ftv where (:$flex$.ap_supplier is null or xxen_util.contains(:$flex$.ap_supplier,aps.vendor_name)='Y') and (:$flex$.ap_supplier_number is null or xxen_util.contains(:$flex$.ap_supplier_number,aps.segment1)='Y') and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') and haouv.organization_id=assa.org_id and aps.vendor_id=assa.vendor_id and assa.country=ftv.territory_code(+) order by assa.vendor_site_code F Site du fournisseur US Supplier Site 22 70 1=1 aia.invoice_num=:invoice_number LOV AP Invoice Number 8E2FF36EDF3079D2E0530100007F1FF2 Y Y select aia.invoice_num value, aps.vendor_name||' ('||aia.invoice_date||')' description from ap_invoices_all aia, ap_suppliers aps where (:$flex$.operating_unit is null or aia.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or aia.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and aia.vendor_id=aps.vendor_id order by aia.invoice_date desc F Numéro de facture US Invoice Number 23 80 1=1 aia.invoice_date>=(select gps.start_date from gl_period_statuses gps where gps.period_name=:invoice_period_name and gps.set_of_books_id=gl.ledger_id and gps.application_id=200) and aia.invoice_date<(select gps.end_date+1 from gl_period_statuses gps where gps.period_name=:invoice_period_name and gps.set_of_books_id=gl.ledger_id and gps.application_id=200) LOV AP Period C23FDB3DBE0DC71FE0530100007FACC7 Y select gps.period_name value, xxen_util.meaning(gps.closing_status,'CLOSING_STATUS',222)||': '||gps.start_date||' - '||gps.end_date description from gl_period_statuses gps where gps.ledger_id= ( select asp.set_of_books_id from ap_system_parameters asp, gl_ledgers gl, hr_operating_units hou where asp.set_of_books_id=gl.ledger_id and asp.set_of_books_id=hou.set_of_books_id and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,hou.name)='Y') and rownum=1 ) and gps.start_date<=sysdate+400 and gps.application_id=200 order by gps.start_date desc F Date de l'invitation Période US Invoice Date Period 24 90 1=1 aia.invoice_date>=:invoice_date_from Date select trunc(sysdate,'month') from dual where :$flex$.invoice_number is null and :$flex$.invoice_date_period is null and :$flex$.accounting_period is null and :$flex$.payment_period is null F Date de l'Inv. US Invoice Date From 25 100 1=1 aia.invoice_date<:invoice_date_to+1 Date last_day(:$flex$.invoice_date_from) F Date de l'inv. US Invoice Date To 26 110 2=2 select 'aida2.accounting_date(+)>=to_date('''||to_char(gps.start_date,'YYYY/MM/DD')||''',''YYYY/MM/DD'') and aida2.accounting_date (+) < to_date('''||to_char(gps.end_date+1,'YYYY/MM/DD')||''',''YYYY/MM/DD'')' from gl_period_statuses gps, gl_ledgers gl where gps.period_name=:accounting_period_name and gps.set_of_books_id=gl.ledger_id and gps.application_id=200 and (:ledger is null or xxen_util.contains(:ledger,gl.name)='Y') and rownum=1 LOV AP Period C23FDB3DBE0DC71FE0530100007FACC7 Y select gps.period_name value, xxen_util.meaning(gps.closing_status,'CLOSING_STATUS',222)||': '||gps.start_date||' - '||gps.end_date description from gl_period_statuses gps where gps.ledger_id= ( select asp.set_of_books_id from ap_system_parameters asp, gl_ledgers gl, hr_operating_units hou where asp.set_of_books_id=gl.ledger_id and asp.set_of_books_id=hou.set_of_books_id and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,hou.name)='Y') and rownum=1 ) and gps.start_date<=sysdate+400 and gps.application_id=200 order by gps.start_date desc F Période comptable US Accounting Period 27 120 2=2 aida2.accounting_date(+)>=:accounting_date_from Date F Date comptable du US Accounting Date From 28 130 2=2 aida2.accounting_date(+)<:accounting_date_to+1 Date last_day(:$flex$.Accounting_Date_From) F Date de comptabilisation au US Accounting Date To 29 140 1=1 aia.invoice_id in ( select aipa.invoice_id from gl_period_statuses gps, ap_checks_all aca, ap_invoice_payments_all aipa where gps.period_name=:payment_period_name and gl.ledger_id=gps.set_of_books_id and gps.application_id=200 and aca.check_date>=gps.start_date and aca.check_date<gps.end_date+1 and aca.void_date is null and aca.stopped_date is null and aca.check_id=aipa.check_id ) Char US Payment Period 30 150 1=1 (select max(aca.check_date) from ap_invoice_payments_all aipa, ap_checks_all aca where aipa.check_id = aca.check_id and aca.void_date is null and aca.stopped_date is null and aipa.invoice_id = apsa.invoice_id and aipa.payment_num = apsa.payment_num )>=:payment_date_from Date US Payment Date From 31 160 1=1 (select max(aca.check_date) from ap_invoice_payments_all aipa, ap_checks_all aca where aipa.check_id = aca.check_id and aca.void_date is null and aca.stopped_date is null and aipa.invoice_id = apsa.invoice_id and aipa.payment_num = apsa.payment_num )<:payment_date_to+1 Date last_day(:$flex$.payment_date_from) US Payment Date To 32 170 1=1 aia.payment_status_flag in ('N','P') and apsa.amount_remaining<>0 LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y select 'Y' from dual where :$flex$.invoice_number is null and :$flex$.invoice_date_period is null and :$flex$.invoice_date_from is null and :$flex$.invoice_date_to is null and :$flex$.accounting_period is null and :$flex$.accounting_date_from is null and :$flex$.accounting_date_to is null and :$flex$.payment_period is null and :$flex$.payment_date_from is null and :$flex$.payment_date_to is null and :$flex$.invoice_status is null and :$flex$.payment_status is null and :$flex$.creation_date_from is null and :$flex$.creation_date_to is null F Ouvert uniquement US Open only 33 180 1=1 ceil(sysdate-apsa.due_date)>:days_due Number F Jours de retard Jours d'échéance (supérieurs à) US Days Overdue Days Due (Greater than) 34 190 1=1 aia.invoice_type_lookup_code=xxen_util.lookup_code(:invoice_type,'INVOICE TYPE',200) LOV AP Invoice Type B20C1D394FC36EDDE0530100007F5621 Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type(+)='INVOICE TYPE' and flvv.view_application_id(+)=200 and flvv.security_group_id(+)=0 order by flvv.meaning F Type de facture US Invoice Type 35 200 1=1 xxen_util.ap_invoice_status(aia.invoice_id,aia.invoice_amount,aia.payment_status_flag,aia.invoice_type_lookup_code,aia.validation_request_id) = :p_invoice_status LOV custom Y select flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type in ('NLS TRANSLATION','PREPAY STATUS') and flvv.view_application_id = 200 and flvv.security_group_id = fnd_global.security_group_id and flvv.lookup_code in ('APPROVED', 'NEEDS REAPPROVAL', 'NEVER APPROVED', 'UNAPPROVED', 'UNPAID', 'FULL', 'PERMANENT', 'AVAILABLE', 'SELECTED FOR PAYMENT', 'SELECTED FOR VALIDATION', 'SELECTED FOR APPROVAL' ) order by flvv.meaning US Invoice Status 36 210 1=1 aia.payment_status_flag=xxen_util.lookup_code(:payment_status,'INVOICE PAYMENT STATUS',200) LOV custom Y select flv.meaning value, flv.description from fnd_lookup_values flv where flv.lookup_type(+)='INVOICE PAYMENT STATUS' and flv.view_application_id(+)=200 and flv.language(+)=userenv('lang') and flv.security_group_id(+)=0 order by flv.lookup_code F Statut du paiement US Payment Status 37 220 2=2 select x.segment_name||'>='''||x.seg_val||''''||decode(rownum,count,null,' and') from ( select count(*) over () count, 'gcc.'||fifs.application_column_name segment_name, substr(:p_expense_account_from,sum(fifs.display_size+1) over (order by fifs.segment_num rows between unbounded preceding and current row)-fifs.display_size,fifs.display_size) seg_val from fnd_id_flex_segments fifs where fifs.enabled_flag='Y' and fifs.application_id=101 and fifs.id_flex_code='GL#' and fifs.id_flex_num=(select gl.chart_of_accounts_id from gl_ledgers gl where gl.ledger_id in (select asp.set_of_books_id from ap_system_parameters asp) and (:ledger is null or xxen_util.contains(:ledger,gl.name)='Y') and rownum=1) order by fifs.segment_num ) x LOV custom Y Y select gcck.concatenated_segments value, xxen_util.segments_description(gcck.code_combination_id) description from gl_code_combinations_kfv gcck where gcck.chart_of_accounts_id= ( select gl.chart_of_accounts_id from gl_ledgers gl where gl.ledger_id in (select asp.set_of_books_id from ap_system_parameters asp) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and rownum=1 ) and gcck.detail_posting_allowed='Y' and gcck.enabled_flag='Y' and gcck.summary_flag='N' order by gcck.concatenated_segments F Compte de dépenses De US Expense Account From 38 230 2=2 select x.segment_name||'<='''||x.seg_val||''''||decode(rownum,count,null,' and') from ( select count(*) over () count, 'gcc.'||fifs.application_column_name segment_name, substr(:p_expense_account_to,sum(fifs.display_size+1) over (order by fifs.segment_num rows between unbounded preceding and current row)-fifs.display_size,fifs.display_size) seg_val from fnd_id_flex_segments fifs where fifs.enabled_flag='Y' and fifs.application_id=101 and fifs.id_flex_code='GL#' and fifs.id_flex_num=(select gl.chart_of_accounts_id from gl_ledgers gl where gl.ledger_id in (select asp.set_of_books_id from ap_system_parameters asp) and (:ledger is null or xxen_util.contains(:ledger,gl.name)='Y') and rownum=1) order by fifs.segment_num ) x LOV custom Y Y select gcck.concatenated_segments value, xxen_util.segments_description(gcck.code_combination_id) description from gl_code_combinations_kfv gcck where gcck.chart_of_accounts_id= ( select gl.chart_of_accounts_id from gl_ledgers gl where gl.ledger_id in (select asp.set_of_books_id from ap_system_parameters asp) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and rownum=1 ) and gcck.detail_posting_allowed='Y' and gcck.enabled_flag='Y' and gcck.summary_flag='N' order by gcck.concatenated_segments :$flex$.Expense_Account_From F Compte de dépenses à US Expense Account To 39 240 1=1 aia.cancelled_date is null LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y select 'Y' from dual where :$flex$.invoice_number is null F Exclure Annulé US Exclude Cancelled 40 250 1=1 ( apsa.hold_flag = 'Y' or (assa.hold_all_payments_flag = 'Y' and aia.payment_status_flag != 'Y' and aia.cancelled_date is null ) or exists (select null from ap_holds_all aha where aha.invoice_id = aia.invoice_id and aha.release_lookup_code is null ) ) LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y F Facture en attente US Invoice on Hold 41 1=1 not ( apsa.hold_flag = 'Y' or (assa.hold_all_payments_flag = 'Y' and aia.payment_status_flag != 'Y' and aia.cancelled_date is null ) or exists (select null from ap_holds_all aha where aha.invoice_id = aia.invoice_id and aha.release_lookup_code is null ) ) N F Facture en attente US Invoice on Hold 42 260 1=1 ( (:p_hold_code = 'Scheduled Payment Hold' and apsa.hold_flag = 'Y' ) or (:p_hold_code = 'Supplier Site Hold' and assa.hold_all_payments_flag = 'Y' and aia.payment_status_flag != 'Y' and aia.cancelled_date is null ) or exists (select null from ap_holds_all aha where aha.invoice_id = aia.invoice_id and aha.release_lookup_code is null and aha.hold_lookup_code = xxen_util.lookup_code(:p_hold_code,'HOLD CODE',200) ) ) LOV custom Y select x.value, x.description from ( select displayed_field value, null description from ap_lookup_codes where lookup_type='HOLD CODE' and lookup_code in(select hold_lookup_code from ap_hold_codes where (hold_type like '%REASON' or hold_type in ('INSUFFICIENT INFORMATION','PERIOD HOLD TYPE','PERIOD RELEASE TYPE')) and nvl(inactive_date,sysdate+1)>sysdate) and enabled_flag='Y' union select 'Scheduled Payment Hold' value, null description from dual union select 'Supplier Site Hold' value, null description from dual ) x order by x.value, x.description F Nom du détenteur US Hold Name 43 270 1=1 exists (select null from fnd_attached_documents fad where to_char(aia.invoice_id)=fad.pk1_value and aia.invoice_id=fad.pk1_value and fad.entity_name='AP_INVOICES') LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y F A l'attachement US Has Attachment 44 1=1 not exists (select null from fnd_attached_documents fad where to_char(aia.invoice_id)=fad.pk1_value and aia.invoice_id=fad.pk1_value and fad.entity_name='AP_INVOICES') N F A l'attachement US Has Attachment 45 280 1=1 aia.creation_date>=:creation_date_from Date US Creation Date From 46 290 1=1 aia.creation_date<:creation_date_to+1 Date US Creation Date To 47 300 &dff_columns select xxen_util.dff_columns(p_table_name=>'po_vendors',p_table_alias=>'aps',p_column_name_prefix=>'Supplier: ')|| xxen_util.dff_columns(p_table_name=>'po_vendor_sites_all',p_table_alias=>'assa',p_column_name_prefix=>'Site: ')|| xxen_util.dff_columns(p_table_name=>'ap_invoices_all',p_column_name_prefix=>'Invoice: ')|| case when :display_level like 'Lines%' then xxen_util.dff_columns(p_table_name=>'ap_invoice_lines_all',p_column_name_prefix=>'Invoice 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 48 &dff_columns2 select xxen_util.dff_columns(p_table_name=>'po_vendors',p_column_name_prefix=>'Supplier: ',p_prefix=>'ap_inv.')|| xxen_util.dff_columns(p_table_name=>'po_vendor_sites_all',p_table_alias=>'assa',p_column_name_prefix=>'Site: ',p_prefix=>'ap_inv.')|| xxen_util.dff_columns(p_table_name=>'ap_invoices_all',p_column_name_prefix=>'Invoice: ',p_prefix=>'ap_inv.')|| case when :display_level like 'Lines%' then xxen_util.dff_columns(p_table_name=>'ap_invoice_lines_all',p_column_name_prefix=>'Invoice Line: ',p_prefix=>'ap_inv.') end from dual where :show_dff=:show_dff US Show DFF Attributes 49 310 :p_show_attachments LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Attachments 50 &attachment_columns attchmt.seq_num attachment_seq, attchmt.type attachment_type, attchmt.category attachment_category, attchmt.title attachment_title, attchmt.description attachment_description, attchmt.content attachment_content, US Show Attachments :$flex$.Accounting_Date_From Accounting Date From Y Accounting Date To :$flex$.Expense_Account_From Expense Account From Expense Account To :$flex$.accounting_date_from Accounting Date From Y Distribution Selection Criteria :$flex$.accounting_date_from Accounting Date From Y Open only :$flex$.accounting_date_from Accounting Date From Y RCV Trx Date From :$flex$.accounting_date_to Accounting Date To Y Distribution Selection Criteria :$flex$.accounting_date_to Accounting Date To Y Open only :$flex$.accounting_date_to Accounting Date To Y RCV Trx Date To :$flex$.accounting_period Accounting Period Distribution Selection Criteria :$flex$.accounting_period Accounting Period Invoice Date From :$flex$.accounting_period Accounting Period Open only :$flex$.accounting_period Accounting Period RCV Trx Date From :$flex$.accounting_period Accounting Period RCV Trx Date To :$flex$.ap_supplier Supplier Supplier Site :$flex$.creation_date_from Creation Date From Y Open only :$flex$.creation_date_to Creation Date To Y Open only :$flex$.expense_account_from Expense Account From Distribution Selection Criteria :$flex$.expense_account_to Expense Account To Distribution Selection Criteria :$flex$.invoice_date_from Invoice Date From Y Invoice Date To :$flex$.invoice_date_from Invoice Date From Y Open only :$flex$.invoice_date_from Invoice Date From Y RCV Trx Date From :$flex$.invoice_date_period Invoice Date Period Invoice Date From :$flex$.invoice_date_period Invoice Date Period Open only :$flex$.invoice_date_period Invoice Date Period RCV Trx Date From :$flex$.invoice_date_period Invoice Date Period RCV Trx Date To :$flex$.invoice_date_to Invoice Date To Y Open only :$flex$.invoice_date_to Invoice Date To Y RCV Trx Date To :$flex$.invoice_number Invoice Number Exclude Cancelled :$flex$.invoice_number Invoice Number Invoice Date From :$flex$.invoice_number Invoice Number Open only :$flex$.invoice_status Invoice Status Open only :$flex$.ledger Ledger Accounting Period :$flex$.ledger Ledger Expense Account From :$flex$.ledger Ledger Expense Account To :$flex$.ledger Ledger Invoice Date Period :$flex$.ledger Ledger Invoice Number :$flex$.ledger Ledger Operating Unit :$flex$.ledger Ledger RCV Trx Date From :$flex$.ledger Ledger RCV Trx Date To :$flex$.operating_unit Operating Unit Accounting Period :$flex$.operating_unit Operating Unit Invoice Date Period :$flex$.operating_unit Operating Unit Invoice Number :$flex$.operating_unit Operating Unit Supplier :$flex$.operating_unit Operating Unit Supplier Site :$flex$.payment_date_from Payment Date From Y Open only :$flex$.payment_date_from Payment Date From Y Payment Date To :$flex$.payment_date_from Payment Date From Y RCV Trx Date From :$flex$.payment_date_to Payment Date To Y Open only :$flex$.payment_date_to Payment Date To Y RCV Trx Date To :$flex$.payment_period Payment Period Invoice Date From :$flex$.payment_period Payment Period Open only :$flex$.payment_period Payment Period RCV Trx Date From :$flex$.payment_period Payment Period RCV Trx Date To :$flex$.payment_status Payment Status Open only