ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE7F79D2E0530100007F1FF2 AR Account Number Y Y select hca.account_number value, hp.party_name||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name US 8E2FF36EDE8679D2E0530100007F1FF2 AR Customer Name Y select hp.party_name value, hca.account_number||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name US B2523A13B47B0CC2E0530100007F9B67 CSI Instance Status Y select cis.name value, cis.description from csi_instance_statuses cis order by cis.name US B24FF34728CB70C2E0530100007FE8E9 City Y select distinct initcap(hl.city) value, ftv.territory_short_name description from hz_locations hl, fnd_territories_vl ftv where trim(hl.city) is not null and hl.country=ftv.territory_code(+) and (:$flex$.country is null or xxen_util.contains(:$flex$.country,ftv.territory_short_name)='Y') order by value US 8E2FF36EDE8379D2E0530100007F1FF2 Country Y select ftv.territory_short_name value, ftv.territory_code||': '||ftv.description description from fnd_territories_vl ftv order by ftv.territory_short_name US 8E2FF36EDEF379D2E0530100007F1FF2 INV Item (master) Y Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where msiv.organization_id=( select max(mp.master_organization_id) master_organization_id from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or fnd_profile.value('MFG_ORGANIZATION_ID') is null and mp.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) ) order by msiv.concatenated_segments US Any item from item master org, including non costing enabled B24731089D434781E0530100007FDA17 select hca.account_number, hp.party_name, msiv.concatenated_segments item, msiv.description item_description, xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) user_item_type, cii.instance_number, cii.serial_number, cis.name status, xxen_util.meaning(cii.instance_type_code,'CSI_INST_TYPE_CODE',542) instance_type, cii.quantity, cii.unit_of_measure, cii.inventory_revision, csv.name system, ooha.order_number, ooha.cust_po_number, ftv.territory_short_name country, hl.city, hl.state, hl.address1||nvl2(hl.address1,nvl2(hl.address2,', ',null),null)||hl.address2 install_address1, hl.address3||nvl2(hl.address3,nvl2(hl.address4,', ',null),null)||hl.address4 install_address2, hl.postal_code from csi_item_instances cii, csi_instance_statuses cis, mtl_system_items_vl msiv, hz_cust_accounts hca, hz_parties hp, hz_party_sites hps, hz_locations hl, fnd_territories_vl ftv, csi_systems_v csv, oe_order_lines_all oola, oe_order_headers_all ooha where 1=1 and cii.instance_status_id=cis.instance_status_id and cii.inventory_item_id=msiv.inventory_item_id(+) and cii.last_vld_organization_id=msiv.organization_id(+) and cii.owner_party_account_id=hca.cust_account_id(+) and hca.party_id=hp.party_id(+) and cii.install_location_id=hps.party_site_id(+) and hps.location_id=hl.location_id(+) and hl.country=ftv.territory_code(+) and cii.system_id=csv.system_id(+) and cii.last_oe_order_line_id=oola.line_id(+) and oola.header_id=ooha.header_id(+) order by hca.account_number, msiv.concatenated_segments, cii.instance_number Y CSI AR CSI Customer Products Summary Application: قاعدة التركيبات Source: CSI: تقرير إجمالي منتجات العميل (XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG D CSI Customer Products Summary Application: Install Base Source: CSI: Kundenprodukte - Übersicht (XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG E CSI Customer Products Summary Application: Install Base Source: CSI: Resumen de Productos del Cliente (XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG F CSI Customer Products Summary Application: Install Base Source: CSI : Etat Synthèse des produits client (XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG I CSI Customer Products Summary Application: Install Base Source: CSI: Rapporto sintetico Prodotti cliente (XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG JA CSI Customer Products Summary Application: Install Base Source: CSI: 顧客製品要約レポート(XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG KO CSI Customer Products Summary Application: Install Base Source: CSI: 고객 제품 요약 보고서(XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG PTB CSI Customer Products Summary Application: Base Instalada Source: CSI: Relatório Resumido de Produtos do Cliente (XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG RU CSI Customer Products Summary Application: База установок Source: CSI: сводный отчет о продуктах клиента (XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG S CSI Customer Products Summary Application: Install Base Source: CSI: Kundprodukter - översiktsrapport (XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG TR CSI Customer Products Summary Application: Müşteri Ürünleri Yönetimi Source: CSI: Müşteri Ürünleri Özet Raporu (XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG US CSI Customer Products Summary Imported Oracle standard Installed Base Customer Products Summary report Source: CSI: Customer Products Summary Report (XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG ZHS CSI Customer Products Summary Application: 产品安装信息库 Source: CSI：客户产品汇总报表 (XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG BI Publisher Enginatics 1=1 1 10 1=1 hca.account_number=:account_number LOV AR Account Number 8E2FF36EDE7F79D2E0530100007F1FF2 Y Y select hca.account_number value, hp.party_name||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name US Account Number 2 20 1=1 upper(hp.party_name) like upper(:customer_name) LOV AR Customer Name 8E2FF36EDE8679D2E0530100007F1FF2 Y select hp.party_name value, hca.account_number||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name US Customer Name 3 30 1=1 cii.instance_number=:instance_number Char US Instance Number 4 40 1=1 msiv.concatenated_segments=:item LOV INV Item (master) 8E2FF36EDEF379D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where msiv.organization_id=( select max(mp.master_organization_id) master_organization_id from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or fnd_profile.value('MFG_ORGANIZATION_ID') is null and mp.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) ) order by msiv.concatenated_segments US Item 5 50 1=1 cis.name=:status LOV CSI Instance Status B2523A13B47B0CC2E0530100007F9B67 Y select cis.name value, cis.description from csi_instance_statuses cis order by cis.name US Status Status 6 60 1=1 upper(hl.city) like upper(:city) LOV City B24FF34728CB70C2E0530100007FE8E9 Y select distinct initcap(hl.city) value, ftv.territory_short_name description from hz_locations hl, fnd_territories_vl ftv where trim(hl.city) is not null and hl.country=ftv.territory_code(+) and (:$flex$.country is null or xxen_util.contains(:$flex$.country,ftv.territory_short_name)='Y') order by value US City 7 70 1=1 ftv.territory_short_name=:country LOV Country 8E2FF36EDE8379D2E0530100007F1FF2 Y select ftv.territory_short_name value, ftv.territory_code||': '||ftv.description description from fnd_territories_vl ftv order by ftv.territory_short_name US Country 8 80 1=1 cii.creation_date>=:creation_date_from Date US Creation Date From 9 90 1=1 cii.creation_date<:creation_date_to+1 Date US Creation Date To :$flex$.country Country City