ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F57D3869E053B46B63588994Y SELECT yedv.TRAILER_SCAC_CODE SCAC , yedv.EQUIPMENT_NUMBER EQUIP_NUMBER , yedv.REQUEST_NUMBER REQ_NUMBER , yedv.INVENTORY_ITEM_ID ITEM_ID , yedv.CURRENT_SUBINVENTORY_CODE FROM_SUBINV , yedv.CURRENT_LOCATOR_ALIAS FROM_LOCATOR , yedv.TRANSFER_SUBINVENTORY TO_SUBINV , yedv.TRANSFER_LOCATOR_ALIAS TO_LOCATOR , yedv.USER_NAME USER_NAME FROM yms_equipment_details_v yedv , MTL_TXN_REQUEST_LINES MTRL WHERE yedv.HEADER_ID = MTRL.HEADER_ID AND MTRL.ORGANIZATION_ID = :P_ORG_ID and &P_WHERE YMS YMSTOPKL_XML AR YMS بطاقة نقل المعدات في الساحة Application: Oracle Yard Management Source: بطاقة نقل المعدات في الساحة (XML) Short Name: YMSTOPKL_XML DB package: YMS_YMSTOPKL_XMLP_PKG D YMS Transferschein für Ausrüstung im Yard Application: Oracle Yard Management Source: Transferschein für Ausrüstung im Yard (XML) Short Name: YMSTOPKL_XML DB package: YMS_YMSTOPKL_XMLP_PKG F YMS Bordereau de déplacement d'équipements dans la cour Application: Oracle Yard Management Source: Bordereau de déplacement d'équipements dans la cour (XML) Short Name: YMSTOPKL_XML DB package: YMS_YMSTOPKL_XMLP_PKG US YMS Yard Equipment Move Slip Application: Oracle Yard Management Source: Yard Equipment Move Slip (XML) Short Name: YMSTOPKL_XML DB package: YMS_YMSTOPKL_XMLP_PKG ZHS YMS 堆场设备移动工单 Application: Oracle Yard Management Source: 堆场设备移动工单 (XML) Short Name: YMSTOPKL_XML DB package: YMS_YMSTOPKL_XMLP_PKG BI Publisher &p_where :cp_date_reqd_hi :cp_date_reqd_lo :p_conc_request_id :p_date_reqd_hi :p_date_reqd_lo :p_dest_locator :p_dest_locator_id :p_dest_subinv :p_equipment_number :p_move_order_high :p_move_order_low :p_org_id :p_org_name :p_source_locator :p_source_locator_id :p_source_subinv :p_trailer_scac :p_user :p_where 1 10 :p_org_id LOV Oracle YMS_SRS_ORG Y select organization_id id, organization_code value, organization_name description from org_organization_definitions orgs where nvl(disable_date,sysdate+1)>sysdate and exists (select 'x' from mtl_parameters mp where mp.organization_id=orgs.organization_id and mp.yard_management_enabled_flag='Y' ) order by organization_code Y AR الساحة F Cour US Yard ZHS 堆场 2 20 :p_move_order_low LOV Oracle YMS_MOVE_ORDER Y select request_number id, request_number value, null description from mtl_txn_request_headers where organization_id=:$flex$.yms_srs_org order by request_number AR رقم طلب النقل من D Von Transferauftragsnummer F Numéro d'ordre de déplacement - De US Move Order Number From ZHS 物料搬运单起始编号 3 30 :p_move_order_high LOV Oracle YMS_MOVE_ORDER Y select request_number id, request_number value, null description from mtl_txn_request_headers where organization_id=:$flex$.yms_srs_org order by request_number SELECT :$FLEX$.Move_Order_Number_From FROM DUAL AR رقم طلب النقل إلى D Bis Transferauftragsnummer F Numéro d'ordre de déplacement - A US Move Order Number To ZHS 物料搬运单终止编号 4 40 :p_source_subinv LOV Oracle YMS_SRS_SUBINV Y select secondary_inventory_name id, secondary_inventory_name value, description description from mtl_secondary_inventories where organization_id=:$flex$.yms_srs_org order by secondary_inventory_name AR منطقة الساحة المصدر D Bezugs-Yard-Bereich F Aire de cour d'origine US Source Yard Area ZHS 来源堆场区域 5 50 :p_source_locator_id LOV Oracle YMS_SRC_LOCATOR Y select inventory_location_id id, alias value, description description from mtl_item_locations where organization_id=:$flex$.yms_srs_org and subinventory_code=:$flex$.yms_srs_subinv order by value,description AR موقع الانتظار المصدر D Bezugsstellplatz F Emplacement de stationnement d'origine US Source Parking Spot ZHS 来源停车位置 6 60 :p_dest_subinv LOV Oracle YMS_DEST_SUBINV Y select secondary_inventory_name id, secondary_inventory_name value, description description from mtl_secondary_inventories where organization_id=:$flex$.yms_srs_org order by secondary_inventory_name AR منطقة الساحة الوجهة D Bestimmungs-Yard-Bereich F Aire de cour de destination US Destination Yard Area ZHS 目标堆场区域 7 70 :p_dest_locator_id LOV Oracle YMS_DEST_LOCATOR Y select inventory_location_id id, alias value, description description from mtl_item_locations where organization_id=:$flex$.yms_srs_org and subinventory_code=:$flex$.yms_dest_subinv order by value,description AR موقع الانتظار الوجهة D Bestimmungsstellplatz F Emplacement de stationnement de destination US Destination Parking Spot ZHS 目标停车位置 8 80 :p_date_reqd_lo Date AR تاريخ الطلب من D Von Bedarfsdatum F Date requise - Du US Date Required From ZHS 需求日期自 9 90 :p_date_reqd_hi Date AR تاريخ الطلب إلى D Bis Bedarfsdatum F Date requise - Au US Date Required To ZHS 需求日期至 10 100 :p_trailer_scac LOV Oracle YMS_SCAC_CODE Y select trailer_scac_code id, trailer_scac_code value, null description from (select distinct trailer_scac_code,organization_id from yms_equipment) where organization_id=:$flex$.yms_srs_org order by trailer_scac_code F Code SCAC US SCAC 11 110 :p_equipment_number LOV Oracle YMS_EQUIPMENT_NUMBER Y select equipment_number id, equipment_number value, null description from yms_equipment where organization_id=:$flex$.yms_srs_org order by equipment_number AR رقم المعدات D Ausrüstungsnummer F Numéro d'équipement US Equipment Number ZHS 设备编号 12 120 :p_user LOV Oracle YMS_ASSIGNED_USER Y select user_name id, user_name value, user_id description from fnd_user fu where exists (select 'x' from ak_web_user_sec_attr_values awusav where awusav.web_user_id=fu.user_id and awusav.attribute_application_id=9009 and awusav.attribute_code='YMS_TASK_ELIGIBLE' and upper(varchar2_value)='YES') order by user_name AR المستخدم المخصص D Zugeordneter Benutzer F Utilisateur affecté US Assigned user ZHS 已分配用户