ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual US 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）限制的操作单元。 F263DDA3FBF60F8FE0530100007F75CD HR Operating Unit for Upload Y select hou.organization_id id, hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.operating_unit is null or hou.name=:$flex$.operating_unit) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication US Operating unit restricted by multi org access control (MOAC) A22D9E9236CE414C81CEAB7A95D47013Y select to_char(null) action_, to_char(null) status_, to_char(null) message_, null modified_columns_, haouv.name operating_unit, aps.vendor_name supplier, aps.segment1 supplier_number, assa.vendor_site_code supplier_site, aia.invoice_num invoice_number, aia.invoice_date, aia.invoice_amount, aia.invoice_currency_code currency, alc.displayed_field hold_name, aha.hold_reason, aha.hold_date, decode(aha.held_by,5,(select alc_sys.displayed_field from ap_lookup_codes alc_sys where alc_sys.lookup_type='NLS TRANSLATION' and alc_sys.lookup_code='SYSTEM'),xxen_util.user_name(aha.held_by)) held_by, pha.segment1 po_number, pola.line_num po_line, plla.shipment_num po_shipment, aha.line_number invoice_line, aha.hold_details, null release_name, null release_reason, aha.hold_id, null upload_row from ap_holds_all aha, ap_invoices_all aia, ap_suppliers aps, ap_supplier_sites_all assa, hr_all_organization_units_vl haouv, ap_hold_codes ahc, ap_lookup_codes alc, po_line_locations_all plla, po_lines_all pola, po_headers_all pha where 1=1 and aha.release_lookup_code is null and aha.invoice_id=aia.invoice_id and aia.org_id=haouv.organization_id and aia.org_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) and aia.vendor_id=aps.vendor_id(+) and aia.vendor_site_id=assa.vendor_site_id(+) and aha.hold_lookup_code=ahc.hold_lookup_code and alc.lookup_type='HOLD CODE' and alc.lookup_code=aha.hold_lookup_code and aha.line_location_id=plla.line_location_id(+) and plla.po_line_id=pola.po_line_id(+) and plla.po_header_id=pha.po_header_id(+) Place and release AP invoice holds at hold-row grain via AP_HOLDS_PKG (Invoice Workbench Holds tab parity). Holds are identified by the visible business key (Operating Unit + Invoice Number + Supplier + Hold Name, discriminated by PO references or Invoice Line) so pasted rows work; a hidden Hold Id round-trips for downloaded rows. Review hardening: a round-tripped Hold Id of an already released hold reports as already released instead of matching a newer hold of the same code, visible PO/line discriminators override a contradicting copied Hold Id, PO Line/Shipment discriminate independently of PO Number, hold context columns default from the resolved open hold for pasted rows, and the Release Name list derives the release reason type from the resolved hold when the PO Number cell is blank. R12 only pending an EBS 11i twin (11i AP_HOLDS_PKG has a different UPDATE_ROW signature). U A xxen_ap_upload.upload_invoice_hold US AP Invoice Hold Upload Releases and places AP invoice holds in bulk - the Excel equivalent of the Invoice Workbench Holds tab. Download the open holds with the download parameters, pick a Release Name (and optionally overwrite the defaulted Release Reason) on the rows to release, and upload. Each hold row is released through the same Oracle logic as the form, including the invoice holds workflow abort, the hold business event and the E-Business Tax synchronization. To place a new manual hold, add a row with the invoice reference and a Hold Name, leaving the Release Name blank. Holds are identified by Operating Unit, Invoice Number, Supplier and Hold Name, so rows can also be pasted from an external list instead of downloaded. When an invoice has several open holds of the same name (for example matching holds on different purchase order shipments), the PO Number, PO Line, PO Shipment or Invoice Line columns identify the exact hold. By default only user releasable holds are downloaded - system holds such as Line Variance or Distribution Variance cannot be released manually and are removed by correcting the invoice and revalidating. Set User Releasable Only to No to review them. Releasing all holds of an invoice does not submit Invoice Validation - the invoice status is derived by Oracle and updates automatically, exactly as after releasing holds in the form. Enginatics R12 only Upload 1=1 1 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C,U Y US Upload Mode 2 20 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 coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit 3 30 1=1 aps.vendor_name=:supplier LOV custom Y select distinct aps.vendor_name value, aps.segment1 description from ap_holds_all aha, ap_invoices_all aia, ap_suppliers aps where aha.release_lookup_code is null and aha.invoice_id=aia.invoice_id and aia.vendor_id=aps.vendor_id and aia.org_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) and (:$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')) order by 1 US Supplier 4 40 1=1 aia.invoice_num=:invoice_number LOV custom Y Y select distinct aia.invoice_num value, aps.vendor_name description from ap_holds_all aha, ap_invoices_all aia, ap_suppliers aps where aha.release_lookup_code is null and aha.invoice_id=aia.invoice_id and aia.vendor_id=aps.vendor_id(+) and aia.org_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) and (:$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$.supplier is null or aia.vendor_id in (select aps2.vendor_id from ap_suppliers aps2 where xxen_util.contains(:$flex$.supplier,aps2.vendor_name)='Y')) order by 1 US Invoice Number 5 50 1=1 aia.invoice_date>=:invoice_date_from Date US Invoice Date From 6 60 1=1 aia.invoice_date<:invoice_date_to+1 Date last_day(:$flex$.invoice_date_from) US Invoice Date To 7 70 1=1 alc.displayed_field=:hold_name LOV custom Y select distinct alc.displayed_field value, ahc.description from ap_holds_all aha, ap_invoices_all aia, ap_hold_codes ahc, ap_lookup_codes alc where aha.release_lookup_code is null and aha.invoice_id=aia.invoice_id and aia.org_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) and (:$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 aha.hold_lookup_code=ahc.hold_lookup_code and alc.lookup_type='HOLD CODE' and alc.lookup_code=ahc.hold_lookup_code order by 1 US Hold Name 8 80 1=1 aha.hold_date>=:hold_date_from Date US Hold Date From 9 90 1=1 aha.hold_date<:hold_date_to+1 Date last_day(:$flex$.hold_date_from) US Hold Date To 10 100 1=1 aha.held_by=:held_by LOV custom Y select distinct aha.held_by id, decode(aha.held_by,5,(select alc_sys.displayed_field from ap_lookup_codes alc_sys where alc_sys.lookup_type='NLS TRANSLATION' and alc_sys.lookup_code='SYSTEM'),xxen_util.user_name(aha.held_by)) value, null description from ap_holds_all aha, ap_invoices_all aia where aha.release_lookup_code is null and aha.invoice_id=aia.invoice_id and aia.org_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) and (:$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')) order by 2 US Held By 11 110 1=1 pha.segment1=:po_number LOV custom Y Y select distinct pha.segment1 value, aps.vendor_name description from ap_holds_all aha, ap_invoices_all aia, ap_suppliers aps, po_line_locations_all plla, po_headers_all pha where aha.release_lookup_code is null and aha.invoice_id=aia.invoice_id and aia.vendor_id=aps.vendor_id(+) and aia.org_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) and (:$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$.supplier is null or aia.vendor_id in (select aps2.vendor_id from ap_suppliers aps2 where xxen_util.contains(:$flex$.supplier,aps2.vendor_name)='Y')) and aha.line_location_id=plla.line_location_id and plla.po_header_id=pha.po_header_id order by 1 US PO Number 12 120 1=1 ahc.user_releaseable_flag='Y' 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 Y US User Releasable Only 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 OPERATING_UNIT LOV varchar2 240 HR Operating Unit for Upload F263DDA3FBF60F8FE0530100007F75CD Y select hou.organization_id id, hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.operating_unit is null or hou.name=:$flex$.operating_unit) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name :$flex$.operating_unit Y Y 6 SUPPLIER Char varchar2 240 select aps.vendor_name from ap_invoices_all aia, ap_suppliers aps, hr_all_organization_units_vl haouv where aia.invoice_num=:$column$.invoice_number and aia.org_id=haouv.organization_id and haouv.name=:$column$.operating_unit and aia.vendor_id=aps.vendor_id Y 7 SUPPLIER_NUMBER Char varchar2 30 select aps.segment1 from ap_invoices_all aia, ap_suppliers aps, hr_all_organization_units_vl haouv where aia.invoice_num=:$column$.invoice_number and aia.org_id=haouv.organization_id and haouv.name=:$column$.operating_unit and aia.vendor_id=aps.vendor_id Y 8 SUPPLIER_SITE Char varchar2 15 select assa.vendor_site_code from ap_invoices_all aia, ap_supplier_sites_all assa, hr_all_organization_units_vl haouv where aia.invoice_num=:$column$.invoice_number and aia.org_id=haouv.organization_id and haouv.name=:$column$.operating_unit and aia.vendor_site_id=assa.vendor_site_id Y 9 INVOICE_NUMBER Char varchar2 50 Y Y 10 INVOICE_DATE Date date select aia.invoice_date from ap_invoices_all aia, hr_all_organization_units_vl haouv where aia.invoice_num=:$column$.invoice_number and aia.org_id=haouv.organization_id and haouv.name=:$column$.operating_unit Y 11 INVOICE_AMOUNT Number number select aia.invoice_amount from ap_invoices_all aia, hr_all_organization_units_vl haouv where aia.invoice_num=:$column$.invoice_number and aia.org_id=haouv.organization_id and haouv.name=:$column$.operating_unit Y 12 CURRENCY Char varchar2 15 select aia.invoice_currency_code from ap_invoices_all aia, hr_all_organization_units_vl haouv where aia.invoice_num=:$column$.invoice_number and aia.org_id=haouv.organization_id and haouv.name=:$column$.operating_unit Y 13 HOLD_NAME LOV custom varchar2 80 Y select x.id, x.value, x.description from ( select alc.lookup_code id, alc.displayed_field value, ahc.description from ap_holds_all aha, ap_invoices_all aia, hr_all_organization_units_vl haouv, ap_hold_codes ahc, ap_lookup_codes alc where aha.release_lookup_code is null and aha.invoice_id=aia.invoice_id and aia.invoice_num=:$column$.invoice_number and aia.org_id=haouv.organization_id and haouv.name=:$column$.operating_unit and aha.hold_lookup_code=ahc.hold_lookup_code and alc.lookup_type='HOLD CODE' and alc.lookup_code=ahc.hold_lookup_code union select alc.lookup_code, alc.displayed_field, ahc.description from ap_hold_codes ahc, ap_lookup_codes alc where ahc.hold_type in ('INVOICE HOLD REASON','VARIANCE HOLD REASON','MATCHING HOLD REASON','INSUFFICIENT FUNDS') and ahc.user_releaseable_flag='Y' and nvl(ahc.inactive_date,sysdate+1)>sysdate and alc.lookup_type='HOLD CODE' and alc.lookup_code=ahc.hold_lookup_code and not exists ( select null from ap_holds_all aha, ap_invoices_all aia, hr_all_organization_units_vl haouv where aha.release_lookup_code is null and aha.invoice_id=aia.invoice_id and aia.invoice_num=:$column$.invoice_number and aia.org_id=haouv.organization_id and haouv.name=:$column$.operating_unit and aha.hold_lookup_code=ahc.hold_lookup_code ) ) x order by x.value Y 14 HOLD_REASON Char varchar2 240 Hold reason for placing a new manual hold. Defaults to the hold code description when left blank. 15 HOLD_DATE Date date select aha.hold_date from ap_holds_all aha, ap_invoices_all aia, hr_all_organization_units_vl haouv, ap_lookup_codes alc where aha.release_lookup_code is null and aha.invoice_id=aia.invoice_id and aia.invoice_num=:$column$.invoice_number and aia.org_id=haouv.organization_id and haouv.name=:$column$.operating_unit and alc.lookup_type='HOLD CODE' and alc.lookup_code=aha.hold_lookup_code and alc.displayed_field=:$column$.hold_name Y 16 HELD_BY Char varchar2 240 select decode(aha.held_by,5,(select alc_sys.displayed_field from ap_lookup_codes alc_sys where alc_sys.lookup_type='NLS TRANSLATION' and alc_sys.lookup_code='SYSTEM'),xxen_util.user_name(aha.held_by)) from ap_holds_all aha, ap_invoices_all aia, hr_all_organization_units_vl haouv, ap_lookup_codes alc where aha.release_lookup_code is null and aha.invoice_id=aia.invoice_id and aia.invoice_num=:$column$.invoice_number and aia.org_id=haouv.organization_id and haouv.name=:$column$.operating_unit and alc.lookup_type='HOLD CODE' and alc.lookup_code=aha.hold_lookup_code and alc.displayed_field=:$column$.hold_name Y 17 PO_NUMBER Char varchar2 20 select pha.segment1 from ap_holds_all aha, ap_invoices_all aia, hr_all_organization_units_vl haouv, ap_lookup_codes alc, po_line_locations_all plla, po_headers_all pha where aha.release_lookup_code is null and aha.invoice_id=aia.invoice_id and aia.invoice_num=:$column$.invoice_number and aia.org_id=haouv.organization_id and haouv.name=:$column$.operating_unit and alc.lookup_type='HOLD CODE' and alc.lookup_code=aha.hold_lookup_code and alc.displayed_field=:$column$.hold_name and aha.line_location_id=plla.line_location_id and plla.po_header_id=pha.po_header_id Identifies the exact matching hold when an invoice has several open holds of the same name on different purchase order shipments. Y 18 PO_LINE Number number select pola.line_num from ap_holds_all aha, ap_invoices_all aia, hr_all_organization_units_vl haouv, ap_lookup_codes alc, po_line_locations_all plla, po_lines_all pola where aha.release_lookup_code is null and aha.invoice_id=aia.invoice_id and aia.invoice_num=:$column$.invoice_number and aia.org_id=haouv.organization_id and haouv.name=:$column$.operating_unit and alc.lookup_type='HOLD CODE' and alc.lookup_code=aha.hold_lookup_code and alc.displayed_field=:$column$.hold_name and aha.line_location_id=plla.line_location_id and plla.po_line_id=pola.po_line_id Y 19 PO_SHIPMENT Number number select plla.shipment_num from ap_holds_all aha, ap_invoices_all aia, hr_all_organization_units_vl haouv, ap_lookup_codes alc, po_line_locations_all plla where aha.release_lookup_code is null and aha.invoice_id=aia.invoice_id and aia.invoice_num=:$column$.invoice_number and aia.org_id=haouv.organization_id and haouv.name=:$column$.operating_unit and alc.lookup_type='HOLD CODE' and alc.lookup_code=aha.hold_lookup_code and alc.displayed_field=:$column$.hold_name and aha.line_location_id=plla.line_location_id Y 20 INVOICE_LINE Number number select aha.line_number from ap_holds_all aha, ap_invoices_all aia, hr_all_organization_units_vl haouv, ap_lookup_codes alc where aha.release_lookup_code is null and aha.invoice_id=aia.invoice_id and aia.invoice_num=:$column$.invoice_number and aia.org_id=haouv.organization_id and haouv.name=:$column$.operating_unit and alc.lookup_type='HOLD CODE' and alc.lookup_code=aha.hold_lookup_code and alc.displayed_field=:$column$.hold_name and aha.line_number is not null Identifies the exact line hold when an invoice has several open holds of the same name on different invoice lines. Y 21 HOLD_DETAILS Char varchar2 2000 select aha.hold_details from ap_holds_all aha, ap_invoices_all aia, hr_all_organization_units_vl haouv, ap_lookup_codes alc where aha.release_lookup_code is null and aha.invoice_id=aia.invoice_id and aia.invoice_num=:$column$.invoice_number and aia.org_id=haouv.organization_id and haouv.name=:$column$.operating_unit and alc.lookup_type='HOLD CODE' and alc.lookup_code=aha.hold_lookup_code and alc.displayed_field=:$column$.hold_name and aha.hold_details is not null Y 22 RELEASE_NAME LOV custom varchar2 80 Y select alc.lookup_code id, alc.displayed_field value, ahc.description from ap_hold_codes ahc, ap_lookup_codes alc where ahc.hold_type= case when :$column$.po_number is not null then 'MATCHING RELEASE REASON' when exists ( select null from ap_holds_all aha, ap_invoices_all aia, hr_all_organization_units_vl haouv, ap_lookup_codes alc_h where aha.release_lookup_code is null and aha.line_location_id is not null and aha.invoice_id=aia.invoice_id and aia.invoice_num=:$column$.invoice_number and aia.org_id=haouv.organization_id and haouv.name=:$column$.operating_unit and alc_h.lookup_type='HOLD CODE' and alc_h.lookup_code=aha.hold_lookup_code and alc_h.displayed_field=:$column$.hold_name ) then 'MATCHING RELEASE REASON' when :$column$.hold_name=(select alc_tv.displayed_field from ap_lookup_codes alc_tv where alc_tv.lookup_type='HOLD CODE' and alc_tv.lookup_code='TAX VARIANCE') then 'VARIANCE RELEASE REASON' else 'INVOICE RELEASE REASON' end and ahc.hold_lookup_code not in ('MATCHED','VARIANCE CORRECTED','Automatic Release') and nvl(ahc.inactive_date,sysdate+1)>sysdate and alc.lookup_type='HOLD CODE' and alc.lookup_code=ahc.hold_lookup_code order by alc.displayed_field Pick a release name to release the hold. Leave blank on rows placing a new hold. 23 RELEASE_REASON Char varchar2 240 select alc.description from ap_lookup_codes alc where alc.lookup_type='HOLD CODE' and alc.displayed_field=:$column$.release_name Defaults to the release name description and can be overwritten. 24 HOLD_ID Number number Y 25 UPLOAD_ROW Char varchar2 Y U 10 status_ out Char STATUS_CODE_ U 20 message_ out Char MESSAGE_ U 30 p_hold_id in Number HOLD_ID U 40 p_operating_unit in Char OPERATING_UNIT value U 50 p_supplier in Char SUPPLIER U 60 p_supplier_number in Char SUPPLIER_NUMBER U 70 p_invoice_number in Char INVOICE_NUMBER U 80 p_hold_lookup_code in Char HOLD_NAME U 90 p_hold_reason in Char HOLD_REASON U 100 p_po_number in Char PO_NUMBER U 110 p_po_line in Number PO_LINE U 120 p_po_shipment in Number PO_SHIPMENT U 130 p_invoice_line in Number INVOICE_LINE U 140 p_release_lookup_code in Char RELEASE_NAME U 150 p_release_reason in Char RELEASE_REASON U 160 p_hold_id_out out Number HOLD_ID Error SQL Order By upload_row, operating_unit, supplier, invoice_number, hold_name Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, nvl(haouv.name,xu.operating_unit) operating_unit, nvl(aps.vendor_name,xu.supplier) supplier, nvl(aps.segment1,xu.supplier_number) supplier_number, nvl(assa.vendor_site_code,xu.supplier_site) supplier_site, nvl(aia.invoice_num,xu.invoice_number) invoice_number, nvl(aia.invoice_date,xu.invoice_date) invoice_date, nvl(aia.invoice_amount,xu.invoice_amount) invoice_amount, nvl(aia.invoice_currency_code,xu.currency) currency, nvl(alc.displayed_field,xu.hold_name) hold_name, nvl(aha.hold_reason,xu.hold_reason) hold_reason, nvl(aha.hold_date,xu.hold_date) hold_date, nvl(decode(aha.held_by,5,(select alc_sys.displayed_field from ap_lookup_codes alc_sys where alc_sys.lookup_type='NLS TRANSLATION' and alc_sys.lookup_code='SYSTEM'),xxen_util.user_name(aha.held_by)),xu.held_by) held_by, nvl(pha.segment1,xu.po_number) po_number, nvl(pola.line_num,xu.po_line) po_line, nvl(plla.shipment_num,xu.po_shipment) po_shipment, nvl(aha.line_number,xu.invoice_line) invoice_line, nvl(aha.hold_details,xu.hold_details) hold_details, nvl((select alc_r.displayed_field from ap_lookup_codes alc_r where alc_r.lookup_type='HOLD CODE' and alc_r.lookup_code=aha.release_lookup_code),xu.release_name) release_name, nvl(aha.release_reason,xu.release_reason) release_reason, xu.hold_id, xu.upload_row from xxen_ap_invoice_hold_up_6138_u xu, ap_holds_all aha, ap_invoices_all aia, ap_suppliers aps, ap_supplier_sites_all assa, hr_all_organization_units_vl haouv, ap_lookup_codes alc, po_line_locations_all plla, po_lines_all pola, po_headers_all pha where xu.status_code_=xxen_upload.status_success and xu.hold_id=aha.hold_id(+) and aha.invoice_id=aia.invoice_id(+) and aia.org_id=haouv.organization_id(+) and aia.vendor_id=aps.vendor_id(+) and aia.vendor_site_id=assa.vendor_site_id(+) and alc.lookup_type(+)='HOLD CODE' and alc.lookup_code(+)=aha.hold_lookup_code and aha.line_location_id=plla.line_location_id(+) and plla.po_line_id=pola.po_line_id(+) and plla.po_header_id=pha.po_header_id(+)