ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 53B31EFFC6B85470E0630100007F501D Blitz Report DFF Display Y select 'V' id, 'Value' value, 'Value only' description from dual union all select 'C' id, 'Value: Description' value, 'Concatenated value and description' description from dual union all select 'S' id, 'Value, Description' value, 'Value and description in separate columns' description from dual US 4E0AA6DEEFCB48B0E0630100007FB13D select wnd.delivery_id, wnd.initial_pickup_date ship_date, nvl(wnd.currency_code,wdd.currency_code) currency_code, ( select wcs.ship_method_meaning from wsh_carrier_services wcs where wcs.ship_method_code=wnd.ship_method_code ) ship_method, wnd.gross_weight, wnd.weight_uom_code, ( select count(*) from wsh_delivery_assignments_v wda0, wsh_delivery_details wdd0 where wdd0.delivery_detail_id=wda0.delivery_detail_id and wdd0.container_flag='Y' and wda0.parent_delivery_detail_id is null and wda0.delivery_id is not null and wda0.delivery_id=wnd.delivery_id ) number_of_boxes, wnd.port_of_loading, wnd.port_of_discharge, wnd.waybill, ( select listagg(wbrdv.bill_of_lading_number,', ') within group (order by wbrdv.bill_of_lading_number) from wsh_bols_rd_v wbrdv where wbrdv.delivery_id=wnd.delivery_id ) bill_of_lading, terr_from.territory_short_name from_country, loc.address1 from_address1, loc.address2 from_address2, loc.address3 from_address3, loc.address4 from_address4, loc.city||', '||nvl(nvl(loc.state,loc.province),loc.county)||' '||loc.postal_code from_city_state, case when nvl(wdd.consignee_flag,'C')='V' then ( select hp.party_name from hz_party_site_uses hpsu, hz_party_sites hps, hz_parties hp where hpsu.party_site_use_id=wdd.ship_to_site_use_id and hpsu.site_use_type='PURCHASING' and hps.party_site_id=hpsu.party_site_id and hp.party_id=hps.party_id ) else ( select hp.party_name from hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa, hz_party_sites hps, hz_parties hp where hcsua.site_use_id=wdd.ship_to_site_use_id and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id and hcasa.party_site_id=hps.party_site_id and hp.party_id=hps.party_id ) end ship_to_customer, terr_to.territory_short_name to_country, loc1.address1 to_address1, loc1.address2 to_address2, loc1.address3 to_address3, loc1.address4 to_address4, loc1.city||', '||nvl(nvl(loc1.province,loc1.state),loc1.county)||' '||loc1.postal_code to_city_state, ( select hp.party_name from hz_cust_account_roles hcar, hz_relationships hr, hz_parties hp where hcar.cust_account_role_id=wdd.ship_to_contact_id and hcar.party_id=hr.party_id and hcar.role_type='CONTACT' and hr.subject_table_name='HZ_PARTIES' and hr.object_table_name='HZ_PARTIES' and hr.directional_flag='F' and hr.subject_id=hp.party_id ) ship_to_contact, wdd.cust_po_number, decode(wms_deploy.wms_deployment_mode,'D',wdd.source_header_number,nvl(wdd.reference_number,wdd.source_header_number)) order_number, mc.description category, coalesce( ( select msiv.description from mtl_system_items_vl msiv where msiv.inventory_item_id=wdd.inventory_item_id and msiv.organization_id=wdd.organization_id ), wdd.item_description ) item_description, ( select msiv.concatenated_segments from mtl_system_items_vl msiv where msiv.inventory_item_id=wdd.inventory_item_id and msiv.organization_id=wdd.organization_id ) item, ( select listagg(mck.concatenated_segments,', ') within group (order by mck.category_id) from mtl_categories_kfv mck, mtl_item_categories mic0, mtl_category_sets_vl mcsv where mic0.inventory_item_id=wdd.inventory_item_id and mic0.organization_id=wdd.organization_id and mic0.category_set_id=mcsv.category_set_id and mck.category_id=mic0.category_id and mcsv.category_set_name='WSH_COMMODITY_CODE' ) commodity_class, sum(nvl(wdd.shipped_quantity,wdd.requested_quantity)) shipped_quantity, wdd.requested_quantity_uom unit_of_measure, wdd.requested_quantity2 secondary_quantity, wdd.requested_quantity_uom2 secondary_uom, round( case wdd.source_code when 'OE' then (select oola.unit_selling_price from oe_order_lines_all oola where oola.line_id=wdd.source_line_id) when 'OKE' then (select okdb.unit_price from oke_k_deliverables_b okdb where okdb.deliverable_id=wdd.source_line_id) else (select wdd2.unit_price from wsh_delivery_details wdd2 where wdd2.source_line_id=wdd.source_line_id and wdd2.source_code=wdd.source_code and rownum=1) end *wsh_wv_utils.convert_uom(wdd.requested_quantity_uom,wdd.src_requested_quantity_uom,1,wdd.inventory_item_id) ,2) unit_cost, round( sum( case wdd.source_code when 'OE' then (select oola.unit_selling_price from oe_order_lines_all oola where oola.line_id=wdd.source_line_id) when 'OKE' then (select okdb.unit_price from oke_k_deliverables_b okdb where okdb.deliverable_id=wdd.source_line_id) else (select wdd2.unit_price from wsh_delivery_details wdd2 where wdd2.source_line_id=wdd.source_line_id and wdd2.source_code=wdd.source_code and rownum=1) end *wsh_wv_utils.convert_uom(wdd.requested_quantity_uom,wdd.src_requested_quantity_uom,nvl(wdd.shipped_quantity,wdd.requested_quantity),wdd.inventory_item_id) ) ,2) extended_cost, ( select sum(wfc.unit_amount) from wsh_freight_costs wfc, wsh_freight_cost_types wfct where wfc.freight_cost_type_id=wfct.freight_cost_type_id and wfc.delivery_detail_id is null and (wfct.name='SUMMARY' and wfct.freight_cost_type_code='FTESUMMARY' or wfc.charge_source_code<>'PRICING_ENGINE') and wfc.delivery_id=wnd.delivery_id ) total_freight_cost, wdd.delivery_detail_id, wdd.source_code, wdd.source_line_id, wdd.source_header_id, ood.organization_name warehouse &dff_columns from wsh_new_deliveries wnd, wsh_delivery_assignments_v wda, wsh_delivery_details wdd, wsh_locations loc, wsh_locations loc1, mtl_categories mc, mtl_item_categories mic, mtl_default_category_sets mdc, fnd_territories_tl terr_from, fnd_territories_tl terr_to, org_organization_definitions ood where 1=1 and wnd.delivery_id=wda.delivery_id and nvl(wnd.shipment_direction,'O') in ('O','IO') and wnd.delivery_type='STANDARD' and (wdd.requested_quantity>0 or wdd.released_status<>'D') and wdd.container_flag in ('N','Y') and wdd.delivery_detail_id=wda.delivery_detail_id and wda.delivery_id is not null and wdd.ship_from_location_id=loc.wsh_location_id and wdd.ship_to_location_id=loc1.wsh_location_id and wdd.organization_id=mic.organization_id and wdd.inventory_item_id=mic.inventory_item_id and loc.country=terr_from.territory_code(+) and loc1.country=terr_to.territory_code(+) and decode(loc.country,null,userenv('lang'),terr_from.language)=userenv('lang') and decode(loc1.country,null,userenv('lang'),terr_to.language)=userenv('lang') and mic.category_id=mc.category_id and mic.category_set_id=mdc.category_set_id and mdc.functional_area_id=7 and exists ( select null from bom_inventory_components bic where bic.include_on_ship_docs=1 and bic.component_sequence_id=(select oola.component_sequence_id from oe_order_lines_all oola where oola.line_id=wdd.source_line_id) union select null from dual where wdd.top_model_line_id is null union select null from dual where wdd.top_model_line_id is not null and wdd.ato_line_id is not null union select null from dual where wdd.top_model_line_id=wdd.source_line_id ) and wdd.organization_id=ood.organization_id(+) group by wnd.delivery_id, wnd.initial_pickup_date, nvl(wnd.currency_code,wdd.currency_code), wnd.ship_method_code, wnd.gross_weight, wnd.weight_uom_code, wnd.port_of_loading, wnd.port_of_discharge, wnd.waybill, terr_from.territory_short_name, loc.address1, loc.address2, loc.address3, loc.address4, loc.city||', '||nvl(nvl(loc.state,loc.province),loc.county)||' '||loc.postal_code, wdd.consignee_flag, wdd.ship_to_site_use_id, terr_to.territory_short_name, loc1.address1, loc1.address2, loc1.address3, loc1.address4, loc1.city||', '||nvl(nvl(loc1.province,loc1.state),loc1.county)||' '||loc1.postal_code, wdd.ship_to_contact_id, wdd.cust_po_number, decode(wms_deploy.wms_deployment_mode,'D',wdd.source_header_number,nvl(wdd.reference_number,wdd.source_header_number)), mc.description, wdd.inventory_item_id, wdd.organization_id, wdd.item_description, wdd.customer_item_id, wdd.requested_quantity_uom, wdd.src_requested_quantity_uom, wdd.requested_quantity2, wdd.requested_quantity_uom2, wdd.source_code, wdd.source_line_id, wdd.source_header_id, wdd.delivery_detail_id, &dff_columns_grp ood.organization_name order by wnd.delivery_id, mc.description Replace data template SQL with flattened query. Inline WSH_WSHRDINV_XMLP_PKG formula functions as scalar subqueries. Y :Warehouse is not null AR WSH الفاتورة التجارية (بتنسيق XML) Imported from BI Publisher Description: الفاتورة التجارية Application: تنفيذ الشحن Source: الفاتورة التجارية (بتنسيق XML) Short Name: WSHRDINV_XML DB package: WSH_WSHRDINV_XMLP_PKG D WSH Rechnung Imported from BI Publisher Description: Rechnung Application: Shipping Execution Source: Rechnung (XML) Short Name: WSHRDINV_XML DB package: WSH_WSHRDINV_XMLP_PKG E WSH Informe Factura Comercial Imported from BI Publisher Description: Factura Comercial Application: Shipping Execution Source: Informe Factura Comercial (XML) Short Name: WSHRDINV_XML DB package: WSH_WSHRDINV_XMLP_PKG F WSH Facture commerciale Imported from BI Publisher Description: Facture commerciale Application: Shipping Execution Source: Facture commerciale (XML) Short Name: WSHRDINV_XML DB package: WSH_WSHRDINV_XMLP_PKG I WSH Fattura commerciale Imported from BI Publisher Description: Fattura commerciale Application: Shipping Execution Source: Fattura commerciale (XML) Short Name: WSHRDINV_XML DB package: WSH_WSHRDINV_XMLP_PKG JA WSH インボイス Imported from BI Publisher Description: インボイス Application: Shipping Execution Source: インボイス(XML) Short Name: WSHRDINV_XML DB package: WSH_WSHRDINV_XMLP_PKG KO WSH 상업 송장 Imported from BI Publisher Description: 상업송장 Application: Shipping Execution Source: 상업 송장(XML) Short Name: WSHRDINV_XML DB package: WSH_WSHRDINV_XMLP_PKG PTB WSH NFF Comercial Imported from BI Publisher Description: NFF Comercial Application: Execução da Entrega Source: NFF Comercial (XML) Short Name: WSHRDINV_XML DB package: WSH_WSHRDINV_XMLP_PKG RU WSH Торговый счет-фактура Imported from BI Publisher Description: Торговый счет-фактура Application: Выполнение отгрузки Source: Торговый счет-фактура (XML) Short Name: WSHRDINV_XML DB package: WSH_WSHRDINV_XMLP_PKG S WSH Faktura Imported from BI Publisher Description: Faktura Application: Shipping Execution Source: Faktura (XML) Short Name: WSHRDINV_XML DB package: WSH_WSHRDINV_XMLP_PKG TR WSH Ticari Fatura Imported from BI Publisher Description: Ticari Fatura Application: Sevkiyat Yönetimi Source: Ticari Fatura (XML) Short Name: WSHRDINV_XML DB package: WSH_WSHRDINV_XMLP_PKG US WSH Commercial Invoice Shipping commercial invoice report showing delivery details including shipped items, quantities, unit costs, extended costs, ship-from/ship-to addresses, freight information, and bill of lading details. Blitz version of the Oracle standard Commercial Invoice (XML) concurrent program WSHRDINV_XML. DB package: WSH_WSHRDINV_XMLP_PKG Please specify a value for the Warehouse parameter ZHS WSH 商业发票 Imported from BI Publisher Description: 商业发票 Application: 发运管理系统 Source: 商业发票 (XML) Short Name: WSHRDINV_XML DB package: WSH_WSHRDINV_XMLP_PKG Enginatics &dff_columns &dff_columns_grp 1=1 1 -20 :p_item_flex_code Char fnd_profile.value('OE_ID_FLEX_CODE') Y AR الرمز المرن للصنف الرمز المرن للصنف D Artikel-FlexFeld-Schlüssel Artikel-FlexFeld-Schlüssel E Código de Estructura de Artículo Código de Estructura de Artículo F Code clé article Code clé article I Codice flexfield Articolo Codice flexfield Articolo JA 品目フレックス・コード 品目フレックス・コード KO 품목 가변 코드 품목 가변 코드 PTB Código Flex. do Item Código Flex. do Item RU Код ГП позиции Код ГП позиции S Artikelflexkod Artikelflexkod TR Kalem Esnek Kodu Kalem Esnek Kodu US Item Flex Code Item Flex Code ZHS 项目弹性域代码 项目弹性域代码 2 -10 :debugflag Char N US DebugFlag Debug Flag 3 10 1=1 wnd.delivery_id in (select wdl.delivery_id from wsh_delivery_legs wdl where wdl.pick_up_stop_id=:trip_stop_id or wdl.drop_off_stop_id=:trip_stop_id) LOV Oracle WSH_SRS_TRIP_STOPS Y select stop_id id, substr(stop_description,1,999) value, location_description description from wsh_srs_trip_stops_v order by stop_description AR محطة الرحلة محطة الرحلة D Tourenstopp Tourenstopp E Parada de Viaje Parada de Viaje F Etape du trajet Etape du trajet I Fermata viaggio Fermata viaggio JA トリップ/ストップ トリップ/ストップ KO 경유지 경유지 PTB Parada do Percurso Parada do Percurso RU Остановка Остановка S Turstopp Turstopp TR Güzergah Durağı Güzergah Durağı US Trip Stop ZHS 行程停靠站 行程停靠站 4 20 1=1 wnd.delivery_id in (select wdl.delivery_id from wsh_delivery_legs wdl where wdl.pick_up_stop_id in (select wts.stop_id from wsh_trip_stops wts where wts.planned_departure_date>=:departure_date_from)) Date AR إيقاف تاريخ المغادرة المخطط (من) تاريخ المغادرة (من) D Geplantes Abfahrtsdatum Stopp (Von) Von Abfahrtsdatum E Fecha de Partida Planificada de la Parada (De) Fecha de Salida (De) F Date de départ planifiée de l'étape - De Date de départ (De) I Interrompi data di partenza pianificata (min) Data partenza (minimo) JA ストップ予定出発日 (自) 出発日 (自) KO 경유지 계획 발송 일자(하한) 발송 일자 (하한) PTB Data de Partida Planejada da Parada (Inferior) Data de Partida (Inferior) RU Дата плановой отправки для остановки с Дата отправки с S Avbryt planerat sändningsdatum (från) Sändningsdatum (från) TR Durak Planlı Çıkış Tarihi (Alt Değer) Çıkış Tarihi (Alt Değer) US Stop Planned Depart Date (Low) ZHS 停靠站计划启运日期（下限） 启运日期（下限） 5 30 1=1 wnd.delivery_id in (select wdl.delivery_id from wsh_delivery_legs wdl where wdl.pick_up_stop_id in (select wts.stop_id from wsh_trip_stops wts where wts.planned_departure_date<:departure_date_to+1)) Date last_day(:$flex$.stop_planned_depart_date_low) AR إيقاف تاريخ المغادرة المخطط (إلى) تاريخ المغادرة (إلى) D Geplantes Abfahrtsdatum Stopp (Bis) Bis Abfahrtsdatum E Fecha de Partida Planificada de la Parada (A) Fecha de Salida (A) F Date de départ planifiée de l'étape - A Date de départ (Au) I Interrompi data di partenza pianificata (max) Data partenza (massimo) JA ストップ予定出発日 (至) 出発日 (至) KO 경유지 계획 발송 일자(상한) 발송 일자 (상한) PTB Data de Partida Planejada da Parada (Superior) Data de Partida (Superior) RU Дата плановой отправки для остановки по Дата отправки по S Avbryt planerat sändningsdatum (till) Sändningsdatum (till) TR Durak Planlı Çıkış Tarihi (Üst Değer) Çıkış Tarihi (Üst Değer) US Stop Planned Depart Date (High) ZHS 停靠站计划启运日期（上限） 启运日期（上限） 6 40 1=1 wnd.ship_method_code=:freight_carrier LOV Oracle WSH_SRS_FREIGHT_CARRIER Y Y select lookup_code id, meaning value, description description from fnd_lookup_values_vl where view_application_id=3 and lookup_type='SHIP_METHOD' and exists (select 1 from wsh_carrier_services wcs,wsh_carriers wc where wcs.ship_method_code=lookup_code and wcs.carrier_id=wc.carrier_id and nvl(wc.generic_flag,'N')='N') order by lookup_code AR ناقلة الشحن ناقلة الشحن D Transporteur Transporteur E Transportista Transportista F Transporteur Transporteur I Vettore Vettore JA 運送業者 運送業者 KO 운송 회사 운송 회사 PTB Transportadora Transportadora RU Перевозчик Перевозчик S Speditör Speditör TR Taşımacı Taşımacı US Freight Carrier ZHS 承运人 承运人 7 50 1=1 wdd.organization_id=:warehouse LOV Oracle WSH_SRS_ORGANIZATIONS Y select organization_id id, organization_code value, organization_name description from org_organization_definitions order by organization_code select organization_code from org_organization_definitions where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') Y AR المستودع المستودع D Lagerorganisation Lagerorganisation E Almacén Almacén F Entrepôt Entrepôt I Magazzino Magazzino JA 倉庫 倉庫 KO 창고 창고 PTB Depósito Depósito RU Склад Склад S Lager Lager TR Temin Yeri Temin Yeri US Warehouse ZHS 仓库 仓库 8 60 1=1 wnd.delivery_id=:delivery_name LOV Oracle WSH_SRS_DELIVERIES Y select delivery_id id, name value, null description from wsh_new_deliveries where organization_id=:$flex$.wsh_srs_organizations and nvl(shipment_direction,'O') in ('O','IO') and delivery_type='STANDARD' order by name AR اسم التسليم اسم التسليم D Auslieferungsbezeichnung Auslieferungsbezeichnung E Nombre de Entrega Nombre de Entrega F Code livraison Code livraison I Nome consegna Nome consegna JA 搬送名 搬送名 KO 납품명 납품명 PTB Nome da Distribuição Nome da Distribuição RU Имя доставки Имя доставки S Leveransnamn Leveransnamn TR Teslimat Adı Teslimat Adı US Delivery Name ZHS 交货名称 交货名称 9 70 1=1 nvl(wnd.currency_code,wdd.currency_code)=:currency_code LOV Oracle WSH_SRS_CURRENCY Y select currency_code id, currency_code value, name description from fnd_currencies_vl where currency_flag='Y' order by currency_code US Currency Code 10 71 :p_item_display LOV Oracle WSH_MGD_ITEM_DISPLAY Y select lookup_code id, meaning value, description description from wsh_lookups where lookup_type='ITEM_DISPLAY' and enabled_flag='Y' order by meaning select meaning from wsh_lookups where lookup_type = 'ITEM_DISPLAY' and lookup_code = 'D' Y AR عرض الصنف عرض الصنف D Artikelanzeige Artikelanzeige E Presentación del Artículo Presentación del Artículo F Affichage article Affichage article I Visualizzazione articolo Visualizzazione articolo JA 品目表示 品目表示 KO 품목 표시 품목 표시 PTB Exibição do Item Exibição do Item RU Вывод позиции Вывод позиции S Artikelvisning Artikelvisning TR Kalem Görüntüleme Kalem Görüntüleme US Item Display Item Display ZHS 物料显示 物料显示 11 80 &dff_columns select xxen_util.dff_columns(p_table_name=>'wsh_new_deliveries',p_table_alias=>'wnd',p_column_name_prefix=>'Delivery: ',p_display_mode=>:dff_display) from dual LOV Blitz Report DFF Display 53B31EFFC6B85470E0630100007F501D Y select 'V' id, 'Value' value, 'Value only' description from dual union all select 'C' id, 'Value: Description' value, 'Concatenated value and description' description from dual union all select 'S' id, 'Value, Description' value, 'Value and description in separate columns' description from dual fnd_profile.value('XXEN_REPORT_DFF_DISPLAY') AR رمز العملة رمز العملة D Währungsschlüssel Währungsschlüssel E Código de Divisa Código de Divisa F Code devise Code devise I Codice divisa Codice divisa JA 通貨コード 通貨コード KO 통화 코드 통화 코드 PTB Cód. da Moeda Cód. da Moeda RU Код валюты Код валюты S Valutakod Valutakod TR Para Birimi Kodu Para Birimi Kodu US DFF Display ZHS 币种代码 币种代码 12 &dff_columns_grp select xxen_util.dff_columns(p_table_name=>'wsh_new_deliveries',p_table_alias=>'wnd',p_hide_column_name=>'Y',p_display_mode=>:dff_display) from dual US DFF Display 13 90 :p_print_cust_item 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 select meaning from fnd_lookups where lookup_type='YES_NO' and lookup_code = 'N' AR طباعة صنف العميل طباعة معلومات صنف العميل D Kundenartikel drucken Kundenartikeldaten drucken E Imprimir Artículo del Cliente Imprimir Información sobre Artículo de Cliente F Imprimer article client Imprimer informations article client I Stampa articolo cliente Stampa le informazioni sull'articolo del cliente JA 顧客品目の印刷 顧客品目情報の印刷 KO 고객 품목 인쇄 고객 품목 정보 인쇄 PTB Imprimir Item do Cliente Imprimir Informações sobre o Item do Cliente RU Печать позиции заказчика Печать сведений о позиции заказчика S Skriv ut kundartikel Skriv ut kundartikelinformation TR Müşteri Envanter Kalemi Yadır Müşteri Envanter Kalemi Bilgisini Yazdırır. US Print Customer Item Print Customer Item Information ZHS 打印客户物料 打印客户项信息 :$flex$.stop_planned_depart_date_low Stop Planned Depart Date (Low) Y Stop Planned Depart Date (High) :$flex$.wsh_srs_organizations Warehouse Delivery Name