ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F07B3869E053B46B63588994Y SELECT error_type error_type5 , error_name error_name5 , movement_id movement_id5 , column_name column_name5, --INV_INVMVTEX_XMLP_PKG.cf_action_text5formula() CF_action_text5, INV_INVMVTEX_XMLP_PKG.cf_action_text5formula() CP_action_text5, --INV_INVMVTEX_XMLP_PKG.cf_error_text5formula() CF_error_text5, INV_INVMVTEX_XMLP_PKG.cf_error_text5formula() CP_error_text5, --INV_INVMVTEX_XMLP_PKG.CP_action_text5_p CP_action_text5, --INV_INVMVTEX_XMLP_PKG.CP_error_text5_p CP_error_text5, 'x' dummy FROM inv_mvt_excep_rep_temp WHERE error_name='INV_MGD_MVT_INVAL_VAL' ORDER BY 1 ASC,2 ASC,3 ASC INV INVMVTEX_XML AR INV تقرير استثناء إحصائيات النقل (بتنسيق XML) Application: المخازن Source: تقرير استثناء إحصائيات النقل (بتنسيق XML) Short Name: INVMVTEX_XML DB package: INV_INVMVTEX_XMLP_PKG D INV Bewegungsstatistiken - Ausnahmen Application: Lager Source: Bewegungsstatistiken - Ausnahmen (XML) Short Name: INVMVTEX_XML DB package: INV_INVMVTEX_XMLP_PKG F INV Etat des exceptions déclaration d'échanges de biens Application: Inventory Source: Etat des exceptions déclaration d'échanges de biens (XML) Short Name: INVMVTEX_XML DB package: INV_INVMVTEX_XMLP_PKG US INV Movement Statistics Exception Application: Inventory Source: Movement Statistics Exception Report (XML) Short Name: INVMVTEX_XML DB package: INV_INVMVTEX_XMLP_PKG ZHS INV 移动统计数据例外报表 Application: 库存管理系统 Source: 移动统计数据例外报表 (XML) Short Name: INVMVTEX_XML DB package: INV_INVMVTEX_XMLP_PKG BI Publisher :cp_action_text1 :cp_action_text2 :cp_action_text3 :cp_action_text4 :cp_action_text5 :cp_action_text6 :cp_display_warn_flag :cp_error_text1 :cp_error_text2 :cp_error_text3 :cp_error_text4 :cp_error_text5 :cp_error_text6 :cp_error_text7 :cp_source_document_type :cp_stat_type_name :cp_usage_type_name :cp_zone_display_name :p_conc_request_id :p_display_warn_flag :p_document_source_type :p_economic_zone_code :p_legal_entity_id :p_order_by :p_period_name :p_stat_type :p_usage_type 1 10 :p_legal_entity_id LOV Oracle INV_MGD_MVT_LEGAL_ENTITY Y select legal_entity_id id, name value, null description from xle_firstparty_information_v where sysdate between nvl(le_effective_from,sysdate) and nvl(le_effective_to,sysdate) and exists (select null from mtl_stat_type_usages where legal_entity_id=xle_firstparty_information_v.legal_entity_id) and exists (select null from xle_fp_ou_ledger_v where mo_global.check_access(operating_unit_id)='Y' and legal_entity_id=xle_firstparty_information_v.legal_entity_id) order by name SELECT name, legal_entity_id FROM xle_firstparty_information_v WHERE sysdate between NVL(le_effective_from, sysdate) and nvl(le_effective_to, sysdate) AND EXISTS (SELECT NULL FROM mtl_stat_type_usages WHERE legal_entity_id = xle_firstparty_information_v.legal_entity_id) AND legal_entity_id = XLE_UTILITIES_GRP.Get_Defaultlegalcontext_Ou(MO_UTILS.Get_Default_Org_ID) Y AR الكيان القانوني D Mandant F Entité juridique US Legal Entity ZHS 法人主体 2 20 :p_economic_zone_code LOV Oracle INV_MGD_MVT_ECONOMIC_ZONE Y select zone_code id, zone_display_name value, null description from mtl_economic_zones_vl where zone_code in (select zone_code from mtl_le_economic_zones where legal_entity_id=:$flex$.inv_mgd_mvt_legal_entity ) order by zone_display_name Y AR المنطقة الاقتصادية D Wirtschaftsraum F Zone économique US Economic Zone ZHS 经济区 3 30 :p_usage_type LOV Oracle INV_MGD_MVT_USAGE_TYPE Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='MVT_USAGE_TYPES' and lookup_code in (select usage_type from mtl_stat_type_usages where legal_entity_id=:$flex$.inv_mgd_mvt_legal_entity and zone_code=:$flex$.inv_mgd_mvt_economic_zone ) order by meaning Y AR نوع الاستخدام D Nutzungsart F Type d'utilisation US Usage Type ZHS 使用类型 4 40 :p_stat_type LOV Oracle INV_MGD_MVT_STAT_TYPE Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='MVT_STAT_TYPES' and lookup_code in (select stat_type from mtl_stat_type_usages where legal_entity_id=:$flex$.inv_mgd_mvt_legal_entity and zone_code=:$flex$.inv_mgd_mvt_economic_zone and usage_type=:$flex$.inv_mgd_mvt_usage_type ) order by meaning Y AR النوع الإحصائي D Statistikart F Type statistique US Statistical Type ZHS 统计类型 5 50 :p_period_name LOV Oracle INV_MGD_MVT_PERIOD_NAME Y select period_name id, period_name value, null description from gl_periods where period_set_name in (select period_set_name from mtl_stat_type_usages where legal_entity_id=:$flex$.inv_mgd_mvt_legal_entity and zone_code=:$flex$.inv_mgd_mvt_economic_zone and usage_type=:$flex$.inv_mgd_mvt_usage_type and stat_type=:$flex$.inv_mgd_mvt_stat_type ) and period_type in (select period_type from mtl_stat_type_usages where legal_entity_id=:$flex$.inv_mgd_mvt_legal_entity and zone_code=:$flex$.inv_mgd_mvt_economic_zone and usage_type=:$flex$.inv_mgd_mvt_usage_type and stat_type=:$flex$.inv_mgd_mvt_stat_type ) and start_date>= (select gp.start_date from gl_periods gp ,mtl_stat_type_usages mstu where gp.period_name=mstu.start_period_name and gp.period_set_name=mstu.period_set_name and legal_entity_id=:$flex$.inv_mgd_mvt_legal_entity and zone_code=:$flex$.inv_mgd_mvt_economic_zone and usage_type=:$flex$.inv_mgd_mvt_usage_type and stat_type=:$flex$.inv_mgd_mvt_stat_type ) and ((end_date<= (select gp.end_date from gl_periods gp ,mtl_stat_type_usages mstu where gp.period_name=mstu.end_period_name and gp.period_set_name=mstu.period_set_name and legal_entity_id=:$flex$.inv_mgd_mvt_legal_entity and zone_code=:$flex$.inv_mgd_mvt_economic_zone and usage_type=:$flex$.inv_mgd_mvt_usage_type and stat_type=:$flex$.inv_mgd_mvt_stat_type )) or (exists (select null from mtl_stat_type_usages where legal_entity_id=:$flex$.inv_mgd_mvt_legal_entity and zone_code=:$flex$.inv_mgd_mvt_economic_zone and usage_type=:$flex$.inv_mgd_mvt_usage_type and stat_type=:$flex$.inv_mgd_mvt_stat_type and end_period_name is null ) ) ) and adjustment_period_flag='N' order by start_date Y AR اسم الفترة D Periodenbezeichnung F Nom de la période US Period Name ZHS 期间名称 6 60 :p_document_source_type LOV Oracle INV_MGD_MVT_DOCUMENT_SOURCE_TYPE Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='MVT_SOURCE_DOCUMENT_TYPES' order by meaning AR نوع مصدر المستند D Herkunftsart Dokument F Type d'origine du document US Document Source Type ZHS 单据来源类型 7 70 :p_display_warn_flag 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' Y AR عرض التحذيرات D Warnungen anzeigen F Afficher des avertissements US Display Warnings ZHS 显示警告