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）限制的操作单元。 208CACEAD9BF7611E0630100007FAF58Y select /*+ push_pred(y) */ 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 vendor, x.c_vendor_site vendor_site, x.c_invoice_num invoice_number, x.po_number, (select gps.period_name from gl_period_statuses gps where gps.set_of_books_id = x.set_of_books_id and gps.application_id = 200 and gps.adjustment_period_flag = 'N' and x.c_invoice_date between gps.start_date and gps.end_date ) invoice_date_period, x.c_invoice_date invoice_date, x.c_original_amount held_original_amt_func_curr, x.c_amount_remaining held_remaining_amt_func_curr, x.c_description invoice_description, (select gps.period_name from gl_period_statuses gps where gps.set_of_books_id = x.set_of_books_id and gps.application_id = 200 and gps.adjustment_period_flag = 'N' and trunc(x.c_inv_creation_date) between gps.start_date and gps.end_date ) invoice_creation_period, trunc(x.c_inv_creation_date) invoice_creation_date, y.cost_center highest_value_cost_centre, trunc(x.payment_date) payment_date, x.invoice_pay_group, x.invalid_account, to_char(x.c_invoice_date,'YYYY-MM - Mon') invoice_date_label, to_char(x.c_inv_creation_date,'YYYY-MM - Mon') invoice_creation_date_label, case when row_number() over (partition by x.c_invoice_id,x.c_hold_type order by x.c_hold_code) = 1 then 1 else 0 end invoice_count, case when row_number() over (partition by x.c_invoice_id,x.c_hold_type order by x.c_hold_code) = 1 then x.c_original_amount else null end inv_original_amt_func_curr, case when row_number() over (partition by x.c_invoice_id,x.c_hold_type order by x.c_hold_code) = 1 then x.c_amount_remaining else null end inv_remaining_amt_func_curr from ( select -- invoices on hold gsob.set_of_books_id, gsob.chart_of_accounts_id, gsob.name ledger, haou.name operating_unit, v.vendor_name c_vendor_name, v.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, ( select distinct poh.segment1 from po_line_locations poll, po_headers poh where poll.line_location_id = h.line_location_id and poll.po_header_id = poh.po_header_id ) po_number, 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, (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, case when h.hold_lookup_code= 'DIST ACCT INVALID' then ( select distinct listagg(gcck.concatenated_segments,', ') within group (order by gcck.concatenated_segments) from ap_invoice_distributions aid, gl_code_combinations gcc, gl_code_combinations_kfv gcck where aid.invoice_id = h.invoice_id and aid.line_type_lookup_code = 'ITEM' and aid.dist_code_combination_id = gcc.code_combination_id (+) and aid.dist_code_combination_id = gcck.code_combination_id (+) and ( gcc.code_combination_id is null or gcc.detail_posting_allowed_flag = 'N' or trunc(gcc.start_date_active) > aid.accounting_date or trunc(gcc.end_date_active) < aid.accounting_date or gcc.template_id is not null or gcc.enabled_flag <> 'Y' or gcc.summary_flag <>'N' ) ) else null end invalid_account from gl_sets_of_books gsob, hr_all_organization_units haou, po_vendors v, po_vendor_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 v.vendor_id = inv1.vendor_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 union select -- payments on hold gsob.chart_of_accounts_id, gsob.set_of_books_id, gsob.name ledger, haou.name operating_unit, v.vendor_name c_vendor_name, v.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, null po_number, 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, 'Scheduled Payment Hold' c_description, 'Scheduled Payment Hold' c_hold_type, inv1.creation_date c_inv_creation_date, inv1.pay_group_lookup_code invoice_pay_group, (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, null invalid_account from gl_sets_of_books gsob, hr_all_organization_units haou, po_vendors v, po_vendor_sites vs, ap_invoices inv1, ap_batches_all b, ap_payment_schedules s, fnd_currencies_vl f where 2=2 and v.vendor_id = inv1.vendor_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 union select -- vendor sites on hold gsob.set_of_books_id, gsob.chart_of_accounts_id, gsob.name ledger, haou.name operating_unit, v.vendor_name c_vendor_name, 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, null po_number, 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, (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, null invalid_account from gl_sets_of_books gsob, hr_all_organization_units haou, po_vendors v, po_vendor_sites vs, ap_invoices inv1, ap_batches_all b, ap_payment_schedules s, fnd_currencies_vl f where 2=2 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' ) x, (select distinct y.invoice_id, first_value(y.cctr) over (partition by y.invoice_id order by y.amount desc, y.cctr rows between unbounded preceding and unbounded following) cost_center from (select aid.invoice_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg','SQLGL','GL#',gcc.chart_of_accounts_id,null,gcc.code_combination_id,'FA_COST_CTR','Y','VALUE') cctr, sum(amount) amount from ap_invoice_distributions aid, po_distributions pd, gl_code_combinations gcc where aid.line_type_lookup_code != 'TAX' and aid.po_distribution_id = pd.po_distribution_id (+) and nvl(pd.code_combination_id,aid.dist_code_combination_id) = gcc.code_combination_id group by aid.invoice_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg','SQLGL','GL#',gcc.chart_of_accounts_id,null,gcc.code_combination_id,'FA_COST_CTR','Y','VALUE') ) y ) y where 1=1 and x.c_invoice_id = y.invoice_id (+) 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 SQLAP #,##0.00;[Red](#,##0.00) B0133B97EC1B0451E0530100007F85D5 US AP Invoice on Hold 11i Based on Oracle standard Invoice on Hold report Source: Invoice on Hold Report (XML) Short Name: APXINROH_XML Enginatics 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 xxen_util.meaning('Y','YES_NO',0) 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_vendor_name LOV custom Y Y select pv.vendor_name value, pv.segment1 description from po_vendors pv where (:$flex$.operating_unit is null or pv.vendor_id in (select pvsa.vendor_id from hr_all_organization_units_vl haouv, po_vendor_sites_all pvsa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=pvsa.org_id)) order by pv.vendor_name, pv.vendor_id US Vendor 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 :$flex$.operating_unit Operating Unit Vendor C8C4ABC9407B3E741304596C85616AC0 Pivot: Summary By Hold Name, Vendor SYSADMIN 7 Accounting Allowed -14.0016 Amount Remaining (Func Curr) 8 BATCH_NAME -16.0017 DESCRIPTION -20.0021 DISPUTE_REASON 15 HELD_ORIGINAL_AMT_FUNC_CURR 16 HELD_REMAINING_AMT_FUNC_CURR 20 HIGHEST_VALUE_COST_CENTRE 5 HOLD_CODE 4 HOLD_NAME 3 3 HOLD_TYPE 1 6 Hold Description 23 INVALID_ACCOUNT 26 INVOICE_COUNT 19 INVOICE_CREATION_DATE 25 INVOICE_CREATION_DATE_LABEL 18 INVOICE_CREATION_PERIOD 14 INVOICE_DATE 4 24 INVOICE_DATE_LABEL 13 INVOICE_DATE_PERIOD 17 INVOICE_DESCRIPTION -12.0013 INVOICE_MONTH -22.0023 INVOICE_MONTH_LABEL 11 INVOICE_NUMBER 5 22 INVOICE_PAY_GROUP 27 INV_ORIGINAL_AMT_FUNC_CURR 28 INV_REMAINING_AMT_FUNC_CURR 1 LEDGER 2 OPERATING_UNIT -14.0015 Original Amount (Func Curr) 21 PAYMENT_DATE 12 PO_NUMBER -8.001 SITE -8.0009 TRADING_PARTNER 2 9 VENDOR 10 VENDOR_SITE Amount Remaining (Func Curr) VALUE 2 SUM HELD_ORIGINAL_AMT_FUNC_CURR VALUE 1 SUM HELD_REMAINING_AMT_FUNC_CURR VALUE 2 SUM HOLD_NAME ROW 2 HOLD_TYPE ROW 1 INVOICE_MONTH_LABEL ROW 2 INVOICE_NUMBER VALUE 3 COUNT Original Amount (Func Curr) VALUE 1 SUM VENDOR ROW 3 S Site 1CC4BF0ADD96EF0659A417CB466E4407 Pivot: Summary by Highest Value Cost Center SYSADMIN 7 Accounting Allowed -14.0016 Amount Remaining (Func Curr) 8 BATCH_NAME 15 HELD_ORIGINAL_AMT_FUNC_CURR 16 HELD_REMAINING_AMT_FUNC_CURR 20 HIGHEST_VALUE_COST_CENTRE 2 5 HOLD_CODE 4 HOLD_NAME 5 3 HOLD_TYPE 1 6 Hold Description 23 INVALID_ACCOUNT 26 INVOICE_COUNT 19 INVOICE_CREATION_DATE 25 INVOICE_CREATION_DATE_LABEL 18 INVOICE_CREATION_PERIOD 14 INVOICE_DATE 3 24 INVOICE_DATE_LABEL 13 INVOICE_DATE_PERIOD 17 INVOICE_DESCRIPTION 11 INVOICE_NUMBER 4 22 INVOICE_PAY_GROUP 27 INV_ORIGINAL_AMT_FUNC_CURR 28 INV_REMAINING_AMT_FUNC_CURR 1 LEDGER 2 OPERATING_UNIT -14.0015 Original Amount (Func Curr) 21 PAYMENT_DATE 12 PO_NUMBER 9 VENDOR 10 VENDOR_SITE Amount Remaining (Func Curr) VALUE 2 SUM HIGHEST_VALUE_COST_CENTRE ROW 2 HOLD_TYPE ROW 1 INVOICE_COUNT VALUE 3 SUM INV_ORIGINAL_AMT_FUNC_CURR VALUE 1 SUM INV_REMAINING_AMT_FUNC_CURR VALUE 2 SUM Original Amount (Func Curr) VALUE 1 SUM S Site EF5548C5EB9AB21C1E5E0A95101B4D80 Pivot: Summary by Vendors SYSADMIN 7 Accounting Allowed -14.0016 Amount Remaining (Func Curr) 8 BATCH_NAME 15 HELD_ORIGINAL_AMT_FUNC_CURR 16 HELD_REMAINING_AMT_FUNC_CURR 20 HIGHEST_VALUE_COST_CENTRE 5 HOLD_CODE 4 HOLD_NAME 5 3 HOLD_TYPE 1 6 Hold Description 23 INVALID_ACCOUNT 26 INVOICE_COUNT 19 INVOICE_CREATION_DATE 25 INVOICE_CREATION_DATE_LABEL 18 INVOICE_CREATION_PERIOD 14 INVOICE_DATE 3 24 INVOICE_DATE_LABEL 13 INVOICE_DATE_PERIOD 17 INVOICE_DESCRIPTION 11 INVOICE_NUMBER 4 22 INVOICE_PAY_GROUP 27 INV_ORIGINAL_AMT_FUNC_CURR 28 INV_REMAINING_AMT_FUNC_CURR 1 LEDGER 2 OPERATING_UNIT -14.0015 Original Amount (Func Curr) 21 PAYMENT_DATE 12 PO_NUMBER 9 VENDOR 2 10 VENDOR_SITE Amount Remaining (Func Curr) VALUE 2 SUM HOLD_TYPE ROW 1 INVOICE_COUNT VALUE 3 SUM INV_ORIGINAL_AMT_FUNC_CURR VALUE 1 SUM INV_REMAINING_AMT_FUNC_CURR VALUE 2 SUM Original Amount (Func Curr) VALUE 1 SUM VENDOR ROW 2 S Site SYSADMIN C8C4ABC9407B3E741304596C85616AC0 1CC4BF0ADD96EF0659A417CB466E4407