ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F8B51A9E05362FB09050512Y SELECT mmt.transaction_date Txn_date , &P_acct_flex C_acct_flex2 , &P_item_flex C_item_flex2 , msi.description Description , &C_type_option Type , mmt.transaction_source_type_id Type_id , mmt.organization_id Org_id , DECODE(mmt.transaction_source_type_id, 1,to_char(mmt.transaction_source_id), 2,&P_so_flex, 3,&P_gl_flex, 5,to_char(mmt.transaction_source_id), 6,&P_alias_flex, 7,to_char(mmt.transaction_source_id), 8,&P_so_flex, 9,to_char(mmt.transaction_source_id), 10,to_char(mmt.transaction_source_id), 11,to_char(mmt.transaction_source_id), 12,&P_so_flex, mmt.transaction_source_name) Source , decode(cal.accounted_dr,NULL,-1*mmt.periodic_primary_quantity,mmt.periodic_primary_quantity) Quantity , msi.primary_uom_code Primary_uom , round(cal.rate_or_amount * :P_EXCHANGE_RATE , :cp_ext_precision) Cost , nvl(nvl(cal.accounted_dr,-1*cal.accounted_cr),0) * :P_EXCHANGE_RATE Value ,cal.ae_line_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_pad2', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') C_item_pad2, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_field2', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_item_field2, BOM_CSTRPMDD_XMLP_PKG.c_item_value2_rformula(:C_item_value2) C_item_value2_R, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_pad2', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') C_acct_pad2, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_field2', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_acct_field2, BOM_CSTRPMDD_XMLP_PKG.c_quantity2formula(cal.ae_line_id, decode ( cal.accounted_dr , NULL , - 1 * mmt.periodic_primary_quantity , mmt.periodic_primary_quantity )) C_Quantity2, DECODE( mmt.transaction_source_type_id, 2, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_source', 'INV', 'MKTS', 101, NULL, MKTS.SALES_ORDER_ID, 'ALL', 'Y', 'VALUE') , 3, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_source1', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') , 6, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_source2', 'INV', 'MDSP', 101, MDSP.ORGANIZATION_ID, MDSP.DISPOSITION_ID, 'ALL', 'Y', 'VALUE') , 8, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_source', 'INV', 'MKTS', 101, NULL, MKTS.SALES_ORDER_ID, 'ALL', 'Y', 'VALUE') , 12, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_source', 'INV', 'MKTS', 101, NULL, MKTS.SALES_ORDER_ID, 'ALL', 'Y', 'VALUE') , BOM_CSTRPMDD_XMLP_PKG.C_SOURCEFORMULA(mmt.organization_id, mmt.transaction_source_type_id , mmt.transaction_source_id ) ) C_Source2, BOM_CSTRPMDD_XMLP_PKG.value2_rformula(nvl ( nvl ( cal.accounted_dr , - 1 * cal.accounted_cr ) , 0 ) * :P_EXCHANGE_RATE) Value2_R FROM cst_ae_headers cah , mtl_material_transactions mmt &C_from_cat , mtl_system_items msi , MTL_SALES_ORDERS mkts , MTL_GENERIC_DISPOSITIONS mdsp , gl_code_combinations glc &C_from_type , cst_ae_lines cal , gl_code_combinations gcc &C_source_from WHERE cah.ae_header_id = cal.ae_header_id AND cah.accounting_event_id = mmt.transaction_id AND cah.acct_event_source_table = 'MMT' AND cal.code_combination_id = gcc.code_combination_id AND mmt.inventory_item_id = msi.inventory_item_id AND msi.organization_id =( SELECT NVL(organization_id,-1) FROM cst_cost_groups WHERE cost_group_id = :P_cost_group_id) AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id) AND nvl(mmt.owning_tp_type,2) = 2 AND cah.cost_group_id = :P_cost_group_id AND cah.cost_type_id = :P_cost_type_id AND cah.period_id = :P_period_id AND &P_where_acct AND &P_where_item AND &P_where_cat &P_source_where2 &C_where_type &C_where_cat &C_source_where &C_where_value &C_where_reason AND (mmt.transaction_source_type_id = :P_source_type_id OR :P_source_type_id IS NULL) AND (mmt.transaction_type_id = :P_txn_type_id OR :P_txn_type_id IS NULL) AND mmt.transaction_source_id = mkts.sales_order_id(+) AND mmt.transaction_source_id = mdsp.disposition_id(+) AND mmt.transaction_source_id = glc.code_combination_id(+) UNION SELECT mmt.transaction_date Txn_date , &P_acct_flex C_acct_flex2 , &P_item_flex C_item_flex2 , msi.description Description , &C_type_option Type , mmt.transaction_source_type_id Type_id , mmt.organization_id Org_id , DECODE(mmt.transaction_source_type_id, 1,to_char(mmt.transaction_source_id), 2,&P_so_flex, 3,&P_gl_flex, 5,to_char(mmt.transaction_source_id), 6,&P_alias_flex, 7,to_char(mmt.transaction_source_id), 8,&P_so_flex, 9,to_char(mmt.transaction_source_id), 10,to_char(mmt.transaction_source_id), 11,to_char(mmt.transaction_source_id), 12,&P_so_flex, mmt.transaction_source_name) Source , decode(cal.accounted_dr,NULL,-1*mmt.periodic_primary_quantity,mmt.periodic_primary_quantity) Quantity , msi.primary_uom_code Primary_uom , round(cal.rate_or_amount * :P_EXCHANGE_RATE , :cp_ext_precision) Cost , nvl(nvl(cal.accounted_dr,-1*cal.accounted_cr),0) * :P_EXCHANGE_RATE Value ,cal.ae_line_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_pad2', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') C_item_pad2, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_field2', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_item_field2, BOM_CSTRPMDD_XMLP_PKG.c_item_value2_rformula(:C_item_value2) C_item_value2_R, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_pad2', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') C_acct_pad2, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_field2', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_acct_field2, BOM_CSTRPMDD_XMLP_PKG.c_quantity2formula(cal.ae_line_id, decode ( cal.accounted_dr , NULL , - 1 * mmt.periodic_primary_quantity , mmt.periodic_primary_quantity )) C_Quantity2, DECODE( mmt.transaction_source_type_id, 2, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_source', 'INV', 'MKTS', 101, NULL, MKTS.SALES_ORDER_ID, 'ALL', 'Y', 'VALUE') , 3, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_source1', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') , 6, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_source2', 'INV', 'MDSP', 101, MDSP.ORGANIZATION_ID, MDSP.DISPOSITION_ID, 'ALL', 'Y', 'VALUE') , 8, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_source', 'INV', 'MKTS', 101, NULL, MKTS.SALES_ORDER_ID, 'ALL', 'Y', 'VALUE') , 12, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_source', 'INV', 'MKTS', 101, NULL, MKTS.SALES_ORDER_ID, 'ALL', 'Y', 'VALUE') , BOM_CSTRPMDD_XMLP_PKG.C_SOURCEFORMULA(mmt.organization_id, mmt.transaction_source_type_id , mmt.transaction_source_id ) ) C_Source2, BOM_CSTRPMDD_XMLP_PKG.value2_rformula(nvl ( nvl ( cal.accounted_dr , - 1 * cal.accounted_cr ) , 0 ) * :P_EXCHANGE_RATE) Value2_R FROM cst_ae_headers cah , mtl_material_transactions mmt &C_from_cat , mtl_system_items msi , MTL_SALES_ORDERS mkts , MTL_GENERIC_DISPOSITIONS mdsp , gl_code_combinations glc &C_from_type , cst_ae_lines cal , gl_code_combinations gcc &C_source_from WHERE cah.ae_header_id = cal.ae_header_id AND cah.accounting_event_id = mmt.transaction_id AND cah.acct_event_source_table = 'MMT' AND cal.code_combination_id = gcc.code_combination_id AND mmt.inventory_item_id = msi.inventory_item_id AND msi.organization_id =( SELECT NVL(organization_id,-1) FROM cst_cost_groups WHERE cost_group_id = :P_cost_group_id) AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id) AND nvl(mmt.owning_tp_type,2) = 2 AND cah.cost_group_id = :P_cost_group_id AND cah.cost_type_id = :P_cost_type_id AND cah.period_id = :P_period_id AND &P_where_acct AND &P_where_item AND &P_where_cat &P_source_where2 &C_where_type &C_where_cat &C_source_where &C_where_value &C_where_reason AND (mmt.transaction_source_type_id = :P_source_type_id OR :P_source_type_id IS NULL) AND (mmt.transaction_type_id = :P_txn_type_id OR :P_txn_type_id IS NULL) AND mmt.transaction_source_id = mkts.sales_order_id(+) AND mmt.transaction_source_id = mdsp.disposition_id(+) AND mmt.transaction_source_id = glc.code_combination_id(+) UNION ALL SELECT rt.transaction_date Txn_date , &P_acct_flex C_acct_flex2 , &P_item_flex C_item_flex2 , msi.description Description , &C_rt_type_option Type , 0 Type_id , 0 Org_id , null Source , decode(cal.accounted_dr,NULL,-1*rt.primary_quantity,rt.primary_quantity) Quantity , msi.primary_uom_code Primary_uom , round(cal.rate_or_amount * :P_EXCHANGE_RATE , :cp_ext_precision) Cost , nvl(nvl(cal.accounted_dr,-1*cal.accounted_cr),0) * :P_EXCHANGE_RATE Value ,cal.ae_line_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_pad2', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') C_item_pad2, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_field2', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_item_field2, BOM_CSTRPMDD_XMLP_PKG.c_item_value2_rformula(:C_item_value2) C_item_value2_R, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_pad2', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') C_acct_pad2, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_field2', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_acct_field2, --BOM_CSTRPMDD_XMLP_PKG.c_quantity2formula(cal.ae_line_id, decode ( cal.accounted_dr , NULL , - 1 * mmt.primary_quantity , mmt.primary_quantity )) C_Quantity2, null C_Quantity2, null C_Source2, BOM_CSTRPMDD_XMLP_PKG.value2_rformula(nvl ( nvl ( cal.accounted_dr , - 1 * cal.accounted_cr ) , 0 ) * :P_EXCHANGE_RATE) Value2_R FROM cst_ae_headers cah , cst_ae_lines cal , mtl_system_items msi , rcv_transactions rt , rcv_shipment_lines rsl , gl_code_combinations gcc &C_from_cat WHERE cah.ae_header_id = cal.ae_header_id AND cah.accounting_event_id = rt.transaction_id AND cah.acct_event_source_table = 'RT' AND cal.code_combination_id = gcc.code_combination_id AND rt.shipment_line_id = rsl.shipment_line_id AND NVL(rt.consigned_flag,'N') = 'N' AND rsl.item_id = msi.inventory_item_id(+) AND cah.organization_id = msi.organization_id AND cah.cost_group_id = :P_cost_group_id AND cah.cost_type_id = :P_cost_type_id AND cah.period_id = :P_period_id AND &P_where_acct AND &P_where_item AND &P_where_cat &C_rt_where_cat &C_where_value &C_rt_where_reason UNION ALL SELECT rae.transaction_date Txn_date , &P_acct_flex C_acct_flex2 , &P_item_flex C_item_flex2 , msi.description Description ,decode(:P_type_option,1,rt.source_document_code, decode(rae.event_type_id,18,raet.description, 19,raet.description, 20,raet.description, raet.event_type_name)) Type , 0 Type_id , 0 Org_id , null Source , decode(cal.accounted_dr,NULL,-1*rae.primary_quantity,rae.primary_quantity) Quantity , msi.primary_uom_code Primary_uom , round(cal.rate_or_amount * :P_EXCHANGE_RATE , :cp_ext_precision) Cost , nvl(nvl(cal.accounted_dr,-1*cal.accounted_cr),0) * :P_EXCHANGE_RATE Value ,cal.ae_line_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_pad2', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') C_item_pad2, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_field2', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_item_field2, BOM_CSTRPMDD_XMLP_PKG.c_item_value2_rformula(:C_item_value2) C_item_value2_R, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_pad2', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') C_acct_pad2, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_field2', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_acct_field2, --BOM_CSTRPMDD_XMLP_PKG.c_quantity2formula(cal.ae_line_id, decode ( cal.accounted_dr , NULL , - 1 * mmt.primary_quantity , mmt.primary_quantity )) C_Quantity2, null C_Quantity2, null C_Source2, BOM_CSTRPMDD_XMLP_PKG.value2_rformula(nvl ( nvl ( cal.accounted_dr , - 1 * cal.accounted_cr ) , 0 ) * :P_EXCHANGE_RATE) Value2_R FROM cst_ae_headers cah , cst_ae_lines cal , mtl_system_items msi , rcv_transactions rt , rcv_accounting_events rae , rcv_shipment_lines rsl , gl_code_combinations gcc , rcv_accounting_event_types raet &C_from_cat WHERE cah.ae_header_id = cal.ae_header_id AND cah.accounting_event_id = rae.accounting_event_id AND rae.rcv_transaction_id = rt.transaction_id AND cah.acct_event_source_table = 'RAE' AND cal.code_combination_id = gcc.code_combination_id AND rt.shipment_line_id = rsl.shipment_line_id AND NVL(rt.consigned_flag,'N') = 'N' AND rsl.item_id = msi.inventory_item_id(+) AND cah.organization_id = msi.organization_id AND cah.cost_group_id = :P_cost_group_id AND cah.cost_type_id = :P_cost_type_id AND cah.period_id = :P_period_id AND raet.event_type_id = rae.event_type_id AND &P_where_acct AND &P_where_item AND &P_where_cat &C_rt_where_cat &C_where_value &C_rt_where_reason ORDER BY 2 asc , 1 asc , 3 asc , 5 asc , 7 asc , 8 asc , 9 asc , 11 asc BOM CSTRPMDD_XML AR CST تقرير تفاصيل توزيع المواد والاستلام الدوري (تنسيق XML) Imported from BI Publisher Description: تقرير تفاصيل توزيعات المواد وحساب الاستلام الدوري Application: شجرة المنتجات Source: تقرير تفاصيل توزيع المواد والاستلام الدوري (تنسيق XML) Short Name: CSTRPMDD_XML DB package: BOM_CSTRPMDD_XMLP_PKG D CST Periodische Aufteilung - Details Material und Wareneingang Imported from BI Publisher Description: Periodische Kontenaufteilungen - Details Material und Wareneingang Application: Produktionsdaten Source: Periodische Aufteilung - Details Material und Wareneingang (XML) Short Name: CSTRPMDD_XML DB package: BOM_CSTRPMDD_XMLP_PKG E CST Detalles de Distribución Periódica de Recepción y Material Imported from BI Publisher Description: Informe Detalles de Distribución Periódica de Cuentas de Recepción y Material Application: Bills of Material Source: Detalles de Distribución Periódica de Recepción y Material (XML) Short Name: CSTRPMDD_XML DB package: BOM_CSTRPMDD_XMLP_PKG F CST Etat Détail des imputations matières et de réception périodiques Imported from BI Publisher Description: Etat détaillé des imputations matières et de réception périodiques Application: Bills of Material Source: Etat Détail des imputations matières et de réception périodiques (XML) Short Name: CSTRPMDD_XML DB package: BOM_CSTRPMDD_XMLP_PKG I CST Rapporto Dettagli distribuzione conti di ricezione e materiali periodica Imported from BI Publisher Description: Rapporto periodico sui dettagli delle distribuzioni dei conti di ricezione e dei materiali Application: Bills of Material Source: Rapporto Dettagli distribuzione conti di ricezione e materiali periodica (XML) Short Name: CSTRPMDD_XML DB package: BOM_CSTRPMDD_XMLP_PKG JA CST 期間資材および受入配分詳細レポート Imported from BI Publisher Description: 期間資材および受入勘定科目配分詳細レポート Application: Bills of Material Source: 期間資材および受入配分詳細レポート(XML) Short Name: CSTRPMDD_XML DB package: BOM_CSTRPMDD_XMLP_PKG KO CST 기간별 자재 및 입고 분배 상세내역 보고서 Imported from BI Publisher Description: 기간별 자재 및 입고 분배 상세내역 보고서 Application: Bills of Material Source: 기간별 자재 및 입고 분배 상세내역 보고서(XML) Short Name: CSTRPMDD_XML DB package: BOM_CSTRPMDD_XMLP_PKG PTB CST Relatório Periódico Detalhado de Distribuição de Material e Recebimento Imported from BI Publisher Description: Relatório periódico detalhado de distribuições de conta de material e de recebimento Application: Bills of Material Source: Relatório Periódico Detalhado de Distribuição de Material e Recebimento (XML) Short Name: CSTRPMDD_XML DB package: BOM_CSTRPMDD_XMLP_PKG RU CST Подробный отчет о периодических распределениях материалов и получения Imported from BI Publisher Description: Подробный отчет о периодических распределениях счетов материалов и получения Application: Спецификации Source: Подробный отчет о периодических распределениях материалов и получения (XML) Short Name: CSTRPMDD_XML DB package: BOM_CSTRPMDD_XMLP_PKG S CST Periodisk kontering av material och inleveranser - detaljrapport Imported from BI Publisher Description: Detaljer för periodiska konteringar av material och inleveranser - rapport Application: Bills of Material Source: Periodisk kontering av material och inleveranser - detaljrapport (XML) Short Name: CSTRPMDD_XML DB package: BOM_CSTRPMDD_XMLP_PKG TR CST Dönemsel Malzeme ve Dağıtım Alma Detayları Raporu Imported from BI Publisher Description: Dönemsel malzeme ve hesap dağıtımları alma detay raporu Application: Ürün Ağacı Source: Dönemsel Malzeme ve Dağıtım Alma Detayları Raporu (XML) Short Name: CSTRPMDD_XML DB package: BOM_CSTRPMDD_XMLP_PKG US CST Periodic Material and Receiving Distribution Details Imported from BI Publisher Description: Periodic material and receiving account distributions details report Application: Bills of Material Source: Periodic Material and Receiving Distribution Details Report (XML) Short Name: CSTRPMDD_XML DB package: BOM_CSTRPMDD_XMLP_PKG ZHS CST 定期物料和接收分配明细报表 Imported from BI Publisher Description: 定期物料和接收帐户分配明细报表 Application: 物料清单管理系统 Source: 定期物料和接收分配明细报表 (XML) Short Name: CSTRPMDD_XML DB package: BOM_CSTRPMDD_XMLP_PKG BI Publisher &c_from_cat &c_from_type &c_rt_type_option &c_rt_where_cat &c_rt_where_reason &c_source_from &c_source_where &c_type_option &c_where_cat &c_where_reason &c_where_type &c_where_value &p_acct_flex &p_alias_flex &p_gl_flex &p_item_flex &p_so_flex &p_source_where2 &p_where_acct &p_where_cat &p_where_item :c_item_value2 :cp_application :cp_cost_group :cp_cost_type :cp_ext_precision :cp_legal_entity :cp_period_name :cp_precision :cp_request_time :cp_requested_by :cp_responsibility :cp_sort_by_cov :cp_type_option_cov :p_acct_flex :p_acct_hi :p_acct_lo :p_acct_sort :p_acct_struct_num :p_alias_flex :p_cat_hi :p_cat_lo :p_cat_set_id :p_cat_struct_num :p_cbo_flag :p_conc_request_id :p_cost_group_id :p_cost_type_id :p_currency_code :p_exchange_rate :p_gl_flex :p_item_flex :p_item_hi :p_item_lo :p_item_sort :p_legal_entity_id :p_period_id :p_quantity_precision :p_reason_id :p_so_flex :p_sort_id :p_source_hi :p_source_lo :p_source_type_id :p_source_where :p_source_where2 :p_struct_num :p_trace_flag :p_txn_type_id :p_type_option :p_value_hi :p_value_lo :p_where_acct :p_where_cat :p_where_item :qty_precision 1 -70 :p_acct_struct_num LOV Oracle CST_SRS_PAC_AP_COAID_BY_LECT Y select chart_of_accounts_id id, chart_of_accounts_id value, null description from gl_sets_of_books where set_of_books_id in (select set_of_books_id from cst_le_cost_types where cost_type_id=:$flex$.cst_srs_pac_ct_proc and legal_entity=:$flex$.cst_srs_pac_ap_le ) order by value,description SELECT chart_of_accounts_id FROM gl_sets_of_books WHERE set_of_books_id IN (SELECT set_of_books_id FROM cst_le_cost_types WHERE legal_entity = :$flex$.legal_entity and cost_type_id = :$flex$.cost_type) Y AR معرف جدول تصنيف الحسابات معرف جدول تصنيف الحسابات - معامل مخفي D Kontenplankennung Kontenplan - verborgenes Feld E Id Plan de Cuentas Identificador de Plan de Cuentas: Parámetro oculto F ID plan de comptes ID plan de comptes - paramètre caché I ID piano dei conti ID piano dei conti - parametro nascosto JA 勘定体系ID 勘定体系ID - 隠しパラメータ KO 계정 코드집 ID 계정 코드집 ID - 숨은 매개변수 PTB ID do Plano de Contas ID do plano de contas - parâmetro oculto RU Идентификатор плана счетов Идентификатор плана счетов - скрытый параметр S Kontoplans-id Kontoplans-id - dold parameter TR Hesap Planı No Hesap planı no - gizli parametre US Chart of Accounts ID Chart of account ID - hidden parameter ZHS 科目表标识 科目表标识 - 隐藏参数 2 -60 :p_master_org_id Number SELECT organization_id FROM cst_cost_groups WHERE cost_group_id = :$flex$.organization_cost_group Y AR معرف التنظيم الرئيسي معرف التنظيم الرئيسي - معامل مخفي D Kennung Hauptorganisation Kennung Hauptorganisation - verborgener Parameter E Id Organización Maestra Identificador de Organización Maestra - parámetro oculto F ID organisation principale ID organisation principale - paramètre caché I Id organizzazione principale ID dell'organizzazione principale - parametro nascosto JA マスター組織ID マスター組織ID - 隠しパラメータ KO 마스터 조직 ID 마스터 조직 ID - 숨은 매개변수 PTB ID da Organização-Mestre ID da Organização-Mestre - parâmetro oculto RU Идентификатор главной организации Идентификатор главной организации (скрытый параметр) S Huvudorganisations-id Huvudorganisations-id - dold parameter TR Ana Organizasyon No Ana Organizasyon No - gizli parametre US Master Organization ID Master Organization ID - hidden parameter ZHS 主组织标识 主组织 - 隐藏参数 3 -50 :p_cat_struct_num Number select structure_id from mtl_category_sets where category_set_id = nvl(:$flex$.category_set,null) Y AR هيكل الفئة معفر هيكل الفئات D Kategoriestruktur Strukturkennung für Kategorien E Estructura de Categoría Identificador de Estructura para Categorías F Structure de catégorie ID structure pour catégories I Struttura categoria ID struttura per categorie JA カテゴリ体系 カテゴリ用体系ID KO 범주 구조 범주의 구조 ID PTB Estrutura da Categoria ID da Estrutura para categorias RU Структура категорий Идентификатор структуры для категорий S Kategoristruktur Struktur-id för kategorier TR Kategori Yapısı Kategoriler için yapı no US Category Structure Structure ID for categories ZHS 类别结构 类别的结构标识 4 -40 :p_inverse_rate Char fnd_profile.value('DISPLAY_INVERSE_RATE') Y AR CST_SRS_INVERSE_RATE سعر عكسي - حقل مخفي D CST_SRS_INVERSE_RATE Kehrwert - verborgenes Feld E CST_SRS_INVERSE_RATE Tipo de Cambio Inverso: Campo oculto F CST_SRS_INVERSE_RATE Taux inverse - champ masqué I CST_SRS_INVERSE_RATE Tasso inverso - campo nascosto JA CST_SRS_INVERSE_RATE 逆算レート - 隠しフィールド KO CST_SRS_INVERSE_RATE 역산율 - 비공개 필드 PTB CST_SRS_INVERSE_RATE Estornar taxa - campo oculto RU CST_SRS_INVERSE_RATE Обратный курс (скрытое поле) S CST_SRS_INVERSE_RATE Inverterad takt - dolt fält TR CST_SRS_INVERSE_RATE Ters kur - gizli alan US CST_SRS_INVERSE_RATE Inverse rate - hiden field ZHS CST_SRS_INVERSE_RATE 逆汇率 - 隐藏字段 5 -30 :p_rate_type Number fnd_profile.value('CST_EXCHANGE_RATE_TYPE') Y AR CST_SRS_RATE_TYPE نوع السعر - حقل مخفي D CST_SRS_RATE_TYPE Kursart - verborgenes Feld E CST_SRS_RATE_TYPE Clase de Tipo de Cambio - campo oculto F CST_SRS_RATE_TYPE Type de taux - champ masqué I CST_SRS_RATE_TYPE Tipo di tasso - campo nascosto JA CST_SRS_RATE_TYPE レート・タイプ - 隠しフィールド KO CST_SRS_RATE_TYPE 비율 유형 - 숨은 필드 PTB CST_SRS_RATE_TYPE Tipo de taxa - campo oculto RU CST_SRS_RATE_TYPE Тип курса (скрытое поле) S CST_SRS_RATE_TYPE Kurstyp - dolt fält TR CST_SRS_RATE_TYPE Kur tipi - gizli alan US CST_SRS_RATE_TYPE Rate type - hidden field ZHS CST_SRS_RATE_TYPE 汇率类型 - 隐藏字段 6 -20 :p_quantity_precision LOV Oracle INV_SRS_PRECISION Y select lookup_code id, lookup_code value, meaning description from mfg_lookups where lookup_type='INV_SRS_PRECISION' and enabled_flag='Y' order by lookup_code fnd_profile.value('REPORT_QUANTITY_PRECISION') Y AR دقة الكمية دقة الكمية D Nachkommastellen Nachkommastellen E Precisión de Cantidad Precisión de Cantidad F Précision des quantités Précision des quantités I Precisione quantità Precisione quantità JA 数量精度 数量精度 KO 수량 소수점 이하 자리수 수량 소수점이하 자리수 PTB Precisão da Quantidade Precisão da quantidade RU Точность количества Точность количества S Kvantitetsprecision Kvantitetsprecision TR Miktar Duyarlılığı Miktar duyarlılığı US Quantity Precision Quantity precision ZHS 数量精确度 数量精确度 7 10 :p_legal_entity_id LOV Oracle CST_SRS_PAC_AP_LE Y select legal_entity_id id, name value, null description from xle_firstparty_information_v where legal_entity_id in (select distinct legal_entity from cst_le_cost_types where create_acct_entries='Y') order by value,description Y AR الكيان القانوني كيان قانوني D Mandant Mandant E Entidad Legal Entidad Legal F Entité juridique Entité juridique I Persona giuridica Persona giuridica JA 法的エンティティ 法的エンティティ KO 법인 법인 PTB Pessoa Jurídica Pessoa jurídica RU Юридическое лицо Юридическое лицо S Juridisk enhet Juridisk enhet TR Tüzel Kişilik Tüzel kişilik US Legal Entity Legal entity ZHS 法人主体 法人主体 8 20 :p_cost_type_id LOV Oracle CST_SRS_PAC_CT_PROC Y select ct.cost_type_id id, ct.cost_type value, null description from cst_cost_types ct where ct.cost_type_id in (select distinct cost_type_id from cst_le_cost_types where legal_entity=:$flex$.cst_srs_pac_ap_le and create_acct_entries='Y') and exists (select 1 from cst_pac_periods where pac_period_id in (select pac_period_id from cst_pac_process_phases where process_phase=6 and process_status=4) and cost_type_id=ct.cost_type_id) and nvl(disable_date,sysdate+1)>sysdate order by value,description Y AR نوع التكلفة نوع التكلفة D Kostentyp Kostentyp E Tipo de Coste Tipo de Coste F Type de coût Type de coût I Tipo di costo Tipo di costo JA 原価タイプ 原価タイプ KO 원가 유형 원가 유형 PTB Tipo de Custo Tipo de custo RU Тип затрат Тип затрат S Kostnadstyp Kostnadstyp TR Maliyet Tipi Maliyet tipi US Cost Type Cost type ZHS 成本类型 成本类型 9 30 :p_cost_group_id LOV Oracle CST_SRS_PAC_CG_PROC Y select ccg.cost_group_id id, ccg.cost_group value, null description from cst_cost_groups ccg where ccg.legal_entity=:$flex$.cst_srs_pac_ap_le and exists (select 1 from cst_pac_periods cpp where legal_entity=:$flex$.cst_srs_pac_ap_le and cost_type_id=:$flex$.cst_srs_pac_ct_proc and cpp.pac_period_id in (select cppp.pac_period_id from cst_pac_process_phases cppp where cppp.cost_group_id=ccg.cost_group_id and process_phase=6 and process_status=4 ) ) order by value,description Y AR مجموعة تكاليف التنظيم مجموعة التكاليف D Organisations-Kostengruppe Kostengruppe E Grupo de Costes de Organización Grupo de Costes F Groupe de coûts organisation Groupe de coûts I Gruppo di costi organizzazione Gruppo di costi JA 組織原価グループ 原価グループ KO 조직 원가 그룹 원가 그룹 PTB Grupo de Custos da Organização Grupo de Custos RU Группа затрат для организации Группа затрат S Kostnadsgrupp för organisation Kostnadsgrupp TR Organizasyon Maliyet Grubu Maliyet grubu US Organization Cost Group Cost group ZHS 组织成本组 成本组 10 40 :p_period_id LOV Oracle CST_SRS_PAC_PRD_PROC Y select cpp.pac_period_id id, cpp.period_name value, null description from cst_pac_periods cpp where cpp.legal_entity=:$flex$.cst_srs_pac_ap_le and cpp.cost_type_id=:$flex$.cst_srs_pac_ct_proc and pac_period_id in (select distinct pac_period_id from cst_pac_process_phases where cost_group_id=:$flex$.cst_srs_pac_cg_proc and process_phase=6 and process_status=4) order by value,description Y AR الفترة فترة دورية D Periode Periodische Periode E Período Período Periódico F Période Période I Periodo Periodo per periodo JA 期間 期間別期間 KO 기간 기간별 기간 PTB Período Período (periódico) RU Период Периодический период S Period Periodiseringsperiod TR Dönem Dönemsel dönem US Period Periodic period ZHS 期间 定期期间 11 50 :p_sort_id LOV Oracle CST_SRS_PAC_CSTRPMDD_SORT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_SRS_PAC_CSTRPMDD_SORT' order by meaning SELECT meaning FROM mfg_lookups WHERE lookup_type = 'CST_SRS_PAC_CSTRPMDD_SORT' AND lookup_code = 2 Y AR فرز بواسطة معرف خيار الفرز D Sortieren nach Kennung Sortieroption E Ordenar por Identificador de Opción de Clasificación F Tri par ID option de tri I Ordina per ID opzione di ordinamento JA ソート・キー ソート・オプションID KO 정렬 기준 정렬 옵션 ID PTB Classificar por ID da opção de classificação RU Сортировка Идентификатор параметра сортировки S Sortera efter Id för sorteringsalternativ TR Sıralama Bazı Sıralama senek no US Sort By Sort option ID ZHS 排序依据 排序选项标识 12 60 :p_type_option LOV Oracle INV_SRS_DST_TYPE Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='INV_SRS_DST_TYPE' and enabled_flag= 'Y' order by meaning SELECT MEANING FROM MFG_LOOKUPS WHERE ENABLED_FLAG = 'Y' AND LOOKUP_CODE = 1 AND LOOKUP_TYPE = 'INV_SRS_DST_TYPE' Y AR نوع الحركة خيار نوع الحركة D Transaktionsart Option Transaktionsart E Tipo de Transacción Opción de Tipo de Transacción F Type de mouvement Option type de mouvement I Tipo di transazione Opzione del tipo di transazione JA 取引タイプ 取引タイプ・オプション KO 트랜잭션 유형 트랜잭션 유형 옵션 PTB Tipo de Transação Opção do tipo de transação RU Тип транзакции Параметр типа транзакции S Transaktionstyp Val av transaktionstyp TR İşlem Tipi İşlem tip seçeneği US Transaction Type Transaction type option ZHS 事务处理类型 事务处理类型选项 13 70 :p_acct_lo Char AR حساب من الحساب من D Von Konto Von Konto E De Cuenta De Cuenta F Compte - De Compte - De I Conto - Da Conto - Da JA 勘定科目:自 勘定科目:自 KO 계정: 부터 계정: 부터 PTB Conta - De Conta - de RU Счет с Счет с S Från konto Från konto TR Hesap, İlk İlk Hesap US Account From Account from ZHS 帐户自 帐户自 14 80 :p_acct_hi Char AR إلى إلى حساب D Bis Bis Konto E A A Cuenta F A Compte - A I A Conto - A JA 至 勘定科目:至 KO 까지 계정: 까지 PTB Até Conta - até RU По Счет по S Till Till konto TR Son Son Hesap US To Account to ZHS 至 帐户至 15 90 :p_cat_set_id LOV Oracle CST_SRS_CATEGORY_SET Y select category_set_id id, category_set_name value, description description from mtl_category_sets where mult_item_cat_assign_flag='N' order by value,description SELECT category_set_name FROM mtl_default_sets_view WHERE functional_area_id = 1 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 Conj. Categorias Conjunto de categorias RU Набор категорий Набор категорий S Kategoriuppsättning Kategoriserie TR Kategori Kümesi Kategori kümesi US Category Set Category set ZHS 类别集 类别集 16 100 :p_cat_lo 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 범주: 부터 PTB Categoria - De Categoria - de RU Категория с Категория с S Från kategori Från kategori TR Kategori, İlk Kategori: İlk US Category From Category from ZHS 类别自 类别自 17 110 :p_cat_hi Char AR إلى 2 الفئة إلى D Bis 2 Bis Kategorie E A 2 A Categoría F A 2 Catégorie - A I A 2 Categoria - A JA 至 2 カテゴリ:至 KO 까지 2 범주: 까지 PTB Até 2 Categoria - até RU По 2 Категория по S Till 2 Till kategori TR Son 2 Kategori: Son US To 2 Category to ZHS 至 2 类别至 18 120 :p_item_lo 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 품목: 부터 품목: 부터 PTB Item - De Item - De RU Позиция с Позиция с S Från artikel Från artikel TR Kalem, İlk Kalem: İlk US Item From Item from ZHS 物料自 物料自 19 130 :p_item_hi Char AR إلى 3 الصنف إلى D Bis 3 Bis Artikel E A 3 A Artículo F A 3 Article - A I A 3 Articolo - A JA 至 3 品目:至 KO 까지 3 품목: 까지 PTB Até 3 Item - até RU По 3 Позиция по S Till 3 Till artikel TR Son 3 Kalem: Son US To 3 Item to ZHS 至 3 物料至 20 140 :p_value_lo Number AR القيمة من القيمة من D Von Von Wert E De Valor De Valor F Valeur - De Valeur - De I Valore - Da Valore - Da JA 価額:自 価額:自 KO 값: 부터 값: 부터 PTB Valor - De Valor - De RU Значение с Значение с S Från värde Från värde TR Değer: İlk Değer: İlk US Value From Value from ZHS 值自 值自 21 150 :p_value_hi Number AR إلى 4 القيمة إلى D Bis 4 Bis Wert E A 4 A Valor F A 4 Valeur - A I A 4 Valore - A JA 至 4 価額:至 KO 까지 4 값: 까지 PTB Até 4 Valor - até RU По 4 Значение по S Till 4 Till värde TR Son 4 Değer: Son US To 4 Value to ZHS 至 4 值至 22 160 :p_source_type_id LOV Oracle INV_SRS_SOURCE_TYPE Y select transaction_source_type_id id, transaction_source_type_name value, description description from mtl_txn_source_types order by value,description AR نوع مصدر الحركة نوع مصدر الحركة D Transaktionsherkunftsart Transaktionsherkunftsart E Tipo de Origen de la Transacción Tipo de origen de la transacción F Type origine mouvement Type origine mouvement I Tipo di origine trs Tipo di origine della transazione JA 取引ソース・タイプ 取引ソース・タイプ KO 트랜잭션 출처 유형 트랜잭션 출처 유형 PTB Tipo de Origem da Transação Tipo de origem da transação RU Тип источника транзакции Тип источника транзакции S Typ av transaktionskälla Transaktionskälltyp TR İşlem Kaynak Tipi İşlem kaynak tipi US Transaction Source Type Transaction source type ZHS 事务处理来源类型 事务处理来源类型 23 170 :p_source_lo Char AR مصدر من مصدر من D Von Herkunft Von Herkunft E De Origen De Origen F Origine Origine - De I Origine da Origine - Da JA ソース元 ソース元 KO 출처: From 출처: From PTB Origem - De Origem - de RU Источник Источник с S Källa från Från källa TR İlk Kaynak Kaynak: İlk US Source From Source from ZHS 来源自 来源自 24 180 :p_source_hi Char AR إلى 5 المصدر إلى D Bis 5 Bis Herkunft E A 5 A Origen F A 5 Origine - A I A 5 Origine - A JA 至 5 ソース先 KO 까지 5 출처: To PTB Até 5 Origem - até RU По 5 Источник по S Till 5 Till källa TR Son 5 Kaynak: Son US To 5 Source to ZHS 至 5 来源至 25 190 :p_txn_type_id LOV Oracle INV_SRS_TXN_TYPE Y select transaction_type_id id, transaction_type_name value, description description from mtl_transaction_types where (transaction_source_type_id=:$flex$.inv_srs_source_type) or (transaction_source_type_id=decode(:$flex$.inv_srs_source_type,7,8,:$flex$.inv_srs_source_type) and transaction_type_id=54 ) order by value,description AR نوع الحركة 2 نوع الحركة D Transaktionsart 2 Transaktionsart E Tipo de Transacción 2 Tipo de transacción F Type de mouvement 2 Type de mouvement I Tipo di transazione 2 Tipo di transazione JA 取引タイプ 2 取引タイプ KO 트랜잭션 유형 2 트랜잭션 유형 PTB Tipo de Transação 2 Tipo de transação RU Тип транзакции 2 Тип транзакции S Transaktionstyp 2 Transaktionstyp TR İşlem Tipi 2 İşlem tipi US Transaction Type 2 Transaction type ZHS 事务处理类型 2 事务处理类型 26 200 :p_reason_id LOV Oracle INV_SRS_TXN_REASON_SGL Y select reason_id id, reason_name value, description description from mtl_transaction_reasons order by value,description AR سبب الحركة سبب الحركة D Transaktionsgrund Transaktionsgrund E Motivo de Transacción Motivo de la Transacción F Motif du mouvement Motif du mouvement I Motivo transazione Motivo della transazione JA 取引事由 取引事由 KO 트랜잭션 사유 트랜잭션 사유 PTB Motivo da Transação Motivo da transação RU Основание транзакции Основание транзакции S Transaktionsorsak Transaktionsorsak TR İşlem Nedeni İşlem nedeni US Transaction Reason Transaction reason ZHS 事务处理原因 事务处理原因 27 210 :p_currency_code LOV Oracle CST_SRS_CURRENCY_CODE Y select currency_code id, currency_code value, description description from fnd_currencies_vl where trunc(nvl(start_date_active,sysdate-1))<sysdate and trunc(nvl(end_date_active,sysdate+1))>sysdate order by value,description SELECT gsob.currency_code FROM gl_sets_of_books gsob, cst_le_cost_types clct WHERE clct.cost_type_id = :$flex$.cost_type AND legal_entity = :$flex$.legal_entity AND gsob.set_of_books_id = clct.set_of_books_id Y AR العملة رمز العملة D Währung Währungsschlüssel E Divisa Código de divisa F Devise Code devise I Divisa Codice divisa JA 通貨 通貨コード KO 통화 통화 코드 PTB Moeda Código da moeda RU Валюта Код валюты S Valuta Valutakod TR Para Birimi Para Birimi kodu US Currency Currency code ZHS 币种 币种代码 28 220 :p_exchange_rate LOV Oracle CST_SRS_LE_EXCHANGE_RATE Y select actual_rate id, display_rate value, period description from cst_pac_gl_translation_view cpv,cst_le_cost_types clt where clt.legal_entity=:$flex$.cst_srs_pac_ap_le and clt.cost_type_id=:$flex$.cst_srs_pac_ct_proc and clt.set_of_books_id=cpv.set_of_books_id and cpv.currency_code=:$flex$.cst_srs_currency_code and cpv.inverse=:$flex$.cst_srs_inverse_rate and cpv.rate_type=:$flex$.cst_srs_rate_type order by cpv.period_year desc,cpv.period_num desc Y AR سعر الصرف سعر الصرف D Wechselkurs Wechselkurs E Tipo de Cambio Tipo de Cambio F Taux de change Taux de change I Tasso di cambio Tasso di cambio JA 換算レート 換算レート KO 환율 환율 PTB Taxa de Câmbio Taxa cambial RU Обменный курс Обменный курс S Växelkurs Växelkurs TR Döviz Kuru Döviz kuru US Exchange Rate Exchange rate ZHS 汇率 汇率