ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 31BBF4BFEC7D0AD9E06362FB090507AE SELECT hca.account_number , hzp.party_name , hl.city install_location , (hl.address1 || DECODE( hl.address1, '', '', DECODE(hl.address2, '', '', CHR(44) || CHR(32))) || hl.address2) install_address1 , (hl.address3 || DECODE( hl.address3, '', '', DECODE( hl.address4, '', '', CHR(44)||CHR(32))) || hl.address4) install_address2 , SUBSTR( hl.city || DECODE( hl.city, '', '', DECODE(hl.state|| hl.country || hl.postal_code, '', '', CHR(44) || CHR(32))) || hl.state ||CHR(32)||CHR(32) || hl.postal_code|| CHR(32) || CHR (32) || hl.country, 1, 220) install_address3 , &P_FLEX_ITEM_CODE C_FLEX_ITEM_CODE , ccpa.serial_number , ccpa.unit_of_measure , ccpa.quantity , ccps.name status , msi.description , ccpa.instance_number , ccpa.inventory_revision , cs.name system , oh.order_number , oh.cust_po_number, 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 csi_item_instances ccpa , hz_cust_accounts hca , hz_parties hzp , hz_party_sites hps , hz_locations hl , csi_instance_statuses ccps, mtl_system_items msi , csi_systems_v cs , csi_lookups cl1 , oe_order_headers_all oh, oe_order_lines_all ol WHERE ccpa.inventory_item_id = msi.inventory_item_id and msi.organization_id = :p_organization_id and ccpa.owner_party_account_id = hca.cust_account_id and hca.party_id = hzp.party_id and ccpa.install_location_id = hps.party_site_id (+) and hps.location_id = hl.location_id (+) and ccpa.instance_status_id = ccps.instance_status_id and ccpa.system_id = cs.system_id (+) and ccpa.instance_type_code = cl1.lookup_code (+) and cl1.lookup_type (+) = 'CSI_INST_TYPE_CODE' and ccpa.last_oe_order_line_id = ol.line_id (+) and ol.header_id = oh.header_id (+) &LP_CUSTOMER_RANGE &LP_ITEM_RANGE &LP_INSTALL_LOCATION &LP_CP_STATUS and &P_ITEM_WHERE ORDER BY 1 ASC,2 ASC,3 ASC,4 ASC,5 ASC,6 ASC Y CSI CSICPREP_XML Y AR CSI تقرير إجمالي منتجات العميل (3) Imported from BI Publisher Description: تقرير إجمالي منتجات العميل Application: قاعدة التركيبات Source: CSI: تقرير إجمالي منتجات العميل (XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG D CSI Kundenprodukte - Übersicht (3) Imported from BI Publisher Description: Auswertung "Kundenprodukte - Übersicht" Application: Installed Base Source: CSI: Kundenprodukte - Übersicht (XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG E CSI Resumen de Productos del Cliente (3) Imported from BI Publisher Description: Informe Resumen de Productos del Cliente Application: Installed Base Source: CSI: Resumen de Productos del Cliente (XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG F CSI Etat Synthèse des produits client (3) Imported from BI Publisher Description: Etat Synthèse des produits client Application: Install Base Source: CSI : Etat Synthèse des produits client (XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG I CSI Rapporto sintetico Prodotti cliente (3) Imported from BI Publisher Description: Rapporto Sintetico prodotti cliente Application: Base installata Source: CSI: Rapporto sintetico Prodotti cliente (XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG JA CSI 顧客製品要約レポート (3) Imported from BI Publisher Description: 顧客製品要約レポート Application: Installed Base Source: CSI: 顧客製品要約レポート(XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG KO CSI 고객 제품 요약 보고서 (3) Imported from BI Publisher Description: 고객 제품 요약 보고서 Application: Installed Base Source: CSI: 고객 제품 요약 보고서(XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG PTB CSI Relatório Resumido de Produtos do Cliente (3) Imported from BI Publisher Description: Relatório Sumariado de Produtos do Cliente 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 сводный отчет о продуктах клиента (3) Imported from BI Publisher Description: Сводный отчет о продуктах клиента Application: База установок Source: CSI: сводный отчет о продуктах клиента (XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG S CSI Kundprodukter - översiktsrapport (3) Imported from BI Publisher Description: Kundprodukter - översiktsrapport Application: Installerad bas Source: CSI: Kundprodukter - översiktsrapport (XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG TR CSI Müşteri Ürünleri Özet Raporu (3) Imported from BI Publisher Description: Müşteri Ürünleri Özet Raporu Application: Müşteri Ürünleri Source: CSI: Müşteri Ürünleri Özet Raporu (XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG US CSI Customer Products Summary (4) Imported from BI Publisher Description: Customer Products Summary Report Application: Installed Base Source: CSI: Customer Products Summary Report (XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG ZHS CSI CSI：客户产品汇总报表 (3) Imported from BI Publisher Description: 客户产品汇总报表 Application: 产品安装信息库 Source: CSI：客户产品汇总报表 (XML) Short Name: CSICPREP_XML DB package: CSI_CSICPREP_XMLP_PKG BI Publisher 1=1 :lp_cp_status :lp_customer_range :lp_install_location :lp_item_range :p_conc_request_id :p_cp_status :p_customer_number_high :p_customer_number_low :p_flex_item_code :p_install_location :p_item_high :p_item_lo :p_item_struct_num :p_item_where :p_order_by :p_organization_id :p_sob_id :rp_company_name :rp_report_name 1 -10 :debugflag Char N US DebugFlag DebugFlag 2 10 :p_customer_number_low LOV Oracle CSI_CUSTOMER_NUMBER Y select customer_number id, customer_number value, party_name description from csi_srs_party_name_v order by customer_number US From Customer Number Customer Number Value(Low) 3 20 :p_customer_number_high LOV Oracle CSI_CUSTOMER_NUMBER Y select customer_number id, customer_number value, party_name description from csi_srs_party_name_v order by customer_number US To Customer Number Customer Number Value(High) 4 30 :p_item_lo Char US From Item Item(Low) 5 40 :p_item_high Char US To Item Item(High) 6 50 :p_install_location LOV Oracle CSI_SRS_INSTALL_LOCATION Y select hcsua.location id, hcsua.location value, null description from hz_cust_acct_sites_all hcasa,hz_cust_site_uses_all hcsua,hz_cust_accounts_all hcaa,hz_locations hl,hz_party_sites hps,ar_lookups al where hcaa.cust_account_id=hcasa.cust_account_id and hcasa.cust_acct_site_id=hcsua.cust_acct_site_id and hcasa.party_site_id=hps.party_site_id and hps.location_id=hl.location_id and hcsua.site_use_code=al.lookup_code and hcaa.status='A' and hcasa.status='A' and hcsua.status='A' and al.lookup_type='SITE_USE_CODE' order by value,description US Installed At Install Location 7 60 :p_cp_status LOV Oracle CSI_SRS_CP_STATUS Y select cs.name id, cs.name value, null description from csi_instance_statuses cs order by cs.name US Status Status