ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4702351A9E05362FB09050512 select ood.organization_code ORG_CODE, a.master_organization_id MASTER_ORG_ID, o1.organization_code MASTER_ORG_CD, o1.organization_name MASTER_ORG_NM, a.cost_organization_id COST_ORG_ID, o2.organization_code COST_ORG_CD, o2.organization_name COST_ORG_NM, a.source_organization_id SOURCE_ORG_ID, o3.organization_code SOURCE_ORG_CD, o3.organization_name SOURCE_ORG_NM, mfg1.meaning PRIMARY_COST_METHOD, br.resource_code DEFAULT_MATL_SUB_ELEM, mfg2.meaning NEGATIVE_BALANCE, mfg11.meaning GL_UPDATE_CODE, a.calendar_code CALENDAR_CODE, bom1.exception_set_name CALENDAR_EXCEPTION_SET_NAME, a.default_demand_class DEFAULT_DEMAND_CLASS, mfg12.meaning ENCUMBRANCE_REVERSAL_FLAG, mfg3.meaning LOCATOR_CONTROL, mfg4.meaning INTERORG_TRANSFER_CODE, DECODE(a.maintain_fifo_qty_stack_type, NULL,'',mfg6.meaning) MAINTAIN_FIFO_COST, mfg7.meaning SERIAL_NUMBER_TYPE, mfg8.meaning LOT_NUMBER_UNIQUENESS, mfg9.meaning LOT_NUMBER_GENERATION, DECODE(a.LOT_NUMBER_ZERO_PADDING, NULL, '' , mfg10.meaning) LOT_NUMBER_ZERO_PADDING, b.rule_name ATP_RULE_NAME, c.picking_rule_name PICKING_RULE_NAME, a.default_locator_order_value, a.default_subinv_order_value, a.interorg_trnsfr_charge_percent intorg_charge_percent, a.auto_serial_alpha_prefix, a.start_auto_serial_number, a.auto_lot_alpha_prefix, a.lot_number_length, mfg13.meaning SERIAL_GENERATION, mfg14.meaning SOURCE_TYPE, a.source_subinventory SOURCE_SUBINV, a.purchase_price_var_account PPV_flexid, &P_ppv_account PPV_flexdat, a.invoice_price_var_account IPV_flexid, &P_ipv_account IPV_flexdat, a.encumbrance_account ENCUMBRANCE_flexid, &P_encumbrance_acct ENCUMBRANCE_flexdat, a.expense_account EXPENSE_flexid, &P_expense_account EXPENSE_flexdat, a.sales_account SALES_flexid, &P_sales_account SALES_flexdat, a.material_account MATERIAL_flexid, null material_flexdat, a.material_overhead_account mat_burden_flexid, null mat_burden_flexdat, a.resource_account resource_flexid, null resource_flexdat, a.ap_accrual_account ap_accrual_flexid, null ap_accural_flexdat, a.overhead_account resource_ovh_flexid, null resource_ovh_flexdat, a.outside_processing_account value_added_flexid, null value_added_flexdat, a.intransit_inv_account intransit_flexid, null intransit_flexdat, a.interorg_receivables_account intorg_receivables_flexid, null intorg_receivables_flexdat, a.interorg_price_var_account intorg_ppv_flexid, null intorg_ppv_flexdat, a.interorg_payables_account intorg_payables_flexid, null intorg_payables_flexdat, a.cost_of_sales_account sales_cost_flexid, null sales_cost_flexdat, a.average_cost_var_account AVG_CST_VAR_flexid, &P_avg_cost_var_account AVG_CST_VAR_flexdat, a.interorg_transfer_cr_account intorg_transfer_flexid, null intorg_transfer_flexdat , a.starting_revision STARTING_REVISION, fnd_flex_xml_publisher_apis.process_kff_combination_1('f_intorg_transfer_flex', 'SQLGL', 'GL#', GLC_13.CHART_OF_ACCOUNTS_ID, NULL, GLC_13.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') F_INTORG_TRANSFER_FLEX, fnd_flex_xml_publisher_apis.process_kff_combination_1('f_intorg_payables_flex', 'SQLGL', 'GL#', GLC_11.CHART_OF_ACCOUNTS_ID, NULL, GLC_11.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') F_INTORG_PAYABLES_FLEX, fnd_flex_xml_publisher_apis.process_kff_combination_1('f_intransit_flex', 'SQLGL', 'GL#', GLC_8.CHART_OF_ACCOUNTS_ID, NULL, GLC_8.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') F_INTRANSIT_FLEX, fnd_flex_xml_publisher_apis.process_kff_combination_1('f_intorg_receivables_flex', 'SQLGL', 'GL#', GLC_9.CHART_OF_ACCOUNTS_ID, NULL, GLC_9.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') F_INTORG_RECEIVABLES_FLEX, fnd_flex_xml_publisher_apis.process_kff_combination_1('f_intorg_ppv_flex', 'SQLGL', 'GL#', GLC_10.CHART_OF_ACCOUNTS_ID, NULL, GLC_10.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') f_intorg_ppv_flex, fnd_flex_xml_publisher_apis.process_kff_combination_1('f_material_flex', 'SQLGL', 'GL#', GLC_1.CHART_OF_ACCOUNTS_ID, NULL, GLC_1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') F_MATERIAL_FLEX, fnd_flex_xml_publisher_apis.process_kff_combination_1('f_sales_cost_flex', 'SQLGL', 'GL#', GLC_12.CHART_OF_ACCOUNTS_ID, NULL, GLC_12.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') F_SALES_COST_FLEX, fnd_flex_xml_publisher_apis.process_kff_combination_1('f_ap_accrual_flex', 'SQLGL', 'GL#', GLC_5.CHART_OF_ACCOUNTS_ID, NULL, GLC_5.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') F_AP_ACCRUAL_FLEX, fnd_flex_xml_publisher_apis.process_kff_combination_1('f_mat_burden_flex', 'SQLGL', 'GL#', GLC_2.CHART_OF_ACCOUNTS_ID, NULL, GLC_2.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') F_MAT_BURDEN_FLEX, fnd_flex_xml_publisher_apis.process_kff_combination_1('f_resource_flex', 'SQLGL', 'GL#', GLC_4.CHART_OF_ACCOUNTS_ID, NULL, GLC_4.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') F_RESOURCE_FLEX, fnd_flex_xml_publisher_apis.process_kff_combination_1('f_resource_ovh_flex', 'SQLGL', 'GL#', GLC_6.CHART_OF_ACCOUNTS_ID, NULL, GLC_6.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') F_RESOURCE_OVH_FLEX, fnd_flex_xml_publisher_apis.process_kff_combination_1('f_value_added_flex', 'SQLGL', 'GL#', GLC_7.CHART_OF_ACCOUNTS_ID, NULL, GLC_7.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') F_VALUE_ADDED_FLEX, fnd_flex_xml_publisher_apis.process_kff_combination_1('f_ppv', 'SQLGL', 'GL#', GLC_14.CHART_OF_ACCOUNTS_ID, NULL, GLC_14.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') F_PPV, fnd_flex_xml_publisher_apis.process_kff_combination_1('f_ipv', 'SQLGL', 'GL#', GLC_15.CHART_OF_ACCOUNTS_ID, NULL, GLC_15.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') F_IPV, fnd_flex_xml_publisher_apis.process_kff_combination_1('f_encumbrance', 'SQLGL', 'GL#', GLC_16.CHART_OF_ACCOUNTS_ID, NULL, GLC_16.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') F_ENCUMBRANCE, fnd_flex_xml_publisher_apis.process_kff_combination_1('f_expense', 'SQLGL', 'GL#', GLC_17.CHART_OF_ACCOUNTS_ID, NULL, GLC_17.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') F_EXPENSE, fnd_flex_xml_publisher_apis.process_kff_combination_1('f_sales', 'SQLGL', 'GL#', GLC_18.CHART_OF_ACCOUNTS_ID, NULL, GLC_18.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') F_SALES, fnd_flex_xml_publisher_apis.process_kff_combination_1('f_avg_cst_var', 'SQLGL', 'GL#', GLC_19.CHART_OF_ACCOUNTS_ID, NULL, GLC_19.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') F_AVG_CST_VAR from mtl_parameters a, mtl_atp_rules b, mtl_picking_rules c, org_organization_definitions ood, org_organization_definitions o1, org_organization_definitions o2, org_organization_definitions o3, bom_resources br, bom_exception_sets bom1, mfg_lookups mfg1, mfg_lookups mfg2, mfg_lookups mfg3, mfg_lookups mfg4, mfg_lookups mfg6, mfg_lookups mfg7, mfg_lookups mfg8, mfg_lookups mfg9, mfg_lookups mfg10, mfg_lookups mfg11, mfg_lookups mfg12, mfg_lookups mfg13, mfg_lookups mfg14, gl_code_combinations glc_1, gl_code_combinations glc_2, gl_code_combinations glc_3, gl_code_combinations glc_4, gl_code_combinations glc_5, gl_code_combinations glc_6, gl_code_combinations glc_7, gl_code_combinations glc_8, gl_code_combinations glc_9, gl_code_combinations glc_10, gl_code_combinations glc_11, gl_code_combinations glc_12, gl_code_combinations glc_13, gl_code_combinations glc_14, gl_code_combinations glc_15, gl_code_combinations glc_16, gl_code_combinations glc_17, gl_code_combinations glc_18, gl_code_combinations glc_19 where a.organization_id = br.organization_id (+) and a.default_material_cost_id = br.resource_id (+) and a.master_organization_id = o1.organization_id (+) and a.cost_organization_id = o2.organization_id (+) and a.source_organization_id = o3.organization_id (+) and a.organization_id = ood.organization_id (+) and a.organization_id = :P_org_id and a.default_atp_rule_id = b.rule_id(+) and a.default_picking_rule_id = c.picking_rule_id(+) and mfg1.lookup_type (+) = 'MTL_PRIMARY_COST' and a.primary_cost_method = mfg1.lookup_code(+) and mfg2.lookup_type (+) = 'SYS_YES_NO' and a.negative_inv_receipt_code = mfg2.lookup_code(+) and mfg3.lookup_type (+) = 'MTL_LOCATION_CONTROL' and a.stock_locator_control_code = mfg3.lookup_code(+) and mfg4.lookup_type (+) = 'MTL_INTER_INV_TRANSFER' and a.matl_interorg_transfer_code = mfg4.lookup_code(+) and mfg6.lookup_type (+) = 'SYS_YES_NO' and a.maintain_fifo_qty_stack_type = mfg6.lookup_code(+) and mfg7.lookup_type (+) = 'MTL_SERIAL_NUMBER_TYPE' and a.serial_number_type = mfg7.lookup_code(+) and mfg8.lookup_type (+) = 'MTL_LOT_UNIQUENESS' and a.lot_number_uniqueness = mfg8.lookup_code(+) and mfg9.lookup_type (+) = 'MTL_LOT_GENERATION' and a.lot_number_generation = mfg9.lookup_code(+) and mfg10.lookup_type (+) = 'SYS_YES_NO' and a.lot_number_zero_padding = mfg10.lookup_code(+) and mfg11.lookup_type (+) = 'SYS_YES_NO' and decode(a.general_ledger_update_code,3,2,1) = mfg11.lookup_code(+) and mfg12.lookup_type (+) = 'SYS_YES_NO' and a.encumbrance_reversal_flag = mfg12.lookup_code(+) and mfg13.lookup_type (+) = 'MTL_SERIAL_GENERATION' and a.serial_number_generation = mfg13.lookup_code(+) and mfg14.lookup_type (+) = 'MTL_SOURCE_TYPES' and a.source_type = mfg14.lookup_code (+) and a.material_account = glc_1.code_combination_id (+) and a.material_overhead_account = glc_2.code_combination_id (+) and a.matl_ovhd_absorption_acct = glc_3.code_combination_id (+) and a.resource_account = glc_4.code_combination_id (+) and a.ap_accrual_account = glc_5.code_combination_id (+) and a.overhead_account = glc_6.code_combination_id (+) and a.outside_processing_account = glc_7.code_combination_id (+) and a.intransit_inv_account = glc_8.code_combination_id (+) and a.interorg_receivables_account = glc_9.code_combination_id (+) and a.interorg_price_var_account = glc_10.code_combination_id (+) and a.interorg_payables_account = glc_11.code_combination_id (+) and a.cost_of_sales_account = glc_12.code_combination_id (+) and a.interorg_transfer_cr_account = glc_13.code_combination_id (+) and a.purchase_price_var_account = glc_14.code_combination_id (+) and a.invoice_price_var_account = glc_15.code_combination_id (+) and a.encumbrance_account = glc_16.code_combination_id (+) and a.expense_account = glc_17.code_combination_id (+) and a.sales_account = glc_18.code_combination_id (+) and a.average_cost_var_account = glc_19.code_combination_id (+) and a.calendar_exception_set_id = bom1.exception_set_id (+) Y INV INVSROPT_XML Y AR INV قائمة معاملات التنظيم (بتنسيق XML) Imported from BI Publisher Description: قائمة معاملات التنظيمات Application: المخازن Source: قائمة معاملات التنظيم (بتنسيق XML) Short Name: INVSROPT_XML DB package: INV_INVSROPT_XMLP_PKG D INV Organisationsparameter - Liste Imported from BI Publisher Description: Organisationsparameter - Liste Application: Lager Source: Organisationsparameter - Liste (XML) Short Name: INVSROPT_XML DB package: INV_INVSROPT_XMLP_PKG E INV Listado de Parámetros de Organización Imported from BI Publisher Description: Listado de Parámetros de la Organización Application: Inventory Source: Listado de Parámetros de Organización (XML) Short Name: INVSROPT_XML DB package: INV_INVSROPT_XMLP_PKG F INV Liste des paramètres de l'organisation Imported from BI Publisher Description: Liste des paramètres de l'organisation Application: Inventory Source: Liste des paramètres de l'organisation (XML) Short Name: INVSROPT_XML DB package: INV_INVSROPT_XMLP_PKG I INV Elenco parametri organizzazione Imported from BI Publisher Description: Elenco parametri organizzazione Application: Inventory Source: Elenco parametri organizzazione (XML) Short Name: INVSROPT_XML DB package: INV_INVSROPT_XMLP_PKG JA INV 組織パラメータ・リスト Imported from BI Publisher Description: 組織パラメータ・リスト Application: Inventory Source: 組織パラメータ・リスト(XML) Short Name: INVSROPT_XML DB package: INV_INVSROPT_XMLP_PKG KO INV 조직 매개변수 목록 Imported from BI Publisher Description: 조직 매개변수 목록 Application: Inventory Source: 조직 매개변수 목록(XML) Short Name: INVSROPT_XML DB package: INV_INVSROPT_XMLP_PKG PTB INV Lista de parâmetros da organização Imported from BI Publisher Description: Lista de parâmetros da organização Application: Inventário Source: Lista de parâmetros da organização (XML) Short Name: INVSROPT_XML DB package: INV_INVSROPT_XMLP_PKG RU INV Список параметров организации Imported from BI Publisher Description: Список параметров организации Application: Запасы Source: Список параметров организации (XML) Short Name: INVSROPT_XML DB package: INV_INVSROPT_XMLP_PKG S INV Organisationsparametrar - lista Imported from BI Publisher Description: Organisationsparametrar - lista Application: Inventory Source: Organisationsparametrar - lista (XML) Short Name: INVSROPT_XML DB package: INV_INVSROPT_XMLP_PKG TR INV Organizayon parameterleri listeleme Imported from BI Publisher Description: Organizasyon parametreleri listesi Application: Stok Yönetimi Source: Organizayon parameterleri listeleme (XML) Short Name: INVSROPT_XML DB package: INV_INVSROPT_XMLP_PKG US INV Organization parameters listing Imported from BI Publisher Description: Organization parameters listing Application: Inventory Source: Organization parameters listing (XML) Short Name: INVSROPT_XML DB package: INV_INVSROPT_XMLP_PKG ZHS INV 组织参数列表 Imported from BI Publisher Description: 组织参数列表 Application: 库存管理系统 Source: 组织参数列表 (XML) Short Name: INVSROPT_XML DB package: INV_INVSROPT_XMLP_PKG BI Publisher &p_avg_cost_var_account &p_encumbrance_acct &p_expense_account &p_ipv_account &p_ppv_account &p_sales_account :p_ap_accrual_flexsql :p_avg_cost_var_account :p_conc_request_id :p_encumbrance_acct :p_expense_account :p_gl_struct_num :p_intorg_payables_flexsql :p_intorg_ppv_flexsql :p_intorg_receivables_flexsql :p_intorg_transfer_flexsql :p_intransit_flexsql :p_ipv_account :p_mat_burden_flexsql :p_material_flexsql :p_mburden_abs_flexsql :p_org_id :p_ppv_account :p_resource_flexsql :p_resource_ovh_flexsql :p_sales_account :p_sales_cost_flexsql :p_value_added_flexsql 1 -30 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR التنظيم التنظيم D Organisation Organisation E Organización Organización F Organisation Organisation I Organizzazione Organizzazione JA 組織 組織 KO 조직 조직 PTB Organização Organização RU Организация Организация S Organisation Organisation TR Organizasyon Organizasyon US Organization Organization ZHS 组织 组织 2 -20 :p_gl_struct_num Number select chart_of_accounts_id from org_organization_definitions where organization_id = fnd_profile.value('mfg_organization_id') Y AR رقم هيكل الأستاذ العام رقم هيكل الأستاذ العام D Konto-FlexFeld-Struktur Konto-FlexFeld-Struktur E Número de Estructura Contable Número de Estructura Contable F Numéro de structure GL Numéro de structure GL I Numero struttura GL Numero struttura GL JA GL体系番号 GL体系番号 KO GL 구조 번호 GL 구조 번호 PTB Número da Estrutura GL Número da Estrutura GL RU Номер структуры ГК Номер структуры ГК S RED-strukturnummer RED-strukturnummer TR GL Yapı Numarası GL Yapı Numarası US GL Structure Number GL Structure Number ZHS GL 结构编号 GL 结构编号