ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EEB43869E053B46B63588994 SELECT SUB.PARtY_NAME "PrimaryCustomer", sub.party_number "PrimaryRegistryId", lrt.meaning "RelationshipType", lrc.MEANING || ' / ' || lrcb.MEANING "RelationshipPhrase", obj.party_name "RelatedCustomerName", obj.PARTY_NUMBER "RelatedRegistryId", rel.START_DATE "From Date", rel.end_date "To Date", to_char(rel.START_DATE,'DD-MON-YY') FROM_DATE_DISP, to_char(rel.end_date,'DD-MON-YY') TO_DATE_DISP --From Date", -- rel.end_date "To Date" FROM hz_relationships rel ,hz_parties sub ,hz_relationship_types rt ,hz_parties obj ,AR_LOOKUPS lrt ,ar_lookups lrc ,ar_lookups lrcb WHERE rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES' AND rel.SUBJECT_TYPE = 'ORGANIZATION' AND rel.subject_id = sub.party_id AND rel.object_id = obj.party_id AND lrt.lookup_type = 'HZ_RELATIONSHIP_TYPE' AND lrt.lookup_code = rel.relationship_type AND lrc.lookup_type = 'PARTY_RELATIONS_TYPE' AND lrc.LOOKUP_code = rel.relationship_code AND rt.relationship_type = rel.relationship_type AND rt.SUBJECT_TYPE = rel.subject_type AND rt.OBJECT_TYPE = rel.object_type AND rt.FORWARD_REL_CODE = rel.RELATIONSHIP_CODE AND rt.BACKWARD_REL_CODE = lrcb.lookup_code AND lrcb.lookup_type = 'PARTY_RELATIONS_TYPE' AND rt.hierarchical_flag = 'Y' AND exists ( SELECT 1 FROM hz_cust_accounts subacc WHERE subacc.party_id = rel.subject_id ) AND exists ( SELECT 1 FROM hz_cust_accounts objacc WHERE objacc.party_id = rel.object_id ) &lp_customer_name &lp_registry_id &lp_rel_type --ORDER BY 1 ASC,2 ASC,3 ASC , sub.party_number , rel.relationship_type , rel.relationship_code order by 1,2,3,4,5,6,7,8 Y AR ARXCURLL_XML AR AR قائمة علاقات العملاء (بتنسيق XML) Application: المقبوضات Source: قائمة علاقات العملاء (بتنسيق XML) Short Name: ARXCURLL_XML DB package: AR_ARXCURLL_XMLP_PKG D AR Kunden - Beziehungen Application: Debitoren Source: Kunden - Beziehungen (XML) Short Name: ARXCURLL_XML DB package: AR_ARXCURLL_XMLP_PKG F AR Liste des relations entre clients Application: Receivables Source: Liste des relations entre clients (XML) Short Name: ARXCURLL_XML DB package: AR_ARXCURLL_XMLP_PKG US AR Customer Relationships Listing Application: Receivables Source: Customer Relationships Listing (XML) Short Name: ARXCURLL_XML DB package: AR_ARXCURLL_XMLP_PKG ZHS AR 客户关系列表 Application: 应收帐款 Source: 客户关系列表 (XML) Short Name: ARXCURLL_XML DB package: AR_ARXCURLL_XMLP_PKG BI Publisher &lp_customer_name &lp_registry_id &lp_rel_type :acct_bal_aprompt :lp_balancing_segment_high :lp_balancing_segment_low :lp_customer_name :lp_customer_number :lp_registry_id :lp_rel_type :operating_unit :p_coaid :p_conc_request_id :p_customer_name_high :p_customer_name_low :p_customer_number_high :p_customer_number_low :p_end_currency_code :p_end_date :p_in_balancing_segment_high :p_in_balancing_segment_low :p_registry_id_high :p_registry_id_low :p_rel_type_high :p_rel_type_low :p_set_of_books_id :p_start_currency_code :p_start_date :rp_company_name :rp_data_found :rp_report_name :rp_sub_title 1 10 :p_customer_name_low LOV Oracle AR_CUSTOMER_NAME Y Y select party.party_name id, party.party_name value, null description from hz_cust_accounts cu,hz_parties party where cu.party_id=party.party_id and cu.cust_account_id in (select cu2.cust_account_id from hz_cust_accounts cu2,hz_parties party2 where cu2.party_id=party2.party_id and party2.party_name= party.party_name) order by party.party_name AR اسم العميل من D Von Kundenname F Nom de client - De US Customer Name Low ZHS 客户名称下限 2 20 :p_customer_name_high LOV Oracle AR_CUSTOMER_NAME Y Y select party.party_name id, party.party_name value, null description from hz_cust_accounts cu,hz_parties party where cu.party_id=party.party_id and cu.cust_account_id in (select cu2.cust_account_id from hz_cust_accounts cu2,hz_parties party2 where cu2.party_id=party2.party_id and party2.party_name= party.party_name) order by party.party_name AR اسم العميل إلى D Bis Kundenname F Nom de client - A US Customer Name High ZHS 客户名称上限 3 30 :p_customer_number_low LOV Oracle AR_CUSTOMER_NUMBER Y Y select cust.account_number id, cust.account_number value, null description from hz_cust_accounts cust,hz_parties party where cust.party_id=party.party_id order by cust.account_number AR رقم الحساب من D Von Kontonummer F Numéro de compte - De US Account Number Low ZHS 帐号下限 4 40 :p_customer_number_high LOV Oracle AR_CUSTOMER_NUMBER Y Y select cust.account_number id, cust.account_number value, null description from hz_cust_accounts cust,hz_parties party where cust.party_id=party.party_id order by cust.account_number AR رقم الحساب إلى D Bis Kontonummer F Numéro de compte - A US Account Number High ZHS 帐号上限 5 50 :p_registry_id_low LOV Oracle AR_REGISTRY_ID Y Y select party_number id, party_number value, null description from hz_parties where party_type='ORGANIZATION' and exists (select 1 from hz_cust_accounts acc where acc.party_id=hz_parties.party_id) order by party_number AR معرف التسجيل من D Von Registry-Kennung F ID registre - De US Registry ID Low ZHS 注册标识下限 6 60 :p_registry_id_high LOV Oracle AR_REGISTRY_ID Y Y select party_number id, party_number value, null description from hz_parties where party_type='ORGANIZATION' and exists (select 1 from hz_cust_accounts acc where acc.party_id=hz_parties.party_id) order by party_number AR معرف التسجيل إلى D Bis Registry-Kennung F ID registre - A US Registry ID High ZHS 注册标识上限 7 70 :p_rel_type_low LOV Oracle AR_REL_TYPE Y select lu.meaning id, lu.meaning value, null description from hz_relationship_types rt,ar_lookups lu where rt.relationship_type=lu.lookup_code and lu.lookup_type='HZ_RELATIONSHIP_TYPE' and rt.relationship_type_id in ( select max(a.relationship_type_id) from hz_relationship_types a where a.object_type='ORGANIZATION' and a.subject_type='ORGANIZATION' group by a.relationship_type) order by lu.meaning AR نوع العلاقة من D Von Beziehungsart F Type de relation - De US Relationship Type Low ZHS 关系类型下限 8 80 :p_rel_type_high LOV Oracle AR_REL_TYPE Y select lu.meaning id, lu.meaning value, null description from hz_relationship_types rt,ar_lookups lu where rt.relationship_type=lu.lookup_code and lu.lookup_type='HZ_RELATIONSHIP_TYPE' and rt.relationship_type_id in ( select max(a.relationship_type_id) from hz_relationship_types a where a.object_type='ORGANIZATION' and a.subject_type='ORGANIZATION' group by a.relationship_type) order by lu.meaning AR نوع العلاقة إلى D Bis Beziehungsart F Type de relation - A US Relationship Type High ZHS 关系类型上限