ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3E83869E053B46B63588994Y SELECT null C_FLEX_CAT , null C_FLEX_ITEM , mtl.description Item_Description , null C_FLEX_ACC , papf.full_name Buyer , mum.unit_of_measure Unit , msi.list_price_per_unit List_Price , plc1.displayed_field Stock_Item , msi.expense_account Expense_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat_disp', 'INV', 'MCAT', MCA.STRUCTURE_ID, NULL, MCA.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_FLEX_CAT_DISP, 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_item_disp', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_FLEX_ITEM_DISP FROM gl_code_combinations gcc , mtl_units_of_measure mum , po_agents poa , per_all_people_f papf , mtl_system_items msi , mtl_system_items_tl mtl , mtl_categories mca , mtl_item_categories mic , po_lookup_codes plc1 WHERE msi.expense_account = gcc.code_combination_id (+) AND msi.organization_id = :c_organization_id AND msi.primary_uom_code = mum.uom_code AND msi.buyer_id = poa.agent_id (+) AND mtl.inventory_item_id = msi.inventory_item_id AND mtl.organization_id = msi.organization_id AND mtl.language = userenv('LANG') AND trunc(sysdate) between papf.effective_start_date (+) and papf.effective_end_date (+) AND decode(hr_security.view_all ,'Y' , 'TRUE', hr_security.show_record('PER_ALL_PEOPLE_F',papf.person_id (+), papf.person_type_id (+), papf.employee_number (+),papf.applicant_number (+) ,papf.npw_number(+) )) = 'TRUE' AND decode(hr_general.get_xbg_profile,'Y', papf.business_group_id (+), hr_general.get_business_group_id) = papf.business_group_id (+) AND poa.agent_id = papf.person_id (+) AND msi.inventory_item_id = mic.inventory_item_id AND mic.category_set_id = :c_category_set_id AND mic.organization_id = :c_organization_id AND mic.category_id = mca.category_id AND plc1.lookup_type = 'YES/NO' AND plc1.lookup_code = msi.stock_enabled_flag AND ((:P_active_inactive = 'BOTH') OR (:P_active_inactive = 'ACTIVE' AND nvl(msi.purchasing_enabled_flag,'N') = 'Y') OR (:P_active_inactive = 'INACTIVE' AND nvl(msi.purchasing_enabled_flag,'N') = 'N')) --order by &P_FLEX_ITEM order by fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat_disp', 'INV', 'MCAT', MCA.STRUCTURE_ID, NULL, MCA.CATEGORY_ID, 'ALL', 'Y', 'VALUE'),&P_FLEX_ITEM,plc1.displayed_field,mtl.description,papf.full_name,msi.list_price_per_unit,mum.unit_of_measure,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'), 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') PO POXSUMIT_XML AR PO قائمة إجمالي الصنف (بتنسيق XML) Application: المشتريات Source: قائمة إجمالي الصنف (بتنسيق XML) Short Name: POXSUMIT_XML DB package: PO_POXSUMIT_XMLP_PKG D PO Artikel - Übersicht Application: Einkauf Source: Artikel - Übersicht (XML) Short Name: POXSUMIT_XML DB package: PO_POXSUMIT_XMLP_PKG F PO Liste de synthèse des articles Application: Purchasing Source: Liste de synthèse des articles (XML) Short Name: POXSUMIT_XML DB package: PO_POXSUMIT_XMLP_PKG US PO Item Summary Listing Application: Purchasing Source: Item Summary Listing (XML) Short Name: POXSUMIT_XML DB package: PO_POXSUMIT_XMLP_PKG ZHS PO 物料汇总列表 Application: 采购管理系统 Source: 物料汇总列表 (XML) Short Name: POXSUMIT_XML DB package: PO_POXSUMIT_XMLP_PKG BI Publisher &p_flex_item :c_category_set_id :c_organization_id :operating_unit :p_active_inactive :p_active_inactive_disp :p_chart_of_accounts_id :p_conc_request_id :p_flex_acc :p_flex_cat :p_flex_item :p_item_struct_num :p_orderby_cat :p_orderby_item :p_sort :p_sort_displayed :p_struct_num :p_title 1 10 :p_title Char AR العنوان D Titel F Titre US Title ZHS 标题 2 20 :p_active_inactive LOV Oracle PO_SRS_ACTIVE_OPTIONS Y select lookup_code id, displayed_field value, null description from po_lookup_codes where lookup_type='ACTIVE_INACTIVE' order by displayed_field Y AR ساري/غير ساري D Gültig/Ungültig F Activé/Désactivé US Active/Inactive ZHS 有效/无效