ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 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）限制的操作单元。 B0133B97EC1B0451E0530100007F85D5 select x.ledger ,x.operating_unit ,x.c_hold_type hold_type ,x.c_nls_hold_code hold_name ,x.c_hold_code hold_code ,x.c_nls_hold_desc "Hold Description" ,x.c_postable "Accounting Allowed" ,x.c_batch_name batch_name ,x.c_vendor_name trading_partner ,x.c_vendor_site site ,x.c_invoice_num invoice_number ,(select listagg(poh.segment1,', ') within group (order by poh.segment1) from po_headers_all poh where exists ( select null from ap_invoice_lines ail, po_line_locations_all plla where ail.invoice_id=x.c_invoice_id and ail.po_line_location_id=plla.line_location_id and plla.po_header_id=poh.po_header_id ) ) po_number ,(select listagg(to_char(pol.line_num),', ') within group (order by pol.line_num) from po_lines_all pol where exists ( select null from ap_invoice_lines ail, po_line_locations_all plla where ail.invoice_id=x.c_invoice_id and ail.po_line_location_id=plla.line_location_id and plla.po_line_id=pol.po_line_id ) ) po_line_number ,to_char(x.c_invoice_date,'fmMonth YYYY') invoice_month ,x.c_invoice_date invoice_date ,x.c_original_amount "Original Amount (Func Curr)" ,x.c_amount_remaining "Amount Remaining (Func Curr)" ,x.c_description description ,trunc(x.c_inv_creation_date) invoice_creation_date ,trunc(x.payment_date) payment_date ,x.invoice_pay_group ,x.dispute_reason ,(select distinct listagg(description,', ') within group (order by description) description from ( select distinct aid.invoice_id , ah.hold_lookup_code , ap_utilities_pkg.get_charge_account(aid.dist_code_combination_id,gls.chart_of_accounts_id,'APXINROH') description from ap_invoice_distributions aid , gl_sets_of_books gls , ap_holds ah where ah.hold_lookup_code = 'DIST ACCT INVALID' and ah.release_lookup_code is null and aid.invoice_id = ah.invoice_id and gls.set_of_books_id = aid.set_of_books_id and ( exists (select 'x' from gl_code_combinations c where aid.dist_code_combination_id = c.code_combination_id (+) and ( c.code_combination_id is null or c.detail_posting_allowed_flag = 'N' or trunc(c.start_date_active) > aid.accounting_date or trunc(c.end_date_active) < aid.accounting_date or c.template_id is not null or c.enabled_flag <> 'Y' or c.summary_flag <>'N' )) or (aid.dist_code_combination_id = -1) ) ) d where d.invoice_id = x.c_invoice_id and d.hold_lookup_code = x.c_hold_code ) invalid_account, to_char(x.c_invoice_date,'YYYY/MM') || ' - ' || to_char(x.c_invoice_date,'fmMonth YYYY') invoice_month_label from ( select -- invoices on hold gsob.name ledger, haou.name operating_unit, hp.party_name c_vendor_name, inv1.party_id c_party_id, inv1.vendor_id c_vendor_id, vs.vendor_site_code c_vendor_site, decode(h.hold_lookup_code, null,:c_nls_na, h.hold_lookup_code) c_hold_code, decode(h.hold_lookup_code, null,:c_nls_na, alc.displayed_field) c_nls_hold_code, decode(h.hold_lookup_code, null,:c_nls_na, alc.description) c_nls_hold_desc, decode(ahc.postable_flag,'Y',:c_nls_yes,:c_nls_no) c_postable, inv1.invoice_date c_invoice_date, b.batch_name c_batch_name, inv1.invoice_id c_invoice_id, inv1.invoice_num c_invoice_num, decode(inv1.invoice_currency_code, gsob.currency_code, inv1.invoice_amount, inv1.base_amount) c_original_amount, decode(inv1.invoice_currency_code, gsob.currency_code, inv1.invoice_amount, inv1.base_amount) - decode(inv1.payment_currency_code, gsob.currency_code, nvl(inv1.amount_paid,0) + nvl(discount_amount_taken,0), decode(f.minimum_accountable_unit, null, round(((decode(inv1.payment_cross_rate_type, 'EMU FIXED', 1/inv1.payment_cross_rate, inv1.exchange_rate)) * nvl(inv1.amount_paid,0)), f.precision), round(((decode(inv1.payment_cross_rate_type, 'EMU FIXED', 1/inv1.payment_cross_rate, inv1.exchange_rate)) * nvl(inv1.amount_paid,0)) / f.minimum_accountable_unit) * f.minimum_accountable_unit) + decode(f.minimum_accountable_unit, null, round(((decode(inv1.payment_cross_rate_type, 'EMU FIXED', 1/inv1.payment_cross_rate, inv1.exchange_rate)) * nvl(inv1.discount_amount_taken,0)), f.precision), round(((decode(inv1.payment_cross_rate_type, 'EMU FIXED', 1/inv1.payment_cross_rate, inv1.exchange_rate)) * nvl(inv1.discount_amount_taken,0)) / f.minimum_accountable_unit) * f.minimum_accountable_unit)) c_amount_remaining, inv1.description c_description, 'Invoice Hold' c_hold_type, inv1.creation_date c_inv_creation_date, inv1.pay_group_lookup_code invoice_pay_group, inv1.dispute_reason, (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 = inv1.invoice_id ) payment_date from gl_sets_of_books gsob, hr_all_organization_units haou, hz_parties hp, ap_supplier_sites vs, ap_invoices inv1, ap_batches_all b, ap_payment_schedules s, ap_holds h, ap_hold_codes ahc, ap_lookup_codes alc, fnd_currencies_vl f where 2=2 and hp.party_id = inv1.party_id and gsob.set_of_books_id = inv1.set_of_books_id and haou.organization_id = inv1.org_id and vs.vendor_id (+) = inv1.vendor_id and vs.vendor_site_id (+) = inv1.vendor_site_id and h.invoice_id = inv1.invoice_id and b.batch_id(+) = inv1.batch_id and s.invoice_id(+) = inv1.invoice_id and h.release_lookup_code is null and f.currency_code = gsob.currency_code and alc.lookup_type = 'HOLD CODE' and alc.lookup_code = h.hold_lookup_code and ahc.hold_lookup_code = h.hold_lookup_code group by gsob.name, haou.name, h.hold_lookup_code, alc.displayed_field, alc.description, ahc.postable_flag, hp.party_name, inv1.party_id, inv1.vendor_id, vs.vendor_site_code, inv1.invoice_date, inv1.invoice_id, b.batch_name, inv1.invoice_num, decode(inv1.invoice_currency_code, gsob.currency_code, inv1.invoice_amount, inv1.base_amount), decode(inv1.invoice_currency_code, gsob.currency_code, inv1.invoice_amount, inv1.base_amount) - decode(inv1.payment_currency_code, gsob.currency_code, nvl(inv1.amount_paid,0) + nvl(discount_amount_taken,0), decode(f.minimum_accountable_unit, null, round(((decode(inv1.payment_cross_rate_type, 'EMU FIXED', 1/inv1.payment_cross_rate, inv1.exchange_rate)) * nvl(inv1.amount_paid,0)), f.precision), round(((decode(inv1.payment_cross_rate_type, 'EMU FIXED', 1/inv1.payment_cross_rate, inv1.exchange_rate)) * nvl(inv1.amount_paid,0)) / f.minimum_accountable_unit) * f.minimum_accountable_unit) + decode(f.minimum_accountable_unit, null, round(((decode(inv1.payment_cross_rate_type, 'EMU FIXED', 1/inv1.payment_cross_rate, inv1.exchange_rate)) * nvl(inv1.discount_amount_taken,0)), f.precision), round(((decode(inv1.payment_cross_rate_type, 'EMU FIXED', 1/inv1.payment_cross_rate, inv1.exchange_rate)) * nvl(inv1.discount_amount_taken,0)) / f.minimum_accountable_unit) * f.minimum_accountable_unit)), inv1.description, inv1.creation_date, inv1.pay_group_lookup_code, inv1.dispute_reason union select -- payments on hold gsob.name ledger, haou.name operating_unit, hp.party_name c_vendor_name, inv1.party_id c_party_id, inv1.vendor_id c_vendor_id, vs.vendor_site_code c_vendor_site, :c_nls_na c_hold_code, 'Scheduled Payment Hold' c_nls_hold_code, :c_nls_na c_nls_hold_desc, :c_nls_na c_postable, inv1.invoice_date c_invoice_date, b.batch_name c_batch_name, inv1.invoice_id c_nr_invoice_id, inv1.invoice_num c_invoice_num, decode(inv1.invoice_currency_code, gsob.currency_code, inv1.invoice_amount, inv1.base_amount) c_original_amount, decode(inv1.invoice_currency_code, gsob.currency_code, inv1.invoice_amount,inv1.base_amount) - decode(inv1.payment_currency_code, gsob.currency_code, nvl(inv1.amount_paid,0) + nvl(discount_amount_taken,0), decode(f.minimum_accountable_unit, null, round(((decode(inv1.payment_cross_rate_type, 'EMU FIXED', 1/inv1.payment_cross_rate, inv1.exchange_rate)) * nvl(inv1.amount_paid,0)), f.precision), round(((decode(inv1.payment_cross_rate_type, 'EMU FIXED', 1/inv1.payment_cross_rate, inv1.exchange_rate)) * nvl(inv1.amount_paid,0)) / f.minimum_accountable_unit) * f.minimum_accountable_unit) + decode(f.minimum_accountable_unit, null, round(((decode(inv1.payment_cross_rate_type, 'EMU FIXED', 1/inv1.payment_cross_rate, inv1.exchange_rate)) * nvl(inv1.discount_amount_taken,0)), f.precision), round(((decode(inv1.payment_cross_rate_type, 'EMU FIXED', 1/inv1.payment_cross_rate, inv1.exchange_rate)) * nvl(inv1.discount_amount_taken,0)) / f.minimum_accountable_unit) * f.minimum_accountable_unit)) c_amount_remaining, max(s.iby_hold_reason) c_description, 'Scheduled Payment Hold' c_hold_type, inv1.creation_date c_inv_creation_date, inv1.pay_group_lookup_code invoice_pay_group, inv1.dispute_reason, (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 = inv1.invoice_id ) payment_date from gl_sets_of_books gsob, hr_all_organization_units haou, hz_parties hp, ap_supplier_sites vs, ap_invoices inv1, ap_batches_all b, ap_payment_schedules s, fnd_currencies_vl f where 2=2 and hp.party_id = inv1.party_id and gsob.set_of_books_id = inv1.set_of_books_id and haou.organization_id = inv1.org_id and vs.vendor_id (+) = inv1.vendor_id and vs.vendor_site_id (+) = inv1.vendor_site_id and b.batch_id(+) = inv1.batch_id and s.invoice_id = inv1.invoice_id and s.hold_flag = 'Y' and f.currency_code = gsob.currency_code group by gsob.name, haou.name, hp.party_name, inv1.party_id, inv1.vendor_id, vs.vendor_site_code, vs.vendor_site_code, inv1.invoice_date, inv1.invoice_id, b.batch_name, inv1.invoice_num, decode(inv1.invoice_currency_code, gsob.currency_code, inv1.invoice_amount, inv1.base_amount), decode(inv1.invoice_currency_code, gsob.currency_code, inv1.invoice_amount,inv1.base_amount) - decode(inv1.payment_currency_code, gsob.currency_code, nvl(inv1.amount_paid,0) + nvl(discount_amount_taken,0), decode(f.minimum_accountable_unit, null, round(((decode(inv1.payment_cross_rate_type, 'EMU FIXED', 1/inv1.payment_cross_rate, inv1.exchange_rate)) * nvl(inv1.amount_paid,0)), f.precision), round(((decode(inv1.payment_cross_rate_type, 'EMU FIXED', 1/inv1.payment_cross_rate, inv1.exchange_rate)) * nvl(inv1.amount_paid,0)) / f.minimum_accountable_unit) * f.minimum_accountable_unit) + decode(f.minimum_accountable_unit, null, round(((decode(inv1.payment_cross_rate_type, 'EMU FIXED', 1/inv1.payment_cross_rate, inv1.exchange_rate)) * nvl(inv1.discount_amount_taken,0)), f.precision), round(((decode(inv1.payment_cross_rate_type, 'EMU FIXED', 1/inv1.payment_cross_rate, inv1.exchange_rate)) * nvl(inv1.discount_amount_taken,0)) / f.minimum_accountable_unit) * f.minimum_accountable_unit)), inv1.creation_date, inv1.pay_group_lookup_code, inv1.dispute_reason union select -- vendor sites on hold gsob.name ledger, haou.name operating_unit, hp.party_name c_vendor_name, inv1.party_id c_party_id, v.vendor_id c_vendor_id, vs.vendor_site_code c_vendor_site, :c_nls_na c_hold_code, 'Supplier Site Hold' c_nls_hold_code, :c_nls_na c_nls_hold_desc, :c_nls_na c_postable, inv1.invoice_date c_invoice_date, b.batch_name c_batch_name, inv1.invoice_id c_invoice_id, inv1.invoice_num c_invoice_num, decode(inv1.invoice_currency_code, gsob.currency_code, inv1.invoice_amount, inv1.base_amount) c_original_amount, decode(inv1.invoice_currency_code,gsob.currency_code, inv1.invoice_amount,inv1.base_amount) - decode(inv1.payment_currency_code, gsob.currency_code, nvl(inv1.amount_paid,0) + nvl(discount_amount_taken,0), decode(f.minimum_accountable_unit, null, round(((decode(inv1.payment_cross_rate_type, 'EMU FIXED', 1/inv1.payment_cross_rate, inv1.exchange_rate)) * nvl(inv1.amount_paid,0)), f.precision), round(((decode(inv1.payment_cross_rate_type, 'EMU FIXED', 1/inv1.payment_cross_rate, inv1.exchange_rate)) * nvl(inv1.amount_paid,0)) / f.minimum_accountable_unit) * f.minimum_accountable_unit) + decode(f.minimum_accountable_unit, null, round(((decode(inv1.payment_cross_rate_type, 'EMU FIXED', 1/inv1.payment_cross_rate, inv1.exchange_rate)) * nvl(inv1.discount_amount_taken,0)), f.precision), round(((decode(inv1.payment_cross_rate_type, 'EMU FIXED', 1/inv1.payment_cross_rate, inv1.exchange_rate)) * nvl(inv1.discount_amount_taken,0)) / f.minimum_accountable_unit) * f.minimum_accountable_unit)) c_amount_remaining, inv1.description c_description, 'Supplier Site Hold' c_hold_type, inv1.creation_date c_inv_creation_date, inv1.pay_group_lookup_code invoice_pay_group, inv1.dispute_reason, (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 = inv1.invoice_id ) payment_date from gl_sets_of_books gsob, hr_all_organization_units haou, hz_parties hp, ap_suppliers v, ap_supplier_sites vs, ap_invoices inv1, ap_batches_all b, ap_payment_schedules s, fnd_currencies_vl f where 2=2 and hp.party_id = inv1.party_id and gsob.set_of_books_id = inv1.set_of_books_id and haou.organization_id = inv1.org_id and v.vendor_id (+) = inv1.vendor_id and vs.vendor_id (+) = inv1.vendor_id and vs.vendor_site_id (+) = inv1.vendor_site_id and b.batch_id(+) = inv1.batch_id and s.invoice_id(+) = inv1.invoice_id and vs.hold_all_payments_flag = 'Y' and f.currency_code = gsob.currency_code and inv1.cancelled_date is null and inv1.payment_status_flag != 'Y' group by gsob.name, haou.name, hp.party_name, inv1.party_id, v.vendor_id, vs.vendor_site_code, b.batch_name, inv1.invoice_date, inv1.invoice_id, inv1.invoice_num, decode(inv1.invoice_currency_code, gsob.currency_code, inv1.invoice_amount, inv1.base_amount), decode(inv1.invoice_currency_code,gsob.currency_code, inv1.invoice_amount,inv1.base_amount) - decode(inv1.payment_currency_code, gsob.currency_code, nvl(inv1.amount_paid,0) + nvl(discount_amount_taken,0), decode(f.minimum_accountable_unit, null, round(((decode(inv1.payment_cross_rate_type, 'EMU FIXED', 1/inv1.payment_cross_rate, inv1.exchange_rate)) * nvl(inv1.amount_paid,0)), f.precision), round(((decode(inv1.payment_cross_rate_type, 'EMU FIXED', 1/inv1.payment_cross_rate, inv1.exchange_rate)) * nvl(inv1.amount_paid,0)) / f.minimum_accountable_unit) * f.minimum_accountable_unit) + decode(f.minimum_accountable_unit, null, round(((decode(inv1.payment_cross_rate_type, 'EMU FIXED', 1/inv1.payment_cross_rate, inv1.exchange_rate)) * nvl(inv1.discount_amount_taken,0)), f.precision), round(((decode(inv1.payment_cross_rate_type, 'EMU FIXED', 1/inv1.payment_cross_rate, inv1.exchange_rate)) * nvl(inv1.discount_amount_taken,0)) / f.minimum_accountable_unit) * f.minimum_accountable_unit)), inv1.description, inv1.creation_date, inv1.pay_group_lookup_code, inv1.dispute_reason ) x where 1=1 order by decode(:p_order_by, 'Hold Name',c_nls_hold_code,x.c_vendor_name) ,x.c_vendor_name ,x.c_vendor_site ,x.c_invoice_date ,x.c_invoice_num ,x.c_nls_hold_code Added PO Line Number, Removed rownum=1 from PO number to list All (listagg) Y SQLAP #,##0.00;[Red](#,##0.00) AR AP Invoice on Hold Application: المدفوعات Source: تقرير إيقاف الفاتورة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: APXINROH_XML DB package: AP_APXINROH_XMLP_PKG D AP Invoice on Hold Application: Kreditoren Source: Rechnungen - gesperrt (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: APXINROH_XML DB package: AP_APXINROH_XMLP_PKG E AP Invoice on Hold Informe importado de facturas estándar de Oracle en espera Fuente: Informe de facturas en espera (XML) Nombre corto: APXINROH_XML Paquete DB: AP_APXINROH_XMLP_PKG F AP Invoice on Hold Application: Payables Source: Etat des factures bloquées (XML) - Non pris en charge : réservé pour une utilisation future Short Name: APXINROH_XML DB package: AP_APXINROH_XMLP_PKG I AP Invoice on Hold Application: Payables Source: Rapporto Fatture bloccate (XML) - non supportato: riservato per usi futuri Short Name: APXINROH_XML DB package: AP_APXINROH_XMLP_PKG JA AP Invoice on Hold Oracle標準請求書の保留レポートをインポート 出典はこちらです。請求書保留報告書(XML) 短縮名。APXINROH_XML DBパッケージです。AP_APXINROH_XMLP_PKG KO AP Invoice on Hold 임포트 된 Oracle 표준 송장 보류 보고서 출처 : 송장 보류 보고서 (XML) 짧은 이름 : APXINROH_XML DB 패키지 : AP_APXINROH_XMLP_PKG PTB AP Invoice on Hold Relatório de fatura padrão importada da Oracle em espera Fonte: Relatório de Fatura em Espera (XML) Nome curto: APXINROH_XML Pacote DB: AP_APXINROH_XMLP_PKG RU AP Invoice on Hold Импортированный стандартный счет-фактура Oracle в отчете о состоянии ожидания Источник: Счет-фактура на удержание отчета (XML) Короткое имя: APXINROH_XML БД-пакет: AP_APXINROH_XMLP_PKG S AP Invoice on Hold Importerad Oracle-standardfaktura i väntan Källa: Invoice on Hold Report (XML) Kort namn: APXINROH_XML DB-paket: AP_APXINROH_XMLP_PKG TR AP Invoice on Hold Beklemedeki Oracle standart faturası içe aktarıldı Kaynak: Bekletilen Fatura Raporu (XML) Kısa isim: APXINROH_XML DB paketi: AP_APXINROH_XMLP_PKG US AP Invoice on Hold Based on Oracle standard Invoice on Hold report Source: Invoice on Hold Report (XML) Short Name: APXINROH_XML ZHS AP Invoice on Hold Application: 应付帐款 Source: 暂挂发票报表 (XML) - 不支持：已保留供将来使用 Short Name: APXINROH_XML DB package: AP_APXINROH_XMLP_PKG Enginatics GST Reports R12 only 1=1 2=2 :c_nls_na :c_nls_no :c_nls_yes :p_order_by 1 -30 :c_nls_no Char xxen_util.meaning('N','YES_NO',0) US c_nls_no 2 -20 :c_nls_yes Char Y US c_nls_yes 3 -10 :c_nls_na Char select alc.displayed_field from ap_lookup_codes alc where alc.lookup_type = 'NLS REPORT PARAMETER' and alc.lookup_code = 'NA' US c_nls_na 4 10 1=1 x.operating_unit=:p_operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit 5 20 1=1 x.c_hold_code=xxen_util.lookup_code(:p_hold_code,'HOLD CODE',200) LOV custom Y select alc.displayed_field value, null description from ap_lookup_codes alc where alc.lookup_type='HOLD CODE' and alc.lookup_code in (select ahc.hold_lookup_code from ap_hold_codes ahc where (ahc.hold_type like '%REASON' or ahc.hold_type in ('INSUFFICIENT INFORMATION','PERIOD HOLD TYPE','PERIOD RELEASE TYPE')) and nvl(alc.inactive_date,sysdate+1)>sysdate) and alc.enabled_flag='Y' order by alc.displayed_field US Hold Name 6 30 1=1 x.c_vendor_name=:p_party_name LOV custom Y select hp.party_name value, null description from hz_parties hp where exists (select 'Payee Party' from iby_external_payees_v ibp where ibp.payee_party_id=hp.party_id and ibp.payment_function in ('PAYABLES_DISB','EMPLOYEE_EXP','LOANS_PAYMENTS','AR_CUSTOMER_REFUNDS') ) order by hp.party_name US Trading Partner 7 50 :p_order_by LOV Oracle AP_SRS_ORDER_HOLD_VENDOR Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where nvl(inactive_date,sysdate+1)>sysdate and lookup_type='RPT ORDER BY' order by value,description Hold Name Y US Order By 8 60 1=1 x.c_inv_creation_date>=:p_start_creation_date Date US Entered Date From 9 70 1=1 x.c_inv_creation_date<:p_end_creation_date+1 Date last_day(:$flex$.Entered_Date_From) US Entered Date To 10 90 2=2 nvl(s.due_date, sysdate)>=:p_start_due_date Date US Due Date From 11 100 2=2 nvl(s.due_date, sysdate)<:p_end_due_date+1 Date last_day(:$flex$.Due_Date_From) US Due Date To 12 110 2=2 ( nvl(s.discount_date, sysdate)>=:p_start_discount_date or nvl(s.second_discount_date, sysdate)>=:p_start_discount_date or nvl(s.third_discount_date, sysdate)>=:p_start_discount_date ) Date US Discount Date From 13 120 2=2 ( nvl(s.discount_date, sysdate)<:p_end_discount_date+1 or nvl(s.second_discount_date, sysdate)<:p_end_discount_date+1 or nvl(s.third_discount_date, sysdate)<:p_end_discount_date+1 ) Date last_day(:$flex$.Discount_Date_From) US Discount Date To :$flex$.Discount_Date_From Discount Date From Y Discount Date To :$flex$.Due_Date_From Due Date From Y Due Date To :$flex$.Entered_Date_From Entered Date From Y Entered Date To Pivot: By Hold, Invoice Month SYSADMIN 7 Accounting Allowed 17 Amount Remaining (Func Curr) 8 BATCH_NAME 18 DESCRIPTION 22 DISPUTE_REASON 5 HOLD_CODE 4 HOLD_NAME 1 3 HOLD_TYPE 6 Hold Description 23 INVALID_ACCOUNT 19 INVOICE_CREATION_DATE 15 INVOICE_DATE 3 14 INVOICE_MONTH 24 INVOICE_MONTH_LABEL 11 INVOICE_NUMBER 4 21 INVOICE_PAY_GROUP 1 LEDGER 2 OPERATING_UNIT 16 Original Amount (Func Curr) 20 PAYMENT_DATE 13 PO_LINE_NUMBER 12 PO_NUMBER 10 SITE 9 TRADING_PARTNER 2 Amount Remaining (Func Curr) VALUE 2 SUM HOLD_NAME ROW 1 INVOICE_MONTH_LABEL ROW 2 INVOICE_NUMBER VALUE 3 COUNT LEDGER FILTER 1 OPERATING_UNIT FILTER 2 Original Amount (Func Curr) VALUE 1 SUM S Site Pivot: By Trading Party, Invoice Month SYSADMIN 7 Accounting Allowed 17 Amount Remaining (Func Curr) 8 BATCH_NAME 18 DESCRIPTION 22 DISPUTE_REASON 5 HOLD_CODE 4 HOLD_NAME 3 3 HOLD_TYPE 6 Hold Description 23 INVALID_ACCOUNT 19 INVOICE_CREATION_DATE 15 INVOICE_DATE 2 14 INVOICE_MONTH 24 INVOICE_MONTH_LABEL 11 INVOICE_NUMBER 4 21 INVOICE_PAY_GROUP 1 LEDGER 2 OPERATING_UNIT 16 Original Amount (Func Curr) 20 PAYMENT_DATE 13 PO_LINE_NUMBER 12 PO_NUMBER 10 SITE 9 TRADING_PARTNER 1 Amount Remaining (Func Curr) VALUE 2 SUM INVOICE_MONTH_LABEL ROW 2 INVOICE_NUMBER VALUE 3 COUNT LEDGER FILTER 1 OPERATING_UNIT FILTER 2 Original Amount (Func Curr) VALUE 1 SUM TRADING_PARTNER ROW 1 S Site SYSADMIN Pivot: By Trading Party, Invoice Month PIYUSH.KHANDELWAL Pivot: By Trading Party, Invoice Month Pivot: By Hold, Invoice Month