ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 3CD8BD80BA9E4AFAB5CEE3DD114442B0Y select hp.party_name customer_name, hca.account_number customer_number, xxen_util.meaning(mci.item_definition_level,'INV_ITEM_DEFINITION_LEVEL',700) definition_level, xxen_util.meaning(mci.customer_category_code,'ADDRESS_CATEGORY',222,'Y') address_category, hps.party_site_number site_number, hz_format_pub.format_address(hps.location_id,null,null,' , ') site_address, mci.customer_item_number customer_item, mci.customer_item_desc customer_item_description, mcc.commodity_code, mci_m.customer_item_number model_customer_item, msiv_mc.concatenated_segments master_container, msiv_dc.concatenated_segments detail_container, mci.min_fill_percentage, xxen_util.yes(mci.dep_plan_required_flag) dependent_planning_required, xxen_util.yes(mci.dep_plan_prior_bld_flag) dependent_planning_prior_build, mci.demand_tolerance_positive, mci.demand_tolerance_negative, xxen_util.yes(decode(mci.inactive_flag,'N','Y')) customer_item_active, mp.organization_code master_organization, msiv.concatenated_segments item, msiv.description item_description, mcix.preference_number rank, xxen_util.yes(decode(mcix.inactive_flag,'N','Y')) active, xxen_util.user_name(mcix.created_by) created_by, xxen_util.client_time(mcix.creation_date) creation_date, xxen_util.user_name(mcix.last_updated_by) last_updated_by, xxen_util.client_time(mcix.last_update_date) last_update_date from mtl_customer_items mci, hz_cust_accounts hca, hz_parties hp, hz_cust_acct_sites_all hcasa, hz_party_sites hps, mtl_commodity_codes mcc, mtl_customer_items mci_m, mtl_system_items_vl msiv_mc, mtl_system_items_vl msiv_dc, mtl_customer_item_xrefs mcix, mtl_parameters mp, mtl_system_items_vl msiv where 1=1 and mci.customer_id=hca.cust_account_id and hca.party_id=hp.party_id and mci.address_id=hcasa.cust_acct_site_id(+) and hcasa.party_site_id=hps.party_site_id(+) and mci.commodity_code_id=mcc.commodity_code_id(+) and mci.model_customer_item_id=mci_m.customer_item_id(+) and mci.master_container_item_id=msiv_mc.inventory_item_id(+) and mci.container_item_org_id=msiv_mc.organization_id(+) and mci.detail_container_item_id=msiv_dc.inventory_item_id(+) and mci.container_item_org_id=msiv_dc.organization_id(+) and mci.customer_item_id=mcix.customer_item_id(+) and mcix.master_organization_id=mp.organization_id(+) and mcix.inventory_item_id=msiv.inventory_item_id(+) and mcix.master_organization_id=msiv.organization_id(+) order by hp.party_name, mci.item_definition_level, mci.customer_item_number, mcix.preference_number Initial version AR INV تقرير الإسنادات المتقاطعة لأصناف العملاء (بتنسيق XML) Application: المخازن Source: تقرير الإسنادات المتقاطعة لأصناف العملاء (بتنسيق XML) Short Name: INVIRCXR_XML DB package: INV_INVIRCXR_XMLP_PKG D INV Kundenartikel - Querverweise Application: Lager Source: Kundenartikel - Querverweise (XML) Short Name: INVIRCXR_XML DB package: INV_INVIRCXR_XMLP_PKG F INV Etat des références croisées d'articles client Application: Inventory Source: Etat des références croisées d'articles client (XML) Short Name: INVIRCXR_XML DB package: INV_INVIRCXR_XMLP_PKG US INV Customer Item Cross References Customer item cross references to the item master, as maintained in the Customer Item Cross References form. One row per cross reference. A customer item without a cross reference shows with blank item columns. Address category and site columns are populated for customer items defined at address category or address level. ZHS INV 客户物料交叉参考报表 Application: 库存管理系统 Source: 客户物料交叉参考报表 (XML) Short Name: INVIRCXR_XML DB package: INV_INVIRCXR_XMLP_PKG Enginatics 1=1 1 10 1=1 hp.party_name=: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 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 union all select hca2.cust_account_id from hz_cust_accounts hca2 where :$flex$.operating_unit is null ) order by hp.party_name AR التنظيم D Organisation F Organisation US Customer Name ZHS 组织 2 20 1=1 mci.customer_item_number=:customer_item LOV custom Y Y select mci.customer_item_number value, max(mci.customer_item_desc) description from mtl_customer_items mci, hz_cust_accounts hca, hz_parties hp where (:$flex$.customer_name is null or xxen_util.contains(:$flex$.customer_name,hp.party_name)='Y') and mci.customer_id=hca.cust_account_id and hca.party_id=hp.party_id group by mci.customer_item_number order by mci.customer_item_number AR العميل D Kunde F Client US Customer Item ZHS 客户 3 30 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 AR فئة العنوان D Adressenkategorie F Catégorie d'adresse US Item ZHS 地址类别 4 40 1=1 mci.item_definition_level=xxen_util.lookup_code(:definition_level,'INV_ITEM_DEFINITION_LEVEL',700) LOV custom Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='INV_ITEM_DEFINITION_LEVEL' and flvv.view_application_id=700 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.lookup_code AR العنوان D Adresse F Adresse US Definition Level ZHS 地址