ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472B751A9E05362FB09050512Y select decode(:delivery_type,'STANDARD',wda.delivery_id, wda.parent_delivery_id) delivery_id2, --decode(:delivery_type,'STANDARD',wda.delivery_id, wda.parent_delivery_id) delivery_id, wdd.item_description unpacked_item_description, wdd.shipping_instructions unpacked_shipping_instr, wdd.hazard_class_id unpacked_item_hazard_class_id, nvl(sum(NVL (wdd.shipped_quantity, 0)),0) unpacked_item_shipped_quantity, wdd.requested_quantity_uom unpacked_item_quantity_uom, nvl(sum(NVL (wdd.shipped_quantity2, 0)),0) unpacked_item_shipped_qty2, wdd.requested_quantity_uom2 unpacked_item_quantity_uom2, nvl(sum(wdd.net_weight),0) unpacked_item_net_weight, wdd.weight_uom_code unpacked_item_weight_uom, nvl(sum(wdd.volume),0) unpacked_item_volume, wdd.volume_uom_code unpacked_item_volume_uom, wdd.classification unpacked_item_classification, wdd.cust_po_number customer_po_number, wdd.seal_code seal_code, wdd.organization_id unpacked_item_organization_id, wdd.inventory_item_id unpacked_item_inv_item_id, wdd.inventory_item_id ||wdd.shipping_instructions || wdd.hazard_class_id||wdd.requested_quantity_uom||wdd.requested_quantity_uom2||wdd.weight_uom_code||wdd.volume_uom_code||wdd.classification group_exp, WSH_WSHRDBOL_XMLP_PKG.cf_commodity_classformula(wdd.inventory_item_id, wdd.organization_id) CF_COMMODITY_CLASS, WSH_WSHRDBOL_XMLP_PKG.cf_unpacked_item_descformula(wdd.item_description, nvl ( sum ( NVL ( wdd.shipped_quantity , 0 ) ) , 0 ), wdd.requested_quantity_uom, wdd.organization_id, wdd.inventory_item_id, wdd.requested_quantity_uom2, nvl ( sum ( NVL ( wdd.shipped_quantity2 , 0 ) ) , 0 )) CF_UNPACKED_ITEM_DESC, WSH_WSHRDBOL_XMLP_PKG.cf_unpacked_item_wtformula(nvl ( sum ( wdd.net_weight ) , 0 ), wdd.weight_uom_code) CF_UNPACKED_ITEM_WT, WSH_WSHRDBOL_XMLP_PKG.cf_src_hdr_idformula() CF_SRC_HDR_ID, WSH_WSHRDBOL_XMLP_PKG.cf_unpacked_item_volformula(nvl ( sum ( wdd.volume ) , 0 ), wdd.volume_uom_code) CF_UNPACKED_ITEM_VOL, WSH_WSHRDBOL_XMLP_PKG.CP_TOP_MODEL_LINE_ID_p CP_TOP_MODEL_LINE_ID, WSH_WSHRDBOL_XMLP_PKG.CP_SRC_LINE_ID_p CP_SRC_LINE_ID from wsh_delivery_assignments wda, wsh_delivery_details wdd where wda.parent_delivery_detail_id is null and wda.delivery_detail_id is not null and wda.delivery_id is not null and wda.delivery_detail_id = wdd.delivery_detail_id and wdd.container_flag = 'N' and wdd.released_status !='B' and ( (:delivery_type ='STANDARD' and wda.parent_delivery_id is null) or (:delivery_type ='CONSOLIDATION' and wda.parent_delivery_id is not null)) AND EXISTS (select 'EXISTS' from bom_inventory_components bic where bic.component_item_id = wdd.inventory_item_id and bic.include_on_ship_docs = 1 --added for bug 6029900 and bic.component_sequence_id = ( select component_sequence_id from oe_order_lines_all where line_id = wdd.source_line_id) and wdd.top_model_line_id is not null UNION select 'EXISTS'/*, WSH_WSHRDBOL_XMLP_PKG.cf_commodity_classformula(wdd.inventory_item_id, wdd.organization_id) CF_COMMODITY_CLASS, WSH_WSHRDBOL_XMLP_PKG.cf_unpacked_item_descformula(wdd.item_description, nvl ( sum ( NVL ( wdd.shipped_quantity , 0 ) ) , 0 ), wdd.requested_quantity_uom, wdd.organization_id, wdd.inventory_item_id, wdd.requested_quantity_uom2, nvl ( sum ( NVL ( wdd.shipped_quantity2 , 0 ) ) , 0 )) CF_UNPACKED_ITEM_DESC, WSH_WSHRDBOL_XMLP_PKG.cf_unpacked_item_wtformula(nvl ( sum ( wdd.net_weight ) , 0 ), wdd.weight_uom_code) CF_UNPACKED_ITEM_WT, WSH_WSHRDBOL_XMLP_PKG.cf_src_hdr_idformula() CF_SRC_HDR_ID, WSH_WSHRDBOL_XMLP_PKG.cf_unpacked_item_volformula(nvl ( sum ( wdd.volume ) , 0 ), wdd.volume_uom_code) CF_UNPACKED_ITEM_VOL, WSH_WSHRDBOL_XMLP_PKG.CP_TOP_MODEL_LINE_ID_p CP_TOP_MODEL_LINE_ID, WSH_WSHRDBOL_XMLP_PKG.CP_SRC_LINE_ID_p CP_SRC_LINE_ID*/ from dual where wdd.top_model_line_id is null UNION select 'EXISTS'/*, WSH_WSHRDBOL_XMLP_PKG.cf_commodity_classformula(wdd.inventory_item_id, wdd.organization_id) CF_COMMODITY_CLASS, WSH_WSHRDBOL_XMLP_PKG.cf_unpacked_item_descformula(wdd.item_description, nvl ( sum ( NVL ( wdd.shipped_quantity , 0 ) ) , 0 ), wdd.requested_quantity_uom, wdd.organization_id, wdd.inventory_item_id, wdd.requested_quantity_uom2, nvl ( sum ( NVL ( wdd.shipped_quantity2 , 0 ) ) , 0 )) CF_UNPACKED_ITEM_DESC, WSH_WSHRDBOL_XMLP_PKG.cf_unpacked_item_wtformula(nvl ( sum ( wdd.net_weight ) , 0 ), wdd.weight_uom_code) CF_UNPACKED_ITEM_WT, WSH_WSHRDBOL_XMLP_PKG.cf_src_hdr_idformula() CF_SRC_HDR_ID, WSH_WSHRDBOL_XMLP_PKG.cf_unpacked_item_volformula(nvl ( sum ( wdd.volume ) , 0 ), wdd.volume_uom_code) CF_UNPACKED_ITEM_VOL, WSH_WSHRDBOL_XMLP_PKG.CP_TOP_MODEL_LINE_ID_p CP_TOP_MODEL_LINE_ID, WSH_WSHRDBOL_XMLP_PKG.CP_SRC_LINE_ID_p CP_SRC_LINE_ID*/ from mtl_system_items msi where wdd.top_model_line_id is not null and msi.inventory_item_id = wdd.inventory_item_id and msi.auto_created_config_flag = 'Y' UNION select 'EXISTS'/*, WSH_WSHRDBOL_XMLP_PKG.cf_commodity_classformula(wdd.inventory_item_id, wdd.organization_id) CF_COMMODITY_CLASS, WSH_WSHRDBOL_XMLP_PKG.cf_unpacked_item_descformula(wdd.item_description, nvl ( sum ( NVL ( wdd.shipped_quantity , 0 ) ) , 0 ), wdd.requested_quantity_uom, wdd.organization_id, wdd.inventory_item_id, wdd.requested_quantity_uom2, nvl ( sum ( NVL ( wdd.shipped_quantity2 , 0 ) ) , 0 )) CF_UNPACKED_ITEM_DESC, WSH_WSHRDBOL_XMLP_PKG.cf_unpacked_item_wtformula(nvl ( sum ( wdd.net_weight ) , 0 ), wdd.weight_uom_code) CF_UNPACKED_ITEM_WT, WSH_WSHRDBOL_XMLP_PKG.cf_src_hdr_idformula() CF_SRC_HDR_ID, WSH_WSHRDBOL_XMLP_PKG.cf_unpacked_item_volformula(nvl ( sum ( wdd.volume ) , 0 ), wdd.volume_uom_code) CF_UNPACKED_ITEM_VOL, WSH_WSHRDBOL_XMLP_PKG.CP_TOP_MODEL_LINE_ID_p CP_TOP_MODEL_LINE_ID, WSH_WSHRDBOL_XMLP_PKG.CP_SRC_LINE_ID_p CP_SRC_LINE_ID*/ from dual where wdd.top_model_line_id is not null and wdd.ato_line_id is not null UNION select 'EXISTS'/*, WSH_WSHRDBOL_XMLP_PKG.cf_commodity_classformula(wdd.inventory_item_id, wdd.organization_id) CF_COMMODITY_CLASS, WSH_WSHRDBOL_XMLP_PKG.cf_unpacked_item_descformula(wdd.item_description, nvl ( sum ( NVL ( wdd.shipped_quantity , 0 ) ) , 0 ), wdd.requested_quantity_uom, wdd.organization_id, wdd.inventory_item_id, wdd.requested_quantity_uom2, nvl ( sum ( NVL ( wdd.shipped_quantity2 , 0 ) ) , 0 )) CF_UNPACKED_ITEM_DESC, WSH_WSHRDBOL_XMLP_PKG.cf_unpacked_item_wtformula(nvl ( sum ( wdd.net_weight ) , 0 ), wdd.weight_uom_code) CF_UNPACKED_ITEM_WT, WSH_WSHRDBOL_XMLP_PKG.cf_src_hdr_idformula() CF_SRC_HDR_ID, WSH_WSHRDBOL_XMLP_PKG.cf_unpacked_item_volformula(nvl ( sum ( wdd.volume ) , 0 ), wdd.volume_uom_code) CF_UNPACKED_ITEM_VOL, WSH_WSHRDBOL_XMLP_PKG.CP_TOP_MODEL_LINE_ID_p CP_TOP_MODEL_LINE_ID, WSH_WSHRDBOL_XMLP_PKG.CP_SRC_LINE_ID_p CP_SRC_LINE_ID*/ from dual where wdd.top_model_line_id = wdd.source_line_id) and decode ( :delivery_type , 'STANDARD' , wda.delivery_id , wda.parent_delivery_id )=:DELIVERY_ID3 group by decode(:delivery_type,'STANDARD',wda.delivery_id, wda.parent_delivery_id), wdd.item_description, wdd.shipping_instructions, wdd.hazard_class_id, wdd.requested_quantity_uom, wdd.requested_quantity_uom2, wdd.weight_uom_code, wdd.volume_uom_code, wdd.classification, wdd.cust_po_number, wdd.seal_code, wdd.organization_id, wdd.inventory_item_id --; WSH WSHRDBOL_XML AR WSH بوليصة الشحن (بتنسيق XML) Imported from BI Publisher Description: بوليصة الشحن Application: تنفيذ الشحن Source: بوليصة الشحن (بتنسيق XML) Short Name: WSHRDBOL_XML DB package: WSH_WSHRDBOL_XMLP_PKG D WSH Frachtbrief Imported from BI Publisher Description: Frachtbrief Application: Shipping Execution Source: Frachtbrief (XML) Short Name: WSHRDBOL_XML DB package: WSH_WSHRDBOL_XMLP_PKG E WSH Conocimiento de Embarque Imported from BI Publisher Description: Conocimiento de Embarque Application: Shipping Execution Source: Conocimiento de Embarque (XML) Short Name: WSHRDBOL_XML DB package: WSH_WSHRDBOL_XMLP_PKG F WSH Bordereau de chargement Imported from BI Publisher Description: Bordereau de chargement Application: Shipping Execution Source: Bordereau de chargement (XML) Short Name: WSHRDBOL_XML DB package: WSH_WSHRDBOL_XMLP_PKG I WSH Polizza di carico Imported from BI Publisher Description: Polizza di carico Application: Shipping Execution Source: Polizza di carico (XML) Short Name: WSHRDBOL_XML DB package: WSH_WSHRDBOL_XMLP_PKG JA WSH 船荷証券 Imported from BI Publisher Description: 船荷証券 Application: Shipping Execution Source: 船荷証券(XML) Short Name: WSHRDBOL_XML DB package: WSH_WSHRDBOL_XMLP_PKG KO WSH 선하증권 Imported from BI Publisher Description: 선하증권 Application: Shipping Execution Source: 선하증권(XML) Short Name: WSHRDBOL_XML DB package: WSH_WSHRDBOL_XMLP_PKG PTB WSH Conhecimento de Embarque Imported from BI Publisher Description: Conhecimento de Embarque Application: Execução da Entrega Source: Conhecimento de Embarque (XML) Short Name: WSHRDBOL_XML DB package: WSH_WSHRDBOL_XMLP_PKG RU WSH Коносамент Imported from BI Publisher Description: Коносамент Application: Выполнение отгрузки Source: Коносамент (XML) Short Name: WSHRDBOL_XML DB package: WSH_WSHRDBOL_XMLP_PKG S WSH Konossement Imported from BI Publisher Description: Konossement Application: Shipping Execution Source: Konossement (XML) Short Name: WSHRDBOL_XML DB package: WSH_WSHRDBOL_XMLP_PKG TR WSH Konşimento Imported from BI Publisher Description: Konşimento Application: Sevkiyat Yönetimi Source: Konşimento (XML) Short Name: WSHRDBOL_XML DB package: WSH_WSHRDBOL_XMLP_PKG US WSH Bill of Lading Imported from BI Publisher Description: Bill of Lading Application: Shipping Execution Source: Bill of Lading (XML) Short Name: WSHRDBOL_XML DB package: WSH_WSHRDBOL_XMLP_PKG ZHS WSH 提单 Imported from BI Publisher Description: 提单 Application: 发运管理系统 Source: 提单 (XML) Short Name: WSHRDBOL_XML DB package: WSH_WSHRDBOL_XMLP_PKG BI Publisher :cp_certificate_number :cp_classification :cp_container_classification :cp_hm :cp_key_version :cp_num_packages :cp_src_line_id :cp_top_model_line_id :cp_total_collect_currency :cp_total_prepaid_amount :cp_total_prepaid_currency :delivery_id3 :delivery_type :lp_date_range :lp_delivery_id :lp_delivery_leg_id :lp_freight_code :lp_organization_id :lp_trip_id :lp_where_clause :p_conc_request_id :p_delivery_date_high :p_delivery_date_high_v :p_delivery_date_low :p_delivery_id :p_delivery_leg_id :p_freight_code :p_item_display :p_item_flex_code :p_organization_id :p_trip_id 1 -20 :p_item_flex_code Char MSTK 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 :p_organization_id 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') 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 Warehouse ZHS 仓库 仓库 3 20 :p_delivery_date_low Date AR تاريخ التسليم (من) تاريخ التسليم (من) D Von Auslieferungsdatum Von Auslieferungsdatum E De Fecha de Entrega De Fecha de Entrega F Date de livraison (Du) Date de livraison (Du) I Data consegna (minimo) Data consegna (minimo) JA 搬送日 (自) 搬送日 (自) KO 납품 일자(하한) 납품 일자(하한) PTB Data da Distribuição (Inferior) Data da Distribuição (Inferior) RU Дата доставки с Дата доставки с S Leveransdatum (från) Leveransdatum (från) TR Teslimat Tarihi (Alt Değer) Teslimat Tarihi (Alt Değer) US Delivery Date (Low) Delivery Date (Low) ZHS 交货日期（下限） 交货日期（下限） 4 30 :p_delivery_date_high Date select fnd_date.date_to_chardate(fnd_date.canonical_to_date(:$flex$.delivery_date_low)) from dual AR تاريخ التسليم (إلى) تاريخ التسليم (إلى) D Bis Auslieferungsdatum Bis Auslieferungsdatum E A Fecha de Entrega A Fecha de Entrega F Date de livraison (Au) Date de livraison (Au) I Data consegna (massimo) Data consegna (massimo) JA 搬送日 (至) 搬送日 (至) KO 납품 일자(상한) 납품 일자(상한) PTB Data da Distribuição (Superior) Data da Distribuição (Superior) RU Дата доставки по Дата доставки по S Leveransdatum (till) Leveransdatum (till) TR Teslimat Tarihi (Üst Değer) Teslimat Tarihi (Üst Değer) US Delivery Date (High) Delivery Date (High) ZHS 交货日期（上限） 交货日期（上限） 5 40 :p_freight_code 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 Freight Carrier ZHS 承运人 承运人 6 50 :p_delivery_id LOV Oracle WSH_BOL_DELIVERIES_W_TYPE Y select delivery_id id, name value, delivery_type_meaning description from wsh_deliveries_bol_rdf_v where organization_id=nvl(:$flex$.wsh_srs_organizations:null,organization_id) and nvl(shipment_direction,'O') in('O','IO') 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 Delivery Name ZHS 交货名称 交货名称 7 60 :p_trip_id LOV Oracle WSH_SRS_TRIPS Y select trip_id id, name value, null description from wsh_trips where nvl(shipments_type_flag,'O') in ('O','M') order by name AR اسم الرحلة اسم الرحلة D Tourbezeichnung Tourbezeichnung E Nombre de Viaje Nombre de Viaje F Code trajet Code trajet I Nome viaggio Nome viaggio JA トリップ名 トリップ名 KO 이동명 이동명 PTB Nome do Percurso Nome do Percurso RU Имя рейса Имя рейса S Turnamn Turnamn TR Yol Adı Yol Adı US Trip Name Trip Name ZHS 里程名称 里程名称 8 70 :p_delivery_leg_id LOV Oracle WSH_SRS_BOLS Y select delivery_leg_id id, bill_of_lading_number value, null description from wsh_bols_rd_v order by bill_of_lading_number AR رقم بوليصة الشحن رقم بوليصة الشحن D Frachtbriefnummer Frachtbriefnummer E Número de Conocimiento de Embarque Número de Conocimiento de Embarque F Nunméro de bordereau de chargement Nunméro de bordereau de chargement I N. polizza di carico N. polizza di carico JA 船荷証券番号 船荷証券番号 KO 선하증권 번호 선하증권 번호 PTB Número do Conhecimento de Embarque Número do Conhecimento de Embarque RU Номер коносамента Номер коносамента S Konossementnummer Konossementnummer TR Konşimento Numarası Konşimento Numarası US Bill of Lading Number Bill of Lading Number ZHS 提单编号 提单编号 9 80 :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 Lagerartikel-Beschreibung oder FlexFeld drucken E Presentación del Artículo Imprimir Descripción de Artículo de Inventario o Estructura F Affichage article Imprimer description ou clé d'article stocké I Visualizzazione articolo Stampa la descrizione o il flexfield dell'articolo di magazzino JA 品目表示 在庫品目摘要またはフレックスの印刷 KO 품목 표시 재고 품명 또는 가변 PTB Exibição do Item Imprimir Descrição ou Flex. do Item de Inventário RU Вывод позиции Печать описания или ГП позиции запасов S Artikelvisning Skriv ut beskr. av lagerart. eller flexfält TR Kalem Görüntüleme Envanter Kalemi Tanımlamasını veya Esnekalanını Yazdırır. US Item Display Print Inventory Item Description or Flex ZHS 物料显示 打印库存物料说明或弹性域