ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F52F3869E053B46B63588994Y select shipment_num, item_id, nvl(to_char(quantity_expected),' ') quantity_expected, nvl(to_char(quantity_actual),' ') quantity_actual, nvl(unit_of_measure_expected,' ') unit_of_measure_expected, nvl(unit_of_measure_actual,' ') unit_of_measure_actual, lpn_expected, lpn_actual, nvl(item_revision_expected,' ') item_revision_expected , nvl(item_revision_actual,' ' ) item_revision_actual , lot_number_expected, lot_number_actual, vendor_id, WMS_WMSASNI_XMLP_PKG.cf_2formula(item_id) CF_2, WMS_WMSASNI_XMLP_PKG.cf_9formula(vendor_id) CF_9 from wms_asn_details asn where asn.organization_id = :ORG_ID and asn.item_id = nvl(:P_ITEM_ID,asn.item_id) and asn.shipment_num = nvl(:P_SHIPMENT_NUMBER,asn.shipment_num) and ( ( asn.vendor_id = :P_VENDOR_ID and :P_VENDOR_ID is not null) or (:P_VENDOR_ID is null) ) and ( ( asn.vendor_site_id = :P_VENDOR_SITE_ID and :P_VENDOR_SITE_ID is not null) or (:P_VENDOR_SITE_ID is null) ) and ( ( ( trunc(asn.TRANSACTION_DATE) between trunc(:P_FROM_DATE) and trunc(:P_END_DATE) ) and (:P_FROM_DATE is not null or :P_END_DATE is not null) ) or (:P_FROM_DATE is null and :P_END_DATE is null) ) and ( ( nvl (:P_SHOW_ONLY_DISC,'N') = 'N' and discrepancy_status = discrepancy_status ) or ( nvl (:P_SHOW_ONLY_DISC,'N') = 'Y' and discrepancy_status in ('E' ,'F') ) ) and discrepancy_reporting_context = 'I' WMS WMSASNI_XML AR WMS ASN DISCREPANCY Application: إدارة المستودعات Source: WMS ASN DISCREPANCY REPORT (XML) Short Name: WMSASNI_XML DB package: WMS_WMSASNI_XMLP_PKG US WMS ASN DISCREPANCY Application: Warehouse Management Source: WMS ASN DISCREPANCY REPORT (XML) Short Name: WMSASNI_XML DB package: WMS_WMSASNI_XMLP_PKG ZHS WMS ASN DISCREPANCY Application: 仓库管理系统 Source: WMS ASN DISCREPANCY REPORT (XML) Short Name: WMSASNI_XML DB package: WMS_WMSASNI_XMLP_PKG BI Publisher :org_id :p_cbo_flag :p_check_lot_attributes :p_check_lot_number :p_check_lpn :p_check_revision :p_check_ser_attributes :p_check_ser_number :p_conc_request_id :p_end_date :p_from_date :p_item_id :p_shipment_number :p_show_only_disc :p_trace_flag :p_vendor_id :p_vendor_site_id 1 10 :org_id LOV Oracle WMS_DISC_ORG Y select to_char(organization_id) id, organization_code value, organization_name description from org_organization_definitions where nvl(disable_date,sysdate+1)>sysdate order by value,description Y AR التنظيم D Organisation F Organisation US Organization ZHS 组织 2 20 :p_shipment_number LOV Oracle WMS_SHIPMENT_NUM Y select shipment_num id, shipment_num value, null description from rcv_shipment_headers order by shipment_num AR رقم الشحنة D Liefernummer F Numéro de livraison US Shipment Num ZHS 发运编号 3 30 :p_item_id LOV Oracle WMS_ITEM_LIST Y select inventory_item_id id, segment1 value, description description from mtl_system_items msi where msi.organization_id=:$flex$.wms_disc_org order by segment1 AR الصنف D Artikel F Article US Item ZHS 物料 4 40 :p_from_date Date AR من التاريخ D Von Datum F Date de début US From Date ZHS 自日期 5 50 :p_end_date Date AR إلى التاريخ D Bis Datum F Date de fin US To Date ZHS 至日期 6 60 :p_vendor_id LOV Oracle INV_SRS_PO_VENDOR Y select vendor_id id, vendor_name value, null description from po_vendors where 1=1 order by value,description AR المورد D Lieferant F Fournisseur US Supplier ZHS 供应商 7 70 :p_vendor_site_id LOV Oracle PO_SRS_VENDOR_SITE Y select vendor_site_code id, vendor_site_code value, null description from po_vendor_sites order by vendor_site_code AR موقع المورد D Lieferantenadresse F Site fournisseur US Supplier Site ZHS 供应商地点 8 80 :p_check_lpn LOV Oracle INV_SRS_Y_N Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' and enabled_flag='Y' order by value,description SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'YES_NO' AND LOOKUP_CODE = 'Y' Y AR فحص LPN D VPN prüfen F Vérifier LPN US Check LPN ZHS 检查 LPN 9 90 :p_check_revision LOV Oracle INV_SRS_Y_N Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' and enabled_flag='Y' order by value,description SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'YES_NO' AND LOOKUP_CODE = 'Y' Y AR فحص المراجعة D Version prüfen F Vérifier la version US Check Revision ZHS 检查版本 10 100 :p_check_lot_number LOV Oracle INV_SRS_Y_N Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' and enabled_flag='Y' order by value,description SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'YES_NO' AND LOOKUP_CODE = 'Y' Y AR فحص رقم اللوط D Losnummer prüfen F Vérifier le numéro de lot US Check Lot Number ZHS 检查批号 11 110 :p_check_ser_number LOV Oracle INV_SRS_Y_N Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' and enabled_flag='Y' order by value,description SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'YES_NO' AND LOOKUP_CODE = 'Y' Y AR فحص الرقم المسلسل D Seriennummer prüfen F Vérifier le numéro de série US Check Serial Number ZHS 检查序列号 12 120 :p_show_only_disc LOV Oracle INV_SRS_Y_N Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' and enabled_flag='Y' order by value,description SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'YES_NO' AND LOOKUP_CODE = 'N' Y AR إظهار التعارضات فقط D Nur Differenzen anzeigen F Afficher uniquement les écarts US Show Only Discrepancies ZHS 仅显示差异 :$flex$.wms_disc_org Organization Item