ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0683869E053B46B63588994Y Select Customer_Item_Id, Master_Organization_Id, Customer_Name, Customer_Number, Customer_Category_Code, Concatenated_Address, Customer_Item_Number, Customer_Item_Desc, Item_Definition_Level, Item_Level, Inventory_Item_Id, Concatenated_segments, Item_Description, Rank, Decode(Inactive_Flag,'N','Yes','Y','No'), Customer_Category From MTL_CUSTOMER_ITEM_XREFS_V A Where A.Master_Organization_Id = :C_MASTER_ORG_ID &P_WHERE Order By Customer_Name, Item_Definition_Level, Customer_Item_Number, Rank INV INVIRCXR_XML 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 Application: Inventory Source: Customer Item Cross References Report (XML) Short Name: INVIRCXR_XML DB package: INV_INVIRCXR_XMLP_PKG ZHS INV 客户物料交叉参考报表 Application: 库存管理系统 Source: 客户物料交叉参考报表 (XML) Short Name: INVIRCXR_XML DB package: INV_INVIRCXR_XMLP_PKG BI Publisher &p_where :c_master_org_id :p_conc_request_id :p_customer_address :p_customer_address_category :p_customer_from :p_customer_item_nbr_from :p_customer_item_nbr_to :p_item_level :p_list_lowest_rank :p_org_id :p_where 1 10 :p_org_id Number select fnd_profile.value('MFG_ORGANIZATION_ID') from dual Y AR التنظيم D Organisation F Organisation US Organization ZHS 组织 2 20 :p_customer_from LOV Oracle INV_SRS_CUSTOMER Y Y select cust.cust_account_id id, cust_party.party_name value, null description from hz_cust_accounts cust,hz_parties cust_party where exists (select 'X' from mtl_customer_items mci where mci.customer_id=cust.cust_account_id) and cust.party_id=cust_party.party_id order by cust_party.party_name AR العميل D Kunde F Client US Customer ZHS 客户 3 30 :p_customer_address_category LOV Oracle INV_SRS_CUSTOMER_ADDRESS_CATEGORY Y select mci.customer_id id, mci.customer_category_code value, mci.customer_category description from mtl_customer_items_all_v mci where mci.customer_id=:$flex$.inv_srs_customer and mci.item_definition_level=2 order by customer_category AR فئة العنوان D Adressenkategorie F Catégorie d'adresse US Address Category ZHS 地址类别 4 40 :p_customer_address LOV Oracle INV_SRS_CUSTOMER_ADDRESS Y Y select address_id id, concatenated_address value, null description from ar_addresses_v arv where exists (select 'X' from mtl_customer_items mci where mci.address_id=arv.address_id and arv.customer_id=:$flex$.inv_srs_customer.id) order by concatenated_address AR العنوان D Adresse F Adresse US Address ZHS 地址 5 50 :p_item_level LOV Oracle INV_SRS_ITEM_LEVEL Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='INV_ITEM_DEFINITION_LEVEL' and enabled_flag='Y' order by lookup_code AR المستوى D Ebene F Niveau US Level ZHS 层 6 60 :p_customer_item_nbr_from LOV Oracle INV_SRS_CUSTOMER_ITEM_NBR Y Y select customer_item_number id, customer_item_number value, customer_item_desc description from mtl_customer_items_all_v order by customer_item_number AR أصناف العملاء من D Von Kundenartikel F Articles client - De US Customer Items From ZHS 客户物料自 7 70 :p_customer_item_nbr_to LOV Oracle INV_SRS_CUSTOMER_ITEM_NBR Y Y select customer_item_number id, customer_item_number value, customer_item_desc description from mtl_customer_items_all_v order by customer_item_number AR إلى D Bis F A US To ZHS 至 8 80 :p_pref_rank_y_n LOV Oracle INV_SRS_VAL_Y_N Y select lookup_code id, lookup_code value, meaning description from fnd_lookups where lookup_type='YES_NO' order by value,description N AR الأصناف المرتبة أولاً فقط D Nur Artikel der ersten Rangordnung F Articles premier rang seulement US First Ranked Items Only ZHS 仅限于第一等级物料