ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF1B3869E053B46B63588994 SELECT C.ORGANIZATION_ID CG_ORG_ID, CCG.COST_GROUP CG_COST_GROUP, CCG.DESCRIPTION CG_CG_DESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('item_seg', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') CG_ITEM_NUMBER, MSI.DESCRIPTION CG_ITEM_DESC, MSI.PRIMARY_UOM_CODE CG_UOM, null CG_MTL_ACCT, null CG_MOH_ACCT, null CG_RES_ACCT, null CG_OSP_ACCT, null CG_OVH_ACCT, null CG_ADJ_ACCT, ROUND(C.ADJUSTMENT_QUANTITY, :P_qty_precision) CG_ADJ_QUANTITY, C.COST_ELEMENT_ID CG_COST_ELEMENT_ID, SUBSTR(CE.COST_ELEMENT,1,15) CG_COST_ELEMENT, ROUND(C.OLD_UNIT_COST, :EXT_PREC) CG_OLD_UNIT_COST, ROUND(C.NEW_UNIT_COST, :EXT_PREC) CG_NEW_UNIT_COST, (ROUND(C.OLD_UNIT_COST * C.ADJUSTMENT_QUANTITY / :ROUND_UNIT) * :ROUND_UNIT) CG_OLD_EXT_COST, (ROUND(C.NEW_UNIT_COST * C.ADJUSTMENT_QUANTITY / :ROUND_UNIT) * :ROUND_UNIT) CG_NEW_EXT_COST, (ROUND(C.NEW_UNIT_COST * C.ADJUSTMENT_QUANTITY / :ROUND_UNIT) - ROUND(C.OLD_UNIT_COST * C.ADJUSTMENT_QUANTITY / :ROUND_UNIT)) * :ROUND_UNIT CG_ADJUSTMENT, DECODE(C.COST_ELEMENT_ID, 1, (ROUND(C.NEW_UNIT_COST*C.ADJUSTMENT_QUANTITY/:ROUND_UNIT)- ROUND(C.OLD_UNIT_COST*C.ADJUSTMENT_QUANTITY/:ROUND_UNIT))* :ROUND_UNIT ,0) CG_MAT_ADJ, DECODE(C.COST_ELEMENT_ID, 2, (ROUND(C.NEW_UNIT_COST*C.ADJUSTMENT_QUANTITY/:ROUND_UNIT)- ROUND(C.OLD_UNIT_COST*C.ADJUSTMENT_QUANTITY/:ROUND_UNIT))* :ROUND_UNIT ,0) CG_MOH_ADJ, DECODE(C.COST_ELEMENT_ID, 3, (ROUND(C.NEW_UNIT_COST*C.ADJUSTMENT_QUANTITY/:ROUND_UNIT)- ROUND(C.OLD_UNIT_COST*C.ADJUSTMENT_QUANTITY/:ROUND_UNIT))* :ROUND_UNIT ,0) CG_RES_ADJ, DECODE(C.COST_ELEMENT_ID, 4, (ROUND(C.NEW_UNIT_COST*C.ADJUSTMENT_QUANTITY/:ROUND_UNIT)- ROUND(C.OLD_UNIT_COST*C.ADJUSTMENT_QUANTITY/:ROUND_UNIT))* :ROUND_UNIT ,0) CG_OSP_ADJ, DECODE(C.COST_ELEMENT_ID, 5, (ROUND(C.NEW_UNIT_COST*C.ADJUSTMENT_QUANTITY/:ROUND_UNIT)- ROUND(C.OLD_UNIT_COST*C.ADJUSTMENT_QUANTITY/:ROUND_UNIT))* :ROUND_UNIT ,0) CG_OVH_ADJ, fnd_flex_xml_publisher_apis.process_kff_combination_1('cg_mtl_acct_seg', 'SQLGL', 'GL#', CC1.CHART_OF_ACCOUNTS_ID, NULL, CC1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') CG_MTL_ACCT_SEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('cg_moh_acct_seg', 'SQLGL', 'GL#', CC1.CHART_OF_ACCOUNTS_ID, NULL, CC1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') CG_MOH_ACCT_SEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('cg_res_acct_seg', 'SQLGL', 'GL#', CC1.CHART_OF_ACCOUNTS_ID, NULL, CC1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') CG_RES_ACCT_SEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('cg_osp_acct_seg', 'SQLGL', 'GL#', CC1.CHART_OF_ACCOUNTS_ID, NULL, CC1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') CG_OSP_ACCT_SEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('cg_ovh_acct_seg', 'SQLGL', 'GL#', CC1.CHART_OF_ACCOUNTS_ID, NULL, CC1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') CG_OVH_ACCT_SEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('cg_adj_acct_seg', 'SQLGL', 'GL#', CC1.CHART_OF_ACCOUNTS_ID, NULL, CC1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') CG_ADJ_ACCT_SEG, BOM_CSTRUSIW_XMLP_PKG.cg_cg_adjformula(:CG_CG_MTL, :CG_CG_MOH, :CG_CG_RES, :CG_CG_OSP, :CG_CG_OVH) CG_CG_ADJ, fnd_flex_xml_publisher_apis.process_kff_combination_1('cg_item_pseg', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') CG_ITEM_PSEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('cg_item_seg', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') CG_ITEM_SEG FROM MTL_SYSTEM_ITEMS_VL MSI, GL_CODE_COMBINATIONS CC1, GL_CODE_COMBINATIONS CC2, GL_CODE_COMBINATIONS CC3, GL_CODE_COMBINATIONS CC4, GL_CODE_COMBINATIONS CC5, GL_CODE_COMBINATIONS CC6, CST_COST_ELEMENTS CE, CST_COST_GROUP_ACCOUNTS CGA, MTL_PARAMETERS MP, CST_COST_GROUPS CCG, ORG_ORGANIZATION_DEFINITIONS OOD, CST_STD_COST_ADJ_VALUES C WHERE C.COST_UPDATE_ID = :P_UPDATE_ID AND OOD.ORGANIZATION_ID = C.ORGANIZATION_ID AND C.OLD_UNIT_COST != C.NEW_UNIT_COST AND CE.COST_ELEMENT_ID = C.COST_ELEMENT_ID AND C.COST_ELEMENT_ID > 0 AND C.TRANSACTION_TYPE = 1 AND C.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND C.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND C.COST_GROUP_ID = CCG.COST_GROUP_ID AND C.ORGANIZATION_ID = CGA.ORGANIZATION_ID AND C.COST_GROUP_ID = CGA.COST_GROUP_ID AND C.ORGANIZATION_ID = MP.ORGANIZATION_ID AND CC1.CODE_COMBINATION_ID = DECODE(CCG.COST_GROUP_ID, 1, MP.MATERIAL_ACCOUNT, CGA.MATERIAL_ACCOUNT) AND CC2.CODE_COMBINATION_ID = DECODE(CCG.COST_GROUP_ID, 1, MP.MATERIAL_OVERHEAD_ACCOUNT, CGA.MATERIAL_OVERHEAD_ACCOUNT) AND CC3.CODE_COMBINATION_ID = DECODE(CCG.COST_GROUP_ID, 1, MP.RESOURCE_ACCOUNT, CGA.RESOURCE_ACCOUNT) AND CC4.CODE_COMBINATION_ID = DECODE(CCG.COST_GROUP_ID, 1, MP.OUTSIDE_PROCESSING_ACCOUNT, CGA.OUTSIDE_PROCESSING_ACCOUNT) AND CC5.CODE_COMBINATION_ID = DECODE(CCG.COST_GROUP_ID, 1, MP.OVERHEAD_ACCOUNT, CGA.OVERHEAD_ACCOUNT) AND CC6.CODE_COMBINATION_ID = NVL(:P_ADJ_ACCOUNT, DECODE(CCG.COST_GROUP_ID, 1, MP.MATERIAL_ACCOUNT, CGA.MATERIAL_ACCOUNT)) and C.ORGANIZATION_ID=:ORGANIZATION_ID Y BOM CSTCUSIW_XML AR CST تقرير تعديل تكلفة قياسي لمخزون تاريخي - إدارة المستودع (تنسيق XML) Application: شجرة المنتجات Source: تقرير تعديل تكلفة قياسي لمخزون تاريخي - إدارة المستودع (تنسيق XML) Short Name: CSTCUSIW_XML DB package: BOM_CSTRUSIW_XMLP_PKG D CST Historische Standardkostenkorrektur - Lagerbestand - Lagerverwaltung Application: Produktionsdaten Source: Historische Standardkostenkorrektur - Lagerbestand - Lagerverwaltung (XML) Short Name: CSTCUSIW_XML DB package: BOM_CSTRUSIW_XMLP_PKG F CST Etat Historique des ajustements de coûts standard du stock - Gestion d'entrepôt Application: Bills of Material Source: Etat Historique des ajustements de coûts standard du stock - Gestion d'entrepôt (XML) Short Name: CSTCUSIW_XML DB package: BOM_CSTRUSIW_XMLP_PKG US CST Historical Inventory Standard Cost Adjustment Report - Warehouse Management Application: Bills of Material Source: Historical Inventory Standard Cost Adjustment Report - Warehouse Management (XML) Short Name: CSTCUSIW_XML DB package: BOM_CSTRUSIW_XMLP_PKG ZHS CST 历史库存标准成本调整报表 - 仓库管理 Application: 物料清单管理系统 Source: 历史库存标准成本调整报表 - 仓库管理 (XML) Short Name: CSTCUSIW_XML DB package: BOM_CSTRUSIW_XMLP_PKG BI Publisher :cg_cg_moh :cg_cg_mtl :cg_cg_osp :cg_cg_ovh :cg_cg_res :ext_prec :lp_cat_set_name :lp_gl_num :lp_item_range :lp_organization :lp_range_option :lp_sort_by :organization_id :p_acct_seg1 :p_acct_seg2 :p_acct_seg3 :p_acct_seg4 :p_acct_seg5 :p_acct_seg6 :p_adj_account :p_cat :p_cat_num :p_cat_seg :p_cat_set_name :p_category_set :p_conc_request_id :p_cost_type :p_cost_type_id :p_currency_code :p_del_snapshot :p_gl_num :p_item :p_item_from :p_item_range :p_item_seg :p_item_to :p_org_id :p_organization :p_qty_precision :p_range_option :p_rpt_only :p_sort_by :p_sort_option :p_trace :p_update_date :p_update_desc :p_update_id :round_unit 1 10 :p_org_id Number select fnd_profile.value('MFG_ORGANIZATION_ID') from dual Y US CST_SRS_NUMERIC_OPTION 2 20 :p_update_id LOV Oracle CST_SRS_COST_ADJ Y select c.cost_update_id id, to_char(c.update_date,'DD-MON-YY HH24:MI') value, null description from cst_cost_updates c,cst_cost_types ct,mfg_lookups lu,mtl_parameters mp where (c.organization_id=:$flex$.cst_srs_numeric_option or c.organization_id=mp.cost_organization_id) and mp.organization_id=:$flex$.cst_srs_numeric_option and c.snapshot_saved_flag=1 and c.status=3 and ct.cost_type_id=c.cost_type_id and lu.lookup_type= 'CST_ITEM_RANGE' and lu.lookup_code=c.range_option order by update_date desc Y AR التاريخ D Datum US Date ZHS 日期 3 30 :p_sort_option LOV Oracle CST_SRS_WMS_RPT_SORT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_ITEM_REPORT_SORT' and lookup_code in (1,2,8) order by lookup_code SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'CST_ITEM_REPORT_SORT' AND LOOKUP_CODE = 1 Y AR خيار الفرز D Sortieroption F Option de tri US Sort Option ZHS 排序选项 4 40 :p_cost Char :$FLEX$.Date.COST_TYPE Y AR نوع التكلفة D Kostentyp F Type de coût US Cost Type ZHS 成本类型 5 50 :p_it Char :$FLEX$.Date.ITEM_RANGE Y AR مدى الصنف D Artikelbereich F Fourchette d'articles US Item Range ZHS 物料范围 6 60 :p_des Char :$FLEX$.Date.DESCRIPTION Y AR البيان D Beschreibung US Description ZHS 说明 7 70 :p_rpt_only Number 0 Y AR التقرير فقط D Nur Auswertung F Edition seule US Report only ZHS 仅限于报告 8 80 :p_del_snapshot Number 0 Y AR حذف اللقطة D SnapShot löschen F Suppr conso US Del Snapshot ZHS 删除快照 :$FLEX$.Date.COST_TYPE Date Cost Type :$FLEX$.Date.DESCRIPTION Date Description :$FLEX$.Date.ITEM_RANGE Date Item Range :$flex$.cst_srs_numeric_option CST_SRS_NUMERIC_OPTION Date