ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 227462CEA76F06F6E06362FB0905427AY SELECT bucket_seq, organization_id, decode(:P_AGE_LEVEL,1,null,subinventory_code) subinventory_code, decode(:P_AGE_LEVEL,3,locator_code,null) locator_code, inventory_item_id, item_code, item_category, item_desc, uom_code, owing_party, buckets_days_heading, to_char(Max(last_trx_date),'DD-MON-YYYY') last_trx_date, Trunc(SYSDATE)-Min(first_trx_date) n_age, Sum(on_hand) on_hand, Max(sum_on_hand) t_onhand, Sum(Round(n_Value,2)) n_value from ( SELECT organization_id, subinventory_code, locator_code, inventory_item_id, item_code, item_category, item_desc, uom_code, owing_party, buckets_days_heading, INV_AGERPXML_PKG.f_bucket_days_seq(:P_BUCKETS_ID,buckets_days_heading) bucket_seq, Trunc(Max(last_trx_date)) last_trx_date, Trunc(Min(first_trx_date)) first_trx_date, Sum(on_hand) on_hand, Max(sum_on_hand) sum_on_hand, Sum(n_Value) n_Value FROM ( SELECT --msib.concatenated_segments item_code , fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_item', 'INV', 'MSTK', 101, MSIB.ORGANIZATION_ID, MSIB.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') item_code, moqd.organization_id, moqd.subinventory_code, inv_utilities.get_conc_segments(moqd.organization_id,moqd.locator_id) locator_code, moqd.inventory_item_id, --MIC.CATEGORY_CONCAT_SEGS item_category, fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_cat_field', 'INV', 'MCAT', MIC.STRUCTURE_ID, NULL, MIC.CATEGORY_ID, 'ALL', 'Y', 'VALUE') item_category, msib.description item_desc, Decode(is_consigned, 1, Decode (moqd.owning_tp_type, 1, (SELECT vendor_name || '-' || pvsa.vendor_site_code FROM po_vendors pv, po_vendor_sites_all pvsa WHERE pvsa.vendor_id = pv.vendor_id AND pvsa.vendor_site_id = moqd.owning_organization_id), 2, (SELECT(substr(hout.NAME,1,60)||'-'||substr(mp.ORGANIZATION_CODE,1,3)) Party FROM hr_organization_information hoi ,hr_all_organization_units_tl hout ,mtl_parameters mp WHERE hoi.organization_id = hout.organization_id AND hout.organization_id =mp.organization_id AND hout.language = userenv ('LANG') AND hoi.org_information1='OPERATING_UNIT' AND hoi.org_information2='Y' AND hoi.org_information_context='CLASS' AND hoi.organization_id= MOQD.owning_organization_id AND moqd.organization_id <> moqd.owning_organization_id) ) ,NULL) owing_party, --moqd.last_update_date last_trx_date, CASE :P_AGE_LEVEL when '1' then max(moqd.last_update_date) over(partition by moqd.organization_id,moqd.inventory_item_id,moqd.is_consigned,moqd.owning_tp_type,Decode(moqd.is_consigned,1,moqd.owning_organization_id,null)) when '2' THEN max(moqd.last_update_date) over(partition by moqd.organization_id,moqd.inventory_item_id,moqd.subinventory_code,moqd.is_consigned,moqd.owning_tp_type,Decode(moqd.is_consigned,1,moqd.owning_organization_id,null)) when '3' THEN max(moqd.last_update_date) over(partition by moqd.organization_id,moqd.inventory_item_id,moqd.subinventory_code,moqd.locator_id,moqd.is_consigned,moqd.owning_tp_type,Decode(moqd.is_consigned,1,moqd.owning_organization_id,null)) END last_trx_date, CASE :P_AGE_LEVEL when '1' then min(moqd.last_update_date) over(partition by moqd.organization_id,moqd.inventory_item_id,moqd.is_consigned,moqd.owning_tp_type,Decode(moqd.is_consigned,1,moqd.owning_organization_id,null)) when '2' THEN min(moqd.last_update_date) over(partition by moqd.organization_id,moqd.inventory_item_id,moqd.subinventory_code,moqd.is_consigned,moqd.owning_tp_type,Decode(moqd.is_consigned,1,moqd.owning_organization_id,null)) when '3' THEN min(moqd.last_update_date) over(partition by moqd.organization_id,moqd.inventory_item_id,moqd.subinventory_code,moqd.locator_id,moqd.is_consigned,moqd.owning_tp_type,Decode(moqd.is_consigned,1,moqd.owning_organization_id,null)) END first_trx_date, moqd.primary_transaction_quantity on_hand, CASE :P_AGE_LEVEL when '1' then sum(moqd.primary_transaction_quantity) over(partition by moqd.organization_id,moqd.inventory_item_id,moqd.is_consigned,moqd.owning_tp_type,Decode(moqd.is_consigned,1,moqd.owning_organization_id,null)) when '2' THEN sum(moqd.primary_transaction_quantity) over(partition by moqd.organization_id,moqd.inventory_item_id,moqd.subinventory_code,moqd.is_consigned,moqd.owning_tp_type,Decode(moqd.is_consigned,1,moqd.owning_organization_id,null)) when '3' THEN sum(moqd.primary_transaction_quantity) over(partition by moqd.organization_id,moqd.inventory_item_id,moqd.subinventory_code,moqd.locator_id,moqd.is_consigned,moqd.owning_tp_type,Decode(moqd.is_consigned,1,moqd.owning_organization_id,null)) END sum_on_hand, moqd.primary_transaction_quantity * INV_AGERPXML_PKG.f_unit_cost(moqd.organization_id, moqd.inventory_item_id,moqd.locator_id,moqd.cost_group_id,Nvl(moqd.orig_date_received,moqd.creation_date)) n_Value, msib.PRIMARY_UOM_CODE uom_code, INV_AGERPXML_PKG.f_bucket_days_heading(:P_BUCKETS_ID,Nvl(moqd.orig_date_received,moqd.creation_date)) buckets_days_heading --p_buckets_day --moqd.orig_date_received FROM mtl_onhand_quantities_detail moqd, MTL_SYSTEM_ITEMS_vl msib, MTL_SECONDARY_INVENTORIES_FK_V msiv, MTL_ITEM_CATEGORIES_V MIC, mtl_item_locations_kfv mil, CST_COST_GROUPS CCG WHERE moqd.organization_id = msib.organization_id AND moqd.inventory_item_id = msib.inventory_item_id AND msib.organization_id = :P_ORG_ID AND msib.INVENTORY_ASSET_FLAG = Decode(:P_EXP_ITEM,'2','Y', msib.INVENTORY_ASSET_FLAG) AND msiv.organization_id = moqd.organization_id AND msiv.secondary_inventory_name = moqd.subinventory_code AND msiv.asset_inventory = Decode(:P_EXP_SUB,'2',1,msiv.asset_inventory) AND MOQD.COST_GROUP_ID = CCG.COST_GROUP_ID AND CCG.COST_GROUP BETWEEN NVL(:P_CG_FROM, CCG.COST_GROUP) AND NVL(:P_CG_TO, CCG.COST_GROUP) AND msib.organization_id = mic.organization_id AND msib.inventory_item_id = mic.inventory_item_id AND moqd.organization_id = mil.organization_id (+) AND moqd.locator_id = mil.inventory_location_id(+) AND mic.category_set_id = :P_CATEGORY_SET AND &P_ITEM_WHERE AND &P_CAT_WHERE ) GROUP BY organization_id, subinventory_code , locator_code, inventory_item_id, item_code, item_category, item_desc, uom_code, owing_party, INV_AGERPXML_PKG.f_bucket_days_seq(:P_BUCKETS_ID,buckets_days_heading), buckets_days_heading UNION ALL --below is for heading all onhand and value is 0 SELECT organization_id, subinventory_code, locator_code, inventory_item_id, item_code, item_category, item_desc, uom_code, owing_party, aablt.report_heading1 || ' ' || aablt.report_heading2 buckets_days_heading, aabl.bucket_sequence_num bucket_seq, last_trx_date, first_trx_date, 0 on_hand, sum_on_hand, 0 n_Value FROM (SELECT organization_id, subinventory_code, locator_code, inventory_item_id, item_code, item_category, item_desc, uom_code, owing_party, buckets_days_heading, INV_AGERPXML_PKG.f_bucket_days_seq(:P_BUCKETS_ID,buckets_days_heading) bucket_seq, Trunc(Max(last_trx_date)) last_trx_date, Trunc(Min(first_trx_date)) first_trx_date, Sum(on_hand) on_hand, Max(sum_on_hand) sum_on_hand, Sum(n_Value) n_Value FROM ( SELECT --msib.concatenated_segments item_code , fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_item', 'INV', 'MSTK', 101, MSIB.ORGANIZATION_ID, MSIB.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') item_code, moqd.organization_id, moqd.subinventory_code, inv_utilities.get_conc_segments(moqd.organization_id,moqd.locator_id) locator_code, moqd.inventory_item_id, --MIC.CATEGORY_CONCAT_SEGS item_category, fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_cat_field', 'INV', 'MCAT', MIC.STRUCTURE_ID, NULL, MIC.CATEGORY_ID, 'ALL', 'Y', 'VALUE') item_category, msib.description item_desc, Decode(is_consigned, 1, Decode (moqd.owning_tp_type, 1, (SELECT vendor_name || '-' || pvsa.vendor_site_code FROM po_vendors pv, po_vendor_sites_all pvsa WHERE pvsa.vendor_id = pv.vendor_id AND pvsa.vendor_site_id = moqd.owning_organization_id), 2, (SELECT(substr(hout.NAME,1,60)||'-'||substr(mp.ORGANIZATION_CODE,1,3)) Party FROM hr_organization_information hoi ,hr_all_organization_units_tl hout ,mtl_parameters mp WHERE hoi.organization_id = hout.organization_id AND hout.organization_id =mp.organization_id AND hout.language = userenv ('LANG') AND hoi.org_information1='OPERATING_UNIT' AND hoi.org_information2='Y' AND hoi.org_information_context='CLASS' AND hoi.organization_id= MOQD.owning_organization_id AND moqd.organization_id <> moqd.owning_organization_id) ) ,NULL) owing_party, --moqd.last_update_date last_trx_date, CASE :P_AGE_LEVEL when '1' then max(moqd.last_update_date) over(partition by moqd.organization_id,moqd.inventory_item_id,moqd.is_consigned,moqd.owning_tp_type,Decode(moqd.is_consigned,1,moqd.owning_organization_id,null)) when '2' THEN max(moqd.last_update_date) over(partition by moqd.organization_id,moqd.inventory_item_id,moqd.subinventory_code,moqd.is_consigned,moqd.owning_tp_type,Decode(moqd.is_consigned,1,moqd.owning_organization_id,null)) when '3' THEN max(moqd.last_update_date) over(partition by moqd.organization_id,moqd.inventory_item_id,moqd.subinventory_code,moqd.locator_id,moqd.is_consigned,moqd.owning_tp_type,Decode(moqd.is_consigned,1,moqd.owning_organization_id,null)) END last_trx_date, CASE :P_AGE_LEVEL when '1' then min(moqd.last_update_date) over(partition by moqd.organization_id,moqd.inventory_item_id,moqd.is_consigned,moqd.owning_tp_type,Decode(moqd.is_consigned,1,moqd.owning_organization_id,null)) when '2' THEN min(moqd.last_update_date) over(partition by moqd.organization_id,moqd.inventory_item_id,moqd.subinventory_code,moqd.is_consigned,moqd.owning_tp_type,Decode(moqd.is_consigned,1,moqd.owning_organization_id,null)) when '3' THEN min(moqd.last_update_date) over(partition by moqd.organization_id,moqd.inventory_item_id,moqd.subinventory_code,moqd.locator_id,moqd.is_consigned,moqd.owning_tp_type,Decode(moqd.is_consigned,1,moqd.owning_organization_id,null)) END first_trx_date, moqd.primary_transaction_quantity on_hand, CASE :P_AGE_LEVEL when '1' then sum(moqd.primary_transaction_quantity) over(partition by moqd.organization_id,moqd.inventory_item_id,moqd.is_consigned,moqd.owning_tp_type,Decode(moqd.is_consigned,1,moqd.owning_organization_id,null)) when '2' THEN sum(moqd.primary_transaction_quantity) over(partition by moqd.organization_id,moqd.inventory_item_id,moqd.subinventory_code,moqd.is_consigned,moqd.owning_tp_type,Decode(moqd.is_consigned,1,moqd.owning_organization_id,null)) when '3' THEN sum(moqd.primary_transaction_quantity) over(partition by moqd.organization_id,moqd.inventory_item_id,moqd.subinventory_code,moqd.locator_id,moqd.is_consigned,moqd.owning_tp_type,Decode(moqd.is_consigned,1,moqd.owning_organization_id,null)) END sum_on_hand, moqd.primary_transaction_quantity * INV_AGERPXML_PKG.f_unit_cost(moqd.organization_id, moqd.inventory_item_id,moqd.locator_id,moqd.cost_group_id,Nvl(moqd.orig_date_received,moqd.creation_date)) n_Value, msib.PRIMARY_UOM_CODE uom_code, INV_AGERPXML_PKG.f_bucket_days_heading(:P_BUCKETS_ID,Nvl(moqd.orig_date_received,moqd.creation_date)) buckets_days_heading --p_buckets_day --moqd.orig_date_received FROM mtl_onhand_quantities_detail moqd, MTL_SYSTEM_ITEMS_vl msib, MTL_ITEM_CATEGORIES_V MIC, MTL_SECONDARY_INVENTORIES_FK_V msiv, mtl_item_locations_kfv mil, CST_COST_GROUPS CCG WHERE moqd.organization_id = msib.organization_id AND moqd.inventory_item_id = msib.inventory_item_id AND moqd.organization_id = :P_ORG_ID AND msib.INVENTORY_ASSET_FLAG = Decode(:P_EXP_ITEM,'2','Y', msib.INVENTORY_ASSET_FLAG) AND msiv.organization_id = moqd.organization_id AND msiv.secondary_inventory_name = moqd.subinventory_code AND msiv.asset_inventory = Decode(:P_EXP_SUB,'2',1,msiv.asset_inventory) AND MOQD.COST_GROUP_ID = CCG.COST_GROUP_ID AND CCG.COST_GROUP BETWEEN NVL(:P_CG_FROM, CCG.COST_GROUP) AND NVL(:P_CG_TO, CCG.COST_GROUP) AND msib.organization_id = mic.organization_id AND msib.inventory_item_id = mic.inventory_item_id AND moqd.organization_id = mil.organization_id (+) AND moqd.locator_id = mil.inventory_location_id(+) AND mic.category_set_id = :P_CATEGORY_SET AND &P_ITEM_WHERE AND &P_CAT_WHERE ) GROUP BY organization_id, subinventory_code , locator_code, inventory_item_id, item_code, item_category, item_desc, uom_code, owing_party, INV_AGERPXML_PKG.f_bucket_days_seq(:P_BUCKETS_ID,buckets_days_heading), buckets_days_heading ) detail, AR_AGING_BUCKETS aab, AR_AGING_BUCKET_LINES_B AABL, --AR_AGING_BUCKET_LINES_vl for language AR_AGING_BUCKET_LINES_tl aablt WHERE aab.aging_type = 'INVENTORYAGE' AND aabl.aging_bucket_id = aab.aging_bucket_id AND aab.status = 'A' AND aablt.aging_bucket_line_id = aabl.aging_bucket_line_id AND aablt.LANGUAGE = userenv ('LANG') AND aab.aging_bucket_id = :P_BUCKETS_ID AND aabl.type ='INVENTORYAGE' ) WHERE bucket_seq not in (-99999,-99998) AND :CF_PROFILE = 'Y' GROUP BY organization_id, decode(:P_AGE_LEVEL,1,null,subinventory_code) , decode(:P_AGE_LEVEL,3,locator_code,null) , inventory_item_id, item_code, item_category, item_desc, uom_code, owing_party, buckets_days_heading, bucket_seq ORDER BY organization_id, subinventory_code, locator_code, bucket_seq, inventory_item_id, item_code, item_category, item_desc, uom_code, owing_party, buckets_days_heading INV INVAGERP_XML AR INV تقرير تقادم المخزون (1) Imported from BI Publisher Application: المخازن Source: تقرير تقادم المخزون (XML) Short Name: INVAGERP_XML DB package: INV_AGERPXML_PKG D INV Auswertung "Fälligkeit Bestand" (1) Imported from BI Publisher Application: Lager Source: Auswertung "Fälligkeit Bestand" (XML) Short Name: INVAGERP_XML DB package: INV_AGERPXML_PKG E INV Informe de Antigüedad de Inventario - XML(1) (2) Imported from BI Publisher Application: Inventory Source: Informe de Antigüedad de Inventario - XML(1) Short Name: INVAGERP_XML DB package: INV_AGERPXML_PKG F INV Etat d'ancienneté du stock (1) Imported from BI Publisher Application: Inventory Source: Etat d'ancienneté du stock (XML) Short Name: INVAGERP_XML DB package: INV_AGERPXML_PKG I INV Rapporto Scadenzario scorte (1) Imported from BI Publisher Application: Inventory Source: Rapporto Scadenzario scorte (XML) Short Name: INVAGERP_XML DB package: INV_AGERPXML_PKG JA INV 在庫年齢調べレポート (1) Imported from BI Publisher Application: Inventory Source: 在庫年齢調べレポート(XML) Short Name: INVAGERP_XML DB package: INV_AGERPXML_PKG KO INV 재고 경과연수 보고서 (1) Imported from BI Publisher Application: Inventory Source: 재고 경과연수 보고서(XML) Short Name: INVAGERP_XML DB package: INV_AGERPXML_PKG PTB INV Relatório de Aging do Inventário (1) Imported from BI Publisher Application: Inventário Source: Relatório de Aging do Inventário (XML) Short Name: INVAGERP_XML DB package: INV_AGERPXML_PKG RU INV Отчет о временном распределении запасов(1) (2) Imported from BI Publisher Application: Запасы Source: Отчет о временном распределении запасов (XML)(1) Short Name: INVAGERP_XML DB package: INV_AGERPXML_PKG S INV Rapport för åldersfördelning av lager (1) Imported from BI Publisher Application: Inventory Source: Rapport för åldersfördelning av lager (XML) Short Name: INVAGERP_XML DB package: INV_AGERPXML_PKG TR INV Envanter Yaşlandırma Raporu (1) Imported from BI Publisher Application: Stok Yönetimi Source: Envanter Yaşlandırma Raporu (XML) Short Name: INVAGERP_XML DB package: INV_AGERPXML_PKG US INV Inventory Aging Imported from BI Publisher Application: Inventory Source: Inventory Aging Report(XML) Short Name: INVAGERP_XML DB package: INV_AGERPXML_PKG ZHS INV 库存天数报表 (1) Imported from BI Publisher Application: 库存管理系统 Source: 库存天数报表 (XML) Short Name: INVAGERP_XML DB package: INV_AGERPXML_PKG BI Publisher 1=1 :l_profile :p_age_level :p_buckets_id :p_cat_from :p_cat_num :p_cat_set_where :p_cat_to :p_cat_where :p_category_set :p_cg_from :p_cg_to :p_conc_request_id :p_exp_item :p_exp_sub :p_item_from :p_item_to :p_item_where :p_locator_level :p_order_by :p_org_id :p_struct_num :p_sub_level :p_title 1 -30 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR Organization_Id معرف التنظيم D Organization_Id Organisationskennung E Organization_Id Id Organización F Organization_Id ID organisation I Organization_Id Id dell'organizzazione JA Organization_Id 組織ID KO Organization_Id 조직 ID PTB Organization_Id ID da Organização RU Organization_Id Идентификатор организации S Organization_Id Organisations-id TR Organization_Id Organizasyon No US Organization_Id Organization Id ZHS Organization_Id 组织标识 2 -20 :p_cat_num Number SELECT STRUCTURE_ID FROM MTL_CATEGORY_SETS WHERE CATEGORY_SET_ID = :$flex$.category_set Y AR هيكل الفئة هيكل الفئة D Kategoriestruktur Kategoriestruktur E Estructura de Categoría Estructura de Categoría F Structure de catégorie Structure de catégorie I Struttura categorie Struttura di categorie JA カテゴリ体系 カテゴリ体系 KO 범주 구조 범주 구조 PTB Estrutura da Categoria Estrutura da Categoria RU Структура категорий Структура категорий S Kategoristruktur Kategoristruktur TR Kategori Yapısı Kategori Yapısı US Category Structure Category Structure ZHS 类别结构 类别结构 3 -10 :debugflag Char N AR علامة معالجة الأخطاء علامة معالجة الأخطاء D DebugFlag DebugFlag E Depuración Depuración F Indicateur Diagnostic Indicateur Diagnostic I DebugFlag DebugFlag JA デバッグ・フラグ デバッグ・フラグ KO DebugFlag DebugFlag PTB DebugFlag DebugFlag RU DebugFlag DebugFlag S DebugFlag DebugFlag TR DebugFlag DebugFlag US DebugFlag DebugFlag ZHS DebugFlag DebugFlag 4 10 :p_title Char AR العنوان العنوان D Titel Titel E Título Título F Titre Titre I Titolo Titolo JA タイトル タイトル KO 제목 제목 PTB Título Título RU Заголовок Заголовок S Titel Titel TR Başlık Başlık US Title Title ZHS 标题 标题 5 20 :p_category_set LOV Oracle INV_SRS_CATEGORY_SET Y select category_set_id id, category_set_name value, description description from mtl_category_sets order by value,description SELECT CATEGORY_SET_NAME FROM MTL_CATEGORY_SETS A, MTL_DEFAULT_CATEGORY_SETS B WHERE B.FUNCTIONAL_AREA_ID = 5 AND A.CATEGORY_SET_ID = B.CATEGORY_SET_ID Y AR مجموعة الفئات مجموعة الفئات D KategorieSet KategorieSet E Juego de Categorías Juego de Categorías F Jeu de catégories Jeu de catégories I Serie categorie Serie di categorie JA カテゴリ・セット カテゴリ・セット KO 범주 세트 범주 세트 PTB Conjunto de Categorias Conjunto de categorias RU Набор категорий Набор категорий S Kategoriuppsättning Kategoriuppsättning TR Kategori Kümesi Kategori kümesi US Category Set Category set ZHS 类别集 类别集 6 30 :p_cat_from Char AR الفئة من الفئة من D Von Kategorie Von Kategorie E De Categoría De Categoría F Catégorie - De Catégorie - De I Categoria - Da Categoria - Da JA カテゴリ:自 カテゴリ:自 KO 범주 From 범주 From PTB Categoria - De Categoria - De RU Категория с Категория с S Från kategori Från kategori TR Kategori, İlk Kategori, İlk US Category From Category From ZHS 类别自 类别自 7 40 :p_cat_to Char AR الفئة إلى الفئة إلى D Bis Kategorie Bis Kategorie E A Categoría A Categoría F Catégorie - A Catégorie - A I Categoria - A Categoria - A JA カテゴリ:至 カテゴリ:至 KO 범주 To 범주 To PTB Categoria - Até Categoria - Até RU Категория по Категория по S Till kategori Till kategori TR Kategori, Son Kategori, Son US Category To Category To ZHS 类别至 类别至 8 50 :p_item_from Char AR الصنف من الصنف من D Von Artikel Von Artikel E De Artículo De Artículo F Article - De Article - De I Articolo - Da Articolo - Da JA 品目:自 品目:自 KO 품목 From 품목 From PTB Item - De Item - De RU Позиция с Позиция с S Från artikel Från artikel TR Kalem, İlk Kalem, İlk US Item From Item From ZHS 物料自 物料自 9 60 :p_item_to Char AR الصنف إلى الصنف إلى D Bis Artikel Bis Artikel E A Artículo A Artículo F Article - A Article - A I Articolo - A Articolo - A JA 品目:至 品目:至 KO 품목 To 품목 To PTB Item - Até Item - Até RU Позиция по Позиция по S Till artikel Till artikel TR Kalem, Son Kalem, Son US Item To Item To ZHS 物料至 物料至 10 70 :p_age_level LOV Oracle INV_AGE_LEVEL Y select lookup_code id, meaning value, meaning description from mfg_lookups where lookup_type='INVAGELEVEL' order by lookup_code SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'INVAGELEVEL' AND LOOKUP_CODE = 1 Y AR المستوى المستوى D Ebene Ebene E Nivel Nivel F Niveau Niveau I Livello Livello JA レベル レベル KO 레벨 레벨 PTB Nível Nível RU Уровень Уровень S Nivå Nivå TR Düzey Düzey US Level Level ZHS 层 层 11 80 :p_cg_from LOV Oracle CST_SRS_COST_GROUP_NAMES Y select ccg.cost_group id, ccg.cost_group value, ccg.description description from cst_cost_groups ccg,((select cost_group_id,organization_id from cst_cost_group_accounts) union (select default_cost_group_id cost_group_id,organization_id from mtl_parameters)) ccga where ccg.cost_group_id=ccga.cost_group_id and ccga.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and nvl(ccg.disable_date,sysdate+1)>sysdate order by cost_group AR مجموعة التكلفة من مجموعة التكلفة من D Von Kostengruppe Von Kostengruppe E De Grupo de Costes De Grupo de Costes F Groupe de coûts - De Groupe de coûts - De I Gruppo costi - Da Gruppo di costi - Da JA 原価グループ:自 原価グループ:自 KO 원가 그룹 From 원가 그룹 From PTB Grupo de Custos - De Grupo de Custos - De RU Группа затрат с Группа затрат с S Från kostnadsgrupp Från kostnadsgrupp TR Maliyet Grubu, İlk Maliyet Grubu, İlk US Cost Group From Cost Group From ZHS 成本组自 成本组自 12 90 :p_cg_to LOV Oracle CST_SRS_COST_GROUP_NAMES Y select ccg.cost_group id, ccg.cost_group value, ccg.description description from cst_cost_groups ccg,((select cost_group_id,organization_id from cst_cost_group_accounts) union (select default_cost_group_id cost_group_id,organization_id from mtl_parameters)) ccga where ccg.cost_group_id=ccga.cost_group_id and ccga.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and nvl(ccg.disable_date,sysdate+1)>sysdate order by cost_group AR مجموعة التكلفة إلى مجموعة التكلفة إلى D Bis Kostengruppe Bis Kostengruppe E A Grupo de Costes A Grupo de Costes F Groupe de coûts - A Groupe de coûts - A I Gruppo costi - A Gruppo di costi - A JA 原価グループ:至 原価グループ:至 KO 원가 그룹 To 원가 그룹 To PTB Grupo de Custos - Até Grupo de Custos - Até RU Группа затрат по Группа затрат по S Till kostnadsgrupp Till kostnadsgrupp TR Maliyet Grubu, Son Maliyet Grubu, Son US Cost Group To Cost Group To ZHS 成本组至 成本组至 13 100 :p_order_by LOV Oracle INV_AGERP_ORDER Y select lookup_code id, meaning value, meaning description from mfg_lookups where lookup_type='INVAGESORT' order by lookup_code Y AR ترتيب حسب ترتيب حسب D Sortieren nach Sortieren nach E Ordenar por Ordenar por F Tri par Tri par I Ordina per Ordina per JA ソート・キー ソート・キー KO 정렬 기준 정렬 기준 PTB Classificar por Classificar por RU Сортировка Сортировка S Ordna per Ordna per TR Sıralama Ölçütü Sıralama Ölçütü US Order By Order By ZHS 排序依据 排序依据 14 110 :p_buckets_id LOV Oracle INV_AGE_BUCKETS_DAY Y select aging_bucket_id id, bucket_name value, bucket_name description from ar_aging_buckets where aging_type='INVENTORYAGE' and status='A' order by value,description Y AR أيام الرزم أيام الرزم D Zeitraumtage Zeitraumtage E Días de Períodos Días de Períodos F Jours de regroupement Jours de regroupement I Giorni periodi fissi Giorni periodi fissi JA バケット日数 バケット日数 KO 버켓 일수 버켓 일수 PTB Dias do Período Dias do Período RU Интервал (дни) Интервал (дни) S Periodlängd i dagar Periodlängd i dagar TR Aralık Gün Sayısı Aralık Gün Sayısı US Buckets Days Buckets Days ZHS 时段天数 时段天数 15 120 :p_exp_item LOV Oracle INV_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by lookup_code SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE='SYS_YES_NO' AND LOOKUP_CODE=2 Y AR تضمين بنود المصروفات تضمين بنود المصروفات D Mit Aufwandsartikeln Mit Aufwandsartikeln E Incluir Conceptos de Gasto Incluir Conceptos de Gasto F Inclure les articles passés en charges Inclure les articles passés en charges I Includi articoli di spesa Include gli articoli di spesa JA 費用品目を含む 費用品目を含む KO 비용 품목 포함 비용 품목 포함 PTB Incluir Itens de Despesa Incluir Itens de Despesa RU Включить статьи расхода Включить статьи расхода S Inkludera utgiftsposter Inkludera utgiftsposter TR Gider Kalemlerini Dahil Et Gider Kalemlerini Dahil Et US Include Expense Items Include Expense Items ZHS 包括低值易耗品 包括低值易耗品 16 130 :p_exp_sub LOV Oracle INV_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by lookup_code SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'SYS_YES_NO' AND LOOKUP_CODE = 2 Y AR تضمين مخازن المصروفات تضمين مخازن المصروفات D Mit Aufwandslägern Mit Aufwandslägern E Incluir Subalmacenes de Gasto Incluir Subalmacenes de Gasto F Inclure les magasins passés en charges Inclure les magasins passés en charges I Includi sottomagazzini di spesa Include i sottomagazzini di spesa JA 保管場所費用を含む 保管場所費用を含む KO 비용 창고 포함 비용 창고 포함 PTB Incluir Subinventários de Despesas Incluir Subinventários de Despesas RU Включить складские подразделения расхода Включить складские подразделения расхода S Inkludera kostnadsförda lagerställen Inkludera kostnadsförda lagerställen TR Gider Stok Yerlerini Dahil Et Gider Stok Yerlerini Dahil Et US Include Expense Subinventories Include Expense Subinventories ZHS 包括费用子库存 包括费用子库存 :$flex$.category_set Category Set Category Structure