ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF403869E053B46B63588994 select trunc(pawo.write_off_gl_date) Write_off_date , null C_FLEX_ITEM , null C_FLEX_ACC , pawo.po_num PO_Number , pawo.po_line_num PO_line_num , pawo.transaction_source_code Source_code , plc.displayed_field Source , pawo.transaction_organization_id Organization_id , ood.organization_code Organization , to_char(pawo.transaction_date,'DD-MON-YY') Document_date , nvl(pawo.invoice_num, pawo.receipt_num) Document_number , pawo.invoice_line_num Document_line , round(pawo.transaction_quantity,:P_QTY_PRECISION) Quantity , pawo.transaction_unit_price Unit_price , pawo.transaction_amount C_AMOUNT_Amount , plc1.displayed_field Destination , pawo.accrual_account_id Account , mtr.reason_name Reason_code , pawo.comments Comments , decode(pawo.write_off_code, 'REVERSE WRITE OFF', 'Yes', 'WRITE OFF', 'No') write_off_reversal, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_acc_disp', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEX_ACC_DISP, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_acc_sort', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') C_FLEX_ACC_SORT, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item_disp', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_FLEX_ITEM_DISP from cst_pac_accrual_write_offs pawo , mtl_transaction_reasons mtr , mtl_system_items msi , gl_code_combinations gcc , po_lines_all pol , org_organization_definitions ood , po_lookup_codes plc , po_lookup_codes plc1 where pawo.legal_entity_id = :P_LEGAL_ENTITY and pawo.cost_type_id = :P_COST_TYPE and pawo.cost_group_id = :P_COST_GROUP and pawo.reason_id = mtr.reason_id (+) and msi.inventory_item_id (+) = pol.item_id and msi.organization_id = pawo.transaction_organization_id and gcc.code_combination_id = pawo.accrual_account_id and pol.po_line_id (+) = pawo.po_line_id and pawo.period_id = :P_PERIOD_ID and nvl(mtr.reason_name,'A') = nvl(:P_reason_code, nvl(mtr.reason_name,'A')) and ood.legal_entity = :P_LEGAL_ENTITY and ood.organization_id = pawo.transaction_organization_id and plc.lookup_code = pawo.transaction_source_code and plc.lookup_type = 'ACCRUAL TRX SOURCE' and plc1.lookup_code(+) = pawo.destination_type_code and plc1.lookup_type(+) = 'DESTINATION TYPE' ORDER BY fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_acc_disp', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') , plc1.displayed_field , :P_ORDERBY_ITEM , pawo.po_num , pawo.po_line_num , decode(plc.displayed_field, 'PO', 1, 'INV', 2, 'WIP', 3, 'AP', 4, 5) , pawo.transaction_date Y BOM CSTRPWRO_XML AR CST تقرير حذف الاستحقاقات الدورية (تنسيق XML) Application: شجرة المنتجات Source: تقرير حذف الاستحقاقات الدورية (تنسيق XML) Short Name: CSTRPWRO_XML DB package: BOM_CSTRPWRO_XMLP_PKG D CST Wareneingang - periodische Rückstellung auflösen Application: Produktionsdaten Source: Wareneingang - periodische Rückstellung auflösen (XML) Short Name: CSTRPWRO_XML DB package: BOM_CSTRPWRO_XMLP_PKG F CST Etat d'annulation des provisions périodiques Application: Bills of Material Source: Etat d'annulation des provisions périodiques (XML) Short Name: CSTRPWRO_XML DB package: BOM_CSTRPWRO_XMLP_PKG US CST Periodic Accrual Writeoff Application: Bills of Material Source: Periodic Accrual Writeoff Report (XML) Short Name: CSTRPWRO_XML DB package: BOM_CSTRPWRO_XMLP_PKG ZHS CST 定期应计冲销报表 Application: 物料清单管理系统 Source: 定期应计冲销报表 (XML) Short Name: CSTRPWRO_XML DB package: BOM_CSTRPWRO_XMLP_PKG BI Publisher :cost_group_name :cost_type_name :from_date :legal_entity_name :operating_unit :p_chart_of_accounts_id :p_conc_request_id :p_cost_group :p_cost_type :p_flex_acc :p_flex_item :p_legal_entity :p_orderby_item :p_organization_id :p_period_id :p_print_comments :p_qty_precision :p_reason_code :p_struct_num :p_title :p_write_off_date_from :p_write_off_date_to :period_name :qty_precision :to_date 1 10 :p_legal_entity 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 F Entité juridique US Legal Entity ZHS 法人主体 2 20 :p_cost_type 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 F Type de coût US Cost Type ZHS 成本类型 3 30 :p_cost_group 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 Kostengruppe F Groupe de coûts US Cost Group ZHS 成本组 4 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 F Période US Period ZHS 期间 5 50 :p_reason_code LOV Oracle PO_SRS_MTL_TRANSACTION_REASON Y select reason_name id, reason_name value, description description from mtl_transaction_reasons order by reason_name AR رمز السبب D Schlüssel Grund F Code motif US Reason Code ZHS 原因代码 6 60 :p_title Char AR العنوان D Titel F Titre US Title ZHS 标题 7 70 :p_print_comments LOV Oracle AP_SRS_YES_NO_OPT Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description AR طباعة الملاحظات D Bemerkungen drucken F Imprimer les commentaires US Print Comments ZHS 打印备注 :$flex$.cst_srs_pac_ap_le Legal Entity Cost Group :$flex$.cst_srs_pac_ap_le Legal Entity Cost Type :$flex$.cst_srs_pac_ap_le Legal Entity Period :$flex$.cst_srs_pac_cg_proc Cost Group Period :$flex$.cst_srs_pac_ct_proc Cost Type Cost Group :$flex$.cst_srs_pac_ct_proc Cost Type Period