ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF1D3869E053B46B63588994Y SELECT C.ORGANIZATION_ID ORGANIZATION_ID , OFROM.ORGANIZATION_CODE FROM_ORG_CODE , OFROM.ORGANIZATION_NAME FROM_ORG_NAME , OTO.ORGANIZATION_CODE TO_ORG_CODE , OTO.ORGANIZATION_NAME TO_ORG_NAME , null ITEM_NUMBER , MSI.DESCRIPTION ITEM_DESC , MSI.PRIMARY_UOM_CODE UOM_CODE , null INTRANSIT_ACCT , null ADJUSTMENT_ACCT , ROUND(C.ADJUSTMENT_QUANTITY,:P_qty_precision) ADJUSTMENT_QUANTITY, C.OLD_UNIT_COST , C.NEW_UNIT_COST , ROUND(C.OLD_UNIT_COST * C.ADJUSTMENT_QUANTITY / :ROUND_UNIT) * :ROUND_UNIT OLD_EXTENDED_COST , ROUND(C.NEW_UNIT_COST * C.ADJUSTMENT_QUANTITY / :ROUND_UNIT) * :ROUND_UNIT NEW_EXTENDED_COST , (ROUND(C.NEW_UNIT_COST * C.ADJUSTMENT_QUANTITY / :ROUND_UNIT) - ROUND(C.OLD_UNIT_COST * C.ADJUSTMENT_QUANTITY / :ROUND_UNIT)) * :ROUND_UNIT ADJUSTMENT, fnd_flex_xml_publisher_apis.process_kff_combination_1('intransit_acct_pseg', 'SQLGL', 'GL#', CC1.CHART_OF_ACCOUNTS_ID, NULL, CC1.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') INTRANSIT_ACCT_PSEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('intransit_acct_seg', 'SQLGL', 'GL#', CC1.CHART_OF_ACCOUNTS_ID, NULL, CC1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') INTRANSIT_ACCT_SEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('intransit_acct_desc', 'SQLGL', 'GL#', CC1.CHART_OF_ACCOUNTS_ID, NULL, CC1.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') INTRANSIT_ACCT_DESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('adjustment_acct_seg', 'SQLGL', 'GL#', CC2.CHART_OF_ACCOUNTS_ID, NULL, CC2.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') ADJUSTMENT_ACCT_SEG, BOM_CSTRUSTA_XMLP_PKG.acc_adjustmentformula(:ACCOUNT_TOTAL) ACC_ADJUSTMENT, fnd_flex_xml_publisher_apis.process_kff_combination_1('item_pseg', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') ITEM_PSEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('item_segment', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') ITEM_SEGMENT FROM MTL_SYSTEM_ITEMS_VL MSI , ORG_ORGANIZATION_DEFINITIONS OFROM , ORG_ORGANIZATION_DEFINITIONS OTO , GL_CODE_COMBINATIONS CC1 , GL_CODE_COMBINATIONS CC2 , CST_STD_COST_ADJ_VALUES C WHERE C.COST_UPDATE_ID = :P_UPDATE_ID AND C.TRANSACTION_TYPE = 2 AND OFROM.ORGANIZATION_ID = C.FROM_ORGANIZATION_ID AND OTO.ORGANIZATION_ID = C.TO_ORGANIZATION_ID AND C.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND C.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND CC1.CODE_COMBINATION_ID = C.INTRANSIT_INV_ACCOUNT AND CC2.CODE_COMBINATION_ID = NVL(:P_ADJ_ACCOUNT, C.INTRANSIT_INV_ACCOUNT) and C.ORGANIZATION_ID=:OWNING_ORG_ID order by fnd_flex_xml_publisher_apis.process_kff_combination_1('intransit_acct_pseg', 'SQLGL', 'GL#', CC1.CHART_OF_ACCOUNTS_ID, NULL, CC1.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE'),OFROM.ORGANIZATION_CODE,OTO.ORGANIZATION_CODE,fnd_flex_xml_publisher_apis.process_kff_combination_1('item_pseg', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') BOM CSTCUSTA_XML AR CST تقرير تعديل تكلفة قياسي لعابر تاريخي (تنسيق XML) Application: شجرة المنتجات Source: تقرير تعديل تكلفة قياسي لعابر تاريخي (تنسيق XML) Short Name: CSTCUSTA_XML DB package: BOM_CSTRUSTA_XMLP_PKG D CST Historische Standardkostenkorrektur - Unterwegsbestand Application: Produktionsdaten Source: Historische Standardkostenkorrektur - Unterwegsbestand (XML) Short Name: CSTCUSTA_XML DB package: BOM_CSTRUSTA_XMLP_PKG F CST Etat Historique des ajustements de coûts standard des stocks en transit Application: Bills of Material Source: Etat Historique des ajustements de coûts standard des stocks en transit (XML) Short Name: CSTCUSTA_XML DB package: BOM_CSTRUSTA_XMLP_PKG US CST Historical Intransit Standard Cost Adjustment Application: Bills of Material Source: Historical Intransit Standard Cost Adjustment Report (XML) Short Name: CSTCUSTA_XML DB package: BOM_CSTRUSTA_XMLP_PKG ZHS CST 历史在途标准成本调整报表 Application: 物料清单管理系统 Source: 历史在途标准成本调整报表 (XML) Short Name: CSTCUSTA_XML DB package: BOM_CSTRUSTA_XMLP_PKG BI Publisher :account_total :owning_org_id :p_acct_seg1 :p_acct_seg2 :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_ext_prec :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_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_cost Char :$FLEX$.Date.COST_TYPE Y AR نوع التكلفة D Kostentyp F Type de coût US Cost Type ZHS 成本类型 4 40 :p_it Char :$FLEX$.Date.ITEM_RANGE Y AR مدى الصنف D Artikelbereich F Fourchette d'articles US Item Range ZHS 物料范围 5 50 :p_des Char :$FLEX$.Date.DESCRIPTION Y AR البيان D Beschreibung US Description ZHS 说明 6 60 :p_rpt_only Number 0 Y AR التقرير فقط D Nur Auswertung F Edition seule US Report only ZHS 仅限于报告 7 70 :p_del_snapshot Number 0 Y AR حذف اللقطة D SnapShot löschen F Suppr conso US Del Snapshot ZHS 删除快照