ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEC879D2E0530100007F1FF2 GL Chart of Accounts (inv org related) Y select fifsv.id_flex_structure_name value, fifsv.id_flex_structure_code description from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 and fifsv.id_flex_num in (select ood.chart_of_accounts_id from org_organization_definitions ood where nvl(ood.disable_date,sysdate + 1) > sysdate) order by fifsv.id_flex_structure_name AR دليل الحسابات المتعلقة بمنظمات المخزون D Kontenplan für Bestandsorganisationen E Plan de cuentas relacionado con las organizaciones de inventario F Plan comptable relatif aux organismes d'inventaire I Piano dei conti relativo alle organizzazioni dell'inventario JA 棚卸し組織に関する勘定科目一覧表 KO 재고 조직과 관련된 계정과 목표 PTB Plano de contas relacionado às organizações de inventário RU План счетов организаций, занимающихся инвентаризацией S Kontoplan relaterade till lagerorganisationer TR Envanter organizasyonları ile ilgili hesap planı US Chart of accounts related to inventory organizations ZHS 与库存组织有关的会计科目表 8E2FF36EDF4079D2E0530100007F1FF2 GL Ledger (inv org related, coa dependent) Y select gl.name value, fifsv.id_flex_structure_name||': '||gl.description description from gl_sets_of_books gl, fnd_id_flex_structures_vl fifsv where gl.set_of_books_id in (select ood.set_of_books_id from org_organization_definitions ood where nvl(ood.disable_date,sysdate)>=sysdate) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, gl.name US All ledgers related to all active inventory organizations, dependent on chart of accounts - R12/R11 Compatible 8E2FF36EDECB79D2E0530100007F1FF2 INV Category Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mcv.structure_id order by mcv.category_concat_segs US 8E2FF36EDEF179D2E0530100007F1FF2 INV Item Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments US Inventory items, restricted to the accessible inventory organizations 8E2FF36EDEE179D2E0530100007F1FF2 INV Organization (ledger dependent) Y select ood.organization_code value, ood.organization_name description from gl_ledgers gl, org_organization_definitions ood where nvl(ood.disable_date,sysdate)>=sysdate and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and gl.ledger_id=ood.set_of_books_id order by ood.organization_code US AD9CE3F74024BD14E053B76B6358B68FY select distinct gl.name ledger, mp.organization_code, msiv.concatenated_segments item, msiv.description item_description, mck.concatenated_segments category, misv.inventory_item_status_code_tl item_status, muot.unit_of_measure_tl primary_uom, &columns round(sum(decode(cdcv.level_type,1,cdcv.item_cost,0)) over (partition by cdcv.organization_id, cdcv.inventory_item_id, &partition_by), fc.extended_precision) this_level, round(sum(decode(cdcv.level_type,2,cdcv.item_cost,0)) over (partition by cdcv.organization_id, cdcv.inventory_item_id, &partition_by), fc.extended_precision) prev_level, round(sum(cdcv.item_cost) over (partition by cdcv.organization_id, cdcv.inventory_item_id, &partition_by), fc.extended_precision) item_cost, 100*sum(cdcv.item_cost) over (partition by cdcv.organization_id, cdcv.inventory_item_id, &partition_by)/xxen_util.zero_to_null(sum(cdcv.item_cost) over (partition by cdcv.organization_id, cdcv.inventory_item_id)) percentage, round(sum(cdcv.item_cost) over (partition by cdcv.organization_id, cdcv.inventory_item_id), fc.extended_precision) item_cost_total from gl_ledgers gl, fnd_currencies fc, org_organization_definitions ood, mtl_parameters mp, mtl_system_items_vl msiv, mtl_units_of_measure_tl muot, mtl_item_status_vl misv, cst_detail_cost_view cdcv, cst_cost_types cct, mtl_category_sets_v mcsv, mtl_item_categories mic, mtl_categories_kfv mck where 1=1 and mcsv.category_set_name=:category_set_name and gl.currency_code=fc.currency_code and fc.enabled_flag='Y' and gl.ledger_id=ood.set_of_books_id and ood.organization_id=mp.organization_id and ood.organization_id=msiv.organization_id and msiv.primary_uom_code=muot.uom_code(+) and muot.language(+)=userenv('lang') and msiv.inventory_item_status_code=misv.inventory_item_status_code(+) and msiv.inventory_item_id=cdcv.inventory_item_id and mp.cost_organization_id=cdcv.organization_id and cdcv.cost_type_id=cct.cost_type_id and mcsv.category_set_id=mic.category_set_id and msiv.inventory_item_id=mic.inventory_item_id and msiv.organization_id=mic.organization_id and mic.category_id=mck.category_id order by ledger, organization_code, &order_by BOM AR CST تقارير تكاليف الأصناف (تنسيق XML) Application: شجرة المنتجات Source: تقارير تكاليف الأصناف (تنسيق XML) Short Name: CSTRFICRG_XML DB package: BOM_CSTRFICR_XMLP_PKG D CST Artikelkosten (3) Application: Produktionsdaten Source: Artikelkosten (XML) Short Name: CSTRFICRG_XML DB package: BOM_CSTRFICR_XMLP_PKG F CST Etats des coûts article (3) Application: Bills of Material Source: Etats des coûts article (XML) Short Name: CSTRFICRG_XML DB package: BOM_CSTRFICR_XMLP_PKG US CST Item Costs Flexible costing set of reports - analyze item costs for any cost type. Choose from the following options: Activity Summary - Report item costs by activity. Activity by Department - Report item costs by activity and department. Activity by Flexfield Segment Value - Report item costs by the descriptive flexfield segment you enter. Activity by Operation - Report item costs by activity and operation sequence number. Element - Report item costs by cost element and cost level. Element by Activity - Report item costs by cost element and activity. Element by Department - Report item costs by cost element and department. Element by Operation - Report item costs by cost element and operation sequence number. Element by Sub-Element - Report item costs by cost element and sub-element. Operation Summary by Level - Report item costs by operation sequence number and cost level. Operation by Activity - Report item costs by operation sequence number and activity. Operation by Sub-Element - Report item costs by operation sequence number and sub-element. Sub-Element - Report item costs by sub-element. Sub-Element by Activity - Report item costs by sub-element and activity. Sub-Element by Department - Report item costs by sub-element and department. Sub-Element by Flexfield Segment Value - Report item costs by the descriptive flexfield segment you enter. Sub-Element by Operation - Report item costs by sub-element and operation sequence number. ZHS CST 物料成本报表 (3) Application: 物料清单管理系统 Source: 物料成本报表 (XML) Short Name: CSTRFICRG_XML DB package: BOM_CSTRFICR_XMLP_PKG Draft &columns &order_by &partition_by 1=1 :category_set_name 1 10 &columns select crt.column1||' "'||crt.column1_heading||'",' from cst_report_types crt where crt.unique_id=:unique_id union all select crt.column2||' "'||crt.column2_heading||'",' from cst_report_types crt where crt.unique_id=:unique_id LOV Oracle CST_SRS_FLEX_REPORT Y select unique_id id, report_name value, description description from cst_report_types where nvl(disable_date,sysdate)>=sysdate order by report_name Y D Bericht F Nom de l'état I Nome rapporto US Report Name ZHS 报表名称 2 &partition_by select crt.column1||', '||crt.column2 from cst_report_types crt where crt.unique_id=:unique_id US Report Name 3 30 1=1 cct.cost_type=:cost_type LOV custom Y select cct.cost_type value, cct.description description from cst_cost_types cct where cct.cost_type_id not in (2,5,6) and nvl(cct.disable_date,sysdate)>=sysdate order by cct.cost_type select cct.cost_type from cst_cost_types cct where cct.cost_type_id = 1 Y D Kostentyp F Type de coût I Tipo di costo US Cost Type ZHS 成本类型 4 60 :category_set_name LOV custom Y select mcsv.category_set_name value, mcsv.description from mtl_category_sets_v mcsv where mcsv.mult_item_cat_assign_flag='N' and ( :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where regexp_like(:$flex$.organization_code,'(^|;)\s*'||xxen_util.regexp_escape(mp.organization_code)||'\s*(;|$)') and mp.organization_id=mic.organization_id) ) order by mcsv.category_set_name select mcsv.category_set_name from mtl_default_category_sets mdcs, mtl_category_sets_v mcsv where mdcs.functional_area_id=5 and mdcs.category_set_id=mcsv.category_set_id Y D KategorieSet F Jeu de catégories I Serie categorie US Category Set ZHS 类别集 5 70 1=1 mck.concatenated_segments>=:category_from LOV INV Category 8E2FF36EDECB79D2E0530100007F1FF2 Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mcv.structure_id order by mcv.category_concat_segs D Von Kategorie F Catégorie - De I Categoria - Da US Category From ZHS 类别自 6 80 1=1 mck.concatenated_segments<=:category_to LOV INV Category 8E2FF36EDECB79D2E0530100007F1FF2 Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mcv.structure_id order by mcv.category_concat_segs :$flex$.category_from US Category To 7 90 1=1 msiv.concatenated_segments>=:item_from LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments D Von Artikel F Article - De I Articolo - Da US Item From ZHS 物料自 8 100 1=1 msiv.concatenated_segments<=:item_to LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments :$flex$.item_from US Item To 9 120 1=1 mp.organization_code=:organization_code LOV INV Organization (ledger dependent) 8E2FF36EDEE179D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name description from gl_ledgers gl, org_organization_definitions ood where nvl(ood.disable_date,sysdate)>=sysdate and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and gl.ledger_id=ood.set_of_books_id order by ood.organization_code US Organization Code 10 130 1=1 gl.name=:ledger LOV GL Ledger (inv org related, coa dependent) 8E2FF36EDF4079D2E0530100007F1FF2 Y select gl.name value, fifsv.id_flex_structure_name||': '||gl.description description from gl_sets_of_books gl, fnd_id_flex_structures_vl fifsv where gl.set_of_books_id in (select ood.set_of_books_id from org_organization_definitions ood where nvl(ood.disable_date,sysdate)>=sysdate) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, gl.name select gl.name value from gl_ledgers gl where gl.ledger_id in (select ood.set_of_books_id from org_organization_definitions ood where nvl(ood.disable_date,sysdate)>=sysdate) and ( :$flex$.chart_of_accounts is null or gl.chart_of_accounts_id in (select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 and regexp_like(:$flex$.chart_of_accounts,'(^|;)\s*'||xxen_util.regexp_escape(fifsv.id_flex_structure_name)||'\s*(;|$)')) ) Y US Ledger 11 140 1=1 gl.chart_of_accounts_id in (select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_structure_name=:chart_of_accounts) LOV GL Chart of Accounts (inv org related) 8E2FF36EDEC879D2E0530100007F1FF2 Y select fifsv.id_flex_structure_name value, fifsv.id_flex_structure_code description from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 and fifsv.id_flex_num in (select ood.chart_of_accounts_id from org_organization_definitions ood where nvl(ood.disable_date,sysdate + 1) > sysdate) order by fifsv.id_flex_structure_name select fifsv.id_flex_structure_name from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 and fifsv.id_flex_num in (select ood.chart_of_accounts_id from org_organization_definitions ood where nvl(ood.disable_date,sysdate)>=sysdate) and fifsv.id_flex_num in (select oav.chart_of_accounts_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) Y US Chart of Accounts 12 150 &order_by item LOV Oracle CST_SRS_ITEMCAT_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) order by value,description 1 1 Y US Sort Option 13 &order_by category, item 2 US Sort Option