ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B9847D20A0E4742FE0538931640A6379 AP Supplier Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id US A8A22372CC511FBDE0530100007FEDAE MSC Supply/Demand Type Y select flv.meaning value, null description from fnd_lookup_values@A2M_DBLINK flv where flv.lookup_type IN ('MRP_ORDER_TYPE','SRP_CHANGED_ORDER_TYPE','MSC_DEMAND_ORIGINATION') and flv.security_group_id = 0 and flv.enabled_flag = 'Y' and sysdate between nvl(flv.start_date_active,sysdate) and nvl(flv.end_date_active,sysdate) and flv.language = nvl((select fl.language_code from fnd_languages@A2M_DBLINK fl where fl.installed_flag in ('B','I') and language_code = userenv('lang')),fnd_global.base_language@A2M_DBLINK) order by value AR تُرجع قائمة أنواع العرض والطلب الخاصة بـ ASCP D Liefert die Liste der ASCP-Angebots- und Nachfragetypen E Devuelve la lista de tipos de oferta y demanda de ASCP F Renvoie la liste des types d'offre et de demande de l'ASCP I Restituisce l'elenco dei tipi di domanda e offerta ASCP JA ASCP需給タイプのリストを返します KO ASCP 공급 및 수요 유형 목록을 반환합니다. PTB Retorna a lista de tipos de oferta e demanda ASCP RU Возвращает список ASCP Типы спроса и предложения S Returnerar listan över ASCP-utbuds- och efterfrågetyper TR ASCP Arz ve Talep Türlerinin listesini verir US Returns the list of ASCP Supply and Demand Types ZHS 返回ASCP供需类型列表。 0081E27DDE612FFFE06362FB0905B96CY select ood.organization_name organization, ood.organization_code, nvl(mfds0.forecast_designator,mfds.forecast_designator) forecast_set, nvl(mfds0.description,mfds.description) set_description, nvl2(mfds.forecast_set,mfds.forecast_designator,null) forecast, nvl2(mfds.description,mfds.description,null) description, msiv.planner_code planner, mpl.description planner_description, msiv.concatenated_segments item, msiv.description item_description, xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) user_item_type, msiv.primary_uom_code uom, mfiv.alternate_bom_designator alternate_bill, xxen_util.meaning(mfiv.bom_item_type,'BOM_ITEM_TYPE',700) bill_type, mfiv.ato_forecast_control_desc forecast_control, mfiv.mrp_planning_code_desc mrp_planning_method, xxen_util.meaning(mfd.origination_type,'MRP_FORECAST_ORIG',700) origination_type, xxen_util.meaning(mfd.bucket_type,'MRP_BUCKET_TYPE',700) bucket_type, mfd.forecast_date, mfd.rate_end_date end_date, mfd.current_forecast_quantity current_quantity, mfd.original_forecast_quantity original_quantity, ppa.project_number project, pt.task_number task, mfd.confidence_percentage, mfiv.alternate_bom_designator, wl.line_code from org_organization_definitions ood, mrp_forecast_items_v mfiv, mrp_forecast_dates mfd, mrp_forecast_designators mfds, mrp_forecast_designators mfds0, mtl_system_items_vl msiv, ( select ppa.project_id, ppa.segment1 project_number from pa_projects_all ppa union select psm.project_id, psm.project_number from pjm_seiban_numbers psm ) ppa, pa_tasks pt, wip_lines wl, mtl_planners mpl where 1=1 and ood.organization_id=mfiv.organization_id and mfiv.organization_id=mfd.organization_id and mfiv.forecast_designator=mfd.forecast_designator and mfiv.inventory_item_id=mfd.inventory_item_id and mfiv.organization_id=mfds.organization_id and mfiv.forecast_designator=mfds.forecast_designator and mfds.organization_id=mfds0.organization_id(+) and mfds.forecast_set=mfds0.forecast_designator(+) and mfiv.organization_id=msiv.organization_id and mfiv.inventory_item_id=msiv.inventory_item_id and mfd.project_id=ppa.project_id(+) and mfd.task_id=pt.task_id(+) and mfd.line_id=wl.line_id(+) and msiv.planner_code=mpl.planner_code(+) and msiv.organization_id=mpl.organization_id(+) order by forecast_set, forecast, msiv.concatenated_segments, mfd.forecast_date desc US Item_Forecast Testing 1=1 1 10 1=1 aps.vendor_name=:supplier_name LOV AP Supplier B9847D20A0E4742FE0538931640A6379 Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id US Supplier 2 20 1=1 mov.order_type_text =:order_type LOV MSC Supply/Demand Type A8A22372CC511FBDE0530100007FEDAE Y select flv.meaning value, null description from fnd_lookup_values@A2M_DBLINK flv where flv.lookup_type IN ('MRP_ORDER_TYPE','SRP_CHANGED_ORDER_TYPE','MSC_DEMAND_ORIGINATION') and flv.security_group_id = 0 and flv.enabled_flag = 'Y' and sysdate between nvl(flv.start_date_active,sysdate) and nvl(flv.end_date_active,sysdate) and flv.language = nvl((select fl.language_code from fnd_languages@A2M_DBLINK fl where fl.installed_flag in ('B','I') and language_code = userenv('lang')),fnd_global.base_language@A2M_DBLINK) order by value US Order Type